Question: Please show work using excel and show formulas as well. Thank you Full Boat Manufacturing has projected sales of $117.5 million next year. Costs are

Please show work using excel and show formulas as well. Thank you
Full Boat Manufacturing has projected sales of $117.5 million next year. Costs are expected to be $68.8 million and net investment is expected to be $12.9 million. Each of these values is expected to grow at 9 percent the following year, with the growth rate declining by 1 percent per year until the growth rate reaches 5 percent, where it is expected to remain indefinitely. There are 4.7 million shares of stock outstanding and investors require a return of 12 percent return on the company's stock. The corporate tax rate is 25 percent a. What is your estimate of the current stock price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Suppose instead that you estimate the terminal value of the company using a PE multiple. The industry PE multiple is 10. What is your new estimate of the company's stock price? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Share price b. Share price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
