What is IRR (Internal Rate of Return) in Mutual Funds?

     

    Listen to our Podcast: Grow your wealth and keep it secure.

    0:00 / 0:00

    Summary :

    The internal rate of return or IRR is one of the most useful financial metrics to understand the return-generating potential of a project. In financial terms, IRR is the discount rate at which a project’s net present value is zero. By comparing the IRR of two projects, a manager can decide which one to invest in. Hence, IRR helps companies allocate capital to projects that have better return-generating potential than other projects. As IRR is expressed in terms of percentage, it is simple to understand and interpret. While it has many benefits, it has a few limitations as well. For example, if two projects have vastly different durations or cash flows, then IRR cannot be used to compare them.


    The internal rate of return (IRR) denotes the return an investment can generate. While calculating it, we exclude external factors, like cost of capital and inflation. Hence, it is called the “internal” rate of return.

    IRR is extremely important, as it helps business leaders assess the profitability of an investment. In most cases, an investment with a higher IRR is better than another with a lower IRR. Read this blog, as it explains the meaning of the internal rate of return, how the internal rate of return works, and many other aspects related to it.

    Internal Rate of Return Definition

    IRR meaning starts with a simple example. Suppose a company is thinking about investing in a factory. It knows how much it will spend building the factory, known as capital expenditure, which counts as a cash outflow today.

    The company must then estimate future cash inflows from the factory. These inflows are typically estimated year by year. Say the factory has a productive life of 20 years, with its value reaching zero at the end of that period. For each of these 20 years, the company estimates expected cash inflows.

    The discount rate at which the present value of all future cash inflows equals the capital expenditure is the internal rate of return. 

    No external factor, such as cost of capital or inflation, is needed for this calculation. Only the estimated cash inflows and outflows matter, which explains the full form of IRR: it measures return using only what happens "inside" the investment itself.

    How to Calculate the Internal Rate of Return (IRR)?

    This section walks through the IRR formula, a worked spreadsheet example, and how IRR is used to compare two investment projects side by side.

    The IRR Formula

    The internal rate of return can be calculated using the following formula:

    0 = CF0 + [CF1/(1+IRR)] + [CF2/(1+IRR)2] + [CF3/(1+IRR)3] +……..+ [CFn/(1+IRR)n]

    In this formula, CF0 stands for the initial investment in a project. CF1, CF2, CF3….. CFn stands for cash flows in future years. N stands for the duration of the project.

    Internal Rate of Return Example Using a Spreadsheet

    Consider the project below. It has a capital outlay in Year 0 (today), so cash flows in Year 0 show as negative.

    From Year 1 to Year 10, the project generates cash inflows. All these numbers go into a spreadsheet. At 5% IRR, the NPV is ₹8,191.

    Since IRR is the rate at which NPV equals zero, the Goal Seek function in MS Excel can be used to find the exact IRR.

    IRR5.00% 
     Cash flowsPresent Value
    Year 0-1,00,000-1,00,000
    Year 110,0009,524
    Year 215,00013,605
    Year 315,00012,958
    Year 420,00016,454
    Year 520,00015,671
    Year 615,00011,193
    Year 715,00010,660
    Year 810,0006,768
    Year 910,0006,446
    Year 108,0004,911
    Net Present Value (NPV)8,191 

    Using Goal Seek, the IRR comes out to 6.74%, as shown below:

    IRR6.74% 
     Cash flowsPresent Value
    Year 0-1,00,000-1,00,000
    Year 110,0009,368
    Year 215,00013,165
    Year 315,00012,333
    Year 420,00015,405
    Year 520,00014,432
    Year 615,00010,140
    Year 715,0009,500
    Year 810,0005,933
    Year 910,0005,558
    Year 108,0004,166
    Net Present Value (NPV)0 

    Comparing Two Projects

    Suppose a company wants to invest in one of two projects, A or B, with the same capital expenditure and duration. Using Goal Seek, the respective IRRs come out as follows:

    IRR14.54%  12.20%
     Project A's Cash FlowsPresent ValueProject B's Cash FlowsPresent Value
    Year 0-50,000-50,000-50,000-50,000
    Year 115,00013,09616,00014,260
    Year 220,00015,24618,00014,299
    Year 320,00013,31118,00012,744
    Year 410,0005,81112,0007,572
    Year 55,0002,5372,0001,125
    Net Present Value (NPV)0 0 

    Project A's IRR is higher than Project B's, which would normally favour Project A on this metric alone. However, IRR comparisons assume similar scale and duration, and don't capture every factor relevant to a final investment decision.

    IRR Vs. CAGR Vs. ROI

    IRR, CAGR, and ROI all measure investment performance, but each captures something different. 

    ROI looks only at total profit relative to investment, ignoring time. CAGR assumes one smooth annual growth rate with no interim cash flows. IRR is the only one of the three that accounts for both the size and timing of every cash flow in a series.

    Metric

    What It Measures

    Accounts for Timing?

    Best Suited For

    ROI

    Net profit divided by initial investment, as a percentage

    No

    Simple, single cash flow comparisons

    CAGR

    Annualised growth rate, assuming reinvestment and no interim flows

    No

    Mutual fund performance reporting (AMFI standard)

    IRR

    Annualised return accounting for all cash flows and their timing

    Yes

    Projects or investments with multiple, uneven cash flows

    A simple example: investing ₹1,00,000 today and receiving ₹30,000, ₹40,000, and ₹50,000 at the end of Years 1, 2, and 3, respectively, works out to an IRR of approximately 8.9%, since this accounts for exactly when each rupee was received. (Source: SEBI)

    Additional Read: How to Calculate Mutual Funds Returns

    Why IRR Matters in Investments

    The internal rate of return helps investors assess which project to invest in. Let us say that a company has to decide whether to invest in Project X or Project Y. It can compare the IRR of these two projects and invest in the project with a higher IRR. Besides, often companies do not have sufficient financing to invest in all projects. In such a situation, they can compare the IRR of various projects and decide which projects are worth pursuing.

    The internal rate of return also helps investors compare a project’s actual IRR with its projected IRR. If the actual rate is higher than the projected rate, it is a good sign. However, if the actual rate is lower than the projected rate, then investors need to analyse why this is the case.

    Once they have identified the reasons for a lower than expected IRR, they can take corrective action.

    Additional Read: Call and Put Options: Meaning, Types & Examples 

    Benefits of the Internal Rate of Return

    The main benefits of internal rate of return are explained below:

    • Consider the time value of money: Several financial metrics, like payback period, do not consider the time value of money. However, the internal rate of return considers the time value of money. The fact is that the value of money deteriorates over time due to factors like inflation. Hence, by considering the time value of money, IRR provides investors with a realistic picture of a project.

    • Based on cash flows: IRR is based on cash flows. However, many other indicators use net profit, which is an accrual concept. While calculating net profit, a business considers all those incomes that it should have received and not those that it actually received. Similarly, it considers all the expenses that it ought to have paid and not the expenses it actually paid. However, cash flows are based on the actual cash inflows and outflows of a business. Hence, IRR is a better indicator.

    • Easy to interpret: As IRR is expressed in terms of a percentage, it is easy to understand and interpret. If a company has to decide whether to invest in a project, it has to check whether its IRR is higher or lower than a comparable project.

    Limitations of IRR

    While the internal rate of return has its advantages, it has certain limitations as well, which are explained below:

    • Should not be used alone: When IRR is used alone, it can result in misleading conclusions. Let us say that Project A has 12% IRR and Project B has 15% IRR. It seems that Project B is better than Project A. However, Project A is for 20 years, while Project B is for only 5 years. As the duration of these projects is considerably different, IRR alone will not help an investor make a decision.

    • Does not consider the relative size of an investment: Let us take the same example. Suppose Project A and B have the same duration. However, Project A requires an investment of ₹100 crores, while Project B needs an outlay of ₹10 crores. As the respective outlay on the projects are vastly different, the net returns they will generate in absolute terms are also considerably different. Hence, IRR will not help us make a decision.

    IRR in Share Market and Trading Decisions

    • Application of IRR in Stock Market Investments: The internal rate of return can be applied effectively while making stock market investments. Suppose a stock is trading at ₹100 today, you can calculate its IRR by estimating future cash flows from it, like dividends and its selling price. If you think its IRR is sufficiently high, you can invest in it, else you can avoid it.

    • How Traders Use IRR to Analyze Stocks: Typically, traders buy stocks for a short period of time. Once they buy a stock, they have to estimate the price at which they will be comfortable selling it. By using the price they have bought a share and the price they would like to sell it at, they can estimate its IRR and make a decision accordingly.

    Frequently Asked Questions

    What is the Internal Rate of Return (IRR) and how is it calculated?

    IRR is the rate at which the net present value of an investment is zero. It is calculated by using this formula:

    0 = CF0  + [CF1/(1+IRR)] + [CF2/(1+IRR)2] + [CF3/(1+IRR)3] +……..+ [CFn/(1+IRR)n]

    Why is IRR important for investment analysis?

    Suppose a company has multiple projects to choose from. It can decide which project to invest in using IRR. Typically, a project with a higher IRR is better than a project with a lower IRR. A company can also compare a project’s actual IRR with its estimated IRR to assess its performance.

    How does IRR differ from Net Present Value (NPV)?

    IRR is the rate at which a project’s NPV is zero. However, NPV is the difference between the present value of a project’s cash inflows and the present value of its cash outflows.

    What are the limitations of using IRR in financial decision-making?

    The internal rate of return (IRR) does not consider the relative size of an investment and the duration of an investment. In case, two projects have significantly different capital expenditure or duration, then it becomes meaningless to compare their IRR

    Can IRR be used to evaluate stock market investments?

    Yes, IRR can be used to evaluate stock market investments by calculating the cash outflows and inflows from such investments and then finding the discount rate at which their NPV is zero.

    No Result Found

    Disclaimer :

    Investments in securities market are subject to market risk, read all related documents carefully before investing. This content is for educational purposes only. Securities quoted are exemplary and not recommendatory.


    The information on this website is provided on "AS IS" basis. Bajaj Broking (BFSL) does not warrant the accuracy of the information given herein, either expressly or impliedly, for any particular purpose and expressly disclaims any warranties of merchantability or suitability for any particular purpose. While BFSL strives to ensure accuracy, it does not guarantee the completeness, reliability, or timeliness of the information. Users are advised to independently verify details and stay updated with any changes. The securities are quoted as an example and not as a recommendation. Past performance is not necessarily a guide to future performance.

    The information provided on this website is for general informational purposes only and is subject to change without prior notice. BFSL shall not be responsible for any consequences arising from reliance on the information provided herein and shall not be held responsible for all or any actions that may subsequently result in any loss, damage and/or liability. Interest rates, fees, and charges etc., are revised from time to time, for the latest details please refer to our Pricing page.

    Neither the information, nor any opinion contained in this website constitutes a solicitation or offer by BFSL or its affiliates to buy or sell any securities, futures, options or other financial instruments or provide any investment advice or service.

    BFSL is acting as distributor for non-broking products/ services such as IPO, Mutual Fund, Insurance, PMS, and NPS. These are not Exchange Traded Products. For more details on risk factors, terms and conditions please read the sales brochure carefully before investing.



    Content Partner - Dalal Street Investment Journal Wealth Advisory Private Limited



    This article is for educational purposes only and should not be considered investment advice. Market investments are subject to risks. DSIJ Wealth Advisory Private Limited is a SEBI-registered Research Analyst (Reg. No: INH000006396) and Investment Adviser (Reg. No: INA000001142). Please consult your financial adviser before investing. 

    For more disclaimer, check here : https://www.bajajbroking.in/disclaimer

    Read More Blogs

    Publish Date: 01 Oct 2026

    Our Secure Trading Platforms

    Level up your stock market experience: Scan the QR to download the Bajaj Broking App for effortless investing and trading

    Scan the QR code to download Bajaj Broking App

    1 M+ Users

    4.8 App Rating

    4 Languages

    ₹8,422 Cr+ MTF Book

    Open Your Free Demat Account

    Access Research Backed Stock Recommendations

    +91

    |

    Open Your Free Demat Account

    Access Research Backed Stock Recommendations

    +91

    |