|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended October, 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 />October-12
<br />CURRENT MONTH
<br />$ 39,455,070.46
<br />548,233.27
<br />53,135.95
<br />25,285.83
<br />69,698.80
<br />$ 696,353.85
<br />$ 40,151,424.31
<br />504,420.67
<br />618,210.42
<br />640,745.28
<br />1,357.74
<br />270,154.35
<br />3,216.23
<br />167.08
<br />$ 2,038,271.77
<br />2012
<br />YEAR-TO-DATE
<br />$ 45,949,302.73
<br />5,049,256.55
<br />6,271,397.42
<br />2,649,249.12
<br />331,323.87
<br />757,654.10
<br />12,137.35
<br />$ 15,071,018.41
<br />$ 61,020,321.14
<br />$ 5,593,620.17
<br />5,418,790.00
<br />781,853.68
<br />3,562,500.00
<br />4,147,273.01
<br />10,903.17
<br />2,839,965.31
<br />61,361.40
<br />(13,705.08)
<br />503,663.33
<br />943.61
<br />$ 22,907,168.60
<br />38,113,152.54 I I $
<br />(1,341,917.92)
<br />$ 29,812,738.78
<br />200,000.00
<br />(1,875,547.64)
<br />38,113,152.54 I
<br />(7,836,150.19)
<br />$ 42,230,022.32
<br />$ 28,137,191.14 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />11/2/2012
<br />13,784,000.00
<br />(27,876,831.18)
<br />28,137,191.14 I
<br />
|