| Current Price | $14.88 |
| 5Y Range | 50.70 – 105.63 |
| 5Y Selected | 78.17 |
| (-) Safety Margin | 85.60% |
| 5Y Buy Price | $14.04 |
| Upside (to Buy Price) | -5.65% |
| 10Y Range | 50.86 – 101.24 |
| 10Y Selected | 76.05 |
| (-) Safety Margin | 85.60% |
| 10Y Buy Price | $13.66 |
| Upside (to Buy Price) | -8.21% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.0078 |
| Revenue R2 (10Y) | 0.3967 |
| Net Income R2 (5Y) | 0.0406 |
| Net Income R2 (10Y) | 0.0000 |
| EBITDA R2 (5Y) | 0.1408 |
| EBITDA R2 (10Y) | 0.0308 |
| FCF R2 (5Y) | 0.0008 |
| FCF R2 (10Y) | 0.1194 |
| Safety Score | 0.1796 |
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | -0.55% | -0.04% | 0.46% | 0.97% | 1.47% | 1.98% | 2.48% | 2.99% | 3.49% | 4.00% |
| Revenue | 28,759.91 | 28,748.25 | 28,881.79 | 29,161.82 | 29,591.86 | 30,177.70 | 30,927.55 | 31,852.24 | 32,965.45 | 34,284.07 |
| EBITDA | 8,315.26 | 8,311.89 | 8,350.50 | 8,431.46 | 8,555.80 | 8,725.18 | 8,941.98 | 9,209.33 | 9,531.19 | 9,912.44 |
| D&A | -1,583.35 | -1,582.70 | -1,590.06 | -1,605.47 | -1,629.15 | -1,661.40 | -1,702.68 | -1,753.59 | -1,814.88 | -1,887.47 |
| EBIT | 6,731.91 | 6,729.18 | 6,760.44 | 6,825.99 | 6,926.65 | 7,063.78 | 7,239.30 | 7,455.74 | 7,716.31 | 8,024.97 |
| Pro forma Taxes | -2,986.87 | -2,985.66 | -2,999.53 | -3,028.61 | -3,073.27 | -3,134.11 | -3,211.99 | -3,308.02 | -3,423.64 | -3,560.58 |
| NOPAT | 3,745.04 | 3,743.52 | 3,760.91 | 3,797.38 | 3,853.38 | 3,929.66 | 4,027.31 | 4,147.72 | 4,292.68 | 4,464.38 |
| Capital Expenditures | -2,001.63 | -2,000.82 | -2,010.12 | -2,029.61 | -2,059.54 | -2,100.31 | -2,152.50 | -2,216.85 | -2,294.33 | -2,386.10 |
| NWC Investment | 46.62 | 3.45 | -39.45 | -82.74 | -127.06 | -173.09 | -221.55 | -273.20 | -328.90 | -389.59 |
| (+) D&A | 1,583.35 | 1,582.70 | 1,590.06 | 1,605.47 | 1,629.15 | 1,661.40 | 1,702.68 | 1,753.59 | 1,814.88 | 1,887.47 |
| Free Cash Flow | 3,373.37 | 3,328.85 | 3,301.40 | 3,290.51 | 3,295.93 | 3,317.66 | 3,355.94 | 3,411.25 | 3,484.32 | 3,576.16 |
| Diluted Shares Outstanding | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 | 1,087,211,600.00 |
| Metric | Dec-25 | Dec-26 | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 | Dec-33 | Dec-34 |
|---|---|---|---|---|---|---|---|---|---|---|
| Period Start | 6/30/25 | 1/1/26 | 1/1/27 | 1/1/28 | 1/1/29 | 1/1/30 | 1/1/31 | 1/1/32 | 1/1/33 | 1/1/34 |
| Period End | 12/31/25 | 12/31/26 | 12/31/27 | 12/31/28 | 12/31/29 | 12/31/30 | 12/31/31 | 12/31/32 | 12/31/33 | 12/31/34 |
| Mid-Point | 9/30/25 | 7/2/26 | 7/2/27 | 7/1/28 | 7/2/29 | 7/2/30 | 7/2/31 | 7/1/32 | 7/2/33 | 7/2/34 |
| Time (t) | 0.10 | 0.46 | 1.46 | 2.46 | 3.46 | 4.46 | 5.46 | 6.46 | 7.46 | 8.46 |
| Valuation Date | 1/16/26 | |||||||||
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.97 | 0.91 | 0.86 | 0.81 | 0.76 | 0.71 | 0.67 | 0.63 | 0.59 | ||
| PV UFCF | 3,352.69 | 3,236.00 | 3,017.89 | 2,828.53 | 2,664.21 | 2,521.82 | 2,398.77 | 2,292.87 | 2,202.29 | 2,125.53 | Raw: 81,274.64 63,707.56 |
Raw: 88,184.78 50,826.37 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 78,806.88 | 77,466.97 |
| (-) Net Debt | 4,624.25 | 4,624.25 |
| Equity Value | 74,182.63 | 72,842.72 |
| (/) Shares Out | 1,087.21 | 1,087.21 |
| Fair Value | $68.23 | $67.00 |
| (-) Safety Margin | 85.60% | 85.60% |
| Buy Price | $9.83 | $9.65 |
| Current Price | $14.88 | $14.88 |
| Upside (to Buy Price) | -33.97% | -35.16% |
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.97 | 0.90 | 0.84 | 0.78 | 0.73 | 0.68 | 0.63 | 0.59 | 0.55 | ||
| PV UFCF | 3,349.55 | 3,222.10 | 2,976.93 | 2,764.15 | 2,579.31 | 2,418.72 | 2,279.26 | 2,158.34 | 2,053.77 | 1,963.71 | Raw: 59,384.12 44,854.87 |
Raw: 64,433.09 34,149.44 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 59,746.91 | 59,915.29 |
| (-) Net Debt | 4,624.25 | 4,624.25 |
| Equity Value | 55,122.66 | 55,291.04 |
| (/) Shares Out | 1,087.21 | 1,087.21 |
| Fair Value | $50.70 | $50.86 |
| (-) Safety Margin | 85.60% | 85.60% |
| Buy Price | $7.30 | $7.32 |
| Current Price | $14.88 | $14.88 |
| Upside (to Buy Price) | -50.93% | -50.78% |
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.98 | 0.93 | 0.88 | 0.84 | 0.79 | 0.75 | 0.71 | 0.68 | 0.64 | ||
| PV UFCF | 3,355.86 | 3,250.10 | 3,059.81 | 2,895.04 | 2,752.74 | 2,630.36 | 2,525.76 | 2,437.17 | 2,363.12 | 2,302.39 | Raw: 127,998.86 104,157.57 |
Raw: 138,881.60 87,117.45 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 119,471.12 | 114,689.80 |
| (-) Net Debt | 4,624.25 | 4,624.25 |
| Equity Value | 114,846.87 | 110,065.55 |
| (/) Shares Out | 1,087.21 | 1,087.21 |
| Fair Value | $105.63 | $101.24 |
| (-) Safety Margin | 85.60% | 85.60% |
| Buy Price | $15.21 | $14.58 |
| Current Price | $14.88 | $14.88 |
| Upside (to Buy Price) | 2.23% | -2.03% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 100,812.46 | 174,323.60 | 301,438.11 | 521,242.86 | 901,326.38 | 1,558,561.87 | 2,695,044.93 | 4,660,236.70 | 8,058,420.77 | 13,934,516.53 |
| Constant Implied Growth | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% | 72.92% |
| Implied Free Cash Flow | 10.08 | 17.43 | 30.14 | 52.12 | 90.13 | 155.86 | 269.50 | 466.02 | 805.84 | 1,393.45 |
| Discount Factor | 0.96 | 0.86 | 0.81 | 0.76 | 0.71 | 0.67 | 0.63 | 0.59 | 0.56 | 0.53 |
| Present Value of Implied FCF | 9.66 | 14.98 | 24.37 | 39.62 | 64.43 | 104.76 | 170.34 | 276.99 | 450.39 | 732.36 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2019 | 2019-12-31 | $15.00 | -0.43% | $-2.68 | -117.84% |
| 2018 | 2018-12-31 | $15.84 | 1.66% | $-29.55 | -286.55% |
| 2017 | 2017-12-31 | $22.60 | 2.41% | $7.97 | -64.75% |
| 2016 | 2016-12-31 | $21.00 | 4.30% | $139.93 | 566.32% |
| 2015 | 2015-12-31 | $20.35 | 4.97% | $-17.76 | -187.28% |
| 2014 | 2014-12-31 | $23.25 | 13.88% | $-134.37 | -677.93% |
| 2013 | 2013-12-31 | $28.35 | 12.92% | $124.03 | 337.50% |
| 2012 | 2012-12-31 | $27.25 | 8.27% | $52.00 | 90.84% |
| 2011 | 2011-12-31 | $21.55 | 1.80% | $-33.05 | -253.34% |
| 2010 | 2010-12-31 | $33.50 | 4.81% | $39.24 | 17.13% |
| 2009 | 2009-12-31 | $39.65 | 11.95% | $3.03 | -92.35% |
| 2008 | 2008-12-31 | $17.70 | 25.83% | $108.41 | 512.50% |
| 2007 | 2007-12-31 | $34.00 | 15.92% | $-19.31 | -156.81% |
| 2006 | 2006-12-31 | $16.78 | 11.31% | $8.00 | -52.30% |
| 2005 | 2005-12-31 | $16.15 | 8.15% | $10.85 | -32.82% |
| 2004 | 2004-12-31 | $16.60 | 5.59% | $11.66 | -29.74% |
| 2003 | 2003-12-31 | $17.75 | 26.02% | $38.00 | 114.06% |
| 2002 | 2002-12-31 | $10.75 | 25.93% | $44.85 | 317.19% |
| 2001 | 2001-12-31 | $14.10 | 20.54% | $40.24 | 185.38% |
| 2000 | 2000-12-31 | $14.05 | 11.15% | $31.35 | 123.16% |
| 1999 | 1999-12-31 | $16.02 | 0.01% | $18.96 | 18.32% |
| 1998 | 1998-12-31 | $16.02 | -3.26% | $-3.03 | -118.92% |
| 1997 | 1997-12-31 | $16.02 | -3.28% | $-3.25 | -120.29% |
| $38.07 - $47.29 | 51 |
| $47.29 - $56.50 | 183 |
| $56.50 - $65.71 | 242 |
| $65.71 - $74.92 | 198 |
| $74.92 - $84.13 | 127 |
| $84.13 - $93.35 | 78 |
| $93.35 - $102.56 | 38 |
| $102.56 - $111.77 | 24 |
| $111.77 - $120.98 | 20 |
| $120.98 - $130.19 | 13 |
| $130.19 - $139.41 | 6 |
| $139.41 - $148.62 | 5 |
| $148.62 - $157.83 | 7 |
| $157.83 - $167.04 | 0 |
| $167.04 - $176.25 | 4 |
| $176.25 - $185.47 | 0 |
| $185.47 - $194.68 | 2 |
| $194.68 - $203.89 | 1 |
| $203.89 - $213.10 | 0 |
| $213.10 - $222.31 | 1 |