|
col
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31, 2009
<br />December-09
<br />CURRENT MONTH
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<br />2009
<br />YEAR-TO-DATE
<br />$ 44,926,915.12 $ 54,000,742.66
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Bond Proceeds
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />NSF/Expired City Checks [More than 6 months]
<br />466,742.37
<br />6,525,946.59
<br />173,341.23
<br />185,350.64
<br />6,599,524.31
<br />13,809,380.08
<br />3,718,942.41
<br />1,302,616.00
<br />1,599,885.11
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />$ 7,351,380.83 $ 27,030,347.91
<br />$ 52,278,295.95 $ 81,031,090.57
<br />Prepaid Checks 351,661.67 $ 15,388,813.75
<br />Bills Lists 772,599.01 5,560,938.06
<br />Pay Estimates 2,391,120.66 6,133,618.43
<br />Payroll -Net 259,601.19 3,713,415.05
<br />Void Checks/Dormant Checks Paid (44,724.04) (116,805.93)
<br />Debt Service 2,237,966.25 4,041,040.00
<br />Miscellaneous [Bank Charges; etc.] -
<br />
<br />TOTAL CASH OUTFLOW $ 5,968,224.74 $ 34,721,019.36
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />$ 46,310,071.21 $ 46,310,071.21
<br />MEMO -NET 2009 CASH INFLOW (OUTFLOW)
<br />1,383,156.09
<br />(7,690,671.45)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />$ 42,248,423.28
<br />$ 48,694,357.12
<br />7,700,000.00 38,234,616.46
<br />(6,985,418.98) (43,965,969.28)
<br />$ 42,963,004.30 $ 42,963,004.30
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />Prepared by the City of Ramsey Finance Department
<br />1/7/2010
<br />
|