Sensitivity Table Generator
Build two-variable sensitivity tables and tornado charts for any financial model. Heatmap output, exportable to CSV.
Presets
Grid size
g ↓ × wacc →
| 0.070 | 0.080 | 0.090 | 0.100 | 0.110 | 0.120 | 0.130 | |
|---|---|---|---|---|---|---|---|
| 0.015 | 1845 | 1562 | 1353 | 1194 | 1068 | 966.67 | 882.61 |
| 0.020 | 2040 | 1700 | 1457 | 1275 | 1133 | 1020 | 927.27 |
| 0.025 | 2278 | 1864 | 1577 | 1367 | 1206 | 1079 | 976.19 |
| 0.030 | 2575 | 2060 | 1717 | 1471 | 1288 | 1144 | 1030 |
| 0.035 | 2957 | 2300 | 1882 | 1592 | 1380 | 1218 | 1089 |
| 0.040 | 3467 | 2600 | 2080 | 1733 | 1486 | 1300 | 1156 |
| 0.045 | 4180 | 2986 | 2322 | 1900 | 1608 | 1393 | 1229 |
Your numbers never leave your browser. Tentt has no backend, no database, and no record of anything you type into this calculator — the math runs entirely on your device. Output is for illustrative modelling only and does not constitute investment, tax, legal, or accounting advice; verify any number you intend to act on.
What is a sensitivity table?
A sensitivity table — also called a two-way data table — is the most useful single exhibit any financial model produces. It shows what happens to the model's output as two underlying assumptions vary across a plausible range. Where a single point estimate gives one answer, a sensitivity table shows the full surface of answers across the assumption space, which is the difference between knowing what the model produces under management's case and understanding what it produces under every reasonable case.
The financial sensitivity calculator space has a strange SERP problem: the keyword "sensitivity calculator" is dominated entirely by medical statistics tools (sensitivity and specificity for diagnostic tests), because the medical use of the term predates the financial use by about a century in the scientific literature. Google is structurally unable to disambiguate the two, which leaves the financial side of the keyword almost completely unserved by free web tools. Wall Street Prep and CFI publish Excel tutorials for building data tables, but no one has shipped an interactive web version. This page is that tool.
The formula language
The calculator accepts a small, safe expression grammar that covers every common finance formula without giving an attacker a foothold to run arbitrary code in your browser. The supported tokens are:
Supported syntax
numbers · identifiers (FCF, wacc, growth, rate, etc.) · + − × ÷ · ^ exponent · parentheses
Variables come from two sources. The two "sweep variables" — the X axis and the Y axis of the table — vary across their respective ranges. Every other variable in the formula must be defined as a constant in the "constant variables" textarea, one per line, in the format name = value. For example, a DCF terminal value formula like (FCF * (1 + g)) / (wacc - g) needs FCF defined as a constant while g and wacc sweep across the X and Y axes.
Worked example
Worked example
A DCF model produces a terminal value of $1,250 per share at a 10% WACC and a 3% terminal growth rate. The analyst wants to know how sensitive that value is to those two assumptions across a plausible range: WACC from 8% to 12%, growth from 2% to 4%.
Setting FCF = 100 (the terminal-year unlevered free cash flow), formula (FCF * (1 + g)) / (wacc - g), sweep g from 0.020 to 0.040 in 0.005 steps and wacc from 0.08 to 0.12 in 0.01 steps, the calculator returns a 5×5 heatmap. The cell at the base case (wacc=0.10, g=0.03) reads $1,471. The worst-case corner (wacc=0.12, g=0.02) reads $1,020. The best-case corner (wacc=0.08, g=0.04) reads $2,600.
The 2.5× spread between worst and best case immediately tells you that the terminal value is highly sensitive to both assumptions, and that defending a single point estimate is not a meaningful exercise — the band is what matters. This is exactly the insight a sensitivity table is supposed to produce.
Common use cases
The three most common 2D sensitivity tables in finance are: WACC × terminal growth in a DCF model (showing how sensitive valuation is to discount rate and long-run growth assumptions), entry multiple × exit multiple in an LBO model (showing how sensitive equity returns are to purchase price and exit assumptions), and synergies × premium in an accretion / dilution model (showing how the EPS impact of a deal depends on the assumed cost synergies and the offer premium). Beyond those three, the same machinery handles bond pricing (rate × maturity), real estate underwriting (cap rate × NOI), debt sizing (DSCR × interest rate), and any other two-variable problem in finance.
Frequently asked questions
- What is a sensitivity analysis calculator?
- A sensitivity analysis calculator computes the output of a financial formula across a 2D grid of input variations, showing how the output changes as two underlying assumptions change at the same time. The classic exhibit it produces is a colour-coded data table — also called a tornado chart in the 1D version — where one variable runs along the rows, another runs along the columns, and the cells display the resulting calculated value. It is the single most-used analytical exhibit in any DCF, LBO, or M&A model.
- Why does Google show medical sensitivity calculators when I search for this?
- Because the term 'sensitivity' has two unrelated meanings. In medical statistics, sensitivity is the true-positive rate of a diagnostic test (the complement of false negatives). In finance, sensitivity analysis means stress-testing a model's output across a range of input values. The medical SERP currently dominates the keyword 'sensitivity calculator', which leaves the financial use case structurally underserved — exactly the gap this tool fills.
- How does the formula parser work?
- It accepts a small safe expression grammar: numbers, variable names, the four basic arithmetic operators (+ − × ÷), parentheses, and the ^ exponent operator. There is no support for function calls, no support for arbitrary JavaScript, and no support for string operations — by design. Running arbitrary user-typed code in a browser is a security vulnerability even on a fully client-side page, so the parser is hand-written and limited to what is needed for finance formulas. That is enough to express a DCF terminal value, an IRR closed form, a bond price formula, or any of the common Excel-style finance equations.
- What is a tornado chart?
- A tornado chart is the 1D version of a sensitivity table — instead of varying two inputs at once, it shows how the output changes as you vary each input independently across its plausible range, with the input that drives the most variance at the top and the input that drives the least at the bottom. The shape resembles a tornado, hence the name. The calculator above produces the 2D version (a heatmap data table), which is more useful when you want to see joint sensitivity to two inputs that interact — e.g. WACC × terminal growth in a DCF, or entry multiple × exit multiple in an LBO.
- Can I export the table to Excel?
- Yes — there is an Export CSV button above the heatmap that downloads the current grid as a CSV file. The CSV preserves the row and column labels and the raw computed values without any formatting, so it can be pasted into Excel or Google Sheets and reformatted with conditional formatting in seconds.
- What presets are included?
- Three presets ship with the calculator: a DCF terminal value sensitivity (WACC × growth), an LBO IRR sensitivity (entry × exit multiple), and a bond price sensitivity (rate × maturity). Each preset loads the matching formula, the constant variables, and a reasonable starting range. You can edit any of them — they are starting points, not lock-ins.