|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2023
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes Pam' 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-23 2023
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 1105742,262.97 $ 1065549,768.65
<br />2,3335094.32
<br />400,380.36
<br />580,711.13
<br />131306,496.71
<br />39%250.58
<br />6,8981,903.21
<br />11,051,510.46
<br />1,522,119.15
<br />3,678,997.11
<br />1,836,147.44
<br />TOTAL CASH INFLOW
<br />$ 5,019,933.10
<br />$ 24,987,677.37
<br />TOTAL CASH AVAILABLE
<br />$ 115,762,196.07
<br />$ 131,537,446.02
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />1,750,676.16
<br />7,2575871.44
<br />Bills Lists
<br />70%925.84
<br />5,717,151.82
<br />Pay Estimates
<br />1,385,146.79
<br />2,908,587.38
<br />Credit Cards
<br />65047.15
<br />55,902.56
<br />Payroll -- Net
<br />4825771.83
<br />3,923,201.35
<br />Flex Reimbursement
<br />766.12
<br />15,270.48
<br />Void Checks/Dormant Checks Paid
<br />(11,685.29)
<br />(45,201.13)
<br />Debt Service
<br />71,050.00
<br />336,287.50
<br />Miscellaneous [Bank Charges; etc.]
<br />943.19
<br />1,820.34
<br />TOTAL CASH OUTFLOW
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />MEMO - NET 2023 CASH INFLOW ( OUTFLOW)
<br />JINVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE - BV
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />$ 4,395ML79 $ 20,170,891.74
<br />$ 111,3665554.28 $ 1115366,554.28
<br />6245291.31 4,816,785.63
<br />$ 73,3239947.56
<br />8%614,560.81
<br />18,77 1, 112.08
<br />2802,780.67
<br />(91700,000.00)
<br />(36,102,281.84)
<br />$ 82,395,059.64
<br />$ 82,395,059.64
<br />Prepared by the City of Ramsey Finance Department
<br />9/5/2023
<br />
|