|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2021
<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 />August-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 91,235,173.80 $ 95,116,775.37
<br />788,325.05
<br />719,856.78
<br />1,105,095.38
<br />78,528.55
<br />9,150,067.90
<br />8,355,052.65
<br />1,762,484.21
<br />3,086,192.02
<br />652,001.92
<br />1,166.74
<br />TOTAL CASH INFLOW $ 2,691,805.76 $ 23,006,965.44
<br />TOTAL CASH AVAILABLE $ 93,926,979.56 $ 118,123,740.81
<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 />1,150,282.92
<br />858,038.89
<br />2,352,618.93
<br />4,290,38
<br />405,334.42
<br />4,420.43
<br />(65,919.25)
<br />68,407.50
<br />166.50
<br />8,075,839.17
<br />5,099,394.32
<br />12,024,923.63
<br />42,620.64
<br />3,409,366.99
<br />29,875.01
<br />(67,496.39)
<br />357,711.89
<br />2,166.71
<br />$ 4,777,640.72 $ 28,974,401.97
<br />$ 89,149,338.84
<br />(2,085,834.96)
<br />$ 72,817,517.60
<br />9,73 5,894.09
<br />(10,645,000.00)
<br />$ 71,908,411.69
<br />$ 89,149,338.84
<br />(5,967,436.53)
<br />73,628,220.22
<br />56,426,392.60
<br />(58,146,201.13)
<br />$ 71,908,411.69
<br />Prepared by the City of Ramsey Finance Department
<br />9/3/2021
<br />
|