Pmt(
Rate: Double;
PeriodCount: Integer;
PresentValue: Double;
FutureValue: Double;
Type: Integer): Double;
Parameters | Description | Constraints |
Rate | Loan interest rate. | Cannot be negative. |
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 Pmt method returns a sum of regular annuity payments, if the payment sums are equal and the interest rate is constant.
Pmt 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.Pmt(0.01, 12, 50000, 0, 0);
Debug.WriteLine(r);
End Sub UserProc;
After executing the example the console window displays the sum of periodic payment equal to -4442.43.
See also: