Ppmt(Rate: Double;
Period: Integer;
PeriodCount: Integer;
PresentValue: Double;
FutureValue: Double;
Type: Integer): Double;
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. |
The Ppmt method returns a sum of regular payments for the investment, if the payment sums are equal and the interest rate is constant.
Ppmt is calculated using the following formula:
Where Pmt - monthly payment on loan.
To get monthly payment on loan, use the IFinance.Pmt method.
To execute the example, add a link to the MathFin system assembly.
Sub UserProc;
Var
r: Double;
Begin
r := Finance.Ppmt(0.01, 3, 12, 50000, 0, 0);
Debug.WriteLine(r);
End Sub UserProc;
After executing the example the console window displays the payment value equal to -4021.683.
See also: