Manuals/calci/SYD
Jump to navigation
Jump to search
SYD(C, salvage, L, P)
Where 'C' is the initial cost of the asset, 'salvage' is the value at the end of the depreciation, 'L' is the number of periods over which the asset is depreciated and 'P' is the period
This function computes the sum-of-years' digits depreciation of an asset for a specified period.
- SYD is calculated as follows:
SYD
Lets see an example,
SYD(C, salvage, L, P)
B
45000
11000
12
=SYD(B2,B3,B4,1) is 5230.7692
=SYD(B2,B3,B4,10) is 1307.6923
Syntax
Remarks
Examples
Description
Column1 | Column2 | Column3 | Column4 | |
Row1 | 45000 | |||
Row2 | 11000 | |||
Row3 | 12 | |||
Row4 | 5230.7692 | |||
Row5 | 1307.6923 | |||
Row6 |