|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period ended May 31, 2024
<br />May-24 2024
<br />CURRENT MONTH YEAR-TO-DATE
<br />[CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes 2022 & 2023 Band Proceeds) $ 96,273,724.51
<br />CASH INFLOWS:
<br />Daily Deposit
<br />1,8973768.23
<br />Tax Settlements
<br />--
<br />U/B Receipts
<br />513,371.50
<br />Credit Cards (Includes Utility Billing)
<br />1,0213403.93
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />17%621.63
<br />Bond Proceeds--int
<br />8,664.35
<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 2024 CASH INFLOW (OUTFLOW)
<br />JINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE - BV
<br />Purchases
<br />Maturities/S ales
<br />ENDING BALANCE
<br />$ 1063429.1330.67
<br />4,9755948.19
<br />203,234.45
<br />L026,511.27
<br />2,877,267.20
<br />1,436,566.07
<br />45,147.26
<br />$ 33620,829.64 $ 10,564,674.44
<br />$ 9%894,554.15 $ 116,994,005.11
<br />807,427.99
<br />1,147,524.17
<br />3,089,516.49
<br />99765.43
<br />521,908.90
<br />30.95
<br />(196.87)
<br />4201.25
<br />264.50
<br />4,752,670.22
<br />6,557,140.39
<br />8,518,335.87
<br />50,242.27
<br />2,79%836.95
<br />695.13
<br />(4,515.81)
<br />423681.25
<br />-- .... .... ..... .. _1,287.50
<br />$ 5,618,922.81 $ 221,718,373.77
<br />$ 949275,631.34 $ 9492755631.34
<br />(11998,093.17) (12,1539699.33)
<br />$ 5796263875.90
<br />71,631,912.26
<br />8,0005000.00
<br />8,663,073.02
<br />(4,520,494.80)
<br />(19,18004.18)
<br />$ 61,1065381.10
<br />-]
<br />E$: 61,106,381.10
<br />Prepared by the City of Ramsey Finance Department
<br />6I512 024
<br />
|