This project is based on the WOK YOW IMPORTS, INC. case found in your textbook under Chapter 14.Please read the case carefully.An excel spreadsheet is provided that has the solution to the case along with suggested answers to the case questions.Please go over the excel sheet first and make sure that you can follow the calculations for the discounted cash flow valuation method (enterprise valuation method).

All the formulas are built into the excel file so when you go over a cell, you can track how the calculation for each number on the sheet is done.Pay special attention to the financial ratios, growth assumptions, calculation of the free cash flows for the foreseeable future (5 years) and the calculation of the terminal value.These future free cash flows are then discounted back to time zero using the discount rate (WACC).

:

Using the provided financial statements as a starting point:

1. The DCF valuation and pro forma financials with five years of forecasted growth rates are provided in the original model.Please modify the model to consider a more successful scenario where Wok Yow's sales grow at a more aggressive pace of 40% for five years and then flatten to a more sustainable growth rate of 7%.What would the stock value per share be under the new scenario? What kind of strategic changes you would make in the business model to justify the growth assumption?How would you do things differently?You can use fictional events to justify your assumptions.

1. present DCF valuations and pro forma financial statements (five-year explicit period) that justify a $31 and a $56 share price. You can play with the model assumptions to get to these valuations. Propose two different business plans that would be targeting these two different outcomes.Make sure the ratios embedded in your projections conform to reasonable operating ratio assumptions in the models. Also remember that higher risk business strategies come with higher expected returns.

1. Discuss the $31 and $56 IPO prices for Wok Yow within the context of comparable firms and their multiples.You can use some outside reference materials from companies in similar industries for comparison purposes. Then take a position on whether you would recommend the $31 or $56 IPO.Which one is more feasible?Take a position on which of the two business plans you would invest in as an investor, which financial instrument of the company you would want to invest in and what kind of a return you would expect on your money.

1. executive summary discussing the events and decisions leading to its current situation, the options it currently has moving forward, and your recommendations for Wok Yow's near future. The events in the summary will be fictional.

I finished a I just need to find the reason why the sales growth 40, do you need the excell