Spread 8.0 Documentation
PPMT
Support Options
Formula Reference > Built-In Functions > PPMT

Glossary Item Box

PPMT


Name

Principal payment

Description

Returns the amount of payment of principal for a loan given the present value, specified interest rate, and number of terms.

Syntax

PPMT(rate,per,nper,pval,fval,type)

Remarks

The result is represented by a negative number because it is money paid out by you.

This function has the following arguments:

Argument Description
rate Value of interest rate per period
per Number of the period for which to find the interest, between 1 and nper
nper Total number of payment periods in an annuity
pval Present value, worth now
fval [Optional] Future value, cash value after the last payment; if omitted, the calculation uses zero
type [Optional] Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0)

Express the interest rate as per annum. For example, if the interest rate is 8 percent, use 8 for the rate argument.

Data Type

Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

PPMT(B1,C4,C6,C7,1)
PPMT(R1C2,R4C3,R6C3,R7C3,0)
PPMT(0.45,22,30,6000,7000)=-206.47

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.