Ispmt(Rate: Double;
Period: Integer;
PeriodCount: Integer;
PresentValue: Double): Double;
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. |
The Ispmt method returns interest, paid for the specified investment period.
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:
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.
See also: