← The FP&A libraryPractice · 4 questions →
Budgeting & planning
Sensitivity analysis
Changing one assumption at a time to see how much the output moves — which drivers the result is most sensitive to.
Owned by: Senior analystTest band: Senior analyst
In practice
Rank drivers by how much a 10% change moves profit or cash. The top two are what to forecast carefully and monitor weekly.
The kind of thing the test asks
- A sensitivity table shows a 10% change in price moves profit 35%, while a 10% change in volume moves it 12%. The forecast should…
More in budgeting & planning
Free · no account · no card
Get your 2027 budget built from your QuickBooks — P&L, balance sheet and cash flow, in Excel.
Knowing the method is half of it. Wauvel runs it on your QuickBooks, every day.
$99/mo, everything included. Free for 14 days, no card.