Question No 3. (Marks 4)

Use the data set which is labeled on your name in Excel sheet. Names are given alphabetical from A to Z. [ Click on left or right to find the sheet with your name]

According to this information :

Question 3
	DocuSign, Inc. Common Stock	Dollar Tree Inc. Common Stock	eBay Inc. Common Stock	Electronic Arts Inc. Common Stock	Exelon Corporation Common Stock	Expedia Group, Inc. Common Stock	Tesla, Inc. Common Stock	Texas Instruments Incorporated Common Stock	The Kraft Heinz Company Common Stock	Trip.com Group Limited American Depositary Shares
Stock price	$ 168.00	$ 91.58	$ 68.25	$ 103.00	$ 39.54	$ 87.60	$ 1,428.36	$ 138.28	$ 36.02	$ 28.29
Growth rate	2.1%	1.5%	0.8%	1.9%	1.8%	0.6%	1.3%	1.9%	3.9%	1.2%
DPS Dividend per share (just paid annual dividend)	$ 12.36	$ 8.12	$ 4.57	$ 12.80	$ 2.58	$ 7.16	$ 129.30	$ 12.07	$ 3.58	$ 2.80
EPS Earnings per share	$ 21.01	$ 13.80	$ 7.58	$ 21.76	$ 4.39	$ 12.17	$ 219.81	$ 20.52	$ 6.09	$ 4.76

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.