| Current Price | $15.52 |
| 5Y Range | -3.01 – -1.83 |
| 5Y Selected | -2.42 |
| (-) Safety Margin | 85.67% |
| 5Y Buy Price | $-0.43 |
| Upside (to Buy Price) | -102.79% |
| 10Y Range | -2.89 – -1.67 |
| 10Y Selected | -2.28 |
| (-) Safety Margin | 85.67% |
| 10Y Buy Price | $-0.41 |
| Upside (to Buy Price) | -102.62% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.7909 |
| Revenue R2 (10Y) | 0.0031 |
| Net Income R2 (5Y) | 0.3146 |
| Net Income R2 (10Y) | 0.1590 |
| EBITDA R2 (5Y) | 0.1983 |
| EBITDA R2 (10Y) | 0.2668 |
| FCF R2 (5Y) | 0.8560 |
| FCF R2 (10Y) | 0.0376 |
| Safety Score | 0.1787 |
| Metric | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | 3.99% | 3.99% | 3.99% | 3.99% | 3.99% | 4.00% | 4.00% | 4.00% | 4.00% | 4.00% |
| Revenue | 12,229.31 | 12,717.47 | 13,225.25 | 13,753.44 | 14,302.86 | 14,874.39 | 15,468.90 | 16,087.34 | 16,730.67 | 17,399.89 |
| EBITDA | 7,001.94 | 7,281.44 | 7,572.17 | 7,874.58 | 8,189.16 | 8,516.39 | 8,856.78 | 9,210.87 | 9,579.21 | 9,962.38 |
| D&A | -72.23 | -75.11 | -78.11 | -81.23 | -84.47 | -87.85 | -91.36 | -95.01 | -98.81 | -102.76 |
| EBIT | 6,929.71 | 7,206.33 | 7,494.06 | 7,793.36 | 8,104.69 | 8,428.54 | 8,765.42 | 9,115.86 | 9,480.40 | 9,859.61 |
| Pro forma Taxes | -1,679.06 | -1,746.08 | -1,815.80 | -1,888.32 | -1,963.75 | -2,042.22 | -2,123.85 | -2,208.76 | -2,297.08 | -2,388.97 |
| NOPAT | 5,250.66 | 5,460.25 | 5,678.26 | 5,905.04 | 6,140.94 | 6,386.32 | 6,641.58 | 6,907.10 | 7,183.32 | 7,470.65 |
| Capital Expenditures | -5,315.36 | -5,527.53 | -5,748.23 | -5,977.81 | -6,216.61 | -6,465.02 | -6,723.42 | -6,992.22 | -7,271.83 | -7,562.71 |
| NWC Investment | 76.97 | 80.06 | 83.28 | 86.63 | 90.11 | 93.73 | 97.50 | 101.43 | 105.51 | 109.76 |
| (+) D&A | 72.23 | 75.11 | 78.11 | 81.23 | 84.47 | 87.85 | 91.36 | 95.01 | 98.81 | 102.76 |
| Free Cash Flow | 84.49 | 87.89 | 91.42 | 95.09 | 98.91 | 102.89 | 107.02 | 111.33 | 115.80 | 120.46 |
| Diluted Shares Outstanding | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.00 | 1,361,618,242.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 | 83.98 | 85.43 | 83.56 | 81.73 | 79.94 | 78.19 | 76.48 | 74.80 | 73.17 | 71.57 | Raw: 2,320.95 1,818.91 |
Raw: 2,826.71 1,628.43 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 2,233.54 | 2,417.26 |
| (-) Net Debt | 5,807.05 | 5,807.05 |
| Equity Value | -3,573.51 | -3,389.79 |
| (/) Shares Out | 1,361.62 | 1,361.62 |
| Fair Value | $-2.62 | $-2.49 |
| (-) Safety Margin | 85.67% | 85.67% |
| Buy Price | $-0.38 | $-0.36 |
| Current Price | $15.52 | $15.52 |
| Upside (to Buy Price) | -102.42% | -102.30% |
| 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 | 83.90 | 85.07 | 82.43 | 79.87 | 77.39 | 74.99 | 72.67 | 70.41 | 68.23 | 66.12 | Raw: 1,717.06 1,296.69 |
Raw: 2,091.23 1,107.82 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 1,705.33 | 1,868.89 |
| (-) Net Debt | 5,807.05 | 5,807.05 |
| Equity Value | -4,101.72 | -3,938.16 |
| (/) Shares Out | 1,361.62 | 1,361.62 |
| Fair Value | $-3.01 | $-2.89 |
| (-) Safety Margin | 85.67% | 85.67% |
| Buy Price | $-0.43 | $-0.41 |
| Current Price | $15.52 | $15.52 |
| Upside (to Buy Price) | -102.78% | -102.67% |
| 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 | 84.05 | 85.81 | 84.72 | 83.65 | 82.59 | 81.55 | 80.52 | 79.51 | 78.51 | 77.52 | Raw: 3,561.20 2,897.27 |
Raw: 4,337.22 2,719.33 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 3,318.09 | 3,537.77 |
| (-) Net Debt | 5,807.05 | 5,807.05 |
| Equity Value | -2,488.96 | -2,269.28 |
| (/) Shares Out | 1,361.62 | 1,361.62 |
| Fair Value | $-1.83 | $-1.67 |
| (-) Safety Margin | 85.67% | 85.67% |
| Buy Price | $-0.26 | $-0.24 |
| Current Price | $15.52 | $15.52 |
| Upside (to Buy Price) | -101.69% | -101.54% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 43,702.17 | 85,483.84 | 167,211.07 | 327,074.00 | 639,774.62 | 1,251,434.15 | 2,447,873.64 | 4,788,174.71 | 9,365,931.59 | 18,320,274.39 |
| Constant Implied Growth | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% | 95.61% |
| Implied Free Cash Flow | 4.37 | 8.55 | 16.72 | 32.71 | 63.98 | 125.14 | 244.79 | 478.82 | 936.59 | 1,832.03 |
| 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 | 4.19 | 7.35 | 13.51 | 24.86 | 45.72 | 84.09 | 154.66 | 284.46 | 523.21 | 962.33 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2019 | 2019-12-31 | $19.26 | 4.22% | $-109.77 | -669.96% |
| 2018 | 2018-12-31 | $19.94 | 4.40% | $-110.28 | -653.08% |
| 2017 | 2017-12-31 | $28.75 | 3.22% | $44.72 | 55.56% |
| 2016 | 2016-12-31 | $27.00 | -2.32% | $38.28 | 41.77% |
| 2015 | 2015-12-31 | $25.20 | -9.75% | $-8.95 | -135.52% |
| 2014 | 2014-12-31 | $35.20 | -4.01% | $94.33 | 167.97% |
| 2013 | 2013-12-31 | $39.15 | -9.82% | $-36.53 | -193.31% |
| 2012 | 2012-12-31 | $44.05 | 0.54% | $-0.52 | -101.17% |
| 2011 | 2011-06-30 | $49.30 | 10.40% | $-19.32 | -139.18% |
| 2010 | 2010-06-30 | $41.80 | 18.70% | $136.63 | 226.86% |
| 2009 | 2009-06-30 | $36.50 | 12.57% | $21.21 | -41.88% |
| 2008 | 2008-06-30 | $34.65 | 10.48% | $116.53 | 236.30% |
| 2007 | 2007-06-30 | $35.30 | -3.93% | $-5.70 | -116.14% |
| 2006 | 2006-06-30 | $16.80 | 5.11% | $-1.09 | -106.49% |
| 2005 | 2005-06-30 | $13.80 | 21.28% | $102.51 | 642.79% |
| 2004 | 2004-06-30 | $10.50 | -0.38% | $-5.71 | -154.42% |
| 2003 | 2003-06-30 | $6.35 | 8.61% | $-13.62 | -314.47% |
| 2002 | 2002-06-30 | $7.35 | 4.14% | $-8.97 | -222.11% |
| 2001 | 2001-06-30 | $7.60 | 13.17% | $-55.95 | -836.19% |
| 2000 | 2000-06-30 | $6.05 | 10.03% | $1.88 | -68.92% |
| 1999 | 1999-06-30 | $8.75 | 7.85% | $-23.15 | -364.53% |
| 1998 | 1998-06-30 | $8.75 | 0.92% | $5.16 | -41.06% |
| 1997 | 1997-06-30 | $8.75 | -4.24% | $34.41 | 293.23% |
| 1996 | 1996-06-30 | $8.75 | -10.43% | $34.10 | 289.76% |
| $-3.28 - $-3.08 | 18 |
| $-3.08 - $-2.88 | 107 |
| $-2.88 - $-2.68 | 182 |
| $-2.68 - $-2.48 | 184 |
| $-2.48 - $-2.28 | 169 |
| $-2.28 - $-2.08 | 90 |
| $-2.08 - $-1.88 | 87 |
| $-1.88 - $-1.68 | 52 |
| $-1.68 - $-1.48 | 37 |
| $-1.48 - $-1.28 | 22 |
| $-1.28 - $-1.08 | 19 |
| $-1.08 - $-0.88 | 8 |
| $-0.88 - $-0.68 | 6 |
| $-0.68 - $-0.48 | 5 |
| $-0.48 - $-0.28 | 5 |
| $-0.28 - $-0.08 | 1 |
| $-0.08 - $0.12 | 2 |
| $0.12 - $0.32 | 1 |
| $0.32 - $0.52 | 4 |
| $0.52 - $0.72 | 0 |