Intrinsic value of Home Depot - HD

Previous Close

$151.42

  Intrinsic Value

premium content

  Rating & Target

premium content

  Value-price divergence*

premium content

Previous close

$151.42

 
Intrinsic value premium content
 
Up/down potential premium content
 
Rating premium content
 
Value-price divergence* premium content

Premium access subscription - $499/yr

please register and log in before paying

*Intrinsic value change (in %) minus stock price change (in %) in the past 12 months.

We calculate the intrinsic value of HD stock by summing up the current values of future distributable cash flows generated by the company and dividing the sum by the number of outstanding shares. As such, the intrinsic value calculation depends entirely on projections. The more accurate your projections of the company's performance are - the more reliable is the intrinsic value calculation result. Please make sure to check the stock valuation input data below and adjust it if necessary. The quality of the output (intrinsic valuation result) is only as good as the quality of the input. See also DISCLAIMERS.

STOCK VALUATION INPUT DATA

Revenue (in 2017), $M
Initial revenue growth rate, %
Terminal revenue growth rate, %
Revenue decline factor
Initial discount rate, %
Discount rate multiplier
Variable cost ratio, %
Fixed operating expenses, $M
Interest rate on debt, %
Effective corporate tax rate, %
Production assets / Revenue, %
Life of production assets, yrs
Working capital / Revenue, %
Revenue / Adjusted assets
Adjusted equity ratio
Cash flow adjustment, % of Revenue
Book value of equity, $M
Shares outstanding, mln
Market capitalization, $bln 184.0

 

FINANCIAL STATEMENTS FORECAST and PRESENT VALUE CALCULATION

Fiscal year
2017(a)
   2018
   2019
   2020
   2021
   2022
   2023
   2024
   2025
   2026
   2027
   2028
   2029
   2030
   2031
   2032
   2033
   2034
   2035
   2036
   2037
   2038
   2039
   2040
   2041
   2042
   2043
   2044
   2045
   2046
   2047

INCOME STATEMENT

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Revenue growth rate, %
  6.86
  5.80
  5.72
  5.65
  5.58
  5.52
  5.47
  5.43
  5.38
  5.34
  5.31
  5.28
  5.25
  5.23
  5.20
  5.18
  5.16
  5.15
  5.13
  5.12
  5.11
  5.10
  5.09
  5.08
  5.07
  5.06
  5.06
  5.05
  5.05
  5.04
  5.04
Revenue, $m
  94,595
  100,082
  105,806
  111,782
  118,023
  124,544
  131,359
  138,486
  145,940
  153,739
  161,903
  170,450
  179,400
  188,775
  198,598
  208,891
  219,680
  230,990
  242,847
  255,281
  268,321
  281,998
  296,345
  311,396
  327,186
  343,755
  361,140
  379,383
  398,529
  418,622
  439,711
Variable operating expenses, $m
 
  72,847
  77,002
  81,339
  85,869
  90,602
  95,548
  100,720
  106,131
  111,791
  117,716
  123,710
  130,206
  137,011
  144,140
  151,611
  159,441
  167,649
  176,256
  185,280
  194,744
  204,671
  215,084
  226,007
  237,468
  249,493
  262,111
  275,352
  289,247
  303,831
  319,137
Fixed operating expenses, $m
 
  12,931
  13,255
  13,586
  13,926
  14,274
  14,631
  14,996
  15,371
  15,756
  16,150
  16,553
  16,967
  17,391
  17,826
  18,272
  18,729
  19,197
  19,677
  20,169
  20,673
  21,190
  21,719
  22,262
  22,819
  23,389
  23,974
  24,573
  25,188
  25,817
  26,463
Total operating expenses, $m
  81,168
  85,778
  90,257
  94,925
  99,795
  104,876
  110,179
  115,716
  121,502
  127,547
  133,866
  140,263
  147,173
  154,402
  161,966
  169,883
  178,170
  186,846
  195,933
  205,449
  215,417
  225,861
  236,803
  248,269
  260,287
  272,882
  286,085
  299,925
  314,435
  329,648
  345,600
