📊 Definition
Internal Rate of Return (IRR) is the annualized rate of return that makes the net present value of all cash flows equal to zero. It's the time-weighted return considering investment timing, cash flow, and exit proceeds.
The Formula
Expressed as annual percentage
Example Calculation
An investment with $12M initial investment, annual distributions, and sale proceeds:
Where Does the Data Come From?
IRR requires complete cash flow history:
- Initial Investment: Down payment plus closing costs
- Operating Distributions: Annual cash flows to investors
- Capital Calls: Additional investments if required
- Refinance Proceeds: Cash-out refinancing distributions
- Sale Proceeds: Net proceeds at disposition
IRR is calculated using Excel (IRR function), financial calculators, or investment management software.
Who Uses This Metric?
Investors & Limited Partners
Evaluate investment performance and compare to alternatives. Target IRRs (e.g., 15-20% for value-add) inform investment decisions and portfolio allocation.
Syndicators & Fund Managers
Market projected IRRs to attract capital and report actual IRRs to demonstrate performance. IRR is the industry standard return metric for communicating investment results.
Underwriters
Model pro forma IRRs to evaluate deal quality. Projects must meet minimum IRR hurdles (e.g., 15%) to justify investment given risk and capital costs.
Why This Metric Matters
1. Time-Weighted Return
IRR accounts for timing—getting cash back faster generates higher IRR. A 2.0× return in 3 years (26% IRR) beats 2.0× in 7 years (11% IRR) despite same equity multiple.
2. Comparable Across Investments
IRR enables apples-to-apples comparison across different investment sizes, hold periods, and structures. A 16% IRR is directly comparable whether on $10M or $100M investment.
3. Risk-Adjusted Decision Tool
Compare IRR to required returns based on risk. Core deals target 10-13% IRR; value-add targets 15-20% IRR; opportunistic targets 20%+ IRR. Higher risk requires higher IRR to justify investment.
⚠️ Important Note
IRR can be misleading with irregular cash flows or short hold periods. Always evaluate IRR alongside equity multiple. A 30% IRR over 2 years (1.7× multiple) may be less attractive than 18% IRR over 6 years (2.5× multiple).
For multifamily owners running multiple business plans at once, manually updating IRR models in spreadsheets is slow and error-prone. BubbleGum BI pulls cash flow and NOI data directly from your systems so you can see IRR, equity multiple, and NOI trends for each asset in a single portfolio analytics view.
Frequently Asked Questions
What's a good IRR for multifamily?
Core stabilized: 10-13%. Core-plus: 12-15%. Value-add: 15-20%. Opportunistic/development: 20-25%+. Higher IRR targets reflect higher risk. Compare to required returns and alternative investments considering risk profiles.
How is IRR different from cash-on-cash return?
Cash-on-cash is annual cash yield (single year metric). IRR is time-weighted total return over entire hold period including appreciation. Cash-on-cash ignores growth; IRR captures complete investment performance.
Can IRR be negative?
Yes—if total cash returned is less than invested, IRR is negative indicating loss. Also possible with very uneven cash flows. Negative IRR signals failed investment requiring capital loss recognition.
What's levered vs. unlevered IRR?
Levered IRR includes debt (measures equity return after financing). Unlevered IRR ignores debt (measures property return). Levered IRR is higher when leverage is positive (cap rate > interest rate). Report both for complete picture.
How does hold period affect IRR?
Shorter holds can generate higher IRRs if exit multiples are strong. However, very short holds (< 2 years) create artificially high IRRs that may not be sustainable. Evaluate IRR in context of hold period and equity multiple for realistic performance assessment.
Track IRR and Investment Performance
BubbleGum BI calculates IRR from cash flows via our financial dashboard and models how operational improvements translate to IRR enhancement—helping optimize investment returns.
Schedule Your Demo Today