Column $E$ is to display the portion of the payment that goes toward paying down the

principal.

In cell E$8,$ insert the PPMT function using the same arguments that you used for the IMPT

function. Copy the function to the range E$9$:E$43.$