Although Excel helps people avoid some manual calculations, teams calculating an IRR in Excel face a series of limitations. First, Excel has difficulty processing large amounts of data, and dealing ...

IRR Examples Let us use a couple of examples to show you how simple the IRR concept is. If you invested $100 and at the end of one year you recouped a total of $115 then the IRR would be 15%.