Probability $10\%,$ NPV A is $-59,670,$ NPV B is $-22,377$

Probability $20\%,$ NPV A is $-14,918,$ NPV B is $3,729$

Probability $40\%,$ NPV A is $29,835,$ NPV B is $29,835$

Probability $20\%,$ NPV A is $74,588,$ NPV B is $55,941$

Probability $10\%,$ NPV A is $119,340,$ NPV B is $82,047$

Probability $20\%,$ NPV A is $-14,918,$ NPV B is $3,729$

A$.$ Calculate the expected NPV for both projects. Can the question be resolved with this information alone?

B$.$ Calculate the variance and standard deviation of the NPVs for both projects. Which project appears to be riskier?

c$.$ Calculate the coefficient of variation for both projects. Does this change your opinion from part b$?$

d$.$ Calculate the probability of a negative NPV for both projects.

e$.$ Which project should be accepted? Why?

Please show excel sheet with All formulas for each part.