Premium Essay

Wal-Mart Case Valuing Wal-Mart Stock Questions

In:

Submitted By le0nhart01
Words 302
Pages 2
Wal-Mart Case

Valuing Wal-Mart Stock
Questions:
1. Assess the financial health of Wal-Mart based on an analysis of the financial statements.

2. Based on any additional available information (including annual reports and 10-K filings) assess the economic conditions (as of the time of the case), the industry key success factors and competitive situation, and Wal-Mart’s strengths and weaknesses.

3. Develop a pro forma income statement and balance sheet for Wal-Mart for the fiscal year ending January 31, 2006. Assume the following (in addition to information in the case): selling, general and administrative expenses at 17.3 percent of anticipated net sales; interest on debt at an average rate of four percent; similar number of shares outstanding as of January 31, 2005: similar prepaids, other assets, accrued liabilities, deferred taxes and minority interest as in 2005. State any other key assumptions. How profitable do you anticipate Wal-Mart will be? Will Wal-Mart need to increase its reliance on external borrowing?

4. Determine the intrinsic value of Wal-Mart (on a per share basis) using the dividend discount model (DDM). Assess the value based on three forms of the DDM: the constant growth version, an assessment based on three years of projected dividends and a projected future stock price, and the three-stage DDM. Clearly state any assumptions including an estimation of Wal-Mart investor required returns.

5. Determine the intrinsic value of Wal-Mart (on a per share basis) using the price-earnings (P/E) approach. As part of your analysis you will need to determine an appropriate forward-looking P/E multiple. Clearly state any assumptions.

6. Based on your analysis, as Rachel Martin, what recommendation would you make? Justify your recommendation and reconcile any differences in your valuation assessments (based on different methods)

Similar Documents

Premium Essay

Walmart

...Management 2014 Graded case 1: Valuing Wal-Mart Read the case material (case 906N09) regarding Wal-Mart's stock. The situation described is that of early 2006. We'll first analyse Wal-Mart at that point in time, and later compare how the analysis made with data up to 2005 holds up 8 years later. Use the data provided in the case unless stated otherwise. If you want to use extra data, feel free to do so (it might be rewarded if it contributes to the quality of your answers!) but mention this explicitly, with reference to your source(s). Prepare a report (this will be handed in through Blackboard, the exact procedure will be posted there) that answers the following questions. Show your calculations in the report! I. Regarding the situation at the start of 2006: A.Value Wal-mart's stock using the dividend discount model. Include in your answer valuations based on the following assumptions: 1. constant growth of dividends; use the data in exhibit 3. 2. a multi-stage development of dividends (analogous to the three-stage approach by Bloomberg mentioned in the case) For both models, use both an 8% and a 9% discount rate. Comment on the differences. B. Assuming Wal-Mart (to be precise, its revenue) keeps growing at 13.7% a year, and the US economy grows at 3% a year, in which year would Wal-Mart be bigger than the US economy? (assume that the size of the US economy in 2006 was $ 12500 billion). What are the implications of this curious bit of information? C. Determine Wal-Mart's stockvalue...

Words: 465 - Pages: 2

Premium Essay

Finance Case Study

...FIN 6310 Case Studies Purchase Case Studies (4) • Harvard Case Studies (2) o Courses available at o https://cb.hbsp.harvard.edu/cbmp/access/18322840 • Ivey Case Studies (2) o Register for an account at Ivey Cases https://www.iveycases.com/RegisterUser.aspx o Put the following two cases studies in your cart. Make sure Digital Download is selected which will cost $3.40 per case. o Burgundy Asset Management: The Wescast Investment Decision https://www.iveycases.com/ProductView.aspx?id=31479 o Valuing Wal-mart 2010 https://www.iveycases.com/ProductView.aspx?id=48332 o Download the Wal-mart case spreadsheet for free. o Valuing Wal-mart 2010 – Spreadsheet for students https://www.iveycases.com/ProductView.aspx?id=52705 Case Report Guidelines 1. Place case title at top of first page with team member names (maximum four members per team). 2. Answer questions in numerical order. 3. Include graphs and tables if appropriate. 4. Print out case report and hand-in at the beginning of class. Harvard Management Company (2001) Questions 1. Is HMC’s recent payout policy consistent with the goal of preserving the real (adjusted for Harvard’s expense growth) value of the endowment and its distribution into perpetuity? 2. Could payout be raised to meet recent budget pressures without changing the risk-return profile of the portfolio? 3. What value has the HMC’s policy portfolio...

