| Current Price | $100.65 |
| 5Y Range | 49.27 – 74.33 |
| 5Y Selected | 61.80 |
| (-) Safety Margin | 39.11% |
| 5Y Buy Price | $37.63 |
| Upside (to Buy Price) | -62.61% |
| 10Y Range | 54.31 – 79.51 |
| 10Y Selected | 66.91 |
| (-) Safety Margin | 39.11% |
| 10Y Buy Price | $40.74 |
| Upside (to Buy Price) | -59.52% |
| Metric | Value |
|---|---|
| Revenue R2 (5Y) | 0.8307 |
| Revenue R2 (10Y) | 0.9702 |
| Net Income R2 (5Y) | 0.8441 |
| Net Income R2 (10Y) | 0.9094 |
| EBITDA R2 (5Y) | 0.9524 |
| EBITDA R2 (10Y) | 0.9528 |
| FCF R2 (5Y) | 0.0028 |
| FCF R2 (10Y) | 0.5130 |
| Safety Score | 0.6089 |
| Metric | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 |
|---|---|---|---|---|---|---|---|---|---|---|
| % Growth | 6.68% | 6.39% | 6.09% | 5.79% | 5.49% | 5.19% | 4.89% | 4.60% | 4.30% | 4.00% |
| Revenue | 1,377.82 | 1,465.80 | 1,555.03 | 1,645.06 | 1,735.39 | 1,825.50 | 1,914.85 | 2,002.86 | 2,088.95 | 2,172.51 |
| EBITDA | 395.20 | 420.43 | 446.02 | 471.85 | 497.75 | 523.60 | 549.23 | 574.47 | 599.17 | 623.13 |
| D&A | -122.84 | -130.68 | -138.63 | -146.66 | -154.71 | -162.75 | -170.71 | -178.56 | -186.23 | -193.68 |
| EBIT | 272.36 | 289.75 | 307.39 | 325.19 | 343.04 | 360.85 | 378.52 | 395.92 | 412.93 | 429.45 |
| Pro forma Taxes | -64.09 | -68.19 | -72.34 | -76.52 | -80.73 | -84.92 | -89.07 | -93.17 | -97.17 | -101.06 |
| NOPAT | 208.27 | 221.57 | 235.05 | 248.66 | 262.32 | 275.94 | 289.44 | 302.75 | 315.76 | 328.39 |
| Capital Expenditures | -82.84 | -88.13 | -93.49 | -98.90 | -104.33 | -109.75 | -115.12 | -120.42 | -125.59 | -130.62 |
| NWC Investment | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.16 | 0.15 | 0.15 |
| (+) D&A | 122.84 | 130.68 | 138.63 | 146.66 | 154.71 | 162.75 | 170.71 | 178.56 | 186.23 | 193.68 |
| Free Cash Flow | 248.42 | 264.28 | 280.36 | 296.58 | 312.86 | 329.09 | 345.19 | 361.05 | 376.56 | 391.61 |
| Diluted Shares Outstanding | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 | 86,376,750.00 |
| Metric | Dec-23 | Dec-24 | Dec-25 | Dec-26 | Dec-27 | Dec-28 | Dec-29 | Dec-30 | Dec-31 | Dec-32 |
|---|---|---|---|---|---|---|---|---|---|---|
| Period Start | 6/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 | 9/30/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.45 | 1.45 | 2.46 | 3.46 | 4.46 | 5.46 | 6.46 |
| Valuation Date | 1/17/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 | 246.27 | 261.99 | 277.93 | 285.18 | 275.75 | 265.64 | 255.40 | 244.85 | 234.07 | 223.13 | Raw: 4,848.57 4,091.39 |
Raw: 6,069.05 3,310.67 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 5,438.50 | 5,880.87 |
| (-) Net Debt | 345.87 | 345.87 |
| Equity Value | 5,092.64 | 5,535.00 |
| (/) Shares Out | 86.38 | 86.38 |
| Fair Value | $58.96 | $64.08 |
| (-) Safety Margin | 39.11% | 39.11% |
| Buy Price | $35.90 | $39.02 |
| Current Price | $100.65 | $100.65 |
| Upside (to Buy Price) | -64.33% | -61.23% |
| 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 | 246.04 | 261.75 | 277.67 | 284.01 | 272.12 | 259.74 | 247.46 | 235.09 | 222.70 | 210.36 | Raw: 3,932.83 3,260.14 |
Raw: 4,922.81 2,520.16 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 4,601.74 | 5,037.10 |
| (-) Net Debt | 345.87 | 345.87 |
| Equity Value | 4,255.87 | 4,691.24 |
| (/) Shares Out | 86.38 | 86.38 |
| Fair Value | $49.27 | $54.31 |
| (-) Safety Margin | 39.11% | 39.11% |
| Buy Price | $30.00 | $33.07 |
| Current Price | $100.65 | $100.65 |
| Upside (to Buy Price) | -70.19% | -67.14% |
| 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.89 | 0.83 | 0.76 | 0.71 | 0.65 | 0.60 | ||
| PV UFCF | 246.49 | 262.23 | 278.18 | 286.37 | 279.45 | 271.72 | 263.66 | 255.12 | 246.14 | 236.80 | Raw: 6,301.62 5,413.87 |
Raw: 7,887.86 4,587.63 |
| 5-Year Horizon | 10-Year Horizon | |
|---|---|---|
| UFCF | UFCF | |
| Enterprise Value | 6,766.59 | 7,213.81 |
| (-) Net Debt | 345.87 | 345.87 |
| Equity Value | 6,420.73 | 6,867.94 |
| (/) Shares Out | 86.38 | 86.38 |
| Fair Value | $74.33 | $79.51 |
| (-) Safety Margin | 39.11% | 39.11% |
| Buy Price | $45.26 | $48.41 |
| Current Price | $100.65 | $100.65 |
| Upside (to Buy Price) | -55.03% | -51.90% |
| Metric | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 |
|---|---|---|---|---|---|---|---|---|---|---|
| Implied Revenue | 3,364.52 | 8,461.42 | 21,279.55 | 53,515.79 | 134,586.46 | 338,470.49 | 851,216.93 | 2,140,719.13 | 5,383,678.66 | 13,539,373.50 |
| Constant Implied Growth | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% | 151.49% |
| Implied Free Cash Flow | 0.34 | 0.85 | 2.13 | 5.35 | 13.46 | 33.85 | 85.12 | 214.07 | 538.37 | 1,353.94 |
| 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.33 | 0.68 | 1.57 | 3.63 | 8.37 | 19.29 | 44.46 | 102.48 | 236.23 | 544.55 |
| Year | Valuation Date | Actual Price | Realized Growth (5Y) | Calculated Fair Value | Valuation Delta |
|---|---|---|---|---|---|
| 2017 | 2017-12-31 | $30.58 | 8.58% | $19.43 | -36.47% |
| 2016 | 2016-12-31 | $18.40 | 5.18% | $6.74 | -63.37% |
| 2015 | 2015-12-31 | $17.84 | 3.96% | $7.19 | -59.68% |
| 2014 | 2014-12-31 | $12.34 | 4.95% | $10.87 | -11.91% |
| 2013 | 2013-12-31 | $16.58 | 9.40% | $-9.62 | -158.00% |
| 2012 | 2012-12-31 | $7.89 | 11.51% | $10.48 | 32.78% |
| 2011 | 2011-12-31 | $9.32 | 10.29% | $11.79 | 26.49% |
| 2010 | 2010-12-31 | $14.24 | 6.80% | $8.36 | -41.26% |
| 2009 | 2009-12-31 | $15.33 | 2.70% | $27.45 | 79.05% |
| 2008 | 2008-12-31 | $11.08 | 1.16% | $3.74 | -66.28% |
| 2007 | 2007-12-31 | $14.76 | -2.02% | $17.17 | 16.34% |
| 2006 | 2006-04-30 | $17.20 | -1.98% | $14.07 | -18.23% |
| 2005 | 2005-12-31 | $0.00 | 1.58% | $2.69 | 0.00% |
| 2004 | 2004-04-30 | $13.76 | 6.00% | $10.98 | -20.22% |
| 2003 | 2003-04-30 | $9.08 | 7.97% | $4.85 | -46.60% |
| 2002 | 2002-04-30 | $14.45 | 5.48% | $11.09 | -23.26% |
| 2001 | 2001-04-30 | $13.63 | -0.16% | $-14.91 | -209.38% |
| 2000 | 2000-04-30 | $18.13 | -3.89% | $12.03 | -33.63% |
| 1999 | 1999-04-30 | $25.25 | -3.74% | $10.24 | -59.45% |
| 1998 | 1998-04-30 | $25.25 | 3.17% | $1.68 | -93.36% |
| $45.93 - $49.92 | 25 |
| $49.92 - $53.92 | 79 |
| $53.92 - $57.91 | 131 |
| $57.91 - $61.91 | 190 |
| $61.91 - $65.90 | 158 |
| $65.90 - $69.90 | 131 |
| $69.90 - $73.89 | 117 |
| $73.89 - $77.88 | 63 |
| $77.88 - $81.88 | 44 |
| $81.88 - $85.87 | 23 |
| $85.87 - $89.87 | 13 |
| $89.87 - $93.86 | 11 |
| $93.86 - $97.85 | 6 |
| $97.85 - $101.85 | 2 |
| $101.85 - $105.84 | 1 |
| $105.84 - $109.84 | 4 |
| $109.84 - $113.83 | 0 |
| $113.83 - $117.83 | 1 |
| $117.83 - $121.82 | 0 |
| $121.82 - $125.81 | 1 |