|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended September 30, 2018
<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 (Includes Utility Billing)
<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 />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 2018 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />September-18
<br />CURRENT MONTH
<br />$ 74,917,295.94
<br />1,177,389.01
<br />37,215.52
<br />175,820.63
<br />84,579.93
<br />$ 1,475,005.09
<br />$ 76,392,301.03
<br />991,151.20
<br />463,721.96
<br />371,142.83
<br />9,945.88
<br />337,091.72
<br />2,014.09
<br />(146.69)
<br />63.00
<br />2018
<br />YEAR-TO-DATE
<br />$ 69,531,209.52
<br />9,853,948.91
<br />6,844,668.18
<br />1,703,979.01
<br />2,605,665.35
<br />881,976.62
<br />1,161,022.39
<br />$ 23,051,260.46
<br />$ 92,582,469.98
<br />2,174,983.99 $
<br />74,217,317.04 I $
<br />(699,978.90)
<br />$ 65,864,602.13
<br />2,125,000.00
<br />(574,076.07)
<br />$ 67,415,526.06 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />10/1/2018
<br />6,391,339.99
<br />5,135,807.50
<br />2,731,988.69
<br />49,501.66
<br />3,143,360.17
<br />31,350.42
<br />(100,633.90)
<br />981,899.41
<br />539.00
<br />18,365,152.94
<br />74,217,317.04 I
<br />4,686,107.52
<br />61,031,260.23
<br />25,680,000.95
<br />(19,295,735.12)
<br />67,415,526.06
<br />
|