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.

The internal rate of return (IRR) is a metric used in capital budgeting to estimate the return of potential investments. Here is the formula for calculating it.

This article will talk about the underpinning and computation of key financial metrics such as NPV and IRR and how to compute these metrics in Microsoft Excel.