|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended October 31, 2017
<br />'CASH AND TEMPORARY INVESTMENTS 1
<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 2017 CASH INFLOW ( OUTFLOW)
<br />'INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />October-17
<br />CURRENT MONTH
<br />$ 66,567,988.46
<br />585,927.82
<br />2017
<br />YEAR-TO-DATE
<br />64,912,887.39
<br />6,427,874.87
<br />6,218,640.94
<br />21,254.00 2,154,226.06
<br />267,727.26 2,347,843.80
<br />65,503.88 745,635.60
<br />863,473.61
<br />$ 940,412.96 $ 18,757,694.88
<br />$ 67,508,401.42 $ 83,670,582.27
<br />647,593.30
<br />354,021.10
<br />304,104,28
<br />5,286.61
<br />305,201.84
<br />4,716.78
<br />(27,156.75)
<br />28,00
<br />1,593,795.16 $
<br />65,914,606.26 I ( $
<br />(653,382.20)
<br />$ 60,323,801.80
<br />424,000.00
<br />(2,182,321.62)
<br />$ 58,565,480.18 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />11/1/2017
<br />6,505,800.09
<br />4,688,067.76
<br />2,142,280.63
<br />53,944.01
<br />3,247,456.74
<br />46,907.67
<br />(72,154.09)
<br />1,143,245. 01
<br />428.19
<br />17,755,976.01
<br />65,914,606.26 I
<br />1,001,718.87
<br />57,425,022.30
<br />18,339,000.00
<br />(17,198,542.12)
<br />58,565,480.18 I
<br />
|