|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 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 />August-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />F
<br />$ 88,417,606.07 $ 84,144,038.99
<br />262,244.33
<br />596,232.11
<br />925,776.53
<br />82,376.86
<br />7,957,044.15
<br />7,254,361,86
<br />1,631,098.29
<br />2,845,720,40
<br />1,056,996.71
<br />TOTAL CASH INFLOW $ 1,866,629.83 $ 20,745,221.41
<br />TOTAL CASH AVAILABLE $ 90,284,23 5.90 $ 104,889,260.40
<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 />653,194.71
<br />606,431.78
<br />.74,412,79
<br />5,675,54
<br />399,751.57
<br />2,571.30
<br />(20,884,23)
<br />69,220.00
<br />149.00
<br />1,790,522.46
<br />$ 88,493,713.44
<br />76,107.37
<br />$ 74,738,456.61
<br />10,620,000.00
<br />(10,959,897.62)
<br />$ 74,398,558.99
<br />Prepared by the City of Ramsey Finance Department
<br />9/14/2020
<br />6,186,185.59
<br />4,278,343.64
<br />91,184.28
<br />42,008.26
<br />3,218,772.84
<br />33,224.20
<br />(67,751.70)
<br />2,612,552.35
<br />1,027.50
<br />16,395,546.96
<br />88,493,713.44
<br />4,349,674.45
<br />73,537,171.61
<br />43,289,533,49
<br />(42,428,146.11)
<br />$ 74,398,558.99
<br />3
<br />
|