|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30, 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 />November-22 2022
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 91,096,028.39 $ 88,776,714.25
<br />571,723.30
<br />750,533.76
<br />1,342,131.61
<br />68,391.71
<br />13,783,786.40
<br />9,684,372.85
<br />2,463,041.69
<br />5,123,774.88
<br />1,009,138.38
<br />TOTAL CASH INFLOW $ 2,732,780.38 $ 32,064,114.20
<br />TOTAL CASH AVAILABLE $ 93,828,808.77 $ 120,840,828.45
<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 />658,589.51
<br />438,225.00
<br />2,081,761.06
<br />7,056.50
<br />446,228.72
<br />1,377.60
<br />(6,607.32)
<br />353,831.25
<br />(601.65)
<br />10,272,860.61
<br />7,266,731.26
<br />7,571,890.59
<br />80,526.55
<br />5,044,714.79
<br />31,051.04
<br />(33,273.46)
<br />755,689.31
<br />1,689.66
<br />$ 3,979,860.67 $ 30,991,880.35
<br />$ 89,848,948.10
<br />(1,247,080.29)
<br />$ 88,687,474.40
<br />1,498,367.65
<br />(448,032.23)
<br />$ 89,737,809.82
<br />$ 89,848,948.10
<br />1,072,233.85
<br />71,817,760.66
<br />30,450,375.45
<br />(12,530,326.29)
<br />89,737,809.82
<br />Prepared by the City of Ramsey Finance Department
<br />12/7/2022
<br />
|