Question

Scenario Analysis Shao Industries is considering a proposed project for its capital budget, The company estimates the project's NPV is $12 million. This estimate assumes that the economy and market conditions will be average over the next few years. The company's CFO, however, forecasts there is only a 50% chance that the economy will be average. Recognizing this uncertainty, she has also performed the following scenario analysis: Economic Scenario Probability of Outcome NPV Recession -$84 million 0.05 0.20 Below average -10 million Average 0.50 12 million Above average 0.20 16 million Boom 0.05 34 million What is the project's expected NPV, its standard deviation, and its coefficient of variation? Enter your answers for the NPV and standard deviation in millions. For example, an answer of $1.2 million should be entered as 1.2, not 1,200,000. Round your answers to two decimal places. E(NPV) million ONPV million CV|py

Answer 1

SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE

- 2x m Find & Select L CM CN CO CP CQ CR CS CT CU CVE 53 0.2 STATS - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Add-Ins % Cut Σ AutoSum : A Calibri -11AA = = = Dr Wrap Text General Ea Copy Fill 2 Paste B I U - D SF A Merge Merge & Center Center Format Painter $ - % % 4:0 .00 8.9 Conditional Format Cell Insert Delete Format Sort & Formatting as Table Styles 2 Clear Filter Clipboard Font Alignment Number Styles Cells Editing CR50 L CH CI CO C K 49 50 ECONOMIC EXPECTED VARIANCE 51 SCENARIO PROB NPV NPV PROB*(NPV-E(NPV))^2 52 RECESSION 0.05 -84.00 -4.20 393.3845 BELOW AVERAGE -10.00 -2.00 43.2180 AVERAGE 0.5 12.00 6.00 26.6450 55 ABOVE AVERAGE 0.2 16.00 3.20 25.5380 56 BOOM 0.05 34.00 1.70 42.9245 57 58 ANS 1 EXPECTED NPV = 4.70 E(NPV) 60 61 VARIANCE 531.7100 ANS 2 STANDARD DEVIATION = 23.06 [SQRT(VARIANCE)] 63 ANS 3 COEFFICIENT OF VARIATION = 4.91 [23.0588/4.70] 64 [STANDARD DEVIATION/EXPECTED NPV] 65 54 59 62 66 67 H P V FV DIVIDEND ferences EMV MEAN STDV assignment DEAR Sheet2 COV TIME SERIES corr REGRESSION range CAMERA TREND freg_MATRIX INTERVAL, NORMAL BO HYPOTHIC 130% _ Red 0 + DO 4 * 410 ENG 05-11-2019