Returns the current value of investment.

**Reminder**: The current value corresponds to the sum that represents a set of future payments at today's date. For example, when you get a loan, the amount of the loan represents the current value for the lender.

// Current value of investment. The repayment value is set to 5000 Euros.

// This investment must bring in 50000 Euros per year during 10 years.

// The interest rate is set to 8%.

ResCurrentVal = FinCurrentVal(-5000, 50000, 10, 8)

Syntax

<Result> = FinCurrentVal([<PaymentÂ Value> [,Â <FutureÂ Value> [,Â <NumberÂ ofÂ periods> [,Â <Rate> [,Â <Start>]]]]])

<Result>: Real or currency

Current value of investment.

<Payment Value>: Optional real or currency

Payment value for each period (0 by default). This payment is identical over the entire duration. This value must be negative.

<Future Value>: Optional real or currency

Future value (capitalized value). This is the amount after the last payment (0 by default).

<Number of periods>: Optional integer

Total number of periods in the investment (1 by default).

<Rate>: Optional real

Interest rate of investment expressed in percentage (1 by default). For example, for a 5% rate, this parameter will be set to 5.

<Start>: Optional boolean

__True__ if the payments must be made at the beginning of period (default value),__False__ if the payments must be made at the end of period.

Remarks

The calculations can be performed according to months or years. <Rate> and <Period> must correspond to the same unit.

Therefore, to get the current value of a 4-year loan, paid off monthly, with a yearly interest rate set to 10%, the units can be expressed in months:

- <Period> = 4*12,
- <Rate> = 10% / 12

**Caution**:

**FinCurrentVal** 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.