Edit

Share via


WorksheetFunction.Syd(Double, Double, Double, Double) Method

Definition

Returns the sum-of-years' digits depreciation of an asset for a specified period.

public:
 double Syd(double Arg1, double Arg2, double Arg3, double Arg4);
public double Syd (double Arg1, double Arg2, double Arg3, double Arg4);
Public Function Syd (Arg1 As Double, Arg2 As Double, Arg3 As Double, Arg4 As Double) As Double

Parameters

Arg1
Double

Cost - the initial cost of the asset.

Arg2
Double

Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset).

Arg3
Double

Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset).

Arg4
Double

Per - the period and must use the same units as life.

Returns

Remarks

Syd is calculated as follows:

Figure 1: Equation for the Syd method

Applies to