please show all work by hand

Question 2: (15 + 25 = 40 points) Savings Useful per Year Probability Life (years) Probability A robot has just been installed at a cost of $18,000 0.2 12 1/6 $81,000. Suppose its salvage value is zero. 20,000 0.7 2/3 22,000 0.1 1/6 (a) Define optimistic, most likely, and pessimistic scenarios by using both optimistic, both most likely, and both pessimistic estimates. What is the rate of return for each scenario? (b) Compute the expected rate of return. (Hint: you need to compute the rate of return for each combination of savings per year and life. Use Excel's IRR or RATE functions.)