SLN |
SLN(cost, salvage, life) |
Returns the depreciation of an asset in a single period (straight-line method). |
cost | The original cost of the asset. |
salvage | The value of the asset at the end of its life. |
life | The number of periods over which the asset is being depreciated. |
REMARKS |
* For an illustrated example refer to the [[Depreciation]] page. * 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 VBA.SLN * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
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. |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top