| SYD Function |
Named Arguments
Yes
Syntax
SYD(cost, salvage, life, period )
cost
Use: Required
Data Type: Double
The initial cost of the asset.
salvage
Use: Required
Data Type: Double
The value of the asset at the end of its useful life.
life
Use: Required
Data Type: Double
The length of the useful life of the asset.
period
Use: Required
Data Type: Double
The period whose depreciation is to be calculated.
Return Value
A Double representing depreciation per period.
Description
Computes the sum-of-years' digits depreciation of an asset for a specified period. The sum-of-years' digits method allocates a larger amount of the depreciation in the earlier years of the asset.
Rules at a Glance
life and period must be expressed in the same time unit. For example, if life represents the life of the asset in years, period must be a particular year for which the depreciation amount is to be computed.
All arguments must be positive numeric values.
To calculate the depreciation for a given period, SYD uses the formula:
(Cost-Salvage)*((Life-Period + 1)/(Life*(Life + 1)/2))
See Also
- DDB Function, SLN Function
Get VB & VBA in a Nutshell: The Language now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
