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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started