<HTML
><HEAD
><TITLE
>IRR</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="LOG10"
HREF="r9122.html"><LINK
REL="NEXT"
TITLE="HYPERLINK"
HREF="r9172.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="r9122.html"
>Prev</A
></TD
><TD
WIDTH="80%"
ALIGN="center"
VALIGN="bottom"
></TD
><TD
WIDTH="10%"
ALIGN="right"
VALIGN="bottom"
><A
HREF="r9172.html"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><H1
><A
NAME="AEN9146"
><A
NAME="GNUMERIC-IRR"
></A
>IRR</A
></H1
><DIV
CLASS="REFNAMEDIV"
><A
NAME="AEN9151"
></A
><H2
>Name</H2
>IRR&nbsp;--&nbsp;</DIV
><DIV
CLASS="REFSYNOPSISDIV"
><A
NAME="AEN9154"
></A
><H2
>Synopsis</H2
><TABLE
BORDER="0"
BGCOLOR="#E0E0E0"
WIDTH="100%"
><TR
><TD
><PRE
CLASS="SYNOPSIS"
>IRR(values[,guess])</PRE
></TD
></TR
></TABLE
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9156"
></A
><H2
>Description</H2
><P
>IRR calculates and returns the internal rate of return of an investment.  This function is closely related to the net present value function (NPV).  The IRR is the interest rate for a serie of cash flow where the net preset value is zero. </P
><P
>@values contains the serie of cash flow generated by the investment.  The payments should occur at regular intervals.  The optional @guess is the initial value used in calculating the IRR.  You do not have to use that, it is only provided for the Excel compatibility. </P
><P
>This function is Excel compatible. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9161"
></A
><H2
>Examples</H2
><P
></P
><P
>Let us assume that the cells A1:A8 contain the numbers -32432, 5324, 7432, 9332, 12324, 4334, 1235, -3422.  Now</P
><P
>IRR(A1:A8) returns 0.04375. </P
></DIV
><DIV
CLASS="REFSECT1"
><A
NAME="AEN9166"
></A
><H2
>See also</H2
><P
>        <A
HREF="r8533.html#GNUMERIC-FV"
>FV</A
>
,         <A
HREF="r6193.html#GNUMERIC-NPV"
>NPV</A
>
,         <A
HREF="r8387.html#GNUMERIC-PV"
>PV</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="r9122.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="r9172.html"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
NAME="GNUMERIC-LOG10"
></A
>LOG10</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-HYPERLINK"
></A
>HYPERLINK</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>