FIN515 Second Course Project

Topics: Stock, Weighted average cost of capital, Corporate finance Pages: 8 (1079 words) Published: April 13, 2015


Weighted Average Cost of Capital: Home Depot, Inc.
Second Project
FIN515 – Managerial Finance
Instructor: Prof. David Eichenholtz
Group:
John Okogeri
Fiona Harrison-Butts
Haider Chaudhry
Mia O’Blenis
Christopher Cardenas
Date: April 5, 2015

TABLE OF CONTENTS

Introduction3
company profile3
WACC calculation4
explanation of calculation/results5
Limiting factors5
Conclusion6
references7

Weighted Cost of Capital: Home Depot, Inc.

Introduction
The purpose of this project is to find the Weighted Average Cost of Capital (WACC) for Home Depot. Investopedia.com reveals that the WACC is “a calculation of a firm's cost of capital in which each category of capital is proportionately weighted. All capital sources - common stock, preferred stock, bonds and any other long-term debt - are included in a WACC calculation. All else equal, the WACC of a firm increases as the beta and rate of return on equity increases, as an increase in WACC notes a decrease in valuation and a higher risk” (Investopedia.com). We will attempt to provide information regarding the following: 1. Description of how we achieved the WACC. 2. Calculations used to obtain WACC. 3. Explanation of the results. 4. Sources of our data. 5. Discussion of confidence level in our answer, as well as any limiting assumptions if applicable. Company Profile

Before going directly into the weighted average cost of capital, it is desirable to provide the profile of the targeted company. The Home Depot, according to Bloomberg Businessweek was founded in 1978 by Bernie Marcus and Arthur Blank. Along with investment banker Ken Langone and merchandising Guru Pat Farrah. The company is headquartered in Atlanta, GA where it opened its first store. According to Bloomberg Businessweek, as of Feb. 2014 Home Depot had 2,263 stores located throughout the US, Puerto Rico, US Virgin Islands, Guam, Canada and Mexico. It currently has 365,000 employees and offer a wide range of building materials, home improvement items, gardening, patio and electrical products targeting mostly professional and do-it-yourself customers. Annual revenue grew to $78.8B in 2014. WACC Calculation

Tax Rate = 40%
Cost of Debt (before tax) or R debt = 5.875%
Cost of Equity or R equity = 6.59%
Debt (Total Liabilities) for 2012 or D = $29.600 billion
Stock Price = $82.01 (Jan, 12th 2014)
Outstanding Shares = 1.41 billion
Equity = Stock price x Outstanding Shares or E = $115.634 billion Debt + Equity or D+E = $145.234 billion
WACC = R = (1 – Tax Rate) x R debt (D/D+E) + R equity (E/D+E) (1 – Tax Rate) x R debt (D/D+E) + R equity (E/D+E)
(1 – 0.4) x .05875 x ($29.600 /$145.234) + .0659 ($115.634 /$145.234) 0.6 x .05875 x .2038 + .0659 x .7962
Hence: WACC = .0072 + .0525 = 5.97%
Explanation of Calculation/Results
The formula for the Weighted Average Cost of Capital (WACC) is: WACC=rD (1-Tc)*(D/V)+rE*(E/V).
To have a better understanding everything is broken down as follow: •rD = The required return of the firm’s debt Financing. •(1-Tc) = The Tax adjustment for interest expense.
(D/V) = (Debt/Total Value). The % of the firm's value that is comprised of debt. •re= The firm’s cost of equity.
The firm's cost of equity is best (or, at least, most easily) calculated using the CAPM (Capital Asset Pricing Model). Cost of Equity rE = rf + B(rM - rf) where:
rf = the 'Risk Free' rate of return
B = the firm's 'Beta'; the correlation between the firm's returns and the market rM = the historical "Market" return
(E/V) = (Equity/Total Value). The % of the firm's value that is comprised of Equity is derived from the firm's intra-day market cap (stock price x shares outstanding). Based on the calculations above, we can conclude that Home Depot pays 5.97% on every dollar that it finances, or 5.97 cents on every dollar. This calculation shows that on every dollar the company spends on an investment, it must make...

References: Borad, S. (March 2015). Weighted Average Cost of Capital (WACC) | eFinanceManagement. Retrieved April 9, 2015, from http://www.efinancemanagement.com/investment-decisions/weighted-average-cost-of-capital-wacc
Boundless.com. (April 2015). Problems with WACC. Retrieved April 9, 2015, from http://www.boundless.com/finance/textbooks/boundless-finance-textbook/introduction-to-the-cost-of-capital-10/the-wacc-90/problems-with-wacc-389-10508/
Home Depot Inc. (2014). Bloomberg Businessweek. Retrieved April 1, 2015 from
http://investing.businessweek.com/research/stocks/snapshot/snapshot_article.asp?ticker
Home Depot Inc. (2014). Fundamental Analysis WACC, Cost of Debt and Cost of Debt and Cost
of Equity. Retrieved March 31 from web site: www.stockresearching.com/2014/01/12.
Investopedia.com. (April 2014). Weighted Average Cost of Capital (WACC) Definition,
Investopedia. Retrieved 4/6/2015 from http://www.investopedia.com/terms/w/wacc.asp
MarketWatch (2014), Home Depot Inc. The Wall Street Journal. Retrieved April 1, 2015 from
http://www.marketwatch.com/investing/stock/HD?countrycode=US
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Second Course Project 2 15
  • Finance Course Project Essay
  • Course Project Essay
  • Fin515 Project 2 Research Paper
  • Fin515 Project Week 7 Essay
  • Essay on FIN515 Week 3 First Course Project
  • Busn379 Week 6 Course Project Part 2 Essay
  • Course Project Essay

Become a StudyMode Member

Sign Up - It's Free