Operating income, $m
  13,427
  14,303
  15,549
  16,857
  18,228
  19,668
  21,180
  22,769
  24,438
  26,192
  28,037
  30,186
  32,227
  34,373
  36,632
  39,009
  41,511
  44,144
  46,915
  49,833
  52,904
  56,138
  59,542
  63,126
  66,900
  70,872
  75,055
  79,458
  84,094
  88,974
  94,111
EBITDA, $m
  15,400
  16,260
  17,606
  19,018
  20,499
  22,052
  23,684
  25,396
  27,196
  29,086
  31,074
  33,163
  35,359
  37,670
  40,100
  42,657
  45,347
  48,177
  51,156
  54,291
  57,590
  61,062
  64,717
  68,564
  72,613
  76,875
  81,361
  86,083
  91,053
  96,284
  101,790
Interest expense (income), $m
  924
  782
  821
  898
  979
  1,063
  1,150
  1,242
  1,338
  1,438
  1,543
  1,653
  1,768
  1,889
  2,015
  2,147
  2,286
  2,431
  2,583
  2,743
  2,910
  3,086
  3,270
  3,463
  3,666
  3,878
  4,101
  4,335
  4,581
  4,839
  5,109
Earnings before tax, $m
  12,491
  13,521
  14,728
  15,959
  17,250
  18,606
  20,030
  21,527
  23,100
  24,754
  26,494
  28,533
  30,458
  32,484
  34,617
  36,862
  39,225
  41,712
  44,332
  47,090
  49,994
  53,052
  56,272
  59,663
  63,234
  66,994
  70,954
  75,123
  79,513
  84,135
  89,002
Tax expense, $m
  4,534
  3,651
  3,977
  4,309
  4,657
  5,024
  5,408
  5,812
  6,237
  6,684
  7,153
  7,704
  8,224
  8,771
  9,347
  9,953
  10,591
  11,262
  11,970
  12,714
  13,498
  14,324
  15,194
  16,109
  17,073
  18,088
  19,157
  20,283
  21,468
  22,717
  24,031
Net income, $m
  7,957
  9,870
  10,752
  11,650
  12,592
  13,582
  14,622
  15,714
  16,863
  18,070
  19,340
  20,829
  22,235
  23,714
  25,270
  26,909
  28,634
  30,450
  32,362
  34,376
  36,496
  38,728
  41,079
  43,554
  46,161
  48,906
  51,796
  54,840
  58,044
  61,419
  64,972

BALANCE SHEET

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Cash and short-term investments, $m
  2,538
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
Total assets, $m
  42,966
  42,770
  45,216
  47,770
  50,437
  53,224
  56,136
  59,182
  62,367
  65,701
  69,189
  72,842
  76,667
  80,673
  84,871
  89,270
  93,880
  98,714
  103,781
  109,095
  114,667
  120,512
  126,643
  133,075
  139,823
  146,904
  154,333
  162,130
  170,312
  178,898
  187,911
Adjusted assets (=assets-cash), $m
  40,428
  42,770
  45,216
  47,770
  50,437
  53,224
  56,136
  59,182
  62,367
  65,701
  69,189
  72,842
  76,667
  80,673
  84,871
  89,270
  93,880
  98,714
  103,781
  109,095
  114,667
  120,512
  126,643
  133,075
  139,823
  146,904
  154,333
  162,130
  170,312
  178,898
  187,911
Revenue / Adjusted assets
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
  2.340
Average production assets, $m
  22,053
  11,710
  12,379
  13,079
  13,809
  14,572
  15,369
  16,203
  17,075
  17,988
  18,943
  19,943
  20,990
  22,087
  23,236
  24,440
  25,703
  27,026
  28,413
  29,868
  31,394
  32,994
  34,672
  36,433
  38,281
  40,219
  42,253
  44,388
  46,628
  48,979
  51,446
Working capital, $m
  3,591
  2,402
  2,539
  2,683
  2,833
  2,989
  3,153
  3,324
  3,503
  3,690
  3,886
  4,091
  4,306
  4,531
  4,766
  5,013
  5,272
  5,544
  5,828
  6,127
  6,440
  6,768
  7,112
  7,474
  7,852
  8,250
  8,667
  9,105
  9,565
  10,047
  10,553
