Using the resources available on the Internet, build a spreadsheet to calculate the intrinsic value for Apollo Medical Holdings, Inc. (AMEH) for your stock report. 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]