Using the Functions in Excel: IRR Here is a simple example of an IRR analysis with cash flows that are known and consistent (one year apart). Assume a company is assessing the profitability of ...