IRR Calculator
Professional Real Estate IRR Model to Calculate Gross IRR and Equity Multiple.
Enter as positive number (will be treated as outflow)
Calculation Logic & Sensitivity
Live Deal Math
Sensitivity Matrix (±10%)
Disclaimer: This calculator is for educational and informational purposes only and does not constitute financial, legal, or tax advice. Real estate investments carry significant risk. Always consult with a licensed commercial real estate professional, CPA, or financial advisor before making investment decisions.
What is IRR?
Internal Rate of Return (IRR) is the discount rate that makes the Net Present Value (NPV) of all cash flows equal to zero. It represents the annualized effective compounded return rate.
IRR is considered the "holy grail" metric for real estate investors because it accounts for the time value of money and all cash flows including the final sale.
Institutional Sensitivity Benchmarks (Market Typical):
- Core: 8-10% (low risk, stabilized)
- Core Plus: 10-14%
- Value-Add: 14-20%
- Opportunistic: 20%+ (high risk, development)
Related Tools
Expert FAQ
What is the primary difference between IRR and Equity Multiple?
Equity Multiple measures absolute profit ($ return vs. $ invested), whereas IRR measures the speed of that profit. You can have a high equity multiple with a low IRR if the hold period is too long.
How is Net IRR calculated in Private Equity?
Net IRR is calculated after deducting all fees, including asset management fees, acquisition fees, and the sponsor's performance promote. It represents the actual return received by the Limited Partners (LPs).
What is a good IRR for a value-add real estate investment?
Value-add real estate typically targets a Net IRR between 14% and 18%. This higher return compensates for the operational risk and capital improvement phase required to stabilize the asset.
How does XIRR differ from standard IRR?
Standard IRR assumes cash flows occur at regular annual intervals. XIRR (Extended Internal Rate of Return) allows for cash flows at specific, irregular dates, providing a more precise calculation for real-world scenarios.
What is the internal rate of return formula for real estate?
The IRR is the discount rate (r) that makes the NPV of all cash flows (CF) equal to zero: 0 = CF0 + CF1/(1+r)^1 + ... + CFn/(1+r)^n. In real estate, this includes the initial equity, annual cash flow, and net sale proceeds.
What does IRR mean in simple terms?
In simple terms, IRR is the annualized percentage rate of return you earn on every dollar of capital that remains invested in the deal. It is the project's "break-even" discount rate.
IRR vs NPV: Which is more important?
While IRR tells you the percentage return, NPV (Net Present Value) tells you the dollar value created. Institutional investors use both; IRR for speed/efficiency and NPV to ensure the deal meets a minimum dollar-profit threshold.
How do exit cap rates impact the final IRR?
Exit cap rates have a massive impact because the sale proceeds often represent 60-80% of the total return. A 0.5% increase in the exit cap rate can drop the IRR by hundreds of basis points.
Why isn't a higher IRR always better?
A high IRR often implies higher risk or a shorter hold period. An 18% IRR over 3 years may result in less total wealth than a 14% IRR over 10 years due to reinvestment risk and transaction costs.
What are common IRR benchmarks by property type?
Multifamily typically targets 12-15% Net IRR, Industrial 11-14%, and Office 13-16%. Development projects usually require 20%+ to justify the construction and lease-up risks.
How does leverage (debt) impact the IRR?
Positive leverage boosts IRR because the cost of debt is lower than the property's cap rate, allowing the investor to use less equity to control the same asset. However, leverage also increases downside risk.
What is an IRR hurdle in a waterfall distribution?
An IRR hurdle is a performance benchmark (e.g., 8%) that must be achieved before the profit-sharing structure shifts in favor of the sponsor. It ensures LPs get paid first.