Learning Objectives

By the end of this lesson, learners should be able to:

  • Explain what-if analysis.
  • Use Goal Seek.
  • Create scenarios.
  • Use Data Tables.
  • Apply sensitivity analysis to business decisions.

Meaning Of What-If Analysis

What-if analysis examines how changes in assumptions affect results.

Goal Seek

Goal Seek finds the input value needed to achieve a target result.

Example: Determine the sales quantity required to achieve a profit of USD 50,000.

Scenario Manager

Create alternative business situations such as:

  • Best case,
  • Expected case,
  • Worst case.

Example: Annual Sales Forecast

Scenario

Sales (USD)

Best Case

1,200,000

Expected Case

1,000,000

Worst Case

780,000

Management can prepare contingency plans for each scenario.

Data Tables

Analyze how one or two variables affect a formula.

Example: Examine profit at different selling prices and sales volumes.

Sensitivity Analysis

Measures how sensitive results are to changes in assumptions.

Common in budgeting, investment analysis, and pricing decisions.

Business Case: International Expansion

A company considering expansion into Dubai evaluates profit under different exchange rates, rental costs, and sales forecasts. Scenario analysis identifies the conditions under which the project remains profitable.

Managerial Benefits

  • Better planning,
  • Risk assessment,
  • Resource allocation,
  • Investment evaluation,
  • Strategic decision support.

Learning Materials / Reference Materials

  • Microsoft What-If Analysis Guide.
  • Financial Modeling Institute Resources.
  • Benninga, S. Financial Modeling.

Lesson Summary

What-if analysis and scenario modeling help managers evaluate uncertainty, assess risk, and make more informed business decisions.

PreviousNext