1. Sport agent B, negotiated a long-term sponsorship deal that called for yearly payments to an athlete of $120,000 for five years with a discount rate of 12%. What is the present value of the athlete's deal?

please show work in excel file or with screenshots thank you!