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 DataRevenue 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 AssumptionsEnd 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:
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. |
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.
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. 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. 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...