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