Words: 1092 - Pages: 5

Premium Essay

Walmart vs Target

...Wal-Mart VS Target Group Analysis [Type the author name] 4/21/2013 [A group analysis of the two top retailers; Wal-Mart and Target. This paper will discuss the SWOT of both companies as well as give an in depth analysis of both companies as big competitors.]   1962 was the year of creation. That is when two great companies were founded, Target and Wal-Mart. Target opening saying it’s a “new idea in discount stores”. Wal-Mart was the retailer who “focused on helping customers and communities save money and live better”. The two companies opened with the same ideas in mind. Sam Walton opened Wal-Mart’s first store in Rogers, Arkansas while Target was opened in Roseville, Minnesota by the Dayton Company. Later that year Target opened three more stores in St. Louis Park, Crystal and Duluth, Minnesota. Over the years the companies have managed to create household names for themselves that have lasted for over 50 years. Target and Wal-Mart have many things about their companies in common, strategy isn’t one of them. These companies seem to take two different approaches and it works in both persons favor. They both are leaders in different aspects therefor making them great competitors. Wal-Mart has 3 different strategies. Focus strategy is usually defined as: focusing on offering products and services to a particular market segment or buyer group, within a segment of a product line, and/ or to a specific geographic market. The differentiation strategy is defined...

Words: 3594 - Pages: 15

Premium Essay

International Business Chapter 003

...Differences in Culture Chapter Outline OPENING CASE: McDonald’s in India INTRODUCTION WHAT IS CULTURE? Values and Norms Culture, Society, and the Nation-State The Determinants of Culture SOCIAL STRUCTURE Individuals and Groups Social Stratification Country Focus: Breaking India’s Caste System RELIGIOUS AND ETHICAL SYSTEMS Christianity Islam Country Focus: Islamic Capitalism in Turkey Hinduism Buddhism Confucianism Management Focus: DMG-Shanghai LANGUAGE Spoken Language Unspoken Language EDUCATION CULTURE AND THE WORKPLACE CULTURAL CHANGE FOCUS ON MANAGERIAL IMPLICATIONS Cross-Cultural Literacy Culture and Competitive Advantage SUMMARY CRITICAL THINKING AND DISCUSSION QUESTIONS CLOSING CASE: Wal-Mart’s Foreign Expansion Learning Objectives 1. Know what is meant by the culture of a society. 2. Identify the forces that lead to differences in social culture. 4. Identify the business and economic implications of differences in culture. 5. Understand how differences in social culture influence values in the workplace. 6. Develop an appreciation for the economic and business implications of cultural change. Chapter Summary This chapter begins by introducing the concept of culture. The determinants of culture are identified, which include religion, political philosophy, economic philosophy, education...

Words: 7579 - Pages: 31

Premium Essay

Walmart

...|Wal-Mart Stores, Inc. (WMT) |February 25, 2006 | |Hold | |WMT: Competitive and Financial Analysis | |By: Ryan Hummer | Company Profile Wal-Mart Stores, Inc. (Wal-Mart) operates retail stores in various formats worldwide. The Company organizes its business into three principal segments: Wal-Mart Stores, SAM'S CLUB and International. The Wal-Mart Stores segment is the largest segment of Wal-Mart's business, accounting for 67.3% sales during the fiscal year ended January 31, 2005 (fiscal 2005). The segment consists of three different retail formats, all of which operate in the United States. The Company's SAM'S CLUB segment consists of membership warehouse clubs that operate in the United States, and accounts for 13% of fiscal 2005 sales. The international segment consists of retail operations in eight countries and Puerto Rico, and generated 19.7% of Wal-Mart's fiscal 2005 sales. In addition, the Company owns an unconsolidated...

Words: 8335 - Pages: 34

Premium Essay

Syllabus Bmgt343

