In: Finance
A project's base case or most likely NPV is $44,000, and assume its probability of occurrence is 50%. Assume the best case scenario NPV is 65% higher than the base case and assume the worst scenario NPV is 35% lower than the base case. Both the best case scenario and the worst case scenario have a 25% probability of occurrence. Find the project's coefficient of variation. Enter your answer rounded to two decimal places. For example, if your answer is 123.45% or 1.2345 then enter as 1.23 in the answer box.
Base case NPV = | 44000 | Probability | 50% | |
Best case NPV is 65% higher than base case. |
||||
So Best case NPV = 44000+ 44000*65% | 72600 | Probability | 25% | |
Worst case NPV is 35% lower than base case |
||||
So, Worst case NPV = 44000-(44000*35%) | 28600 | Probability | 25% | |
Average Return formula in case of Probability = sum of (Probability* NPV) |
||||
Standard deviation = √((∑ (actual NPV -Average NPV)^2*Probability) |
||||
Coefficient of variation = Standard deviation / Average return |
||||
Probability | NPV | NPV *Prob. |
(Actual NPV - Average NPV)^2 * probaility |
|
Base case | 50% | 44000 | 22000 | 5445000 |
Best case | 25% | 72600 | 18150 | 160022500 |
Worst case | 25% | 28600 | 7150 | 87422500 |
Total= | 47300 | 252890000 | ||
Average return = | 47300 | |||
Standard deviation = √(252890000) |
||||
15902.51552 | ||||
Coefficient of variation = 15902.51552/47300 = | 0.3362054022 | |||
So, coefficient of variation is 0.34 |
please thumbs up.