As of February 2010, what is your assessment of the worth of Wal-Mart's stock? Utilize all...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 c. The three-stage dividend model d. The price/earnings approach Clearly State any assumptions DIVIDEND DISCOUNT MODEL: THREE-STAGE EXAMPLE Discount rate (r): Growth period (g1): Growth years Initial growth rate of EPS Maturity period (92): Payout at maturity Retention rate at maturity (retent) Growth rate at maturity: r x retent Transition period: Transition years Growth rate of EPS (incremental) Other information: Current fiscal year EPS Current calendar year dividend Current payout (p1) Growth years payout = current Maturity payout (p2) Transition years payout (incremental) Growth+ Transition Years Terminal value (TV) = div1/(r-g) Year Assumption 1 Growth year EPS 2 Growth year EPS 3 Growth year EPS 4 Growth year EPS 5 Growth year EPS 6 Growth year EPS 7 Growth year EPS 8 Transition year EPS 9 Transition year EPS 10 Transition year EPS 11 Transition year EPS 12 Transition year EPS 13 Transition year EPS 14 Transition year EPS 15 Transition year EPS 16 Transition year EPS 17 Transition year EPS 18 Maturity Theoretical price EPS 5.25 5.51 5.79 6.08 5.00% 5.00% 40% 60% 3.00% 10 0.18% 5.00 0.50 10.00% 10.00% 40.00% 2.73% 17 growth 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4.82% 4.64% 4.45% 6.38 6.70 7.04 7.39 7.76 8.10 8.45 8.79 4.09% 9.14 9.48 4.27% 3.91% 3.73% 3.55% 9.81 10.14 10.47 3.18% 3.36% 10.78 3.00% 1 2345 60 6 7 8 9 10 11 12 13 4 15 16 17 18 ಸ 14 Dividend Calculate payout 10.00% 10.00% 10.00% 10.00% 0.53 0.55 0.58 0.61 0.64 0.67 10.00% 10.00% 10.00% 12.73% 0.70 0.94 1.20 1.47 1.77 15.45% 18.18% 20.91% 2.08 23.64% 26.36% 2.41 2.76 29.09% 31.82% 3.12 3.50 3.90 4.31 34.55% 37.27% 40.00% TV V (div+TV) 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.64 0.77 0.90 215.6 1.03 1.16 1.28 1.39 1.50 1.61 95.78 109.56 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 c. The three-stage dividend model d. The price/earnings approach Clearly State any assumptions DIVIDEND DISCOUNT MODEL: THREE-STAGE EXAMPLE Discount rate (r): Growth period (g1): Growth years Initial growth rate of EPS Maturity period (92): Payout at maturity Retention rate at maturity (retent) Growth rate at maturity: r x retent Transition period: Transition years Growth rate of EPS (incremental) Other information: Current fiscal year EPS Current calendar year dividend Current payout (p1) Growth years payout = current Maturity payout (p2) Transition years payout (incremental) Growth+ Transition Years Terminal value (TV) = div1/(r-g) Year Assumption 1 Growth year EPS 2 Growth year EPS 3 Growth year EPS 4 Growth year EPS 5 Growth year EPS 6 Growth year EPS 7 Growth year EPS 8 Transition year EPS 9 Transition year EPS 10 Transition year EPS 11 Transition year EPS 12 Transition year EPS 13 Transition year EPS 14 Transition year EPS 15 Transition year EPS 16 Transition year EPS 17 Transition year EPS 18 Maturity Theoretical price EPS 5.25 5.51 5.79 6.08 5.00% 5.00% 40% 60% 3.00% 10 0.18% 5.00 0.50 10.00% 10.00% 40.00% 2.73% 17 growth 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 4.82% 4.64% 4.45% 6.38 6.70 7.04 7.39 7.76 8.10 8.45 8.79 4.09% 9.14 9.48 4.27% 3.91% 3.73% 3.55% 9.81 10.14 10.47 3.18% 3.36% 10.78 3.00% 1 2345 60 6 7 8 9 10 11 12 13 4 15 16 17 18 ಸ 14 Dividend Calculate payout 10.00% 10.00% 10.00% 10.00% 0.53 0.55 0.58 0.61 0.64 0.67 10.00% 10.00% 10.00% 12.73% 0.70 0.94 1.20 1.47 1.77 15.45% 18.18% 20.91% 2.08 23.64% 26.36% 2.41 2.76 29.09% 31.82% 3.12 3.50 3.90 4.31 34.55% 37.27% 40.00% TV V (div+TV) 0.50 0.50 0.50 0.50 0.50 0.50 0.50 0.64 0.77 0.90 215.6 1.03 1.16 1.28 1.39 1.50 1.61 95.78 109.56
Expert Answer:
Answer rating: 100% (QA)
ANSWER To assess the worth of WalMarts stock utilizing the methods mentioned in the case including t... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these finance questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
(a) Why is the MD&A section of the annual report useful to the financial analyst? What types of information can be found in this section? (b) Using the excerpts from the MD&A of the Biolase,...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Repeat the instructions of Exercise 1 for Graph the function Then discuss, in detail, limits, one-sided limits, continuity, and one-sided continuity of at x = -1, 0, and 1. Are any of the...
-
A rectangular loop (area = 0.15 m2) turns in a uniform magnetic field, B = 0.20 T. When the angle between the field and the normal to the plane of the loop is nl2 rad and increasing at 0.60 rad/s,...
-
Steam at T = 400C and P = 5 bar enters an adiabatic, steady-state nozzle. The exiting pressure is P = 1 bar. A. If the nozzle is reversible, find the temperature and velocity of the exiting steam. B....
-
Statistical sampling is not a panacea and is not necessarily appropriate for all tests of controls; nonstatistical sampling is often applied by practicing auditors, and for good reason. Required: 1....
-
Airport Connection provides shuttle service between four hotels near a medical center and an international airport. Airport Connection uses two 10-passenger vans to offer 12 round trips per day. A...
-
7. Let f(x, y) = ln(2x y). (a) (3 points) Determine the gradient of f at the point (2, -1). (b) (4 points) Determine the equation of the plane tangent to the graph of at the point (3,2). (c) (3...
-
12 Mitchell's Specialties sells high-end furniture (dressers, chairs, sofas, and tables). The company has been in business for several years. Based on its experience, management projects next year's...
-
The programming language is Python im not sure which question is wrong is there any problem with my answers? Match the type of loop to its basic description. Prompts Submitted Answers A loop that...
-
Sunspot Beverages, Limited, of Fiji uses the weighted-average method of process costing. It makes blended tropical fruit drinks in two stages. Fruit juices are extracted from fresh fruits and then...
-
Select a company you are familiar with and detail one short-term and one longer-term strategy, then discuss how the role of human resource development can provide valuable advice and counsel in the...
-
What type of approach is most commonly used for procedures on the digestive organs? Explain why that approach is used.
-
What types of interviewing styles are there, and which do prefer using? Have experienced a group interview? If so, explain how that went ? Have ever been part of any of these: stress interview, STAR...
-
Two sole proprietorship businesses converted to partnership. No revaluation of assets and liabilities required. Lourdes and Bernadette individually have been in the catering service business for...
-
On October 1, 20X1, a company purchased a piece of land by agreeing to pay the seller $450,000 in two years. If the company had borrowed the money from a bank to pay the seller immediately,...
-
Consider the reaction of acetic acid in water CH 3 CO 2 H(aq) + H 2 O(l) CH3CO 22 (aq) + H 3 O + (aq) where Ka 5 1.8 3 1025. a. Which two bases are competing for the proton? b. Which is the stronger...
-
At a cost of $200,000, Assume In-N-Out Burger acquired a tract of land for a restaurant site. It paid attorneys $7,500 to conduct a title search and to prepare the required legal documents for the...
-
Exhibit 5.21 presents selected financial data for Best Buy Co., Inc., and Circuit City Stores, Inc., for fiscal 2008 and 2007. Best Buy and Circuit City operate as specialty retailers offering a wide...
-
Explain free cash flows. Describe which types of cash flows are free and which are not. How do free cash flows available for debt and equity stakeholders differ from free cash flows available for...
-
Find the fundamental frequency of longitudinal vibration of the tapered bar shown in Fig. 8.41, using Rayleigh's method with the mode shape \[U(x)=c_{1} \sin \frac{\pi x}{2 l}\] The mass per unit...
-
Approximate the fundamental frequency of a rectangular membrane supported along all the edges by using Rayleigh's method with \[W(x, y)=c_{1} x y(x-a)(y-b)\] \[V=\frac{P}{2}...
-
The root mean square value of a signal \(x(t), x_{\mathrm{rms}}\), is defined as \[x_{\mathrm{rms}}=\left\{\lim _{T ightarrow \infty} \frac{1}{T} \int_{0}^{T} x^{2}(t) d t ight\}^{1 / 2}\] Using this...
Study smarter with the SolutionInn App