$20$

The next column is designed to display the interest portion of each payment.

In cell D$7,$ insert the IPMT function to calculate the interest fo: the first payment. Use mixed references for cells in the Basic Output Area and make sure the result is a positive value. Copy the function from cell $D7$ to the range $D8$:$D42.$

$21$ Next, you are ready to calculate the portion of the monthly payment that goes toward the principal.

In cell E$7,$ insert the PPMT function to calculate the principal portion of the first payment. Use mixed references for cells in the Basic Output Area and make sure the result is a positive value. Copy the function from cell $E7$ to the range $E8$:$E42$