Hi,
I'm building a business case at the moment and am evaluating the investment using NPV.
What I need to do is complete a sensitivity analysis on the core drivers of the NPV (i.e. revenue, implementation costs, operating costs, etc.)
I have tried to used the data table feature but it makes no sense to me.
I am look to calculate and graph the effects at 20% - 200% at 20% intervals.
How can I use this data table to complete my sensitivity analysis?
Any help would be greatly appreciated
I'm building a business case at the moment and am evaluating the investment using NPV.
What I need to do is complete a sensitivity analysis on the core drivers of the NPV (i.e. revenue, implementation costs, operating costs, etc.)
I have tried to used the data table feature but it makes no sense to me.
I am look to calculate and graph the effects at 20% - 200% at 20% intervals.
How can I use this data table to complete my sensitivity analysis?
Any help would be greatly appreciated