Sensitivity and Scenario Analysis: Stress-Test Your Project Before You Invest

Every feasibility study rests on assumptions: the number of customers, prices, costs and the opening date. The base case a study presents is just one set of these assumptions, and the only certainty is that reality will not match it exactly. The real question, then, is not "Is the project profitable?" but "How far can things go wrong before the project starts losing money?". That is precisely what sensitivity and scenario analysis answers.

Why the base case is not enough

When you read that a project's net present value is positive and its internal rate of return is high, you are reading a result that is correct provided that every assumption holds. But:

• Opening may be delayed by a few months because of licensing or supply issues.
• Demand in the first year may be slower than expected.
• Material prices or rents may rise.
• A new competitor may enter and put pressure on prices.

Two projects that look identical in the base case may differ radically in their ability to absorb shocks. One withstands a large drop in sales, while the other turns loss-making at the first small deviation. Sensitivity analysis is what reveals this hidden difference.

Sensitivity analysis: one variable at a time

The idea is simple: hold all assumptions constant, change one variable by set percentages up and down, and observe the effect on decision indicators such as net present value, internal rate of return and payback period. If you need a refresher on these indicators, see our article on net present value, internal rate of return and payback period.

Steps to apply it

1. Identify the key variables: sales, price, operating costs, investment cost and the discount rate.
2. Choose the range of change: for example, graduated increases and decreases, with the range reflecting the realistic volatility of each variable rather than an arbitrary uniform figure.
3. Calculate the effect on each indicator at each percentage change.
4. Rank the variables by the strength of their impact, which is usually shown in a so-called "tornado chart", because the most influential variable appears at the top with the widest bar.

The critical value: the most useful question

Instead of asking "What if sales fall by 10%?", ask the reverse: "How far can sales fall before net present value reaches zero?". This critical value gives you the real margin of safety. If the project can tolerate a large drop in sales, it is robust; if it collapses at a slight deviation, it is fragile, however attractive its base-case figures appear.

Scenario analysis: a complete picture of a possible world

In reality, variables do not move in isolation. An economic downturn, for example, may reduce sales and squeeze prices at the same time. Sensitivity analysis is therefore complemented by building internally consistent scenarios:

The important rule: each scenario must have a logical story that explains it, not merely numbers multiplied by arbitrary percentages. The conservative scenario for a tourism project, for example, might be "a weaker season than usual, combined with a delay in opening a neighbouring project that was expected to draw visitors". That story determines which variables move together and in which direction, making the results open to discussion and credible.

The break-even point: the minimum for survival

The break-even point is the level of sales at which revenue covers all fixed and variable costs, with neither profit nor loss. It is calculated by dividing fixed costs by the contribution margin per unit, i.e. the selling price minus the variable cost per unit.

Compare the break-even point with expected demand and capacity: if it is very close to maximum capacity, the project needs near-perfect performance just to cover its costs, which is a clear warning sign. It is also advisable to calculate the cash break-even point, i.e. after adding financing installments to fixed obligations, because a project may break even in accounting terms yet still be unable to meet its cash obligations.

A hypothetical example for illustration

A specialty coffee shop with a hypothetical initial investment of OMR 80,000. In the base case:

• An average of 200 orders a day at an average ticket of OMR 2.5, over 360 days: annual revenue of OMR 180,000.
• Variable cost (ingredients and packaging) at 35% of revenue: OMR 63,000.
• Annual fixed costs (rent, salaries and utilities): OMR 90,000.
• Net annual cash flow: OMR 27,000, and a simple payback period of about 3 years.

Break-even point: the contribution margin per order is 2.5 × 65% = OMR 1.625, so the break-even point is 90,000 ÷ 1.625 ≈ 55,400 orders a year, or about 154 orders a day. The margin between break-even and the base case is only 46 orders a day, or about 23%.

Sensitivity: we now change one variable at a time, keeping the other assumptions as they are in the base case:

The result is clear: the project is highly sensitive to demand volume, and a 20% decline all but wipes out its viability. This does not necessarily mean rejecting it; it means the investment decision must rest on high confidence in the demand estimate, or on redesigning the project to lower its fixed costs. That is why we recommend serious prior work on estimating demand in the Omani market.

From analysis to decision: what to do with the results

Sensitivity analysis is not an academic exercise relegated to an appendix; it is a tool for redesigning the project and strengthening its position:

• Reduce fixed costs: for example by renting a smaller space at first or outsourcing some functions, which lowers the break-even threshold.
• Phased implementation: start with smaller capacity and expand once demand is proven.
• Advance contracts: forward supply or sales contracts reduce uncertainty in the riskiest variable.
• Lock in costs: long-term lease or supply contracts at fixed prices.
• Liquidity reserve: set aside a reserve that covers the conservative scenario for several months, which funders usually look at when assessing the project's capacity to repay.
• Early warning indicators: define monthly operating figures that alert you if the project is heading towards the conservative scenario, so you can act before the problem escalates.

Common mistakes in sensitivity analysis

• Testing secondary variables while neglecting the most influential ones, such as demand and price.
• Token ranges of change that do not reflect a variable's real volatility.
• A conservative scenario that differs little from the base case, giving a false sense of security.
• Ignoring timing: a delay of several months in opening may be more dangerous than a change in prices, because it postpones revenue while some costs continue.
• Presenting results without explanation or without linking them to practical actions.
• Running the analysis once and then forgetting it: it should be updated whenever assumptions change or actual data emerges after operations begin, so the financial model becomes a live monitoring tool.

Conclusion

The base case tells you what may happen if things go to plan, while sensitivity and scenario analysis tells you what will happen if they do not, which is closer to reality. Know the riskiest variable in your project, calculate its critical value, compare the break-even point with your capacity and expected demand, and then design the project to withstand pressure. The confident investor is not the one with the best figures, but the one who knows the limits of those figures. If you want a financial model that rigorously tests your project before you commit your money, we would be glad to work with you: request your study.