2 Variable Sensitivity Tables (Data Table in Excel)

This is a common analysis used in finance in which two variables are sensitized on the x and y axises, respectively, to produce a third variable that populates the 2x2 table. In excel, the process is a bit unwieldy as you have to make sure all referenced cells are on the same tab and often have to manually hide rows/columns to produce a cleanly formatted table. Given Causal already identifies all variables, my hope is that this type of analysis can be made as simple as a drag and drop.

A common use case I’ve run into: how does total valuation change when you sensitize revenue growth rate and revenue multiple?

Thanks!

2 Likes

Hey Travis :wave: thanks for the suggestion! Totally get the utility of multi-variable sensitivity tables.