...contact) Office: 4426 Van Munching Mobile Phone: (240) 507 9877 Course Notes are on Canvas Office Hours: Tuesdays & Thursdays, 2pm to 3pm, and I am always available so always feel free to contact me. Class meeting venue and time: Section 0201 Tuesdays & Thursdays, 11am to 1215pm, VMH 1418 Section 0301 Tuesdays & Thursdays, 1230pm to 145pm, VMH 1418 Review sessions by the TA: some Thursdays, 5pm to 6pm, Review sessions by the instructor: some Fridays, 1245pm to 145pm, II. Course Description and Objectives • Required Textbook “Essentials of Investments”, by Bodie, Kane, and Marcus, McGraw-Hill, 9th edition • Required Course packet Purchase the course packet at: https://cb.hbsp.harvard.edu/cbmp/access/27906209 The course packet contains four cases. • Course Overview This course is an introductory course in investments. We cover the following topics (the chapters are from BKM): Note: The schedule given below is only tentative, and may be changed based on the progress of the class. It is a student’s responsibility to read the assigned chapters, as information in them may be part of a quiz or an exam. Week Week 1 Week 2 Week 3 BMGT343 Topic Introduction Debt securities – I Debt securities – II Reading Chapter 1, 2, and 3 Chapter 10 Chapter 11 Xiaohui Gao Bakshi Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Portfolio theory I - Risk and return Portfolio theory II – Efficient diversification The capital asset pricing model (CAPM) Empirical tests of CAPM Market efficiency Midterm...

Words: 1828 - Pages: 8

Premium Essay

Target

...UVA-F-1563 Rev. Jan. 22, 2013 TARGET CORPORATION On November 14, 2006, Doug Scovanner, CFO of Target Corporation, was preparing for the November meeting of the Capital Expenditure Committee (CEC). Scovanner was one of five executive officers who were members of the CEC (Exhibit 1). On tap for the 8:00 a.m. meeting the next morning were 10 projects representing nearly $300 million in capital-expenditure requests. With the fiscal year’s end approaching in January, there was a need to determine which projects best fit Target’s future store growth and capital-expenditure plans, with the knowledge that those plans would be shared early in 2007, with both the board and investment community. In reviewing the 10 projects coming before the committee, it was clear to Scovanner that five of the projects, representing about $200 million in requested capital, would demand the greater part of the committee’s attention and discussion time during the meeting. The CEC was keenly aware that Target had been a strong performing company in part because of its successful investment decisions and continued growth. Moreover, Target management was committed to continuing the company’s growth strategy of opening approximately 100 new stores a year. Each investment decision would have long-term implications for Target: an underperforming store would be a drag on earnings and difficult to turn around without significant investments of time and money, whereas a top-performing store would add value both financially...

Words: 6104 - Pages: 25

Premium Essay

Science Technology

...Sarmas www.csupomona.edu/~psarmas CATALOG DESCRIPTION: A seminar course in finance utilizing comprehensive cases to simulate the role of the financial manager. 3 seminar-discussion. Prerequisite: GBA 546, all required 500-level courses, and microcomputer proficiency. Concurrent enrollment in GBA 646. Unconditional standing requirement. EXPANDED DESCRIPTION OF THE COURSE AND INSTRUCTIONAL METHODS: A. Expanded Description of the Course: This course reinforces the basic concepts of financial management. The course provides an in-depth discussion of key topics that are critical to financial management: (1) the goals of the firms, (2) financial statement analysis, planning, and forecasting, (3) working capital policy and management, (4) capital budgeting techniques without and with risk, (5) capital structure theory and application, (5) the cost of capital estimation, and (6) long-term financing decisions. In addition, the course examines issues such as lease financing, merger and acquisition, and international financial management. B. Instructional Methods: The delivery system throughout this course will be a combination of class discussion and case analysis. The case analysis will be both in a written format and oral presentation. The amount of lecture will be limited to detailed coverage of concepts pertaining to each individual case. REQUIRED BACKGROUND OR EXPERIENCE: A. Prerequisites: Fundamental of Financial Management (GBA 546), all required...

Words: 3255 - Pages: 14

Premium Essay

Stud

