OquiliaOquiliaOquilia — India's Financial Intelligence Platform
HomeCalculatorsInvestigationsNews
View All CalculatorsSIP CalculatorEMI CalculatorIncome TaxFD CalculatorPPF CalculatorAll 150+ Calculators
View All CompareHome Loan RatesPersonal LoansCredit CardsHealth InsuranceTerm InsuranceMutual FundsFD RatesEducation Loan
View All GuidesTax: Old vs New RegimeIncome Tax SlabsITR Filing GuideNRI Investment GuideNRI Tax GuideInsurance HubLoans HubLoan App Harassment HelpRetirement PlanningInvest HubHNI WealthFinancial Glossary
View All ToolsAm I Underinsured?Policy AuditJargon DecoderMutual Fund CategoriesBlog & Explainers
View All MoreAbout OquiliaReport FraudRefund TrackerContactBrand ConnectElection AdvertisingFor BusinessFAQ
  • Home
  • Latest
  • Live
  • Enforcement
  • Courts
  • Markets
  • Market X-Ray
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Startups
  • Investigations
  • Bribe Tracker
  • Elections
  • Data Audit
  • हिन्दी
Report fraud
  1. Home
  2. Calculators
  3. Corporate Finance
  4. IRR Calculator
Reviewed byOquilia Research Desk·17 November 2026
Corporate

Internal Rate of Return (IRR) Calculator

Calculate the IRR of any investment or project in seconds. Evaluate capex proposals, private equity deals, and real estate investments against your hurdle rate.

Method: Standard corporate finance formulasMethodology

Project Cash Flows

Rs.

Annual Cash Flows

Rs.
Rs.
Rs.
Rs.
Rs.

Rate Assumptions

%
%
%

Formula

NPV = 0 = sum(CF_t / (1+IRR)^t)

MIRR = (FV+/PV-)^(1/n) - 1

IRR is the discount rate making NPV zero. MIRR assumes reinvestment at a specified rate (more realistic than IRR which assumes reinvestment at the IRR itself). Finance rate is used for discounting negative cash flows.

Internal Rate of Return

19.71%

MIRR: 16.56% | NPV at {hurdleRate}%: ₹22.10 L

ACCEPT PROJECT

IRR (19.71%) is above the hurdle rate (12.0%)

IRR

19.71%

vs 12% hurdle

MIRR

16.56%

Modified return

NPV

₹22.10 L

At hurdle rate

Cash Flow Profile

IRR: 19.71%

Cash Flow Summary

YearCash FlowCumulative
Y0-₹1.00 Cr-₹1.00 Cr
Y1₹25.00 L-₹75,00,000
Y2₹30.00 L-₹45,00,000
Y3₹35.00 L-₹10,00,000
Y4₹40.00 L₹30.00 L
Y5₹45.00 L₹75.00 L

Payback Period

Investment recovery analysis

DCF Valuation

Intrinsic value analysis

Internal Rate of Return (IRR): The Complete Guide for Capital Budgeting

The Internal Rate of Return (IRR) is one of the most important metrics in corporate finance and project evaluation. It represents the discount rate at which the net present value (NPV) of all cash flows from a project equals zero. In simple terms, IRR tells you the annualised effective rate of return that a project is expected to generate. If the IRR exceeds the company's cost of capital or hurdle rate, the project is worth pursuing because it creates value for shareholders.

How IRR Is Calculated

The IRR cannot be solved algebraically for most real-world cases. Instead, it is found through iterative numerical methods. Our calculator uses the Newton-Raphson method, which converges rapidly for well-behaved cash flow patterns, with a bisection fallback for edge cases. The process starts with an initial guess and iteratively refines the discount rate until NPV converges to zero within a tiny tolerance (one ten-millionth of a rupee).

Modified Internal Rate of Return (MIRR)

A well-known criticism of IRR is that it implicitly assumes all interim cash flows are reinvested at the IRR itself, which may be unrealistic for projects with very high or very low IRRs. The Modified IRR (MIRR) addresses this by using two separate rates: a finance rate for discounting negative cash flows to the present, and a reinvestment rate for compounding positive cash flows to the terminal year. MIRR provides a single, unambiguous rate of return even when the conventional IRR produces multiple solutions (which can happen with non-conventional cash flow patterns).

IRR vs Hurdle Rate: The Decision Rule

The basic IRR decision rule is straightforward: accept a project if its IRR exceeds the hurdle rate (often the WACC), and reject it if the IRR falls below the hurdle rate. Each company sets its own hurdle rate from its cost of capital and the project's risk; no standard figure applies.

When IRR Can Mislead

