IRR Calculator: Internal Rate of Return, MIRR & Hurdle Rate Analysis
Calculate Internal Rate of Return (IRR) & Modified IRR (MIRR) online. Analyze project NPV, Hurdle Rate spreads, Profitability Index & cash flow schedules.
Internal Rate of Return (IRR) is 24%, generating a +14% spread over your 10% Hurdle Rate with an NPV of ₹434,872.
IRR of 24% exceeds Hurdle Rate (10%) by +14%, generating ₹434,872 in net present value. Modified IRR (MIRR) is 18.24% and Profitability Index is 1.43x.
Project Cash Flow Stream
NPV Profile & Discount Rate Sensitivity Curve
How project NPV changes across varying discount rates (IRR is where NPV = 0)
Annual Cash Flow & Present Value Schedule
Hurdle Rate: 10%| Period | Cash Flow | Discount Factor | Discounted PV | Cumulative Undiscounted | Cumulative Discounted |
|---|---|---|---|---|---|
| Year 0 (Outlay) | ₹-1,000,000 | 1.0000 | ₹-1,000,000 | ₹-1,000,000 | ₹-1,000,000 |
| Year 1 | ₹250,000 | 0.9091 | ₹227,273 | ₹-750,000 | ₹-772,727 |
| Year 2 | ₹350,000 | 0.8264 | ₹289,256 | ₹-400,000 | ₹-483,471 |
| Year 3 | ₹400,000 | 0.7513 | ₹300,526 | ₹0 | ₹-182,945 |
| Year 4 | ₹450,000 | 0.6830 | ₹307,356 | ₹450,000 | ₹124,411 |
| Year 5 | ₹500,000 | 0.6209 | ₹310,461 | ₹950,000 | ₹434,872 |
Save Interest & Finish Early
How Repayment & Lifecycle Works
Understanding the key phases of your loan or investment timeline
Year 0 Capital Outlay Mapping
Quantify initial CapEx, acquisition costs, inventory investments, and project setup expenses occurring at Time 0.
Forecast Multi-Year Net Cash Inflows
Project post-tax operating cash flows (EBITDA - Tax + Depreciation adjustments - Working Capital shifts) across the operating lifecycle.
Solve Polynomial Root for Internal Rate of Return (IRR)
Determine the exact discount rate where Net Present Value (NPV) equals zero via iterative Newton-Raphson polynomial algorithms.
Evaluate Hurdle Rate Spread & MIRR Reinvestment Realism
Compare IRR against WACC hurdle rate, calculate Modified IRR (MIRR) with realistic reinvestment assumptions, and formalize capital allocation decisions.
Who Should Use the IRR Calculator: Internal Rate of Return, MIRR & Hurdle Rate Analysis?
Corporate CFOs & Treasury Executives
Finance leaders screening capital expenditure budgets, plant automation projects, and commercial ROI hurdles.
Private Equity & Venture Capital Investors
Fund managers underwriting buyout returns, venture portfolio syndication IRRs, and waterfall distributions.
Commercial Real Estate Developers
Property syndicators evaluating rental cash yields combined with year 5-10 terminal exit valuations.
Renewable Infrastructure & Energy Sponsors
Infrastructure project developers evaluating multi-decade Power Purchase Agreement (PPA) cash flows against hurdle rates.
Key Benefits
- Make data-backed capital allocation and project investment decisions with institutional rigor
- Identify whether proposed CapEx creates or destroys shareholder value relative to cost of capital
- Avoid flawed capital budgeting conclusions by comparing Standard IRR with Modified IRR (MIRR)
- Detect non-conventional cash flow streams with multiple sign changes and multiple mathematical roots
Platform Features
- High-precision Newton-Raphson polynomial root solver with Secant / Bisection method fallback
- Modified Internal Rate of Return (MIRR) calculator addressing the flawed IRR reinvestment rate assumption
- Net Present Value (NPV) & Profitability Index (PI) at corporate WACC hurdle rates
- NPV Profile Discount Rate Sensitivity Curve mapping NPV across discount rates from 0% to 30%
- Annual discounted cash flow schedule with cumulative undiscounted and discounted cash balances
Internal Rate of Return (IRR) & Modified IRR (MIRR) Formulas
The net cash outflow required at project inception (Time t = 0).
Net cash inflows generated in each operating year (t = 1, 2, ..., n).
The annualized compound rate of return that makes project NPV equal to zero.
Explicit rates used in MIRR to replace the flawed standard IRR reinvestment rate assumption.
Practical Worked Scenarios
Case Study 1: ₹50 Lakhs Factory Automation Project (5-Year Horizon @ 12% WACC)
Case Study 2: ₹1 Crore Commercial Real Estate Acquisition with Terminal Sale
Practical Strategies to Save Money
Pair IRR with Net Present Value (NPV)
Never rely on IRR in isolation. When comparing mutually exclusive projects of different scale, always prioritize the project with the highest absolute NPV.
Use MIRR for Reinvestment Realism
Standard IRR unrealistically assumes interim cash flows are reinvested at the project IRR. MIRR provides a far more accurate corporate return based on your actual WACC.
Check for Non-Conventional Sign Reversals
Projects with alternating positive and negative cash flows (e.g., major mid-life overhauls or decommissioning costs) can have multiple mathematical IRRs. Rely on NPV in such cases.
Incorporate Margin of Safety Over Hurdle Rates
Always require an IRR premium of at least 300–500 bps above your corporate WACC to absorb supply chain inflation, delayed timelines, and execution slippage.
Common Mistakes to Avoid
Critical financial oversights that reduce long-term returns
Assuming interim project cash inflows can be continually reinvested at a high 30%+ IRR rather than the realistic company WACC.
Choosing a smaller high-IRR project over a larger low-IRR project that delivers significantly more total cash profit.
IRR Calculator: Internal Rate of Return, MIRR & Hurdle Rate Analysis FAQs
Clear answers to common questions about calculations and methodology