Assignment

The company is Google

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

2. 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:

2. 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.

3. 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)

2. 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?

3. 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).