A financial forecast tells you what happens if your assumptions are achieved.
A sensitivity analysis tells you what happens when they are not.
That distinction matters when a business plan reaches a bank, investor or development finance institution. A funder needs to see not only that the base case is profitable. They need to understand how dependent profitability, cash flow and repayment capacity are on the assumptions underneath that base case.
If revenue falls 15.0%, does the business remain cash-positive? If gross margin contracts by five percentage points, can it still service debt? What happens if customers take 60 days rather than 30 days to pay? How far can utilisation fall before the project reaches break-even?
A properly constructed sensitivity analysis answers those questions before the funder has to ask them.
Quick answer: Sensitivity analysis is a financial modelling technique that measures how changes in selected assumptions affect a model’s outputs. It identifies which variables have the greatest influence on outcomes such as EBITDA, cash flow, break-even, DSCR, IRR or NPV, helping management and funders understand where financial risk is concentrated.
Microsoft describes what-if analysis as changing values in worksheet cells to examine how those changes affect the results of formulas. Excel provides Scenarios, Goal Seek and Data Tables for this purpose, with Data Tables specifically designed to test one or two variables across multiple values.
That Excel functionality is the tool. Sensitivity analysis is the financial thinking applied through it.
Key Takeaways
- Sensitivity analysis shows how changes in individual financial assumptions affect important outputs such as EBITDA, cash flow, break-even, DSCR, IRR and NPV.
- Sensitivity analysis, scenario analysis and stress testing are not the same thing: sensitivity analysis isolates key drivers, scenario analysis changes several related assumptions together, and stress testing examines where the financial model begins to fail.
- For a business plan for funding, the most useful sensitivity tests normally focus on revenue, selling prices, margins, operating costs, working capital, CAPEX, interest rates, project timing and repayment capacity.
- A strong sensitivity analysis does more than rank financial risks. It identifies the breakpoint at which cash becomes negative, debt-service capacity weakens, additional funding is required or investment returns fall below an acceptable level.
- Banks, DFIs and investors do not expect forecasts to be perfect. A credible financial model shows which assumptions matter most, how much downside the business can absorb and what management will do if those risks begin to materialise.
What is Sensitivity Analysis?
Sensitivity analysis measures the effect that changing an input assumption has on one or more outputs of a financial model.
Suppose a business plan assumes:
| Assumption | Base Case |
|---|---|
| Selling price | R1,000 per unit |
| Annual sales volume | 10,000 units |
| Variable cost | R600 per unit |
| Fixed operating costs | R2,500,000 |
| Base EBITDA | R1,500,000 |
A sensitivity analysis can change one assumption while holding the others constant.
If selling price falls by 10.0%, EBITDA falls from R1,500,000 to R500,000.
If volume falls by 20.0%, EBITDA falls to R700,000.
If variable cost rises by 10.0%, EBITDA falls to R900,000.
That immediately tells management something the base-case forecast does not: the model is more sensitive to selling price than to the other tested assumptions over those ranges.
Sensitivity analysis does not predict that selling prices will fall by 10.0%. It shows what the financial consequence would be if they did.
That is its real purpose.
Why Sensitivity Analysis Matters in a Business Plan
A business plan contains assumptions everywhere.
Revenue forecasts assume customer demand. Gross margin assumes pricing and input costs. Payroll assumes headcount and salary levels. Working capital assumes debtor, creditor and inventory days. Funding models assume interest rates, repayment terms, capital expenditure and the timing of operations.
The financial statements are the result of these assumptions.
Sensitivity analysis reverses the perspective. It asks which assumptions are doing the most work.
For management, that identifies what needs the closest operational control.
For a funder, it exposes how much margin for error exists between the base case and financial distress.
This is particularly important because a profitable Income Statement does not necessarily mean a resilient business. A company can remain profitable while running out of cash because customers pay more slowly than forecast. A project can show a positive NPV while its debt service coverage becomes unacceptable in a single critical year. A high-growth forecast can create a larger funding gap because working capital expands faster than operating cash flow.
Sensitivity analysis brings those weaknesses into view.
Why Sensitivity Analysis Matters to Banks, DFIs and Investors
Not every funder publishes a checklist that includes the phrase “sensitivity analysis required”.
What they do require is more fundamental.
The IDC requires detailed financial forecasts with assumptions, business-plan support for revenue assumptions and evidence that projects are financially and operationally sound. Its guidance also emphasises sustainable cash flows and realistic, evidence-based projections.
SEDFA’s published eligibility criteria state that forecast cash flow must demonstrate the applicant’s ability to repay the proposed facility.
Business Partners Limited similarly identifies cash-flow viability and the ability to explain how and when funding will be repaid as core parts of funding preparation, supported by detailed financial forecasts and evidence that the business can service its obligations.
At the international development-finance level, IFC’s appraisal process assesses whether an investment is financially and economically sound and examines the project’s risks and opportunities before an investment decision is made.
Sensitivity analysis fits directly into that due-diligence logic.
A funder looking at a financial model is effectively asking:
| Funder Question | Relevant Sensitivity Test |
|---|---|
| How dependent is revenue on optimistic sales assumptions? | Volume / revenue sensitivity |
| How much pricing power does the business really have? | Selling-price sensitivity |
| What happens if input costs rise? | Gross-margin / cost sensitivity |
| Can the company survive slower collections? | Debtor-days sensitivity |
| Is the funding amount sufficient? | Working-capital / CAPEX sensitivity |
| Can the debt still be serviced? | DSCR / interest-rate sensitivity |
| How exposed is the project to implementation delays? | Start-date / ramp-up sensitivity |
| What destroys investment value fastest? | IRR / NPV sensitivity |
A good model does not try to convince a credit analyst that nothing will go wrong.
It shows what can go wrong, quantifies the effect and demonstrates what management can do about it.
Sensitivity Analysis vs. What-If Analysis vs. Scenario Analysis vs. Stress Testing
These terms overlap, but they should not be treated as interchangeable.
| Method | What Changes? | Main Question | Typical Use |
|---|---|---|---|
| Sensitivity Analysis | Usually one input at a time, sometimes two | Which assumptions affect the result most? | Identify financial drivers and vulnerabilities |
| What-If Analysis | General umbrella for changing inputs and observing results | What happens if this changes? | Excel-based testing |
| Scenario Analysis | Several related assumptions simultaneously | What does a coherent alternative future look like? | Base, downside, severe downside, upside cases |
| Stress Testing | Severe or extreme adverse assumptions | Where does the model fail? | Liquidity, debt capacity, covenant and survival testing |
| Monte Carlo Analysis | Many inputs sampled repeatedly from distributions | What range and distribution of outcomes could occur? | Complex or probabilistic models |
Microsoft’s Excel terminology supports this distinction. Its What-If Analysis tools include Data Tables for one- or two-variable testing and Scenario Manager for changing groups of assumptions.
What is Scenario Analysis in Business Planning?
Scenario analysis changes a coherent group of assumptions simultaneously to model an alternative business environment.
A downside scenario might combine:
- 15.0% lower sales volume;
- 5.0% lower selling prices;
- 8.0% higher input costs;
- 15 additional debtor days; and
- a three-month delay in operational ramp-up.
That is fundamentally different from changing sales volume alone.
Scenario analysis answers: “What happens to the business under this set of conditions?”
Sensitivity analysis answers: “Which assumption matters most?”
The two techniques work best together.
A Worked Example: Sensitivity Analysis in a Funding Model
Consider a simplified manufacturing expansion.
The base case assumes:
| Financial Driver | Base Case |
|---|---|
| Units Sold | 10,000 |
| Selling Price | R1,000 |
| Revenue | R10,000,000 |
| Variable Cost per Unit | R600 |
| Variable Costs | R6,000,000 |
| Fixed Costs | R2,500,000 |
| EBITDA | R1,500,000 |
Now test four assumptions individually.
| Sensitivity | Revised EBITDA | Change from Base |
|---|---|---|
| Base Case | R1,500,000 | – |
| Selling Price -10.0% | R500,000 | -66.7% |
| Sales Volume -20.0% | R700,000 | -53.3% |
| Variable Cost +10.0% | R900,000 | -40.0% |
| Fixed Costs +10.0% | R1,250,000 | -16.7% |
The conclusion is immediate.
The selling price is the most sensitive driver tested.
That means price discipline deserves more management attention than a similar percentage movement in fixed overhead.
It also changes the risk narrative in the business plan. Management should now explain how pricing is protected through contracts, customer segmentation, value proposition, cost-plus pricing, minimum margins or other relevant controls.
The sensitivity analysis has therefore done more than produce a spreadsheet table.
It has identified the most significant risk and linked it to management action.
The Same Business Under a Downside Scenario
Now combine several adverse assumptions instead of changing only one:
| Assumption | Base | Downside Scenario |
|---|---|---|
| Selling Price | R1,000 | R950 |
| Sales Volume | 10,000 | 8,500 |
| Variable Cost per Unit | R600 | R648 |
| Fixed Costs | R2,500,000 | R2,500,000 |
Under this downside case:
- revenue falls to R8,075,000;
- variable costs reach R5,508,000; and
- EBITDA falls to approximately R67,000.
The individual sensitivity tests showed which assumptions mattered most.
The scenario analysis shows what happens when several plausible adverse movements occur together.
That distinction is critical in a serious financial model.
One-Way Sensitivity Analysis
A one-way sensitivity analysis changes one input while holding all other assumptions at their base-case values.
It is the most useful starting point for most business plans because it makes cause-and-effect easy to isolate.
Typical one-way tests include:
| Input Tested | Possible Output |
|---|---|
| Sales Volume | Revenue, EBITDA, cash balance |
| Selling Price | Gross profit, EBITDA |
| Cost of Sales | Gross margin, net profit |
| Payroll | EBITDA, break-even |
| Debtor Days | Minimum cash balance |
| Inventory Days | Working-capital requirement |
| Interest Rate | Interest cover, DSCR |
| CAPEX | Funding requirement, IRR, NPV |
| Capacity Utilisation | Revenue, break-even |
| Project Start Date | Cash runway, funding gap |
The most useful output is not always net profit.
For debt funding, minimum cash balance and DSCR may matter more.
For an equity investor, IRR and NPV may matter more.
For an early-stage company, the key output may simply be how many months of cash runway remain.
The sensitivity output should match the decision the model is meant to support.
How to Run One-Way Sensitivity Analysis in Excel
Microsoft Excel’s Data Table function provides a direct way to calculate multiple outputs using different values for one input.
Assume:
| Cell | Input |
|---|---|
| B2 | Selling Price |
| B3 | Units Sold |
| B4 | Variable Cost per Unit |
| B5 | Fixed Costs |
| B6 | EBITDA |
B6 contains:
=(B2*B3)-(B4*B3)-B5
To test selling price:
- Enter the range of selling prices vertically in another area of the worksheet.
- In the cell immediately above the output column, reference the EBITDA output cell.
- Select the sensitivity range.
- Go to Data → What-If Analysis → Data Table.
- Because the test values run vertically, enter B2 as the Column Input Cell.
- Leave the Row Input Cell blank.
- Run the table.
Excel substitutes each test price into cell B2 and automatically calculates the corresponding EBITDA. Microsoft confirms that one-variable Data Tables can test multiple values for one input against one or more formulas.
Why Sensitivity Tables Sometimes Return Zeros or Wrong Answers
The most common problems are structural.
The output reference at the top of the table is missing. The wrong input cell is selected. The output itself contains a hard-coded value. Calculation settings prevent Data Tables from recalculating. Or the base financial model has broken links.
Sensitivity analysis cannot repair a weak model.
It only exposes the behaviour of the model it is given.
Two-Way Sensitivity Analysis
A two-way sensitivity table changes two inputs and calculates the result for every combination.
A common business-planning example is the relationship between selling price and sales volume.
Using the manufacturing example above:
| Units / Price | R900 | R950 | R1,000 | R1,050 | R1,100 |
|---|---|---|---|---|---|
| 8,000 | (R100,000) | R300,000 | R700,000 | R1,100,000 | R1,500,000 |
| 9,000 | R200,000 | R650,000 | R1,100,000 | R1,550,000 | R2,000,000 |
| 10,000 | R500,000 | R1,000,000 | R1,500,000 | R2,000,000 | R2,500,000 |
| 11,000 | R800,000 | R1,350,000 | R1,900,000 | R2,450,000 | R3,000,000 |
| 12,000 | R1,100,000 | R1,700,000 | R2,300,000 | R2,900,000 | R3,500,000 |
The grid immediately identifies the combinations where the business moves into loss.
This is highly useful in funding analysis because a lender can see how far price and volume can deteriorate before EBITDA becomes insufficient.
A two-way table should not, however, be described as modelling correlation. It tests combinations. It does not estimate how likely those combinations are or model the statistical relationship between the two inputs.
Scenario Analysis in Excel
For scenario analysis in Excel, Microsoft’s Scenario Manager allows users to store groups of changing assumptions and switch between them to compare the resulting outputs.
A funding model might contain:
| Scenario | Revenue | Gross Margin | Debtor Days | CAPEX | Interest Rate |
|---|---|---|---|---|---|
| Base | 100.0% | 38.0% | 45 | R20.0m | 11.0% |
| Downside | 85.0% | 34.0% | 60 | R21.5m | 12.5% |
| Severe Downside | 70.0% | 30.0% | 75 | R23.0m | 14.0% |
| Upside | 110.0% | 40.0% | 40 | R20.0m | 10.5% |
The outputs can then compare:
- EBITDA;
- closing cash;
- maximum funding requirement;
- break-even;
- DSCR;
- debt balance;
- IRR; and
- NPV.
This is where scenario analysis becomes far more valuable than simply labelling forecasts “best case” and “worst case”.
Each scenario should contain an internally consistent set of assumptions and an explanation of why those assumptions belong together.
Local vs. Global Sensitivity Analysis
Most business-plan financial models use local sensitivity analysis.
This means changing assumptions around a base case, often one factor at a time.
It is practical, transparent and easy for management, investors and credit analysts to interpret.
It also has limits.
The European Commission’s Joint Research Centre notes that one-factor-at-a-time methods do not capture interactions between inputs and can be inadequate where models are highly non-linear or uncertainty ranges are large. Global sensitivity methods vary inputs across broader ranges and can account for interactions between factors.
For a normal SME business plan, that does not mean one-way sensitivity analysis is wrong.
It means it should be used for what it does well: screening and ranking important business drivers around a credible base case.
Where several variables interact materially, add scenario analysis.
Where uncertainty is complex and probabilistic, consider global analysis or Monte Carlo simulation.
When Monte Carlo Simulation Becomes Useful
Monte Carlo simulation repeatedly samples input parameters from specified probability distributions and produces a distribution of model outcomes rather than a single deterministic answer.
NIST describes Monte Carlo analysis as a probabilistic sensitivity technique in which variables are assigned distributions and repeatedly sampled over many iterations.
For example, instead of saying sales growth is exactly 12.0%, the model might assume that growth follows a defined distribution around a range of plausible outcomes.
After thousands of iterations, the analysis could estimate:
- probability that cash becomes negative;
- probability that IRR falls below the hurdle rate;
- probability that DSCR falls below 1.20x;
- range of likely NPVs; or
- probability that additional funding is required.
That is powerful, but unnecessary for many SME funding applications.
Use additional complexity only when it improves the decision.
What Variables Should You Test in a Business Plan Financial Model?
The right variables depend on the business model.
A retail business may be highly sensitive to customer traffic and gross margin.
A mine may be sensitive to commodity prices, production volumes, recovery rates and operating costs.
A property development may be driven by selling prices, construction costs, timing and interest rates.
A manufacturing expansion may depend on utilisation, selling price, materials and working capital.
The following framework covers the main areas.
| Category | Sensitivity Drivers |
|---|---|
| Revenue | Volume, price, customer conversion, occupancy, utilisation, churn |
| Gross Margin | Raw materials, procurement costs, labour productivity, discounts |
| OPEX | Payroll, rent, utilities, fuel, marketing |
| Working Capital | Debtor days, inventory days, creditor days |
| Funding | Interest rate, moratorium, repayment period, gearing |
| CAPEX | Equipment cost, construction cost, contingency |
| Timing | Launch delays, construction delays, ramp-up |
| Valuation | WACC, terminal growth, exit multiple |
| Project Returns | Revenue, CAPEX, OPEX, timing, financing assumptions |
The key is not to test everything simply because the spreadsheet allows it.
Test the assumptions that can materially change the investment decision.
Which Outputs Should Sensitivity Analysis Measure?
A common weakness in financial models is testing every variable against net profit only.
That is rarely enough.
Different stakeholders care about different outputs.
| Stakeholder | Most Relevant Outputs |
|---|---|
| Commercial Bank | Cash flow, DSCR, interest cover, debt balance |
| DFI | Cash flow, repayment, IRR/NPV, jobs, funding gap |
| Equity Investor | IRR, NPV, EBITDA, exit value |
| Founder | Cash runway, break-even, profitability |
| Project Finance Lender | CFADS, DSCR, LLCR, project IRR |
| Management | EBITDA, cash, working capital, utilisation |
A model can remain profitable and still breach its debt-service requirement.
It can maintain EBITDA even as cash runs out because debtors have increased.
It can show a positive project IRR while requiring more funding than originally requested.
Test the output that could actually cause the investment to fail.
Tornado Charts: Turning Sensitivity Analysis into a Decision Tool
A full workbook may contain dozens of sensitivity tables.
A funder does not need to see all of them in the main business plan.
A tornado chart ranks variables according to the size of their effect on a selected output.
Assume the base EBITDA is R10 million. For each variable, calculate the result at an adverse and favourable assumption, then express each result relative to the base case:
| Driver | Downside Impact | Upside Impact |
|---|---|---|
| Revenue Volume | -R4.0m | +R4.0m |
| Selling Price | -R3.2m | +R3.2m |
| Gross Margin | -R2.5m | +R2.5m |
| Payroll | -R1.1m | +R1.1m |
| Interest Rate | -R0.4m | +R0.4m |
Sort the variables from the largest total range to the smallest.
Create horizontal bars around a zero baseline.
The widest bar appears at the top and the shortest at the bottom, producing the tornado shape.
The value of the chart is not its appearance.
It answers a management question instantly:
Which assumptions can damage the financial case fastest?
Best Practices for Interpreting Sensitivity Analysis Results
Good interpretation matters more than producing more tables.
A useful analysis should identify the variables with the largest financial effect, determine the point at which an important threshold is breached, explain why that variable is sensitive and connect the result to an operating response.
If revenue falling by 12.0% causes DSCR to fall below 1.20x, the important conclusion is not “revenue is sensitive”.
The useful conclusion is:
The model can absorb approximately a 12.0% revenue reduction before debt-service coverage falls below the required threshold. Management must therefore protect sales conversion and maintain a minimum contracted-revenue pipeline sufficient to preserve that buffer.
That is an investor-grade interpretation.
Focus on Breakpoints
Ranking variables is useful.
Finding the breakpoint is better.
Examples include:
- revenue decline before cash becomes negative;
- gross-margin contraction before EBITDA becomes negative;
- debtor days before additional funding is required;
- interest rate before DSCR breaches a lender threshold;
- CAPEX overrun before NPV turns negative; and
- utilisation level at operating break-even.
These figures convert sensitivity analysis into management limits.
Common Sensitivity Analysis Mistakes
| Mistake | Why It Weakens the Analysis |
|---|---|
| Testing an arbitrary ±10.0% on everything | Different assumptions have different realistic ranges |
| Testing only upside cases | Funding analysis is primarily concerned with downside resilience |
| Looking only at net profit | Cash and debt-service failure can occur before accounting losses |
| Changing too many variables in a “sensitivity” test | That becomes scenario analysis |
| Treating two-way analysis as correlation analysis | The grid shows combinations, not probabilities |
| Using unrealistic extreme values | Results become dramatic but commercially meaningless |
| Ignoring working capital | Rapid growth frequently creates cash pressure |
| Ignoring timing | Delays can materially affect funding and returns |
| Ranking risks without mitigation | The analysis never reaches a management decision |
| Hiding negative results | It damages credibility when due diligence identifies them later |
| Running sensitivity on a broken model | The analysis simply reproduces model errors |
A Funding Case Study: How Sensitivity Analysis Changes the Decision
Consider a hypothetical business seeking R20 million to expand a manufacturing facility.
The base financial model produces:
| Metric | Base Case |
|---|---|
| Revenue | R42.0m |
| EBITDA | R7.0m |
| Minimum Cash | R2.4m |
| DSCR | 1.55x |
| Project IRR | 23.0% |
The sensitivity analysis identifies three major exposures:
| Test | Result |
|---|---|
| Revenue -15.0% | DSCR falls to 1.08x |
| Debtor Days 45 → 75 | Minimum cash becomes negative |
| Input Costs +10.0% | EBITDA falls materially, but DSCR remains above 1.20x |
What does the analysis tell the funder?
The major problem is not input-cost inflation.
It is revenue conversion and working capital.
The funding strategy should therefore concentrate on those risks. Management may need stronger customer commitments, milestone billing, a larger working-capital buffer, tighter debtor collection or a slower capacity ramp-up.
Without sensitivity analysis, management might have focused on negotiating cheaper raw materials while missing the actual liquidity threat.
That is the difference between a financial forecast and a financial decision model.
How Sensitivity Analysis Should Appear in a Business Plan
Do not dump twenty Excel tables into the Business Plan.
The detailed calculations belong in the financial model.
The written plan should extract the decision-useful findings.
Executive Summary
Use one or two sentences where the downside result materially strengthens the investment case.
Example:
The base case remains cash-positive under the tested downside assumptions, with revenue identified as the principal sensitivity. Debt-service capacity becomes constrained once revenue falls materially below the forecast case, making contracted sales conversion a core management KPI.
Financial Plan
Show the key sensitivity table, downside case and relevant breakpoints.
Risk Analysis
Translate the largest sensitivities into risks, mitigants and monitoring indicators.
Funding Section
Explain whether changes to CAPEX, working capital or operating assumptions could create an additional funding requirement.
Excel Financial Model
Retain the full sensitivity tables, assumptions, scenario analysis and supporting calculations.
Investor or Funder Dashboard
Use a tornado chart, traffic-light matrix or compact scenario table if it improves interpretation.
The written narrative and Excel model should tell the same story.
A Practical Sensitivity Analysis Checklist before Submitting a Business Plan
Before sending a financial model to a bank, DFI or investor, confirm that:
- the base case reconciles across the Income Statement, Balance Sheet and Cash Flow Statement;
- every tested assumption links to a defined input cell;
- sensitivity ranges are commercially plausible;
- revenue, pricing and cost assumptions have been tested;
- working-capital assumptions have been tested;
- interest rates and debt terms have been tested where funding is involved;
- CAPEX overruns and implementation delays have been considered;
- key outputs include cash and repayment capacity, not only profit;
- downside cases have been tested;
- major breakpoints are known;
- the principal sensitivities have clear mitigation actions;
- sensitivity analysis and scenario analysis are clearly distinguished; and
- the Business Plan interpretation matches the Excel model.
If those questions cannot be answered, the model is not yet ready for due diligence.
When Sensitivity Analysis Becomes Too Simplistic
One-way analysis deliberately holds everything else constant.
Real businesses do not behave that way.
Sales volume may fall even as discounting increases. Raw material costs may rise as the rand weakens. A project delay may increase both construction costs and interest during construction.
The Joint Research Centre specifically warns that one-factor-at-a-time analysis can miss interactions and non-linear behaviour. Global methods are more suitable when those interactions materially affect the decision.
This is why a strong funding model should normally use a progression:
Base Case → Sensitivity Analysis → Scenario Analysis → Stress Test
Sensitivity analysis identifies the pressure points.
Scenario analysis combines them.
Stress testing finds the failure point.
When Should You Get Professional Help?
A basic one-way sensitivity analysis is accessible to most competent Excel users.
The difficulty increases when the financial model contains:
- several revenue streams;
- integrated three-statement forecasts;
- debt schedules and moratoriums;
- project-finance structures;
- multiple funding tranches;
- staged CAPEX;
- working-capital facilities;
- DCF valuation;
- covenant testing;
- complex tax assumptions; or
- ten-year and longer projection periods.
At that stage, the risk is not simply building the Data Table incorrectly.
The larger risk is testing a model whose underlying architecture is wrong.
A professional funding model should allow a user to trace the result from the assumption through the financial statements, cash flow, funding schedules and investment-return metrics without breaking the workbook.
That is also why sensitivity analysis should be designed into the model from the beginning rather than added as a cosmetic worksheet immediately before submission.
What a Funder-Ready Sensitivity Section Should Communicate
A strong sensitivity section allows a credit analyst or investor to understand five things quickly:
1. What is the base case?
The starting forecast must be clearly defined.
2. What assumptions matter most?
The model should rank the major drivers.
3. How much downside can the business absorb?
Show the relevant breakpoints.
4. What happens to cash and repayment capacity?
Profit alone is not sufficient.
5. What will management do if the risk starts materialising?
Link the sensitivity to a mitigation and KPI.
That final step is often missed.
Sensitivity analysis is most valuable when it changes the way the business is managed.
Frequently Asked Questions About Sensitivity Analysis in Business Plans
What is sensitivity analysis?
Sensitivity analysis tests how changes in financial-model assumptions affect the model’s outputs. It is used to identify which assumptions have the greatest influence on profitability, cash flow, funding requirements, valuation or debt-service capacity.
What is sensitivity analysis in financial modelling?
Sensitivity analysis in financial modelling measures how an output such as EBITDA, cash flow, IRR, NPV or DSCR responds when one or more assumptions change. The technique helps identify the assumptions that create the greatest financial risk.
What is what-if analysis?
What-if analysis is the broader process of changing model inputs to examine the resulting outputs. Microsoft Excel includes Data Tables, Scenario Manager and Goal Seek as built-in What-If Analysis tools.
What is scenario analysis in business planning?
Scenario analysis changes several related assumptions simultaneously to create a coherent alternative forecast, such as a downside, severe-downside or upside case. It shows how the entire business performs in a different operating environment rather than isolating a single assumption.
What is the difference between sensitivity analysis and scenario analysis?
Sensitivity analysis usually isolates individual drivers to identify which assumptions matter most. Scenario analysis changes several assumptions together to model a complete alternative outcome. Sensitivity analysis identifies the pressure points; scenario analysis shows what happens when several pressure points occur together.
How do you perform sensitivity analysis in Excel?
For one- or two-variable sensitivity analysis, Excel’s Data Table function can substitute a range of input values into linked model cells and automatically calculate the resulting outputs. Microsoft provides dedicated one-variable and two-variable Data Table functionality within What-If Analysis.
What assumptions should be tested in a business plan?
The most common assumptions are revenue, selling prices, volumes, gross margins, operating costs, payroll, debtor days, inventory, creditor days, CAPEX, interest rates, utilisation and project timing. The correct variables depend on the business model and funding structure.
Do funders require sensitivity analysis?
Requirements differ between institutions and transactions. South African funders such as the IDC and SEDFA publicly require credible financial forecasts, detailed assumptions, sustainable cash flow and evidence of repayment ability. Sensitivity analysis is a practical way to demonstrate the resilience of those forecasts and expose the risks that could affect repayment.
What are the best practices for interpreting sensitivity analysis results?
Identify the assumptions that produce the largest output changes, establish the relevant breakpoints, focus on cash, repayment, and profit, distinguish plausible downside from extreme stress, and connect each major sensitivity to a management response and a measurable KPI.
The Point of Sensitivity Analysis
A business plan should never imply that management knows exactly what the next five years will look like.
It should show that management understands what drives the financial outcome.
That is what sensitivity analysis does.
It moves the discussion away from:
“These are our projections.”
towards:
“These are our projections, these are the assumptions that matter most, this is what happens when they move, this is how much downside the business can absorb, and this is how we will manage the risk.”
That is a materially stronger funding proposition.
A robust financial model should therefore do more than calculate a base case. It should make uncertainty visible, identify the financial breakpoints and give management enough information to act before a variance becomes a funding problem.
For businesses preparing a bank, DFI, or investor submission, JTB Consulting builds integrated Excel financial models that connect assumptions, financial statements, funding requirements, repayment capacity, sensitivity analysis, and scenario analysis within a single model. The objective is not to make the spreadsheet more complicated. It is to clarify the investment decision.
