|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31, 2022
<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 2022 CASH INFLOW ( OUTFLOW)
<br />'INVESTMENT PORTFOLIO SUMMARY I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />December-22
<br />CURRENT MONTH
<br />$ 89,849,264,74
<br />1,283,251.51
<br />8,164,315.66
<br />37,847.37
<br />105,151.15
<br />159,676.22
<br />11,903,743.78
<br />$ 21,653,985.69
<br />$ 111,503,250.43
<br />1,142,163.12
<br />604,125.00
<br />999,474.18
<br />22,521.86
<br />406,400.79
<br />1,409.51
<br />(205.97)
<br />1,778,301.25
<br />(691.35)
<br />$ 4,953,498.39
<br />2022
<br />YEAR-TO-DATE
<br />$ 88,776,714.25
<br />15,067,037.91
<br />17,848,688.51
<br />2,500,889.06
<br />5,228,926.03
<br />1,169,131.24
<br />11,903,743.78
<br />$ 53,718,416.53
<br />$ 142,495,130.78
<br />11,415,023.73
<br />7,870,856.26
<br />8,571,364.77
<br />103,048.41
<br />5,451,115.58
<br />32,460.55
<br />(33,479.43)
<br />2,533,990.56
<br />998.31
<br />$ 35,945,378.74
<br />106,549,752.041 I $ 106,549,752.04I
<br />16,700,487.30
<br />$ 89,737,809.82
<br />1,699,750.74
<br />(1,822,000.00)
<br />$ 89,615,560.56 I I $
<br />17,773,037.79
<br />71,817,760.66
<br />32,150,126.19
<br />(14,352,326.29)
<br />89,615,560.56 I
<br />Prepared by the City of Ramsey Finance Department
<br />1/9/2023
<br />
|