|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended September, 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 />September-12
<br />CURRENT MONTH
<br />2012
<br />YEAR-TO-DATE
<br />$ 40,739,201.75 $ 45,949,302.73
<br />125,697.79 4,501,023.28
<br />6,271,397.42
<br />172,866.32 2,596,113.17
<br />41,251.06 306,038.04
<br />51,547.28 687,955.30
<br />12,137.35
<br />$ 391,362.45 $ 14,374,664.56
<br />$ 41,130,564.20 $ 60,323,967.29
<br />292,697.73 $
<br />666,318.45
<br />477,484.70
<br />2,355.76
<br />23 3,628.25
<br />2,941.85
<br />67.00
<br />1,675,493.74 $
<br />39,455,070.46 I I $
<br />(1,284,131.29)
<br />$ 32,875,853.93
<br />200,000.00
<br />(3,263,115.15)
<br />5,089,199.50
<br />4,800,579.58
<br />781,853.68
<br />3,562,500.00
<br />3,506,527.73
<br />9,545.43
<br />2,569,810.96
<br />58,145.17
<br />(13,705.08)
<br />503,663.33
<br />776.53
<br />20,868,896.83
<br />39,455,070.46
<br />(6,494,232.27)
<br />$ 42,230,022.32
<br />29,812,738.78 I I $
<br />13,584,000.00
<br />(26,001,283.54)
<br />29,812,738.78 I
<br />Prepared by the City of Ramsey Finance Department
<br />10/17/2012
<br />
|