Scenario Analysis is a technique used to identify the project’s risk and compare the bad and good circumstances with the base case scenario. It considers both the 1) sensitivity of the project’s NPV to its key variables and 2) the change in values of these variables considering their probability distribution. To carry out the scenario analysis, it is required to calculate the NPV of worst case, best case and base case, followed by the calculation of its standard deviation and co-efficient of variation. If the co-efficient of variation is higher than the average project of the company, the project should be rejected. Expected NPV, Standard deviation of NPVs and co-efficient of variation of NPVs are calculated as below: Expected NPV = ∑ i = 1 n Pr i ( N P V i ) σ N P V = ∑ i = 1 n Pr i ( NPV i − Expected NPV ) 2 C V N P V = σ N P V Expected NPV Here, Probabilities of the occurrence is “ Pr i ” NPV for each probability is “ N P V i ” Standard deviation of NPVs is “ σ N P V ” Co-efficient of Variation of NPVs is “ C V N P V ” After conducting a scenario analysis, it is estimated, that the NPV of the project for all the three scenarios is as follows. Determine whether the project should be accepted or rejected if the maximum allowable co-efficient of variation is 0.8. Scenario Probability NPV Best Case 20% $31,500 Base Case 70% $19,800 Worst Case 10% -$20,100

Question

Want to see the full answer?

Answer 1

Question

Chapter 10, Problem 17PROB

Summary Introduction

Scenario Analysis is a technique used to identify the project’s risk and compare the bad and good circumstances with the base case scenario. It considers both the 1) sensitivity of the project’s NPV to its key variables and 2) the change in values of these variables considering their probability distribution.

To carry out the scenario analysis, it is required to calculate the NPV of worst case, best case and base case, followed by the calculation of its standard deviation and co-efficient of variation. If the co-efficient of variation is higher than the average project of the company, the project should be rejected.

Expected NPV, Standard deviation of NPVs and co-efficient of variation of NPVs are calculated as below:

Expected NPV=∑i=1nPri(NPVi) σNPV=∑i=1nPri(NPVi−Expected NPV)2 CVNPV=σNPVExpected NPV

Here,

Probabilities of the occurrence is “Pri”

NPV for each probability is “NPVi”

Standard deviation of NPVs is “σNPV”

Co-efficient of Variation of NPVs is “CVNPV”

After conducting a scenario analysis, it is estimated, that the NPV of the project for all the three scenarios is as follows. Determine whether the project should be accepted or rejected if the maximum allowable co-efficient of variation is 0.8.

Scenario Probability NPV

Best Case 20% $31,500

Base Case 70% $19,800

Worst Case 10% -$20,100

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Answer in step by step with explanation. Don't use Ai and chatgpt.

Article: Current Bank Problem Statement The general problem to be surveyed is that leaders lack an understanding of how to address job demands, resulting in an increase in voluntary termination, counterproductive workplace outcomes, and a loss of customers. Bank leaders discovered from customer surveys that customers are closing accounts because their rates are not competitive with area credit unions. Job demands such as a heavy workload interfered with employee performance, leading to decreased job performance. Healthcare employees who felt the organization’s benefits were not competitive were more likely to quit without notice, resulting in retention issues for the organization. Information technology leaders who provide job resources to offset job demand have seen an increase in (a) new accounts, (b) employee productivity, (c) positive workplace culture, and (d) employee retention. The specific problem to be addressed is that IT technology leaders in the information technology…

How to rewrite the problem statement, correcting the identified errors of the Business Problem Information and the current Bank Problem Statement (for the discussion: Evaluating a Problem Statement)