Please answer part b, c, and d based on the stipulations posted below the question!

Hometown Insurance sells 10-year annuities to retirees who are looking for stable sources of investment income. Hometown invests the annuity funds it receives in an equity index fund with annual returns that are normally distributed with a mean of 9% and standard deviation of 3%. It guarantees investors a minimum annual return of 6% and a maximum return (or rate cap) of 8.5%. This limits both the retir- ees' down-side risk and up-side return potential. Of course, Hometown makes its money on these contracts when the actual return exceeds the rate cap. Suppose a retiree invests $50,000 in such an annuity contract. Assume investment earnings are credited at the end of the year and are reinvested. a. Build a spreadsheet model for this problem that computes the profit Hometown would make on the contract. b. How much money can Hometown expect to make on average on the contract? c. What is the probability that Hometown would lose money on the contract? d. Suppose that Hometown wants to identify the minimum guaranteed annual rate of return that provides a 2% chance of the company losing money on the con- tract. What should the minimum guaranteed annual rate of return be? Problem 12.11.b. Use 10,000 trials for the simulation. Problem 12.11.c. Use 10,000 trials for the simulation. Problem 12.11.d. Use 10,000 trials for the simulation. Also, use the "Interactive simulation" mode. Express your answer as a fraction, e.g., if you thought the minimum rate was 2.3%, then enter.023