syd Function

Description:
The depreciation of an asset for a specified period using the sum-of-years method.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The initial value of the asset.
2
Number
The salvage value at the end of its useful life.
3
Whole Number
The useful life of the asset in years.
4
Whole Number
Any period within the life of the asset.
Example:
When using functions inside a field, remember the field brackets:
{syd(VehicleInitialValue, VehicleSalvageAmount, VehicleLifeYears, VehicleCurrentYear)}
Expression
Result
syd( 30000, 7500, 10, 1 )
4090.91

Related content