Premium Essay

Walmart Valuation

In: Business and Management

Submitted By bfrieder
Words 1910
Pages 8
Summary - Valuing Wal-Mart
In utilizing the fundamental data provided by the 2010 Richard Ivey School of Business Foundation article titled Valuing Wal-Mart - 2010, I have made the following conclusions regarding the value of Wal-Mart (WMT) stock as of February 2012. * Utilizing the constant growth dividend discount model (DDM), the value of Wal-Mart’s stock price is $60.20. The most recent closing price of Wal-Mart stock was $53.48. Given this information, the constant growth DDM valuation suggests that the Wal-Mart stock is currently undervalued. * Utilizing the two-stage DDM approach, the value of Wal-Mart’s stock price is $83.95. Similar to the constant growth DDM valuation conclusion, the Wal-Mart stock is currently undervalued. * The capital asset pricing model (CAPM) was used to determine the appropriate required rate of return on Walm-Mart’s stock. The required rate of return for Wal-Mart is 7.01% * In following the concepts of the price/earnings (P/E) multiple approach, Wal-Mart’s intrinsic value based upon the P/E multiple approach is $55.03. Given the current stock price of Wal-mart of $53.48, this valuation would support that Wal-Mart’s stock is undervalued.
*Several assumptions were made within the various valuation methods. The assumptions are noted and defined within each of the following sections.

In summary, in employing the dividend discount valuation methods and price/earnings multiple approach, the Wal-Mart stock would be a “buy” given the current close price of $53.48. Wal-mart is the largest retailer in the world with more than $400 billion in annual revenues across more than 8,000 stores. Since the firm’s inception in 1974, the firm has consistently grown their sales, earnings, dividends, and dividend payout ratio. Although the DDM valuations incorporate general assumptions around the dividend growth rates, I believe…...

Similar Documents

Premium Essay

Walmart

...ACC 519 Case Note Target vs. WalMart Purpose: The purpose of this case is to illustrate a comprehensive financial statement analysis which applies the concepts of strategy analysis, ratio analysis and valuation in the context of two competing businesses. This case will demonstrate how corporate strategy is reflected in financial statements and ratios, and will require you to compare performance over time and against a competitor. In addition, this case will help you to see how different operating and financing strategies will affect ratios. Your primary sources of information in this case should be the most recent 10-K’s issued by the two companies (TGT, filed 3.15.2012; WMT, filed 3.27.12). Case Questions: 1. What is the generic strategy for each of the two companies? 2. What is each company’s source of competitive advantage, and what will be important to maintaining that advantage? 3. How do their business models differ? For purposes of this question you should consider the following: a. Composition of the business from a segment perspective b. Composition of sales - % of sales in various categories c. Financing of the assets used in the business 4. From an accounting analysis perspective, are there any major differences between the two companies? 5. Calculate the following ratios for both companies for the years ended January 2012 and 2011 (Please note that the two companies refer to their fiscal years in different ways): d.......

Words: 370 - Pages: 2

Premium Essay

Valuation

...AMITY INTERNATIONAL BUSINESS SCHOOL ANALYSIS AND VALUATION OF EQUITY SECURITIES OF TATA CONSULTANCY SERVICES , INFOSYS AND WIPRO LTD. SUBMITTED TO: SUBMITTED BY : Ms.Vibha Singh Atreya Vyas A1802011445 Section C MBA IB TABLE OF CONTENTS S.No | Topic | Page Number | 1 | Introduction | 3 | 2 | Research Methodolgy | 4 | 2.1 | Research Objectives | 5 | 2.2 | Proposed Literature Review and Tentative Hypothesis | 5 | 3 | Data Collection | 7 | 4 | About Companies and Research | 8 | 5 | Limitation of Study | 11 | 6 | References | 12 | 1) INTRODUCTION In today’s era every company needs cash or cash equivalents to run its day to day activities smoothly. The major sources through which companies can borrow money are: * Bank Loans * Debenture * Preference Share * Equity Share. Bank Loan is the amount which companies receive after fulfilling all the required information which is mandate according to the rules of banks. Companies need to mortgage its assets as guarantee for the future repayment of its loan amt. on the loan bank charge interest which company has to pay irrespective of the fact that company is in profit or loss. Debentures are the instruments which are used to acknowledge the receipt of the debt form the debenture holders. Debenture Holders are sought lenders for the company. They...

