Understanding Internal Rate of Return in Project Evaluation

When evaluating whether a project is worth investing in – whether it’s installing irrigation infrastructure, setting up a food processing unit, or adopting precision farming technology – decision-makers need a reliable way to measure profitability. One of the most widely used tools for this is the Internal Rate of Return (IRR). IRR is the discount rate at which a project’s net present value (NPV) equals zero – it is, in effect, the break-even cost of capital. Understanding IRR helps you determine whether a proposed investment will earn more than it costs, making it central to sound project appraisal.

What is the internal rate of return? 🔗

IRR represents the annualized effective compounded rate of return that sets the NPV of all cash flows – both positive and negative – equal to zero. Put simply, it is the interest rate at which the present value of all future cash inflows exactly equals the initial investment. If a project has an IRR of 18%, it means the investment grows at an annualized rate of 18% over its lifetime in present value terms.

The concept is closely tied to the time value of money – the principle that a rupee received today is worth more than a rupee received in the future. IRR is a robust tool because it does not focus on a single moment in time but factors in the continuous cash flow across future periods. This makes it particularly useful for long-duration projects where income is spread over several years.

In project evaluation, IRR also goes by the name break-even interest rate – because at that rate, the project neither creates nor destroys value in present value terms. When NPV is positive, the project is expected to generate value; when NPV is negative, it is expected to lose value. IRR marks precisely the neutral point between the two.

The decision rule: when to accept or reject a project 🔗

The IRR decision rule is straightforward: if a project’s estimated IRR exceeds the firm’s cost of capital, the investment is profitable; if the IRR is less than the cost of capital, the project should not be undertaken. The cost of capital here refers to the minimum return a project must generate to justify the investment – also called the required rate of return or hurdle rate.

For example, if a farmer can borrow at 9% to fund a drip irrigation system, and the project’s IRR is 16%, the investment is earning 7% above the cost of financing – making it financially justified. If a project’s IRR exceeds the cost of capital, the investment is potentially worthwhile; for most agricultural investments, comparing IRR to current interest rates provides a useful baseline.

When ranking multiple projects, the higher the IRR, the more profitable the potential investment is likely to be, all else being equal. This allows project managers to prioritize among competing alternatives using a common percentage-based metric.

How IRR is calculated 🔗

IRR cannot be solved through simple algebraic rearrangement. In practice, analysts find it through iteration – testing discount rates until the discounted inflows equal the initial outlay. There are two main approaches: the trial and error method and the linear interpolation method.

Trial and error method 🔗

In this approach, you apply different discount rates to the project’s cash flows until you find the one that produces an NPV close to zero. You start with a rate that produces a positive NPV, then try a higher rate until the NPV turns negative. The rate that brings NPV closest to zero is the approximate IRR. While conceptually simple, this can be time-consuming without software tools.

Linear interpolation method 🔗

Before spreadsheets became common, analysts estimated IRR manually by testing two discount rates – one producing a positive NPV and another producing a negative NPV – and then interpolating between them. The closer these two rates are, the more accurate the estimate.

The interpolation formula is:

IRR = a + [NPVa ÷ (NPVa − NPVb)] × (b − a)

Where a is the lower discount rate (producing a positive NPV), b is the higher discount rate (producing a negative NPV), NPVa is the positive NPV at rate a, and NPVb is the negative NPV at rate b.

For instance, if a project with an initial outlay of ₹2,40,000 yields an NPV of +₹6,200 at 15% and an NPV of −₹4,643 at 17%, plugging these into the interpolation formula gives an IRR of approximately 15.79%. Since this exceeds a required rate of return of 13%, the project would be considered feasible.

Today, modern tools simplify this process through spreadsheet functions such as =IRR() or =XIRR() in Excel, with XIRR() handling irregular cash flow dates and returning an annualised rate based on actual timing.

IRR and NPV: how they relate 🔗

IRR and Net Present Value (NPV) are closely related – both are discounted cash flow (DCF) methods that account for the time value of money. NPV represents the monetary amount added to shareholder value in excess of that required to compensate for project risk; IRR expresses the return on a project in relative terms as an average annual compound rate.

The key distinction is that NPV gives an absolute rupee figure (how much value is added), while IRR gives a percentage return (at what rate the project grows). Financial managers and entrepreneurs usually favor performance measurements expressed in percentages rather than absolute values, which is why IRR is widely preferred in practice.

For independent projects (where accepting one does not affect others), both methods generally give consistent recommendations. Projects with a positive NPV also show an IRR greater than the hurdle rate – the two signals align. However, for mutually exclusive projects, the methods can conflict. One project may have a higher IRR while another has a higher NPV. When faced with such a conflict, it is best to choose the project with the larger positive NPV using the cost of capital as the cutoff rate.

Advantages of using IRR 🔗

IRR is a well-established tool in project appraisal for several practical reasons:

Accounts for time value of money: Unlike simple payback methods, IRR discounts future cash flows, recognizing that money received earlier is worth more than money received later.

No pre-specified discount rate needed: IRR can be calculated without a predetermined cost of capital, making it useful when the required rate of return is uncertain or being debated.

Easy to communicate: A percentage return is intuitive and easy to compare against borrowing costs, benchmark rates, or alternative investment options – even for stakeholders without a finance background.

Useful for ranking projects: Companies use IRR to compare different projects and prioritize those that will generate the highest returns.

