|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended June 30, 2020
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<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 />Bond Proceeds
<br />June-20 2020
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 80,289,239,97 $ 84,144,038.99
<br />1,660,428.35
<br />3,400,000.00
<br />87,778.20
<br />114,441.11
<br />197,005.63
<br />5,212,723.87
<br />3,516,640.63
<br />1,005,151.19
<br />1,726,070.49
<br />882,972.99
<br />TOTAL CASH INFLOW $ 5,459,653.29 $ 12,343,559.17
<br />TOTAL CASH AVAILABLE $ 85,748,893.26 $ 96,487,598.16
<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 2019 CASH INFLOW ( OUTFLOW)
<br />(INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />635,430.93
<br />472,316.38
<br />10,436.50
<br />398,205.07
<br />4,157.05
<br />(866.82)
<br />256,178.76
<br />149.00
<br />4,641, 792.94
<br />2,893,487.81
<br />33,172.22
<br />2,425,271.22
<br />23,388.76
<br />(46,463.03)
<br />2,543,332.35
<br />729.50
<br />$ 1,776,006.87 $ 12,514,711.77
<br />$ 83,972,886.39
<br />3,683,646.42
<br />$ 66,286,984.23
<br />4,968,338.71
<br />(4,608,031.01)
<br />$ 66,647,291.93
<br />Prepared by the City of Ramsey Finance Department
<br />7/16/2020
<br />$ 83,972,886.39
<br />(171,152.60)
<br />73,537,171.61
<br />21,893,338.71
<br />(28,783,218.39)
<br />$ 66,647,291.93
<br />
|