Total debt, $m
  23,601
  23,461
  25,663
  27,961
  30,362
  32,869
  35,491
  38,232
  41,099
  44,099
  47,238
  50,526
  53,968
  57,574
  61,352
  65,311
  69,460
  73,810
  78,371
  83,153
  88,169
  93,429
  98,947
  104,736
  110,809
  117,181
  123,868
  130,885
  138,248
  145,977
  154,088
Total liabilities, $m
  38,633
  38,493
  40,695
  42,993
  45,394
  47,901
  50,523
  53,264
  56,131
  59,131
  62,270
  65,558
  69,000
  72,606
  76,384
  80,343
  84,492
  88,842
  93,403
  98,185
  103,201
  108,461
  113,979
  119,768
  125,841
  132,213
  138,900
  145,917
  153,280
  161,009
  169,120
Total equity, $m
  4,333
  4,277
  4,522
  4,777
  5,044
  5,322
  5,614
  5,918
  6,237
  6,570
  6,919
  7,284
  7,667
  8,067
  8,487
  8,927
  9,388
  9,871
  10,378
  10,909
  11,467
  12,051
  12,664
  13,308
  13,982
  14,690
  15,433
  16,213
  17,031
  17,890
  18,791
Total liabilities and equity, $m
  42,966
  42,770
  45,217
  47,770
  50,438
  53,223
  56,137
  59,182
  62,368
  65,701
  69,189
  72,842
  76,667
  80,673
  84,871
  89,270
  93,880
  98,713
  103,781
  109,094
  114,668
  120,512
  126,643
  133,076
  139,823
  146,903
  154,333
  162,130
  170,311
  178,899
  187,911
Debt-to-equity ratio
  5.447
  5.490
  5.680
  5.850
  6.020
  6.180
  6.320
  6.460
  6.590
  6.710
  6.830
  6.940
  7.040
  7.140
  7.230
  7.320
  7.400
  7.480
  7.550
  7.620
  7.690
  7.750
  7.810
  7.870
  7.920
  7.980
  8.030
  8.070
  8.120
  8.160
  8.200
Adjusted equity ratio
  0.062
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100
  0.100

CASH FLOW

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Net income, $m
  7,957
  9,870
  10,752
  11,650
  12,592
  13,582
  14,622
  15,714
  16,863
  18,070
  19,340
  20,829
  22,235
  23,714
  25,270
  26,909
  28,634
  30,450
  32,362
  34,376
  36,496
  38,728
  41,079
  43,554
  46,161
  48,906
  51,796
  54,840
  58,044
  61,419
  64,972
Depreciation, amort., depletion, $m
  1,973
  1,957
  2,057
  2,161
  2,270
  2,384
  2,503
  2,628
  2,758
  2,894
  3,037
  2,977
  3,133
  3,297
  3,468
  3,648
  3,836
  4,034
  4,241
  4,458
  4,686
  4,924
  5,175
  5,438
  5,714
  6,003
  6,306
  6,625
  6,959
  7,310
  7,679
Funds from operations, $m
  9,486
  11,827
  12,809
  13,811
  14,863
  15,966
  17,125
  18,342
  19,621
  20,964
  22,377
  23,805
  25,367
  27,010
  28,738
  30,557
  32,470
  34,484
  36,603
  38,833
  41,181
  43,652
  46,254
  48,992
  51,874
  54,909
  58,103
  61,465
  65,004
  68,729
  72,650
Change in working capital, $m
  -297
  132
  137
  143
  150
  156
  164
  171
  179
  187
  196
  205
  215
  225
  236
  247
  259
  271
  285
  298
  313
  328
  344
  361
  379
  398
  417
  438
  459
  482
  506
Cash from operations, $m
  9,783
  600
  12,671
  13,668
  14,713
  15,810
  16,961
  18,171
  19,442
  20,777
  22,181
  23,600
  25,153
  26,785
  28,503
  30,310
  32,211
  34,212
  36,318
  38,535
  40,868
  43,324
  45,909
  48,631
  51,495
  54,511
  57,685
  61,027
  64,544
  68,247
  72,144
