next, you will calculate the principal paid. in cell d8, calculate the principal paid for the first payment using the ppmt function. copy the function to the range d9:d19.