need help with this question. 1a and 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, Julle would receive a lump sum of $131,000 immediately as her fun retirement benefit. Under the second option she would receive $20,000 each year for thirteen years plus a lump-sum payment of $50.000 at the end of the thirteen-year period Use Excel or a financial calculator to solve. Round answers to the nearest dollar Required: 1a. Calculate the present value for the following assuming that the money can be invested at 14%. Present Value of First Option Lump-sum payment Present Value of Second Option Total present value Required: 1a Calculate the present value for the following assuming that the money can be invested at 14% Present Value of First Option Lump-sum payment Present Value of Second Option Total present value N 1b. If you can invest money at a 14% return, which option would you prefer? O First option Second option