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
-
Financial Functions
Format:
Article,
1 min read