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 ...

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