Sensitivity Analysis: Testing Financial Assumptions

Every successful UK small business plan is built on financial assumptions – but what happens if those assumptions turn out to be wrong? Sensitivity analysis lets you stress-test your forecasts, so you can see how changes in sales, costs, or prices would affect your bottom line. In this guide, you'll learn exactly how to carry out sensitivity analysis, why it matters for your business, and how to use it to make more robust, confident decisions.

Sensitivity analysis is a technique used to test how changes in key financial assumptions affect your business outcomes. In practice, it means asking 'what if?' – what if sales grow slower than expected, costs rise, or a key customer leaves? By systematically adjusting your assumptions and recalculating your forecasts, you can see which factors have the biggest impact on your profits, cash flow, and survival.

For UK small business owners, sensitivity analysis is not just a finance exercise – it’s a practical way to reduce risk. The UK business environment is unpredictable, with inflation, changing tax rates, and fluctuating demand. The Office for National Statistics (ONS) regularly reports that around 20% of new UK businesses fail within their first year, often because cash flow issues catch them off guard. Sensitivity analysis helps you anticipate these scenarios and plan for them.

Banks, investors, and even grant providers increasingly expect to see sensitivity analysis in your business plan or funding application. It demonstrates that you understand your numbers and have considered what could go wrong. Even if you’re bootstrapping or self-funding, it’s the difference between wishful thinking and genuinely robust planning.

• Helps identify which assumptions are most critical to your business’s viability.
• Reveals how much 'wiggle room' your forecast has before you run into trouble.
• Supports more confident decision-making and investment choices.
• Demonstrates professionalism to lenders, investors, and partners.

Not every variable in your forecast is equally important. Sensitivity analysis works best when you focus on the factors that have the biggest impact on your financial health. For UK small businesses, this typically means sales volumes, pricing, direct costs, overheads, and key external factors like VAT or business rates.

Start by listing out all the main assumptions that underpin your projections. These could include your average sales price, the number of customers or sales per month, supplier costs (which can be affected by inflation or exchange rates), wage rates (including National Minimum Wage changes), and even things like energy prices or insurance premiums, which have seen notable volatility in the UK market recently.

It’s also important to consider tax-related assumptions, such as Corporation Tax rates (currently 25% for profits over £250,000, with marginal relief for profits between £50,000 and £250,000 as of 2026), and VAT thresholds (£90,000 turnover for VAT registration). Get these wrong and your forecast could be wildly inaccurate.

• Sales growth rate (e.g. 5%, 10%, 20%)
• Cost inflation (e.g. raw materials up 8% year-on-year)
• Customer churn (losing 1 in 5 customers per year)
• Late payment rates (average UK SME waits 54 days for payment)
• Tax and compliance cost changes

The actual mechanics of sensitivity analysis are straightforward, but meaningful results come from doing it thoughtfully. You don’t need expensive software – Excel or Google Sheets will do the job, and most UK business accounting systems like Sage, QuickBooks, and Xero allow for scenario testing. The key is to be systematic and transparent.

Begin with your baseline forecast: this is your best estimate of how your business will perform, based on current knowledge. Then, for each key assumption, ask: what if this is 10%, 20%, or 30% better or worse than expected? Recalculate your forecasts for each scenario. The aim is to reveal how sensitive your bottom line is to changes in each input.

For critical assumptions – for example, if your business depends on a single large customer – consider more extreme scenarios. Don’t just test likely swings, but also what would happen if a major risk materialised. This is particularly important for businesses with thin margins or limited cash reserves.

Once you’ve run your scenarios, the next step is to interpret what they mean for your business. The goal isn’t just to generate lots of numbers, but to spot where you’re vulnerable – and where you have flexibility. If a 10% drop in sales wipes out your profit, or a small cost increase pushes you into negative cash flow, you’ve identified a critical risk.

