NPV

Returns the Net Present Value of an investment, based on a supplied discount rate,
and a series of future payments and income.
=NPV(B1, B2:B7)
NPV() Result is $196.88
=NPV(C1, C3:C7) + C2
NPV() Result is $2,678.68