Internal Rate of Return – Meaning, Formula and Usage (2024)

Capital budgeting is a function of management, which uses various techniques to assist in decision making. Internal Rate of Return (IRR) is one such technique of capital budgeting. It is the rate of return at which the net present value of a project becomes zero. They call it ‘internal’ because it does not take any external factor (like inflation) into consideration.

Introduction

The internal rate of return (IRR) is a discounting cash flow technique which gives a rate of return earned by a project. The internal rate of return is the discounting rate where the total of initial cash outlay and discounted cash inflows are equal to zero. In other words, it is the discounting rate at which the net present value (NPV) is equal to zero.

How is the Internal Rate of Return computed?

For the computation of the internal rate of return, we use the same formula as NPV. To derive the IRR, an analyst has to rely on trial and error method and cannot use analytical methods. With automation, various software (like Microsoft Excel) is also available to calculate IRR. In Excel, there is a financial function that uses cash flows at regular intervals for calculation.

Internal Rate of Return – Meaning, Formula and Usage (1)

The rate at which the cost of investment and the present value of future cash flows match will be considered as the ideal rate of return. A project that can achieve this is a profitable project. In other words, at this rate the cash outflows and the present value of inflows are equal, making the project attractive.

How is IRR used for capital budgeting?

If the same costs apply for different projects, then the project with the highest IRR will be selected. If an organization needs to choose between multiple investment options wherein the cost of investment remains constant, then IRR will be used to rank the projects and select the most profitable one. Ideally, the IRR higher than the cost of capital is selected.

In real life scenarios, since the investment in any project will be huge and will have a long-term effect, an organization uses a combination of various techniques of capital budgeting like NPV, IRR and payback period to select the best project.

Illustration

Let us say a company has an option to replace its machinery.
The cost and return are as follows:
Initial investment = Rs.5,00,000
Incremental increase per year = Rs.2,00,000
Replacement value = Rs.45,270
Life of asset = 3 years
If we assume IRR to be 13%, the computation will be as follows.

YearCash flowsDiscounted cash flowsComputation
0-5,00,000-500000(5,00,000 * 1)
12,00,0001769912,00,000 * (1/1.13)1
22,00,0001562292,00,000 * (1/1.13)2
32,00,0001386102,00,000 * (1/1.13)3
445,2702776545,270 * (1/1.13)4

The total of the column Discounted Cash Flows approximately sums up to zero making the NPV equal to Zero. Hence, this discounted rate is the best rate. As can be seen from the above, using the rate of 13%, the cash flows, both positive and negative become minimum.

Hence, it is the best rate of return on investment. The cost of capital of the company is 10%. Since the IRR is higher than the cost of capital, the project can be selected.

If the company has another opportunity to invest the money in a project that gives a 12% return, the company will still go in for the machinery replacement since it gives the highest IRR.

What are the shortcomings of the method?

As mentioned earlier, IRR is widely used and adopted by many companies in combination with other techniques for capital budgeting. However, this method has some shortcomings.

  • IRR does not take into consideration the duration of the project.
    Example, if the company has to choose between two projects – Project A with IRR 15% and duration is one year and Project B with IRR 20% and project duration is 5 years and the cost of capital of the company is 10% – both the projects are profitable. If the company selects Project B because it has a higher IRR it would be incorrect as the duration of Project B is longer.
  • IRR assumes that the cash flows are reinvested at the same rate as the project, instead of the cost of capital. Hence, IRR may not give a true picture of the profitability.

Given the shortcomings of the method, analysts are using the Modified Internal Rate of Return. It assumes that the positive cash flows are reinvested at the cost of capital and not IRR.

IRR and NPV together can help one understand the profitability of the project and also choose the most suitable project with a positive NPV. Further, users can compare the IRR of different projects and go for the most profitable one.

Related Articles

Internal Rate of Return – Meaning, Formula and Usage (2)

File your returns in just 3 minutes

100% pre-fill. No manual data entry

As a seasoned financial expert with a comprehensive understanding of capital budgeting, particularly in the realm of Internal Rate of Return (IRR), I can offer insights and evidence-based knowledge to shed light on this critical financial concept.

Internal Rate of Return (IRR): Unveiling the Depths of Capital Budgeting

Capital budgeting, an integral function of management, involves employing diverse techniques to facilitate decision-making in investments. Among these techniques, the Internal Rate of Return (IRR) stands out as a pivotal tool. IRR is the rate of return at which the net present value (NPV) of a project equals zero, making it a key metric in evaluating the profitability of an investment.

Computation of Internal Rate of Return: A Blend of Art and Automation

To compute IRR, the same formula as NPV is used, but unlike NPV, IRR relies on a trial and error method. However, in the modern era, automation has streamlined this process, with software like Microsoft Excel offering efficient calculation through dedicated financial functions. The ideal rate of return is the point at which the cost of investment aligns with the present value of future cash flows, indicating a profitable project.

Utilizing IRR in Capital Budgeting Decisions

In capital budgeting scenarios where costs are constant across projects, IRR serves as a crucial metric for project selection. Organizations often opt for the project with the highest IRR when faced with multiple investment options of similar cost. Ideally, projects with IRR higher than the cost of capital are preferred. However, in real-life applications, a combination of capital budgeting techniques, including NPV, IRR, and payback period, is often employed to ensure a comprehensive evaluation.

Illustrating IRR in Action: Machinery Replacement Case

Consider a scenario where a company contemplates replacing machinery. Through a detailed illustration involving initial investment, incremental increase per year, replacement value, and life of the asset, the computation of IRR is demonstrated. The chosen rate of 13% yields zero NPV, affirming its status as the optimal rate of return. This rate, higher than the company's cost of capital, validates the project's viability.

Shortcomings of IRR and the Rise of Modified Internal Rate of Return (MIRR)

While IRR is widely adopted, it has limitations. It neglects project duration, potentially leading to flawed decisions when comparing projects of different durations. Additionally, IRR assumes cash flows are reinvested at the project's rate, not the cost of capital, which may distort profitability assessments. In response, analysts are turning to the Modified Internal Rate of Return, considering reinvestment at the cost of capital. Combining IRR and NPV provides a holistic view of profitability and aids in selecting the most suitable projects.

In conclusion, the Internal Rate of Return stands as a vital component in the toolkit of capital budgeting, contributing to informed decision-making in the complex landscape of financial investments.

Internal Rate of Return – Meaning, Formula and Usage (2024)
Top Articles
Latest Posts
Article information

Author: Clemencia Bogisich Ret

Last Updated:

Views: 6309

Rating: 5 / 5 (60 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Clemencia Bogisich Ret

Birthday: 2001-07-17

Address: Suite 794 53887 Geri Spring, West Cristentown, KY 54855

Phone: +5934435460663

Job: Central Hospitality Director

Hobby: Yoga, Electronics, Rafting, Lockpicking, Inline skating, Puzzles, scrapbook

Introduction: My name is Clemencia Bogisich Ret, I am a super, outstanding, graceful, friendly, vast, comfortable, agreeable person who loves writing and wants to share my knowledge and understanding with you.