Xirr: Is closely related to

XIRR is closely related to XNPV, the net present value function. The rate of return calculated by XIRR is the interest rate corresponding to XNPV = 0. Excel uses an iterative technique for calculating XIRR . Using a changing rate (starting with guess), XIRR cycles through the calculation until the result is accurate within 0.000001 percent. XIRR stands for Extended Internal Rate of Return . It is a financial metric used to calculate the internal rate of return for a series of cash flows that occur at irregular intervals. Extended Internal Rate of Return, or XIRR , is a way to measure how your mutual fund investment has performed over time, especially when you’ve invested money at different intervals. For example,... What is XIRR? The XIRR is a single rate of return that calculates the current value of an investment after considering all installments and redemptions. The XIRR represents your personal rate of return. It represents your real return on investment. XIRR stands for " Extended Internal Rate of Return ."