To calculate the depreciation value using the straight-line basis, or straight-line method (SLN), Excel uses a built-in function, SLN, which takes the arguments: cost, salvage, and life.

How to Calculate Depreciation Using Excel. Two common ways of calculating depreciation are the straight-line and double declining balance methods. Excel can accomplish both using the SLN function ...

To calculate the depreciation value using the straight-line basis, or straight-line method (SLN), Excel uses a built-in function, SLN, which takes the arguments: cost, salvage, and life. 1 ...