SYD
Financial

Returns the sum-of-years' digits depreciation of an asset for a specified period

Syntax:

=SYD(cost, salvage, life, per)

Example:

=SYD(100000, 10000, 5, 1)