← Back to Cover                  
  PROBABILITY-WEIGHTED SCENARIO ANALYSIS
  Expected values calculated using probability weights from Assumptions sheet
   
                     
  SCENARIO WEIGHTS & EXPECTED VALUES   EXPECTED VALUE SUMMARY
  Metric Weight Worst Case Base Case Best Case Expected Value   Key Result Value Assessment
  Probability   25.0% 50.0% 25.0% 100.0%   Expected NPV ($mm) $521 Value Creating
  Implied Enterprise Value ($mm)   $1,091 $2,486 $6,023 $3,021   Expected IRR (%) -3.9% Below WACC
  NPV ($mm)   ($1,709) ($14) $3,823 $521   Expected MOIC (x) 0.84x Below 1x
  IRR (%)   -14.0% -4.5% 7.3% -3.9%   Prob. of Positive NPV 25.0% Low Confidence
  MOIC (x)   0.37x 0.75x 1.51x 0.84x   Max Downside Loss ($mm) ($1,709) Worst Case NPV
  Year 10 Revenue ($mm)   $1,095 $1,425 $2,008 $1,488   Max Upside Gain ($mm) $3,823 Best Case NPV
  Year 10 EBITDA ($mm)   $245 $401 $702 $437   Risk/Reward Ratio 2.24x Favorable
  Cumulative UFCF ($mm)   ($1,770) ($621) $1,118 ($473)        
  Terminal Value ($mm)   $1,715 $3,610 $8,421 $4,339        
  Total Synergies ($mm)   $50 $95 $145 $96        
  Yr 1 Accretion / (Dilution)   -98.3% -95.6% -90.8% -95.1%        
                     
                     
  Note: Expected values = SUM(Scenario Value x Probability). Probability weights editable in Assumptions sheet Section 5. Ensure weights sum to 100%. Risk/Reward = |Best NPV / Worst NPV|.