IRR Calculator – Internal Rate of Return India

Why Simple Returns Lie — And IRR Tells the Truth

Teen investment options hain — teeno mein ₹10 lakh invest hota hai. Option A: 5 saal baad ₹17L milenge. Option B: Year 1 mein ₹1L, Year 2 mein ₹2L, Year 3 mein ₹3L, Year 4 mein ₹4L, Year 5 mein ₹8L. Option C: Year 1–4 kuch nahi, Year 5 mein ₹20L.

Naively: Option C winner — 100% absolute return. Lekin time value of money consider karo. Option B early cash flows deta hai — jo reinvest ho sakte hain. Option C sab paise 5 saal lock karta hai. IRR calculate karo: Option A = 11.2%, Option B = 14.3%, Option C = 14.9%. Option C barely better — aur early cash flows ka koi faida nahi. IRR sab reveal karta hai.

IRR = NPV = 0 karne wala discount rate. Yeh metric time value of money correctly capture karta hai — stocks, real estate, business projects, insurance plans, FDs — sab ko ek comparable annual % mein convert karta hai. Agar IRR > hurdle rate → invest karo. IRR < hurdle rate → reject.

IRR Benchmarks & Use Cases — Complete Reference

Investment Type	Typical IRR (India)	IRR vs FD (7.5%)	Decision
FD / PPF	6–7.5%	Baseline	Minimum floor
LIC Endowment / ULIP	4–6%	Below FD	Reject vs FD
Residential Real Estate	12–18%	+5 to +10%	Accept
Equity MF (Nifty 15yr)	~13% XIRR	+5.5%	Accept
Business Equipment	15–25%	+7 to +17%	Usually Accept
Private Equity / VC	20–35%+	+12 to +27%	Accept (high risk)
Startup Investment	25–40%+ target	+17 to +32%	Due diligence needed

IRR vs CAGR vs XIRR — When to Use Which

Metric	Use When	Cash Flow Type	Example
CAGR	Single invest → single exit	2 data points only	Lumpsum MF, FD
IRR	Multiple equal-period cash flows	Annual/quarterly intervals	Real estate, projects
XIRR	Cash flows on specific dates	Irregular dates	SIP, insurance premiums
MIRR	Multiple sign changes in cash flows	–ve → +ve → –ve	Mining, infrastructure

How to Use the IRR Calculator

1

Identify all cash flows with their period — Initial investment at Year 0 (negative). Ongoing income at Years 1–n (positive). Additional costs as negative. Terminal value included in final year.

2

Enter Year 0 as negative — down payment, equipment purchase cost, or any initial outflow. This is your capital deployed. Do not forget transaction costs — registration, stamp duty, brokerage.

3

Enter subsequent cash flows — annual rent (net of expenses), project profits, or business income for each year. Include additional investments as negative values if applicable.

4

Include terminal value in the final year — property sale proceeds, maturity amount, scrap value, or exit valuation. This is often the largest single cash flow and most impactful on IRR.

5

Read IRR and compare with hurdle rate — if IRR exceeds your minimum required return (hurdle rate), the investment creates value. NPV at different discount rates confirms the margin of safety.

Worked Examples

Example 1 Anita — Real Estate Investment IRR (10-Year Hold)

Anita buys a 2BHK for ₹50L. Down payment ₹15L (her actual outflow). Annual net rent (after tax, maintenance): ₹1.5–2.5L growing over time. Sold after 10 years for ₹1.1 crore.

Year	Cash Flow	Description
0	–₹15,00,000	Down payment
1–2	+₹1,50,000/yr	Net rent
3–4	+₹1,75,000/yr	Net rent (increased)
5–6	+₹2,00,000/yr	Net rent
7–8	+₹2,25,000/yr	Net rent
9	+₹2,50,000	Net rent
10	+₹1,12,50,000	Rent + net sale proceeds
IRR		≈ 22.4%

Sensitivity — IRR vs Sale Price: ₹70L sale → 12.1% IRR | ₹90L → 17.8% | ₹1.1Cr → 22.4% | ₹1.3Cr → 26.3%. Terminal value is the single biggest driver of real estate IRR — always run sensitivity analysis on exit price.

Example 2 Rahul — LIC Endowment Plan: What IRR Reveals

Rahul's LIC endowment: ₹50,000/year premium for 20 years. Maturity value: ₹18,00,000. "₹18 lakh for ₹10 lakh invested — 80% return!" Does IRR agree?

Alternative	₹50K/yr for 20 yrs	20-Year Corpus	IRR
LIC Endowment	–₹50,000/yr	₹18,00,000	5.1%
PPF	–₹50,000/yr	₹28,63,695	7.1%
ELSS SIP	–₹50,000/yr	₹49,95,938	12%
Index Fund SIP	–₹50,000/yr	₹56,38,000	13%

