|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June 30, 2023
<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 />June-23 2023
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 104,549,077.14 $ 106,549,768.65
<br />574,377.77
<br />6,249,196.84
<br />40,187.19
<br />228,005.02
<br />218,760.83
<br />4,115,558.39
<br />6,538,948.79
<br />914,126.95
<br />2,168,340.31
<br />1,114,533.51
<br />TOTAL CASH INFLOW $ 7,310,527.65 $ 14,851,507.95
<br />TOTAL CASH AVAILABLE $ 111,859,604,79 $ 121,401,276.60
<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 />1,062,770.37
<br />837,985.29
<br />421,477.74
<br />17,077.23
<br />462,890.17
<br />1,019.33
<br />(1,633.39)
<br />219,456.25
<br />230.00
<br />4,861,149,49
<br />4,016,794.51
<br />430,674.83
<br />42,960.39
<br />2,964,978.58
<br />12,583.69
<br />(32,074.84)
<br />265,237.50
<br />640,65
<br />$ 3,021,272.99 $ 12,562,944,80
<br />$ 108,838,331.80
<br />4,289,254.6E
<br />$ 77,519,743.68
<br />859,3 59.98
<br />(1,115,000.00)
<br />$ 77,264,103.66
<br />$ 108,838,331.80
<br />2,288,563.15
<br />89,614,560.81
<br />9,556,824.69
<br />(21,907,281.84)
<br />$ 77,264,103.66
<br />Prepared by the City of Ramsey Finance Department
<br />7/13/2023
<br />
|