|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June 30, 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
<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 />June-17
<br />CURRENT MONTH
<br />2017
<br />YEAR-TO-DATE
<br />$ 61,747,370.64 $ 64,912,887.39
<br />1,422,499.85
<br />3,900,000.00
<br />76,731.66
<br />106,332.93
<br />115,818.34
<br />3,777,802.87
<br />4,058,808.75
<br />1,388,261.50
<br />977,482.58
<br />465,269.10
<br />$ 5,621,382.78 $ 10,667,624.80
<br />67,368,753.42 $ 75,580,512.19
<br />1,269,605.94
<br />491,249.58
<br />262,980.61
<br />7,343.56
<br />475,555.17
<br />5,057.86
<br />(39,840.76)
<br />299,377.51
<br />28.00
<br />2,771,357.47 $
<br />64,597,395.95 1 I $
<br />2,850,025.31
<br />$ 58,702,809.78
<br />3,570,000.00
<br />(4,590,136.72)
<br />$ 57,682,673.06 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />7/3/2017
<br />4,107,320.58
<br />3,163,948.18
<br />673,394.05
<br />23,117.49
<br />1,987,014.50
<br />30,985.87
<br />(41,254.38)
<br />1,038,273.76
<br />316.19
<br />10,983,116.24
<br />64,597,395.95 I
<br />(315,491.44)
<br />57,425,022.30
<br />11,073,000.00
<br />(10,815,349.24)
<br />57,682,673.06 I
<br />
|