|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended September 30, 2021
<br />September-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 89,151,569,96 $ 95,116,775.37
<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-int
<br />1,956,727.58
<br />68,689.05
<br />165,866.12
<br />77,006.79
<br />11,106,795.48
<br />8,355,052,65
<br />1,833,404.38
<br />3,252,058.14
<br />729,008.71
<br />1,166.74
<br />TOTAL CASH INFLOW $ 2,268,289.54 $ 25,277,486.10
<br />TOTAL CASH AVAILABLE $ 91,419,859.50 $ 120,394,261.47
<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 2021 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />1,235,747.72
<br />818,215.99
<br />1,544,925.42
<br />15,378.50
<br />402,271.63
<br />2,600.09
<br />(5,163.13)
<br />290.70
<br />$ 4,014,266.92
<br />$ 87,405,592.58
<br />(1,745,977.38)
<br />71,908,411.69
<br />1,750,000.00
<br />(1,682,056.43)
<br />$ 71,976,355.26
<br />9,311,586.89
<br />5,917,610.31
<br />13,569,849.05
<br />_ 57,999.14
<br />3,811,638.62
<br />32,475.10
<br />(72,659.52)
<br />357,711.89
<br />2,457.41
<br />32,988,668.89
<br />$ 87,405,592.58
<br />(7,711,182.79)
<br />73,628,220.22
<br />58,176,392.60
<br />(59,828,257.56)
<br />$ 71,976,355.26
<br />Prepared by the City of Ramsey Finance Department
<br />10/5/2021
<br />
|