mittafinBrowse library

← Calculator library

• Calculator worksheet

Sensitivity Analysis Calculator

Stress-test an output by sweeping two inputs across a two-dimensional grid.

Inputs

Live

Formula Preset

?

The calculation template used to generate the sensitivity table.

X Axis (columns)

X Min

?

One assumption range used across the rows or columns of the sensitivity table.

X Max

?

One assumption range used across the rows or columns of the sensitivity table.

Y Axis (rows)

Y Min

?

One assumption range used across the rows or columns of the sensitivity table.

Y Max

?

One assumption range used across the rows or columns of the sensitivity table.

Grid resolution and base inputs

X Steps

?

One assumption range used across the rows or columns of the sensitivity table.

Y Steps

?

One assumption range used across the rows or columns of the sensitivity table.

Variables and terms

X Min

One assumption range used across the rows or columns of the sensitivity table.

X Max

One assumption range used across the rows or columns of the sensitivity table.

Y Min

One assumption range used across the rows or columns of the sensitivity table.

Y Max

One assumption range used across the rows or columns of the sensitivity table.

X Steps

One assumption range used across the rows or columns of the sensitivity table.

Y Steps

One assumption range used across the rows or columns of the sensitivity table.

How to read this calculator

Each cell recalculates the selected preset for one X-axis and Y-axis combination. Read across columns and down rows to compare output range; the tornado chart summarizes which input has the largest effect.

Multiple \ EBITDA	$45M	$47.5M	$50M	$52.5M	$55M
8.00x	360.00	380.00	400.00	420.00	440.00
9.00x	405.00	427.50	450.00	472.50	495.00
10.00x	450.00	475.00	500.00	525.00	550.00
11.00x	495.00	522.50	550.00	577.50	605.00
12.00x	540.00	570.00	600.00	630.00	660.00

Base case output (midpoint of both axes): 500.00

Data view

Methodology