OquiliaOquiliaOquilia — India's Financial Intelligence Platform
Calculators
Compare
Tax
NRI
News
Consult
Oquilia Advisor
HomeCalculatorsConsultNews

Talk to Subodh Bajpai · Advocate

Free 15-min phone consultation. No payment, no signup.

+91 84008 60008Or view paid consultations from ₹5,000 →
View All CalculatorsSIP CalculatorEMI CalculatorIncome TaxFD CalculatorPPF CalculatorAll 150+ Calculators
View All CompareHome Loan RatesPersonal LoansCredit CardsHealth InsuranceTerm InsuranceMutual FundsFD RatesEducation Loan
View All TaxOld vs New RegimeTax Saving under 80CIncome Tax Slabs 2025Capital Gains TaxSave Tax on SalaryITR Filing Guide
View All NRINRI Investment GuideNRI Tax FilingNRI Banking & NRE FDNRI Real EstateDTAA CalculatorNRE FD Calculator
View All NewsLatest NewsSubodh's Law ColumnSARFAESI DefenceBlog / GuidesReports
View All ConsultFree 15-min call · +91 84008 60008DTAA Review · ₹5,000FEMA Compounding · ₹15,000NRI Tax Filing Review · ₹7,500About Subodh Bajpai, Advocate
View All ToolsAm I Underinsured?Policy AuditJargon DecoderMutual Fund Discovery
For Business
View All LearnFinancial GlossaryFAQAbout OquiliaContact
Oquilia Advisor
  1. Home
  2. Calculators
  3. Corporate Finance
  4. IRR Calculator
Reviewed byRohan Desai, CFA·26 April 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.

Verified Formula·Source: CFA Institute & SEBI guidelines·Last verified: April 2026Methodology
OquiliaOquiliaOquilia — India's Financial Intelligence Platform
Calculators
Compare
Tax
NRI
News
Consult
Oquilia Advisor
HomeCalculatorsConsultNews

Talk to Subodh Bajpai · Advocate

Free 15-min phone consultation. No payment, no signup.

+91 84008 60008Or view paid consultations from ₹5,000 →
View All CalculatorsSIP CalculatorEMI CalculatorIncome TaxFD CalculatorPPF CalculatorAll 150+ Calculators
View All CompareHome Loan RatesPersonal LoansCredit CardsHealth InsuranceTerm InsuranceMutual FundsFD RatesEducation Loan
View All TaxOld vs New RegimeTax Saving under 80CIncome Tax Slabs 2025Capital Gains TaxSave Tax on SalaryITR Filing Guide
View All NRINRI Investment GuideNRI Tax FilingNRI Banking & NRE FDNRI Real EstateDTAA CalculatorNRE FD Calculator
View All NewsLatest NewsSubodh's Law ColumnSARFAESI DefenceBlog / GuidesReports
View All ConsultFree 15-min call · +91 84008 60008DTAA Review · ₹5,000FEMA Compounding · ₹15,000NRI Tax Filing Review · ₹7,500About Subodh Bajpai, Advocate
View All ToolsAm I Underinsured?Policy AuditJargon DecoderMutual Fund Discovery
For Business
View All LearnFinancial GlossaryFAQAbout OquiliaContact
Oquilia Advisor
  1. Home
  2. Calculators
  3. Corporate Finance
  4. IRR Calculator

Corporate Finance

IRR Calculator

Calculate Internal Rate of Return (IRR) and Modified IRR (MIRR) for capital investment projects. Compare against your hurdle rate to make accept/reject decisions.

Verified Formula·Source: CFA Institute & SEBI guidelines·Last verified: April 2026Methodology

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 (typically the WACC), and reject it if the IRR falls below the hurdle rate. For Indian companies, the hurdle rate typically ranges from 10-15% depending on the industry, company size, and risk profile. IT services firms with low capital intensity might use 12%, while capital-heavy manufacturing or infrastructure companies might require 14-16%.

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. In such cases, NPV should be the primary decision criterion. 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 significantly overstate returns for projects with high IRRs. For all these reasons, always use IRR alongside NPV and MIRR.

IRR in Indian Corporate Practice

In India, IRR is extensively used for project finance decisions by banks, NBFCs, and infrastructure investors. The Reserve Bank of India and SEBI expect companies to disclose project return metrics in certain contexts. Private equity funds evaluating Indian investments typically target gross IRRs of 20-25%, while infrastructure debt funds may accept 10-14%. Understanding the distinction between project IRR (unleveraged) and equity IRR (leveraged, and therefore higher) is crucial for proper analysis.

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

CalculatorsInsuranceInvestTaxLoansNRIMBAHNIAI
Oquilia

150+ calculators · Zero commissions

Oquilia

Intelligent financial analysis. 150+ calculators & unbiased analysis.

Data: IRDAI · RBI · SEBI · AMFI

Calculators

  • SIP
  • EMI
  • Income Tax
  • FD
  • PPF
  • NPS
  • Gratuity
  • HRA
  • ELSS
  • All 150+

Insurance

  • Compare Plans
  • Companies
  • Claims Data
  • Hospitals
  • Health Premium
  • Term Premium
  • Section 80D

Tax & Loans

  • Old vs New
  • Capital Gains
  • TDS
  • Home Loan EMI
  • Car Loan EMI
  • Rent vs Buy
  • Prepayment

