|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 31, 2021
<br />December-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 96,435,324.65 $ 95,116,775.37
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />UIB 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 2021 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />424,540.17
<br />7,046,051.58
<br />80,744.98
<br />150,764.83
<br />149,014.49
<br />14,117,174.82
<br />15,401,104.23
<br />2,656,307.46
<br />4,586,232.73
<br />1,018,704.86
<br />10,513,644.26
<br />$ 7,851,116.05 $ 48,293,168.36
<br />$ 104,286,440.70 $ 143,409,943.73
<br />854,055.19
<br />1,258,846.58
<br />609,565.25
<br />16,568.26
<br />395,945.00
<br />4,292.06
<br />(2,073.65)
<br />12,367,725.01
<br />495.11
<br />11,839,478.40
<br />8,707,222.15
<br />15,734,666.24
<br />82,697.40
<br />5,228,289.56
<br />40,298.41
<br />(84,714.63)
<br />13,077,268.15
<br />3,716.16
<br />$ 15,505,418.81 $ 54,628,921.84
<br />$ 88,781,021.89
<br />(7,654,302.76)
<br />$ 72,101,100.44
<br />2,032,674.20
<br />(2,316,013.98)
<br />$ 71,817,760.66
<br />$ 88,781,021.89
<br />(6,335,753.48)
<br />73,628,220.22
<br />62,828,670.88
<br />(64,639,130.44)
<br />$ 71,817,760.66
<br />Prepared by the City of Ramsey Finance Department
<br />1/6/2022
<br />
|