show all work please with excel functions

Choosing the best annuity Personal Finance Problem Raina Herzig wishes to choose the best of four annuities available to her. In each case, in exchange for paying a lump sum today, she will receive equal, end-of-year cash payments for a specified number of years. She considers the annuities to be equally risky and is not concerned about their differing lives. Her decision will be based solely on the rate of return she will earn on each annuity. The key terms of the four annuities are shown in the following table, a. Calculate the rate of return on each of the four annuities Raina is considering. b. Given Raina's stated decision criterion, which annuity would you recommend? a. The rate of retum, r, on annuity A is %. (Round to two decimal places.) (Cliek on the icon here pi in order to copy the contents of the data table below into a spreadsheet.)