Purchase Solution

Wal-Mart Employee Stock option (ESO) in valuation

Not what you're looking for?

Ask Custom Question

See the attahced file. I have compiled a very comprehensive excel workbook. I am seeking guidance on the items highlighted in YELLOW:

1. Please double check the WMT FCF Facaset tab - PV of cash flows is 1.3 Trillion seems very high. All forecast are based on own assumptions.

2. on WMT Marginal Rate tESO tab see Yellow item - where is the avg stock price at exercise in the 10K???

3. on WMT Oustanding ESO tab see Yellow item - where is this in the 10K???

I am just looking for guidance on where some numbers are in the 10K and a formula in excel.

** See ATTACHED file(s) for complete details **

Attachments
Purchase this Solution
Solution Summary

The solution examines Wal-Marts employee stock option in valuation.

Purchase this Solution
Free BrainMass Quizzes
Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

View More Free Quizzes
Related BrainMass Solutions

  • ESO Plan For Costco Valuation

    Perform your valuation in Excel; use appropriate formulas/equations Attached is the Excel file with the computations. This solution contains an Employee Stock Option (ESO) plan for Costco's company valuation in an Excel sheet.

  • Special Issues in Valuation

    453061 Special Issues in Valuation Excel Spreadsheet Incorporate an employee stock option (ESO) into a company's valuation.

  • ESO Plan

    144629 ESO Plan Incorporate an ESO plan into a company's valuation. For your company (Dell, Inc), incorporate the effect of the Employee Stock Option (ESO) plan into the common equity valuation.

  • Capital Valuation - Walmart

    Capital Valuation of Wal-Mart The capital structure of Wal-Mart includes both debt and equity in terms of long term debt and common stock shares respectively.

  • Financial analysis of Wal-Mart compared to Target

    Attached in the excel file 4. Obtain industry averages for each from firm from Reuters.com and compare. Attached in the excel file Explanatory note: Comparison 2009 2009 Industry ratio Wal-Mart Target a.

  • Wal-Mart's Motivational Strategies

    433831 Wal-Mart's Motivational Profile Using Wal-mart which Motivational strategies - identify which of the following strategies the Wal-mart uses to motivate employees: a. Employee empowerment b. Selection and training c.

  • Evaluate the use of heuristics in valuing a firm

    343179 Evaluate the use of heuristics in valuing a firm Consider the following excerpt from a prudential report on Wal-Mart, dated May 13, 2003. The report states: We are maintaining our Hold rating on Wal-Mart as we believe the stockâ??

  • Explain types of stock options and their effect on a company

    Employee stock options (ESO), incentive stock options (ISO) and non-qualified stock options (NQSO or NSO) are all types of employee stock options which vary mostly because of the differences in tax treatment and timing.

  • determining current futures prices

    On the basis of returns on these investment alternatives, stock of Wal-Mart is the best option for investment as it would cause an increase in the investment value of the investors.

View More Related Solutions