Financial model review glossary

This financial model review glossary defines 25 terms in one sentence each, then adds the context a reviewer needs — what it looks like in a workbook, why it matters in a review and, where it helps, a link to the guide that shows the technique.

Terms A–Z

  • #REF! error — A #REF! error appears when a formula refers to a cell or range that has been deleted or moved, so the reference itself can no longer be resolved.
  • Array formula — An array formula is a formula that returns one or many results from a range, calculated as a set rather than by copying the formula down each row.
  • Audit trail — An audit trail is a record of changes made to a file, and in a spreadsheet it is what lets a reviewer tell a deliberate edit from an accident.
  • Calculation chain — The calculation chain is Excel's record of which cells depend on which, used to decide what to recalculate and in what order when something changes.
  • Circular reference — A circular reference occurs when a formula refers back to its own cell, directly or through a chain, so the calculation cannot resolve without either an iteration setting or a fixed input.
  • Dead cell — A dead cell is a formula whose result is never used by another cell, a chart or an output, so it can be wrong without anyone noticing.
  • Dependent cell — A dependent cell contains a formula that refers to another cell, so a list of dependents answers the question of what breaks if that cell changes.
  • Dynamic array — A dynamic array is a formula whose results spill into as many cells as it needs, so one formula replaces a column of copied formulas.
  • External link — An external link is a reference from one workbook to a cell or a name in another file, so the value depends on a file the reader may not have.
  • Formula auditing — Formula auditing is the set of Excel commands that display relationships between cells, evaluate a formula step by step and locate errors, all grouped on the Formulas tab.
  • Hard-coded value — A hardcode is a number typed directly into a formula or a calculation cell instead of being referenced from an input, which breaks the trail from a result back to its assumption.
  • Implicit intersection — Implicit intersection is the rule that lets a formula written for a single cell quietly pick one value from a range instead of returning an error.
  • Input cell — An input cell is a cell that holds an assumption a person is meant to change, which is why a typed number there is correct and the same number in a calculation block is not.
  • Model risk — Model risk is the possibility that a decision based on a model turns out wrong because the model itself was built incorrectly, misused or fed bad inputs.
  • Named range — A named range is a name that stands in for a cell, a block or a formula, so a reader sees a word where the reference would otherwise be.
  • Precedent cell — A precedent cell is a cell that a formula in another cell refers to, so following precedents is how a reviewer walks a total back to the numbers it depends on.
  • R1C1 notation — R1C1 notation writes a reference as a row and column count relative to the current cell, so R1C1 notation describes the shape of a copied formula rather than a fixed address.
  • Sensitivity table — A sensitivity table recalculates a model's output across a grid of input values, so one cell holds the result for every combination in the grid.
  • Spill range — A spill range is the block of cells that a single dynamic array formula fills with its results, and it is the range Excel reserves so the output has somewhere to land.
  • Structured reference — A structured reference names a table and a column instead of a range, so the reference grows and shrinks with the table rather than staying fixed.
  • Three-statement model — A three-statement model is a financial model where the income statement, the balance sheet and the cash flow statement are built from the same drivers and tie together.
  • Tracer arrow — A tracer arrow is the line drawn by Trace Precedents or Trace Dependents to show the relationship between a formula and the cells it reads or feeds.
  • Version drift — Version drift is the divergence between two copies of a workbook that were once the same, usually because one copy kept changing while the other stayed in circulation.
  • Volatile function — A volatile function is one Excel recalculates whenever anything in the workbook changes, because Excel cannot tell whether its inputs have changed.
  • Workbook link — A workbook link is a stored reference from one Excel file to a cell or name in another, and it depends on the other file staying where it was when the link was created.

Looking for the how-to?

The guides walk through the native Excel method for each of these terms, step by step.