ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

This content has been translated automatically.  Click here  to view the French version.
Help / WLanguage / WLanguage functions / Standard functions / Numeric values functions / Financial functions
  • Fixed-rate amortization
  • Error management
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
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.
// Valeur d'amortissement d'un bien acheté 25 000 Euros dont la valeur
// résiduelle sera de 15 000 Euros après une durée de 6 ans.
ResAmortissement = FinDecreasingRedemption(25000, 15000, 6)
Syntax
<Result> = FinDecreasingRedemption(<Acquisition cost> , <Residual value> , <Duration> [, <Period> [, <Number of months 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 the product. This cost cannot be null.
<Residual value>: Real or currency
Residual value of the product after amortization.
<Duration>: Real
Number of periods during which the product is repaid. This duration cannot be null.
<Period>: Optional integer
Period over which the amortization must be calculated (1 by default).
<Number of months 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 months amortized is taken into account (<Number of months for year 1>);
  • for the last year, the number of months amortized corresponds to:
    12 - <Number of months for year 1>
Remark: If the number of months in the first year equals 12, this year is included in the duration.

Error management

Caution: FinDecreasingRedemption 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
Minimum version required
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 03/28/2025

Send a report | Local help