{"id":6129,"date":"2021-11-13T15:31:33","date_gmt":"2021-11-13T14:31:33","guid":{"rendered":"https:\/\/www.simtrade.fr\/blog_simtrade\/?p=6129"},"modified":"2025-09-04T15:25:58","modified_gmt":"2025-09-04T15:25:58","slug":"how-compute-irr-function-excel","status":"publish","type":"post","link":"https:\/\/www.simtrade.fr\/blog_simtrade\/how-compute-irr-function-excel\/","title":{"rendered":"How to compute the IRR in Excel"},"content":{"rendered":"

\"Photo<\/a> Jeremy PAULEN<\/p>\n

In this article, J\u00e9r\u00e9my PAULEN<\/a> (ESSEC Business School, Global Bachelor of Business Administration, 2019-2023) explains everything about the IRR function in Excel, which is used to compute the internal rate of return of a series of cash flow to evaluate the financial performance of an investment in relative terms.<\/p>\n

What is the IRR?<\/h2>\n

The IRR represents the internal rate of return of an investment. It is closely related to the net present value (NPV) of the investment as the IRR is the discount rate that makes the NPV equal to zero.<\/p>\n

Consider an investment represented by a series of cash flows CF0<\/sub>, CF1<\/sub>, CF2<\/sub>, \u2026, CFT<\/sub>, which take into account the revenues and expenses of the project computed or forecasted at time 0 leading to capital inflows and outflows for the firm. The NPV of this investment is given by:<\/p>\n

\"NPV<\/center><\/p>\n

where r is the discount rate that takes into account the risk of the project.<\/p>\n

The IRR corresponds to the value of the discount rate for which the NPV is equal to 0:<\/p>\n

\"IRR\"<\/center><\/p>\n

The IRR is the solution of a non-linear equation:<\/p>\n

\"IRR\"<\/center><\/p>\n

Note that this equation may have one solution, several solutions or no solution according to the sequence of cash flows.<\/p>\n

The internal rate of return (IRR) is an important indicator in the decision-making process as it measures the financial performance of a project. The IRR is a relative measure as its unit is a percentage. The NPV is an absolute measure as its unit is the euro, the dollar, etc.<\/p>\n

It makes it possible to measure the future financial performance of a project or a company. The higher the IRR is, the more interesting it is to launch the project.<\/p>\n

The IRR can therefore be used in the case of a choice to be made between different investment perspectives, but also to evaluate the company’s share buyback programs.<\/p>\n

A limit of using the IRR method is that it does not consider the size of a project. Cash flows are simply compared to the amount of capital outlay generating those cash flows. In other words, considering two projects A and B, the IRR of A may be lower than the IRR of B, while the NPV of A may be higher than the NPV of B.<\/p>\n

The IRR function in Excel<\/h2>\n

How to use the IRR function in Excel?<\/h3>\n

In Excel, you can get the IRR function in the \u201cFormulas\u201d tab.
\nYou can also type \u201c= IRR (value, [guess])\u201d in the cell where you want to compute the IRR.<\/p>\n

The IRR function uses the following arguments:<\/p>\n