Ispmt

Syntax

Ispmt(Rate, Period, PeriodCount, PresentValue)

Parameters

Rate. Interest rate per period.

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

PeriodCount. Total number of payment periods in an investment.

PresentValue. The present value of the investment. For a loan, PresentValue is the loan sum.

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

Description

It returns an interest paid over the specified investment period.

Comments

All the arguments, 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

=Ispmt(0.15, 1, 12, 1200)

-165,00

Interests paid over the specified investment period based on the following terms:

The interest rate over the period is 0.15.
Period 1.
The total number of periods is 12.
The value of investments is 1200.

=Ispmt(A0, 2, 14, B0)

-1120,96

Interests paid over the specified investment period based on the following terms:

The interest rate over the period is specified in the A0 cell (value: 0.9).
Period 2.
The total number of periods is 14.

The value of investments is specified in the B0 cell (value: 1453.1).