pexels-mikael-blomkvist-6476589_edited.jpg

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