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

Glossary Item Box

IPMT


Name

Interest payment

Description

Calculates the payment of interest on a loan.

Syntax

IPMT(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)

Data Type

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

Example

IPMT(0.65,A1,B3,C42)
IPMT(R1C1,R12C12,R13C13,R32C1)
IPMT(0.45,2,30,6000)=-2699.98

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