Related Topics:

Spreadsheet Mathematical Functions

Function Wizard Functions

SYD

Description: Based on a specified period, returns the sum-of-years-digits depreciation of an asset.

Syntax: SYD(Cost, Salvage, Life, Per)

Remarks:

Example:

If you've bought a truck for $30,000 that has a useful life of 10 years and a salvage value of $7,500, the yearly depreciation allowance for the first year is:

The yearly depreciation allowance for the tenth year is:

 

© 1992-2015. ReliaSoft Corporation. ALL RIGHTS RESERVED.