More Tools

  • Invest Hub
  • Tax Planning
  • Loan Tools
  • NRI Hub
  • MBA Finance
  • HNI Wealth
  • Glossary
  • News
  • Blog
  • Reports
  • Tools
  • Oquilia Advisor

Company

  • About
  • Contact
  • FAQ
  • Legal Hub
  • Privacy
  • Terms
  • Disclaimer
  • Cookie Policy
  • Grievance
  • Disclosure

Newsletter

Monthly digest

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

Reviewed by Subodh Bajpai, Senior Partner & MBA Finance (XLRI)

Legal & Grievance Partner: Unified Chambers & Associates, Delhi High Court

Designed & developed by QX137, React & Next.js studio

© 2026 Oquilia. Not a licensed financial advisor. All third-party logos and trademarks belong to their respective owners.

PrivacyTermsDisclaimerSitemap

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 Benchmarks in the Indian Market

Benchmarks vary sharply by asset class. Indian private equity funds target net IRRs of 20 to 25 percent over a 5 to 7 year fund life. Venture capital funds aim for 25 to 35 percent net IRR, given the higher loss ratio on individual investments. Infrastructure funds and InvITs operating in power, roads, and telecom typically deliver 10 to 14 percent IRR because of long stable cash flows and lower risk. Real estate development projects in tier-1 metros target 18 to 22 percent pre-tax IRR. Corporate capex proposals usually need to beat a 13 to 15 percent hurdle rate that reflects WACC plus a risk premium.

IRR for Capital Budgeting Decisions

Indian CFOs and corporate finance teams use IRR as one of three primary capex screening tools, alongside NPV and payback period. 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 should be used in such cases.

Ignoring scale: A Rs 10 lakh project with 40 percent IRR adds less value than a Rs 10 crore project with 18 percent IRR, even though the former looks better in percentage terms. Always cross-check with NPV.

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. Typical Indian PE deals underwrite at 22 to 25 percent deal IRR, assuming a 5-year hold and exit via IPO, secondary sale, or strategic acquisition. The General Partner's carried interest is typically triggered only after the fund crosses a preferred return (hurdle) of 8 percent. High IRR alone is not sufficient: investors also examine the Multiple on Invested Capital (MOIC), which measures absolute value created.

Regulatory and Disclosure Context

SEBI's disclosure norms for InvITs and REITs require sponsors to disclose project-level and portfolio IRRs in offer documents. RBI's external commercial borrowing (ECB) framework uses IRR indirectly through the all-in-cost ceilings. Companies listed on BSE and NSE disclose IRR in strategic capex approvals, especially in sectors like power and telecom. For individual taxpayers, the IRR concept is also relevant when evaluating ULIP, PMS, and alternative investment fund returns on a post-tax basis.

Frequently Asked Questions

What is considered a good IRR in India?

For Indian corporates, an IRR above 15 percent is usually considered attractive because it exceeds the average cost of capital (10 to 12 percent) by a comfortable margin. Private equity funds target 20 to 25 percent IRR, while venture capital funds target 25 to 35 percent to compensate for higher risk. Infrastructure projects with long tenures typically accept 12 to 15 percent IRR. The threshold depends on the alternative return available at similar risk, commonly referred to as the hurdle rate.

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. Always use XIRR when projects have mid-year or quarterly cash flows to get accurate annualised returns.

Should I use IRR or NPV for investment decisions?

When the two metrics conflict, NPV is the superior criterion because it directly measures value addition in rupee terms. 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. In practice, Indian CFOs and board members use both: NPV for the final go or no-go decision, and IRR to check whether returns exceed the cost of capital.

CalculatorsInsuranceInvestTaxLoansNRIMBAHNIAI
Oquilia

150+ calculators · Zero commissions

Oquilia

Intelligent financial analysis. 150+ calculators & unbiased analysis.

Data: IRDAI · RBI · SEBI · AMFI

Calculators

  • SIP
  • EMI
  • Income Tax
  • FD
  • PPF
  • NPS
  • Gratuity
  • HRA
  • ELSS
  • All 150+

Insurance

  • Compare Plans
  • Companies
  • Claims Data
  • Hospitals
  • Health Premium
  • Term Premium
  • Section 80D

Tax & Loans

  • Old vs New
  • Capital Gains
  • TDS
  • Home Loan EMI
  • Car Loan EMI
  • Rent vs Buy
  • Prepayment

More Tools

  • Invest Hub
  • Tax Planning
  • Loan Tools
  • NRI Hub
  • MBA Finance
  • HNI Wealth
  • Glossary
  • News
  • Blog
  • Reports
  • Tools
  • Oquilia Advisor

Company

  • About
  • Contact
  • FAQ
  • Legal Hub
  • Privacy
  • Terms
  • Disclaimer
  • Cookie Policy
  • Grievance
  • Disclosure

Newsletter

Monthly digest

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

Reviewed by Subodh Bajpai, Senior Partner & MBA Finance (XLRI)

Legal & Grievance Partner: Unified Chambers & Associates, Delhi High Court

Designed & developed by QX137, React & Next.js studio

© 2026 Oquilia. Not a licensed financial advisor. All third-party logos and trademarks belong to their respective owners.

PrivacyTermsDisclaimerSitemap