Preview

Walmart Valuation Analysis Essay Example

Satisfactory Essays
Open Document
Open Document
542 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Walmart Valuation Analysis Essay Example
Firm Valuation Project
Wal-mart (WMT) The purpose of this report is to find the intrinsic value of a company. We choose Wal-Mart Stores for our analysis.
FCF calculation First, we retrieved the financial statements of the company for the last five years (2005-2010) from www.sec.gov website. Based on this information, we calculated the Average annual growth rate for Wal-mart to be 9.27% and the Compound annual growth rate to be 9.26%. Then we found the projected sales for 2010 to be $433,289 and based on this number, we forecasted the implied growth rate and the pro forma ratios for the company.
The finance.yahoo.com website was used throughout this report as well. We found the Dividend growth rate to be 15.95%. The Tax rate-34% was calculated by dividing the company’s income tax expense ($7,145) by EBT ($20,898) for 2009. We forecasted the financial statements for Wal-mart for 2010 using ratios and their past years financial statements. After all of that was done we were able to calculate the FCF for 2010 to be $5,298.
WACC calculation To estimate beta we pulled the historical prices of S&P and Wal-mart from finance.yahoo.com for the last 5 years. We calculated the monthly returns for the market and Wal-mart and using the slope function we found beta to be 0.25.
In order to solve cost of debt we found the yield of maturity of a 30-year bond of Wal-mart to be 5.022%. The risk free rate was found using the 5-year Treasury bond index value of 2.16% quoted on finance.yahoo.com as of May 7th, 2010. We estimated the market risk premium to be 5.5% given that the historical market risk premium has been between 5% and 6%. To calculate the cost of common equity, we used the Capital Asset Pricing Model. We multiplied the beta of 0.25 by market risk premium, and then added this amount to the risk free rate of 2.16%. We calculated the weight of debt to be 14% and the weight of equity to be 86%. For the weight of debt we divided the Long Term Debt
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Acc 230-Checkpoint: Assessing Financial Statements
    • 441 Words
    • 2 Pages

    Acc 230-Checkpoint: Assessing Financial Statements

    One year later, 2009, Wal-Mart declared stockholder's equity of 65,285 million, and liability of 98,144 million, which also resulted in a debit/equity ratio of 1.5. This proves that this company is maintaining a stable low ratio and by doing so it makes it less risky for creditors or investors.…

    • 441 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Dick's Sporting Goods, Equity Valuation and Analysis Essay Example
    • 8844 Words
    • 36 Pages

    Dick's Sporting Goods, Equity Valuation and Analysis Essay Example

    After analyzing Dick’s Sporting Goods and taking into account both positive and negative aspects associated with the stock, I am giving the stock a Moderate Buy Recommendation, with a target price of $46.50. The recommendation took into account DKS’s recent earnings report, improving financial health, growth estimates, and industry outlook.…

    • 8844 Words
    • 36 Pages
    Powerful Essays
    Read More
  • Better Essays

    Mgt/330 Wal-Mart Organizational Paper
    • 1117 Words
    • 5 Pages

    Mgt/330 Wal-Mart Organizational Paper

    Business economy today has seen vast amounts of businesses fail. However, Wal-Mart Corporation is standing and increases their revenue yearly. In 2009 alone, Wal-Mart generated approximately $404 billion dollars in revenue. That type of success only proves that the organization has everything in order to keep on the track of success.…

    • 1117 Words
    • 5 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Ethical Arguments for Wal-Mart
    • 440 Words
    • 2 Pages

    Ethical Arguments for Wal-Mart

    Wal-Mart went public in October of 1970. Their IPO was 3,000 shares at a price of $16.50 per share. By having a smart business model and keeping cost low though a variety of tactics including low employees wages and benefits, Wal-Mart has been able to sustain an incredible rate of growth. Since their IPO Wal-Mart has undergone eleven full 2-1 stock splits. That means that just one share of their IPO has turned into 2,048 current shares. The current market value of Wal-Mart stocks on the NYSE is $62.30 per share. If an investor bought just one share in 1970 for $16.50, today that investment would be worth $127,590.40. In addition to rising stock value, investors receive a quarterly cash dividend payment that was paid out at $0.2725 per share as of July 2009. People start and invest in businesses to make money. Wal-Mart should concentrate on serving their shareholders by producing profits because the business would not exist in the same capacity without their investment. They have certainly done this, keeping their expenses low by paying minimum wage and limiting employee benefits in addition to a number of other influential factors has allowed Wal-Mart to recognize large profits, which serve its shareholders well.…

    • 440 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Satisfactory Essays

    ACC 561 Week 1 Financial Statement Review
    • 312 Words
    • 2 Pages

    ACC 561 Week 1 Financial Statement Review

    This information important to Walmart investors because most investors invest more to a company earning revenue and growing. Invertores do not like to invest in a company tha is not profiting.…

    • 312 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Good Essays

    COMPARISON WALMART AND TARGET
    • 1463 Words
    • 8 Pages

    COMPARISON WALMART AND TARGET

    A review of core operating data shows that annual sales improved by 399 million and 98.2 million for Wal-Mart and Target, respectively. This resulted in Wal-Mart improving net income by 36.1%, and Target producing a 21.8% gain over the previous year. While Wal-Mart would appear to have improved dramatically, further review reveals that this improvement is due to a large reduction in income taxes, caused by a corresponding loss in business segment walmart.com. Because this segment is expected to reduce its losses in 2003, look for Wal-Mart to have a more modest improvement in net income.…

    • 1463 Words
    • 8 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Walmart's Value Chain Analysis Essay
    • 134 Words
    • 1 Page

    Walmart's Value Chain Analysis Essay

    The U.K. grocery market is highly diverse, with a wide range of formats, from convenience stores to hypermarkets, warehouse clubs and online stores. The market is currently led by five grocers (Tesco, Sainsbury, Wal-Mart‘s Asda, Morrisons and Cooperative Group), accounting for almost 55% of grocery retail banner sales, while the remaining 45% is attributed to hundreds of outlets scattered throughout the country (Planet Retail). Over the years, large players have continued to expand, both in terms of size, product range and services, increasingly taking market share from their smaller competitors.…

    • 134 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Powerful Essays

    Mba 685 Strategic Audit Paper
    • 4149 Words
    • 17 Pages

    Mba 685 Strategic Audit Paper

    Wal-Mart Stores Incorporated, or Wal-Mart as popularly known, is a publicly traded company. The company has continued to increase its sales income over the period of existence since 1962. Recent financial records revealed that net sales increased from $418.9Billion recorded in 2011 fiscal year to $443. 9 Billion in 2012 fiscal year, representing a percentage growth of 5.63%. A cursory look at the 2012 audited financial statement of Wal-Mart revealed that there was a continue deep in net sales between 2008 and 2010 fiscal year. This continued decline can be attributed to the state…

    • 4149 Words
    • 17 Pages
    Powerful Essays
    Read More
  • Good Essays

    10k vs Annual Report
    • 716 Words
    • 3 Pages

    10k vs Annual Report

    Every year Wal-Mart files an annual report to inform their share holders with the company’s most recent activities and financial position. The report’s intentions are to establish and maintain a relationship with its stock holders. In contrast, the 10k report files through Security Exchange Commission (SEC) for public companies to show their performance and operation statistics. The first intent is to provide detail statistics for serious investors and stock analysts. The second intent is to provide detail information of employment benefits for their employees.…

    • 716 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Target vs Walmart
    • 1770 Words
    • 8 Pages

    Target vs Walmart

    This paper will give a summary of Target corporation versus Wal-Mart stores, Incorporated. In the following weeks it will compare the financial performances of these two companies, by evaluating circumstances such as the times interest earned, return on equity, return on assets and other factors. This paper will present an overview of the exchanges on which both company’s stock is traded. It will also present characteristics of that particular exchange which may have led the company to be listed there versus another exchange. This summary will also explain the types of securities both Wal-Mart and Target have outstanding, such as the bonds, preferred stock or the common stock and thus will explain the characteristics of those securities and if they have assisted the company in gaining and raising capital. Finally it will explain the purposes of the four basic financial statements: the balance sheet, income statement, statement of retained income, and the statement of cash flow; which are found in each company’s annual report.…

    • 1770 Words
    • 8 Pages
    Powerful Essays
    Read More
  • Good Essays

    Wal-Mart Research Paper
    • 700 Words
    • 3 Pages

    Wal-Mart Research Paper

    In the first year of operation, sales at Wal-Mart stores were US $975,000. Ten years later, when the company was listed on the New York Stock Exchange in 1972, revenues had reached US $78million. The public listing provided the company with the resources to finance a more rapid expansion, and by 1979 sales had surpassed US $1 billion. The unbelievable growth was unstoppable. In 1990, the company topped the list of major retailers in the US. And five years later, Wal-Mart stores could be found in all 50 American states, in Mexico and Canada. In 2002 it became the world’s largest company in terms of sales. On January 31st 2005, Wal-Mart Stores reported net sales of US $285 billion, and had a presence in nine countries with 5,289 stores and 1.6 million employees worldwide. Wal-Mart offered multiple store purchasing options that included discount stores, supercentres, warehouse stores and neighborhood markets. Wal-Mart not only the largest company in the world, but also the most admired company in the US according to Fortune magazine. (Farhoomand, 2005)…

    • 700 Words
    • 3 Pages
    Good Essays
    Read More
  • Powerful Essays

    Walmart Finacial Analysis
    • 1235 Words
    • 5 Pages

    Walmart Finacial Analysis

    Based on this model, the PV of stock price of 2006 should be dividend $0.64/1.2%=$53.33, higher than the recent closing price of $49.47. It reaches a conclusion that we’d better buy the Wal-Mart stocks.…

    • 1235 Words
    • 5 Pages
    Powerful Essays
    Read More
  • Good Essays

    Financial Reporting Pt 1
    • 1292 Words
    • 4 Pages

    Financial Reporting Pt 1

    The total assets for Wal-Mart as of January 31, 2013 were $203,105,000. The reason this is important for a company or business to know, is so the business can have a better understanding of how much the company is worth. Knowing how much a company is worth is beneficial because the assets can be used as collateral for a loan. Also knowing the assets and comparing total assets to previous years can show if a company is growing and expanding or shrinking. For Wal-Mart, the comparison from the previous year shows that the total assets increased. As of January 31, 2012 the company showed total assets of $193,406,000. With the comparison from January 31, 2012 to the current figure from January 31, 2013 Wal-Mart grew and/or expanded in total assets by 9,699,000.…

    • 1292 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Walmart vs Target Financial Analysis Essay Example
    • 5153 Words
    • 21 Pages

    Walmart vs Target Financial Analysis Essay Example

    SUBMITTED BY: Amaresh Chandra Panda K H Gupta Mehul Shah SNDS Ramanish Sadhu Upasana Patra…

    • 5153 Words
    • 21 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Analyzing the Financial Statements of the World's Largest Retailer: Wal-Mart
    • 302 Words
    • 2 Pages

    Analyzing the Financial Statements of the World's Largest Retailer: Wal-Mart

    The Wal-Mart case is intended for an introductory or main course on Financial Statement Analysis. It may also be useful within a Corporate Finance/Financial Management course. After a class on financial statements and liquidity, profitability and solvency ratios – and some brief examples discussed by the lecturer – students should be capable of making a financial analysis of Wal-Mart. Students can be asked to make this analysis in class, or to prepare the case outside the classroom, and to present it. Ideally, the case work is conducted in groups of 4 to 6 students, and it typically takes between 1 to 1.5 hours (for the analysis itself – obviously, drafting a written report or presentation is more time consuming). The Wal-Mart case is aimed at both undergraduate and graduate students, and for general management programmes/MBAs as well as finance students – obviously, for the latter group, a much more fine-grained analysis, extensive discussion and adequate linking among various financials and between the numbers and Wal-Mart’s business is required. Evidently, the lecturer should highlight many more details in a class of finance students.…

    • 302 Words
    • 2 Pages
    Satisfactory Essays
    Read More