| ← Back to Cover | ||||||||||||
| WORST CASE SCENARIO — 10-Year Financial Projections | ||||||||||||
| Pessimistic assumptions: lower growth, compressed margins, slower synergies, discount exit | ||||||||||||
| ($mm unless noted) | Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |
| INCOME STATEMENT | ||||||||||||
| Revenue | $800 | $824 | $849 | $874 | $900 | $927 | $955 | $984 | $1,013 | $1,044 | $1,075 | |
| Revenue Growth (%) | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | 3.0% | ||
| Synergy Revenue | - | $5 | $10 | $15 | $20 | $20 | $20 | $20 | $20 | $20 | $20 | |
| Total Revenue | $800 | $829 | $859 | $889 | $920 | $947 | $975 | $1,004 | $1,033 | $1,064 | $1,095 | |
| EBITDA Margin (%) | 0.18 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | 0.2 | |
| EBITDA | $144 | $165 | $170 | $175 | $180 | $185 | $191 | $197 | $203 | $209 | $215 | |
| Cost Synergies | - | $8 | $15 | $23 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | |
| Total EBITDA | $144 | $172 | $185 | $197 | $210 | $215 | $221 | $227 | $233 | $239 | $245 | |
| (-) Depreciation & Amortization | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | |
| EBIT | $99 | $127 | $140 | $152 | $165 | $170 | $176 | $182 | $188 | $194 | $200 | |
| (-) Taxes | $25 | $32 | $35 | $38 | $41 | $43 | $44 | $45 | $47 | $48 | $50 | |
| NOPAT | $74 | $95 | $105 | $114 | $124 | $128 | $132 | $136 | $141 | $145 | $150 | |
| FREE CASH FLOW | ||||||||||||
| NOPAT | $74 | $95 | $105 | $114 | $124 | $128 | $132 | $136 | $141 | $145 | $150 | |
| (+) Depreciation & Amortization | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | $45 | |
| (-) Capital Expenditures | $48 | $50 | $52 | $53 | $55 | $57 | $59 | $60 | $62 | $64 | $66 | |
| (-) Change in Net Working Capital | - | $3 | $4 | $4 | $4 | $3 | $3 | $3 | $4 | $4 | $4 | |
| (-) Integration / Restructuring Costs | $52 | $39 | $39 | - | - | - | - | - | - | - | - | |
| Unlevered Free Cash Flow | ($2,800) | $48 | $56 | $102 | $110 | $113 | $115 | $118 | $120 | $123 | $126 | |
| Cumulative FCF | ($2,800) | ($2,752) | ($2,696) | ($2,594) | ($2,484) | ($2,371) | ($2,256) | ($2,138) | ($2,018) | ($1,895) | ($1,770) | |
| DCF VALUATION & RETURNS | ||||||||||||
| Discount Factor | 1 | 0.8929 | 0.7972 | 0.7118 | 0.6355 | 0.5674 | 0.5066 | 0.4523 | 0.4039 | 0.3606 | 0.3220 | |
| PV of Free Cash Flow | $43 | $44 | $73 | $70 | $64 | $58 | $53 | $49 | $44 | $40 | ||
| Terminal Value (Exit Multiple) | $1,715 | |||||||||||
| PV of Terminal Value | $552 | |||||||||||
| Implied Enterprise Value | $1,091 | |||||||||||
| NPV (EV - Purchase Price) | ($1,709) | |||||||||||
| IRR (%) | -14.0% | |||||||||||
| MOIC (x) | 0.37x | |||||||||||
| Payback Period (Years) | >10 | |||||||||||
| Exit EV/EBITDA (x) | 7.0x | |||||||||||
| Yr 1 Accretion / (Dilution) | -98.3% | |||||||||||
| Note: Worst Case uses pessimistic Assumptions (columns I/C). Lower growth, compressed margins, slower synergies, discount exit. Sample data. | ||||||||||||