|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended October 31, 2022
<br />October-22 2022
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />,BEGINNING BALANCE (Includes PW Bond Proceeds) $ 93,209,801.53 $ 88,776,714.25
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />UfB Receipts
<br />Credit Cards (Includes Utility Billing)
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds-int
<br />129,146.33
<br />17,316.80
<br />256,168.84
<br />101,310.49
<br />13,212,063.10
<br />9,684,372.85
<br />1,712,507.93
<br />3,781,643.27
<br />940,746.67
<br />TOTAL CASH INFLOW $ 503,942.46 $ 29,331,333.82
<br />TOTAL CASH AVAILABLE $ 93,713,743.99 $ 118,108,048.07
<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 2022 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />512,265,02
<br />824,341.61
<br />855,270.91
<br />7,359.51
<br />418,561.01
<br />669.75
<br />(132.56)
<br />(619.65)
<br />$ 2,617,715.60
<br />$ 91,096,028.39
<br />(2,113,773.14)
<br />$ 88,617,182.38
<br />655,292.57
<br />(585,000.55)
<br />$ 88,687,474.40
<br />9,614,271.10
<br />6,828,506.26
<br />5,490,129.53
<br />73,470.05
<br />4,598,486.07
<br />29,673.44
<br />(26,666.14)
<br />401,858.06
<br />2,291.31
<br />27,012,019.68
<br />$ 91,096,028.39
<br />2,319,314.14
<br />71,817,760.66
<br />28,952,007.80
<br />(12,082,294.06)
<br />$ 88,687,474.40
<br />Prepared by the City of Ramsey Finance Department
<br />12/ 1 /2022
<br />
|