|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June 30, 2018
<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 2018 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />June-18
<br />CURRENT MONTH
<br />$ 67,773,840.65
<br />431,066.11
<br />43,340.60
<br />141,936.51
<br />162,749.88
<br />4,300,000.00
<br />$ 5,079,093.10
<br />$ 72,852,933.75
<br />623,416.04
<br />777,018.50
<br />340,309.64
<br />7,866.30
<br />497,972.07
<br />1,706.34
<br />(1,380.05)
<br />59.50
<br />2018
<br />YEAR-TO-DATE
<br />$ 69,531,209.52
<br />5,029,708.39
<br />22,366.22
<br />1,022,295.65
<br />1,500,649.79
<br />589,779.66
<br />4,300,000.00
<br />$ 12,464,799.71
<br />$ 81,996,009.23
<br />2,246,968.34 $
<br />70,605,965.41 I I $
<br />2,832,124.76
<br />$ 61,809,700.25
<br />3,494,000.00
<br />(5,707,263.17)
<br />$ 59,596,437.08 1 ( $
<br />Prepared by the City of Ramsey Finance Department
<br />7/2/2018
<br />3,936,362.33
<br />3,522,678.63
<br />986,218.89
<br />28,847.05
<br />2,110, 872.49
<br />23,406.21
<br />(99,479.94)
<br />880,788.16
<br />350.00
<br />11,390,043.82
<br />70,605,965.41
<br />1,074,755.89
<br />61,031,260.23
<br />12,567,000.00
<br />(14,001,823.15)
<br />59,596,437.08 1
<br />
|