| Current Price | $61.98 |
| 5Y Range | 37.05 – 60.52 |
| 5Y Selected | 48.79 |
| (-) Safety Margin | 75.58% |
| 5Y Buy Price | $11.91 |
| Upside (to Buy Price) | -80.78% |
| 10Y Range | 37.67 – 58.62 |
| 10Y Selected | 48.14 |
| (-) Safety Margin | 75.58% |
| 10Y Buy Price | $11.76 |
| Upside (to Buy Price) | -81.03% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.6566 |
| Revenue R2 (10Y) | 0.8493 |
| Net Income R2 (5Y) | 0.0391 |
| Net Income R2 (10Y) | 0.0723 |
| EBITDA R2 (5Y) | 0.4849 |
| EBITDA R2 (10Y) | 0.7639 |
| FCF R2 (5Y) | 0.0103 |
| FCF R2 (10Y) | 0.3360 |
| Safety Score | 0.2442 |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | -0.74% | -0.22% | 0.31% | 0.84% | 1.36% | 1.89% | 2.42% | 2.95% | 3.47% | 4.00% |
| Revenue | 1,931.03 | 1,926.84 | 1,932.82 | 1,949.01 | 1,975.61 | 2,012.98 | 2,061.67 | 2,122.40 | 2,196.11 | 2,283.95 |
| EBITDA | 350.37 | 349.62 | 350.70 | 353.64 | 358.46 | 365.24 | 374.08 | 385.10 | 398.47 | 414.41 |
| D&A | -106.77 | -106.53 | -106.86 | -107.76 | -109.23 | -111.30 | -113.99 | -117.35 | -121.42 | -126.28 |
| EBIT | 243.61 | 243.08 | 243.84 | 245.88 | 249.23 | 253.95 | 260.09 | 267.75 | 277.05 | 288.13 |
| Pro forma Taxes | -70.11 | -69.96 | -70.17 | -70.76 | -71.73 | -73.08 | -74.85 | -77.06 | -79.73 | -82.92 |
| NOPAT | 173.50 | 173.12 | 173.66 | 175.12 | 177.51 | 180.86 | 185.24 | 190.70 | 197.32 | 205.21 |
| Capital Expenditures | -54.26 | -54.14 | -54.31 | -54.77 | -55.51 | -56.56 | -57.93 | -59.64 | -61.71 | -64.18 |
| NWC Investment | 2.85 | 0.82 | -1.18 | -3.19 | -5.24 | -7.36 | -9.59 | -11.96 | -14.52 | -17.30 |
| (+) D&A | 106.77 | 106.53 | 106.86 | 107.76 | 109.23 | 111.30 | 113.99 | 117.35 | 121.42 | 126.28 |
| Free Cash Flow | 228.86 | 226.34 | 225.04 | 224.92 | 225.99 | 228.24 | 231.71 | 236.44 | 242.52 | 250.01 |
| Diluted Shares Outstanding | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,000.00 | 65,375,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 | 12/31/22 | 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 | 7/1/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 | 226.87 | 224.38 | 223.09 | 216.09 | 199.01 | 184.23 | 171.43 | 160.35 | 150.75 | 142.45 | Raw: 3,468.50 2,924.29 |
Raw: 3,837.27 2,093.23 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 4,013.72 | 3,991.88 |
| (-) Net Debt | 996.68 | 996.68 |
| Equity Value | 3,017.05 | 2,995.21 |
| (/) Shares Out | 65.38 | 65.38 |
| Fair Value | $46.15 | $45.82 |
| (-) Safety Margin | 75.58% | 75.58% |
| Buy Price | $11.27 | $11.19 |
| Current Price | $61.98 | $61.98 |
| Upside (to Buy Price) | -81.82% | -81.95% |
| 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 | 226.66 | 224.17 | 222.88 | 215.19 | 196.37 | 180.14 | 166.11 | 153.95 | 143.42 | 134.30 | Raw: 2,818.12 2,333.85 |
Raw: 3,117.75 1,596.09 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 3,419.13 | 3,459.29 |
| (-) Net Debt | 996.68 | 996.68 |
| Equity Value | 2,422.45 | 2,462.61 |
| (/) Shares Out | 65.38 | 65.38 |
| Fair Value | $37.05 | $37.67 |
| (-) Safety Margin | 75.58% | 75.58% |
| Buy Price | $9.05 | $9.20 |
| Current Price | $61.98 | $61.98 |
| Upside (to Buy Price) | -85.40% | -85.16% |
| 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 | 227.08 | 224.58 | 223.29 | 217.01 | 201.70 | 188.45 | 176.98 | 167.07 | 158.52 | 151.18 | Raw: 4,496.02 3,859.63 |
Raw: 4,974.04 2,892.94 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 4,953.30 | 4,828.81 |
| (-) Net Debt | 996.68 | 996.68 |
| Equity Value | 3,956.62 | 3,832.14 |
| (/) Shares Out | 65.38 | 65.38 |
| Fair Value | $60.52 | $58.62 |
| (-) Safety Margin | 75.58% | 75.58% |
| Buy Price | $14.78 | $14.31 |
| Current Price | $61.98 | $61.98 |
| Upside (to Buy Price) | -76.15% | -76.90% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 4,441.38 | 10,139.21 | 23,146.79 | 52,841.75 | 120,632.33 | 275,391.30 | 628,690.24 | 1,435,235.67 | 3,276,496.56 | 7,479,907.29 |
| Constant Implied Growth | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% | 128.29% |
| Implied Free Cash Flow | 0.44 | 1.01 | 2.31 | 5.28 | 12.06 | 27.54 | 62.87 | 143.52 | 327.65 | 747.99 |
| 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 | 0.44 | 0.82 | 1.71 | 3.58 | 7.50 | 15.69 | 32.83 | 68.71 | 143.77 | 300.84 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2017 | 2017-12-31 | $50.40 | -0.21% | $16.85 | -66.57% |
| 2016 | 2016-12-31 | $36.90 | -2.01% | $19.17 | -48.06% |
| 2015 | 2015-12-31 | $25.08 | -1.22% | $27.86 | 11.10% |
| 2014 | 2014-12-31 | $28.39 | 0.97% | $25.39 | -10.57% |
| 2013 | 2013-12-31 | $34.22 | 0.51% | $27.52 | -19.57% |
| 2012 | 2012-12-31 | $22.05 | 1.24% | $10.95 | -50.34% |
| 2011 | 2011-12-31 | $18.83 | 0.66% | $7.93 | -57.87% |
| 2010 | 2010-12-31 | $19.86 | 3.48% | $11.46 | -42.28% |
| 2009 | 2009-12-31 | $12.35 | 9.45% | $37.30 | 202.01% |
| 2008 | 2008-12-31 | $7.91 | 12.04% | $17.24 | 117.98% |
| 2007 | 2007-12-31 | $16.63 | 5.73% | $14.18 | -14.73% |
| 2006 | 2006-12-31 | $14.05 | -1.83% | $-14.67 | -204.44% |
| 2005 | 2005-12-31 | $14.29 | -18.49% | $-422.24 | -3,054.78% |
| 2004 | 2004-12-31 | $14.29 | -89.88% | $-560.01 | -4,018.91% |
| $29.63 - $39.16 | 178 |
| $39.16 - $48.68 | 471 |
| $48.68 - $58.20 | 243 |
| $58.20 - $67.73 | 93 |
| $67.73 - $77.25 | 11 |
| $77.25 - $86.78 | 1 |
| $86.78 - $96.30 | 2 |
| $96.30 - $105.83 | 0 |
| $105.83 - $115.35 | 0 |
| $115.35 - $124.88 | 0 |
| $124.88 - $134.40 | 0 |
| $134.40 - $143.93 | 0 |
| $143.93 - $153.45 | 0 |
| $153.45 - $162.98 | 0 |
| $162.98 - $172.50 | 0 |
| $172.50 - $182.03 | 0 |
| $182.03 - $191.55 | 0 |
| $191.55 - $201.08 | 0 |
| $201.08 - $210.60 | 0 |
| $210.60 - $220.13 | 1 |