ONLINE HELP WINDEV, WEBDEV AND WINDEV MOBILEVersion: 151617181920212223242526
 Home | Sign in | English
 Fixed-rate amortizationManaging errors WINDEV WEBDEV WINDEV Mobile Others 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.Example See additional examples // 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 = FinDecreasingRedemption( , , [,  [, ]]) : Real or currencyValue of the amortization for the given or 0 if the amortization is null. : Real or currencyAcquisition cost of good. This cost cannot be null. : Real or currencyResidual value of good after amortization. : RealNumber of periods during which the good is repaid. This duration cannot be null. : Optional integerPeriod over which the amortization must be calculated (1 by default). : Optional integerNumber of months in the first amortization year (1 by default). This number must be included between 0 and 12. Remarks Fixed-rate amortizationThe 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: - where 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 ();for the last year, the number of amortized months corresponds to: 12 - Remark: If the number of months for the first year is equal to 12, this year is included in the duration.Managing errorsCaution: 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.Component : wd260mat.dll Minimum version required Version 9 This page is also available for…
 Comments
 Click [Add] to post a comment
 Last update: 09/23/2020Send a report | Local help
 Registered trademarks. Copyright ©2009-2021 PC SOFT. All rights reservedThis website has been developed with WEBDEV and HFSQLWEBDEV, WINDEV Mobile and WINDEV programming