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…
The skinny
The skinny isn't ready yet — notes appear once the transcript is processed.