In: Finance
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 $19,000 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.
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -
Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.