**Please show Excel Formulas**

Question 3 (18 points) An investor is considering four different opportunities: A, B, C, or D. The payoff for each opportunity will depend on the economic conditions, represented in the payoff table below. Investment Payoff Table Economic Conditions Poor Average Good Excellent 50 75 20 30 80 15 40 300 -200 -80 25 0.35 0.5 0.1 0.05 B 10 D 25 25 Probability Part a) Give the maximax, maximin, and equal likelihood criterion. What investment would be made using these criterion? Note: Excel formulas not required. The maximax criterion: The maximin criterion: This leads to a decision of This leads to a decision of (Type A, B, C, or D.) (Type A, B, C, or D.) The equal likelihood criterion: This leads to a decision of (Type A, B, C, or D.) Part b) Given the probabilities in the last row of the payoff table above, compute the expected value for each investment. What investment would be made using the expected value criterion? Note: Excel formula not required for Cell H37. What investment would be made? (Type A, B, C, or D.) EV(A)= EV(B) = EV(C)= EV(D)= Part c) Given the probabilities in the last row of the payoff table above, compute the expected value of perfect information for each investment. What investment would be made using the expected value of perfect information? Note: Excel formula not required for Cell H49. What investment would be made? (Type A, B, C, or D.) EV using PI = EVPI(A) = EVPIB)= EVPI(C)= EVPI(D) = Part d) Fill in the regret for each investment and economic condition in the table below. Regret Table Economic Conditions Poor Average Good Excellent Investment B