Maintenance CAPEX, $m
  0
  -1,656
  -1,748
  -1,848
  -1,952
  -2,061
  -2,175
  -2,294
  -2,418
  -2,549
  -2,685
  -2,827
  -2,977
  -3,133
  -3,297
  -3,468
  -3,648
  -3,836
  -4,034
  -4,241
  -4,458
  -4,686
  -4,924
  -5,175
  -5,438
  -5,714
  -6,003
  -6,306
  -6,625
  -6,959
  -7,310
New CAPEX, $m
  -1,621
  -614
  -670
  -699
  -730
  -763
  -797
  -834
  -872
  -913
  -955
  -1,000
  -1,047
  -1,097
  -1,149
  -1,204
  -1,262
  -1,323
  -1,387
  -1,455
  -1,526
  -1,600
  -1,679
  -1,761
  -1,847
  -1,938
  -2,034
  -2,135
  -2,240
  -2,351
  -2,467
Cash from investing activities, $m
  -1,583
  -2,270
  -2,418
  -2,547
  -2,682
  -2,824
  -2,972
  -3,128
  -3,290
  -3,462
  -3,640
  -3,827
  -4,024
  -4,230
  -4,446
  -4,672
  -4,910
  -5,159
  -5,421
  -5,696
  -5,984
  -6,286
  -6,603
  -6,936
  -7,285
  -7,652
  -8,037
  -8,441
  -8,865
  -9,310
  -9,777
Free cash flow, $m
  8,200
  -1,670
  10,254
  11,121
  12,031
  12,986
  13,989
  15,043
  16,151
  17,316
  18,541
  19,773
  21,129
  22,555
  24,057
  25,637
  27,301
  29,053
  30,897
  32,840
  34,885
  37,038
  39,306
  41,695
  44,210
  46,859
  49,648
  52,586
  55,679
  58,937
  62,366
Issuance/(repayment) of debt, $m
  2,274
  1,112
  2,202
  2,298
  2,400
  2,508
  2,621
  2,741
  2,867
  3,000
  3,140
  3,287
  3,442
  3,606
  3,778
  3,959
  4,149
  4,350
  4,561
  4,782
  5,015
  5,260
  5,518
  5,789
  6,073
  6,372
  6,687
  7,017
  7,364
  7,728
  8,111
Issuance/(repurchase) of shares, $m
  -6,662
  502
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
Cash from financing (excl. dividends), $m  
  -4,466
  1,614
  2,202
  2,298
  2,400
  2,508
  2,621
  2,741
  2,867
  3,000
  3,140
  3,287
  3,442
  3,606
  3,778
  3,959
  4,149
  4,350
  4,561
  4,782
  5,015
  5,260
  5,518
  5,789
  6,073
  6,372
  6,687
  7,017
  7,364
  7,728
  8,111
Total cash flow (excl. dividends), $m
  3,726
  -558
  12,456
  13,419
  14,431
  15,494
  16,611
  17,784
  19,018
  20,316
  21,681
  23,060
  24,571
  26,161
  27,835
  29,596
  31,451
  33,403
  35,458
  37,622
  39,900
  42,299
  44,824
  47,484
  50,283
  53,231
  56,335
  59,603
  63,043
  66,665
  70,477
Retained Cash Flow (-), $m
  1,983
  -1,230
  -245
  -255
  -267
  -279
  -291
  -305
  -319
  -333
  -349
  -365
  -382
  -401
  -420
  -440
  -461
  -483
  -507
  -531
  -557
  -584
  -613
  -643
  -675
  -708
  -743
  -780
  -818
  -859
  -901
Prev. year cash balance distribution, $m
 
  1,286
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
Cash flow adjustment, $m
 
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
  0
Cash available for distribution, $m
 
  0
  12,211
  13,164
  14,164
  15,215
  16,319
  17,480
  18,700
  19,983
  21,332
  22,695
  24,189
  25,761
  27,415
  29,156
  30,990
  32,919
  34,951
  37,090
  39,343
  41,714
  44,211
  46,840
  49,609
  52,523
  55,592
  58,823
  62,225
  65,806
  69,576
