PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Time unit
  • Managing errors
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
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.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Versions 23 and later
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
New in version 23
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
Java This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
Android This function is now available for the Android applications.
// 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

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

Managing errors

Caution: FinCurrentVal 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.
Components
WINDEVWEBDEV - Server codeReports and Queries wd230mat.dll
Windows Mobile wp230mat.dll
Java wd230java.jar
Linux wd230mat.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment