Scenario Analysis Calculator
Calculate Scenario Analysis step by step: Scenario profit = revenue × (1 + revenue change) − costs × (1 + cost change); optional weighted profit = Σ weight × scenario profit.
In short
Formula: Scenario profit = revenue × (1 + revenue change) − costs × (1 + cost change); optional weighted profit = Σ weight × scenario profit.
What this calculator does
Calculate Scenario Analysis step by step: Scenario profit = revenue × (1 + revenue change) − costs × (1 + cost change); optional weighted profit = Σ weight × scenario profit. Worked example, questions and limitations included.
Use it to turn Currency (symbol only, never converted), Base-case revenue, Base-case costs, Downside revenue change, and the other shown inputs into a checked result you can compare, copy, or rerun with different assumptions.
The page shows the formula, a numeric worked example, and the assumptions that affect this fp&a calculation.
Inputs and what they mean
- Currency (symbol only, never converted)
- — choice value.
- Base-case revenue
- — number value.
- Base-case costs
- — number value.
- Downside revenue change
- — number value.
- Downside cost change
- — number value.
- Upside revenue change
- — number value.
- Upside cost change
- — number value.
- Downside weight (optional)
- — number value.
- Base weight (optional)
- — number value.
- Upside weight (optional)
- — number value.
How to use it
- Enter each value in the unit shown next to the box (use the unit converter first if your numbers are in other units).
- Check the breakdown to see every intermediate step.
- Read the limitations before relying on the result.
Formula
Scenario analysis as described in OpenStax Principles of Finance.
You define each scenario; nothing is assumed.
Weights are optional and must sum to 100%.
Scenario profit = revenue × (1 + revenue change) − costs × (1 + cost change); optional weighted profit = Σ weight × scenario profit.
Inputs used: Currency (symbol only, never converted), Base-case revenue, Base-case costs, Downside revenue change, Downside cost change, Upside revenue change, Upside cost change, Downside weight (optional), and other shown inputs.
Worked example
Annual plan
- Base = $100,000.
- Downside = 425,000 − 380,000 = $45,000.
- Upside = 550,000 − 424,000 = $126,000.
Reading the result
The headline figure is the main answer. Any breakdown underneath shows the parts that make it up, so you can check the working and see what changes when you adjust an input.
Limitations and assumptions
- Three scenarios only.
- Revenue and costs change by flat percentages.
- Results are educational estimates built only from the figures you enter. They are not personalised investment, tax, legal or accounting advice. Rates, growth and discount assumptions are always yours to choose.
- The result depends on the values you enter for this scenario analysis calculator; it does not supply missing rates, rules, prices, dates, or assumptions for you.
Common questions
Is this a prediction?
No. It projects the assumptions you enter. Growth, rates and scenarios are your choices — none are built in.
Why are weights optional?
Assigning probabilities is a judgement. We only compute a weighted figure when you supply all three.
Is this investment advice?
No. It shows the outcomes of the scenarios you define.
How do I use the Scenario Analysis Calculator?
Enter the required values for Currency (symbol only, never converted), Base-case revenue, Base-case costs, Downside revenue change, Downside cost change, and the other fields shown. The calculator applies the formula on this page and shows the main result with any supporting breakdown so you can check the arithmetic.
What formula does the Scenario Analysis Calculator use?
Scenario profit = revenue × (1 + revenue change) − costs × (1 + cost change); optional weighted profit = Σ weight × scenario profit. The visible formula section above lists the calculation path and the edge cases the page handles, so the result can be checked without relying on the form alone.
Can the Scenario Analysis Calculator be used for exact decisions?
Use it as a calculation aid, not as a substitute for checking the underlying rule, contract, policy, or professional advice that applies to your situation. When a result depends on local rules, personal details, prices, or dates, enter those values yourself and confirm them before acting.
Related tools
Calculate Revenue Forecast step by step: Revenueₙ = current revenue × (1 + growth rate)ⁿ.
Calculate Expense Forecast step by step: Forecast expenses = fixed costs + (variable % × forecast revenue) + one-off costs.
Calculate Headcount Cost step by step: Annual cost = employees × [salary × (1 + benefits % + employer taxes %) + other cost per head].
Calculate Cash Flow step by step: Closing cash = opening cash + inflows − outflows.
Calculate Burn Rate step by step: Net burn = (cash at start − cash at end) ÷ months.