 Help WLanguage WLanguage functions Standard functions Numeric values management functions Financial functions FinNetCurrentVal Presentation Example Matrix element Managing errors See also  FinCurrentVal (Example) FinCurrentVal FinDecreasingRedemption (Example) FinDecreasingRedemption FinError (Example) FinError FinFutureVal (Example) FinFutureVal FinInterestRate (Example) FinInterestRate FinLinearRedemption (Example) FinLinearRedemption FinNetCurrentVal (Example) FinNetCurrentVal FinPaymentNb (Example) FinPaymentNb FinPeriodInterest (Example) FinPeriodInterest FinRedemption (Example) FinRedemption FinRepayVal (Example) FinRepayVal Financial constants Financial functions
• Matrix element
• Managing errors
WINDEV      WEBDEV    WINDEV Mobile       Others FinNetCurrentVal (Function)
In french: FinValActuelleNette
Returns the net current value of investment. This investment is based on variable financial flows.
Reminder: The net current value corresponds to the value at today's date of a series of future disbursements (negative values) and collections (positive values).
Remark: From a financial point of view, an investment will be deemed profitable if its NCV (Net Current Value) is positive.
Example
// Net current value of investment. The interest rate is set to 8%.
ResNetCurrentVal = FinNetCurrentVal(8, "Matrix")
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/column Content 1 Invested amount (disbursed): negative 2 Revenue for year 1: credited or debited 3 Revenue for year 2: credited or debited ..... N-1 Revenue for year N-2: credited or debited N Revenue for year N-1: credited or debited

Managing errors

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: wd270mat.dll
Minimum version required
• Version 9