|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended November 30, 2017
<br />CASH AND TEMPORARY INVESTMENTS I
<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 />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 2017 CASH INFLOW ( OUTFLOW)
<br />!INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />November-17
<br />CURRENT MONTH
<br />2017
<br />YEAR-TO-DATE
<br />$ 65,914,790.40 $ 64,912,887.39
<br />1,901,676.50 8,329,551.37
<br />6,218,640.94
<br />740,759.41 2, 894, 985.47
<br />614,434.69 2,962,514.49
<br />102,895.43 848,531.03
<br />863,473.61
<br />$ 3,359,766.03 $ 22,117,696.91
<br />$ 69,274,556.43 $ 87,030,584.30
<br />591,710.00
<br />525,262.20
<br />713,604.69
<br />10,031.19
<br />304,268.80
<br />3,193.99
<br />(892.93)
<br />1,754,953.76
<br />31.50
<br />3,902,163.20 $
<br />65,372,393.23 I I $
<br />(542,397.17)
<br />$ 58,565,480.18
<br />2,120,000.00
<br />(2,901,985.56)
<br />57,783,494.62 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />12/6/2017
<br />7,097,510.09
<br />5,213,329.96
<br />2,855,885.32
<br />63,975.20
<br />3,551,725.54
<br />50,101.66
<br />(72,995.16)
<br />2,898,198.77
<br />459.69
<br />21,658,191.07
<br />65,372,393.23 I
<br />459,505.84
<br />57,425,022.30
<br />20,459,000.00
<br />(20,100,527.68)
<br />57,783,494.62 I
<br />
|