|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended January 31, 2017
<br />CASH AND TEMPORARY INVESTMENTS
<br />BEGINNING BALANCE
<br />CASH INFLOWS:
<br />Daily Deposit
<br />Tax Settlements
<br />U/B Receipts
<br />Credit Cards
<br />Interest Earnings [Net of Interest Paid on Investments]
<br />Bond Proceeds
<br />January-17 2017
<br />CURRENT MONTH YEAR-TO-DATE
<br />$ 64,912,887.39 $ 64,912,887.39
<br />207,216.25
<br />158,808.75
<br />27,298.40
<br />22,290.48
<br />43,388.86
<br />207,216.25
<br />158,808.75
<br />27,298.40
<br />22,290.48
<br />43,388.86
<br />TOTAL CASH INFLOW $ 459,002.74 $ 459,002.74
<br />TOTAL CASH AVAILABLE $ 65,371,890.13 $ 65,371,890.13
<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 2016 CASH INFLOW ( OUTFLOW)
<br />INVESTMENT PORTFOLIO SUMMARY
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />764,466.71
<br />263,989.48
<br />283,687.00
<br />2,501,66
<br />292,893.85
<br />1,498.24
<br />(200.00)
<br />525,942.50
<br />100.00
<br />764,466.71
<br />263,989.48
<br />283,687.00
<br />2,501,66
<br />292,893.85
<br />1,489.24
<br />(200.00)
<br />525,942.50
<br />100.00
<br />$ 2,134,879.44 $ 2,134,870.44
<br />$ 63,237,010.69
<br />(1,675,876.70)
<br />$ 57,425,022.30
<br />1,355,000.00
<br />(1,759,585.10)
<br />$ 57,020,437.20
<br />$ 63,237,019.69
<br />(1,675,867.70)
<br />57,425,022.30
<br />1,355,000.00
<br />(1,759,585.10)
<br />$ 57,020,437.20
<br />Prepared by the City of Ramsey Finance Department
<br />2/9/2017
<br />
|