|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2023
<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 />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 2023 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE - BV
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />July-23
<br />2023
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 108,838,331.80 $ 106,549,768.65
<br />450,250.50
<br />4,112,181.31
<br />27,281.07
<br />204,160.06
<br />322,363.35
<br />4,565,808.89
<br />10,651,130.10
<br />941,408.02
<br />2,372,500.37
<br />1,436,896.86
<br />$ 5,116,236.29 $ 19,967,744.24
<br />$ 113,954,568.09 $ 126,517,512.89
<br />646,045.79
<br />990,431.47
<br />1,092,765.76
<br />6,895.02
<br />475,450.94
<br />1,920.67
<br />(1,441.00)
<br />236,50
<br />5,507,195.28
<br />5,007,225.98
<br />1,523,440.59
<br />49,855.41
<br />3,440,429.52
<br />14,504.36
<br />(33,515.84)
<br />265,237.50
<br />877.15
<br />3,212,305.15 $ 15,775,249.95
<br />110,742,262.94 1 1 $ 110,742,262.94
<br />1,903,931.14
<br />$ 77,264,103.66
<br />554,843.90
<br />(4,495,000.00)
<br />4,192,494.29
<br />89,614,560.81
<br />10,111,668.59
<br />(26,402,281.84)
<br />73,323,947.56 I $ 73,323,947.56 I
<br />Prepared by the City of Ramsey Finance Department
<br />8/1/2023
<br />
|