Scenario and What If Analysis

By Kardi Teknomo, PhD.

<Content | Next>

What if analysis or scenario analysis is sometimes also called deterministic simulation. It simulates the system to find possible effect of some possible scenarios.

In this interesting tutorial, you will learn:

1. How to perform an economic evaluation
2. How to compute financial analysis
3. How to model feasibility study for a public transportation system (bus)
4. How to perform sensitivity analysis using MS Excel

The MS Excel worksheet companion of this tutorial is provided here for your understanding. You should be familiar to the very basic on how to use MS Excel (such as how to type formula and value, and copy and paste). No other prerequisite knowledge is necessary to read this tutorial aside from high school algebra. The core knowledge on public transportation financial analysis can be read without going into detail.

The topics of the tutorial are given below (click to enter)

• Setting the Problems of Feasibility study
• Economic Feasibility Study
  • Notations
  • Formulations
    • Cost Formulations
    • Benefit Formulation
    • Bus Operation Formulation
• Feasibility Study using MS Excel
• Sensitivity and What if Analysis
• Appendix: Financial Analysis
• Exercises
• Give your comments on this tutorial

<Content | Next>

This tutorial is copyrighted.

Preferable reference for this tutorial is

Teknomo, Kardi. Scenario and What If Analysis. http://people.revoledu.com/kardi/tutorial/What-If-Analysis/index.html