Discount rate, %
 
  7.70
  8.09
  8.49
  8.91
  9.36
  9.83
  10.32
  10.83
  11.38
  11.95
  12.54
  13.17
  13.83
  14.52
  15.25
  16.01
  16.81
  17.65
  18.53
  19.46
  20.43
  21.45
  22.52
  23.65
  24.83
  26.07
  27.38
  28.75
  30.18
  31.69
PV of cash for distribution, $m
 
  0
  10,452
  10,309
  10,066
  9,727
  9,299
  8,790
  8,212
  7,577
  6,902
  6,187
  5,481
  4,783
  4,108
  3,470
  2,880
  2,346
  1,875
  1,467
  1,124
  841
  615
  438
  304
  205
  134
  85
  53
  31
  18
Current shareholders' claim on cash, %
  100
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4
  98.4

The Home Depot, Inc. operates as a home improvement retailer. It operates The Home Depot stores that sell various building materials, home improvement products, and lawn and garden products, as well as provide installation, home maintenance, and professional service programs to do-it-yourself, do-it-for-me (DIFM), and professional customers. The company offers installation programs that include flooring, cabinets, countertops, water heaters, and sheds; and professional installation in various categories sold through its in-home sales programs, such as roofing, siding, windows, cabinet refacing, furnaces, and central air systems, as well as acts as a contractor to provide installation services to its DIFM customers through third-party installers. It primarily serves home owners; and renovators/remodelers, general contractors, repairmen, installers, small business owners, and tradesmen. The company also sells its products through online. As of December 31, 2015, it had 2,274 stores, including 1,977 in the United States, 182 in Canada, and 115 in Mexico. The Home Depot, Inc. was founded in 1978 and is based in Atlanta, Georgia.

FINANCIAL RATIOS  of  Home Depot (HD)

Valuation Ratios
P/E Ratio 22.9
Price to Sales 1.9
Price to Book 42
Price to Tangible Book
Price to Cash Flow 18.6
Price to Free Cash Flow 22.3
Growth Rates
Sales Growth Rate 6.9%
Sales - 3 Yr. Growth Rate %
EPS Growth Rate %
EPS - 3 Yr. Growth Rate %
Capital Spending Gr. Rate 7.9%
Cap. Spend. - 3 Yr. Gr. Rate 3.1%
Financial Strength
Quick Ratio 2
Current Ratio 0
LT Debt to Equity 515.8%
Total Debt to Equity 544.7%
Interest Coverage 15
Management Effectiveness
Return On Assets 20.1%
Ret/ On Assets - 3 Yr. Avg. 18.5%
Return On Total Capital 28.7%
Ret/ On T. Cap. - 3 Yr. Avg. 26.1%
Return On Equity 149.4%
Return On Equity - 3 Yr. Avg. 99.1%
Asset Turnover 2.2
Profitability Ratios
Gross Margin 34.2%
Gross Margin - 3 Yr. Avg. 34.2%
EBITDA Margin 16.3%
EBITDA Margin - 3 Yr. Avg. 15.6%
Operating Margin 14.2%
Oper. Margin - 3 Yr. Avg. 13.4%
Pre-Tax Margin 13.2%
Pre-Tax Margin - 3 Yr. Avg. 12.5%
Net Profit Margin 8.4%
Net Profit Margin - 3 Yr. Avg. 8%
Effective Tax Rate 36.3%
Eff/ Tax Rate - 3 Yr. Avg. 36.4%
Payout Ratio 42.8%

HD stock valuation input parameters

Revenue. Company's revenue (or sales) is always the starting point of any cash flow forecast. In the HD stock intrinsic value calculation we used $94595 million for the last fiscal year's total revenue generated by Home Depot. The default revenue input number comes from 2017 income statement of Home Depot. You may change it if you feel that it should be adjusted for some unusual circumstances that are not expected to be repeated in the future or if you already know (from interim financial statements, for example) that this year's revenue is going to be quite different.

