Manuals/calci/XIRR

XIRR(V, Dates, G)

• $V$ is a series of cash flows which equivalent to a schedule of payments in dates.
• $Dates$ is a schedule of payment dates which equivalent to the cash flow payments.
• $G$ is a number that you guess is close to the result of this function.

Description

• This function computes the internal rate of return for a schedule of cash flows that is not essentially periodic.
• This function suppose at least one positive cash flow and one negative cash flow.
• The numbers in dates should be valid dates.
• In most cases no need to provide guess

XIRR shows the error value:

1.whenever any number in dates precedes the starting date or values 
2.$Dates$ contain a different number of values.

Equation $\sum _{i=1}^{N}{\frac {P_{i}}{(1+rate)^{\frac {date_{i}-date_{0}}{365}}}}=0$

Example

XIRR(V, dates, G) B C

-10000 &!02-01-2009&!

3000 04-01-2009

4300 11-30-2009

3250 03-15-2010

2200 05-01-2010

?UNIQ2b4aa68f40f8e8e8-nowiki-00000002-QINU?

---

Syntax

---

Remarks

---

Examples

---

Description

---

	Column1	Column2	Column3	Column4
Row1	-10000	02-01-2009
Row2	3000	04-01-2009
Row3	4300	11-30-2009
Row4	3250	03-15-2010
Row5	2200	05-01-2010
Row6	0.3593

File:Calci1.gif

---