(Excel Formulas) Tebow Endeavors Inc. is evaluating two mutually exclusive investment projects. The firm has estimated the following net present values (NPV) and profitability indices (Pls) after performing scenario analysis using the following probabilities for each scenario. A B D E F 1 Project A Project B Scenario Probability NPVA PIA NPVB Pls 3 1 5% $1,260,000 1.63 $1,000,000 1.33 4 2 10% $960,000 1.48 $780,000 1.26 5 3 15% $660.000 1.33 $560,000 1.19 6 4 40% $360,000 1.18 $330,000 1.11 7 5 15% $61,000 1.03 $105,000 1.04 6 10% -$240,000 0,88 -$122,000 0.96 9 7 5% -$540,000 0.73 -$350,000 0.88 10 11 Expected Value $360,150 1.18 12 Variance 0.04 101,775,250,000 0.01 13 Standard Deviation 0.21 319,022 0.11 14 Coefficient of Variation 1.18 0.18 0.97 0.10 15 Prob(NPV/PI