|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended September 30, 2017
<br />September-17 2017
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS I
<br />BEGINNING BALANCE $ 67,760,829.04 $ 64,912,887.39
<br />CASH INFLOWS:
<br />Daily Deposit 714,602.69 5,841,947.05
<br />Tax Settlements 6,218,640.94
<br />U/B Receipts 56,965.86 2,132,972.06
<br />Credit Cards 183,906.49 2,080,116.54
<br />Interest Earnings [Net of Interest Paid on Investments] 69,466.38 680,131.72
<br />Bond Proceeds 863,473.61
<br />TOTAL CASH INFLOW $ 1,024,941.42 $ 17,817,281.92
<br />TOTAL CASH AVAILABLE $ 68,785,770.46 $ 82,730,169.31
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<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 />541,534.52 5,858,206.79
<br />404,472.82 4,334,046.66
<br />941,267.77 1,838,176.35
<br />12,578.99 48,657.40
<br />313,940.90 2,942,254.90
<br />4,010.53 42,190.89
<br />(51.53) (44,997.34)
<br />1,143,245.01
<br />28.00 400.19
<br />2,217,782.00 $ 16,162,180.85
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 66,567,988.46 I 1 $ 66,567,988.46
<br />MEMO - NET 2017 CASH INFLOW ( OUTFLOW) (1,192,840.58) 1,655,101.07
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE $ 60,675,143.98 57,425,022.30
<br />Purchases 847,000.00 17,915,000.00
<br />Maturities/Sales (1,198,342.18) (15,016,220.50)
<br />ENDING BALANCE I $ 60,323,801.80 I $ 60,323,801.80 I
<br />Prepared by the City of Ramsey Finance Department
<br />10/2/2017
<br />
|