|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2018
<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 2018 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />August-18
<br />CURRENT MONTH
<br />$ 73,115,192.48
<br />2,880,507.42
<br />625,089.87
<br />742,595.17
<br />135,523.75
<br />$ 4,383,716.21
<br />$ 77,498,908.69
<br />1,011,486.72
<br />599,183.56
<br />545,707.82
<br />5,916.67
<br />352,786.07
<br />1,953.43
<br />(302.32)
<br />64,818.75
<br />63.00
<br />2018
<br />YEAR-TO-DATE
<br />$ 69,531,209.52
<br />8,676,559.90
<br />2,544,668.18
<br />1,666,763.49
<br />2,429, 844.72
<br />797,395.74
<br />5,461,022.39
<br />$ 21,576,254.42
<br />$ 91,107,463.94
<br />2,581,613.70 $
<br />74,917,294.99 I I $
<br />1,802,102.51
<br />$ 65,349,883.48
<br />2,764,000.00
<br />(2,249,282.30)
<br />$ 65,864,601.18 I 1 $
<br />5,400,188.79
<br />4,672,085.54
<br />2,360,845.86
<br />39,555.78
<br />2,806,268.45
<br />29,336.33
<br />(100,487.21)
<br />981,899.41
<br />476.00
<br />16,190,168.95
<br />74,917,294.99 I
<br />5,386,085.47
<br />61,031,260.23
<br />23,555,000.00
<br />(18,721,659.05)
<br />65,864,601.18 I
<br />Prepared by the City of Ramsey Finance Department
<br />9/4/2018
<br />
|