How to use Excel CUMPRINC Function

Introduction:-

CUMPRINC function in excel is a financial function. It is used to find cumulative principal of a loan between the start and end period. It is a worksheet function and can be entered in the cell in which value is required.

Syntax:-

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

Arguments:-

  • Rate: It is the rate of the required loan.
  • NPER: It is the number of payment periods.
  • PV: It is the present value.
  • Start_Period: First period to be used in the calculation.
  • End_Period: Last period to be used in the calculation.
  • Type: It is the timing of the payment.

Keynotes:-

  • Microsoft Excel stores dates as serial numbers . By default, January 1, 1900 is serial number 1 and corresponding dates have serial number greater than 1.
  • If Rate ≤ 0 and  nper ≤ 0, or pv ≤ 0, #NUM! error is displayed.
  • If start_period < 1, end_period < 1, or start_period > end_period, #NUM! error is displayed.
  • If Type argument is a different value from 0 or 1, #NUM! error is displayed.

Examples

In this example, various arguments are entered in column A and their values are entered in column B , the required cumulative principal is entered using formula CUMPRINC in column D.

Leave a Reply

Close Menu
×

Cart