IRR has several well-documented pitfalls. For mutually exclusive projects of different sizes, a smaller project with a higher IRR may have a lower NPV than a larger project with a modest IRR; NPV, which measures value in rupees, ranks them by the value they add. Projects with non-conventional cash flows (alternating positive and negative flows) can produce multiple IRRs or no real IRR at all. The reinvestment rate assumption can overstate returns for projects with high IRRs. NPV and MIRR are not affected by these problems in the same way.

IRR in Indian Corporate Practice

In India, IRR is used in project finance by banks, NBFCs and infrastructure investors, and by private equity and venture funds to report returns. The return each investor requires is its own choice. Project IRR (before borrowing) and equity IRR (after borrowing) differ: when the project earns more than the cost of debt, borrowing lifts the equity IRR.

Practical Tips for IRR Analysis

Always compute both IRR and MIRR. Use MIRR when interim cash flows are likely to be reinvested at a rate different from the project's own IRR (which is usually the case). Run sensitivity analysis by varying key inputs to understand how robust the IRR is to changes in assumptions. For long-duration projects (10+ years), even small changes in cash flow estimates can swing the IRR by several percentage points. Consider scenario analysis (base, optimistic, pessimistic) rather than relying on a single-point IRR estimate.

Disclaimer

This IRR calculator is an educational tool. Actual project evaluations require detailed financial modelling, risk assessment, and sensitivity analysis. IRR alone should not determine investment decisions. This is not financial advice. Consult a qualified corporate finance professional for project appraisal.

Frequently Asked Questions

What Is Internal Rate of Return?

The Internal Rate of Return (IRR) is the single annualised discount rate at which the present value of all future cash inflows from a project exactly equals the initial investment, making the Net Present Value (NPV) zero. Put simply, it is the effective compounded return that an investment generates over its life, accounting for the precise timing of every cash flow. IRR is the most widely used hurdle metric in Indian corporate finance, particularly for capex proposals, private equity exits, real estate development projects, and infrastructure deals.

IRR gives a clean yes-or-no answer when compared to a required return, often called the hurdle rate. If the IRR of a project exceeds the cost of capital, the project creates value; if not, it destroys value. Indian boards routinely see IRR on every capex proposal above Rs 10 crore, and SEBI-regulated InvITs and REITs report project-level IRR in their offering documents.

The Mathematics of IRR

Mathematically, IRR is the rate r that satisfies: Sum of CF_t / (1 + r)^t = 0, where CF_t is the cash flow at time t (the initial investment is a negative cash flow at time 0). There is no closed-form solution for projects with more than two cash flow periods, so IRR is computed iteratively. Excel's IRR function assumes evenly spaced annual cash flows, while XIRR accepts actual dates and is the more accurate choice for real-world projects with irregular timing.

A simple example: an Indian manufacturer invests Rs 50 lakh in new equipment that generates Rs 15 lakh of annual cash flow for 5 years and has Rs 5 lakh salvage value. The IRR is approximately 19.2 percent, comfortably above the typical 10 percent cost of capital, making it a clear value-creating project.

Using the IRR Calculator

The calculator accepts an initial investment and a series of periodic cash flows (positive for inflows, negative for additional outflows). It solves iteratively for the IRR and displays the result with NPV at common discount rates. Use actual post-tax, after-working-capital cash flows rather than accounting profits. Include terminal value or disposal proceeds as the final cash flow for fixed-duration projects.

IRR and Required Returns

The return an investor requires differs by asset class and risk: long-lived assets with steady cash flows, such as infrastructure, are usually priced at lower returns than early-stage ventures with a high failure rate. Each company or fund sets its own hurdle rate; this page does not publish target IRRs.

IRR for Capital Budgeting Decisions

Corporate finance teams often use IRR alongside NPV and payback period to screen capital spending. When projects are independent (accepting one does not preclude another), IRR gives the correct answer as long as the hurdle rate is reasonable. When projects are mutually exclusive, such as two alternative plant locations, NPV is the tie-breaker because IRR ignores project scale and can favour a smaller, higher-IRR project over a larger, value-creating one.

Common IRR Pitfalls

Reinvestment assumption: IRR implicitly assumes that interim cash flows are reinvested at the IRR itself. For high-IRR projects, this is unrealistic. The Modified IRR (MIRR) corrects this by reinvesting at the cost of capital.

Multiple IRRs: Projects with unconventional cash flows (e.g., an inflow followed by an outflow followed by an inflow) can have multiple IRRs or no solution at all. NPV gives a single answer in such cases.

Ignoring scale: At a cost of capital below 18 percent, a Rs 10 lakh project with a 40 percent IRR can add less value than a Rs 10 crore project with an 18 percent IRR, even though the former looks better in percentage terms. NPV shows the difference in rupees.

IRR in Indian M&A and Private Equity

