ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
This predefined function is used to calculate the straight-line depreciation of an investment.
The calculation is governed by a depreciation duration expressed in years and takes the item's residual value into account.
Syntax
Result = &DEPRECIATION(Cost;Residual value;Duration)
Parameters
|
Description |
Contents |
Controls |
Result |
Numeric variable with decimals. |
Depreciation calculated. |
|
Cost |
Numeric constant or variable with decimals. |
Sum to be depreciated in straight-line mode. |
Mandatory parameter. |
Residual value |
Numeric constant or variable with decimals. |
Estimated value of the item at the end of the depreciation period. |
Mandatory parameter. |
Duration |
Numeric constant or variable with decimals. |
Number of years over which an investment is to be depreciated. |
Mandatory parameter. |
Example
COST = 150000 |
|
RESIDUAL = 50000 |
|
YEARS = 5 |
|
RESULT = &DEPRECIATION(COST;RESIDUAL;YEARS) |
|
* The RESULT is equal to: 20000 |
|
* |
|
COST = 200000 |
|
RESIDUAL = 0 |
|
YEARS = 20 |
|
RESULT = &DEPRECIATION(COST;RESIDUAL;YEARS) |
|
* The RESULT is equal to: 10000 |
List of predefined functions by topic