IRR (Internal Rate of Return): Your Project's True Profitability

The IRR, or Internal Rate of Return, is a sophisticated financial metric used in investment analysis to estimate the profitability of a project or asset. Technically, IRR is the discount rate that makes the Net Present Value (NPV) of all cash flows (both inflows and outflows) of a project equal to zero. In simpler terms, IRR represents the annual rate of return an investment is expected to generate. It is one of the most powerful tools for capital allocation decision-making.

To understand IRR, one must first grasp the concept of Net Present Value (NPV). NPV calculates the present-day value of all future cash flows a project will generate, discounted by a rate that represents the opportunity cost of capital (the so-called Minimum Acceptable Rate of Return - MARR). The MARR is the minimum return an investor is willing to accept for that investment, considering the risks involved. If a project's NPV is positive, it means it is financially viable, as its return is greater than the opportunity cost. If it is negative, the project should be rejected.

IRR takes this analysis a step further. Instead of asking, “Is the project viable at a certain rate?”, it asks, “What is the exact rate of return for this project?”. Calculating IRR is complex and typically done with financial calculators or spreadsheets (using the =TIR() or =IRR() function). Once calculated, the decision rule is simple: if a project's IRR is greater than the Minimum Acceptable Rate of Return (MARR), the project should be accepted. If it is lower, it should be rejected.

Example in an entrepreneur's routine:

An entrepreneur is evaluating the purchase of a new machine for his factory. The machine costs R$ 100,000 (initial investment, or cash flow in year 0). He estimates that the machine will generate cost savings (i.e., a net cash inflow) of R$ 30,000 per year for the next 5 years. The company's Minimum Acceptable Rate of Return (MARR) is 12% per year (which is the return he could obtain from an alternative investment with similar risk).

The project's cash flow is:

• Year 0: - R$ 100,000
• Year 1: + R$ 30,000
• Year 2: + R$ 30,000
• Year 3: + R$ 30,000
• Year 4: + R$ 30,000
• Year 5: + R$ 30,000

Using a spreadsheet, he calculates the IRR for these cash flows and finds a value of 15.24% per year.

Now, he compares the IRR with the MARR:

• IRR = 15.24%
• MARR = 12.00%

Since the IRR (15.24%) is greater than his minimum required rate (12%), the investment in the machine is considered attractive and should be made. The project not only pays for itself but also generates an excess return above the opportunity cost of capital.

Now, imagine the entrepreneur has a second investment option: investing the same R$ 100,000 in a marketing campaign that, according to projections, would generate cash flows resulting in an IRR of 20%. Having to choose between the two projects (as his capital is limited), he should opt for the marketing campaign, as it offers higher profitability. IRR is, therefore, an essential tool for prioritizing and selecting the best projects for allocating the company's scarce resources.