Words: 4106 - Pages: 17

Premium Essay

Valuation

...Bank Valuation: Comparable Public Companies & Precedent Transactions Picking a set of comparable companies or precedent transactions for a bank is very similar to what you’d do for any other company – here are the differences: 1. The set has to be more specific due to differing regulatory requirements for different countries and types of banks. For example, if you’re looking at large-cap commercial banks in the US, you should not include regional banks or insurance companies even if they’re also large-cap – nor should you include Credit Suisse or Deutsche Bank, because they’re not US-based. 2. Rather than cutting the set by revenue or EBITDA, you use metrics like total assets or total deposits to determine the “size” of banks. 3. Instead of traditional metrics like revenue and EBITDA, you list the metrics and multiples that are relevant to a bank: EPS, Return on Equity (ROE), Book Value (BV), P / E, P / BV, and so on. Operating Metric Equity Value Book Value (BV) How to Calculate It Shares Outstanding * Share Price Shareholders’ Equity(1) What It Means How much are we worth? How much are we worth according to our assets rather than the market? How much are we worth to everyone except preferred shareholders? How much are we worth according to our incomeproducing assets? How much money do we make after taxes? How much money is left to pass on to common shareholders? How much in dividends could we potentially issue to each common shareholder? Does our market cap overvalue or......

Words: 1938 - Pages: 8

Premium Essay

Valuation

...Valuation Valuation is the process and procedures used to determine the current worth of a company. Valuation is used in deciding if a company is worth investing in , what price you should pay when buying a company and even financial and dividend choices when running a company . Some elements of a valuation are Economic conditions, financial analysis, and financial statements. When a financial analysts need to value a business, they often start by identifying a sample of similar firms. (Brealey, Myers, & Marcus, 2012). They then examine how much investors in these companies are prepared to pay for each dollar of assets or earnings. (Brealey, Myers, & Marcus, 2012). Valuation determines a company’s value by using internal and external factors whereas when determining a company’s value and using financial income statement it uses internal factors only. Valuation also is a company’s market value and income statement is the book value. The definition of a stakeholder is a person, group, organization, or system that affects or can be affected by an organization's actions. The main stakeholders of a company are the employees, suppliers, investors, and customers. The Executives major goal is to create the most value for all stakeholders. This is a difficult goal. Executives know that long term value is what is best for their stakeholders especially with the economy the way it is today. However, corporate leaders are under great......

Words: 363 - Pages: 2

Premium Essay

Walmart, Valuation Case Study

...names and other identifying information to protect confidentiality. Ivey Management Services prohibits any form of reproduction, storage or transmittal without its written permission. 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 Management Services, c/o Richard Ivey School of Business, The University of Western Ontario, London, Ontario, Canada, N6A 3K7; phone (519) 661-3208; fax (519) 661-3882; e-mail cases@ivey.uwo.ca. Copyright © 2006, Ivey Management Services Version: (A) 2009-09-23 In early January 2006, Rachel Martin was examining Wal-Mart Stores, Inc. (Wal-Mart) stock and its valuation. As an investment advisor with a major brokerage firm, Martin gave investment suggestions and helped clients manage their portfolios. Some of her clients had Wal-Mart stock in their portfolios, and Martin 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 and had over 4,000 stores worldwide, including stores in all 50 states as well as international stores in Argentina, Brazil, Canada, Germany, Mexico, Puerto Rico, South Korea, the United Kingdom, joint venture agreements in China, and a......

Words: 5056 - Pages: 21

Free Essay

Walmart Valuation

...P_(0 )= $1.21/(2.013%) breakthrough. He only hoped that tomorrow morning would bring mercy upon him… Such was not the case for Dr. Santiago. He arrived at his office early, hoping to prepare for the meeting at hand with the senior staff and the project manager. Instead, he found the project manager, along with the vice president of biotechnology, waiting for him. It did not take long. The data and the logs clearly showed that the error was a result of Santiago’s negligence – and they were errors that could not be forgiven easily. His worst fears were confirmed as they sat him down to discuss his future with the corporation. His career would be altered – he would be transferred and demoted to a research assistant. He would loose many of the perqs he’d come to enjoy. He would be all but thrown away. And that was the good news. All of this would come with a heavy price. One paid with blood – literally. In order to recover from this incident, Santiago would have to sacrifice his only son. The corporate offices had been keeping an eye on young Tomas since his twelve birthday, when testing revealed he possessed a latent gene known to be involved with magical ability. He had failed, however, to demonstrate any sort of ability or powers that would attract the attention of the thaumaturgy division. Possessing even latent abilities, however, would make him a valuable and powerful candidate for ritual sacrifice to power some of the more obscure procedures that were rumored to......

