The credit is earned for the performance of the dividend discount model and the free cash flow method approach, the valuation, and the recommendation. Don’t forget to justify the market risk premium, the required rate of return, and the growth rate(s) used in your models. Specifically, you should cover the following: (FOR APPLE COMPANY) Please show excel formulas.

• a.Dividend discount model and the free cash flow method approach - You must operationalize your assumptions in a discounting model. Please explicitly state and clearly explain all assumptions you use in your valuation methodology. Compare your valuation with the current price of the stock. Be careful to show what, when, and how you discount them. Mention and show how sensitive your intrinsic value is to the main assumptions in your model.
• b. Over / Under-valued and Recommendation - Finalize your best estimate of current Vo = Intrinsic Value for the firm and state if the firm is over-or under-valued. Summarize your evaluation of the firm through the entire report and make an investment recommendation on this stock as a security analyst would. Finally, compare your recommendation with those made by financial analysts who cover the same company.
• c. % Return - estimate what your return would be on this firm if you were to trade on your over / under-valuation decision and explain your estimation. Do you believe that the mispricing is transitory or more permanent in nature?

Need to do any of these steps by using Apple actual annual filing please.