do you guys know hot to d o it

A1 X A B C D E F G H 1 J K L M ham tono a You have been hired as a financial advisor to J. Winston. He has received two offers from the New Orleans Saints and wants to select the best offer. Offer A is an contract for $2 a year for 5 years. Offer B is an contract of $1.25 a year for four years and $7 in year 5. Which is the best offer based on the present value of cash flows? Assume a discount rate of 15% (cell B13). Fill in the cash flow cells and calculate the NPV for each offer. Choose the best offer (cell D19, drop down menu). 9 11 Discount rate Offer A Year 1 2 3 4 5 NPV CF 12 13 14 15 Year 1 2 3 4 5 Offer B NPV 16 CF 17 18 Which offer is best? (Choose A or B) 19 20 21