Model and deck auditor

Check the model, then every number in the deck.

The mistakes that cost the most in a review are small: a figure on slide 12 from last week’s version, a margin that no longer recomputes, £1.3m where the model says £1,320m. Add your Excel model and, if you have one, the deck or memo that quotes it. You get every figure matched to the cell that produces it, every formula checked, and a list of what to fix, most serious first.

Your files are read in this browser and never leave this device: nothing is uploaded, stored or sent anywhere, so a live deal or a confidential case study is safe to check. Nothing in either file is changed; every correction is a suggestion for you to make.

Read on this device. Your files never leave it.

What it checks

Fixed rules and arithmetic, the same answer every time. Each finding is marked must fix, review or note.

Deck against model
Every figure in the deck or document matched to the cell that produces it, by its label and its value at the precision shown, across £, $ and €, thousands, millions and billions, percentages, multiples and basis points. Figures that disagree, figures with no source, and one line quoted two ways.
Errors and links
Cells holding #REF!, #DIV/0!, #N/A, #VALUE! or #NAME?, traced to the cell that starts them; formulas that lost a reference; links to other workbooks.
Hardcodes
A number typed inside a formula, and a typed number sitting among the formulas of a calculated row, where it will not move when the inputs do.
Consistency
A formula that breaks the pattern of the row it sits in, circular references, saved values that no longer recalculate, and check rows that do not read zero.
The finance
Revenue builds, EBITDA against operating profit and D&A, margins and growth recomputed, the balance sheet, cash and ARR roll-forwards, the bridge from enterprise value to equity value, multiples, and IRR against the money multiple and hold.
A report to work from
Each finding with where it is, what was expected and found, how serious it is, and the correction to consider. Saved as a self-contained page or a CSV.

What it cannot do

  • It reads the conventions most models follow: a label in the first columns, the unit beside it, a header row of years. A model laid out its own way still gets its formula checks; the matching and the finance checks find less to work on, and the report says which checks did not run.
  • A finance check runs only when the labels leave no doubt which rows it needs. It never guesses.
  • It cannot know intent. A figure from another source, a deliberate override or a different case reads as a finding to look at, not a mistake.
  • Charts drawn as pictures and scanned PDFs have no text to read. Speaker notes are not read.
  • A handful of spreadsheet functions (XLOOKUP, OFFSET and other lookups) cannot be recalculated here; their saved values are used as they are, and the report says how many.

Build it right the first time

The Models library has worked Excel models with every check row at zero to learn the conventions from, and Deck Studio writes a deck storyline first and checks each title against its figures.