I have made an excel file where i want to do a few sensitivity analysis.
To remain flexible, i have put a formula on the data that the what if analysis tool has to take for its calculations.
https://imagebin.ca/v/3irbzK2IVH6D
Like putting on a row -5% to +5% compared to my basic assumption for me to have an easier understanding of the value of the table.
However i have noticed that:
-1) The values given by the what if analysis are not the same at all as if i were to directly write in hard the value in my model (the most shocking was when for the parameters i have 0% / 0% so we are back to my basic assumption, the computation is different from my model on excel)
-2) if the what if analysis take cells which are only composed of value or of formula (but gives the same value) the computation are not the same at all.
It is one of my first time using this excel tool and i'm not very familiar with it and i thought i'd still understand how to use it but i have the impression i'm wrong (i have been careful on what i put in row/columns in the window of the what if though)
Please find attached the link on my excel if it is easier for your understanding. https://mega.nz/#!2wIXALyA!-z4PVGG10a-ZKt9wSCqt4q2MHw-2pHZIBcQbgo2wFvE
Thank you for any help,
Regards
