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
  • Matrix element
  • Error management
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
FinNetCurrentVal (Function)
In french: FinValActuelleNette
Returns the net current value of investment. This investment is based on variable financial flows.
Reminder Net present value is the current value of a series of future cash outflows (negative values) and inflows (positive values).
Note From a financial point of view, an investment is considered profitable if its NPV (Net Present Value) is positive.
// Valeur actuelle nette d'un investissement. Le taux d'intérêt est de 8%.
ResValActuelleNette = FinNetCurrentVal(8, "Matrice")
Syntax
<Result> = FinNetCurrentVal(<Rate> [, <Matrix name> [, <Row/Column number> [, <Row/Column>]]])
<Result>: Real or currency
Net current value of investment.
<Rate>: 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.
<Matrix name>: Optional character string
Name of matrix (defined by MatCreate) containing the disbursements and the collections originating from the investment.
<Row/Column number>: Optional integer
Number of the row or column containing the data (1 by default).
<Row/Column>: Optional boolean
  • True (default) if the series of values corresponds to a matrix column,
  • False if the series of values corresponds to a matrix row.
Remarks

Matrix element

The matrix row or column analyzed by FinNetCurrentVal must contain the following elements:
Number of the row/columnContent
1Amount invested (disbursed): negative
2Income for year 1: received or disbursed
3Income for year 2: received or disbursed
.....
N-1Income for year N-2: received or disbursed
NIncome for year N-1: received or disbursed

Error management

Caution: FinNetCurrentVal 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.
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