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 - $68 million Below average 0.20 - $10 million Average 0.50 12 million Above average 0.20 24 million Boom 0.05 40 million

Explanation / Answer

Project A Standard Deviation of Cash flow $ in million Economin Scenarion Prob. NPV     ($ in million) Expected Cash flow Deviation from exp. Cahflow Square of deviation Variance a b c d= (bxc) e = c -7.40 f = e*e g = b x f Recession 0.05 -68 -3.40 -75.40 5685.16 284.258 Below Avearge 0.20 -10 -2.00 -17.40 302.76 60.552 Average 0.50 12 6.00 4.60 21.16 10.58 Above average 0.20 24 4.80 16.60 275.56 55.112 Boom 0.05 40 2.00 32.60 1062.76 53.138 Mean of cash flow 7.40 Total 463.64 E(NPV) 7.4 Variance = 463.6 Stad. Dev. of NPV = 21.53 Coefficient of variation = 2.91 = (Std. Dev /E(NPV)

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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