What are the projects expected npv and standard deviation


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?

Solution Preview :

Prepared by a verified Expert
Finance Basics: What are the projects expected npv and standard deviation
Reference No:- TGS01597638

Now Priced at $10 (50% Discount)

Recommended (96%)

Rated (4.8/5)