IFinance.Ispmt

Fore Syntax

Ispmt(Rate: Double;

Period: Integer;

PeriodCount: Integer;

PresentValue: Double): Double;

Fore.NET 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:

Fore Example

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

Sub UserProc;
Var
    r: Double;
Begin
    r := Finance.Ispmt(0.15, 1, 12, 1200);
    Debug.WriteLine(r);
End Sub UserProc;

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

Fore.NET Example

The requirements and result of the Fore.NET example execution match with those in the Fore example.

Imports Prognoz.Platform.Interop.MathFin;
…
Public Shared Sub Main(Params: StartParams);
Var
    r: double;
    Finance: FinanceClass = New FinanceClass();
Begin
    r := Finance.Ispmt(0.15, 1, 12, 1200);
    System.Diagnostics.Debug.WriteLine(r);
End Sub;