| Current Price | $3.73 |
| 5Y Range | 5.23 – 12.27 |
| 5Y Selected | 8.75 |
| (-) Safety Margin | 79.86% |
| 5Y Buy Price | $2.08 |
| Upside (to Buy Price) | -44.23% |
| 10Y Range | 5.40 – 12.18 |
| 10Y Selected | 8.79 |
| (-) Safety Margin | 79.86% |
| 10Y Buy Price | $2.09 |
| Upside (to Buy Price) | -43.97% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.0277 |
| Revenue R2 (10Y) | 0.7055 |
| Net Income R2 (5Y) | 0.4756 |
| Net Income R2 (10Y) | 0.3824 |
| EBITDA R2 (5Y) | 0.0202 |
| EBITDA R2 (10Y) | 0.5840 |
| FCF R2 (5Y) | 0.5042 |
| FCF R2 (10Y) | 0.0097 |
| Safety Score | 0.2377 |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | 0.57% | 0.95% | 1.33% | 1.71% | 2.09% | 2.47% | 2.86% | 3.24% | 3.62% | 4.00% |
| Revenue | 20,070.03 | 20,260.08 | 20,529.26 | 20,880.36 | 21,317.15 | 21,844.42 | 22,468.11 | 23,195.34 | 24,034.64 | 24,996.02 |
| EBITDA | 4,660.86 | 4,705.00 | 4,767.51 | 4,849.04 | 4,950.48 | 5,072.93 | 5,217.76 | 5,386.65 | 5,581.56 | 5,804.82 |
| D&A | -647.36 | -653.49 | -662.17 | -673.49 | -687.58 | -704.59 | -724.71 | -748.16 | -775.24 | -806.25 |
| EBIT | 4,013.50 | 4,051.51 | 4,105.34 | 4,175.55 | 4,262.89 | 4,368.34 | 4,493.06 | 4,638.49 | 4,806.32 | 4,998.58 |
| Pro forma Taxes | -945.18 | -954.13 | -966.81 | -983.35 | -1,003.92 | -1,028.75 | -1,058.12 | -1,092.37 | -1,131.89 | -1,177.17 |
| NOPAT | 3,068.32 | 3,097.37 | 3,138.53 | 3,192.20 | 3,258.98 | 3,339.59 | 3,434.94 | 3,546.12 | 3,674.43 | 3,821.41 |
| Capital Expenditures | -854.35 | -862.44 | -873.90 | -888.85 | -907.44 | -929.89 | -956.44 | -987.39 | -1,023.12 | -1,064.05 |
| NWC Investment | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 |
| (+) D&A | 647.36 | 653.49 | 662.17 | 673.49 | 687.58 | 704.59 | 724.71 | 748.16 | 775.24 | 806.25 |
| Free Cash Flow | 2,861.32 | 2,888.42 | 2,926.79 | 2,976.85 | 3,039.12 | 3,114.29 | 3,203.21 | 3,306.89 | 3,426.54 | 3,563.61 |
| Diluted Shares Outstanding | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 | 13,694,117,500.00 |
| Metric | Dec-23 | Dec-24 | Dec-25 | Dec-26 | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 |
|---|---|---|---|---|---|---|---|---|---|---|
| Period Start | 12/31/19 | 1/1/24 | 1/1/25 | 1/1/26 | 1/1/27 | 1/1/28 | 1/1/29 | 1/1/30 | 1/1/31 | 1/1/32 |
| Period End | 12/31/23 | 12/31/24 | 12/31/25 | 12/31/26 | 12/31/27 | 12/31/28 | 12/31/29 | 12/31/30 | 12/31/31 | 12/31/32 |
| Mid-Point | 12/30/21 | 7/1/24 | 7/2/25 | 7/2/26 | 7/2/27 | 7/1/28 | 7/2/29 | 7/2/30 | 7/2/31 | 7/1/32 |
| Time (t) | 0.10 | 0.10 | 0.10 | 0.46 | 1.46 | 2.46 | 3.46 | 4.46 | 5.46 | 6.46 |
| Valuation Date | 1/16/26 | |||||||||
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.99 | 0.99 | 0.97 | 0.91 | 0.86 | 0.81 | 0.76 | 0.72 | 0.67 | ||
| PV UFCF | 2,843.87 | 2,870.80 | 2,908.94 | 2,894.23 | 2,779.41 | 2,679.12 | 2,592.06 | 2,517.14 | 2,453.42 | 2,400.12 | Raw: 92,872.68 82,377.10 |
Raw: 108,900.48 71,135.67 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 96,674.36 | 98,074.79 |
| (-) Net Debt | -1,697.78 | -1,697.78 |
| Equity Value | 98,372.14 | 99,772.57 |
| (/) Shares Out | 13,694.12 | 13,694.12 |
| Fair Value | $7.18 | $7.29 |
| (-) Safety Margin | 79.86% | 79.86% |
| Buy Price | $1.45 | $1.47 |
| Current Price | $3.73 | $3.73 |
| Upside (to Buy Price) | -61.21% | -60.66% |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.99 | 0.99 | 0.97 | 0.90 | 0.84 | 0.78 | 0.73 | 0.68 | 0.63 | ||
| PV UFCF | 2,841.21 | 2,868.11 | 2,906.22 | 2,881.80 | 2,741.68 | 2,618.12 | 2,509.44 | 2,414.20 | 2,331.16 | 2,259.26 | Raw: 63,946.73 55,688.73 |
Raw: 74,982.54 45,889.97 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 69,927.74 | 72,261.15 |
| (-) Net Debt | -1,697.78 | -1,697.78 |
| Equity Value | 71,625.52 | 73,958.93 |
| (/) Shares Out | 13,694.12 | 13,694.12 |
| Fair Value | $5.23 | $5.40 |
| (-) Safety Margin | 79.86% | 79.86% |
| Buy Price | $1.05 | $1.09 |
| Current Price | $3.73 | $3.73 |
| Upside (to Buy Price) | -71.76% | -70.84% |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.99 | 0.99 | 0.98 | 0.93 | 0.88 | 0.84 | 0.79 | 0.75 | 0.72 | ||
| PV UFCF | 2,846.56 | 2,873.51 | 2,911.69 | 2,906.84 | 2,818.03 | 2,742.14 | 2,678.23 | 2,625.51 | 2,583.35 | 2,551.22 | Raw: 168,238.95 152,016.23 |
Raw: 197,273.33 137,623.77 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 166,372.86 | 165,160.85 |
| (-) Net Debt | -1,697.78 | -1,697.78 |
| Equity Value | 168,070.64 | 166,858.64 |
| (/) Shares Out | 13,694.12 | 13,694.12 |
| Fair Value | $12.27 | $12.18 |
| (-) Safety Margin | 79.86% | 79.86% |
| Buy Price | $2.47 | $2.45 |
| Current Price | $3.73 | $3.73 |
| Upside (to Buy Price) | -33.73% | -34.21% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 82,686.12 | 160,890.72 | 313,061.30 | 609,154.92 | 1,185,294.12 | 2,306,346.22 | 4,487,690.27 | 8,732,151.24 | 16,991,026.71 | 33,061,153.04 |
| Constant Implied Growth | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% | 94.58% |
| Implied Free Cash Flow | 8.27 | 16.09 | 31.31 | 60.92 | 118.53 | 230.63 | 448.77 | 873.22 | 1,699.10 | 3,306.12 |
| Discount Factor | 0.99 | 0.86 | 0.81 | 0.76 | 0.72 | 0.67 | 0.63 | 0.60 | 0.56 | 0.53 |
| Present Value of Implied FCF | 8.22 | 13.84 | 25.33 | 46.37 | 84.87 | 155.33 | 284.31 | 520.38 | 952.46 | 1,743.30 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2017 | 2017-12-31 | $5.80 | -0.47% | $2.31 | -60.22% |
| 2016 | 2016-12-31 | $3.67 | 2.42% | $4.32 | 17.79% |
| 2015 | 2015-12-31 | $3.68 | 3.99% | $5.94 | 61.46% |
| 2014 | 2014-12-31 | $3.99 | 3.79% | $2.55 | -36.03% |
| $3.46 - $12.66 | 913 |
| $12.66 - $21.85 | 66 |
| $21.85 - $31.04 | 13 |
| $31.04 - $40.23 | 2 |
| $40.23 - $49.42 | 2 |
| $49.42 - $58.61 | 0 |
| $58.61 - $67.80 | 1 |
| $67.80 - $76.99 | 0 |
| $76.99 - $86.18 | 0 |
| $86.18 - $95.37 | 0 |
| $95.37 - $104.57 | 0 |
| $104.57 - $113.76 | 1 |
| $113.76 - $122.95 | 1 |
| $122.95 - $132.14 | 0 |
| $132.14 - $141.33 | 0 |
| $141.33 - $150.52 | 0 |
| $150.52 - $159.71 | 0 |
| $159.71 - $168.90 | 0 |
| $168.90 - $178.09 | 0 |
| $178.09 - $187.28 | 1 |