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 ...

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.