| ← Back to Cover | |||||||
| MODEL INTEGRITY CHECKS | |||||||
| Automated validation of key model assumptions, formulas, and cross-references | |||||||
| ASSUMPTION CHECKS | MODEL & CALCULATION CHECKS | ||||||
| Check Description | Result | Status | Check Description | Result | Status | ||
| Probability weights sum to 100% | 100.0% | PASS | Base Case Revenue Year 0 > 0 | $850 | PASS | ||
| Cash + Stock = 100% (Worst) | 100.0% | PASS | Base Case NPV calculated | ($14) | PASS | ||
| Cash + Stock = 100% (Base) | 100.0% | PASS | Best Case NPV > Base NPV | Consistent | PASS | ||
| Cash + Stock = 100% (Best) | 100.0% | PASS | Base Case NPV > Worst NPV | Consistent | PASS | ||
| Equity Value > 0 (all scenarios) | $1,650 | PASS | IRR Base between -50% and 100% | -4.5% | PASS | ||
| WACC > 0 (all scenarios) | 8.0% | PASS | Prob-Weighted NPV computed | $521 | PASS | ||
| Tax Rate between 0-50% | 25.0% | PASS | Decision Matrix score computed | 3.34 | PASS | ||
| Decision Matrix weights = 100% | 1 | PASS | All Sensitivity Tables populated | -581.2846558 | PASS | ||
| All scores between 1-5 | Valid | PASS | |||||
| Worst EV > Best EV (conservative) | Correct | PASS | |||||
| OVERALL MODEL STATUS | |||||||
| Total Checks: | 18 | Passed: | 18 | Status: | ALL CHECKS PASSED | ||
| Note: Error checks run automatically when the model recalculates. PASS = within expected bounds. FAIL = requires attention. WARNING = unusual but may be intentional. Review all warnings before finalizing. | |||||||