Solve using excel

Format Painter LE y Merge & Center Clipboard Font Alignment J22 D E F G H K 2 Samantha's utility function is U(Y) = 105. She tries to maximize her expected utility. She owns a car for business 3 that she will have to replace if it is stolen. If her car is not stolen, her net income will be $122,500. If the car is stolen, her net income will be reduced by the car's replacement cost of $20,100. The probability that the car will be stolen is 20%. Use Excel to answer the following questions. 6 8 19 c. If Samantha buys insurance, how much would the insurance company gain in expected value if the anti-theft 10 device was installed in Samantha's car? 11 12 13 Insurance Company's income, payout and profit 14 No anti-theft device installed 15 Outcome Probability Income Payout Profit 16 No Loss 0.8 4090 17 Loss 0.2 4090 18 Expected Value of profit 19 20 Anti-theft device installed 21 Outcome Probability Income Payout Profit 22 No Loss 0.9 23 Loss 0.1 24 Expected value of profit 25 26 Insurance company's gain from anti-theft device 27 28 29