NPV Sensitivity Analysis: A Dynamic Excel Approach

Autor/inn/en	Mangiero, George A.; Kraten, Michael
Titel	NPV Sensitivity Analysis: A Dynamic Excel Approach
Quelle	In: American Journal of Business Education, 10 (2017) 3, S.113-126 (14 Seiten) PDF als Volltext kostenfreie Datei Verfügbarkeit
Sprache	englisch
Dokumenttyp	gedruckt; online; Zeitschriftenaufsatz
ISSN	1942-2504
Schlagwörter	Predictor Variables; Visual Aids; Computer Graphics; Business Administration Education; Computation; Probability; Mathematical Formulas; Courseware; Spreadsheets; Money Management; Teaching Methods; Statistical Analysis; Investment; Higher Education + Suchen Sie Ihr Suchwort? Prädiktor; Anschauungsmaterial; Computergrafik; Wahrscheinlichkeitsrechnung; Wahrscheinlichkeitstheorie; Mathematische Formel; Lernsoftware; Spread sheet; Spredsheets; Spreadsheet; Tabellenkalkulation; Teaching method; Lehrmethode; Unterrichtsmethode; Statistische Analyse; Investments; Geldanlage; Investiton; Hochschulbildung; Hochschulsystem; Hochschulwesen
Abstract	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. (As Provided).
Anmerkungen	Clute Institute. 6901 South Pierce Street Suite 239, Littleton, CO 80128. Tel: 303-904-4750; Fax: 303-978-0413; e-mail: Staff@CluteInstitute.com; Web site: http://www.cluteinstitute.com
Erfasst von	ERIC (Education Resources Information Center), Washington, DC
Update	2020/1/01