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 AMORDEGRC function to return the depreciation of an asset in a single period (declining balance method).
* You can use the AMORLINC function to return the depreciation of an asset in a single period (linear method).
* 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-declining balance method).
* You can use the SLN function to return the depreciation of an asset in a single period (straight-line method).
* You can use the VDB function to return the depreciation of an asset in a single period (variable-declining balance 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

	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