|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30, 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 />November-19 2019
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 81,658,626.75 $ 77,758,879.57
<br />905,728.05
<br />707,018.79
<br />839,922.49
<br />107,449.30
<br />10,296,587.16
<br />7,162,734.82
<br />2,386,168.55
<br />3,626,170.67
<br />1,456,771.69
<br />TOTAL CASH INFLOW $ 2,560,118.63 $ 24,928,432.89
<br />TOTAL CASH AVAILABLE $ 84,218,745.38 $ 102,687,312.46
<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 />812,648.70
<br />452,214.70
<br />54,415.72
<br />6,226.20
<br />545,099.74
<br />1,504.32
<br />(31.26)
<br />343,681.25
<br />112.00
<br />7,3 89,147.26
<br />6,079,489.42
<br />1,696,264.97
<br />61,239.52
<br />4,262,989.31
<br />42,226.20
<br />(116,996.06)
<br />1,268,954.60
<br />1,123.23
<br />$ 2,215,871.37 $ 20,684,438.45
<br />$ 82,002,874.01
<br />344,247.26
<br />$ 70,959,863.96
<br />3,790,000.00
<br />(2,895,034.71)
<br />$ 71,854,829.25
<br />Prepared by the City of Ramsey Finance Department
<br />12/19/2019
<br />$ 82,002,874.01
<br />4,243,994.44
<br />66,545,332.76
<br />39,593,000.00
<br />(34,283,503.51)
<br />$ 71,854,829.25
<br />
|