|
|
|
|
|
|
|
|
|
|
- Matrix element
- Error management
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.
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 The matrix row or column analyzed by FinNetCurrentVal must contain the following elements: | | | Number of the row/column | Content | | 1 | Amount invested (disbursed): negative | | 2 | Income for year 1: received or disbursed | | 3 | Income for year 2: received or disbursed | | ..... | | | N-1 | Income for year N-2: received or disbursed | | N | Income for year N-1: received or disbursed |
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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|