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.