ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Standard functions / Numeric values functions / Financial functions
  • Time unit
  • Error management
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
FinRepayVal (Function)
In french: FinValRemboursement
Returns the amount of each regular payment for an investment with fixed interest rate and fixed payment.
Note The value returned by FinRepayVal includes principal repayment and interest.
// Montant des remboursements périodiques. Le capital initial est 100 000 Euros.
// Les remboursement sont effectués chaque mois pendant 2 ans.
// Le taux d'intérêt est de 8%.
ResValRemboursement = 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 value returned is negative: this value corresponds to the amount to 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.

Error management

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:
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: wd300mat.dll
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/27/2025

Send a report | Local help