CUMPRINC Function

Originally published at: How to use the CUMPRINC Function in Excel - Excelbuddy.com

The CUMPRINC Function in Excel returns the cumulative principal paid on a loan between the start and end period. This is an excellent tool to quickly understand your total principle on a loan. Plus, it’s extremely easy to setup and use. Let’s take a look. Syntax: =CUMPRINC(rate, nper, pv, start_period, end_period, type) Arguments rate –…