|
C o. I
<br />. CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />• Period Ended April 30, 2007
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<br />April -07 2007
<br />CURRENT MONTH YEAR -TO -DATE
<br />$ 44,610,467.22 $ 42,982,917.84
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />Municipal Center Proceeds held with Trust Agent
<br />Bond Proceeds
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />NSF/Expired City Checks [More than 6 months]
<br />371,442.48 3,056,862.06
<br />- 94,501.17
<br />3,374,492.20
<br />1,703,575.55
<br />116,622.53 513,799.67
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />Pay Estimates
<br />Payroll - Net
<br />Void Checks/Dormant Checks Paid
<br />Debt Service
<br />Miscellaneous [Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />MEMO - NET 2007 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities /Sales
<br />ENDING BALANCE
<br />•
<br />$ 488,065.01 $
<br />8,743,230.65
<br />(2,503,255.70)
<br />(10,552,314.24)
<br />$ 45,098,532.23 $
<br />51,726,148.49
<br />616,699.37 $
<br />2,425,524.48
<br />650,230.78
<br />1,983,503.30
<br />225,402.35
<br />1,322,711.47
<br />299,524.13
<br />1,109,335.99
<br />(14,986.98)
<br />(21,403.66)
<br />1,584,814.33
<br />$ 1,776,869.65 $
<br />8,404,485.91
<br />$ 43,321,662.58 43,321,662.58
<br />(1,288,804.64) 338,744.74
<br />$ 42,121,733.30 $ 40,468,547.40
<br />2,155,000-00
<br />11,857,244.44
<br />(2,503,255.70)
<br />(10,552,314.24)
<br />$ 41,773,477.60 1
<br />$ 41,773,477.60
<br />Prepared by the City of Ramsey Finance Department
<br />05/01/2007
<br />-3-
<br />
|