IFinance.Ispmt

Syntax

Ispmt(Rate: Double;

Period: Integer;

PeriodCount: Integer;

PresentValue: Double): Double;

Parameters

Parameters Description Constraints
Rate Interest rate for a period.  
Period The period, for which profit has to be found. Must be in the [1;PeriodCount] interval.
PeriodCount Total number of periods of paying the annual rent. Must be positive.
PresentValue Current investments value. For a loan it is the loan sum.  

Description

The Ispmt method returns interest, paid for the specified investment period.

Comments

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

Ispmt is calculated using the following formula:

Example

To execute the example, add a link to the MathFin system assembly.

Sub UserProc;
Var
    r: Double;
Begin
    r := Finance.
Ispmt(0.151121200);
    Debug.WriteLine(r);
End Sub UserProc;

After executing the example the console window displays the percent equal to -165.

See also:

IFinance