Huang Industries is considering a proposed project whose estimated NPV is $12 mi

Question

Huang Industries is considering a proposed project whose estimated NPV is $12 million. This estimate assumes that economic conditions will be "average." However the CFO realizes that conditions could be better or worse, so she performed a scenario analysis and obtained these results:

Calculate the project's expected NPV, standard deviation, and coefficient of variation. Round your answers to two decimal places. Enter your answers for the project's expected NPV and standard deviation in millions. For example, an answer of $13,000,000 should be entered as 13.

Economic Scenario Probability of Outcome NPV Recession 0.05 - $48 million Below average 0.20 - $24 million Average 0.50 12 million Above average 0.20 22 million Boom 0.05 26 million

Explanation / Answer

Expected NPV = $ 4.50 Million

Variance = $ 412.75 Million

Standard Deviation = 412.75^(1/2) = $ 20.32 Million

coefficient of variation = SD/Mean * 100

coefficient of variation = 20.32/4.50 * 100 = 451.56

Working

Economic Scenario Probability of Outcome NPV A*B [NPV - Expected NPV]
B-4.50 D^2 E*A A B C D E F Recession 0.05 -48 $              (2.40) $                       (52.50) 2756.25                        137.81 Below average 0.2 -24 $              (4.80) $                       (28.50) 812.25                        162.45 Average 0.5 12 $                 6.00 $                            7.50 56.25                           28.13 Above average 0.2 22 $                 4.40 $                         17.50 306.25                           61.25 Boom 0.05 26 $                 1.30 $                         21.50 462.25                           23.11 Expected NPV $                 4.50 Variance $                    412.75

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.