Scenario & What-If Analysis
Scenario analysis and what-if analysis help businesses understand how different assumptions may affect revenue, costs, and profit. In this interactive lesson, you will test business assumptions, compare possible outcomes, evaluate sensitivity, and use evidence to make decisions under uncertainty.
Concepts
8
Progressively unlocked
Practice checks
16
One activity and one MCQ per concept
Core skill
Test before deciding
Evaluate risk and opportunity
Understanding Scenario Analysis
Explore several possible business futures instead of assuming there is only one outcome.
Learning objective
Understand how changing business assumptions creates alternative outcomes that management can prepare for.
Explore the visual
One business, three possible futures
A retailer has current monthly revenue of ₹10 lakh. Demand may weaken, remain near expectations, or strengthen. Select a scenario to explore its implications.
Base scenario selected
Management can use this scenario as the planning reference while tracking actual performance against assumptions.
Data shown in this visual
Current revenue
Baseline
₹10 lakh
Low scenario
Demand weakens
₹8 lakh
Base scenario
Expected conditions
₹10 lakh
High scenario
Demand strengthens
₹12 lakh
Apply the concept
Compare the possible outcomes
The baseline revenue is ₹10 lakh. The high-demand scenario projects ₹12 lakh. What is the absolute increase over the baseline?
Think and interpret
Related business reasoning MCQ
What is the main reason to prepare low, base, and high business scenarios?
Complete both checks to continue
Activity: incomplete · MCQ: incomplete
Scenario analysis formulas and ideas
Business scenario analysis is not only about calculating numbers. It connects assumptions to financial outcomes and helps management understand what action may be appropriate under different conditions.
Revenue
Units sold × Selling price per unit
Profit
Revenue − Total costs
Scenario range
Highest outcome − Lowest outcome
Percentage change
(New value − Old value) ÷ Old value × 100
Frequently asked questions
What is scenario analysis in business?
Scenario analysis evaluates how business results may change under different sets of assumptions, such as low demand, expected demand, and high demand.
What is the difference between scenario analysis and sensitivity analysis?
Scenario analysis evaluates a set of assumptions representing a possible situation. Sensitivity analysis tests how strongly an output responds when an input changes.
Can I perform what-if analysis in Excel?
Yes. Excel includes Scenario Manager, Goal Seek, and Data Tables for different what-if tasks. Formulas can also model changes to revenue, costs, and profit.
Does scenario analysis predict the future with certainty?
No. It helps a business understand possible outcomes and prepare decisions under uncertainty. Results depend on the quality of the assumptions and the model.
Learning note: all financial figures are illustrative. Scenario results depend on assumptions and may differ from actual business outcomes. Progress is held in page state and resets when the page is refreshed.