|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August, 2012
<br />CASH AND TEMPORARY INVESTMENTS
<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
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />Au gust-12
<br />CURRENT MONTH
<br />$ 42,432,897.09
<br />216,254.67
<br />897,817.36
<br />69,373.14
<br />78,821.27
<br />$ 1,262,266.44
<br />$ 43,695,163.53
<br />2012
<br />YEAR-TO-DATE
<br />$ 45,949,302.73
<br />4,379,873.34
<br />6,271,397.42
<br />2,423,246.77
<br />264,786.98
<br />636,408.02
<br />12,137.35
<br />$ 13,987,849.88
<br />$ 59,937,152.61
<br />1,006,286.05 $
<br />489,517.32
<br />1,089,243.21
<br />489.08
<br />370,253.25
<br />2,165.79
<br />(6,669.64)
<br />124.95
<br />2,951,410.01 $
<br />40,743,753.52 1 I $
<br />(1,689,143.57)
<br />$ 32,451,994.08
<br />2,496,000.00
<br />(2,072,140.15)
<br />4,796,501.77
<br />4,134,261.13
<br />781,853.68
<br />3,562,500.00
<br />3,029,043.03
<br />7,189.67
<br />2,336,182.71
<br />55,203.32
<br />(13,705.08)
<br />503,663.33
<br />705.53
<br />19,193,399.09
<br />40,743,753.52 I
<br />(5,205,549.21)
<br />$ 42,230,022.32
<br />$ 32,875,853.93 I I $
<br />13,384,000.00
<br />(22,738,168.39)
<br />32,875,853.93 I
<br />Prepared by the City of Ramsey Finance Department
<br />9/17/2012
<br />
|