|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2024
<br />July-24 2024
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes 2022 & 2023 Bond Proceeds) $ 93,689,860.10 $ 106,429,330.67
<br />CASH INFLOWS:
<br />Daily Deposit 3,103,036.84 8,867,242.35
<br />Tax Settlements 5,558,813.68 12,366,269.25
<br />UB Receipts 20,011.37 1,019,472.58
<br />Credit Cards (Includes Utility Billing) 443,819.96 3,580,325.78
<br />Interest Earnings [Net of Interest Paid on Investments] 256,718.99 1,928,682.36
<br />Bond Proceeds-int 8,233.04 61,638.74
<br />TOTAL CASH INFLOW $ 9,390,633.88 $ 27,823,631.06
<br />TOTAL CASH AVAILABLE $ 103,080,493.98 $ 134,252,961.73
<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 />INVESTMENT PORTFOLIO SUMMARY
<br />625,563.21 6,170,849.82
<br />1,486,248.00 9,741,730.78
<br />3,909,214.56 17,159,900.93
<br />6,860.40 77,491.68
<br />528,103.19 3,857,607.83
<br />695.13
<br />(3,012.04) (9,112.70)
<br />724,722.60
<br />271.50 1,830.50
<br />$ 6,553,248.82 $ 37,725,716.57
<br />$ 96,527,245.16 I I $ 96,527,245.16
<br />2,837,385.06 (9,902,085.51)
<br />BEGINNING BALANCE - BV $ 61,976,601.23 71,631,912.26
<br />Purchases 4,554,746.42 13,320,763.43
<br />Maturities/Sales (500,000.00) (18,921,328.04)
<br />ENDING BALANCE
<br />$ 66,031,347.65 1 I $ 66,031,347.65 I
<br />Prepared by the City of Ramsey Finance Department
<br />8/5/2024
<br />
|