In This Topic

SYD

In This Topic

This function returns the sum-of-years’ digits depreciation of an asset for a specified period.

SYD(*cost*,*salvage*,*life*,*period*)

This function has these arguments:

Argument | Description |
---|---|

cost | Initial cost of the asset |

salvage | Value at the end of the depreciation |

life | Number of periods over which the asset is being depreciated |

period | Period for depreciation; must use the same units as the life argument. |

This function calculates the digits depreciation as follows:

Accepts numeric data for all arguments. Returns numeric data.

SYD(B1,1000,10,1)

SYD(R1C2,1000,10,1)

SYD(100000,10000,5,2) gives the result $2,4000

See Also