|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July, 2011
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE
<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 />NSF/Expired City Checks [More than 6 months]
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />Pay Estimates
<br />Credit Cards
<br />Payroll - Net
<br />Flex Reimbursement
<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 2010 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />July-11
<br />CURRENT MONTH
<br />$ 44,662,471.83
<br />97,792.14
<br />3,156,626.22
<br />31,289.70
<br />8,129.30
<br />113,109.03
<br />$ 3,406,946.39
<br />$ 48,069,418.22
<br />2011
<br />YEAR-TO-DATE
<br />$ 44,417,829.93
<br />2,988,766.20
<br />6,618,625.05
<br />1,645,282,06
<br />9,789.46
<br />601,216,48
<br />$ 11,863,679.25
<br />$ 56,281,509.18
<br />389,546.39 $ 2,941,506.88
<br />628,801.19 3,570,147.43
<br />768,084.07 933,239.38
<br />373.75 373,75
<br />303,290.77 2,040,749.59
<br />4,203.93 43,349.67
<br />(55.41) (115,434.80)
<br />17,173.75 909,577.50
<br />2,111,418.44
<br />$ 10,323,509.40
<br />45,957,999.78 I I $
<br />1,295,527.95
<br />$ 39,264,658.82
<br />5,697,000.00
<br />(4,653,047.72)
<br />45,957,999.78 I
<br />1,540,169.85
<br />$ 41,467,058.94
<br />40,308,611.10 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />8/2/2011
<br />14,446,968.35
<br />(15,605,416.19)
<br />40,308,611.10 I
<br />
|