[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

CUMPRINC

Syntax:

CUMPRINC ( rate , nper , pv , start-period , end-period , type )

Description: Computes the cumulative principal paid on a loan between start-period and end-period.

Arguments:

Name

Type

Description

rate

number

The interest rate.

nper

number

The total number of payment periods, truncated to integer.

pv

number

The present value.

start-period

number

The first period in the calculation. (Payment periods are numbered beginning with 1.)

end-period

number

The last period in the calculation.

type

number

The timing of the payment, truncated to integer, as follows:

Value

Timing

0

Payment at the end of the period

1

Payment at the beginning of the period

 

 

Time information in the date arguments is ignored.

Return Type and Value: number – The cumulative principal paid on a loan.

However, if

rate, nper, or pv ≤ 0, #NUM! is returned.

start-period < 1 or end-period < 1, or start-period end_period, #NUM! is returned.

type is any number other than 0 or 1, #NUM! is returned.

[Example:

CUMPRINC(0.09/12,30*12,125000,13,24,0) results in -934.11
CUMPRINC(0.09/12,30*12,125000,1,1,0) results in -68.28

end example]