Mayes & Co. is currently evaluating two mutually exclusive investments. After doing a scenario analysis and applying probabilities to each scenario, it has determined that the investments have the following distribution around the expected NPVs.

Probability	NPV(A)	NPV(B)
10%	$ (30,600.00)	$ (11,475.00)
20%	$ (7,650.00)	$ 1,913.00
40%	$ 15,300.00	$ 15,300.00
20%	$ 38,250.00	$ 28,688.00
10%	$ 61,200.00	$ 42,075.00

You were asked to determine which of the two projects should be accepted.

1. Calculate the expected NPV for each project.
2. Calculate the variance of the NPVs for each project
3. Calculate the standard deviation of the NPV for each project
4. Calculate the coefficient of variation for each project

Bonus:

1. Calculate the probability of a negative NPV for each project
2. Which project should be accepted and why?

Please show detailed steps and use Excel!!!!! WILL offer max points