LIC's 5.1% IRR is below PPF's 7.1% — and dramatically below equity. The "80% absolute return" story collapses when time-adjusted. Term insurance + mutual fund: same protection + 3× returns. IRR reveals what agents never mention.

Example 3 Priya — Business Equipment: IRR vs Hurdle Rate Decision

Priya's bakery considers buying an automated oven for ₹8,00,000. Expected additional annual profits over 5 years, then scrap value.

Year	Cash Flow	Notes
0	–₹8,00,000	Equipment cost
1	+₹1,50,000	Additional profit
2	+₹2,00,000	Additional profit
3	+₹2,50,000	Additional profit
4	+₹2,50,000	Additional profit
5	+₹3,00,000	Additional profit
6	+₹80,000	Scrap value
IRR	≈ 19.7%	Hurdle rate: 15%

IRR (19.7%) > Hurdle Rate (15%) → Accept. NPV at 15% = +₹72,900 → value created. Decision is clear and data-driven, not gut-feel.

IRR Formulas

1. NPV (Net Present Value)
NPV = Σ [CF_t / (1 + r)^t] for t = 0 to n

2. IRR Definition — NPV = 0
Solve for r: Σ [CF_t / (1 + IRR)^t] = 0 (t = 0 to n)
No closed-form solution — requires numerical iteration

3. Newton-Raphson Iteration
r_(k+1) = r_k – NPV(r_k) / NPV'(r_k)
NPV'(r) = –Σ [t × CF_t / (1 + r)^(t+1)]
Converges when |NPV(r)| < 0.0001

4. MIRR (Modified IRR) — Realistic Reinvestment
PV_neg = Σ |CF_t| / (1 + r_financing)^t (for negative CFs)
FV_pos = Σ CF_t × (1 + r_reinvest)^(n–t) (for positive CFs)
MIRR = (FV_pos / PV_neg)^(1/n) – 1

5. Hurdle Rate Decision
If IRR > Hurdle Rate → Accept (NPV at hurdle rate is positive)
If IRR < Hurdle Rate → Reject (NPV at hurdle rate is negative)
NPV at hurdle rate = Σ [CF_t / (1 + r_hurdle)^t]

Variable Reference

Variable	Meaning	Example
CF_t	Cash flow at period t	–₹10L (t=0), +₹3L (t=1)
n	Total number of periods	5 years
IRR	Internal Rate of Return	14.3% p.a.
r_f	Financing rate (MIRR)	8% (cost of loan)
r_r	Reinvestment rate (MIRR)	10% (alternate return)
NPV	Net Present Value	+₹2,34,000 at hurdle rate

Pro Tips for IRR Analysis

Terminal Value Pe Sensitivity Zaroor Karo

IRR sabse zyada terminal value (exit price) pe sensitive hota hai. ₹50L property — ₹90L ya ₹1.3Cr exit? IRR mein dramatic difference (17.8% vs 26.3%). Range mein socho, point estimate pe nahi.

Insurance IRR Hamesha Calculate Karo

Agent endowment ya ULIP recommend kare — faydemand.in pe premium aur maturity enter karo. Typically 4–6% IRR milta hai — PPF se kam. "₹1 crore milega" — maturity impressive, IRR revealing.

MIRR Use Karo Realistic Estimate Ke Liye

IRR ka weak point: intermediate cash flows ko IRR rate pe reinvest assume karta hai. 20% IRR project — unrealistic. MIRR realistic reinvestment rate (10–12%) use karo — typically 2–5% lower but honest.

Equity IRR vs Project IRR — Leverage Effect

Real estate mein apna paisa (down payment) enter karo — equity IRR higher (leverage effect). Total property cost enter karo — project IRR lower. Dono calculate karo — leverage risk bhi samajh aata hai.

Hurdle Rate Apna Opportunity Cost Set Karo

Business investment ke liye hurdle rate = best alternative use of money. FD 7% → hurdle 7%. Equity 12% expected → hurdle 12%. IRR > hurdle rate toh invest justified. faydemand.in clear Accept/Reject dikhata hai.

Multiple Sign Changes → MIRR Mandatory

Mining, infrastructure: large initial cost (–) → revenues (+) → restoration cost (–). Cash flow sign changes twice. Standard IRR gives multiple conflicting answers. MIRR mandatory for single definitive result.

Scale Blindness — NPV Bhi Dekho

IRR scale ignore karta hai. 20% IRR on ₹1L vs 15% IRR on ₹100L — absolute value dramatically different. IRR se screen karo, NPV se final decision karo. Dono together = complete picture.

Benefits of Calculating IRR

