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.
// Net current value of investment. The interest rate is set to 8%.
ResNetCurrentVal = FinNetCurrentVal(8, "Matrix")
<Result> = FinNetCurrentVal(<Rate> [, <Matrix name> [, <Row/Column number> [, <Row/Column>]]])
<Result>: Real or currency
Net current value of investment.
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.
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|Caution
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