See Also Example
Description
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Syntax
SYD(cost, salvage, life, period)
Remarks
The SYD function uses the following numeric arguments:
Argument Description
cost Initial cost of the asset.
salvage Value of the asset at the end of its useful life.
life Length of the useful life of the asset.
period Period for which asset depreciation is calculated.
The arguments life and period must be expressed in the same units. For example, if life is given in months, period must also be given in months. All arguments must be positive numbers.
Distribution Note When you create and distribute applications that use any of the financial functions, you should install the file MSAFINX.DLL in the customer's Microsoft Windows \SYSTEM directory. The Visual Basic Setup Kit provides tools to help you write setup programs that install your applications.