|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2021
<br />CASH AND TEMPORARY INVESTMENTS
<br />July-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 87,817,074.06 $ 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 />3,620,710.39
<br />3,463,165.85
<br />21,145.05
<br />155,907.81
<br />74,494.70
<br />8,361,742.85
<br />8,355,052.65
<br />1,042,627.43
<br />1,981,096.64
<br />573,473.37
<br />1,166.74
<br />TOTAL CASH INFLOW $ 7,335,423.80 $ 20,315,159.68
<br />TOTAL CASH AVAILABLE $ 95,152,497.86 $ 115,431,935.05
<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 />885,773.34
<br />565,554.11
<br />2,045,912.30
<br />3,151.91.
<br />415,189.08
<br />1,422.47
<br />(299.85)
<br />620.70
<br />6,925,556.25
<br />4,241,355.43
<br />' 9,672,304.70
<br />38,330.26
<br />3,004,032.57
<br />25,454.58
<br />(1,577.14)
<br />289,304.39
<br />2,000.21
<br />3,917,324.06 $ 24,196,761.25
<br />$ 91,235,173.80
<br />3,418,099.74
<br />$ 73,232,504.03
<br />5,898,348.40
<br />(6,313,334.83)
<br />$ 72,817,517.60
<br />$ 91,235,173.80
<br />(3,881,601.57)
<br />73,628,220.22
<br />46,690,498.51
<br />(47,501,201.13)
<br />$ 72,817,517.60
<br />Prepared by the City of Ramsey Finance Department
<br />8/17/2021
<br />
|