Home | Sign in | English EN
  • Time unit
  • Managing errors
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Stored procedures
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.
Versions 23 and later
Java This function is now available for Java applications.
New in version 23
Java This function is now available for Java applications.
Java This function is now available for Java applications.
// 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)
<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.

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 find out whether errors have been generated by this function, use FinError. To find out the error details, use ErrorInfo associated with the errMessage constant.
Related Examples:
WD Loan 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.
The Financial functions 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: wd260mat.dll
Minimum version required
  • Version 9
This page is also available for…
Click [Add] to post a comment