|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended February 28, 2021
<br />February-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 92,250,330.73 $ 95,116,775.37
<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 />1,580,775.28
<br />436,235.73
<br />634,554.61
<br />84,989.75
<br />(407.74)
<br />2,028,718.60
<br />374,749.21
<br />446,123.70
<br />781,547.25
<br />133,845.00
<br />859.12
<br />TOTAL CASH INFLOW $ 2,736,147.63 $ 3,765,842.88
<br />TOTAL CASH AVAILABLE $ 94,986,478.36 $ 98,882,618.25
<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,948,885.68
<br />656,265.49
<br />456,386.50
<br />4,426.81
<br />399,616.55
<br />6,024.52
<br />177.50
<br />$ 3,471,783.05
<br />$ 91,514,695.31
<br />2,796,091.30 .
<br />1,541,244.89
<br />2,223,859.96
<br />8,015.51
<br />789,866.46
<br />8,525.03
<br />(188.20)
<br />507.99
<br />7,367,922.94
<br />$ 91,514,695.31
<br />(735,635.42) (3,602,080.06)
<br />$ 73,093,043.90
<br />24,834,659.36
<br />(24,444,716.80)
<br />$ 73,482,986.46
<br />73,628,220.22
<br />29,404,659.36
<br />(29,549,893.12)
<br />$ 73,482,986.46
<br />Prepared by the City of Ramsey Finance Department
<br />3/2/2021
<br />
|