PakAccountants.com

SYD

Calculate depreciation of asset using sum of years digits method

Syntax of Excel SYD formula:
=SYD(cost, salvage, life, per)

In words:
=Calculate depreciation of asset using sum of years digits method with this(cost, salvage value, useful life, for this period)

Examples of Excel SYD Formula

=SYD(1000,100,5,1) will give $300 as depreciation of asset.