|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended October 31, 2021
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds)
<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 />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 2021 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />October-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />87,405,592.58 $ 95,116,775.37
<br />1,146,582.92
<br />30,617.66
<br />152,836.31
<br />76,387.55
<br />10,512,477.52
<br />12,253,378.40
<br />8,355,052.65
<br />1,864,022.04
<br />3,404,894.45
<br />805,396.26
<br />10,513,644.26
<br />$ 11,918,901.96 $ 37,196,388.06
<br />$ 99,324,494.54 $ 132,313,163.43
<br />841,280.09
<br />825,793.24
<br />1,355,101.61
<br />3,891.33
<br />592,908.56
<br />1,172.39
<br />(804.97)
<br />444.91
<br />$ 3,619,787.16
<br />$ 95,704,707.38
<br />8,299,114.80
<br />$ 71,976,355.26
<br />1,620,000.00
<br />(1,546,841.37)
<br />$ 72,049,513.89
<br />10,152,866.98
<br />6,743,403.55
<br />14,924,950.66
<br />61,890.47
<br />4,404,547.18
<br />33,647.49
<br />(73,464.49)
<br />357,711.89
<br />2,902.32
<br />36,608,456.05
<br />$ 95,704,707.38
<br />587,932.01
<br />73,628,220.22
<br />59,796,392.60
<br />(61,375,098.93)
<br />$ 72,049,513.89
<br />Prepared by the City of Ramsey Finance Department
<br />11/2/2021
<br />
|