|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31, 2017
<br />(CASH AND TEMPORARY INVESTMENTS
<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 />December-17
<br />CURRENT MONTH
<br />$ 65,372,393.23
<br />2017
<br />YEAR-TO-DATE
<br />$ 64,912,887.39
<br />630,747.97 8,960,299.34
<br />5,504,202.05 11,722, 842.99
<br />59,365.50 2,954,350.97
<br />106, 826.21 3,069,340.70
<br />103,543.37 952,074.40
<br />863,473.61
<br />$ 6,404,685.10 $ 28,522,382.01
<br />$ 71,777,078.33 $ 93,435,269.40
<br />648,700.31
<br />770,113.12
<br />352,489.42
<br />8,127.69
<br />459,267.57
<br />7,214.26
<br />(23.90)
<br />35.00
<br />2,245,923.47 $
<br />$ 69,531,154.86 I I $
<br />4,158,761.63
<br />$ 57,783,494.62
<br />5,484,000.00
<br />(2,236,234.39)
<br />$ 61,031,260.23 1 I $
<br />Prepared by the City of Ramsey Finance Department
<br />1/2/2018
<br />7,746,210.40
<br />5,983,443.08
<br />3,208,374.74
<br />72,102.89
<br />4,010,993.11
<br />57,315.92
<br />(73,019.06)
<br />2,898,198.77
<br />494.69
<br />23,904,114.54
<br />69,531,154.86 1
<br />4,618,267.47
<br />57,425,022.30
<br />25,943,000.00
<br />(22,336,762.07)
<br />61,031,260.23 I
<br />
|