IFinance.Ppmt

Syntax

Ppmt(Rate: Double;

Period: Integer;

PeriodCount: Integer;

PresentValue: Double;

FutureValue: Double;

Type: Integer): Double;

Parameters

Parameters Description Constraints
Rate Loan interest rate. Cannot be negative.
Period Period. Must be in the [1;PeriodCount] interval.
PeriodCount Total number of payments on a loan. Must be positive.
PresentValue Present net value or a total sum, which is currently equal to a set of future payments, also called a capital amount.  
FutureValue The required value of future cost, or the remainder after the last payment.  
Type Selecting time of payment:
0 - in the end of the period.
1 - in the beginning of the period.
Must take the values 0 or 1.

Description

The Ppmt method returns a sum of regular payments for the investment, if the payment sums are equal and the interest rate is constant.

Comments

Ppmt is calculated using the following formula:

Where Pmt - monthly payment on loan.

To get monthly payment on loan, use the IFinance.Pmt method.

Example

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

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

After executing the example the console window displays the payment value equal to -4021.683.

See also:

IFinance