Difference between revisions of "Manuals/calci/SYD"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font color="#000000"><font face="Arial, sans-serif"><font size="2">'''SYD'''</font></font><font face="Arial, sans-...") |
(No difference)
|
Revision as of 21:45, 24 October 2013
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 |
