Syntax. CUMPRINC(Rate,Nper,Pv,Start_Period,End_Period,Type)

Definition. This function calculates the part of the repayment that is paid between two points in time when a loan is repaid as an annuity loan.


  • Rate (required) The nominal interest of the loan.

  • Nper (required) Specifies the total number of periods in which the loan is repaid.

  • Pv (required) Contains the loan amount.

  • Start_Period (required) The first period of the calculation.

  • End_Period (required) The last period.

  • Type (required) With the (by way of exception, required) maturity argument Type, you can specify whether the payments become interest effective at the start of the periods (Type = 1) or at the end of the periods (Type = 0).

If the values of function arguments (which ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.