Spreadsheet 2. An individual is considering two investment projects. Project A will return a zero profit if conditions are poor, a profit of $4 if conditions are good, and a profit of $8 if conditions are excellent. Project B will return a profit of $2 if conditions are poor, a profit of $3 if conditions are good, and a profit of $4 if conditions are excellent. The probability distribution of conditions is as follows:

Conditions:      Poor            Good         Excellent

Probability:      40%             50%             10%

Using Excel, calculate the expected value of each project and identify the preferred project according to this criterion. (b) Assume that the individuals utility function for profit is U(X) = X - 0.05X². Calculate the expected utility of each project and identify the preferred project according to this criterion. (c) Is this individual risk averse, risk neutral, or risk seeking? Why?