Revenue growth rate. Forecasted future revenue growth rate is the most important input parameter for the intrinsic value calculation. Unlike other input parameters that are reasonably expected to be in line with their historic averages or their historic trends, the revenue growth rate by and large is a wild card: nobody really knows what the company's revenue will be in the future. Of course, the level of unpredictability is different for different industries (utility companies being the most predictable and, thus, less risky).
    We use three input parameters to forecast the revenue growth rate in our HD stock valuation model: a) initial revenue growth rate of 5.8% whose default value is the revenue growth rate in the most recent quarter compared to the quarterly revenue a year ago; b) terminal revenue growth rate of 5% whose default value is chosen to be close to the average nominal (i.e. not adjusted for inflation) GDP growth rate; and c) revenue decline factor of 0.9, which stipulates that revenue growth rate in each forecasted year will be equal to the difference of the revenue growth rate in the preceding year and the terminal revenue growth rate multiplied by this revenue decline factor (with the passage of time the revenue growth rate will be approaching the terminal revenue growth rate, but not quite reaching it - though the difference could be infinitesimally small).
    At the revenue decline factor of 1, the future revenue growth rate is forecasted to be constant and equal to the initial revenue growth rate. The smaller the revenue decline factor, the faster the revenue growth rate will approach the terminal revenue growth.

Discount rate. The discount rate is used for determining the present value of future cash flows: future cash flows are "discounted" as at normal conditions (that translate into positive expected return on investment) one dollar today is worth more than the same dollar in the future. Unlike all other valuation models, we use variable discount rate, i.e. it increases for each consecutive year. This is done to account for higher risk of cash flows coming in further in the future.
    The initial discount rate of 7.7%, whose default value for HD is calculated based on our internal credit rating of Home Depot, is applied to the cash flow expected to be received a year from now (well, actually, to be precise, in the financial year following the base year - the last year for which we have financial statements). For each consecutive year the discount rate is multiplied by the discount rate multiplier of 1.05, e.i. each year it increases by 5%. Feel free to change this number to correspond to your level of risk assessment of Home Depot.
    By the way, it is easy to set the discount rate to be constant (this would make comparison with other valuation models easier): just set the discount rate multiplier equal to 1 and chose the magnitude of the initial discount rate to your liking.

Variable cost ratio is the ratio of variable costs (i.e. costs that fluctuate with fluctuation of the volume of production) to the revenue expressed as a percentage. In the calculation of intrinsic value of HD stock the variable cost ratio is equal to 72.8%.

Fixed operating expenses is just that - expenses that are not dependant on the volume of production. They are set to $12616 million in the base year in the intrinsic value calculation for HD stock. These expenses increase with the level of inflation in subsequent years.

Interest rate on debt is the average all-in rate of interest paid by the company on its debt. It is set at 3.5% for Home Depot.

Corporate tax rate of 27% is the nominal tax rate for Home Depot. In reality, companies find ways to pay much less taxes than that or not to pay them at all.

Cash flow adjustment could be used for any adjustment the investor deems necessary. Most commonly we use this field to account for stock options-related effects in excess of what is reported on the company's income statement. The cash flow adjustment is expressed as a percentage of the revenue, and in the current valuation of the HD stock is equal to 0%.

Production assets are the company's assets used for manufacturing products or provision of services. In the valuation model input table they are expressed as a percentage of revenue and for HD are equal to 11.7%.

Life of production assets of 6.7 years is the average useful life of capital assets used in Home Depot operations. It is used to calculate yearly capital expenditures needed to keep these assets in good order - we call it the maintenance CAPEX.

Working capital is the difference between the company's current assets and liabilities. In the model we use the ratio of working capital to revenue, which for HD is equal to 2.4%. A negative number means that the company is apt at using financial resources of its suppliers and customers; a large positive number, on the other hand, means that it either provides in-kind financing to others or is not good at managing its inventories.

Book value of equity - $4333 million for Home Depot - is used in calculation of the "floor" for intrinsic valuation based on the discounted cash flow (DCF) method. Even if the prospects are very bad for a company, its assets could always be sold now for their current fair market value.

Shares outstanding of 1214.89 million for Home Depot is needed to calculate the intrinsic value of one share.

Market capitalization is used here only for reference purposes and as a quick check that the share price and the number of shares outstanding numbers are correct - something especially to be cognizant about at stock splits. So, the market capitalization of Home Depot at the current share price and the inputted number of shares is $184.0 billion.


Premium access subscription - $499/yr

