|
|
|
|
|
|
|
|
|
|
- Linear amortization
- Managing errors
FinLinearRedemption (Function) In french: FinAmortissementLinéaire Calculates the value of linear amortization of a product over a specific period of time.
// Amortization value of a product bought for 25000 Euros whose
// residual value will be 15000 Euros after 6 years.
ResAmortization = FinLinearRedemption(25000, 15000, 6)
Syntax
<Result> = FinLinearRedemption(<Acquisition cost> , <Residual value> , <Duration>)
<Result>: Real or currency - Value of amortization,
- 0 is the amortization is null.
<Acquisition cost>: Real or currency Acquisition cost of the product. <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. Remarks In a linear amortization, the amortization value is the same for each amortization period. Caution: FinLinearRedemption 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…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|