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).


1) Normal Excel Functions

2) Excel's Financial Functions

3) Data Tables

4) Excel Charts