FinRepayVal (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help

WLanguage

WLanguage functions

Standard functions

Numeric values management functions

Financial functions

FinRepayVal

Presentation

Example

Time unit

Managing errors

Related examples

See also

FinRepayVal (Function)

In french: FinValRemboursement

Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment.

Remark: The value returned by FinRepayVal includes the payment of the principal and the interests.

Example

See additional examples

// Amount of regular payments. The initial capital is set to 100000 Euros.
// The payments are paid each month during 2 years.
// The interest rate is set to 8%.
ResRepayVal = FinRepayVal(100000, 24, 8)

Syntax

<Result> = FinRepayVal([<Initial capital> [, <Number of periods> [, <Rate>]]])

<Result>: Real or currency

Amount of regular payments.

<Initial capital>: Optional real or currency

Initial capital (0 by default). This parameter indicates the amount on which the calculation must be performed.
In the "standard" case of a borrower, this capital is borrowed and therefore it corresponds to a negative value.
If this parameter is positive, the calculation is performed for a lender. The returned value is negative: this value corresponds to the amount that must be paid.

<Number of periods>: Optional integer

Total number of periods for the operation (1 by default).

<Rate>: Optional real

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

Remarks

Time unit

The calculations can be performed according to months or years. <Rate> and <Period> must correspond to the same unit.

Therefore, for monthly payments of a 4-year loan with a yearly interest rate set to 12%, use:

<Rate> = 12% / 12,
<Number of periods> = 4*12

For the same loan with yearly payments, use:

<Rate> = 12%,
<Number of periods> = 4

For all the parameters, the payments are represented by a negative number while the collections are represented by a positive number.

Managing errors

Caution: FinRepayVal 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:

Complete examples (WINDEV): WD Loan

[ + ] The power of WINDEV and the ease-of-use of WLanguage have allowed us to develop this application within a single day!

This example is used to simulate loans and to:
- calculate the amount of the monthly repayments from the amount borrowed
- calculate the amount that can be borrowed from a given monthly repayment
- calculate the income of an investment from a monthly payment

For each case, you have the ability to view the amortization table corresponding to your parameters.

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.

Component: wd280mat.dll