Subscribe to Stock Researching via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 56 other subscribers

Seeking Alpha Certified

Home Depot: Fundamental Analysis WACC, Cost of Debt and Cost of Equity $HD

image001Understanding Home Depot’s (NYSE:HD) cost of debt, cost of equity and WACC is an important factor in stock research. Using these formulas an investor will understand how much the shareholder should expect in return for the stock over the long-term, how much the company pays for its debt and how much the company needs in return to break even on its investments.

Cost of Debt

The cost of debt is the effective rate that a company pays on its total debt.

As a company acquires debt through various bonds, loans and other forms of debt, the cost of debt is a useful metric. It gives an idea as to the overall rate being paid by the company to use debt financing. This measure is also useful because it gives investors an idea as to the riskiness of the company compared with others. The higher the cost of debt, the higher the risk.

8. Cost of debt (before tax) = Corporate Bond rate of company’s bond rating.

  • Hm Depot 5.875%= 5.875%
  • Current cost of Debt as of January 12, 2014 = 5.875%

9. Current tax rate

  • 2014 TTM – = 36.36%

2014 TTM Home Depot has averaged tax rate of 36.36%

10. Cost of Debt (After Tax) = (Cost of Debt Before Tax) (1 – Tax Rate)

The effective rate that a company pays on its current debt after tax.

  • .05875 x (1 – .3636) = Cost of debt after tax

The cost of debt after tax for Home Depot is 3.74%

Cost of Equity or R Equity = Risk Free Rate + Beta Equity (Average Market Return – Risk Free Rate)

The cost of equity is the return a firm theoretically pays to its equity investors (for example, shareholders) to compensate for the risk they undertake by investing in their company.

  • Risk Free Rate = U.S. 10-year bond = 2.86% (Bloomberg)
  • Average Market Return 1950 – 2014 = 7%
  • Beta = (Google Finance) Home Depot’s Beta = 0.90

Risk Free Rate + Beta Equity (Average Market Return – Risk Free Rate)

  • 2.86 + 0.90 (7- 2.86)
  • 2.86 + 0.90 x 4.14
  • 2.86 + 3.73 = 6.59%

Currently, Home Depot has a Cost of Equity or R Equity of 6.59%, so investors should expect to get a return of 6.59% per-year average over the long term on their investment to compensate for the risk they undertake by investing in this company.

(Please note that this is the CAPM approach to finding the cost of equity. Inherently, there are some flaws with this approach and that the numbers are very “general.” This approach is based off of the S&P average return from 1950 – 2013 at 7%, the U.S. 10-year bond for the risk-free rate, which is susceptible to daily change and Google Finance beta.)

Weighted Average Cost of Capital or WACC

The WACC calculation is a calculation of a company’s cost of capital in which each category of capital is equally weighted. All capital sources such as common stock, preferred stock, bonds and all other long-term debt are included in this calculation.

As the WACC of a firm increases, and the beta and rate of return on equity increases, this is an indicator of a decrease in valuation and a higher risk. By taking the weighted average, we can see how much interest the company has to pay for every dollar it finances. For this calculation, you will need to know the following listed below:

Tax Rate = 36.36%

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 – .3636) x .05875 x ($29.600 /$145.234) + .0659 ($115.634 /$145.234)

.6364 x .05875 x .2038 + .0659 x .7962

.0076 + .0525

= 6.01%

Based on the calculations above, we can conclude that Home Depot pays 6.01% on every dollar that it finances, or 6.01 cents on every dollar. From this calculation, we understand that on every dollar the company spends on an investment, the company must make $.0601 plus the cost of the investment for the investment to be feasible for the company.

Understanding the WACC of a company is important because securities analysts employ WACC all the time when valuing and selecting investments. In discounted cash flow analysis, for instance, WACC is used as the discount rate applied to future cash flows for deriving a business’s net present value. WACC can be used as a hurdle rate against which to assess ROIC performance. It also plays a key role in economic value added (EVA) calculations.

Investors use WACC as a tool to decide whether to invest. The WACC represents the minimum rate of return at which a company produces value for its investors. Let’s say a company produces a return of 20% and has a WACC of 11%. That means that for every dollar the company invests into capital, the company is creating nine cents of value. By contrast, if the company’s return is less than WACC, the company is shedding value, which indicates that investors should put their money elsewhere.

Photo sourced by:

Leave a Reply