<HTML
><HEAD
><TITLE
>SLN</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="ATAN"
HREF="r9787.html"><LINK
REL="NEXT"
TITLE="LARGE"
HREF="r9840.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="r9787.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r9840.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN9814"
><A
NAME="GNUMERIC-SLN"
></A
>SLN</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN9819"
></A
><H2
>Name</H2
>SLN&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN9822"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>SLN(cost,salvage_value,life)</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9824"
></A
><H2
>Description</H2
><P
>The SLN function will determine the straight line depreciation of an assest for a single period. The amount you paid for the asset is the cost, salvage is the value of the asset at the end of its useful life, and life is the number of periods over which an the asset is depreciated. This method of deprecition devides the cost evenly ofver the life of an asset.</P
><P
>The formula used for straight line depriciation is:</P
><P
>Depriciation expense = ( cost - salvage_value ) / life</P
><P
>	@cost = cost of an asset when acquired (market value).	@salvage_value = amount you get when asset sold at the end of the assets's useful life.	@life = anticipated life of an asset.</P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9830"
></A
><H2
>Examples</H2
><P
></P
><P
>For example, lets suppose your company purchases a new machine for $10,000, which has a salvage value of $700 and will have a useful life of 10 years. The SLN yearly depreciation is computed as follows:</P
><P
>=SLN(10000, 700, 10)</P
><P
>This will return the yearly depreciation figure of $930.</P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9836"
></A
><H2
>See also</H2
><P
>        <A
HREF="r3124.html#GNUMERIC-SYD"
>SYD</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="r9787.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="r9840.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-ATAN"
></A
>ATAN</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-LARGE"
></A
>LARGE</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>