To do this, we set up PPMT like this:
rate- The interest rate per period.
Supplied as 1 since we are interested in the principal amount of the first payment.
pv- The present value, or total value of all payments now.
Calculate interest for given period
To calculate the interest portion of a loan payment in a given period, you can use the IPMT function. In the example shown, the formula in C10 is: =IPMT(C6/12,1,C8,-C5)
