| Current Price | $26.62 |
| 5Y Range | 35.77 – 72.52 |
| 5Y Selected | 54.15 |
| (-) Safety Margin | 85.76% |
| 5Y Buy Price | $9.63 |
| Upside (to Buy Price) | -63.81% |
| 10Y Range | 34.61 – 66.65 |
| 10Y Selected | 50.63 |
| (-) Safety Margin | 85.76% |
| 10Y Buy Price | $9.01 |
| Upside (to Buy Price) | -66.16% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.1775 |
| Revenue R2 (10Y) | 0.2554 |
| Net Income R2 (5Y) | 0.4065 |
| Net Income R2 (10Y) | 0.0098 |
| EBITDA R2 (5Y) | 0.3728 |
| EBITDA R2 (10Y) | 0.0538 |
| FCF R2 (5Y) | 0.8889 |
| FCF R2 (10Y) | 0.0019 |
| Safety Score | 0.1779 |
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | -0.75% | -0.22% | 0.31% | 0.83% | 1.36% | 1.89% | 2.42% | 2.94% | 3.47% | 4.00% |
| Revenue | 42,770.88 | 42,676.56 | 42,807.59 | 43,164.86 | 43,752.84 | 44,579.66 | 45,657.28 | 47,001.83 | 48,633.94 | 50,579.30 |
| EBITDA | 6,263.47 | 6,249.65 | 6,268.84 | 6,321.16 | 6,407.27 | 6,528.35 | 6,686.16 | 6,883.06 | 7,122.07 | 7,406.95 |
| D&A | -1,917.26 | -1,913.04 | -1,918.91 | -1,934.93 | -1,961.28 | -1,998.35 | -2,046.65 | -2,106.92 | -2,180.08 | -2,267.29 |
| EBIT | 4,346.20 | 4,336.62 | 4,349.93 | 4,386.24 | 4,445.98 | 4,530.00 | 4,639.51 | 4,776.13 | 4,941.98 | 5,139.66 |
| Pro forma Taxes | -979.47 | -977.31 | -980.31 | -988.49 | -1,001.96 | -1,020.89 | -1,045.57 | -1,076.36 | -1,113.74 | -1,158.29 |
| NOPAT | 3,366.73 | 3,359.30 | 3,369.62 | 3,397.74 | 3,444.03 | 3,509.11 | 3,593.93 | 3,699.77 | 3,828.24 | 3,981.37 |
| Capital Expenditures | -2,866.68 | -2,860.35 | -2,869.14 | -2,893.08 | -2,932.49 | -2,987.91 | -3,060.13 | -3,150.25 | -3,259.64 | -3,390.03 |
| NWC Investment | 76.27 | 22.32 | -31.00 | -84.53 | -139.11 | -195.61 | -254.95 | -318.10 | -386.14 | -460.25 |
| (+) D&A | 1,917.26 | 1,913.04 | 1,918.91 | 1,934.93 | 1,961.28 | 1,998.35 | 2,046.65 | 2,106.92 | 2,180.08 | 2,267.29 |
| Free Cash Flow | 2,493.59 | 2,434.30 | 2,388.39 | 2,355.06 | 2,333.71 | 2,323.93 | 2,325.50 | 2,338.34 | 2,362.55 | 2,398.39 |
| Diluted Shares Outstanding | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.00 | 1,108,311,802.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 | 2,478.30 | 2,366.40 | 2,183.29 | 2,024.42 | 1,886.41 | 1,766.47 | 1,662.23 | 1,571.71 | 1,493.27 | 1,425.50 | Raw: 56,543.43 44,321.87 |
Raw: 58,110.49 33,492.69 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 55,260.69 | 52,350.69 |
| (-) Net Debt | 2,494.12 | 2,494.12 |
| Equity Value | 52,766.57 | 49,856.57 |
| (/) Shares Out | 1,108.31 | 1,108.31 |
| Fair Value | $47.61 | $44.98 |
| (-) Safety Margin | 85.76% | 85.76% |
| Buy Price | $6.78 | $6.41 |
| Current Price | $26.62 | $26.62 |
| Upside (to Buy Price) | -74.53% | -75.94% |
| 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 | 2,475.98 | 2,356.24 | 2,153.66 | 1,978.34 | 1,826.30 | 1,694.25 | 1,579.41 | 1,479.50 | 1,392.56 | 1,316.98 | Raw: 41,498.72 31,345.41 |
Raw: 42,648.83 22,603.82 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 42,135.93 | 40,857.04 |
| (-) Net Debt | 2,494.12 | 2,494.12 |
| Equity Value | 39,641.81 | 38,362.92 |
| (/) Shares Out | 1,108.31 | 1,108.31 |
| Fair Value | $35.77 | $34.61 |
| (-) Safety Margin | 85.76% | 85.76% |
| Buy Price | $5.09 | $4.93 |
| Current Price | $26.62 | $26.62 |
| Upside (to Buy Price) | -80.87% | -81.48% |
| 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 | 2,480.64 | 2,376.71 | 2,213.62 | 2,072.02 | 1,949.10 | 1,842.49 | 1,750.22 | 1,670.63 | 1,602.32 | 1,544.12 | Raw: 88,211.49 71,781.07 |
Raw: 90,656.21 56,866.70 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 82,873.16 | 76,368.57 |
| (-) Net Debt | 2,494.12 | 2,494.12 |
| Equity Value | 80,379.03 | 73,874.45 |
| (/) Shares Out | 1,108.31 | 1,108.31 |
| Fair Value | $72.52 | $66.65 |
| (-) Safety Margin | 85.76% | 85.76% |
| Buy Price | $10.33 | $9.49 |
| Current Price | $26.62 | $26.62 |
| Upside (to Buy Price) | -61.20% | -64.34% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 148,840.26 | 258,517.28 | 449,012.83 | 779,880.26 | 1,354,556.44 | 2,352,698.52 | 4,086,348.98 | 7,097,487.36 | 12,327,465.69 | 21,411,297.06 |
| Constant Implied Growth | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% | 73.69% |
| Implied Free Cash Flow | 14.88 | 25.85 | 44.90 | 77.99 | 135.46 | 235.27 | 408.63 | 709.75 | 1,232.75 | 2,141.13 |
| 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 | 14.26 | 22.22 | 36.30 | 59.28 | 96.82 | 158.14 | 258.28 | 421.85 | 688.99 | 1,125.32 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2019 | 2019-12-31 | $24.70 | -3.83% | $35.67 | 44.43% |
| 2018 | 2018-12-31 | $20.90 | 0.10% | $-8.68 | -141.52% |
| 2017 | 2017-12-31 | $42.50 | 3.67% | $-49.77 | -217.11% |
| 2016 | 2016-12-31 | $23.50 | 3.37% | $167.55 | 612.97% |
| 2015 | 2015-12-31 | $12.38 | 1.57% | $8.47 | -31.57% |
| 2014 | 2014-12-31 | $13.10 | 5.53% | $-13.28 | -201.35% |
| 2013 | 2013-12-31 | $20.25 | 6.73% | $-45.74 | -325.87% |
| 2012 | 2012-12-31 | $22.92 | 3.42% | $-5.87 | -125.60% |
| 2011 | 2011-12-31 | $19.17 | -1.70% | $-17.22 | -189.85% |
| 2010 | 2010-12-31 | $38.79 | -2.58% | $-8.51 | -121.94% |
| 2009 | 2009-12-31 | $25.67 | 0.71% | $-16.48 | -164.21% |
| 2008 | 2008-12-31 | $11.58 | 8.74% | $9.47 | -18.18% |
| 2007 | 2007-12-31 | $38.67 | 14.88% | $-36.07 | -193.29% |
| 2006 | 2006-12-31 | $27.00 | 17.97% | $21.95 | -18.69% |
| 2005 | 2005-12-31 | $17.50 | 17.24% | $-17.27 | -198.70% |
| 2004 | 2004-12-31 | $13.71 | 14.31% | $-31.64 | -330.78% |
| 2003 | 2003-12-31 | $9.96 | 22.49% | $-32.13 | -422.61% |
| $23.92 - $30.86 | 33 |
| $30.86 - $37.81 | 200 |
| $37.81 - $44.75 | 282 |
| $44.75 - $51.69 | 198 |
| $51.69 - $58.64 | 115 |
| $58.64 - $65.58 | 67 |
| $65.58 - $72.52 | 38 |
| $72.52 - $79.46 | 20 |
| $79.46 - $86.41 | 17 |
| $86.41 - $93.35 | 9 |
| $93.35 - $100.29 | 7 |
| $100.29 - $107.23 | 7 |
| $107.23 - $114.18 | 0 |
| $114.18 - $121.12 | 2 |
| $121.12 - $128.06 | 3 |
| $128.06 - $135.00 | 0 |
| $135.00 - $141.95 | 0 |
| $141.95 - $148.89 | 1 |
| $148.89 - $155.83 | 0 |
| $155.83 - $162.77 | 1 |