Manuals/calci/SLN
Jump to navigation
Jump to search
SLN(C,salvage, L)
Where 'C' is the initial cost of the asset, 'salvage' is the value at the end of the depreciation and 'Life' is the number of periods over which the asset is depreciated.
This function computes the straight-line depreciation of an asset for one period.
DAVERAGE
Lets see an example,
SLN(C,salvage, L)
B
45000
11000
12
=SLN(B2, B3, B4) is 2833.333
Syntax
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 45000 | |||
Row2 | 11000 | |||
Row3 | 12 | |||
Row4 | 2833.3333 | |||
Row5 | ||||
Row6 |