|
<br />C-I
<br />
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended JUNE 30, 2006
<br />
<br /> June-06 2006
<br /> CURRENT MONTH YEAR- TO-DATE
<br />ICASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 45,247,859.78 $ 49,665,371.16
<br />CASH INFLOWS:
<br />Daily Deposit 1,060,588.30 6,987,403.86
<br />Tax Settlements 2,488,200.00 2,574,756.06
<br />Municipal Center Proceeds held with Trust Agent 780,150.46 6,566,448. I 6
<br />Bond Proceeds 1,011,205.97
<br />Interest Earnings [Net of Interest Paid on Investments] 166,676.02 852,163.01
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 4,495,614.78 $ 17,991,977.06
<br />TOTAL CASH AVAILABLE $ 49,743,474.56 $ 67,657,348.22
<br />CASH OUTFLOWS:
<br />Prepaid Checks 948,229.55 $ 5,130,886.45
<br />B ills Lists 501,623.70 3,369,974.45
<br />Pay Estimates 3,063,953.61 11,764,299.92
<br />Payroll - Net 374,932.60 1,599,776.21
<br />Void CheckslDormant Checks Paid (435.00) (3,107.87)
<br />Debt Service 690,906.99 1,631,255.95
<br />Miscellaneous [Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW $ 5,579,211.45 $ 23,493,085.11
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 44,164,263.11 I I $ 44,164,263.11 I
<br />MEMO - NET 2006 CASH INFLOW ( OUTFLOW) (1,083,596.67) (5,501,108.05)
<br />
<br />IINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 41,387,957.90 $ 48,994,958.00
<br />Purchases 3,700,000.00 7,844,000.00
<br />Maturities/Sales (3,135,470.32) (I 4,886,470.42).
<br />ENDING BALANCE I S 41,952,487.58 I Is 41,952,487.58 I
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />07/04/2006
<br />
<br />-1-
<br />
|