top of page

Sensitivity Analysis
This project focuses on sensitivity analysis in capital budgeting.
​
As seen below, the current model shows maximum sensitivity for growth rate while least sensitivity for land / buildings value w.r.t NPV. An important point to note is that the current model requires higher growth rate in order to be feasible (i.e. positive NPV).
​
Tools/Techniques
1) Normal Excel Functions
2) Excel's Financial Functions
3) Data Tables
4) Excel Charts
bottom of page