Sensitivity Analysis of NPV
Not what you're looking for?
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
Motivation
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.