Returns the number of payments required to pay off a capital according to a given rate.

Example

// Number of necessary payments: the amount of payments // is set to 7500 Euros, // the interest rate is set to 5% and the amount borrowed is // set to 42000 Euros. ResNbPayment = FinPaymentNb(-7500, 5, 42000)

Syntax

<Result> = FinPaymentNb([<Value of payment> [, <Rate> [, <Capital>]]])

<Result>: Real

Number of payments to perform. This number can be:

negative: a payment must be made;

positive: a credit must be made.

<Value of payment>: Optional real or currency

Value of payment (0 by default). For a credit, this value must be negative.

<Rate>: Optional real

Interest rate, expressed in percentage (1 by default). For example, for a 5% rate, this parameter will be set to 5.

<Capital>: Optional real or currency

Amount of loan (1 by default).

Remarks

Caution: FinPaymentNb returns no error code. To determine if this function has generated errors, use FinError. To get more details on the error, use ErrorInfo with the errMessage constant.

Related Examples:

Unit examples (WINDEV): The financial functions

[ + ] Using the main functions for performing financial calculations in WINDEV: - Calculate the number of repayments - Calculate the future value of an investment

Unit examples (WEBDEV): The financial functions

[ + ] This example presents the main functions for financial calculations of WEBDEV and it allows you to: - Calculate the number of reimbursements - Calculate the future value of an investment

Unit examples (WINDEV Mobile): The Financial functions

[ + ] Use of financial functions. This example calculates the number of payments needed to pay back a loan, the total cost of a loan as well as the interests returned by an investment.