<HTML
><HEAD
><TITLE
>SYD</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.54"><LINK
REL="HOME"
TITLE="Gnumeric's user manual"
HREF="gnumeric.html"><LINK
REL="UP"
TITLE="Reference"
HREF="function-reference.html#AEN1187"><LINK
REL="PREVIOUS"
TITLE="POISSON"
HREF="r3100.html"><LINK
REL="NEXT"
TITLE="MID"
HREF="r3149.html"></HEAD
><BODY
CLASS="REFENTRY"
><DIV
CLASS="NAVHEADER"
><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="3"
ALIGN="center"
>Gnumeric's user manual</TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="bottom"
><A
HREF="r3100.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r3149.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN3124"
><A
NAME="GNUMERIC-SYD"
></A
>SYD</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN3129"
></A
><H2
>Name</H2
>SYD&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN3132"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>SYD(cost,salvage_value,life,period)</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3134"
></A
><H2
>Description</H2
><P
>The SYD function calculates the sum-of-years digits depriciation for an asset based on its cost, salvage value, anticipated life and a particular period. This method accelerates the rate of the depreciation, so that more depreciation expense occurs in earlier periods than in later ones. The depreciable cost is the actual cost minus the salvage value. The useful life is the number of periods (typically years) over with the asset is depreciated.</P
><P
>The Formula used for sum-of-years digits depriciation is:</P
><P
>Depriciation expense = ( cost - salvage_value ) * (life - period + 1) * 2 / life * (life + 1).</P
><P
>	@cost = cost of an asset when acquired (market value).	@salvage_value = amount you get when asset sold at the end of its useful life.	@life = anticipated life of an asset.	@period = period for which we need the expense.</P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3140"
></A
><H2
>Examples</H2
><P
></P
><P
>For example say a company purchases a new computer for $5000 which has a salvage value of $200, and a useful life of three years. We would use the following to calculate the second year's depreciation using the SYD method:</P
><P
>=SYD(5000, 200, 5, 2) which returns 1,280.00.</P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN3145"
></A
><H2
>See also</H2
><P
>        <A
HREF="r9814.html#GNUMERIC-SLN"
>SLN</A
>
      </P
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="r3100.html"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="gnumeric.html"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="r3149.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-POISSON"
></A
>POISSON</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="function-reference.html#AEN1187"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
NAME="GNUMERIC-MID"
></A
>MID</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>