SYD function - Calculate depreciation for an asset by remaining value in Excel

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:

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 1

For example:

With investment properties have the following parameters. Calculate the depreciation for the first year, the depreciation for the last year.

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 2

In the cell to calculate enter the formula: = SYD (B7, C7, D7,1) .

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 3

Pressing Enter results as:

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 4

The depreciation for the last year -> the depreciation period is 10.

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 5

Press Enter the depreciation value of the property after 10 years:

SYD function - Calculate depreciation for an asset by remaining value in Excel Picture 6

Above are the uses and cases of the SYD function .

Good luck!