Question: According to the information given below answer the following question: DocuSign, Inc. Common Stock Dollar Tree Inc. Common Stock eBay Inc. Common Stock Electronic Arts
According to the information given below answer the following question:
| 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 | $210.50 | $101.11 | $57.72 | $140.45 | $37.34 | $87.60 | $1,908.49 | $138.28 | $36.02 | $28.29 |
| Growth rate | 2.20% | 0.30% | 0.50% | 1.70% | 1.90% | 0.20% | 4.60% | 0.30% | 0.40% | 0.80% |
| DPS Dividend per share (just paid annual dividend) | $10.10 | $8.12 | $4.57 | $12.80 | $1.99 | $7.16 | $207.34 | $12.07 | $3.11 | $2.34 |
| EPS Earnings per share | $17.17 | $13.80 | $7.77 | $21.76 | $3.38 | $12.17 | $352.48 | $20.52 | $5.29 | $3.98 |
- 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.
- 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 with explanation for the answer.
* Write your answers after each question.
* Be careful when rounding. Leave two decimal places.
all the information are given as per the question what more do you need?
all the details are there. even the 10th companies details are there move the cursure of ur mouse to the right and see you can see the 10th companies details. company 1 is docusign, Inc. common stock company 2 is dollar tree inc common stock company 3 is ebay company 4 is electronic arts company 5 js exelon corporation company 6 is expedia company 7 is tesla company 8 is Texas instruments company 9 is the Kraft heinz company 10 is trip. com group all these have given what more do you need cus these are the only informations provided.

- Merge 2 Center %> 00 .000 Clipboard Font ki Conditional Format as Cell Formatting Table Styles Styles Alignment Number B3 fc DocuSign, Inc. Common Stock C D E F G H K M 1 Question 3 2 Texas Instrume Trip.com Exelon Expedia nts The Kraft Group DocuSig Dollar Tree eBay Electroni Corporati Group, Tesla, Incorpora Heinz Limited Inc. Inc. cArts Inc. on Inc. Inc. ted Company American Commo Common Commo Common Common Common Common Common Common Deposita In Stock Stock In Stock Stock Stock Stock Stock Stock Stock n, Inc. 3 ry Shares $210.50 $101.11 2.20% 0.30% $57.72 $140.45 $37.34 0.50% 1.70% 1.90% $87.60 0.20% $1,908.49 $138.28 $36.02 4.60% 0.30% 0.40% $28.29 0.80% 4 Stock price 5 Growth rate DPS Dividend per share (just paid 6 annual dividend) EPS Earnings per 7 share $10.10 $8.12 $4.57 $12.80 $1.99 $7.16 $207.34 $12.07 $3.11 $2.34 $17.17 $13.80 $7.77 $21.76 $3.38 $12.17 $352.48 $20.52 $5.29 $3.98 8 9 10 11 12 13 Sheet1 Seled destination and press ENTER or choose Paste x
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
