Calculate the benefits for each year of each scenario and discount them in columns C and D$.$

Sum up these benefits to calculate the present value for each scenario.

Calculate the costs for each year of each scenario and discount them in columns F and G$.$

In row $25,$ calculate the net present value for each scenario by subtracted the appropriate discounted costs from each of the discounted benefits.