Please help me with the necessary steps, and the excel formulas you used.

1A

1B

Julie has just retired. Her company's retirement program has two options as to how retirement benefits can be received. Under the first option, Julie would receive a lump sum of $131,000 immediately as her full retirement benefit. Under the second option, she would receive $20,000 each year for 13 years plus a lump-sum payment of $50,000 at the end of the 13-year period. Required: 1-a. Calculate the present value for the following assuming that the money can be invested at 14%. 1-b. If she can invest money at 14%, which option would you recommend that she accept? Complete this question by entering your answers in the tabs below. Calculate the present value for the following assuming that the money can be invested at 14%. (Round your final answer to the nearest whole dollar amount.) Required: 1-a. Calculate the present value for the following assuming that the money can be invested at 14%. 1-b. If she can invest money at 14%, which option would you recommend that she accept? Complete this question by entering your answers in the tabs below. If she can invest money at 14%, which option would you recommend that she accept? First option Second option