Skip to content
Formula Audit XL
Blog

Review a financial model you didn't build

Open it safely, map it, trace the outputs, test it and log what you find, before the audit checklist even starts.

By Formula Audit XL Updated 7 min read
  • Model review
  • Due diligence
On this page

Most models you review were built by someone else. A client sends a budget, a seller puts a model in the data room, a colleague leaves and their forecast lands on your desk. The usual audit checklist assumes you already know where the inputs are and how the logic flows. With an unfamiliar model you do not, so the review starts with orientation.

For the mechanical checks themselves, the financial model audit guide goes step by step.

Before you open the file

Five questions to the builder save more time than any shortcut:

  • What decision does the model support, and which output matters most?
  • Which sheets hold the inputs, and which hold the outputs?
  • Is any circular logic intentional, for example interest on an average debt balance?
  • Does the model pull data from other workbooks?
  • Are there known issues or unfinished parts?

If you cannot ask, write down your own answers as you go. In a due diligence review, also confirm that you have the live file with formulas. A PDF or a values-only paste cannot be reviewed, only read.

Open it safely

Work on a copy, and keep the original untouched as your reference.

If the model links to other workbooks, Excel shows a security warning bar saying that automatic update of links has been disabled. Leave it disabled for now. Open Data → Edit Links (called Workbook Links in recent Microsoft 365 builds) to see which files the model expects. If you update the links before you know where they point, the numbers can change to values from files you never saw. The external links guide also covers the links that this dialog does not list.

Next, check the calculation mode under Formulas → Calculation Options. A model saved in Manual mode can show stale results, and the status bar then shows Calculate. Excel takes the calculation mode from the first workbook you open in a session, so the same model can behave differently on your machine and on the builder’s. Set it to Automatic, or press F9 and note whether any number moves.

If the model is circular on purpose, check that iterative calculation is on and that the results converge. The iterative calculation guide explains the settings.

Map the workbook

Before you read a single formula, find out what the file contains.

Hidden sheets. Right-click any sheet tab and choose Unhide. In Microsoft 365 you can select several sheets in that dialog at once. Very hidden sheets do not appear there. To find them, press Alt + F11, select each sheet in the Project Explorer, and look at the Visible property in the Properties window (F4). A value of 2 - xlSheetVeryHidden can only be set through VBA or the Properties window, so someone hid that sheet on purpose. Our article on finding hidden sheets in Excel lists every sheet and its state in one pass.

Hidden rows, columns and values. Look for gaps in the row numbers and column letters, and for outline buttons at the edge of the grid. Press Ctrl + End on each sheet to see where the used range really ends, because stray data sometimes sits hundreds of rows below the visible model. Also watch for cells that look empty but are not, such as white text or the custom number format ;;;.

Defined names. Open the Name Manager with Ctrl + F3. Use Filter → Names with Errors to find broken names, and read the Refers To column for names that point to other workbooks or hold a typed constant.

Formula Audit XL shortens this step. Quick Navigation (Ctrl + Shift + N) lists every sheet, including hidden and very hidden ones, and shows them from one panel. Model Check (Ctrl + Shift + R) writes a scorecard that names the hidden and very hidden sheets and counts errors, circular references, broken links and hardcoded numbers, with a detail table for each sheet.

Find the inputs, calculations and outputs

Many models follow a colour convention: blue font for inputs, black for formulas, green for links to other sheets. Use it as a hint, not as proof. Builders forget to recolour cells, and an overtyped formula keeps its black font.

To see what each cell really is, select a block and use Go To Special (F5, then Special). Constants with Numbers ticked selects the typed values. Formulas selects the calculations. A typed number in the middle of a calculation block is the first thing to note. Our article on finding hardcoded numbers covers this and the harder case of numbers typed inside formulas.

Cell Map (Ctrl + Shift + M) does the same job for a whole sheet in one step. It colours each cell as an input, a unique formula, a copied formula, a link to another sheet or workbook, or a hardcoded number, and it removes the colours in one click.

