M&A SCENARIO MANAGER
  Enterprise Deal Evaluation & Decision Framework
   
  Date: February 13, 2026   |   Prepared by: [Analyst Name]   |   Status: DRAFT
                 
  DEAL OVERVIEW   NAVIGATION
  Target Company [Target Co. Name]       Assumptions Deal inputs & parameters
  Acquirer [Acquirer Name]       Base Case Base scenario projections
  Transaction Type 100% Acquisition       Best Case Upside scenario
  Announcement Date TBD       Worst Case Downside scenario
  Expected Close Date TBD       Scenario Comparison Side-by-side KPI view
  Enterprise Value ($mm) $2,500       Probability Weighting Weighted expected values
  Equity Value ($mm) $1,900       Sensitivity Analysis 2-way data tables
  Offer Premium (%) 30.0%       Tornado Chart Variable impact ranking
              Decision Matrix Go / No-Go framework
  SCENARIO SUMMARY (Key Metrics)   Error Check Model integrity checks
  Metric Worst Case Base Case Best Case        
  10-Yr IRR -14.0% -4.5% 7.3%     DECISION SNAPSHOT
  NPV ($mm) ($1,709) ($14) $3,823     Probability-Weighted NPV: $521
  Payback Period (Yrs) >10 >10 7.332915057     Decision Matrix Score: 3.34
  MOIC 0.37x 0.75x 1.51x     Recommendation: CONDITIONAL GO
  EV/EBITDA Exit 7.0x 9.0x 12.0x        
  Accretion / (Dilution) Yr 1 -98.3% -95.6% -90.8%        
  Synergy NPV ($mm) ($80) ($5) $75        
  Prob. Weighted NPV ($mm) $521 $521 $521        
                 
  Note: This model contains sample / placeholder data. All blue-font values are user-editable inputs in the Assumptions sheet. Green-font values are cross-sheet formula links. Update Assumptions to populate the full model.