For that, we'll need to use a special function in Excel. Plugging the data into a spreadsheet, we'll use the XIRR function to calculate the internal rate of return for each project.

For that, we'll need to use a special function in Excel. Plugging the data into a spreadsheet, we'll use the XIRR function to calculate the internal rate of return for each project.

Learn about the internal rate of return (IRR), how to calculate it and why it matters to traders.