Home Depot DCF Stock Analysis. Buy or Sell?


Home Depot DCF Stock Analysis.

Here’s my assumptions:

Risk Free Rate (10 Years Interest Rate Swap): 3.95%

Risk Premium (Taken from the Aswath Damodaran equity premium spreadsheet): 4.62%

Interest Rate Spread on The Risk free rate ( For the cost of debt calculation): 5%

Historical Data

Revenue growth in the last 10 years (CAGR): 5.39%

Earnings growth in the last 10 years (CAGR): 5.93%

Unlevered Free Cash Flow growth in the last 10 years (CAGR): 1.33%

Future Assumptions

End of Year FCF growth: 4%

Growth until end of 2026: 4%

Growth until end of 2034: 4%

Perpetual growth: 3%

Net Debt: 63.691B

Outstanding Stock Options Present Value Assumption: $0.358B

Assumptions used for the Black & Scholes model:

  • Stock Price: $341
  • Strike Price: $228.23
  • Time to expiration: 5 years
  • Risk Free Rate: 3.92%
  • Volatility: 24.6%

Restricted Stock Units Present Value Assumption: $1.452B

Stock Valuation based on these assumptions: $233

Last update 03/13/2026

All the content in this newsletter should be taken as informational content only. THIS IS NOT FINANCIAL ADVICE! Do your own Due Diligence before investing or contact a professional financial advisor.

I don’t have a position in Home Depot (HD) and I don’t plan to add a position in the coming days.

Hustle Hub Stocks

I'm a author who loves to talk about stocks and I publish stock valuations using the Disconted Cash Flow method. Subscribe to my newsletter for more.

Read more from Hustle Hub Stocks
Lamb Weston Holdings DCF Stock Analysis. Buy or Sell?

Lamb Weston Holdings DCF Stock Analysis. Here’s my assumptions: Risk Free Rate (10 Years Interest Rate Swap): 4.02% Risk Premium (Taken from the Aswath Damodaran equity premium spreadsheet): 4.62% Interest Rate Spread on The Risk free rate ( For the cost of debt calculation): 6% Last 24 Months Beta: 1 Historical Data Revenue growth in the last 10 years (CAGR): 8.24% Earnings growth in the last 10 years (CAGR): 2.27% Unlevered Free Cash Flow growth in the last 10 years (CAGR): -0.33% Future...

KLA Corporation DCF Stock Analysis. Buy or Sell?

KLA Corporation DCF Stock Analysis. Here’s my assumptions: Risk Free Rate (10 Years Interest Rate Swap): 4.02% Risk Premium (Taken from the Aswath Damodaran equity premium spreadsheet): 4.62% Interest Rate Spread on The Risk free rate ( For the cost of debt calculation): 5% Last 24 Months Beta: 1.93 Historical Data Revenue growth in the last 10 years (CAGR): 14.77% Earnings growth in the last 10 years (CAGR): 19.15% Unlevered Free Cash Flow growth in the last 10 years (CAGR): 13.29% Future...

Jabil Inc DCF Stock Analysis. Buy or Sell?

Jabil Inc. DCF Stock Analysis. Here’s my assumptions: Risk Free Rate (10 Years Interest Rate Swap): 4.02% Risk Premium (Taken from the Aswath Damodaran equity premium spreadsheet): 4.62% Interest Rate Spread on The Risk free rate ( For the cost of debt calculation): 5% Last 24 Months Beta: 1.54 Historical Data Revenue growth in the last 10 years (CAGR): 3.81% Earnings growth in the last 10 years (CAGR): 9.97% Unlevered Free Cash Flow growth in the last 10 years (CAGR):14.56% Future...