SLN – Straight-line method of depreciation
Syntax:
=SLN(cost,salvage,life)
cost: cost of the asset
salvage: residual value of asset at the end of its useful life
life: useful life of asset
Example
The heart favourite depreciation method among accountants for numerous types of assets. To calculate depreciation using straight-line method follow these steps:
Step 1: Open tab named SLN and observe the minimal data. No wonder straight-line method is simplest in Excel as well.
Step 2: In cell B11 enter the following formula: =SLN(B7,B8,B9). Hit enter and depreciation expense is calculated in the blink of an eye.
You can practice these steps in the following live excel worksheet
