image
The Home Depot, Inc. HD
Consumer Cyclical - Home Improvement - NYSE - US
Watchlist
$ 408.18
0.606 %
$ 405 B
Market Cap
27.41
P/E
FREE CASH FLOW TO FIRM (OWNERS EARNINGS)
DCF Model Base Case Scenario
Cash Flow For Owners Growth Estimate the growth of (owners) cash flows per year for the next 10 years.
%
Maintenance CAPEX Estimate the percentage of CAPEX that is needed for maintenance.
%
Required Rate Of Return The required rate of return is a personal target return, before considering a margin of safety.
%
Terminal Growth Rate Terminal Value reflects the expected growth of cash flows after the 10th year and into perpetuity.
%

Owners Calculation

Millions
Current Year Forecasted Year 1 Forecasted Year 2 Forecasted Year 3 Forecasted Year 4 Forecasted Year 5 Forecasted Year 6 Forecasted Year 7 Forecasted Year 8 Forecasted Year 9 Terminal
Operating Cash Flow 21 172.0
CAPEX (3 226.0)
Maintenance CAPEX (2 258.2)
Cash Flow For Owners 18 913.8 19 862.1 20 857.9 21 903.7 23 001.9 24 155.2 25 366.3 26 638.1 27 973.6 29 376.2 578 685.4
Cash and Cash Equivalents The current cash and cash equivalents of the company.
M
Total Debt The current total debt of the company.
M
Fair Value The calculated fair value of the company.
$
Valuation The valuation against current price.
%