help me evaluate a scenario analysis using expected NPV, standard deviation , and coefficient of variation. I want to be able to input the following on excel and how to do it.

• Best case NPV and probability
• Base case NPV and probability
• Worst case NPV and probability

And the worksheet must show the right expected NPV, standard deviation, and coefficient of variation.

thank you

data, scenario can be made up