Question: FCF Forecast ($ million) Year 0 1 2 3 4 Sales 240 Growth versus Prior Year 12.50% 7.40% 6.90% 5.00% EBIT (10% of Sales) Less:
| FCF Forecast ($ million) | |||||
| Year | 0 | 1 | 2 | 3 | 4 |
| Sales | 240 | ||||
| Growth versus Prior Year | 12.50% | 7.40% | 6.90% | 5.00% | |
| EBIT (10% of Sales) | |||||
| Less: Income Tax (37%) | |||||
| Less Increase in NWC (12% of Change in Sales) | |||||
| Free Cash Flow |
Banco Industries expect sales to grow at a rapid rate over the next three years, but settle to an industry growth rate in year 4. The spreadsheet above is a template for forecasting Banco Industries' free cash flows (FCFs), with assumptions provided.
a) (8 points) Forecast Banco Industries' FCFs in year 1-4. Banco Industries's FCF is expected to be $Answer million in year 1, $Answer million in year 2, $Answer million in year 3, $Answer million in year 4. State your answers in 2 decimal places.
b) (4 points) Banco Industries expect sales to settle to an industry growth rate of 5% in year 4 and after. If Banco industries has a weighted average cost of capital of 11%, $50 million in cash, $80 million in debt, and 18 million shares outstanding, the best estimate of Banco's stock price is $Answer. (1 decimal place)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
