|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June, 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 />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 />June-I1
<br />CURRENT MONTH
<br />$ 42,413,459,11
<br />1,007,657.98
<br />3,226,000.00
<br />. 80,976.71
<br />1,660.16
<br />164,062.69
<br />$ 4,480,357.54
<br />$ 46,893,816.65
<br />2011
<br />YEAR-TO-DATE
<br />$ 44,417,829.93
<br />2,890,974.06
<br />3,461,998.83
<br />1,613,992.36
<br />1,660.16
<br />488,107.45
<br />$ 8,456,732.86
<br />$ 52,874,562.79
<br />378,905.98 $ 2,551,960.49
<br />1,043,856.73 2,941,346.24
<br />91,880.07 165,155.31
<br />270,806.10 1,737,458, 82
<br />5,631.51 39,145.74
<br />(195.57) (115,379.39)
<br />440,460.00 892,403.75
<br />2,231,344.82
<br />$ 8,212,090,96
<br />44,662,471.83 I I $
<br />2,249,012.72
<br />$ 39,856,762.55
<br />1,474,968.35
<br />(2,067,072.08)
<br />44,662,471.83 I
<br />244,641.90
<br />$ 41,467,058.94
<br />$ 39,264,658.82 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />7/29/2011
<br />8,749,968.35
<br />(10,952,368.47)
<br />39,264,658.82 I
<br />
|