SYD |
SYD(cost, salvage, life, per) |
Returns the depreciation of an asset in a single period (sum-of-years digits 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. |
per | The period. |
REMARKS |
* For an illustrated example refer to the [[Depreciation]] page. * The sum of digits method computes depreciation at an accelerated rate. * Depreciation is highest in the first period and decreases in successive periods. * 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. * The "life" and "per" must be in the same units. * 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 SLN function to return the straight line depreciation of an asset for one period. * You can use the VDB function to return the depreciation of an asset using a variable declining method. * The equivalent VBA function is VBA.SYD * For the Microsoft documentation refer to support.microsoft.com * For the Google documentation refer to support.google.com |
|
1 - What is the depreciation in the first year if |
© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top