Excel and Google Sheets have IRR functions programmed to run 20 iterations to find a value that is accurate to within 0.00001%. If the program can’t find one, then it returns "#NUM" in the cell.

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 and use it as the discount rate that causes NPV to equal zero. Alternatively, you can use the What-If analysis tool, a built-in calculator in Excel, to solve for the discount rate ...

Excel will default to a 10% IRR guess if one is not provided. Doing this for both projects, we calculate that the facility expansion would have an internal rate of return of 14.5%, ...

The Difference Between Yield and IRR Calculations in Excel. When it comes to calculating interest rates for investments and bonds, the Yield and IRR formulas in Excel can quickly become your friends.

In Excel, you can use the program's XIRR function to solve for "r" -- the IRR -- for each project. The XIRR function first asks for the dates, followed by the cash flows, and then a guess at the ...

IRR is used for cash flows that are of the same size and spaced out equally, while XIRR is used for cash flows that are of different sizes and occur at varying intervals.

IRR on Microsoft Excel. We will use the same example we used above. Open Excel and enter -100 (that is negative 100) in cell A1, 0 (that is zero) in A2 and 132.25 in A3.