Excel and Google Sheets have three functions to calculate the internal rate of return: IRR, XIRR, and MIRR. Learn how these functions can calculate investment returns.

Learn how to calculate the internal rate of return (IRR) in Excel and how it’s used to determine whether a capital investment can be profitable.

Using Excel to calculate IRR with unequal timing of cash flows In the chart below, we have management's estimation for the initial cost and cash flow returns for both the expansion and new ...

Calculating the IRR for a project with an initial outlay and single cash flow is very easy to do. It's also very practical for measuring the returns.