Internal Return Rate (IRR) Excel Template

Internal Rate of Return (IRR) is a discount rate that is used to identify potential/future investments that may be profitable. The IRR is used to make the net present value (NPV) of cash flows from a project/investment equal to zero.

Generally, the easiest way to calculate IRR is using an Excel spreadsheet. The download below allows you to work out the internal rate of return of a series of cash flows so that the NPV is discounted to $0.

The IRR can be used for just about any potential investment, including the stock market, equipment, and other capital investments. While the projected amount of future cash flow is not always accurate due to a variety of factors, the IRR is a great jumping off point when considering any sort of future investment.

The IRR is also commonly used when comparing if it will be more profitable to open a new branch of business within a company or expand the operations of an existing one. An example of this would be a paper company deciding whether to open a new mill or simply expand an existing one. Both would certainly add value to the company, but the IRR could give a good indication of which is the more profitable decision in the long term.

For more analysis on internal rate of return and details on how the NPV formula is derived, please read our article on IRR article.

You can also use our free IRR calculator to calculate the IRR for up to 10 cash flows.