Returns the straight-line depreciation of an asset for one period. The amount of the depreciation is constant during the depreciation period.
SLN(Cost; Salvage; Life)
Cost is the initial cost of an asset.
Salvage is the value of an asset at the end of the depreciation.
Life is the depreciation period determining the number of periods in the depreciation of the asset.
Office equipment with an initial cost of 50,000 currency units is to be depreciated over 7 years. The value at the end of the depreciation is to be 3,500 currency units.
=SLN(50000;3,500;84) = 553.57 currency units. The periodic monthly depreciation of the office equipment is 553.57 currency units.