Description
SYD returns a Number specifying the sum-of-years' digits depreciation of an asset for a single period.
Arguments
cost is a Number or Currency that specifies the initial cost of the asset.
salvage is a Number or Currency that specifies the value of the asset at the end of its useful life.
life is a positive Number that specifies the length of the useful life of the asset.
period is a Number that specifies the period for which asset depreciation is calculated. The value is positive and less than or equal to life. The arguments life and period must have the same units.
Action
SYD returns a Number specifying the sum-of-years' digits depreciation of an asset for a single period.
Examples
Suppose a company purchases a fleet of cars for $500,000. The cars have a lifetime of 10 years and a salvage value of $60,000. They are depreciated as follows:
SYD (500000, 60000, 10, 1)
Returns 80000. The first year's depreciation is $80,000.
SYD (500000, 60000, 10, 4)
Returns 56000. The fourth year's depreciation is $56,000.
SYD (500000, 60000, 10, 10)
Returns 8000. The final year's depreciation is $8,000.