To do this, we set up CUMPRINC 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 CUMPRINC function returns 5,000, which matches the original loan value as expected.

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 interest

Excel CUMPRINC function