The following article details the syntax and usage of the SYD function to help you understand and use it properly in all cases.
Description: The function performs depreciation of assets according to the remaining time in the specified period.
Syntax : = SYD (cost, salvage, life, per) .
Inside:
- cost : The initial value of the property, required parameters.
- salvage : The depreciation value of the property, also called the recovery value of the property.
- life : Term of the property, required parameters.
- per : The number of depreciation periods, mandatory in the same unit as the asset's maturity, is the required parameter.
Attention:
- Depreciation formula:
For example:
With investment properties have the following parameters. Calculate the depreciation for the first year, the depreciation for the last year.
In the cell to calculate enter the formula: = SYD (B7, C7, D7,1) .
Pressing Enter results as:
The depreciation for the last year -> the depreciation period is 10.
Press Enter the depreciation value of the property after 10 years:
Above are the uses and cases of the SYD function .
Good luck!