Excel functions / Financial

SYD function

Sum-of-years’ digits depreciation: more in the early periods, less in the late ones.

Syntax

=SYD(cost, salvage, life, per)

Arguments

When to use it

SYD gives depreciation by the sum-of-years' digits method: more in the early years, less later, in a straight-line decline. For a 10-year life, the first year takes 10/55 of the cost less salvage, the second 9/55, and so on.

Examples

  1. The first year

    ABCDE
    1CostSalvageLife
    2300007500104090.91

    In E2: =SYD(A2, B2, C2, 1) → 4090.91

    Try this example

  2. The last year

    ABCDE
    1CostSalvageLife
    230000750010409.09

    In E2: =SYD(A2, B2, C2, 10) → 409.09

    Try this example

Common mistakes

SYD in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try SYD in the playground

Related functions