|
<br />CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30,2009
<br />
<br />C-I
<br />
<br /> November-09 2009
<br /> CURRENT MONTH YEAR-TO-DATE
<br />tCASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 44,332,476.56 $ 54,000,742.66
<br />CASH INFLOWS:
<br />Daily Deposit 165,795.98 6,132,781.94
<br />Tax Settlements 7,283,433.49
<br />U/B Receipts 870,628.97 3,545,601.18
<br />Bond Proceeds 1,302,616.00 1,302,616.00
<br />Interest Eatnings [Net of Interest Paid on Investments] 80,528.49 1,414,534.47
<br />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW $ 2,419,569.44 $ 19,678,967.08
<br />TOTAL CASH AVAILABLE $ 46,752,046.00 $ 73,679,709.74
<br />CASH OUTFLOWS:
<br />Prepaid Checks 327,323.07 $ 15,037,152.08
<br />Bills Lists 315,281.68 4,788,339.05
<br />Pay Estimates 726,05923 3,742,497.77
<br />Payroll - Net 267,224.40 3,453,813.86
<br />Void Checks/Dormant Checks Paid (72,081.89)
<br />Debt Service 189,242.50 1,803,073.75
<br />Miscellaneous [Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW $ 1,825,130.88 $ 28,752,794.62
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 44,926,915.12 I I $ 44,926,915.12 I
<br />MEMO- NET 2009 CASH INFLOW ( OUTFLOW) 594,438.56 (9,073,827.54)
<br />
<br />IINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE $ 43,256,572.66 $ 48,694,357.12
<br />Purchases 120,000,00 30,534,616.46
<br />Maturities/Sales (1,128,149.38) (36,980,550.30)
<br />ENDING BALANCE 1$ 42,248,423.28 I 1$ 42,248,423.28 I
<br />
<br />Prepared by the City of Ramsey Finance Department
<br />12/1/2009
<br />
|