| 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. | ||||||||