|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June 30, 2021
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE (Includes PW Bond Proceeds)
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Credit Cards (Includes Utility Billing)
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Band Proceeds-int
<br />TOTAL CASH INFLOW
<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 2021 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />June-21 2021
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 86,564,058.91 $ 95,116,775.37
<br />912,038.65
<br />4,517,137.59
<br />63,970.00
<br />111,415.43
<br />148,459.28
<br />4,741,032.46
<br />4,891,886.80
<br />1,021,482.38
<br />1,825,188.83
<br />498,978.67
<br />1,166.74
<br />$ 5,753,020.95 $ 12,979,735.88
<br />$ 92,317,079.86 $ 108,096,511.25
<br />1,362,324.34
<br />544,679.97
<br />1,887,278.77
<br />9,613.50
<br />405,499.94
<br />1,548.85
<br />(406.96)
<br />289,304.39
<br />163.00
<br />6,03 9,782.91
<br />3,675,801.32
<br />7,626,392.40
<br />35,178.35
<br />2,588,843.49
<br />24,032.11
<br />(1,277.29)
<br />289,304.39
<br />1,379.51
<br />$ 4,500,005.80 $ 20,279,437.19
<br />$ 87,817,074.06
<br />1,253,015.15
<br />$ 73,125,747.79
<br />3,810,000.00
<br />(3,703,243.76)
<br />$ 73,23 2,504.03
<br />$ 87,817,074.06
<br />(7,299,701.31)
<br />73,628,220.22
<br />40,792,150.11
<br />(41,187,866.30)
<br />$ 73,232,504.03
<br />Prepared by the City of Ramsey Finance Department
<br />7/15/2021
<br />
|