skinny.

Latest / ModeLoop: Financial Modelling in Excel

P2E15: Data Tables in Excel for Sensitivity Analysis - Test Hundreds of Scenarios in One Grid

Data Tables in Excel for sensitivity analysis let you test hundreds of scenarios in one grid without touching your base case. We build one-variable and two-variable Data Tables for equity IRR, minimum DSCR and NPV, using project finance, DCF, M&A and FP&A examples.

In this episode:

What a Data Table does and why the base case never changes

Sensitivity flex cells such as Capex × (1 + Flex%)

One-variable and two-variable tables via Data › What-If Analysis › Data Table

Classic views: DSCR vs P90 and opex, IRR vs capex and COD delay, EV vs WACC and growth

The traps: slow recalcs, macro-broken…

Log in to save or queue this episode.

The skinny

The skinny isn't ready yet — notes appear once the transcript is processed.