Question: please i need the excel file Pane 2- Debbie Gibson is considering three investment options for a small inheritance that she has just received -

please i need the excel file
please i need the excel file Pane 2- Debbie Gibson is considering
three investment options for a small inheritance that she has just received

Pane 2- Debbie Gibson is considering three investment options for a small inheritance that she has just received - stocks, bonds, and money market. The return on her investment will depend on the performance of the economy, which can be strong, average, or weak. The returns for each possible combination are shown in the following table: Investment Strong Average Weak Stocks 12% 6% -10% Bonds 7% 4% 1% Money market 4% 3% 2% Assume that Debbie will choose only one of the investment options. a) Which investment should Debbie choose if she uses the maximax criterion? b) Which investment should Debbie choose if she uses the maximin criterion? c) Which investment should Debbie choose if she uses the equally likely criterion? d) Which investment should Debbie choose if she uses the criterion of realism with a = 0.52 e) Which investment should Debbic choose if she uses the minimax regret criterion? Page 2 of 2 405 words LE Filme Home insert Draw Page Layou Arial v 10 ' ' == ab & Wrap Text Paste yv a.A Merge & Center $ E11 4 Xv fx B D E F G H K L M N 1 2 PAYOFFS 3 Alternatives 4 Stocks 5 Bonds 6 Money Market Outcomes (a) MaxImax (b) Maximin (c) Equally Likely Strong Average Weak Maximum Choice Minimum Choice Average Choice (d) Hurwicz Realism Choice Outcomes Minimax Strong Average Woak Maximum Choice 8 9 REGRET 10 Alternatives 11 Stocks 12 Bonds 13 Money Market 14 15 10 17 18 19 20 21 22 23 24

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!