SLN
Straight-line depreciation: the same amount every period of an asset's life.
Group: Financial. Compatible with DAX.
Syntax
SLN ( <cost>, <salvage>, <life> )| Parameter | Type | Description |
|---|---|---|
cost | Number | What the asset cost. |
salvage | Number | What it is worth at the end of its life. |
life | Number | How many periods the asset is used: years, or months for a monthly schedule. |
Returns
Number. One period's depreciation, the same in every period.
Remarks
- (cost − salvage) / life: the same amount every period.
- A life of 0 is an error. A salvage above the cost gives a negative amount.
Examples
A fermentation tank
480,000, worth 30,000 after 15 years.
EVALUATE
ROW (
"A year", SLN ( 480000, 30000, 15 ),
"A month", SLN ( 480000, 30000, 15 * 12 )
)| A year | A month |
|---|---|
| 30000 | 2500 |