Purchase Solution

Sensitivity Analysis of NPV

Not what you're looking for?

Ask Custom Question

See the attached file.

Sensitivity Analysis is an analysis of a change in NPV when a key input variable is changed and all other variables stay the same.

Key variables can change a NPV (return) of a project. The graphing of this data indicates the degree of risk of each variable to the analysis.

Take the information and analysis presented in the attached excel file. Look at the Base Case and present a sensitivity analysis with the following variables and inputs:
% change variables: +25%,+20%,+15%,+10%, +5%, 0%
(Base Case), -5%, -10%,-15%,-20%, -25%

Sensitivity variables:
1). Selling Price per Unit
2). Variable Cost Per Unit
3). Salvage Value
4). WACC

a) Include a spreadsheet file with the analysis,
b) including a graph of the sensitivity/NPV review.
c) Along with a brief written review of what this analysis tells you about the project.

Purchase this Solution

Solution Summary

This response presents a sensitivity analysis of Selling Price per Unit, Variable Cost Per Unit, Salvage Value and WACC.

Solution Preview

Kindly find attached tutorial having some ideas, references and content related to sensitivity analysis

This response should be useful for you to develop better understanding with regard to the given topics. Kindly use this work for your reference only and please do not use this content in your assignment or homework.

Sensitivity Analysis of the Project
On the basis of sensitivity analysis, it is identified that there is a significant impact of changing sales price per unit on NPV of the project. When sales price per unit increases, ...

Purchase this Solution

Free BrainMass Quizzes

This tests some key elements of major motivation theories.

Operations Management

This quiz tests a student's knowledge about Operations Management

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Paradigms and Frameworks of Management Research

This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.