...and have got it wrong Don’t pity the kirana guy, he knows how to fight back Economy, not kirana shops, is biggest loser in retail FDI debate Why the kirana dukan doesn’t care about Big Brother 11 13 15 17 All sides of the debate GOVERNMENT FDI in retail ‘distinct and different’: Sharma Out on a limb: Govt says FDI in retail will ‘immensely benefit farmers’ Reader debate: Is FDI in retail bane or boon? PUBLIC India Inc appeals political parties to support FDI in retail India Inc divided over FDI in multi-brand retail INDUSTRY FDI in retail: Opposition, allies term it anti-people Will not allow Parliament to function until FDI in retail is withdrawn: NDA OPPOSITION Why some farmers are relieved to be dealing with Wal-Mart Farmers Retail FDI: The merits are over-hyped, say academics Academics Cong meets over FDI in retail: Is a rollback on the cards? Will FDI last? FDI nod given, global retailers wait for more clarity The world is waiting FDI in retail What is ? Retail battle: It’s finally about politics and numbers, not FDI he Congress is hell-bent on pushing through its proposal for foreign direct investment (FDI) in retail. It says the move would create jobs and curb inflation besides creating infrastructure which the agriculture sector lacks. However, the bigger motive is to fight the overwhelming perception that the government is caught in a policy paralysis and is unable to take decisions. The entire opposition...

Words: 12610 - Pages: 51

Premium Essay

Whole Foods - Financial Analysis

...the food and drink intake of the world in general, but specifically the American people. Some grocery and supermarket companies such as Whole Foods Market have embraced this change with open arms and in turn built reputable, profitable companies. These companies are built around the general premise that natural and organics are better products for human beings to consume. It has become a new way of thinking throughout the United States with both producers and consumers reaping the benefits. The health consequences obviously affect the consumer, while the producers – i.e. Whole Foods Market – seek to better enhance the lives of the consumer while at same time creating financial stability for shareholders and stakeholders alike. The question for the future remains: is this just a fad or the latest trend, or will Whole Foods Market be able to retain its financial prowess for years to come? As a recent SWOT analysis indicates (“Whole Foods Market, Inc.,” 2010), “Whole Foods Market is a natural and organic foods supermarket chain that operates through several wholly owned subsidiaries” and “offers a broad and differentiated product selection with a strong emphasis on perishable foods designed to appeal to both natural and organic food and gourmet shoppers” (p.1). Their stores are oftentimes very large in size, offer an incredible array of products, and promote a healthy lifestyle in foods, drinks, and other consumable/personal care products. With a robust organization, Whole...

Words: 2698 - Pages: 11

Premium Essay

Blue Nile and Diamond Retailing

...The learning objectives of the case are to (1) understand the link between supply chain structure and financial performance, (2) identify key drivers of supply chain performance and how they affect a firm's ability to respond during periods of strong or weak demand, and (3) develop the alignment between supply chain structure and strategic position for a firm. To this end, the case highlights the supply chain structures and performances of three firms in the diamond retailing industry: Blue Nile, Zales, and Tiffany. Blue Nile’s supply chain structure is geared toward a pure centralized e-business; Zales sells merchandise primarily through stores but recently added an online channel; and Tiffany also uses an online channel but most of its diamond and other high-end products are sold through stores. The case is designed to foster discussion of the three supply chain structures and encourage students to evaluate the firms’ performance in terms of components of customer service such as response time, product variety, product availability, customer experience, order visibility, and returnability, coupled with cost factors that include inventory, transportation, information, and facilities. 1. What are some key success factors in diamond retailing? How do Blue Nile, Zales, and Tiffany compare on those dimensions? As with most retailing, the key success factors in diamond retailing can be measured by customer service factors and cost factors. Given the varied supply chain components...

Words: 2496 - Pages: 10

Premium Essay

Marketing

...Final Exam Study Questions: Fall 2010 MKT201 1. Describe and discuss total revenue, average revenue, and marginal revenue. • Total revenue- price x quantity (money received from the sale) • Marginal Revenue- change in total revenue/ change in total sales (additional revenue added by an additional unit of output, or in terms of a formula) • Average Revenue- the revenue generated per unit of output sold. It plays a role in the determination of a firm's profit. Per unit profit is average revenue minus average (total) cost. 2. Explain how to conduct a break even analysis. Show how a break-even point is calculated. Illustrate what a break even chart looks like. 3. What is a marketing channel? What is its function? • is a set of practices or activities necessary to transfer the ownership of goods, and to move goods, from the point of production to the point of consumption and, as such, which consists of all the institutions and all the marketing activities in the marketing process. 4. Describe and explain the relationship between marketing channels, supply chains, supply chain management, and logistics management. Provide examples. 5. Define Marketing and Social Marketing. Explain the similarities and differences between commercial and social marketing. 6. Discuss and describe the three forms of consumer ads. Discuss and describe the three forms of industrial ads. • 486-487 • 3 types • Consumer Product: focus on selling...

