|
CITY OF RAAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended September 30, 2023
<br /> September-23 2023
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE(Includes PW Bond Proceeds) $ 111,395,478.42 $ 106154%768.65
<br /> CASH INFLOWS;
<br /> Daily Deposit 2,227,760.86 %126,664.07
<br /> Tax Settlements - 11,051,510.46
<br /> U/B Receipts 36,621.66 1,558,740.81
<br /> Credit Cards(Includes Utility Billing) 253,406.05 3,932,403.20
<br /> Interest Earnings[Net of Interest Paid on Investments] 215,1 I9.36 2,079,379.96
<br /> Bond Proceeds-int - ..
<br /> TOTAL CASH INFLOW $ 2,732,907.93 $ 27,748,698.50
<br /> TOTAL CASH AVAILABLE $ 114,128,386.35 $ 134,298,467.15
<br /> CASH OUTFLOWS;
<br /> Prepaid Checks I1,355,903.35 8,6I3,774.79
<br /> Bills Lists 2,452,786.04 8,169,937.86
<br /> Pay Estimates 5,134,794.47 8,043,381.85
<br /> Credit Cards 24,116.43 80,018.99
<br /> Payroll--Net 716,616.96 4,63%818.31
<br /> Flex Reimbursement (459.79) 143810.69
<br /> Void Checks/Dormant Checks Paid (100.00) (45,401.88)
<br /> Debt Service - 336,287.50
<br /> Miscellaneous [Bank Charges;etc.] 888.33 1,998.48
<br /> l
<br /> TOTAL CASH OUTFLOW $ 9,684,545.79 $ 2%85451626.59
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE $ 104,443,840.56 $ 104,443,840.56
<br /> MEMO-NET 2023 CASH INFLOW(OUTFLOW) (69951,637.86) (211059928.09)
<br /> I
<br /> J
<br /> INVESTMENT PORTFOLIO SUMMARY
<br /> BEGINNING BALANCE-BV $ 82,395,059.64 8996145560.81
<br /> Purchases 643,956.23 28,947,73 6.90
<br /> Maturities/Sales (41,500,000.00) (40,60228 r.
<br /> l
<br /> 960,015.87 77,960015.87 '
<br /> ENDING BALANCE $ 77, , }
<br /> Prepared by the City of Ramsey Finance Department
<br /> 10I312023
<br />
|