Tornado Diagram Templates and Video Courses

This page explains how to make different presentations of scenario and sensitivity analysis using tornado diagrams, spider diagrams and other tools. The process involves using a combination of data tables and the index function. The process is helped with the TRANSPOSE function. A tornado diagram can be a good risk tool because it shows the importance of different variables and it demonstrates whether there is more downside or upside risk. A spider diagram can be used when sensitivity variables are expressed as percentages (e.g.120% or 90%). Then a two way data table can be used with the percentages and the various different input variables. In creating a tornado diagram you need add a whole bunch of scenarios where each sensitivity has only variables that differ from the base case.

The video below illustrates the process




Subject

Excel Exercise File

Video





Basic Tornado Diagram

Scenario and Tornado Exercise

https://www.youtube.com/watch?v=0x1sx5YKpr8
Sorting a Tornado Diagram

Scenario and Tornado Exercise Finished

https://www.youtube.com/watch?v=kH41VDGakqM
Tornado Diagram with Two Way Table

Scenario and Tornado Exercise Two Way Table

https://www.youtube.com/watch?v=fdO6p22ngow
Showing Low and High Case Values in Tornado Diagram




Tornado Diagram in Project Finance Model




Tornado Diagram with Alternative Base Case




Spider Diagram with Constant Increments




Spider Diagram with Variable Increments




Tornado Diagram in Merchant Analysis




Flexible Sensitvity Diagram

Kalitta Corporate Model

https://www.youtube.com/watch?v=JO-SbCoqXqk
Tornado Diagram with Offset Function

Kitty Hawk Corporate Model


……………………………………………………………………………………………………….
….
………………………………………………………………………………………..

……………………………………………………………………………………………..