Step Instruction

The next column is designed to calculate the interest amount per payment.

In cell D$8,$ insert the IPMT function using the periodic rate, the current payment number in the

first column, the number of payments, and loan. Use relative and mixed references correctly.

Make sure the result is a positive value. Copy the function to the range D$9$:D$43.$