Show all work in excel with formulas

8. Jimmy Football is retiring from his sport. Under terms defined by his professional league, Jimmy has a choice. He can receive either (a) monthly payments of $21,000 each for 20 years (240 total monthly payments) with the first monthly payment occurring precisely five years from today or (b) monthly payments of $18,425 each for 20 years (240 total monthly payments) with the first monthly payment occurring one month from today. A discount rate of 2.64%/year is appropriate for valuing these cash flows. An innovative investments firm in Dallas, TX wants to purchase the rights to this retirement package today. Jimmy is interested in selling the rights in exchange for a lump sum of cash today. Both parties agree on all information provided here. Calculate a fair price at which such an exchange could occur. 8. Jimmy Football is retiring from his sport. Under terms defined by his professional league, Jimmy has a choice. He can receive either (a) monthly payments of $21,000 each for 20 years (240 total monthly payments) with the first monthly payment occurring precisely five years from today or (b) monthly payments of $18,425 each for 20 years (240 total monthly payments) with the first monthly payment occurring one month from today. A discount rate of 2.64%/year is appropriate for valuing these cash flows. An innovative investments firm in Dallas, TX wants to purchase the rights to this retirement package today. Jimmy is interested in selling the rights in exchange for a lump sum of cash today. Both parties agree on all information provided here. Calculate a fair price at which such an exchange could occur