|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended August 31, 2022
<br />August-22 2022
<br />CURRENT MONTH YEAR-TO-DATE
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds) $ 90,919,773.65 $ 88,776,714.25
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />UB Receipts
<br />Credit Cards (Includes Utility Billing)
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds-int
<br />192, 743.02
<br />642,673.66
<br />602,167.23
<br />927,880.35
<br />100,124.62
<br />TOTAL CASH INFLOW $ 2,465,588.88
<br />TOTAL CASH AVAILABLE
<br />CASH OUTFLOWS:
<br />Prepaid Checks
<br />Bills Lists
<br />Pay Estimates
<br />Credit Cards
<br />Payroll - Net
<br />Flex Reimbursement
<br />Void Checks/Dormant Checks Paid
<br />Debt Service
<br />Miscellaneous {Bank Charges; etc.]
<br />TOTAL CASH OUTFLOW
<br />POOLED CASH AND TEMPORARY INVESTMENTS
<br />ENDING BALANCE
<br />MEMO - NET 2022 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />7,527,185.20
<br />9,684,372.85
<br />1,649,723.00
<br />3,223,221.96
<br />742,704.88
<br />22,827,207.89
<br />93,3 85,362.53 $ 111,603,922.14
<br />1,025,700.39
<br />599,504.86
<br />215,209.08
<br />4,312.32
<br />429,087.16
<br />4,868.45
<br />(5,990.00)
<br />72,595.00
<br />194.20
<br />7,935,924.90
<br />5,420,525.51
<br />3,206,890.76
<br />50,003.73
<br />3,544,797.59
<br />26,439.95
<br />(25,933.54)
<br />401,858.06
<br />3,534.11
<br />$ 2,345,481.46 $ 20,564,041.07
<br />$ 91,039,881.07
<br />120,107.42
<br />$ 69,371,138.39
<br />20,556,046.88-
<br />(300,001.80)
<br />$ 89,627,183.47
<br />$ 91,039,881.07
<br />2,263,166.82
<br />71,817,760.66
<br />28,296,715.23
<br />(10,487,292.42)
<br />$ 89,627,183.47
<br />Prepared by the City of Ramsey Finance Department
<br />9/2/2022
<br />
|