To do this, we set up CUMIPMT like this:

rate- The interest rate per period.

pv- The present value, or total value of all payments now, 5000, from cell C5.

end_period- the last period of interest, 60 in this case for the full loan term.

Excel formula: Calculate interest for given period

With these inputs, the CUMIPMT function returns -592.91, the total interest paid for the loan.

Excel formula: Calculate principal for given period

Excel formula: Calculate interest rate for loan

Excel formula: Calculate original loan amount

Excel formula: Calculate payment for a loan

Excel formula: Calculate payment periods for loan

Excel formula: Calculate cumulative loan principal payments

Excel CUMIPMT function