// 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
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:
FinNetCurrentVal returns no error code. To find out whether errors have been generated by this function, use
FinError. To find out the error details, use
ErrorInfo associated with the
errMessage constant.