|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 2019
<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 />July-19 2019
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 78,386,313.46 $ 77,758,879.57
<br />436,775.80
<br />2,541,996.14
<br />29,952.46
<br />109,960.15
<br />125,767.45
<br />4,056,588.32
<br />7,162,734.82
<br />1,068,130.49
<br />1,712,403.16
<br />948,225.43
<br />TOTAL CASH INFLOW $ 3,244,452.00 $ 14,948,082.22
<br />TOTAL CASH AVAILABLE $ 81,630,765.46 $ 92,706,961.79
<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 />871,313.22
<br />306,799.77
<br />193,388.99
<br />3,900.88
<br />368,960.72
<br />1,877.02
<br />(539.38)
<br />32,602.50
<br />188.73
<br />$ 1,778,492.45
<br />$ 79,852,273.01
<br />1,465,959.55
<br />$ 69,772,009.68
<br />4,713,000.00
<br />(6,067,035.09)
<br />$ 68,417,974.59
<br />Prepared by the City of Ramsey Finance Department
<br />8/21/2019
<br />4,259,002.96
<br />4,159,336.73
<br />853,485.43
<br />37,627.93
<br />2,635,819.30
<br />29,530.82
<br />(46,069.97)
<br />925,273.35
<br />682.23
<br />12,854,688.78
<br />$ 79,852,273.01
<br />2,093,393.44
<br />66,545,332.76
<br />25,248,000.00
<br />(23,375,358.17)
<br />$ 68,417,974.59
<br />
|