NPer(Rate: Double;
PeriodPayment; Double;
PresentValue: Double;
FutureValue: Double;
Type: Integer): Double;
Parameters | Description | Constraints |
Rate | Interest rate for a period. | Cannot be negative. |
PeriodPayment | The payment, made each period; this value cannot change during the whole payments period. The payment usually consists of the primary payment and the interest payment, and does not include taxes. | |
PresentValue | Present net value or the total sum, which is currently equal to the set of future payments. | |
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 value 0 or 1. |
The NPer method returns the number of periods of payment for investments based on periodic regular payments and constant interest rate.
NPer 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.NPer(0.011, -100, -800, 5000, 0);
Debug.WriteLine(r);
End Sub UserProc;
After executing the example the console window displays the total number of settlement periods equal to 32.35.
See also: