|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2014
<br />July-14 2014
<br />CURRENT MONTH YEAR-TO-DATE
<br />!CASH AND TEMPORARY INVESTMENTS 1
<br />BEGINNING BALANCE $ 48,019,226.37 $ 47,755,155.12
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Credit Cards
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds
<br />400,302.74
<br />1,866,023.07
<br />74,787.33
<br />80,689.18
<br />48,838.93
<br />3,564,713.08
<br />5,474,842.07
<br />1,659,245.87
<br />345,769.79
<br />428,253.65
<br />TOTAL CASH INFLOW $ 2,470,641.25 $ 11,472,824.46
<br />TOTAL CASH AVAILABLE $ 50,489,867.62 $ 59,227,979.58
<br />CASH OUTFLOWS:
<br />Prepaid Checks 483,300.22 $ 3,836,799.63
<br />Bills Lists 214,974.35 2,499,764.30
<br />Pay Estimates - 627,889.89
<br />Credit Cards 1,322.90 10,119.10
<br />Payroll - Net 309,864.02 1,992,065.99
<br />Flex Reimbursement 2,922.05 31,026.27
<br />Void Checks/Dormant Checks Paid - (181,716.74)
<br />Debt Service 57,492.50 991,963.76
<br />Miscellaneous [Bank Charges; etc.] 729.89 805.69
<br />TOTAL CASH OUTFLOW
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />MEMO - NET 2014 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY
<br />$ 1,070,605.93 $ 9,808,717.89
<br />$ 49,419,261.69 ( I $ 49,419,261.69 I
<br />1,400,035.32 1,664,106.57
<br />BEGINNING BALANCE $ 41,512,393.40 $ 42,140,323.39
<br />Purchases 2,876,000.00 8,616,000.00
<br />Maturities/Sales (510,279.90) (6,878,209.89)
<br />ENDING BALANCE
<br />$ 43,878,113.50 I I $ 43,878,113.50 I
<br />Prepared by the City of Ramsey Finance Department
<br />8/5/2014
<br />
|