SLN(cost, salvage, life)

Returns the depreciation of an asset in a single period (straight-line method).

costThe original cost of the asset.
salvageThe value of the asset at the end of its life.
lifeThe number of periods over which the asset is being depreciated.

Remarks

* The value of an asset at the end of the depreciation is also known as the salvage value.
* The number of periods over which the asset is being depreciated is also known as the useful life and is usually measured in years.
* The salvage value plus the total amount the asset has depreciated will equal your original cost.
* This method accelerates depreciation at a constant rate for the entire life of the asset.
* You can use the DB function to return the depreciation of an asset in a single period (declining balance method).
* You can use the DDB function to return the depreciation of an asset in a single period (double or triple declining balance method).
* You can use the SYD function to return the depreciation of an asset using the sum of years method
* You can use the VDB function to return the depreciation of an asset using a variable declining method.
* The equivalent VBA function is SLN
* For the Microsoft documentation refer to support.office.com

 A
1=SLN(30000,7500,10) = £2,250.00
2=SLN(1300,100,4) = £300.00

1 - Suppose you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500. The depreciation amount for each year is £2,250.
2 - Suppose you've bought a laptop for £1,300 that has a useful life of 4 years and a salvage value of £100. The amount this asset will depreciate every year is £300.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top