|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended April 30, 2020
<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 2019 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />April-20
<br />CURRENT MONTH
<br />$ 82,643,359.86
<br />1,111,049.22
<br />18,814.05
<br />131,038.00
<br />123,672.41
<br />$ 1,384,573.68
<br />2020
<br />YEAR-TO-DATE
<br />$ 84,144,038.99
<br />2,825,777.25
<br />116,640.63
<br />502,469.15
<br />957,888.37
<br />568,508.85
<br />$ 4,971,284.25
<br />$ 84,027,933.54 $ 89,115,323.24
<br />1,479,697.50
<br />360,584.49
<br />3,935.57
<br />361,574.20
<br />2,075.67
<br />(872.41)
<br />149.00
<br />2,207,144.02 $
<br />81,820,789.52 I J $
<br />(822,570.34)
<br />$ 70,295,056.51
<br />2,720,000.00
<br />(3,485,041.77)
<br />1 $ 69,530,014.74 1 I $
<br />Prepared by the City of Ramsey Finance Department
<br />5/6/2020
<br />3,369,458.53
<br />2,063,020.50
<br />18,556.23
<br />1,474,507.04
<br />15,554.27
<br />(45,240.85)
<br />398,097.50
<br />580.50
<br />7,294,533.72
<br />81,820,789.52 I
<br />(2,323,249.47)
<br />73,537,171.61
<br />13,225,000.00
<br />(17,232,156.87)
<br />69,530,014.74
<br />
|