Follow the key outputs back

Pick the two or three outputs the model exists to produce: the valuation, the covenant headroom, the cash balance at the end of the forecast. Then trace each one back to its inputs.

  • Select the output and press Alt + M, P to draw the precedent arrows. Press it again to go one level further back.
  • Press Ctrl + [ to jump to the direct precedents, including those on another sheet.
  • Use Formulas → Evaluate Formula to step through a long formula one part at a time.
  • Add the key outputs to Formulas → Watch Window, so you see them change while you work on other sheets.

At each level, ask whether the formula refers to the cells it should, and whether the logic matches what the builder told you. The trace precedents guide covers the arrows and their limits across sheets. If you use Formula Audit XL, Explore Precedents (Ctrl + Q) shows the same chain as a tree that follows references across sheets and through named ranges.

Run the mechanical checks

Now the model is familiar enough for the standard checks: circular references, error values, external links, hardcodes and inconsistent formulas. Run them across every sheet, not only the ones you traced. The audit checklist lists the native Excel method for each one.

If the file is confidential and you cannot install software on the machine, the free browser tools cover circular references, external links, hardcodes, inconsistent formulas and broken names without uploading the file. They read the workbook in your browser, so it never leaves your computer.

Test it

A model that passes every check can still give wrong answers. Change the inputs and watch what happens.

  • Set the growth rate to zero. Revenue should stay flat.
  • Double the volume. Variable costs should double and fixed costs should not.
  • Check that the balance sheet balances in every period, and that the cash flow statement ends at the cash on the balance sheet.
  • Put an extreme value into one input and see whether anything breaks.

Each test that gives an unexpected result goes in the log, with the input you changed and what you saw.

Keep an issue log

Write the findings down as you go, in a separate file or on a new sheet. One row per issue:

SheetCellFindingSeverityQuestion for the builder
ForecastH24FY2028 revenue typed as 1,450, not a formulaHighIs this an intentional override?
DebtD12Interest uses the opening balance, the memorandum says averageMediumWhich basis is correct?

The log turns the review into a record. The builder can answer each question, you can confirm each fix, and the next reviewer starts from your notes and not from zero. To close the review with a sign-off, follow the Excel model review checklist.

In a due diligence review

In a transaction, the time is short and the stakes sit in a few numbers. Spend the orientation time on the sheets that move the price: the EBITDA adjustments, the net debt bridge and the working capital calculation. Check that the figures in the information memorandum come from the version of the model you received. A difference between the two goes in the log as a finding of its own.

The mechanical checks are the part a tool does faster than a person. Formula Audit XL runs them across every sheet, and Model Check writes the result to a _ModelCheck sheet you can attach to your review file. To try it on the next model you inherit, download Formula Audit XL and start the 7-day free trial.

Frequently asked questions

How do you review a financial model built by someone else?

Ask the builder what the model is for and which sheets hold the inputs and outputs. Open a copy with link updates disabled and check the calculation mode. Unhide every sheet and list the defined names. Trace the key outputs back to their inputs, run the mechanical checks, then change inputs and confirm the outputs move as expected. Record every finding in an issue log with the cell address and a question for the builder.

How long does a review of an unfamiliar model take?

For a model of ten to fifteen sheets, a careful manual review takes an experienced analyst two to four hours, plus the time to learn the structure when the model is new to you. Hidden sheets, external links and circular logic add to both. Automated checks shorten the mechanical part, but the time spent understanding the structure stays.

What should you ask for when you receive a model in due diligence?

Ask for the live Excel file with formulas, not a PDF or a values-only copy. Ask which version the numbers in the information memorandum come from, which sheets hold the adjustments to EBITDA, net debt and working capital, and whether the model depends on external files or circular logic. Each answer saves time in the review.

Stop eyeballing models. Start auditing them.

For Microsoft Excel on Windows, Mac and the web · No data leaves your machine