PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Fixed-rate amortization
  • 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
FinDecreasingRedemption (Function)
In French: FinAmortissementDégressif
Calculates the amortization value of a good over a specific period of time, via the formula for fixed-rate decreasing amortization.
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 This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
New in version 23
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
Java This function is now available for the Java applications.
Android This function is now available for the Android applications.
Android Widget This function is now available in Android Widget mode.
// Amortization value of a good bought for 25000 Euros
// whose residual value will be 15000 Euros after 6 years.
ResAmortization = FinDecreasingRedemption(25000, 15000, 6)
Syntax
<Result> = FinDecreasingRedemption(<Acquisition Cost> , <Residual Value> , <Duration> [, <Period> [, <Number of Months for Year 1>]])
<Result>: Real or currency
Value of the amortization for the given <Period> or 0 if the amortization is null.
<Acquisition Cost>: Real or currency
Acquisition cost of good. This cost cannot be null.
<Residual Value>: Real or currency
Residual value of good after amortization.
<Duration>: Real
Number of periods during which the good is repaid. This duration cannot be null.
<Period>: Optional integer
Period over which the amortization must be calculated (1 by default).
<Number of Months for Year 1>: Optional integer
Number of months in the first amortization year (1 by default). This number must be included between 0 and 12.
Remarks

Fixed-rate amortization

The method for fixed-rate amortization consists in calculating the amortization of a good via a fixed rate over the amortization period.
This rate is applied to the current value of the good over each period. The current value of the good corresponds to:
<Acquisition Cost> - <Amortization Total>
where <Amortization Total> represents the sum of the amortization for the previous periods.
This rate is calculated according to the residual value, the acquisition cost of the good and the duration of the amortization.
A specific calculation must be performed regarding the amortization value for the first year and for the last year:
  • for the first year, only the number of amortized months is taken into account (<Number of Months (Year 1)>);
  • for the last year, the number of amortized months corresponds to:
    12 - <Number of months (year 1)>
Note: If the number of months for the first year is equal to 12, this year is included in the duration.

Managing errors

Caution: FinDecreasingRedemption 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