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%.
- At 10%: 10 / (10% − 2%) = 125
- 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
- Scenarios and sensitivities in a model15 min lesson Free course: Financial modelling
- Scenarios and sensitivity in a research note15 min lesson Free course: Writing a research note
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.