Question: J K L W A B C D E F G H I M N 0 P Q R S T U V DIVIDEND DISCOUNT

J K L W A B C D E F G H I M N 0 P Q R S T U V DIVIDEND DISCOUNT MODEL: THREE-STAGE EXAMPLE Discount rate (r): 5.00% Growth period (g1): Calculate Growth years Initial growth rate of EPS 5.00% Maturity period (g2): Payout at maturity 40% 10 Retention rate a 60% 11 Growth rate at maturity: r x retent 3.00% 12 Transition period: 13 Transition years 10 14 Growth rate of EPS (incremental) 0. 18% 15 Other information: 16 Current fiscal year EPS 5.00 17 Current calendar year dividend 0.50 18 Current payout (p 1) 10.00% 19 Growth years payout = current 10.00% 20 Maturity payout (p2) 40.00% 21 Transition years payout (incremental) 2.73% 22 Growth + Transition Years 17 23 Terminal value (TV) = div1/(r-g) 24 25 Year Assumption EPS growth Dividend payout TV V (div+TV) 26 1 Growth year EPS 5.25 5.00% 0.53 10.00% 0.50 27 2 Growth year EPS 5.51 5.00% 0.55 10.00% 0.50 28 3 Growth year EPS 5.79 5.00% 0.58 10.00% 0.50 29 4 Growth year EPS 6.08 5.00% 0.61 10.00% 0.50 30 5 Growth year EPS 6.38 5.00% 0.64 10.00% 0.50 31 6 Growth year EPS 6.70 5.00% 0.67 10.00% 0.50 32 7Growth year EPS 7.04 5.00 0.70 10.00% 0.50 33 8 Transition year EPS 7.39 4.82% 0.94 12.73% 0.64 34 9 Transition year EPS 7.76 4.64% 1.20 15.45% 0.77 35 10 Transition year EPS 8.10 4.45% 10 1.47 18.18% 0.90 36 11 Transition year EPS 8.45 4.27% 11 1.77 20.91% 1.03 37 12 Transition year EPS 8.79 4.09% 12 2.08 23.64% 1.16 38 13 Transition year EPS 9.14 3.91% 13 2.41 26.36% 1.28 39 14 Transition year EPS 9.48 3.73% 14 2.76 29.09% 1.39 40 15 Transition year EPS 9.81 3.55% 15 3.12 31.82% 1.50 41 16 Transition year EPS 10.14 3.36% 16 3.50 34.55% 1.61 42 17 Transition year EPS 10.47 3.18% 17 3.90 37.27% 215.6 95.78 43 18 Maturity 10.78 3.00% 18 4.31 40.00% 44 Theoretical price 109.56 45 46 Sheet1 + + Ready { Accessibility: Good to go m - 100%1-) As of February 2010, what is your assessment of the worth of Wal-Mart's stock? Utilize all the methods discussed in the case to value the shares, including the following: a. The perpetual growth in dividends b. Forecasted dividends for the next several years plus sale of the stock in the future 0. The three-stage dividend model d. The price/earnings approach Clearly State any assumptions

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!

J K L W A B C D E F G H I M N 0 P Q R S T U V DIVIDEND DISCOUNT MODEL: THREE-STAGE EXAMPLE Discount rate (r): 5.00% Growth period (g1): Calculate Growth years Initial growth rate of EPS 5.00%...

J K L 4 9 B C D E F G H I 1 Mortgage Amortization Complete the loan amortization schedule for a Mortgage that will be repaid over 360 months and answer the following questions (The details about the...

MINICASE Wok Yow Imports, Inc. Wok Yow Imports, Inc., is a rapidly growing, closely held corporation that imports and sells Asian style furniture and accessories at several retail outlets. The equity...

Submit the excel example with all three strategies executed on them:one sheet with a chase strategy, one tab with a flexible strategy, and one tab with a level strategy. Sales and Operations Planning...

here are the screenshots of the problem A local rm wanted to explore various marketing channels to see how much sales revenue was generated by each marketing campaign over the course of 10 weeks. The...

2. Company Valuation Fley Airline Supply is trading at $15/share but you think that price may not be right. You have the following data and you want to use it to calculate its share price: Gross...

SHOW FORMULA FOR ANSWERS B J K L Part 4 15 C D E F G H Eyll opens a savings account in FIBABANKA with a monthly interest rate of 2 %, solve the questions below accordingly. Assume that the savings...

I need to pull the amount from the Expenses tab onto the Income Statement if the correct expense category is selected from the dropdown on the Expense tab, and have it apply to the correct month. I...

zmir Metropolitan Municipality wants to decide which projects to fund out of nine projects. To quantify public support, a survey study asking to rank each project was conducted on randomly selected...

AutoSave O A A 5 . CD ... X: BUS333 Final Exam Q Search (Cmd + Ctrl + U) Home Insert Draw Page Layout Formulas Data Review View Automate Acrobat Comments Share Times New Roman v 12 AA = Percentage...

Which of the following statements about ASC 740 as it relates to uncertain tax positions is true? a) ASC 740 deals with all tax benefits involving income and non-income taxes. b) ASC 740 deals with...

Rod CD is attached to the collar D and passes through a collar welded to end B of lever AB. Neglecting the effect of friction, determine the couple M required to hold the system in equilibrium when ...

Explain why manufacturing companies use standard costs for material, labor and manufacturing overhead versus actual costs?

For 22 years, Ms. Brielle saved $ 2,800 each year. A year after investing period ended, she withdraws $8,300 each year for 5 years. In the 7th and 8th years, she only withdraw $5800 per year. In the...