|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period ended December 31, 2023
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes 2022 & 2023 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 2023 CASH INFLOW (OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE - BV
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />December-23
<br />CURRENT MONTH
<br />2023
<br />YEAR-TO-DATE
<br />I01,3971603.29 $ 1063549,768.65
<br />1,451,314.71
<br />%358,023.43
<br />90,129.64
<br />210,375.76
<br />2773993.85
<br />$ 11,387,837.39
<br />12,19I,200.88
<br />20,40%533.89
<br />2,478,240.46
<br />65271,398.20
<br />2,81.1.5,778.33
<br />8,454,005.31
<br />$ 52,616,157.07
<br />$ 112,785,440.68 $ 1595165,925.72
<br />2,887,088.78
<br />892, 876.42
<br />1,695,271.49
<br />28,540.32
<br />470,882.47
<br />286.23
<br />(251673,969.63)
<br />2,884,3 82.50
<br />236.50
<br />16,058,660.66
<br />10,987,389.01
<br />18,797,116.69
<br />128,267.87
<br />6,084,593.85
<br />19,679.96
<br />(2,237,022.90)
<br />3,220,670.00
<br />2,724.98
<br />$ 6013595.08 $ 53,0723?080.12
<br />106,0935845.60 $ 106,0935845.60
<br />4,6965242.31 (4555923.05)
<br />$ 71,547,522.61
<br />8%614,560.81
<br />249,389.65
<br />29,197,126.55
<br />_ (165,000.00)„
<br />(47,179,775.10)
<br />$ 71,631,912.26
<br />71,6319912.26
<br />Prepared by the City of Ramsey Finance Department
<br />114/2024
<br />
|