sensitivity analysis
Sensitivity analysis is testing what happens to your numbers if one thing changes, like fuel price, exchange rate, or interest rate, before it actually changes.
In plain English
Uche sells rice and beans in bulk from a warehouse in Onitsha, and every December she sits with her exercise book and asks herself a question that has nothing to do with December yet. What happens to my profit if the dollar rate jumps by ₦50 before my next container arrives? She is not being pessimistic. She is doing sensitivity analysis, even though nobody taught her that name for it.
Sensitivity analysis simply means changing one assumption at a time in your financial plan to see how much your result wobbles. You take your budget, your business case, or your investment forecast, and you ask, what if this single number moved up or down, while everything else stayed the same. It shows you which assumptions actually matter and which ones you can relax about.
A company in Lagos planning to build a new factory might run the numbers assuming diesel stays at today's price, then run them again assuming diesel rises by 30 percent. If the whole project only makes sense at the current diesel price, that project is fragile, and the board needs to know that before signing any cheque, not after.
In the UK, a Nigerian nurse remitting money home every month might do her own calm version of this. She checks what her transfer is worth if the pound to naira rate weakens by 10 percent, so she knows in advance whether her mother's school fee plan still holds or needs a backup.
Banks and investors love this tool because life rarely follows the neat single forecast in a spreadsheet. Interest rates move, customers pay late, exchange rates swing. Sensitivity analysis does not predict the future. It simply tells you where your plan is strong and where it is standing on one leg.
A property developer projects a rental block will earn ₦18,000,000 a year at 90 percent occupancy. Sensitivity analysis tests the same model at 75 percent occupancy and finds annual income drops to ₦15,000,000, still covering the loan repayment, so the project survives a bad year without collapsing.
Questions people ask
Is sensitivity analysis the same as risk analysis?
They are cousins. Sensitivity analysis changes one assumption at a time to see its effect, while broader risk analysis looks at many uncertainties together, sometimes using probabilities. Sensitivity analysis is usually the simpler first step.
Do I need special software to do this?
No. A basic spreadsheet is enough. You just duplicate your forecast, change one input like sales price or exchange rate, and compare the new result with the original. Excel or Google Sheets handles this easily.
Which variables should I test first?
Start with the ones that are both uncertain and large, like exchange rate, fuel or raw material cost, and interest rate on any loan. Testing a variable that barely moves your result is not worth the time.
Last reviewed