please solve on excel and show the functions

5) Your annual salary is $120,000. You are offered three options for a severance package. Option 1 pays you 50% of your annual salary now. Option 2 pays you and your heirs $6,000 per year forever but the first payment will be at the end of the current year. Option 3 pays you and your heirs $5,300 per year forever and the first payment will start today. If your required return is 9.5%, which option should you choose? 8 points)