CUMPRINC

Definition: CUMPRINC is a function that returns the cumulative principal paid on a loan between two periods.

Syntax: =CUMPRINC(rate, nper, pv, start_period, end_period, type)

Situation: This formula is suitable when you need to calculate the cumulative principal paid on a loan between two periods.

Example: If you have a loan with a principal value of $100,000, an interest rate of 5%, a term of 20 years, and want to calculate the cumulative principal paid between the 1st and 10th year, the formula =CUMPRINC(5%/12, 20*12, 100000, 1, 10, 0) can be used.