|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended October 31, 1023
<br /> October-23 2023
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE(Includes PAY Bond Proceeds) $ 104,444,330.56 $ 106,54%768.65
<br /> CASH INFLOWS.-
<br /> Daily Deposit 1,1543254.83 10,280,918.90
<br /> Tax Settlements -- 11,051,510.46
<br /> U/B Receipts 35,431.53 1,594,172.34
<br /> Credit Cards(Includes Utility Billing) 418,174.40 4,350,577.60
<br /> Interest Earnings [Net of Interest Paid on Investments] 252,626.30 2,332,006.26
<br /> Bond Proceeds-int
<br /> TOTAL CASH INFLOW $ 1,8605487.06 $ 29,609,185.56
<br /> TOTAL CASH AVAILABLE $ 106,304,817.62 $ 136,158,954.21
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 1,100,018.01 9,713,792.80
<br /> Bills Lists 807,219.05 8,977,156.91
<br /> Pay Estimates 4,160,422.32 12,203,804.17
<br /> Credit Cards 7,201.05 86,730.04
<br /> Payroll-Net 4715601.26 5 3111,419.57
<br /> Flex Reimbursement 2,171.30 16,981.99
<br /> Void Checks/Dormant Checks Paid (71146.39) (52,548.27)
<br /> Debt Service - 336,287.50
<br /> Miscellaneous[Bank Charges;etc.] 240.00 2,238.48
<br /> TOTAL CASH OUTFLOW $ 6,541,726.60 $ 36,395,863.19
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING-BALANCE $ 99,7631091. 99,763,091.02
<br /> MEMO-NET 2023 CASH INFLOW(OUTFLOW) (456819239.54) (657869677.63)
<br /> JINVESTMENT PORTFOLIO SUMMARY
<br /> F•'
<br /> BEGINNING BALANCE-BV 779960,015.87 899614,560.81
<br /> Purchases -- 28,947,736.90
<br /> MaturitieslSales 4 448 016.76 45 050 298.60
<br /> s.
<br /> ENDING BALANCE $ 73,5115999.1 73,5113999.11
<br /> Prepared by the City of Ramsey Finance Department
<br /> 1112l2023
<br /> l
<br />
|