Skip to content

Noch nicht auf Deutsch verfügbar. Alles auf Deutsch ansehen

Stockertim Dictionary · Technology

Data table

Also called sensitivity table, two-way data table, one-way data table

In short

A spreadsheet tool that recalculates a model for a range of values of one or two inputs and shows the results as a grid.

  • Advanced
  • Technology
  • Checked

In detail

A data table answers the question of how an output changes when an input changes, without copying the model many times. The user lists values for one input down a column, and optionally values for a second input across a row, and points the table at the output cell. The spreadsheet then reruns the whole model for every value or pair of values and fills the grid with the results.

Valuation models use two-way tables constantly. A discounted cash flow value might be shown for discount rates from 10% to 14% across the top and long-term growth rates from 1% to 4% down the side, so readers see the range of outcomes and which assumption drives them. Budget models do the same for price and volume, and loan models for interest rate and term.

Data tables recalculate every time the sheet changes, which can slow large workbooks, so many modellers switch them to manual calculation. They work only with inputs on the same sheet in many programs, and the results are live formulas that cannot be edited directly. A table shows sensitivity to one or two inputs at a time; for many inputs at once, scenario switches and tornado charts give a broader view.

Worked example

A simple model values a business at next year's cash flow of ₦10bn divided by the discount rate minus growth of 2%. A data table tries discount rates of 10% and 12%.

  1. At 10%: 10 / (10% − 2%) = 125
  2. At 12%: 10 / (12% − 2%) = 100

Two points on the discount rate move the value from ₦125bn to ₦100bn, which the grid makes plain.

In practice

Bankers' valuation reports and equity research notes routinely include sensitivity grids, and HM Treasury's AQuA Book on quality analysis recommends testing how results depend on key assumptions.

Watch out

  • A grid of outcomes is not a set of probabilities; extreme corners may be very unlikely.
  • Large tables can make a workbook slow; check the calculation setting before trusting figures.

Learn it properly

More lessons about data table

Official sources

Facts last checked on 4 November 2026.

Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.

English