XIRR

XIRR(values, dates [,guess])

Returns the interest rate for a series of unequal cash flows at irregular intervals (implicit reinvestment rate).

values	A series of unequal cash flows.
dates	A series of payment dates that correspond to the cash flows.
guess	(Optional) An estimate as to what the rate will be.

REMARKS

* This function uses an iterative approach to find a solution.
* If the successive results of this function do not converge to within 2.98 E-09 after 100 iterations, then #NUM! is returned.
* This function assumes all payments are at the end of each period.
* A negative number represents cash that you pay out.
* A positive number represents cash that you receive (start with or end with).
* All succeeding payments are discounted based on a 365-day year.
* The series of values must contain at least one positive and one negative value.
* The "dates" must all be later than the first date, but they may occur in any order.
* If "dates" contain any numbers, they are truncated to integers.
* If any number in "dates" is not a valid date, then #NUM! is returned.
* If any number in "dates" precedes the starting date, then #NUM! is returned.
* If "values" and "dates" contain a different number of values, then #NUM! is returned.
* If "guess" is left blank, then 0.1 (or 10%) is used.
* Dates should be entered using the DATE function as problems can occur when dates are entered as text.
* This function can be used to calculate the Compound Annual Growth Rate (CAGR).
* You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals.
* You can use the IRR function to return the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
* You can use the MIRR function to return the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate)
* You can use the XNPV function to return the net present value of a series of unequal cash flows at irregular intervals.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A
1	=XIRR({-10000, 2750, 4250, 3250, 2750}, {"1/1/1998", "3/1/1998", "10/3/1998", "2/5/1999", "4/1/2000"}) = 44.90%
2	=XIRR({-10000, 2750, 4250, 3250, 2750}, {"1/1/2008", "3/1/2008", "30/10/2009", "15/2/2009", "1/4/2009"}, 0.1) = 27.17%
3	=XIRR({-10000, 2750}, {"1/1/2008"}, 0.1) = #NUM!