Please provide (and show work for):

1. Constant growth model
2. Trailing Own P/E
3. Two-stage dividend growth model
4. Forward Peer P/E
5. TrailingPeerP/E

Information is attached. Not all of the attached information is necessary (such as the balance sheet).

W11058 VALUING WAL-MART - 20101 Cyrus Zahedi wrote this case under the supervision of Professor Jim Hatch solely to provide material for class discussion. The authors do not intend to illustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality. This publication may not be transmitted, photocopied, digitized or otherwise reproduced in any form or by any means without the permission of the copyright holder. Reproduction of this material is not covered under authorization by any reproduction rights organization. To order copies or request permission to reproduce materials, contact Ivey Publishing, Ivey Business School, Western University, London, Ontario, Canada, N6G 0N1; (t) 519.661.3208; (e) cases@ivey.ca; www.iveycases.com. Copyright 2011, Richard Ivey School of Business Foundation Version: 2013-05-15 In early February 2010, Sabrina Gupta, an investment advisor with a major brokerage firm, was examining Wal-Mart Stores, Inc. (Wal-Mart) stock and its valuation. Gupta wondered whether to recommend the stock to any of her new clients or to existing clients who did not currently have Wal-Mart in their portfolios. BACKGROUND OF WAL-MART STORES, INC. Based in Bentonville, Arkansas, and founded by the legendary Sam Walton, Wal-Mart was the world's largest retailer, operating more than 8,400 stores worldwide, including stores in all 50 states; international stores in Argentina, Brazil, Canada, Germany, Mexico, Puerto Rico, South Korea, the United Kingdom; joint venture agreements in China and a stake in a leading Japanese retail chain. Worldwide, Wal-Mart had 2.1 million employees (known as \"associates\"), who served more than 200 million customers each week. During the fiscal year ended January 31, 2010, Wal-Mart's net sales were more than US$405 billion. Exhibit 1 presents a summary of Wal-Mart's 2009 and 2010 financial statements. Wal-Mart's strategy was to provide a broad assortment of quality merchandise and services at \"everyday low prices.\" It was best known for its discount stores, which offered merchandise such as apparel, small appliances, housewares, electronics and hardware, but also ran combined discount and grocery stores (Wal-Mart Supercenters), membership-only warehouse stores (SAM'S Club) and smaller grocery stores (Neighborhood Markets). In the general merchandise area, Wal-Mart's competitors included Sears and Target. In terms of specialty retailers, its competitors included Gap and Limited. Department store competitors included Dillard's, Macy's and J.C. Penney. Grocery store competitors included Kroger, Supervalu and Safeway. The major membership-only warehouse competitor was Costco Wholesale. Wal-Mart became a publicly traded firm in 1970 with an initial stock price of $16.50 per share and subsequently, in March 1974, declared its first cash dividend of $0.05 per share (after two two-for-one 1 This case has been written on the basis of published sources only. Consequently, the interpretation and perspectives presented in this case are not necessarily those of Wal-Mart Stores, Inc. or any of its employees. This document is authorized for use only by ying xin (carolxin9@gmail.com). Copying or posting is an infringement of copyright. Please contact customerservice@harvardbusiness.org or 800-988-0886 for additional copies. Page 2 9B11N004 stock splits). It had undergone 11 two-for-one stock splits, and thus, an original lot of 100 Wal-Mart shares had grown to 204,800 shares after the most recent split in April 1999. Analysts generally believed that Wal-Mart would continue to be successful in consistently increasing profits, resulting in the consensus annual earnings growth forecast of 10.40 per cent for the next five years. As of February 2010, according to Bloomberg L. P., Wal-Mart shares were ranked as \"buys\" in the coming six to 12 months by 20 analysts, \"holds\" by 7 analysts and \"sells\" by none of the analysts. These rankings (which amounted to an average of 4.41 on a five-point scale) currently exceeded the average buy/hold/sell mix among Standard & Poor (S&P) 500 firms (at 3.94) and among the hypermarkets and supercenters subindustry (at 4.23). Analysts' consensus projected Wal-Mart's target price was $60.50 per share, relative to a recent closing price of $53.48 per share. Over the 2010 fiscal year, Wal-Mart shareholders had generated a total return (including dividends) of 9.69 per cent, and the consensus stock price forecast ranking (as measured by buys/holds/sells) was above that of the overall market. Wal-Mart's 52-week high stock price was $55.01 per share and the 52-week low was $46.42 per share. Gupta noticed that Wal-Mart shares had a price-to-trailing earnings (P/E) ratio of 14.40 times (based on the last four quarters of earnings) and an indicated dividend yield (based on the current 2010 quarterly dividend and current stock price) of 2.0 per cent. Exhibit 2 presents a graph of Wal-Mart's stock price for 10 years, and Exhibit 3 provides historical dividend data. In determining whether Wal-Mart was fairly valued, Gupta decided to focus on valuation concepts she had been introduced to in her university business courses and in one of her firm's training courses: the dividend discount model, the capital asset pricing model (CAPM) and price/earnings multiples. DIVIDEND DISCOUNT MODELS Dividends in Perpetuity According to the dividend discount model (DDM), the current stock price of Wal-Mart represents the present value of all expected future dividends, discounted at an investor's required (or expected) rate of return. Under this approach, a share is valued by forecasting dividends in perpetuity, which is not an easy task. To simplify the daunting task of estimating all future dividends, a growth trend of the dividends can be used in a much simpler version of the model, which is known as the constant growth dividend discount model. According to the constant growth DDM, the current value of a firm's stock price (P0) is equal to next year's (expected) dividend (D1) divided by an investor's required rate of return (Ke) minus the expected perpetual dividend growth rate (g). P0 = D1/ (Ke - g) Alternatively, by rearranging the model, the required return can be decomposed into two parts: the expected dividend yield (i.e., the dividends anticipated over the next four quarters divided by the current stock price) plus the expected future growth in dividends. Ke = D1/P0 + g In other words, the required return can be thought of as both a dividend portion and a growth portion that are reflected in future capital gains. This document is authorized for use only by ying xin (carolxin9@gmail.com). Copying or posting is an infringement of copyright. Please contact customerservice@harvardbusiness.org or 800-988-0886 for additional copies. Page 3 9B11N004 Anticipated dividend growth (g) is often estimated in a variety of ways. First, observed historical dividend growth can be assumed to continue in a perpetual fashion. Second, future dividend growth can be estimated on the basis of recent estimates of analysts. Gupta noted that the consensus annual Wal-Mart dividend for fiscal year 2011 was $1.21, and one respected analyst had estimated the expected constant dividend growth (in perpetuity) at approximately 5.0 per cent. When a firm achieves its steady state (i.e., when the annual return on equity is just equal to its cost of equity capital), the sole determinant of the growth in dividends is the annual dividend payout ratio. If all dividends are paid out, the firm's assets do not increase and therefore the dividend stream will not grow. On the other hand, if some of the earnings are retained (i.e., the dividend payout ratio