The XIRR function can be found using the command fx and under the category ‘Financial’. XIRR, short for Extended Internal Rate of Return, can help calculate the return when the time interval ...

Excel's built-in XIRR function allows investors to input cash flows and their respective dates to get an accurate rate of return.

You can calculate XIRR on MS Excel using the symbol function. The formula syntax is: =XIRR (values, dates, [guess]) Wherein: Values are your investment and redemption amounts (inflows are negative ...