Difference between revisions of "Manuals/calci/SYD"

From ZCubes Wiki
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