Using the resources available on the Internet, build a spreadsheet to calculate the intrinsic value of Apollo Medical Holdings Inc. For firms that pay substantial dividends, you should include a model using at least a 3-stage (i.e. 3 different near term growth patterns ending with a constant growth assumption) Dividend Discount Model. In the event that your stock does not pay a substantial dividend (> 1% dividend yield), then complete this assignment using Procter & Gamble (PG). Make sure you state all of the assumptions used to generate this value. You must also show all of your work. Make sure you demonstrate all of the techniques discussed in class for estimating each of the assumed variables. (i.e. 4 methods for estimating required return, 2 methods for estimating constant growth.) In doing so you will generate at least 8 price estimates. Remember that your goal is to identify an appropriate price range for the stock. How does your value compare to the actual price? What are some of the reasons for any discrepancy? [Hint do not use the H-model]

Answer on excel and attach pictures, by showing formulas. Just explaining me what do to won't help me.