SYD

Try it

When to use it

When should I use SYD?

Use SYD to calculate sum-of-years'-digits depreciation for a specific period — an accelerated method that charges more depreciation in early years and less in later years, useful for assets that lose value quickly.

Used in

finance

Syntax

SYD(cost, salvage, life, per)

Examples

=SYD(100,50,10,2) // => 8.181818181818182