In M&A, acquirers compute transaction IRR based on the purchase price, annual synergies, tax benefits, and the terminal value at exit. Private equity funds model a deal IRR over an expected holding period and exit. A fund's carried interest is often paid only after investors receive a preferred return set in the fund's terms. Because IRR can be high on a short, small gain, investors also look at the Multiple on Invested Capital (MOIC), which measures the absolute value created.

Frequently Asked Questions

What is considered a good IRR in India?

No law or standard sets one. A project earns more than its capital costs when its IRR exceeds the hurdle rate, which each company or investor sets from its cost of capital and the risk of the project. Riskier investments are usually expected to return more. This page does not publish target IRRs for companies or funds.

How is IRR different from ROI?

ROI (Return on Investment) is a simple percentage showing total gain divided by initial investment, ignoring time. IRR is the annualised rate that makes the Net Present Value (NPV) of all cash flows equal to zero, explicitly accounting for the timing of each cash flow. Two projects with identical ROI can have very different IRRs if the cash flows occur at different times. IRR is the more rigorous measure for comparing projects of different durations.

What are the limitations of IRR?

IRR has three known limitations. First, it assumes reinvestment of interim cash flows at the IRR itself, which is often unrealistic. Second, projects with non-conventional cash flows (alternating positive and negative) can have multiple IRRs or no solution. Third, IRR ignores the scale of investment, so a small project with 40 percent IRR might be chosen over a large project with 18 percent IRR even if the latter generates more absolute value. Modified IRR (MIRR) and NPV address these issues.

How do I calculate IRR for a project with irregular cash flows?

IRR is calculated by setting NPV equal to zero and solving for the discount rate. For irregular cash flows, there is no closed-form solution; it requires iterative computation, which is what Excel's IRR and XIRR functions and the calculator above perform. XIRR accepts actual dates and is preferable for cash flows that occur at non-annual intervals. For projects with mid-year or quarterly cash flows, XIRR gives the annualised return on the actual dates.

Should I use IRR or NPV for investment decisions?

When the two metrics conflict, NPV measures the value added in rupees. IRR can mislead when comparing mutually exclusive projects of different sizes or durations. However, IRR is more intuitive for communication with stakeholders and for comparing against a hurdle rate like the cost of capital. Many companies look at both: NPV for the value added, and IRR to compare the return with the cost of capital.

Oquilia

India’s financial newsroom: enforcement, courts, markets and your money, in English and Hindi, from the official record.

Report fraud to our desk

Sections

  • Latest news
  • Fraud & Enforcement
  • Courts
  • Markets
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Elections
  • हिन्दी समाचार

Trackers & data

  • Investigations
  • Bribe Tracker
  • Police bribery cases
  • Report a bribe demand
  • Loan-app enforcement tracker
  • Refund Tracker
  • Data Audit
  • Markets Lab

Tools & guides

  • 150+ calculators
  • Compare loans & cards
  • Compare insurance
  • Tax guides
  • NRI guides
  • Loan app harassment help
  • Topics
  • Glossary

The newsroom

  • About Oquilia
  • Editorial policy
  • Corrections
  • Our journalists
  • Report fraud
  • Contact
  • Syndication
  • Brand Connect
  • Election advertising

Policies

  • Privacy
  • Terms
  • Disclaimer
  • Advertiser disclosure
  • Grievance redressal
  • Cookie policy
  • Legal hub
  • Security
Sections
  • Latest news
  • Fraud & Enforcement
  • Courts
  • Markets
  • Banking & Loans
  • Insurance
  • Tax
  • NRI
  • Elections
  • हिन्दी समाचार
Trackers & data
  • Investigations
  • Bribe Tracker
  • Police bribery cases
  • Report a bribe demand
  • Loan-app enforcement tracker
  • Refund Tracker
  • Data Audit
  • Markets Lab
Tools & guides
  • 150+ calculators
  • Compare loans & cards
  • Compare insurance
  • Tax guides
  • NRI guides
  • Loan app harassment help
  • Topics
  • Glossary
The newsroom
  • About Oquilia
  • Editorial policy
  • Corrections
  • Our journalists
  • Report fraud
  • Contact
  • Syndication
  • Brand Connect
  • Election advertising
Policies
  • Privacy
  • Terms
  • Disclaimer
  • Advertiser disclosure
  • Grievance redressal
  • Cookie policy
  • Legal hub
  • Security

Newsletter

Monthly digest

Policy moves, deadline reminders, and the most-used calculators each month.

We report fromRBISEBIIRDAIPFRDAIBBIIncome Tax DeptAMFI

© 2026 Oquilia. Not investment advice.SitemapRSSX @oquiliaBuilt by QX137