NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
PDF on ERIC Download full text
ERIC Number: EJ1148254
Record Type: Journal
Publication Date: 2017
Pages: 14
Abstractor: As Provided
ISSN: ISSN-1942-2504
NPV Sensitivity Analysis: A Dynamic Excel Approach
Mangiero, George A.; Kraten, Michael
American Journal of Business Education, v10 n3 p113-126 2017
Financial analysts generally create static formulas for the computation of NPV. When they do so, however, it is not readily apparent how sensitive the value of NPV is to changes in multiple interdependent and interrelated variables. It is the aim of this paper to analyze this variability by employing a dynamic, visually graphic presentation using Excel. Our approach illustrates how these variables, when increased or decreased to reflect the potential range of values in a business case, change the value of NPV, and hence affect the decision about whether to proceed with the project or to reject it. Furthermore, since sales revenue is one of the least certain elements in the business case, the presentation includes a probability estimate of whether NPV will be positive or negative, assuming that sales revenue is normally distributed with a known mean and standard deviation. The business case we have chosen for illustrative purposes is a global energy project. Nevertheless, financial analysts in any industry should be able to apply our dynamic spreadsheet approach to their projects as well.
Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Descriptive
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A
Grant or Contract Numbers: N/A