// 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 determine if this function has generated errors, use

FinError. To get more details on the error, use

ErrorInfo with the

*errMessage* constant.