Total$/$sum the yearly payments across all $10$ years in cells C$12$ and D$12.$

Compute the present discounted value of contract $1$ using the present discounted value formula in cell F$2.$

Compute the present discounted value of contract $2$ using the excel function net present value in cell F$3.$

Compute the present discounted value of contract $1$ using the present discounted value formula in cell G$2.$

Compute the present discounted value of contract $2$ using the excel function net present value in cell G$3.$

Comment on which $10$ year contract you would accept. Put your response in cell F$5.$