Company Valuation 1. Analysis of WACC a. Calculation of WACC for your company: M
ID: 2793675 • Letter: C
Question
Company Valuation
1. Analysis of WACC
a. Calculation of WACC for your company:Macdonald’s Corporation (MCD)
You will need to identify each component of the WACC formula and calculate the overall WACC.
The WACC formula for a company that uses debt and equity is as follows:
WACC = % Debt * Cost of Debt * (1 - Tax Rate) + % Equity * Cost of Equity
*You should use Yahoo! Finance and / or the company's most recent 10K report to identify all financial statement inputs. You can use the following guide for the inputs. The specific financial statement data are found on the relevant financial statement. Debt = Long-term Debt + Short-term Debt (on Yahoo! this is called, "Short/Current Long Term Debt") This has to be done in Microsoft excel.
Equity = Market Cap. (This is on the Key Statistics page in Yahoo! Finance)
% Debt = Debt / (Debt + Equity)
% Equity = 1 - % Debt
Cost of Debt = Interest Expense / Debt
Tax Rate = Income Tax Expense / Income Before Tax
Cost of Equity: Use the CAPM equation to calculate this
Cost of Equity = Risk free rate + Beta * (Market Risk Premium)
Risk free rate: look up the yield on 10 year US Treasury bonds 2.34
Beta: This is on the Key Statistics page in Yahoo! Finance
Market Risk Premium: Assume 11% minus the risk-free rate
b. Interpretation of WACC for Your Company
*Indicate what the WACC value you derived means for your company.
*What role does the WACC play for company managers when they are evaluating new projects to undertake?
*How would company managers and investors use the WACC for an overall company valuation analysis?
This has to be done in excel and you have to use yahoo finance. Can you show your work and explan. Thaks
Explanation / Answer
a)First listing all the data from google finance;
Equity= 135.86 Billion
% debt = 25.96/(25.96+135.86)=16.04%
% equity = 1 - 0.1604= 83.96%
cost of debt= not mentioned in yahoo finance so I am assuming it to be zero
tax rate = 2179500/6866000=31.74%
risk free rate= 2.39%
beta = 0.82
cost of equity using CAPM = 2.39 + 0.82( 11-2.39)=9.45%
WACC = % equity*cost of equity= 0.8396*9.45=7.93% ( since cost of debt is zero)
b.So the WACC is the net rate of return that the company must generate for the debt holder and share holders as a whole.
So while evaluating new projects ,WACC is the discount rate that they use to value any project.
WACC is the minimum rate that the investors( both debt and equity) must get in order to justify present valuations.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.