0.47 1 Scenario 2 Worst Case 3 Base Case Best Case 3 Expected NPV Probabilities Net Present Value 20% (152,000) 60% 87,352 20% 239,352 Which is the right formula for B5? All are correct -B2C2+B3*C3+B4%C4 -SUMPRODUCT(B2:B4,C2:04) OO O T-SUM(C2C4B2:B4)) Next 0 i & 3 5 6 7 8 9 D. 0 E R. T LY U o P. ents D Question 2 0.4 pts ons 1 Scenario 2 Worst Case 3 Base Case Best Case $ Expected NPV 6 Standard Deviation 7 Prob(NPV) Probabilities Net Present Value 2046 (152,000) 6046 87,352 239,352 69,881.60 126,131,33 ? 209 JS erences 360 Recordings What is the correct formula in B7 to determine the probability of rejecting the project? ary Resources =NORM.DISTO.C5,C6,TRUE) Both are correct O-NORM.S.DIST((0-C5)/C6,TRUE) Previous Next Type here to search 3 18 0 E Y U P