|
CITY OF 1tAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended May 31, 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 />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 />May-23 2023
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 103,4543939.43 $ 10655495768.65
<br />1 J37,338.71
<br />3,541,180.62
<br />- -
<br />28%751.95
<br />394,033.34
<br />873,939.76
<br />895,712.33
<br />1,9405335.29
<br />37%470.95
<br />895,772.68
<br />$ 2,806,555.33
<br />$ 7,5403980.30
<br />$ 10652613494.76
<br />$ 114,090,748.95
<br />736,714.18
<br />469,260.15
<br />3,179.60
<br />456,933.38
<br />4,982.36
<br />(5,104.64)
<br />45, 781.25
<br />233.00
<br />$ 1,711,979.28 $
<br />3,798,379.12
<br />35178,809.22
<br />95197.09
<br />25,444.82
<br />25502,088.41
<br />11,564.36
<br />(30,441.45)
<br />45,781.25
<br />410.65
<br />%5415233.47
<br />$ 104,549,515.48 $ 104,549,515.48
<br />170949576.05 (2,000,253.17)
<br />$ 889480,096.83 8%6149560.81
<br />-- 8,467, 817.86
<br />(l 1,19o,00o.00) (20,792,281.84)
<br />$ 77,290,096.83 $ 779290,096.83
<br />Prepared by the City of Ramsey Finance Department
<br />6/5/2023
<br />
|