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 Bottom Line . Using Excel to calculate the internal rate of return requires the IRR function and reference cells that list the cash flows for a series of periods, plus an optional guess for ...

Find the IRR in Excel by employing the IRR function, then use it as the discount rate that causes NPV to equal zero. Use What-If analysis, a built-in calculator in Excel, to solve for the discount ...

Now I just hit enter, and Excel calculates that my internal rate of return on my Microsoft stock was 0.2373. This result is actually a percentage, an IRR of 23.73%.

Calculating the IRR, or an investment’s expected annual rate of growth, is no easy task for investors. Find the formula and tips for calculating IRR.

Next, in the IRR function, in the Values field, select the array of cells that contains the values of the payments and receipts for which you want to calculate the IRR. In our example, it is A1:A13.

The XIRR function takes into account the cash flows, the dates, and a guess of the IRR to instantly compute the internal rate of return. In this example, 0.2 -- 20% -- was used as the IRR estimate ...

Step 4: Another formula you can use to calculate percentage is simply applying the / key in between two cells. For example, to pass a driving theory test, I need to get 80% of the questions correct.