|
|
|
|
|
|
|
|
|
|
FinCurrentVal (Function) In french: FinValActuelle 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.
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|