|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June, 2012
<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 />Bond Proceeds
<br />TOTAL CASH INFLOW
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />F&C Draws
<br />Ramsey Rail - Northstar
<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 2012 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />June-12
<br />CURRENT MONTH
<br />2012
<br />YEAR-TO-DATE
<br />$ 41,590,958.22 $ 45,949,302.73
<br />480,754,07
<br />3,280,000.00
<br />57,592.40
<br />20,588.64
<br />91,171.18
<br />12,137.35
<br />$ 3,942,243.64 $
<br />$ 45,533,201.86 $
<br />3,532,401,15
<br />3,369,679.38
<br />1,494,935.46
<br />172,942.10
<br />483,667.94
<br />12,137.35
<br />9,065,763.38
<br />55,015,066.11
<br />442,954.93 $ 2,688,857.90
<br />701,071.22 3,221,326.57
<br />223,523.31 659,201.94
<br />2,375,000.00 3,562,500.00
<br />371,947.30 1,688,333.30
<br />1,618.49 5,688.15
<br />254,797.70 1,688,310.63
<br />7,930.12 47,756.80
<br />(2,459.96) (6,318.96)
<br />89,406.25 391,580.00
<br />78.05 495.33
<br />4,465,867.41 $ 13,947,731.66
<br />41,067,334.45 1 I $
<br />41,067,334.45 1
<br />(523,623.77) (4,881,968.28)
<br />$ 34,417,809.74
<br />525,000.00
<br />(1,103,148.30)
<br />$ 42,230,022.32
<br />33,839,661.44 I I $
<br />9,988,000.00
<br />(18,378,360.88)
<br />33,839,661.44 I
<br />Prepared by the City of Ramsey Finance Department
<br />7/16/2012
<br />
|