|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended January 31, 2022
<br />January-22 2022
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 88,776,714.25 $ 88,776,714.25
<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 />860,842.10
<br />201,871.91
<br />21,658.88
<br />159,807.84
<br />76,258.04
<br />860,842.10
<br />201,871.91
<br />21,658.88
<br />159,807.84
<br />76,258.04
<br />TOTAL CASH INFLOW $ 1,320,438.77 $ 1,320,438.77
<br />TOTAL CASH AVAILABLE $ 90,097,153.02 $ 90,097,153.02
<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 />657,844.38
<br />318,221.44
<br />792,348.04
<br />3,873.63
<br />413,585.12
<br />2,059.68
<br />(5,350.09)
<br />183.00
<br />657,844.38
<br />318,221.44
<br />792,348.04
<br />3,873.63
<br />413,585.12
<br />2,059.68
<br />(5,350.09)
<br />183.00
<br />$ 2,182,765.20 $ 2,182,765.20
<br />$ 87,914,387.82
<br />(862,326.43)
<br />$ 71,817,760.66
<br />253,882.73
<br />(181,013.33)
<br />$ 71,890,630.06
<br />$ 87,914,387.82
<br />(862,326.43)
<br />71,817,760.66
<br />253,882.73
<br />(181,013.33)
<br />$ 71,890,630.06
<br />Prepared by the City of Ramsey Finance Department
<br />2/2/2022
<br />
|