|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended March 31, 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 />March-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 82,854,220.37 $ 84,144,038.99
<br />638,379.10
<br />33,940.78
<br />145,853.02
<br />154,561.34
<br />1,714,678.03
<br />116,640.63
<br />483,655.10
<br />826,850.37
<br />444,836.44
<br />TOTAL CASH INFLOW $ 972,734.24 $ 3,586,660.57
<br />TOTAL CASH AVAILABLE $ 83,826,954.61 $ 87,730,699.56
<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 1
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />429,126.95
<br />364,993.31
<br />8,145.55
<br />378,585.12
<br />2,889.68
<br />(241.36)
<br />145.50
<br />1,889,761.03
<br />1,702,436.01
<br />14,620.66
<br />1,112,932.84
<br />13,478.60
<br />(44,368.44)
<br />398,097.50
<br />431.50
<br />$ 1,183,644.75 $ 5,087,389.70
<br />$ 82,643,309.86
<br />(210,910.51)
<br />$ 73,922,100.23
<br />2,310,000.00
<br />(5,937,043.72)
<br />$ 70,295,056.51
<br />$ 82,643,309.86
<br />(1,500,729.13)
<br />73,537,171.61
<br />10,505,000.00
<br />(13,747,115.10)
<br />$ 70,295,056.51
<br />Prepared by the City of Ramsey Finance Department
<br />4/3/2020
<br />
|