|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2022
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PVC Bond Proceeds)
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />UB Receipts
<br />Credit Cards (Includes Utility Billing)
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds-int
<br />July-22 2022
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 87,805,320.92 $ 88,776,714.25
<br />2,275,873.21
<br />3,869,869.33
<br />17,208.84
<br />148,104.30
<br />109,004.59
<br />7,334,442.18
<br />9,041,699.19
<br />1,047,555.77
<br />2,295,341.61
<br />642,580.26
<br />TOTAL CASH INFLOW $ 6,420,060.27 $ 20,361,619.01
<br />TOTAL CASH AVAILABLE $ 94,225,3 81.19 $ 109,138,333.26
<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 />1,609,309.72
<br />567,302.48
<br />708,182.76
<br />3,876.54
<br />412,685.61
<br />3,400,51
<br />849.92
<br />6,910,224.51
<br />4,821,020.65
<br />2,991,681.68
<br />45,691.41
<br />3,115,710.43
<br />21,571.50
<br />(19,943.54)
<br />329,263.06
<br />3,339.91
<br />3,305,607.54 $ 18,218,559.61
<br />$ 90,919,773.65
<br />3,114,452.73
<br />$ 69,918,480.51
<br />250,000.00
<br />(797,342.12)
<br />$ 69,371,138.39
<br />$ 90,919,773.65
<br />2,143,059.40
<br />71,817,760.66
<br />7,740,668.35
<br />(10,187,290.62)
<br />$ 69,371,138.39
<br />Prepared by the City of Ramsey Finance Department
<br />8/2/2022
<br />
|