Please explain/show how to get the answers to this question using excel.
The managers of Merton Medical Clinic are analyzing a proposed project. The project's most likely NPV is $120,000, but, as evidenced by the following NPV distribution, there is considerable risk involved:
Probability NPV
0.05 -700,000
0.2 -250,000
0.5 120,000
0.2 200,000
0.05 300,000
What are the project's expected NPV and standard deviation of NPV?