|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended December 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 />December-19 2019
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 82,002,874.01 $ 77,758,879.57
<br />490,698.75
<br />6,233,464.89
<br />78,757.69
<br />121,584.53
<br />201,386.01
<br />10,787,285.91
<br />13,396,199.71
<br />2,464,926.24
<br />3,747,755.20
<br />1,658,157.70
<br />TOTAL CASH INFLOW $ 7,125,891.87 $ 32,054,324.76
<br />TOTAL CASH AVAILABLE $ 89,128,765.88 $ 109,813,204.33
<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 />1,988,162.78
<br />522,442.73
<br />399,525.83
<br />11,479.04
<br />361,296.44
<br />1,805.41
<br />(1,286.10)
<br />1,701,188.76
<br />112.00
<br />9,377,310.04
<br />6,601,932.15
<br />2,095,790.80
<br />72,718.56
<br />4,624,285.75
<br />44,031.61
<br />(118,282.16)
<br />2,970,143.36
<br />1,235.23
<br />$ 4,984,726.89 $ 25,669,165.34
<br />$ 84,144,038.99
<br />2,141,164.98
<br />$ 71,854,829.25
<br />5,341,383.46
<br />(3,659,041.10)
<br />$ 73,537,171.61
<br />Prepared by the City of Ramsey Finance Department
<br />1/6/2020
<br />$ 84,144,038.99
<br />6,385,159.42
<br />66,545,332.76
<br />44,934,383.46
<br />(37,942,544.61)
<br />$ 73,537,171.61
<br />
|