WorksheetFunction.Syd Method (Excel)
Returns the sum-of-years' digits depreciation of an asset for a specified period.
Syntax
expression .Syd(Arg1, Arg2, Arg3, Arg4)
expression A variable that represents a WorksheetFunction object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Arg1 |
Required |
Double |
Cost - the initial cost of the asset. |
Arg2 |
Required |
Double |
Salvage - the value at the end of the depreciation (sometimes called the salvage value of the asset). |
Arg3 |
Required |
Double |
Life - the number of periods over which the asset is depreciated (sometimes called the useful life of the asset). |
Arg4 |
Required |
Double |
Per - the period and must use the same units as life. |
Return Value
Double
Remarks
- SYD is calculated as follows:
.gif "Ff821499.awfsyd_ZA06051253(en-us,office.14).gif")