|
CITY OF RAMSEY
<br /> REPORT OF POOLED CASH FLOWS
<br /> Period Ended. May 31, 2022
<br /> May-22 2022
<br /> CURRENT MONTH YEAR-TO-DATE
<br /> CASH AND TEMPORARY INVESTMENTS
<br /> BEGINNING BALANCE(Includes PW Band Proceeds) $ 8650345616.25 $ 88,776,714.25
<br /> CASH INFLOWS;
<br /> Daily Deposit 318,622.60 4,949,156.93
<br /> Tax Settlements -- 201,871.91
<br /> U113 Receipts 461,085.74 995,345.30
<br /> Credit Cards(Includes Utility Billing) 748,733.58 1,998,360.38
<br /> Interest Earnings [Net of Interest Paid on Investments] 73,588.74 3871,029.66
<br /> Bond Proceeds--int --
<br /> TOTAL CASK INFLOW $ 1,602,030.66 $ 8,531,764.18
<br /> TOTAL CASH AVAILABLE $ 87,636,646.91 $ 97,308,478.43
<br /> CASH OUTFLOWS:
<br /> Prepaid Checks 655,303.16 4)607)094.69
<br /> i
<br /> Bills Lists 65704.63 39495,084.96
<br /> Pay Estimates 501,271.82 1,496,664.39
<br /> Credit Cards 4,462.85 289506.12
<br /> Payroll--Net 4173918.38 2,276,910.92
<br /> Flex Reimbursement 2,004.89 133702.00
<br /> Void Checks/Dormant Checks Paid (8,487.03) (17,343.54)
<br /> Debt Service 48,831.25 48,831.25
<br /> Miscellaneous [Bank Charges;etc.]. 478.44 1,859.12
<br /> f
<br /> I
<br /> TOTAL CASH OUTFLOW $ 27 9 3 279 478.39 $ 11 9517 309.91
<br /> I
<br /> POOLED CASH.AND TEMPORARY INVESTMENTS
<br /> ENDING BALANCE $ 855357,168.52 E$ 85,357,168.52
<br /> MEMO-NET 2022 CASH INFLOW(OUTFLOW) (677,447.73) (3)4195545.73)
<br /> JINVESTMENT PORTFOLIO SUMMARY
<br /> E B GINNING BALANCE 719188,495.11 71,8179760.66
<br /> Purchases 105,000.00 7,490.9668.35 s
<br /> Maturities/Sales (805,009.04) (8)819,942.94) }
<br /> ENDING BALANCE $ 70,488,486.07 $ 7054885486.07
<br /> 1
<br /> is
<br /> rr:
<br /> s'
<br /> Prepared by the City of Ramsey Finance Department
<br /> 6/3/2022 l
<br />
|