|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended April 30, 2023
<br />April-23 2023
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 103,850,961.35 $ 106,549,768.65
<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,244,121.38
<br />10,447.73
<br />79,660.27
<br />122,177.77
<br />2,403, 841.91
<br />289,751.95
<br />479,906.42
<br />1,044,622.96
<br />516,301.73
<br />TOTAL CASH INFLOW $ 1,456,407.15 $ 4,734,424.97
<br />TOTAL CASH AVAILABLE $ 105,307,368.50 $ 111,284,193.62
<br />CASH OUTFLOWS:
<br />Prepaid Checks 630,854.20 3,061,664.94
<br />Bills Lists 777,114.14 2,709,549.07
<br />Pay Estimates 9,197.09
<br />Credit Cards 3,3 01.34 22,265.22
<br />Payroll - Net 463,701.98 2,045,155.03
<br />Flex Reimbursement 2,098.64 6,582.00
<br />Void Checks/Dormant Checks Paid (24,894.23) (25,336.81)
<br />Debt Service .-
<br />Miscellaneous [Bank Charges; etc.] 253.00 177.65
<br />TOTAL CASH OUTFLOW $ 1,852,429.07 $ 7,829,254.19
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE I $ 103,454,939.43 I $ 103,454,939.43 I
<br />MEMO - NET 2023 CASH INFLOW ( OUTFLOW) (396,021.92) (3,094,829.22)
<br />'INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE - BV
<br />$ 89,242,984.65 89,614,560.81
<br />Purchases 1,092,112.18 8,467,817.86
<br />Maturities/Sales (1,855,000.00) (9,602,281.84)
<br />ENDING BALANCE I $ 88,480,096.83 I I $ 88,480,096.83
<br />Prepared by the City of Ramsey Finance Departtnent
<br />5/15/2023
<br />
|