The standard Tornado analysis function is an excellent tool for learning which are the most sensitive variables and where to put focus:

In practice however, it lacked the possibility to adjust for different change ranges for the individual variables. Some are more volatile, and some are fairly fixed. Usually, a variables value can also change more in one direction (up/down), than to the other direction. The variations are seldom symmetrical.

This has been addressed in Invest for Excel® from version 4.1.003 onwards. You can now select individual variables, press % -button and adjust the variations freely:

Maybe I consider that average annual ticket price could be 15% higher or 20% lower than planned:

Maybe I consider that the number of passengers could be 15% higher or 30% lower than planned: 

The outcome:

Datapartner Oy

Phone: +358 19 54 10 100
E-mail: [email protected]
Online chat: https://www.datapartner.fi/chat

 

Back