Manuals/calci/IRR

From ZCubes Wiki
Revision as of 20:38, 24 October 2013 by MassBot1 (talk | contribs) (Created page with "<div id="6SpaceContent" class="zcontent" align="left">  <font color="#000000">'''<font face="Arial, sans-serif"><font size="2">IRR(V, E)</font></font>'''</font> <font c...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
 

IRR(V, E)

Where 'V' is an array or a reference to cells and 'E' is a number that you guess is close to the result of IRR.

 This function returns the internal rate of return for a series of cash flows represented by the numbers.
 
  • The following formula demonstrates how NPV and IRR are related:NPV(IRR(B1:B6),B1:B6) equals 3.60E-08

IRR

 

Lets see an example,

IRR(V, E)

B

-25000

10000

11000

14000

18000

20000

=IRR(B2:B7) is 0.4259

Syntax
Remarks
Examples
Description
Column1 Column2 Column3 Column4
Row1 -25000 0.4259
Row2 10000
Row3 11000
Row4 14000
Row5 18000
Row6 20000
Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/IRR&oldid=457"