The associate on the model has already been up 30 hours. The MD is about to open the deck. Somewhere in row 47 of the debt schedule, a hardcoded IRR override is quietly breaking your sensitivity table. BaselineSnap finds it before Monday morning.
| Sheet | Cell | Issue | Details | Severity |
|---|---|---|---|---|
| P&L | H14 | Error value #DIV/0! | Critical | |
| Assumptions | C7 | Hardcoded number in formula | Warning | |
| Model | M31 | Inconsistent formula (column) | Warning | |
| (Workbook) | OldRev | Dangling named range | Critical | |
| Inputs | B12 | Volatile function OFFSET | Warning | |
| P&L | K44 | Static value in formula row | Warning | |
| Balance | (entire) | Very-hidden worksheet | Critical |
One hardcoded IRR in a return calc turns your sensitivity table into fiction. BaselineSnap flags every literal embedded in a formula.
Dangling named ranges and formula drift across the debt schedule caught in one pass — before your MD spots it.
Sheets you meant to delete last diligence still calculating quietly? Flagged as xlSheetHidden / xlSheetVeryHidden with distinct severities.
The functions that make your model recalc for 12 seconds every time you press F9. Every use surfaced.
“We ran it on our latest sponsor waterfall the morning of IC. Caught a hardcoded IRR override that would have broken the sensitivity table on the return summary. Ten seconds. That's the whole product.”
Free to start, ten seconds to run, zero data ever leaves your machine. The .bas download runs the full audit and baseline pair today.