|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended September 30, 2014
<br />September-14 2014
<br />CURRENT MONTH YEAR-TO-DATE
<br />(CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 48,500,562.47 $ 47,755,155.12
<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 />123,822.97 3,990,855.79
<br />5,474,842.07
<br />71,128.28 2,592,032.64
<br />51,431.55 503,875.59
<br />(62,144.37) 444,795.38
<br />TOTAL CASH INFLOW $ 184,238.43 $ 13,006,401.47
<br />TOTAL CASH AVAILABLE $ 48,684,800.90 $ 60,761,556.59
<br />CASH OUTFLOWS:
<br />Prepaid Checks 389,130.78 $ 4,783,573.25
<br />Bills Lists 444,539.38 3,836,069.20
<br />Pay Estimates - 1,025,181.57
<br />Credit Cards 3,631.09 16,436.11
<br />Payroll - Net 262,159.86 2,672,712.92
<br />Flex Reimbursement 2,773.84 36,134.52
<br />Void Checks/Dormant Checks Paid (273.95) (184,160.33)
<br />Debt Service 991,963.76
<br />Miscellaneous [Bank Charges; etc.] 805.69
<br />TOTAL CASH OUTFLOW $ 1,101,961.00 $ 13,178,716.69
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 47,582,839.90 I I $ 47,582,839.90 I
<br />MEMO - NET 2014 CASH INFLOW ( OUTFLOW) (917,722.57) (172,315.22)
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE $ 44,165,022.14 $ 42,140,323.39
<br />Purchases 784,000.00 10,447,000.00
<br />Maturities/Sales (1,853,122.70) (9,491,423.95)
<br />ENDING BALANCE
<br />$ 43,095,899.44 I I $ 43,095,899.44 I
<br />Prepared by the City of Ramsey Finance Department
<br />10/2/2014
<br />
|