Universal Investment Comparison Real estate, insurance, business equipment, FD, equity — sab alag-alag metrics mein hote hain. IRR sab ko ek comparable annual % mein convert karta hai. Apples-to-apples comparison possible ho jaata hai.

Time Value of Money Correctly Captured Simple return metrics time ignore karte hain. IRR correctly captures: rupee aaj milna rupee 5 saal baad milne se zyada valuable. Early cash flows ka real advantage IRR mein dikh jaata hai.

Insurance Plan Reality Check ₹50,000/year LIC policy — actual IRR 4–6% calculate kiya nahi. faydemand.in IRR calculator ek click mein reveal karta hai ki wahi paisa PPF ya ELSS mein kitna zyada deta. Eye-opening calculation.

Business Decision Support — Accept/Reject Framework Equipment, expansion, new project — subjective "lagta hai profitable" se data-driven "IRR > Hurdle Rate → Accept" mein convert hota hai. No financial jargon knowledge required — clear output milta hai.

MIRR — Honest, Realistic Returns Standard IRR ki reinvestment assumption weakness MIRR solve karta hai. Realistic financing aur reinvestment rates accept karta hai — more conservative, more honest IRR. High-IRR projects jo actually much lower returns denge — MIRR expose karta hai.

Common Mistakes in IRR Calculation

Terminal Value Miss Karna

Real estate IRR — rental income enter ki — property sale value nahi. IRR dramatically underestimated. Terminal value often total return ka 60–70% hota hai long-duration investments mein. Final year mein asset sale ya maturity value include karna mandatory hai.

Absolute Return Se Compare Karna

"LIC ne ₹18 lakh diya ₹10 lakh pe — 80% absolute return" sounds great. IRR: 5.1%. "Real estate 3× return diya 15 saal mein" — IRR = 7.6% only. Absolute return misleads. Time-adjusted IRR always calculate karo.

Costs Exclude Karna Cash Flows Se

Real estate IRR mein: property tax, maintenance, society charges, vacancy losses — sab deduct karke net rental income enter karo. Gross rental without costs → inflated IRR. Garbage in, garbage out — accurate cash flows hi accurate IRR dete hain.

Multiple IRR Problem Ignore Karna

Infrastructure project: construction cost (–) → revenues (+) → decommissioning cost (–). Sign change twice. Standard IRR multiple solutions dega. faydemand.in calculator warning dikhata hai — MIRR use karo aise cases mein.

Hurdle Rate Without Context Report Karna

"IRR 12% hai — achha hai na?" Without hurdle rate context — can't answer. Hurdle rate 15% hai → 12% IRR = reject. Hurdle rate 8% hai → 12% IRR = accept. IRR always hurdle rate ke context mein evaluate karo.

Who Should Use This IRR Calculator

Real Estate Investors Down payment, annual net rent, property sale proceeds enter karo — IRR instantly milega. FD aur equity ke saath compare karo — objective data se property investment decision lo.

Insurance Policyholders Annual premium aur maturity value enter karo — actual IRR dekho. 4–6% IRR typical hota hai endowment plans mein — PPF se kam. Better alternatives identify karo before committing for 20 years.

Business Owners Equipment purchase, expansion, new product launch — cash outflows aur projected inflows enter karo. Hurdle rate set karo. IRR > hurdle rate → invest. Clear data-driven framework for capex decisions.

Finance Students — CA, CFA, MBA IRR, NPV, MIRR numerical problems solve karo instantly. Newton-Raphson method ka output verify karo. Real-world scenarios practice karo — exams aur placements ke liye.

Startup / Angel Investors Investment amount, projected exit multiple, holding period enter karo. IRR calculate karo — hurdle rate (25%+ for startups) se compare karo. Quantify what was previously gut-feel decision.

Frequently Asked Questions

What is IRR (Internal Rate of Return)?expand_more

IRR — Internal Rate of Return — woh discount rate hai jo kisi investment ya project ke sab cash flows ka Net Present Value (NPV) = zero kar deta hai. Simpler words mein: woh annual return rate hai jis pe aapka investment break-even karta hai considering time value of money. Agar IRR > hurdle rate (cost of capital) → investment worthwhile. IRR < hurdle rate → reject karo. IRR multiple investments compare karne ka standard financial metric hai — especially uneven cash flows ke liye.

What is the difference between IRR and CAGR?expand_more

CAGR: single initial investment, single final value — simple annualized return. Only two data points. IRR: multiple cash flows at different times — initial outflow + periodic inflows + terminal value. Handles complexity. Example: ₹10L invest → ₹2L return Year 1, ₹3L Year 2, ₹4L Year 3, ₹5L Year 4. CAGR can't handle this. IRR handles it correctly. For SIP (monthly investments): use XIRR (dates-aware IRR). For periodic project cash flows: use regular IRR. faydemand.in calculator both IRR and XIRR calculate karta hai.

