Essay
Suppose that the forecasted price levels shown in the pro forma cash flow sheet are not deterministic, but rather, are expected to fluctuate due to market forces. The prices are expected to be normally distributed in each year, with the means equal to the expected values shown in the pro forma, but with standard deviations of $5.2, $5.3, and $5.5 in years 1, 2, and 3, respectively. Enter this pro forma in an Excel worksheet, with the appropriate @RISK functions for the random prices, and simulate 1,000 iterations. What is the expected NPV now? Would you recommend investing in this project? Explain.
Correct Answer:
Verified
The mean NPV will still be app...View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Correct Answer:
Verified
View Answer
Unlock this answer now
Get Access to more Verified Answers free of charge
Q7: Churn is an example of the type
Q10: A @RISK output range allows us to
Q22: RISKMAX and RISKMIN are can be used
Q24: Suppose first that all three bidders are
Q26: What is the probability of winning for
Q27: The value at risk (VAR) is typically
Q31: In Excel<sup>®</sup>, we can use the RAND
Q33: Suppose that a customer satisfaction firm approaches
Q39: Using @RISK summary functions such as RISKMEAN,RISKPERCENTILE,and
Q51: In a manufacturing model,we might simulate the