Sensitivity Analysis is a term that conveys so much meaning it can easily be misunderstood. Most formulations in Excel are in the form of a computational flow from one input cell (or range) to another till we reach one (or more) result or output cells. If we have a portfolio model showing all our investments [...]
Excel 2003 does not use the overcharged term: “sensitivity.” Having avoided this trap, Excel falls into another. It has so many features that fall under Sensitivity Analysis that one remains ignorant of how much Excel can do in this area and where these facilities are.
For example, there is an entry on the Data menu called [...]
This post shows an example of NPV and IRR formulations using sensitivity analysis in Excel. Graphic representation show the cross over of NPV and hence give IRR directly.
21 queries / 0.135 seconds.