Please show Excel work. Thanks

Shao Industries is considering a proposed project for its capital budget. The company estimates the projects NPV is $12 million. This estimate assumes that the economy and market conditions will be average over the next few years. The companys 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	0.05	$70 million
Below average	0.20	25 million
Average	0.50	12 million
Above average	0.20	20 million
Boom	0.05	30 million

What are the projects expected NPV, standard deviation, and coefficient of variation?

Answer:

E[NPV] $3 million

NPV= $23.622 million *** Supposed to be In Problem 11-1 Part C, there is an error in the check figure from the publisher which should be correctly stated as $23.5 million. You need to describe why this number is correct.

CVNPV = 7.874