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:
More information:
Datapartner Oy
Phone: +358 19 54 10 100
E-mail: datapartner@datapartner.fi
Online chat: https://www.datapartner.fi/chat