|
CITY OF RAMSEY
<br />REPORT OF POOLED CASH FLOWS
<br />Period Ended July 31, 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
<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 I
<br />BEGINNING BALANCE
<br />Purchases
<br />Maturities/Sales
<br />ENDING BALANCE
<br />July-17
<br />CURRENT MONTH
<br />64,597,395.95
<br />1,038,883.21
<br />2,159,832.19
<br />21,518.58
<br />178,113.51
<br />48,458.18
<br />$ 3,446,805.67
<br />$ 68,044,201.62
<br />604,259.02
<br />411,135.80
<br />223,514.53
<br />6,624.02
<br />324,040.05
<br />2,199.90
<br />(3,262.13)
<br />39,792.50
<br />28.00
<br />2017
<br />YEAR-TO-DATE
<br />$ 64,912,887.39
<br />4,816,686.08
<br />6,218,640.94
<br />1,409,780.08
<br />1,155,596.09
<br />513,727.28
<br />14,114,430.47
<br />$ 79,027,317.86
<br />1,608,331.69 $
<br />66,435,869.93 I $
<br />1,838,473.98
<br />$ 57,682,673.06
<br />3,477,000.00
<br />(1,500,990.25)
<br />$ 59,658,682.81 I I $
<br />Prepared by the City of Ramsey Finance Department
<br />8/1/2017
<br />4,711,579.60
<br />3,575,083.98
<br />896,908.58
<br />29,741.51
<br />2,311,054.55
<br />33,185.77
<br />(44,516.51)
<br />1,078,066.26
<br />344.19
<br />12,591,447.93
<br />66,435,869.93
<br />1,522,982.54
<br />57,425,022.30
<br />14,550,000.00
<br />(12,316,339.49)
<br />59,658,682.81 I
<br />
|