Company overview analysis part 3 on microsoft

Don't use plagiarized sources. Get Your Assignment on
Company overview analysis part 3 on microsoft
Just from $13/Page
Order Now

The Module 6 course project assignment let’s you explore the company-level valuation, combining many aspects of the entire course into one activity. The requirements of the assignment are as follows:

  1. Calculate the Intrinsic Value of Your Company:

You will use the Discounted Cash Flow (DCF) valuation model to calculate the intrinsic value of your chosen company. This model involves three primary steps: i) calculating the company’s cost of capital, ii) calculating the free cash flows to the firm, and ii) applying the time-value-of-money concept to discount your projected cash flow values back to the present using the company’s cost of capital as the discount rate.

  1. Calculating the Cost of Capital:
    1. The company’s cost of capital can be calculated using the Weighted Average Cost of Capital (WACC) formula:

    WACC = D/V * eD *(1-Tc) + E/V * rE

    1. Using the website, ThatsWACC (www.thatswacc.com), enter your company’s “ticker symbol”, identify the relevant terms from above and calculate the WACC (please show your calculations).
  2. Calculating Free Cash Flow to the Firm:
    1. Estimate the free cash flows available to the firm (“FCFF”). To do this we can use the below formula:

FCFF = Cash Flow from Operations – Capital Expenditures + Interest * (1 – Tax Rate)

  • The Cash Flow from Operations and Capital Expenditures can be found on the Statement of Cash Flows in Yahoo! Finance.
  • The Interest expense (if any exists) is on the Income Statement.
  • The Tax Rate is the one you used to calculate the WACC, above.
  • For additional details on these calculations please refer to this external resource.
  1. Calculating Firm Value:
    1. You can now combine the two items above to estimate a present value of the firm. To simplify this calculation you should assume a constant growth rate of 3% in the Free Cash Flows to the Firm and apply the constant growth model:

    Firm Value = FCFF * (1+g) / (WACC – g)

  1. Comparison to Market Capitalization:
    1. On the Key Statistics page in Yahoo! Finance identify and indicate the Market Capitalization (“market cap”). What does this value represent?
    2. Compare the market cap to your calculated value.
      1. To compare the market cap from Yahoo! Finance to the firm value you calculated in the previous section above you need to first subtract the value of the debt from your firm value calculation.
      2. How does your intrinsic value (less debt) compare to the market cap of the company on Yahoo! Finance?
      3. What might account for any differences between these two values?
  2. Paper Mechanics should be as follows:
    1. There is no minimum page length requirement for this paper.
    2. The paper should be in APA format (i.e. cover page, double-spaced, 12 pt font, reference section at end, etc.).
    3. The paper should include at least 1 source, such as the annual report, Yahoo! Finance or Google Finance, the company’s web site, etc.
    4. The paper should be divided into the sections indicated above (label each section clearly).

Recent Blog Posts

No recent articles to show.

Other Blog Posts

What are the key elements of an essay

You may clearly understand what an essay is and have had the experience of writing a number. However, it is […]

Feb 25th, 2022

How to write a research paper fast

The day inevitably comes; you need to submit your assignment. You have been procrastinating on writing your paper until the […]

Feb 24th, 2022

220+ best humanities research paper topics

Choosing a paper topic can be a daunting task for any assignment. A student may face agony trying to come […]

Feb 24th, 2022

How to write a media analysis essay

The media is an integral part of modern society. Think of what would happen to the world if there were […]

Feb 23rd, 2022

Great tricks on how to write a hypothesis in 2022

A hypothesis is a statement that can be proven by scientific research. It proves the theory of action and reaction, […]

Feb 22nd, 2022

How to get better at math

Math is not difficult. However, it is complex and tough compared to other subjects and requires a little bit more […]

Feb 22nd, 2022