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
Returns the future value of an investment. The payments are regular and fixed. The interest rate is fixed.
// Valeur future d'un investissement. Le capital initial est 100 000 Euros.
// 3 000 Euros sont versés chaque mois pendant 2 ans. Le taux d'intérêt est de 8%.
ResValFuture = FinFutureVal(-100000, -3000, 24, 8)
Syntax
<Result> = FinFutureVal([<Initial capital> [, <Periodic Deposit> [, <Number of periods> [, <Rate> [, <Start>]]]]])
<Result>: Real or currency
Future value of the investment.
<Initial capital>: Optional real or currency
Initial capital (0 by default).
<Periodic Deposit>: Optional real or currency
Periodic deposit (0 by default). This value is fixed for the entire duration of the operation. In most cases, this amount includes the capital and the interests.
<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. This rate cannot be null.
<Start>: Optional boolean
  • True if the payments must be made at the beginning of period (default value),
  • False if the payments must be made at the end of period.
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 5-year loan with a yearly interest rate set to 8%, use:
  • <Rate> = 8% / 12,
  • <Number of Periods> = 5*12
For the same loan with yearly payments, use:
  • <Rate> = 8%,
  • <Number of Periods> = 5
For all the parameters, the payments are represented by a negative number while the collections are represented by a positive number.

Error management

Caution: FinFutureVal 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:
The financial functions 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
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 (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
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/28/2025

Send a report | Local help