Excel has three functions to calculate the IRR: IRR, the modified IRR (MIRR ... Let's walk you through the steps with an example. Suppose you have two potential investments with the following ...

You have added a table in Excel with date, cash flow, and description columns. You can now use the =XIRR(B2:B7, A2:A7) function to calculate an annualized internal rate of return for this real ...