FinCurrentVal (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

This content has been translated automatically. Click here to view the French version.

Help / WLanguage / WLanguage functions / Standard functions / Numeric values functions / Financial functions

Time unit
Error management

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

FinCurrentVal (Function)

In french: FinValActuelle

Returns the current value of investment.

Reminder Present value corresponds to the sum represented today by a set of future repayments. For example, when you get a loan, the amount of the loan represents the current value for the lender.

Example

See additional examples

// Valeur actuelle d'un investissement. La valeur de remboursement est de 5 000 Euros.
// Cet investissement doit rapporter 50 000 Euros par an pendant 10 ans.
// Le taux d'intérêt est de 8%.
ResValActuelle = 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 for 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

Time unit

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

Error management

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.

Component: wd300mat.dll