Sensitivity Tornado Analyzer

Most business plans get built around a dozen assumptions. Usually only two or three of them actually decide whether the plan works. This finds those two or three.

Reading This Tool

How To Use This Analyzer

Enter your base case revenue, cost structure, and interest expense, plus how much each could realistically swing.

Each bar shows the net income range if that one variable moves through its swing while everything else holds still. Bars are sorted widest to narrowest, the classic "tornado" shape that tells you exactly where to focus planning attention.

Your Inputs

Base Case Revenue $2,000,000

Revenue Swing (±) 15%

Base Case COGS (% Of Revenue) 45%

COGS % Swing (± Points) 5 pts

Base Case Operating Expense $600,000

OpEx Swing (±) 10%

Base Case Interest Expense $80,000

Each variable is swung independently while all others are held at their base case value, this isolates the individual sensitivity of net income to each assumption rather than compounding multiple changes at once.

What Actually Moves The Outcome

Base Case Net Income

Biggest Swing Factor

Smallest Swing Factor

Net Income Range By Variable

This tool isolates one variable at a time, real outcomes usually involve correlated movements, a revenue miss often comes with cost pressure too, so treat this as a prioritization tool rather than a worst-case forecast.

Want to build out a full three-scenario model from here?

Try The NPV/IRR Capital Budgeting Tool →