1. Choose the best company to invest from a list of 10 companies (in Excel page) based on dividend yield, capital gains yield and the required returns on your stocks (based on the dividend growth model). Calculate the required indicators and analyze the results.
2. What will be the share prices of the selected company in 4 years, considering the dividend growth model, if the required rate of return is 10%?

* You should describe each step in detail and provide intermediate calculations. Add tables from Excel if necessary.

* Do not delete anything from the Word file.

* Write your answers after each question.

* Be careful when rounding. Leave two decimal places.

28 29 Question 3 Expedia The Kraft Trip.com Group DocuSign, Dollar Group, Texas Heinz Limited Inc. Tree Inc. eBay Inc. Electronic Arts Exelon Inc. Tesla, Inc. Instruments Company American Common Common Common Inc. Common Corporation Common Common Incorporated Common Depositary Stock Stock Stock Stock Common Stock Stock Stock Common Stock Stock Shares $ 115.00$ 90.50 $ 57.72 $ 140.45$ 37.34 $ 87.60 $ 1,428.36 $ 138.28 $ 36.02 $ 28.29 2.3% 3.7% 0.7% 1.9% 2.1% 0.4% 0.6% 0.5% 0.6% 1.0% 30 31 Stock price 32 Growth rate 2.34 DPS Dividend per share 33 (just paid annual dividend) $ 12.36 $ 8.12 $ 34 EPS Earnings per share $ 21.01 $ 13.80 $ 35 4.57 $ 7.58 $ 12.80 $ 21.76 $ 2.58 $ 7.16 $ 4.39 $ 12.17 $ 129.30 $ 219.81 $ 12.07 $ 20.52 $ 3.58 $ 6.09 $ 3.98