header

Interest Paid

The total interest paid is the difference between what you get out of the investment (its present value which is the amount you borrow) and what you put into the investment (the series of equal payements). Since you are borrowing the money, you will put more in than you will get out:

I = n*Pmt - PV

  = B3*B8 - B9