Limitations of IRR 🔗

Despite its usefulness, IRR has several important limitations that practitioners must keep in mind.

Unrealistic reinvestment assumption 🔗

IRR implicitly assumes that interim cash flows are reinvested at the IRR itself – an assumption that may not always be realistic, especially for projects with high IRRs. If a project has a 20% IRR, the calculation presumes every rupee of intermediate income can also be reinvested at 20%, which is rarely achievable in practice.

Does not reflect absolute scale 🔗

IRR does not account for the overall scale of a project. A smaller investment with a high IRR might generate a lower total profit than a larger project with a slightly lower IRR. Focusing solely on IRR can lead to choosing a less valuable option.

Multiple IRR problem 🔗

In the case of non-normal cash flows – where a project has positive flows followed by negative flows – IRR can take on multiple values, making the decision more difficult. This is common in agricultural investments where cash flows can alternate in sign due to replanting, equipment overhaul, or seasonal expenditures. In such cases, the Modified Internal Rate of Return (MIRR) is a more reliable alternative, as it allows the analyst to specify a separate, realistic reinvestment rate.

Misleading for projects with unequal durations 🔗

A two-year project with a 15% IRR is not necessarily better than a five-year project with a 12% IRR, especially if equivalent short-term alternatives are not available. IRR does not factor in what happens after the project ends or how reinvested proceeds will perform.

IRR in agricultural project evaluation 🔗

In the context of agricultural development, IRR has been applied extensively – from evaluating farm mechanization and drip irrigation to assessing agribusiness ventures and land rehabilitation programs. IRR is considered appropriate for agribusiness investments, particularly in situations where investors use equity funding to finance their projects.

The Food and Agriculture Organization (FAO) and the International Fund for Agricultural Development (IFAD) routinely use IRR-based appraisal in agricultural project evaluations. Research on land rehabilitation in the Sahel region showed that with an optimistic scenario on yield change, a positive economic IRR was found over three years – the minimum period needed to recover the amount invested – while climate and rainfall variability significantly impacted the results, making project profitability rates highly uncertain.

For crop and technology decisions specifically, IRR helps quantify returns: precision agriculture technologies often require large upfront investments, but their long-term efficiency gains can justify the cost if the IRR clears the hurdle rate. Similarly, according to the NCREIF index, the average annual return on farmland over 25 years has been roughly 11-12% – a benchmark that gives investors a reference point when evaluating new agricultural ventures.

One practical approach for agricultural projects is to set a hurdle rate that accounts for the specific risks of farming – weather variability, price fluctuations, and uncertain yields. If risk-free investments yield 4% and agricultural risk justifies at least an additional 6%, the hurdle rate becomes 10%. Any project with an IRR above this threshold can be considered for acceptance.

Best practices when using IRR 🔗

IRR is most effective when used as part of a broader evaluation framework, not as a standalone metric. A few key guidelines:

Combine with NPV: Both NPV and IRR offer a clear framework for decision-making and should be used together – NPV for absolute value creation, IRR for percentage return comparison.

Conduct sensitivity analysis: Given that IRR is only as reliable as the underlying cash flow projections, calculate IRR under optimistic, realistic, and pessimistic scenarios to understand the range of possible outcomes.

Use MIRR for non-conventional cash flows: When cash flows alternate between positive and negative multiple times – as is common in agriculture – the Modified IRR provides a more stable and realistic result by using a separate, specified reinvestment rate.

Set a realistic hurdle rate: If the IRR is greater than a pre-set percentage target, the project is accepted. That target should reflect not just borrowing costs but also the opportunity cost of capital and the specific risk profile of the investment.

What do you think? If two agricultural projects have the same IRR but very different investment sizes and cash flow timings, how would you decide which one to prioritize? And in a sector as weather-dependent as agriculture, how much weight should be given to IRR projections when the underlying cash flows are highly uncertain?

References

1. https://www.wallstreetprep.com/knowledge/irr-internal-rate-of-return/
2. https://en.wikipedia.org/wiki/Internal_rate_of_return
3. https://www.harvestreturns.com/blog/2018/6/15/3-ways-to-measure-agriculture-investment-returns
4. https://clfi.co.uk/resources/internal-rate-of-return-irr-explained/
5. https://www.scribd.com/presentation/464967046/IRR-calculations-through-interpolation
6. https://corporatefinanceinstitute.com/resources/valuation/npv-vs-irr/
7. https://twproject.com/blog/net-present-value-npv-internal-rate-return-irr-project-selection-methods/
8. https://www.bajajfinserv.in/investments/net-present-value-vs-internal-rate-of-return
9. https://blog.paradigmshift.training/demystifying-the-internal-rate-of-return-a-key-to-passing-management-information/
10. https://www.calculator.net/irr-calculator.html
11. https://www.researchgate.net/publication/369424417_The_Use_of_IRR_and_NPV_in_Agribusiness_Investments_Outline
12. https://www.iamm.ciheam.org/ress_doc/opac_css/doc_num.php?explnum_id=11440
13. https://info.acretrader.com/blog/whats-the-irr-of-farmland
14. https://www.efinancialmodels.com/irr-vs-npv-in-the-context-of-financial-decision-making/
15. https://www.accaglobal.com/in/en/student/exam-support-resources/foundation-level-study-resources/ffm/ffm-technical-articles/the-internal-rate-of-return.html