|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended April 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 I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />March-17
<br />CURRENT MONTH
<br />$ 62,415,410.36
<br />561,806.53
<br />25,272.84
<br />61,908.45
<br />63,027.65
<br />$ 712,015.47
<br />$ 63,127,425.83
<br />390,679.84
<br />564,150.34
<br />12,032.94
<br />2,855.00
<br />310,720.14
<br />3,972.83
<br />(8.79)
<br />111.19
<br />2017
<br />YEAR-TO-DATE
<br />$ 64,912,887.39
<br />1,887,080.58
<br />158,808.75
<br />819,842.72
<br />401,043.21
<br />262,321.03
<br />$ 3,529,096.29
<br />$ 68,441,983.68
<br />1,284,513.49 $
<br />61,842,912.34 1 1 $
<br />(572,498.02)
<br />$ 55,996,699.38
<br />2,400,000.00
<br />(691,872.68)
<br />$ 57,704,826.70 1 1 $
<br />Prepared by the City of Ramsey Finance Department
<br />5/1/2017
<br />2,186,692.29
<br />2,118,381.76
<br />385,896.89
<br />13,903.55
<br />1,201,009.88
<br />18,725.40
<br />(1,413.62)
<br />675,615.00
<br />260.19
<br />6,599,071.34
<br />61,842,912.34 1
<br />(3,069,975.05)
<br />57,425,022.30
<br />6,404,000.00
<br />(6,124,195.60)
<br />57,704,826.70 1
<br />
|