SYD function example

By using the sum-of-years digits method, this example illustrates the use of the SYD function to return the depreciation of an asset for a specified period given the asset's initial cost (InitCost), the salvage value at the end of the asset's useful life (SalvageVal), and the total life of the asset in years (LifeTime). The period for which the depreciation is calculated is DepYear, also in years.

SYD([InitCost], [SalvageVal], [LifeTime], [DepYear])