Look for 'tipping points' – the threshold at which your business becomes unviable. For example, your breakeven sales volume, or the maximum level of cost increases your margins can absorb. In the UK context, also watch for thresholds that trigger tax or compliance changes (like hitting the £90,000 VAT threshold, or going over the small profits limit for Corporation Tax).

Summarise your findings in plain English. For decision-makers (including yourself), it’s not helpful to say 'profit varies between £10,000 and £50,000.' Instead, say: 'If sales fall by more than 15%, we make a loss. If costs rise by 10%, we need to increase prices by 5% to stay profitable.' This clarity is what makes sensitivity analysis so valuable.

• Identify which changes have the biggest financial impact.
• Spot if multiple 'bad' changes at once could sink your business.
• Highlight areas needing contingency plans (e.g. cost increases).
• Use findings to justify pricing, investment, or staffing choices.

The most frequent mistake UK small business owners make is either skipping sensitivity analysis altogether or running it on autopilot. Relying on a single 'best guess' for your forecast is wishful thinking. Similarly, using unrealistic ranges – like testing sales at +/-50% when the real world rarely shifts that dramatically – can make the exercise meaningless.

Another trap is changing too many variables at once. If you adjust sales, costs, and prices simultaneously, it’s impossible to see which factor is driving the result. Stick to 'one at a time' analysis, at least initially, before testing combined scenarios for worst-case planning.

A subtle but serious error is failing to act on what you find. Sensitivity analysis only adds value if you update your plans based on the risks you uncover. If your analysis says you’re dangerously exposed to wage increases, don’t ignore it – consider automation, price increases, or other mitigations.

• Testing only 'good news' scenarios – always include worst-case.
• Failing to update assumptions as market conditions change.
• Using US or global data instead of UK-specific figures.
• Assuming fixed costs are truly fixed – some may scale unexpectedly.

The real power of sensitivity analysis is what you do with the insights. It’s not just a tick-box for a business plan – it’s a living tool for decision-making. Review your analysis at least quarterly, or whenever there’s a major change (like a new contract, supplier, or regulation).

Use your findings to set financial controls and contingency plans. For example, if you know a 10% cost increase would wipe out your profit, you might negotiate fixed-rate supply contracts, build a cash buffer, or agree price review clauses with customers. Similarly, if you’re close to the VAT threshold, plan for the cash flow impact of quarterly VAT payments and potential price adjustments.

Sensitivity analysis is also invaluable for discussions with banks and investors. If you can show you’ve thought through multiple scenarios, including bad ones, you’ll be taken far more seriously. Even internally, it’s a powerful way to align your team and avoid nasty surprises.

• Set cash reserves based on your worst-case scenario.
• Use findings to support price increases or cost-cutting decisions.
• Plan for VAT registration and Corporation Tax changes before you hit thresholds.
• Review and update sensitivity analysis after major business events.

You don’t need expensive software to run sensitivity analysis – most UK small businesses use Excel or Google Sheets, which have built-in 'what-if' and scenario tools. For more advanced needs, business planning software like Brixx, Futrli, or Float (all UK-compliant) can automate scenario testing and integrate with your accounts.

The British Business Bank, Federation of Small Businesses, and ICAEW all provide free templates and guides for financial forecasting and sensitivity analysis. The GOV.UK website has sector-specific data and links to the ONS and HMRC for up-to-date rates, thresholds, and statistics.

If you’re applying for funding, check your lender’s requirements. Most UK banks (Barclays, Lloyds, NatWest) provide their own templates, and will expect to see at least three scenarios: base case, optimistic, and pessimistic. If you need help, a UK-qualified accountant can review your model for realism and compliance.

• Download sector-specific templates from the British Business Bank.
• Use Excel’s built-in 'Data Table' or 'Scenario Manager' tools.
• Check GOV.UK for the latest tax and compliance thresholds.
• Consider cloud forecasting apps that integrate with your UK accounts.
• Join business networks (FSB, local Chambers) for peer support.