Question: PLEASE SHOW ANSWER IN EXCEL WITH FORMULAS THANKS! Question 3 - Amazon just paid a dividend of $2.13. The company plans to increase its dividends

PLEASE SHOW ANSWER IN EXCEL WITH FORMULAS THANKS!

PLEASE SHOW ANSWER IN EXCEL WITH FORMULAS THANKS! Question 3 - Amazon

Question 3 - Amazon just paid a dividend of $2.13. The company plans to increase its dividends at 21% over the next three years, then 11% over the following five years, and 3.5% indefinitely after that. If the required return on Amazon stock is 13.2%, what is the stock worth today? Complete each of the items below to reach the final answer. (15 points) Dividend growth rate - years 1-3 Dividend growth rate . years 4-8 Dividend growth rate. perpetual Required return Dividend $ 21.00% 11.00% 3.50% 13.20% 2.13 Calculate the Share Price: Year 1 2 3 4 5 6 7 8 9 10 11 12 Growth Rate 21.00% $ 21.00% $ 21.00% $ 11.00% $ 11.00% $ 11.00% $ 11.00% $ 11.00% $ 3.50% $ 3.50% $ 3.50% $ 3.50% $ Dividend 2.58 3.12 $ 3.77 $ 4.19 4.65 $ 5.16 $ 5.73 $ 6.36 $ 6.58 $ 6.81 $ 7.05 $ 7.30 $ Present Value $2.28 2.43 2.60 $2.55 2.50 2.45 2.40 2.36 2.16 1.97 1.80 1.65 + Price at end of supernormal growth PV of supernormal growth price Share price today

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

PLEASE ANSWER QUESTION IN EXCEL WITH FORMULAS SHOWN THANKS! Question 3 - Amazon just paid a dividend of $2.13. The company plans to increase its dividends at 21% over the next three years, then 11%...

Question 2 - Chipotle stock is trading at $1,300 per share. The company just paid a dividend of $2.69 and expects to pay a dividend of $2.88 next year. If dividends will continue to grow at this rate...

This is for a Managerial Corporate finance Class, Please See attachment, it is the sheet labeled PART 2 Financing Growth. I have Completed the internal and sustainable growth portion. I just need...

This is for a Managerial Corporate finance Class, Please See attachment, it is the sheet labeled PART 2 Financing Growth the ONLY document, in the workbook I need help with. I have Completed the...

The CEO of Company A is considering entering into an agreement to have the company buy another company (Company B). An analyst has suggested that the price might be too high, but the CEO of Company A...

QUESTION 1 Linda's Lights balance sheet info for the beginning of 2020: Owners' Equity27 million Bank Loan 10 million, 4.5% interest rate Fixed Assets 10 million Inventory 23 million Cash 4 million...

QUESTION 1 Linda's Lights balance sheet info for the beginning of 2020: Owners' Equity27 million Bank Loan10 million, 4.5% interest rate Fixed Assets10 million Inventory23 million Cash4 million Here...

please show calculations in Excel with breif descriptions calculate the stock price of mocha cola using the 3 stage discount model. it says this in the last paragraph Your first assignment is...

.Solve the following. PLEASE ANSWER IN EXCEL USING FORMULAS Q1 Assume? Evco, Inc. has a current stock price of $53.41 and will pay a $2.25 dividend in one? year; its equity cost of capital is 11%....

I have attached a document that I need some help with. I cannot seem to get the correct answers through formulas, if someone can help, please show the work so I can fully understand. Thank you!...

You're analyzing the stock of a certain company. The most recent dividend paid was $5 dollars per share. The company's discount rate is 13%, and the firm is expected to grow at 5% per year forever....

Expected cash collection pattern is 50% in the month of sale, 30% in the following month, and 15% in the second following month. Five percent of the credit sales are uncollectible. November...

Seconds at the Farnsworth Corporation contained the following deta for the most recent period of activity. \ table [ [ Actual tatal sirect laber cost, 5 5 1 5 , 5 1 0 ] , [ Artubl direct labor -...

As Alan strolled through a shopping center, he tried to relate his lessons in a marketing class to his observations at the mall. Which of Alan s interpretations of his observations can NOT be true?...

=+3. Have a look at this Financial Times article (http://www.ft.com/cms/s/0/c6d8c8a2-5902- 11de-80b3-00144feabdc0.html), which describes a law passed by the Norwegian government to force listed...

=+5. Look at this video of Nike CEO Phil Knight and the documentary producer, Michael Moore: http://www.youtube.com/watch? v=cOI0V4kRCIQ. Is Nike a good company? Why or why not?

=+2. Is a tobacco firm that employs tens of thousands of people and pays significant taxes a better or worse firm (in terms of CSR performance) than a supermarket that sells food but pays its...