G A A. % Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Office Update To keep up-to-date with security updates, fixes, and improvement... E11 B D E F 1 P12.7 SCENARIO ANALYSIS Huang Industries is considering a 2 proposed project whose estimated NPV is $13.27 million. This 3 estimate assumes that economic conditions will be "average." 4 5 However, the CFO realizes that conditions could be better or 6 worse, so she performed a scenario analysis and obtained the 7 following results. Calculate the expected value, variance, standard 8 deviation, and coefficient of variation. 9 10 Economic Scenario Probability NPV 11 Recession 0.0700 -$35.00 12 Below average 0.1500 $25.00 13 Average 0.5300 $13.27 14 Above average 0.1800 + $20.00 15 Boom 0.0700 $30.00 16 17 18 19 20 21 22