SYD(cost, salvage, life, per)

Returns the depreciation of an asset in a single period (sum-of-years digits 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.
perThe period.

Remarks

* 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 SYD
* For the Microsoft documentation refer to support.office.com

 A
1=SYD(30000,7500,10,1) = £4,090.91
2=SYD(30000,7500,10,10) = £409.09

1 - What is the depreciation in the first year if

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