SYD Function

See AlsoCH7IPK              ExampleGUAA8M>Low

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 KitGUH5X7 provides tools to help you write setup programs that install your applications.