How is IRR calculated?expand_more

IRR formula: NPV = Σ [CF_t / (1+IRR)^t] = 0. Solve for IRR iteratively — no closed-form solution exists. Newton-Raphson method use hoti hai. Example: ₹1,00,000 invest, receive ₹40,000 Year 1, ₹50,000 Year 2, ₹30,000 Year 3. IRR = rate such that: -1,00,000 + 40,000/(1+r) + 50,000/(1+r)^2 + 30,000/(1+r)^3 = 0. Solving: r ≈ 14.3% IRR. faydemand.in calculator numerical iteration se exact IRR instantly calculate karta hai.

What is the difference between IRR and XIRR?expand_more

IRR: assumes equal time periods between cash flows — annual, quarterly etc. Regular intervals. XIRR: handles irregular date-based cash flows — each cash flow has its own specific date. More accurate for real-world investments. Example: SIP (different dates each month) — use XIRR. Annual project cash flows — IRR sufficient. Mutual fund redemptions at arbitrary dates — XIRR. Insurance premiums with irregular intervals — XIRR. faydemand.in calculator period-based IRR mode supports standard investment analysis.

What is a good IRR for an investment in India?expand_more

Good IRR benchmarks India: Risk-free rate (FD, PPF): 6–7.5% — minimum acceptable IRR for any investment. Real estate: 12–18% IRR (quality projects). Equity investments: 12–15% IRR long term (Nifty historical). Private equity/VC: 20–30%+ IRR targets. Startup investments: 25–35%+ (to justify risk). Business projects: minimum WACC + risk premium (typically 15–25%). General rule: IRR should exceed hurdle rate (your cost of capital or opportunity cost). If FD gives 7% — any investment must give >7% IRR to be worthwhile.

What is Modified IRR (MIRR)?expand_more

MIRR — Modified Internal Rate of Return — IRR ki limitation solve karta hai. Regular IRR assumes all intermediate cash flows reinvested at IRR rate (unrealistic). MIRR: negative cash flows discounted at financing rate, positive cash flows compounded at reinvestment rate (more realistic). MIRR formula: [FV of positive cash flows / PV of negative cash flows]^(1/n) – 1. MIRR typically lower than IRR — more conservative and realistic. High-IRR projects jo actually much lower realistic returns denge — MIRR expose karta hai.

Can IRR be negative or more than 100%?expand_more

Haan — IRR negative bhi ho sakta hai (project destroys value) aur 100% se zyada bhi. Negative IRR: total cash inflows < initial investment even without discounting. Example: ₹1L invest, get back only ₹70,000 total over all years — negative IRR. IRR > 100%: possible in high-return short-duration investments. Ek saal mein ₹1L → ₹2.5L = 150% IRR. Multiple IRR problem: iff cash flows change sign more than once — multiple mathematical IRR solutions possible — use MIRR instead.

How is IRR used in real estate investment?expand_more

Real estate IRR calculation: Initial investment (down payment + all costs) = negative cash flow Year 0. Annual rental income (net of expenses, taxes) = positive cash flows Years 1–n. Property sale proceeds (terminal value) = large positive cash flow Year n. IRR of this complete cash flow series = real estate investment's true return. Compares apples-to-apples with other investments. Example: ₹50L property, ₹1.5L/year rent, sold for ₹1.2 crore after 15 years → IRR approximately 14.8%. faydemand.in calculator handles this multi-year real estate IRR.

What are the limitations of IRR?expand_more

IRR limitations: (1) Multiple IRR problem — if cash flows change sign >1 time, multiple solutions possible; (2) Reinvestment assumption — IRR assumes intermediate cash flows reinvested at same IRR rate (unrealistic for high IRR projects); (3) Scale ignorance — IRR doesn't consider project size (20% IRR on ₹1L vs 15% IRR on ₹100L — absolute returns very different); (4) Mutually exclusive project comparison can mislead. Solutions: use MIRR for reinvestment issue, use NPV for scale comparison, use IRR only as screening tool with NPV as decision tool.

What is hurdle rate and how does it relate to IRR?expand_more

Hurdle rate = minimum acceptable rate of return for an investment — also called minimum required rate of return. Decision rule: If IRR > Hurdle Rate → Accept investment. If IRR < Hurdle Rate → Reject investment. If IRR = Hurdle Rate → Indifferent (break even). For corporate projects: hurdle rate = WACC + risk premium. For personal investors: hurdle rate = opportunity cost (e.g., best FD rate or index fund expected return). faydemand.in IRR calculator mein hurdle rate enter karo — calculator automatically Accept/Reject decision dikhata hai.

Related Calculators

IRR ke saath in calculators ko use karo — complete investment analysis ke liye.