Manuals/calci/SYD

SYD(c,s,l,p)

• $c$ is the initial cost.
• $s$ is the salvage which is the value of the asset.
• $l$ is the life of the number of periods.
• $p$ is the number of periods.

Description

• This function gives the depreciation of an asset for a given time period based on the sum-of-years digits depreciation method.
• In $SYD(c,s,l,p)$, $c$ is the original cost of the asset.
• $s$ is the salvage value after the asset has been fully depreciated.
• $l$ is the useful life of the asset or the number of periods that you will be depreciating the asset, $p$ is the period that you wish to calculate the depreciation for.
• SYD is calculated as follows:

$SYD={\frac {(c-s)*(l-p+1)*2}{(l)(l+1)}}$ where $c$ is the cost,$s$ is the salvage,$p$ is the period and $l$ is the life.

• This function will give the result as error when

  1.Any one of the argument is nonnumeric.
  2.s<0 
  3.l or p<=0
  4.p is greater than l.

Examples

1. =SYD(25000,2800,7,1) = 5550
2. =SYD(50000,9000,15,3) = 4441.6666667
3. =SYD(42500,6850,6,3) = 6790.47619047

See Also

• PMT
• PPMT
• PV

References

• Syd