please register and log in before paying
RELATED COMPANIES Price Int.Val. Rating
LOW Lowe's 76.70 prem.  prem.
SHOS Sears Hometown 2.80 prem.  prem.

COMPANY NEWS

▶ Bears shopping at this home retailer   [Jun-26-17 01:39PM  CNBC Videos]
▶ Home Depot hits 3-month low   [05:04PM  CNBC Videos]
▶ Stocks Up; The Best Growth Play For The Rest Of The Year?   [03:05PM  Investor's Business Daily]
▶ Lawsuits complain that 2x4s, other boards don't measure up   [Jun-22-17 05:29PM  Associated Press]
▶ A Close Look at Lowe's Dividend Potential   [08:09AM  Motley Fool]
▶ Cramer: Someone Has Created a Monster ETF   [Jun-21-17 07:01PM  TheStreet.com]
▶ A Brief History of Retail   [03:26PM  MarketWatch]
▶ US Market Indexes Gain on Monday   [Jun-19-17 05:36PM  GuruFocus.com]
▶ 10 Best Part-Time Jobs for Retirees   [12:41PM  TheStreet.com]
▶ 3 Dividend Stocks for Go-Getter Investors   [Jun-17-17 08:21AM  Motley Fool]
▶ 2017 IPO Expecting 260% Q2 Earnings Growth Near Breakout   [Jun-15-17 04:06PM  Investor's Business Daily]
▶ Which Stocks Are Showing Rising Relative Strength?   [12:01PM  Investor's Business Daily]
▶ Dow Jones Industrial Average And Dow Stocks: News And Analysis   [Jun-14-17 11:04PM  Investor's Business Daily]
▶ Dow Jones Gains on Wednesday   [06:11PM  GuruFocus.com]
▶ Why Yellen was right on 'Trump effect'   [06:00PM  CNBC Videos]
▶ These Economic Data Signal Warning As Fed Charges Ahead   [04:18PM  Investor's Business Daily]
▶ Watch These 10 Stocks This Hurricane Season   [Jun-12-17 09:24AM  TheStreet.com]
▶ These Are 5 Dow Stocks To Watch This Week As Apple Toes The Line   [Jun-11-17 08:00AM  Investor's Business Daily]
▶ [$$] Preferred Stock for the Long Run   [Jun-10-17 12:14AM  Barrons.com]
▶ Retail waving white flag? 9 trades   [Jun-08-17 05:00PM  CNBC Videos]
▶ [$$] Sohn Hong Kong Recap: 8 Smart Money Trades   [Jun-07-17 11:46PM  Barrons.com]
▶ Its tough to be a retailer but this store and its stock are up   [07:08PM  American City Business Journals]
▶ Best Buy's Not GameStop. It's Wal-Mart.   [02:25PM  Barrons.com]
▶ The stocks really bolstering this rally   [Jun-01-17 06:13PM  CNBC Videos]
▶ Indexes Chalk Off Weekly Closing Highs; Young IPO Scores Breakout   [May-26-17 04:26PM  Investor's Business Daily]
▶ Home Depot Is Stuck in the Doorway   [May-25-17 02:04PM  TheStreet.com]
▶ Sears Skyrockets After Q1 Loss, Sales Not As Bad As Feared   [10:06AM  Investor's Business Daily]
▶ 3 Dividend Stocks for Ambitious Investors   [09:12AM  Motley Fool]
▶ Home Depot Is Raising the Roof Again   [08:50AM  Motley Fool]
▶ Takeaways from Lowe's first-quarter earnings call   [12:00AM  American City Business Journals]
▶ Asian shares gain, tracking Wall St advance, oil price rally   [May-24-17 11:07PM  Associated Press]
Stock chart of HD Financial statements of HD Annual reports of HD
Valuation of Stocks

The paper VALUATION OF STOCKS: The Quest for Intrinsic Value provides a detailed description of our valuation model and discloses the calculation algorithm.

FREE DOWNLOAD
Follow us on:   twitter   twitter   twitter   twitter

VALUATION THEORY       ASSET ALLOCATION

About X-FIN       Site news       Privacy policy       Terms of use       FAQ

Copyright © X-FIN.com 2005-2017. All rigths reserved.