In English - Auf Deutsch - Suomeksi - På svenska - Polski - Česky - По Русски - Español - Български
DataPartner
DataPartner Software for capital budgeting, investment appraisal & valuation: Invest for Excel®
-
News & Events
-
Services
-
Customers
-
Company
-
Support
-
Download a Free Trial
-
How to buy
-
Webcam
-
Book a Free Presentation
-
Invest for Excel, Your Investment Appraisal Software
-
Products
-
White paper
News & Events
![Press to learn more about Invest for Excel software!](/images/DP-all-page.png)
News
A new feature: Flexible Tornado Analysis in the Invest for Excel® software
June 9, 2023
The standard Tornado analysis function is an excellent tool for learning which are the most sensitive variables and where to put focus:
![](https://www.datapartner.fi/uploads/3f/b8/3fb8c9c7239dbab3a92d344f3ed20325/Tornado-analysis.png)
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:
![](https://www.datapartner.fi/uploads/8a/a8/8aa8ada747abe8195cd128dd98e48389/tornado2.png)
Maybe I consider that average annual ticket price could be 15% higher or 20% lower than planned:
![](https://www.datapartner.fi/uploads/0a/7d/0a7df07602bbf0eac17136ebb109ebe4/tornado3.png)
Maybe I consider that the number of passengers could be 15% higher or 30% lower than planned:
![](https://www.datapartner.fi/uploads/31/7d/317dcebc177d24fffccba1d88cacf9b3/tornado4.png)
The outcome:
![](https://www.datapartner.fi/uploads/48/ed/48eda54b2ebfcfef5b8fc0614979da4a/Tornado5.png)
More information:
Datapartner Oy
Phone: +358 19 54 10 100
E-mail: [email protected]
Online chat: https://www.datapartner.fi/chat