Ipmt

Syntax

Ipmt(Rate, Period, PeriodCount, PresentValue, FutureValue, Type)

Parameters

Rate. Interest rate per period.

Period. The period, for which interest must be found. Value of this parameter is greater than zero and less or equal to value of the PeriodCount parameter.

PeriodCount. The total number of payment periods in an annuity.

PresentValue. The present value, or the total amount that a series of future payments is worth now.

FutureValue. The required value of future cost or the remainder after the last payment.

Type. Selecting payment time. The parameter may take the following values:

0. Payment at the end of the period.
1. Payment at the beginning of the period.

NOTE. To determine the parameter, specify either the parameter value or the cell address where it is located.

Description

It returns the interest payment for a given period for an investment, based on periodic, constant payments and a constant interest rate.

Comments

All the parameters, denoting money, which must be paid (for example, saving accounts), are represented as negative numbers; all the money, which must be received (for example, dividends), are represented as positive numbers.

Example

Formula

Result

Description

=Ipmt(0.15,12, 12, 1200, 1500, 0)

160,03

Sum of investment interest payments based on the following terms:

The interest rate over the period is 0.15.
The period is 12.
The total number of periods is 12.
The current value is 1200.
The required cost is 1500.
The payments are effected at the end of period.

=Ipmt(0.09,12, 14, A0, B0, 0)

53,15

Sum of investment interest payments based on the following terms:

The interest rate over the period is 0.09.
The period is 12.
The total number of periods is 14.

The current value is specified in the A0 cell, value is 1200.
The required value is specified in the B0 cell (value is 1453.1).
The payments are effected at the end of period.