|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended June 30, 2022
<br /> June--22 2022
<br /> CURRENT MONTH YEAR-TO--DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE(Includes PW Bond Proceeds) $ 85,357,168.52 $ 88,776,714.25
<br /> CASH INFLOWS;
<br /> Daily Deposit 10%412.04 55L058,568.97
<br /> Tax Settlements 4,969,957.95 5,171,829.86
<br /> U/B Receipts 353001.63 1,030,346.93
<br /> Credit Cards(Includes Utility Billing) 148,876.93 2,147,237.31 1
<br /> I
<br /> Interest Earnings[Net of Interest Paid on Investments] 146,546.01 533,575.67
<br /> Bond Proceeds-int .-
<br /> i
<br /> 3
<br /> TOTAL CASH INFLOW $ 5,409,794.56 $ 13,941,558.74
<br /> TOTAL CASH AVAILABLE $ 90,766,963.08 $ 102,718,272.99
<br /> CASH OUTFLOWS;
<br /> Prepaid Checks 693,820.10 5,300,914.79
<br /> Bills Lists 758,633.21 4,253,718.17
<br /> Pay Estimates 786 834.53 2283498.92
<br /> 7 7 7
<br /> z?.
<br /> Credit Cards 13,308.75 41,814.87 Fvl
<br /> Payroll--Net 426,113.90 2,703,024.82
<br /> i.
<br /> Flex Reimbursement 4,4.68..99 18,170.99
<br /> Void Checks/Dormant Checks Paid (25600.00) (19,943.54)
<br /> Debt Service 2805431.81 32%263.06
<br /> Miscellaneous [Bank Charges;etc.] 630.87 2,489.99
<br /> TOTAL CASH OUTFLOW $ 2,961,642.16 $ 14,9125952.07 l
<br /> POOLED CASH AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE $ 87,805,320.92 8798059320.92
<br /> MEMO-NET 2022 CASH INFLOW(OUTFLOW). 25448,152.40 (9719393.33) r
<br /> JINVESTMENT PORTFOLIO SUMMARY
<br /> BEGINNING-BALANCE 705488,486.07 71,817,760.66
<br /> Purchases - 7,490,668.3 5
<br /> I
<br /> Maturities/Sales (570 005.56) (9 389 948.50)
<br /> ENDING BALANCE $ 695918,480.51 $ 699918,480.51
<br /> Prepared by the City of Ramsey Finance Department
<br /> 7/15/2022
<br />
|