| Current Price | $14.54 |
| 5Y Range | 20.62 – 28.54 |
| 5Y Selected | 24.58 |
| (-) Safety Margin | 74.40% |
| 5Y Buy Price | $6.29 |
| Upside (to Buy Price) | -56.73% |
| 10Y Range | 18.73 – 24.46 |
| 10Y Selected | 21.59 |
| (-) Safety Margin | 74.40% |
| 10Y Buy Price | $5.53 |
| Upside (to Buy Price) | -61.98% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.4009 |
| Revenue R2 (10Y) | 0.6763 |
| Net Income R2 (5Y) | 0.1364 |
| Net Income R2 (10Y) | 0.1773 |
| EBITDA R2 (5Y) | 0.0074 |
| EBITDA R2 (10Y) | 0.4915 |
| FCF R2 (5Y) | 0.4319 |
| FCF R2 (10Y) | 0.7506 |
| Safety Score | 0.2560 |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | -4.86% | -3.87% | -2.89% | -1.90% | -0.92% | 0.06% | 1.05% | 2.03% | 3.02% | 4.00% |
| Revenue | 6,885.47 | 6,618.78 | 6,427.56 | 6,305.12 | 6,247.07 | 6,251.03 | 6,316.51 | 6,444.85 | 6,639.21 | 6,904.78 |
| EBITDA | 810.88 | 779.48 | 756.96 | 742.54 | 735.70 | 736.17 | 743.88 | 758.99 | 781.88 | 813.16 |
| D&A | -383.87 | -369.00 | -358.34 | -351.52 | -348.28 | -348.50 | -352.15 | -359.31 | -370.14 | -384.95 |
| EBIT | 427.01 | 410.47 | 398.61 | 391.02 | 387.42 | 387.67 | 391.73 | 399.69 | 411.74 | 428.21 |
| Pro forma Taxes | -89.67 | -86.20 | -83.71 | -82.11 | -81.36 | -81.41 | -82.26 | -83.93 | -86.47 | -89.92 |
| NOPAT | 337.34 | 324.27 | 314.91 | 308.91 | 306.06 | 306.26 | 309.46 | 315.75 | 325.27 | 338.29 |
| Capital Expenditures | -218.76 | -210.29 | -204.21 | -200.32 | -198.48 | -198.60 | -200.68 | -204.76 | -210.94 | -219.37 |
| NWC Investment | 109.22 | 82.86 | 59.41 | 38.04 | 18.04 | -1.23 | -20.34 | -39.87 | -60.39 | -82.51 |
| (+) D&A | 383.87 | 369.00 | 358.34 | 351.52 | 348.28 | 348.50 | 352.15 | 359.31 | 370.14 | 384.95 |
| Free Cash Flow | 611.67 | 565.85 | 528.45 | 498.14 | 473.90 | 454.92 | 440.59 | 430.43 | 424.09 | 421.35 |
| Diluted Shares Outstanding | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 | 395,500,000.00 |
| Metric | Dec-23 | Dec-24 | Dec-25 | Dec-26 | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 |
|---|---|---|---|---|---|---|---|---|---|---|
| Period Start | 9/30/23 | 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 | 11/15/23 | 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.96 | 0.88 | 0.81 | 0.74 | 0.68 | 0.62 | 0.57 | ||
| PV UFCF | 606.36 | 560.94 | 523.87 | 478.58 | 417.33 | 367.21 | 325.98 | 291.90 | 263.62 | 240.08 | Raw: 7,174.46 6,048.79 |
Raw: 6,378.87 3,479.68 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 8,635.87 | 7,555.54 |
| (-) Net Debt | -737.00 | -737.00 |
| Equity Value | 9,372.87 | 8,292.54 |
| (/) Shares Out | 395.50 | 395.50 |
| Fair Value | $23.70 | $20.97 |
| (-) Safety Margin | 74.40% | 74.40% |
| Buy Price | $6.07 | $5.37 |
| Current Price | $14.54 | $14.54 |
| Upside (to Buy Price) | -58.27% | -63.08% |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.99 | 0.99 | 0.96 | 0.87 | 0.79 | 0.72 | 0.65 | 0.59 | 0.54 | ||
| PV UFCF | 605.81 | 560.43 | 523.39 | 476.58 | 411.80 | 359.06 | 315.85 | 280.26 | 250.81 | 226.33 | Raw: 5,842.88 4,838.82 |
Raw: 5,194.95 2,659.48 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 7,416.84 | 6,669.80 |
| (-) Net Debt | -737.00 | -737.00 |
| Equity Value | 8,153.84 | 7,406.80 |
| (/) Shares Out | 395.50 | 395.50 |
| Fair Value | $20.62 | $18.73 |
| (-) Safety Margin | 74.40% | 74.40% |
| Buy Price | $5.28 | $4.79 |
| Current Price | $14.54 | $14.54 |
| Upside (to Buy Price) | -63.70% | -67.03% |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | TV (5y) | TV (10y) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Discount Factor | 0.99 | 0.99 | 0.99 | 0.96 | 0.89 | 0.83 | 0.76 | 0.71 | 0.65 | 0.60 | ||
| PV UFCF | 606.92 | 561.46 | 524.35 | 480.62 | 422.98 | 375.62 | 336.53 | 304.14 | 277.21 | 254.79 | Raw: 9,265.52 7,954.03 |
Raw: 8,238.05 4,791.30 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 10,550.35 | 8,935.91 |
| (-) Net Debt | -737.00 | -737.00 |
| Equity Value | 11,287.35 | 9,672.91 |
| (/) Shares Out | 395.50 | 395.50 |
| Fair Value | $28.54 | $24.46 |
| (-) Safety Margin | 74.40% | 74.40% |
| Buy Price | $7.31 | $6.26 |
| Current Price | $14.54 | $14.54 |
| Upside (to Buy Price) | -49.75% | -56.94% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 16,367.23 | 32,224.99 | 63,446.88 | 124,918.79 | 245,949.12 | 484,242.35 | 953,411.24 | 1,877,144.77 | 3,695,857.90 | 7,276,671.40 |
| Constant Implied Growth | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% | 96.89% |
| Implied Free Cash Flow | 1.64 | 3.22 | 6.34 | 12.49 | 24.59 | 48.42 | 95.34 | 187.71 | 369.59 | 727.67 |
| Discount Factor | 0.99 | 0.81 | 0.74 | 0.68 | 0.62 | 0.57 | 0.52 | 0.48 | 0.44 | 0.40 |
| Present Value of Implied FCF | 1.62 | 2.60 | 4.69 | 8.47 | 15.29 | 27.59 | 49.79 | 89.86 | 162.17 | 292.66 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2017 | 2017-12-31 | $37.71 | -8.29% | $21.35 | -43.38% |
| 2016 | 2016-12-31 | $37.71 | -9.47% | $21.28 | -43.58% |
| 2015 | 2015-12-31 | $37.71 | -2.57% | $35.89 | -4.83% |
| 2014 | 2014-12-31 | $37.71 | -9.37% | $51.88 | 37.57% |
| 2013 | 2013-12-31 | $37.71 | -22.81% | $40.88 | 8.40% |
| 2012 | 2012-12-31 | $37.71 | -26.27% | $8.28 | -78.05% |
| $16.56 - $17.60 | 23 |
| $17.60 - $18.64 | 83 |
| $18.64 - $19.67 | 156 |
| $19.67 - $20.71 | 201 |
| $20.71 - $21.75 | 173 |
| $21.75 - $22.79 | 134 |
| $22.79 - $23.82 | 102 |
| $23.82 - $24.86 | 48 |
| $24.86 - $25.90 | 31 |
| $25.90 - $26.94 | 19 |
| $26.94 - $27.97 | 12 |
| $27.97 - $29.01 | 10 |
| $29.01 - $30.05 | 4 |
| $30.05 - $31.09 | 1 |
| $31.09 - $32.12 | 1 |
| $32.12 - $33.16 | 0 |
| $33.16 - $34.20 | 0 |
| $34.20 - $35.24 | 1 |
| $35.24 - $36.27 | 0 |
| $36.27 - $37.31 | 0 |