Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help with this finance question and what does it mean? 152 153 c. Now conduct a scenario analysis. Assume that there is a 25%
Please help with this finance question and what does it mean?
152 153 c. Now conduct a scenario analysis. Assume that there is a 25% probability that best-case conditions, with each of the 154 variables discussed in Part b being 20% better than its base-case value, will occur. There is a 25% probability of worst-case 155 conditions, with the variables 20% worse than base, and a 50% probability of base-case conditions. (Hint: Use Scenario 156 Manager. Go to the Data menu, choose What-If-Analyis, the choose Scenario Manager. After you create the Scenario's, 157 you can pick a scenario and type in the resulting NPV (but be sure to return the Scenario to the base-case afterward). Or 158 you can create a Scenario Summary and use a cell reference to the Scenario Summary worksheet to show the NPV for each 159 scenario.) Variable Costs per Unit Scenario Sales Price per Unit Probability Unit Sales NPV 160 161 162 163 164 165 166 167 168 169 170 171 172 173 Best Case Base Case Worst Case 25% 50% 25% 1,200 1,000 800 $28.80 $24.00 $19.20 $14.40 $18.00 $17.28 Expected NPV = Standard Deviation = Coefficient of Variation = Std Dev / Expected NPV = 152 153 c. Now conduct a scenario analysis. Assume that there is a 25% probability that best-case conditions, with each of the 154 variables discussed in Part b being 20% better than its base-case value, will occur. There is a 25% probability of worst-case 155 conditions, with the variables 20% worse than base, and a 50% probability of base-case conditions. (Hint: Use Scenario 156 Manager. Go to the Data menu, choose What-If-Analyis, the choose Scenario Manager. After you create the Scenario's, 157 you can pick a scenario and type in the resulting NPV (but be sure to return the Scenario to the base-case afterward). Or 158 you can create a Scenario Summary and use a cell reference to the Scenario Summary worksheet to show the NPV for each 159 scenario.) Variable Costs per Unit Scenario Sales Price per Unit Probability Unit Sales NPV 160 161 162 163 164 165 166 167 168 169 170 171 172 173 Best Case Base Case Worst Case 25% 50% 25% 1,200 1,000 800 $28.80 $24.00 $19.20 $14.40 $18.00 $17.28 Expected NPV = Standard Deviation = Coefficient of Variation = Std Dev / Expected NPV =Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started