Words: 1290 - Pages: 6

Premium Essay

Amazon vs Ebay

...Case study eBay, Inc. And Amazon.com Introduction The case that we present concerns two of the most famous companies in the world: Amazon.com and eBay,Inc.. They have become so ubiquitous that probably there is not a household with a computer and internet connection in the world that hasn’t purchased at least one item from them or visited their websites at least once . In the following paragraphs we endeavor to analyze how these two companies have achieved this worldwide success and how they are defined by all as online giants and colossus. But above all, we will focus on how they differ from each other, what are their strengths and weaknesses, what their business model is and how it has changed over the course of time. We will discuss briefly the history of these two giants and explain how they deal and cope with this ever-changing market and business environment. We will start with the background of these two companies, and then analyze the differences in terms of business models, focusing on financial data, services provided, overall stakeholder value and customers’ perception. Background of eBay EBay was launched by Pierre Omidyar in 1995, and referring to his own words, his purpose was giving “ the power of the market back to individuals, not just large corporations”...and his goal was “pioneer new communities around the world built on commerce, sustained by trust and inspired by opportunities”. It is important for us to underline the words of Omidyar because...

Words: 4922 - Pages: 20

Premium Essay

Workbrain

...Assignment #3 – FEED Recovery Resources – Sourcing Funding Opportunities Michael Field Professor Steven Droll New Business Venture and Entrepreneurship May 24, 2014 Table of Contents | Section | Page | Abstract ………………………………………………………………….. | 3 | Introduction – Gaining Financing to Execute Business Plan...……………… | 4 | Source of Competition………………………….……….……………………. | 5 | Venture Capitalists Pursuit of Green Technology….……………………….. | 6 | Timing of Investment by Venture Capitalist…………………………………. | 7 | Friends and Family Financing……………………………………………….. | 10 | Angel Investor as Other Source of Capital………………………………….. | 12 | Conclusion …………….…………………………………………………….. | 13 | Abstract Shane Eten and Ryan Begin need to gain $250,000 in financing to launch their business venture, FEED Resource Recovery. Their business plan has gained some traction in presentations to venture capitalists without anyone taking the plunge. They have also gained some interest from potential customers, but have not secured commitments from anyone. Their current efforts focus on securing funding from available sources. As they approach potential investors, they need to acknowledge the possible downsides to their business plan including the invasion of competitors into their identified markets as well as a realistic valuation for the business based upon their lack of customers and lack of product prototype. Nevertheless, their focus on funding could emphasize friends and...

Words: 3716 - Pages: 15

Premium Essay

Ferrell's Law

...Chapter 2 Business Ethics and Social Responsibility Chapter Outline Introduction Business Ethics and Social Responsibility The Role of Ethics in Business Recognizing Ethical Issues in Business Improving Ethical Behaviour in Business The Nature of Social Responsibility Social Responsibility Issues Objectives After reading this chapter, you will be able to: • Define business ethics and examine its importance. • Detect some of the ethical issues that may arise in business. • Specify how businesses can promote ethical behaviour. • Define social responsibility and explain its relevance to business. • Debate an organization’s social responsibilities to owners, employees, consumers, the environment, and the community. • Evaluate the ethics of a business’s decision. Enter the World of Business The Leopard Did Change His Spots—They Grew The son of a wealthy brewery executive, Conrad Moffat Black was born August 25, 1944, in Montreal. After leaving home at age 18, he earned a history degree at Carleton University, a law degree at Laval, and an MA from McGill. An avid student of history, he has written several books (including an autobiography) about political figures such as Maurice Duplessis, Napoleon, and most recently, Franklin Roosevelt. Mr. Black purchased his first newspaper, the Sherbrooke Record, when he was 25 years old. Two years later, he added about 20 Canadian newspapers to his belt with the acquisition of the Sterling Company chain. Five years later, at age 33...

Words: 14163 - Pages: 57