Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for Functions

CUMPRINC

Description: Returns the cumulative principal paid on a loan between two periods.

Syntax: CUMPRINC(Rate, Nper, PV, Start_Period, End_Period, Type)

• Rate is the interest rate in decimals.

• Nper is the total number of payment periods.

• PV is the present value.

• Start_Period is the first period in the calculation. Payment periods are numbered beginning with 1.

• End_Period is the last period in the calculation.

• Type is the timing of the payment.

Remarks:

• Make sure that you are consistent about the units you use for specifying Rate and Nper. If you make monthly payments on a four-year loan at an annual interest rate of 12 percent, use 0.12/12 for Rate and 4*12 for Nper. If you make annual payments on the same loan, use 0.12 for Rate and 4 for Nper.

• Nper, Start_Period and End_Period must be integers.

• Rate, Nper and PV must be >= 0.

• Start_Period and End_Period must be >= 1 and Start_Period <= End_Period.

• Type must be either 0 or 1.

Example:

• The total principal paid in the second year of payments, periods 13 through 24.

CUMPRINC(.09/12, 30*12, 125000, 13, 24, 0) = -934.1071