Using the Functions in Excel: XIRR The extended internal rate of return (XIRR) function in Excel assumes irregular payment dates rather than estimates for annual periods. XIRR might be used in projects or investments like mutual funds, which are redeemed and reinvested in at various interva...
Syntax: XNPV(rate,values,dates) XIRR: This function calculates the internal rate of return for a series of cash flows that are not equally spaced in time. Syntax: XIRR(values,dates,guess) Download the NPV IRR Excel to view these example calculations. Download: NPV IRR Calculations Excel ...