XIRR(values, dates [,guess]) 
Returns the interest rate for a series of unequal cash flows at irregular intervals. 
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 E09 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 365day 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 present value for a series of unequal cash flows at irregular intervals. * In Excel 2010 the accuracy of this function was improved. * For the Microsoft documentation refer to support.office.com 

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top