Words: 2573 - Pages: 11

Premium Essay

Valuation

...Wal-Mart Stores, Inc. operates retail stores in various formats worldwide. The company operates in three segments: Walmart U.S., Walmart International, and Sam's Club. It operates retail stores, restaurants, discount stores, supermarkets, supercenters, hypermarkets, warehouse clubs, apparel stores, Sam’s Clubs, neighborhood markets, and other small formats, as well as walmart.com; and samsclub.com. Wal-Mart’s main strategy is to provide customers with everyday low prices. It is known for its discount stores. Wal-Mart’s competitors are Sears, Target, Gap, limited, Dillard’s, Macy’s and JC Penny. The major membership only warehouse competitor is Costco Wholsale. 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 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. For this valuation we will be using the dividend discount model, the capital asset pricing model (CAPM) and price/earnings multiples. Dividend Discount Model (DDM) In discounted cash flow (DCF) valuation techniques the value of the stock is estimated based upon present value of some measure of cash flow. Dividends are the cleanest and most straightforward measure of cash flow because these are clearly cash flows that......

Words: 1158 - Pages: 5

Premium Essay

Valuations

...Valuation Assumptions The models used to value the target firm SkyWest will include: I. Residual Earnings Model (REM) II. Abnormal Growth Model (AGM) III. Dividend Discount Model ((DDM) IV. Discounted Cash Flow Model (DCF) V. Method of Comparables These models have been based on some fundamental assumptions. These assumptions can be found in Appendix 1.1. I. Residual Earning Model The REM splits the intrinsic value of a company into two components; the book value and the present value of the future residual earnings. The discount rate used for future earning was the Cost of Equity found in Appendix 1.1. Through obtaining the earnings per share (EPS), book value per share (BPS) and dividends per share (DPS) from Bloomberg, it is possible to estimate the value of SkyWest. A growth rate of 2.6% (2012 financial statement) was applied. The value per a share shown in Appendix 1.2 is approximately 94 cents. II. Abnormal Growth Model The RE model anchors book value whereas, the AEG model anchors earnings. In applying the model the value per a share is equal to the capitalised earning plus the extra forecasted earning and applying a growth rate of 2.6% for the CV. In Appendix 1.3 the value per a share is $9.86. However, there seems to be a problem with the CV, through excluding the CV the value per a share is equal to approximately 33cents (0.02076/0.0636). Theoretically, the AEG and RE models should give the same valuations, but due to imperfections, the two......

Words: 499 - Pages: 2

Premium Essay

Valuation

...VALUATION TECHNIQUES Vault Guide to Finance Interviews Valuation Techniques How Much is it Worth? Imagine yourself as the CEO of a publicly traded company that makes widgets. You’ve had a highly successful business so far and want to sell the company to anyone interested in buying it. How do you know how much to sell it for? Likewise, consider the Bank of America acquisition of Fleet. How did B of A decide how much it should pay to buy Fleet? For starters, you should understand that the value of a company is equal to the value of its assets, and that Value of Assets = Debt + Equity or Assets = D + E If I buy a company, I buy its stock (equity) and assume its debt (bonds and loans). Buying a company’s equity means that I actually gain ownership of the company – if I buy 50 percent of a company’s equity, I own 50 percent of the company. Assuming a company’s debt means that I promise to pay the company’s lenders the amount owed by the previous owner. The value of debt is easy to calculate: the market value of debt is equal to the book value of debt. (Unless the debt trades and thus has a real “market value.” This information, however, is hard to come by, so it is safe to use the book value.) Figuring out the market value of equity is trickier, and that’s where valuation techniques come into play. The four most commonly used techniques are: 1. 2. 3. 4. Discounted cash flow (DCF) analysis Multiples method Market valuation Comparable transactions method Generally, before...

Words: 11224 - Pages: 45

Premium Essay

Valuation

...BUSINESS VALUATION METHODS (All Valuations MUST BE based on Historical Data) I. Adjusted Book Value Take the Book Value of net worth -assets not acquired +liabilities not assumed +fair market value of assets acquired +any net worth adjustments =Adjusted Book Value ____________________________________________________________ II. Capitalized Adjusted Earnings First Step: Adjust Historical Earnings Seller’s Discretionary Cash Flow Net Profit +Officer’s salary +Discretionary expenses -New Owner salary Adjusted Profit Last Year 50.0 +70.0 +30.0 -60.0 90.0 Second Step: Get the adjusted profits for 5 years then do a Weighted Average of the Adjusting Earnings Year 95 96 97 98 99 Totals Average Earnings $ 50 $ 30 $ 70 $ 60 $ 90 Weight 1 2 3 4 5 15 $ Adjusted $ 50 $ 60 $ 210 $ 240 $ 450 $1,010 /15 67 (rounded) Third Step: Calculate a Discount Rate Determine T-Bill Rate Determine Offset Risk Rate √ √ Establish rate of return based on risk factors Establish rate of return based on general economy 5.0% 12.0% Determine Offset Illiquidity Rate Total the Rates 3.0% 20.0% Fourth Step: Take the weighted average of the adjusted earnings and divide by the discount rate. Example: $67/.20 = $335 ___________________________________________________________________ III. Discounted Future Earnings First Step: Adjust Historical Earnings Last Year 50.0 +70.0 +30.0 -60.0 90.0 Net Profit +Officer’s salary +Discretionary expenses -New Owner salary Adjusted Profit Second Step: Get the adjusted......

Words: 1274 - Pages: 6

Premium Essay

Walmart Valuation

...Wal Mart Valuation Wal-Mart 2010 Case Study Dividend in perpetuity For this model we use this formula : Expected dividends (D) divided by the investor’s required rate of return (Ke) minus the perpetual dividend growth rate(g). P = D/(Ke-g) The case tell us about each of the inputs : the dividend growth, the xpected dividend, and the investor’s required rate of return. We know that one respected analyst figure out that the constant perpetual dividend growth is g=5.0%. We also know that the consensus annulal Wal-Mart dividend for fiscal year 2011 was D= $1.21 And to calculate the investor’s required rate of return (Ke) we can use the CAPM : Risk free rate : 3.68% Beta of Wal-Mart : 0.66 Market risk premium : 5.05% So the CAPM gives us : Ke= 0.0368+ 0.66*0.0505= 7.013% So we have P= 1.21/(0.07013-0.05)= $60.11 We know that February 2010 closing price was $53.48 per share so it means that Wal-Mart is slightly undervalued. So it is a good investment opportunity. Dividends and a terminal value. In this method we forecast the futur dividends (which we know assuming the constant perpetual dividend growth is g=5.0%) until the futur stock price P(n). We call this price the terminal value. The formula is : P(0)= D(1)/(Ke+1)+D(2)/(Ke+1)^2+….+D(n)/(Ke+1)^n+P(n)/(Ke+1)^n The further we go in years the bigger become the (Ke+1)^i part of the formula and the smaller become the D(i)/(Ke+1)^i. It tend to be 0. Let’s say we forecast the dividends for the......

Words: 340 - Pages: 2

Premium Essay

Walmart

...them in the US. Although the company was using products that were made in the U.S. Wal-Mart was rapidly growing overseas. In 1991 they had only one store in Mexico. By 1998 they had over 600 stores overseas, which accounted for about 5 percent of their growth in sales and profits. Wal-Mart was very successful in the United States but in order for them to survive and grow they had to begin building stores overseas (Govindarajan & Gupta, 2002). Wal-Mart also had so many stores in the United States that their only other option to continue to grow was to move into other countries. Wal-Mart has been able to grow into the number one retailer in the United States. According to Bloomberg, the current Chief Executive Officer (CEO) at Walmart is Michael Terry Duke. Mr. Duke has been the CEO at Wal-Mart Stores Inc. since 2006 (2011). And Bloomberg also reports that Charles M. Holley Jr. is the current Chief Financial Officer of Wal-Mart and has held that position since late 2010. Mr. Holley’s education background consists of a MBA from the University of Houston. His financial experience is quite extensive and he has been working within the Wal-Mart Stores Inc. finance scene since 1999. Before that he started working for Wal-Mart he was with Ernst & Young for over ten years (2011). After examining Mr. Holley’s experience, I believe that he is well qualified for the position that he currently holds. He has over a decade of experience within Wal-Mart itself dealing......

Words: 1380 - Pages: 6

Premium Essay

Walmart Valuation

...v p al ik a @ ho tm ai l. co m Walmart The Retail Superpower Vinod Palikala Walmart Valuation by Vinod Palikala 2 Wal m art Company Overview Walmart is the largest retailer in the world and accounts for nearly 10% of all retail sales in US. I t dominates the retail market with sales exceeding that of the next six largest retailers in US. Retailers compete for customers on five major factors : 1. Prices for the products and services 2. Service level 3. Product selection (merchandise line width and depth) 4. Location or access: the overall convenience of shopping the retailer 5. Customer experience (the customer’s positive feelings and behaviors in the purchase process) Walmart competes primarily on prices (every day low prices) . It also provides a greater product selection compared to peers (one - stop shopping) . Competitiv e Advantage Perhaps the most critical judgment in the valuation of a business is the estimation of its competitive advantage. Lacking any competitive advantage , a business is usually worth no more than the replacement cost of its assets. Only in the presen ce of sustainable competitive advantage would it be possible to value a firm on the basis of its earning power. Retailing is an industry that is characterized by intense competition with few competitive advantages of any kind. However, Walmart has been abl e to develop significant competitive advantage via several strategies......

Words: 453 - Pages: 2

Premium Essay

Walmart

...Table of Contents Company Background 2 Financial Ratios 5 Bond Valuation 5 Wal-Mart vs. Target Competitor Analysis 7 Stock Valuation 7 Capital Budgeting 10 Cost of Capital and Capital Structure 12 Conclusion 13 References 13 Appendix 13 Company Background Wal-Mart Stores, Inc. (NYSE: WMT) Sam Walton founded Wal-Mart Stores, Inc. in 1962. Wal-Mart is a family-owned business that operates through many generations of Sam Walton’s heirs, who own over 50% of Wal-Mart through their holding company, Walton Enterprises. Today, Wal-Mart is led by Chairman, Greg Penner, the grandson-in-law of Sam Walton and President and Chief Executive Officer, Doug McMillon and headquartered in Bentonville, Arkansas. Wal-Mart’s brand and low price strategy, ‘Every Day, Low Prices’ prides itself on making a difference in customers lives, helping communities save money and live better domestic and international. Wal-Mart operates 11,532 stores in all 50 states, across 28 countries and 11 e-commerce websites. Each week nearly 260 million customers visit stores or websites (via online and mobile). Many of its brick-and-mortar stores, operate 24 hours a day, seven days a week and consumer products range from a variety of groceries, electronics, sporting goods, clothing, home improvement products, pet supplies, pharmacy and most everything in between. In 2015, Wal-Mart generated the highest sales in its grocery division at 60% of $288 billion dollars in revenue. Over the......

Words: 3850 - Pages: 16

Premium Essay

Valuation

...Valuation M&A involves using more than one valuation technique to arrive at a valuation that we think is fair. The most common techniques used are: ➢ Comparable Publicly traded companies (“Public Comps”) – this analysis indicates how the stock markets are valuing companies that are similar to the target ➢ Precedent Comparable Transaction analysis (“Transaction Comps”) – this analysis indicates the valuations at which prior M&A transactions have been done in the same industry as that of the target. ➢ DCF analysis – is one of the most important valuation techniques ➢ Sum-of-the-parts analysis – If a target has more than one lines of business, the financial advisor will value each business separately. Therefore, each “part” might have its own Public Comps, Transaction comps and DCF (with different WACCs for each part). The total value is the sum of the parts ➢ Other –depending on the unique characteristics of the transaction, financial advisors will perform a number of other analyses to arrive at fair value like Leveraged Buyout (“LBO”) Analysis, Historical Exchange Ration analyses etc. Valuation M&A involves using more than one valuation technique to arrive at a valuation that we think is fair. The most common techniques used are: ➢ Comparable Publicly traded companies (“Public Comps”) – this analysis indicates how the stock markets are valuing companies that are similar to the target ➢ Precedent Comparable Transaction analysis......

Words: 343 - Pages: 2