|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended November 30, 2023
<br /> November-23 2023
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE(Includes 2022&2023 Bond Proceeds) $ 9%764,569.02 $ 106,5493,768.65
<br /> CASH INFLOWS:
<br /> Daily Deposit 458,967.27 10,7395886.17
<br /> Tax Settlements -- 11,051,510.46
<br /> U/B Receipts 793,938.48 2,3885110.82
<br /> Credit Cards(Includes Utility Billing) 1,70%096.84 65061,022.44
<br /> Interest Earnings [Net of Interest Paid on Investments] 201,778.22 2>533,784.48
<br /> Bond Proceeds--int 85454,005.31 8,454,005.31
<br /> TOTAL CASH INFLOW $ 115617,786.12 $ 415228,319.68
<br /> TOTAL CASH AVAILABLE $ I I I,382,355.14 $ 147,778,088.33
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 3,467,779.08 13,1815571.88
<br /> Bills Lists 1,117,355.68 10,094,512.59
<br /> Pay Estimates 431898,041.03 17,1015845.20
<br /> Credit Cards 12,997.51 993727.55
<br /> Payroll-Net 5025291.81 5,6135711.38
<br /> Flex Reimbursement 2,541.74 193393.73 "
<br /> Void Checks/Dormant Checks Paid (163505.00) (69,053.27)
<br /> Debt Service -- 336,287.50
<br /> Miscellaneous [Bank Charges;etc.] 250.00 2,488.48
<br /> TOTAL CASH OUTFLOW $ %9841751.85 $ 4653805485.04
<br /> gr
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE 10193979603.29 E$: 101,397,603.29
<br /> MEMO-NET 2023 CASH INFLOW(OUTFLOW) 116339034.27 (5,1525165.36)
<br /> JINVESTMENT PORTFOLIO SUMMARY7
<br /> BEGINNING BALANCE-BV $ 735511,999.11 8%6145560.81
<br /> Purchases -- 28,947,736.90
<br /> Maturities/Sales (1,964,476.50) (47)0143775.10)
<br /> ENDING-BALANCE 715547,522.61 $ 71,5479522.61
<br /> Prepared by the City of Ramsey Finance Department
<br /> 12/5/2023
<br />
|