Dec'20 Actual | Dec'21 Actual | Dec'22 Actual | Dec'23 Actual | Dec'24 Actual | Dec'25 Estimate | Dec'26 Estimate | Dec'27 Estimate | Dec'28 Estimate | Dec'29 Estimate | Dec'30 Estimate | Dec'31 Estimate | Dec'32 Estimate | Dec'33 Estimate | Dec'34 Estimate | Dec'35 Terminal | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
% growth | 1,998.6 (9.3%) | 2,462.0 23.2% | 2,909.0 18.2% | 3,263.6 12.2% | 3,006.1 (7.9%) | 3,290.5 9.5% | 3,473.8 5.6% | 4,463.0 28.5% | 4,907.0 9.9% | 5,339.5 8.8% | 5,749.4 7.7% | 6,125.5 6.5% | 6,456.7 5.4% | 6,732.5 4.3% | 6,943.5 3.1% | 7,082.4 2.0% |
% margin | 247.4 12.4% | 355.4 14.4% | 440.4 15.1% | 587.4 18.0% | 527.1 17.5% | 509.8 15.5% | 538.2 15.5% | 691.5 15.5% | 760.3 15.5% | 827.3 15.5% | 890.8 15.5% | 949.1 15.5% | 1,000.4 15.5% | 1,043.1 15.5% | 1,075.8 15.5% | 1,097.3 15.5% |
NOPAT % effective tax rate | 1,229.2 61.5% | 302.4 12.3% | 372.6 12.8% | 666.9 20.4% | 295.7 9.8% | 286.0 8.7% | 302.0 8.7% | 388.0 8.7% | 426.5 8.7% | 464.1 8.7% | 499.8 8.7% | 532.5 8.7% | 561.3 8.7% | 585.2 8.7% | 603.6 8.7% | 615.6 8.7% |
% of revenue | 102.6 5.1% | 108.4 4.4% | 114.2 3.9% | 141.4 4.3% | 146.0 4.9% | 143.9 4.4% | 151.9 4.4% | 195.1 4.4% | 214.5 4.4% | 233.4 4.4% | 251.3 4.4% | 267.8 4.4% | 282.3 4.4% | 294.3 4.4% | 303.6 4.4% | 309.6 4.4% |
% of revenue | (40.0) (2.0%) | (39.5) (1.6%) | (45.9) (1.6%) | (71.0) (2.2%) | (74.0) (2.5%) | (68.2) (2.1%) | (72.0) (2.1%) | (92.5) (2.1%) | (101.7) (2.1%) | (110.6) (2.1%) | (119.1) (2.1%) | (126.9) (2.1%) | (133.8) (2.1%) | (139.5) (2.1%) | (143.8) (2.1%) | (146.7) (2.1%) |
% of revenue | 46.7 2.3% | (5.0) (0.2%) | (63.9) (2.2%) | (32.6) (1.0%) | 2.4 0.1% | (34.2) (1.0%) | (36.1) (1.0%) | (46.4) (1.0%) | (51.0) (1.0%) | (55.5) (1.0%) | (59.7) (1.0%) | (63.6) (1.0%) | (67.1) (1.0%) | (69.9) (1.0%) | (72.1) (1.0%) | (73.6) (1.0%) |
Free Cash Flow to Firm (FCFF) % of revenue | 1,338.5 67.0% | 366.3 14.9% | 377.0 13.0% | 704.7 21.6% | 370.1 12.3% | 327.5 10.0% | 345.8 10.0% | 444.3 10.0% | 488.4 10.0% | 531.5 10.0% | 572.3 10.0% | 609.7 10.0% | 642.7 10.0% | 670.2 10.0% | 691.2 10.0% | 705.0 10.0% |
% of FCFF used in calculation | ||||||||||||||||
Discount period | ||||||||||||||||
Discount factor | ||||||||||||||||
Discounted FCFF (DFCFF) |
Company name | Market Cap | Enterprise Value | Intrinsic Value | DCF Value | Relative value | Ben Graham Revised fair value | Peter Lynch fair value | Earnings Power Value (EPV),
% of EV | Market-Implied Value of Growth (MIVoG),
% of EV | Reverse DCF (implied FCF growth) | Reverse DCF (implied Revenue growth) |
$9,734.0M | $11.8B | $50.6 10.2% overvalued | N/A | $50.6 10.2% overvalued | $102.1 81.2% undervalued | $62.5 11.0% undervalued | N/A | N/A | 0.0% | 0.0% | |
$33.8B | $32.8B | $30.1 64.7% overvalued | $11.0 87.0% overvalued | $49.3 42.3% overvalued | $145.3 70.2% undervalued | $89.9 5.2% undervalued | 17.5% | 82.5% | 18.8% | 22.1% | |
$19.8B | $21.0B | $270.7 23.7% overvalued | $250.5 29.0% overvalued | $290.9 18.0% overvalued | $382.4 7.9% undervalued | $242.5 31.6% overvalued | 44.4% | 55.6% | 8.4% | 9.5% | |
$8,989.5M | $8,623.5M | $326.0 14.4% undervalued | $215.6 24.0% overvalued | $436.4 53.1% undervalued | $407.5 43.0% undervalued | $267.4 6.2% overvalued | 43.3% | 56.7% | 8.1% | 7.4% | |
$5,669.3M | $6,139.4M | $11.3 51.8% overvalued | N/A | $11.3 51.8% overvalued | $200.9 757.8% undervalued | N/A | (8.0%) | 108.0% | (100.0%) | (100.0%) | |
$4,561.5M | $3,947.4M | $335.1 15.6% undervalued | $164.5 43.0% overvalued | $505.7 74.5% undervalued | Negative 136.1% overvalued | Negative 135.2% overvalued | 82.9% | 17.1% | 4.6% | 1.3% | |
$4,204.4M | $4,064.8M | $93.5 13.0% overvalued | $87.6 18.0% overvalued | $99.4 7.5% overvalued | $310.1 188.7% undervalued | $149.0 38.7% undervalued | 10.4% | 89.6% | 23.4% | 21.2% | |
$3,983.4M | $3,549.8M | $140.1 41.8% undervalued | $55.2 44.0% overvalued | $225.0 127.8% undervalued | $319.2 223.1% undervalued | $179.9 82.1% undervalued | 110.4% | (10.4%) | 7.1% | 1.8% | |
$3,211.1M | $3,989.9M | $12.5 14.9% overvalued | $8.5 42.0% overvalued | $16.4 12.1% undervalued | $34.2 133.7% undervalued | $21.1 44.0% undervalued | 53.9% | 46.1% | 1.9% | 0.4% | |
$2,126.3M | $2,739.7M | $242.1 311.0% undervalued | $167.2 184.0% undervalued | $317.0 438.2% undervalued | Negative 518.0% overvalued | Negative 301.6% overvalued | 127.3% | (27.3%) | (5.6%) | (7.3%) | |
$1,974.9M | $1,602.9M | $208.6 33.6% undervalued | $191.7 23.0% undervalued | $225.5 44.4% undervalued | $127.8 18.1% overvalued | $119.4 23.5% overvalued | 73.2% | 26.8% | 18.9% | 6.8% |