I need some help in Finance projects
cvyney200
fcfforcast_template.xlsSheet1
| Free Cash Flow Forecast Template | |||||
| Appl Inc. | |||||
| (billions of dollars) | |||||
| 2015 | 2016 | 2017 | 2018 | ||
| Sales | $233.7 | $252.4 | $272.6 | $294.4 | |
| % increase | 8.0% | ||||
| EBIT | 71.2 | ||||
| Depreciation | 11.2 | ||||
| EBITDA | 82.4 | 89.8 | 97.9 | 106.7 | |
| % increase | 9.0% | ||||
| Tax Expenses | 19.1 | 20.8 | 22.7 | 24.7 | |
| % increase | 9.0% | ||||
| Operating Cash flow | 63.3 | 69.0 | 75.2 | 82.0 | |
| Capex | 11.2 | 12.0 | 12.8 | 13.7 | |
| % increase | 7.0% | ||||
| YoY increse in w/capital | 4 | 4.3 | 4.7 | 5.0 | |
| % increase | 8.0% | ||||
| Levered Free cash flow | $48.10 | $52.69 | $57.72 | $63.22 | |
| growth rate | 9.55% | 9.54% | 9.53% |
