IRR Examples
Example 1 - Real Estate Investment: Initial investment: -$100,000 (property purchase). Year 1-3 rental income: $12,000/year. Year 4 sale: $130,000. IRR: 16.8%. This exceeds typical stock market returns, indicating a potentially attractive real estate opportunity when accounting for both rental income and appreciation.
Example 2 - Business Project: Equipment purchase: -$50,000. Year 1 savings: $15,000. Year 2 savings: $20,000. Year 3 savings: $25,000. Salvage value: $5,000. IRR: 18.5%. Since this exceeds the company's 12% hurdle rate, the project is financially viable and should be approved.
Example 3 - Savings with Contributions: Initial: -$10,000. Monthly contributions tracked annually: -$6,000/year for 5 years. Final value: $60,000. IRR: 9.2%. This shows the actual return experienced, accounting for the timing of each contribution rather than just total dollars in vs. out.
Who Should Use This Calculator?
Business managers evaluating capital projects use IRR to decide which investments to pursue. Projects with IRR exceeding the company's cost of capital create value and should be approved.
Real estate investors analyzing rental properties need IRR to account for irregular cash flows from rental income, expenses, refinancing, and eventual property sale. It provides a true picture of investment performance.
Personal investors tracking portfolios with regular contributions or withdrawals benefit from IRR. Unlike simple return calculations, IRR accurately reflects the impact of deposit and withdrawal timing on overall performance.
Frequently Asked Questions
What is IRR and how is it calculated?
IRR (Internal Rate of Return) is the discount rate that makes the net present value (NPV) of all cash flows equal to zero. In other words, it's the break-even rate of return where the present value of inflows equals the present value of outflows. Calculation: IRR solves this equation for r: 0 = Σ [Cash Flow_t / (1 + r)^t] where t = time period. No algebraic solution exists—calculated through iterative numerical methods (trial and error until NPV = 0). Financial calculators and software use sophisticated algorithms to find IRR instantly.
What is the difference between IRR and ROI?
ROI (Return on Investment): Simple percentage return calculation. Formula: (Gain - Cost) / Cost. Ignores timing of cash flows. Best for single-period investments. IRR (Internal Rate of Return): Accounts for timing of all cash flows. Solves for the rate that makes NPV = 0. Best for multi-period investments with irregular cash flows. Example: $10,000 invested, $500 added month 6, $16,000 final value after 1 year. ROI: 52.4% (ignores timing). IRR: ~28% (accounts for mid-year contribution). Use ROI for simple comparisons. Use IRR when timing matters.
What is a good IRR percentage?
"Good" IRR is relative to your cost of capital and risk: Corporate Projects: Usually 12-20% depending on industry risk. Real Estate: 12-18% for value-add projects; 8-12% for stabilized properties. Private Equity: 20-30% target for leveraged buyouts. Venture Capital: 30%+ for early-stage (high failure risk). Personal Investments: Should exceed stock market returns (7-10%). Cost of Capital Benchmark: IRR > WACC (Weighted Average Cost of Capital) creates value. Risk Adjustment: Higher risk projects should show proportionally higher IRR to justify investment.
Can IRR be negative?
Yes, negative IRR means the investment loses money at any discount rate. Indicators: NPV is negative at all positive discount rates. Cash outflows exceed inflows in present value terms. Project destroys rather than creates value. Interpretation: IRR < 0: Reject project (unless strategic/non-financial reasons). IRR = 0: Break-even in nominal terms. IRR between 0 and hurdle rate: Reject (doesn't meet minimum return). Always compare IRR to your required rate of return or cost of capital.
What are the limitations of IRR?
IRR limitations include: Multiple IRRs: Projects with alternating positive/negative cash flows may have multiple solutions. Unrealistic Reinvestment: Assumes cash flows reinvest at IRR rate—often too optimistic. Scale Ignorance: Favors smaller high-percentage returns over larger lower-percentage returns. Mutually Exclusive Projects: May give conflicting rankings with NPV for projects of different sizes. Timing Sensitivity: Highly sensitive to cash flow timing assumptions. No Dollar Value: Doesn't show absolute wealth created (use NPV for that). Solutions: Use NPV alongside IRR. Consider MIRR (Modified IRR) for realistic reinvestment. Analyze payback period for liquidity assessment.
How do I interpret IRR results?
Decision Rules: IRR > Cost of Capital: Accept project (creates value). IRR = Cost of Capital: Indifferent (break-even). IRR < Cost of Capital: Reject project (destroys value). Comparisons: Higher IRR is generally better when comparing similar-sized projects. IRR vs. NPV: NPV shows dollar value created; IRR shows percentage return. Example: Project A: IRR 15%, NPV $100K. Project B: IRR 12%, NPV $500K. IRR favors A; NPV favors B. If mutually exclusive, choose B (more total value). If capital is abundant, do both.
What is MIRR (Modified IRR)?
MIRR addresses IRR's unrealistic reinvestment assumption. Standard IRR assumes cash flows reinvest at the IRR itself. MIRR assumes: Negative cash flows (investments) financed at financing rate. Positive cash flows reinvested at reinvestment rate (more conservative). Calculation: MIRR = (FV of positive cash flows / PV of negative cash flows)^(1/n) - 1. When to use: When IRR seems too optimistic. For projects with high early returns. When reinvestment opportunities yield less than IRR. Corporate finance often prefers MIRR for conservative planning.
How does IRR compare to NPV?
NPV (Net Present Value): Shows dollar value created in today's dollars. Considers absolute wealth generation. Preferred for mutually exclusive projects of different sizes. IRR (Internal Rate of Return): Shows percentage return. Easier to communicate and compare to benchmarks. Preferred when comparing projects of similar scale. Conflict Resolution: When NPV and IRR disagree on project ranking: If projects are mutually exclusive, trust NPV (maximizes wealth). If independent projects, both can be acceptable if IRR > hurdle and NPV > 0. Best Practice: Calculate both metrics for comprehensive analysis.
Can I calculate IRR for my investment portfolio?
Yes, portfolio IRR (also called money-weighted return or dollar-weighted return) is your personal return accounting for contribution and withdrawal timing. Tools: Excel: XIRR function for irregular dates; IRR function for regular periods. Financial software: Most portfolio trackers calculate IRR automatically. This calculator: Input portfolio cash flows (contributions negative, withdrawals positive, current value as final positive). Why use it: Your IRR differs from time-weighted returns if you added/removed money. Shows your actual experienced return, not just market performance.
What causes multiple IRRs?
Multiple IRRs occur with non-conventional cash flows that change signs more than once. Conventional: Outflow followed by inflows (one sign change = one IRR). Non-conventional: Pattern like: -, +, -, + (multiple sign changes). Example: -$1000, +$3000, -$2500, +$500. This pattern has two sign changes and potentially two IRRs. Solutions: Use NPV instead when multiple IRRs appear. Apply modified IRR (MIRR) methodology. Examine the pattern to ensure cash flows are realistic. In practice, true non-conventional patterns are rare in standard business projects.