BRIEFCASE GUIDES / UNDERWRITING METRICS
Internal rate of return (IRR) is the annualized return that sets the net present value of all of a deal's cash flows to zero. In real estate, it combines the money you put in, the cash flow along the way, and the sale proceeds into one percentage that accounts for timing.
IRR is the headline number in most investment memos because it rewards getting money back sooner. That is its strength and its weakness. It is the best single measure of time-weighted return, and it is also the easiest metric to flatter with assumptions about when and at what price a property sells.
01
FORMULA
0 = CF0 + CF1/(1+IRR) + CF2/(1+IRR)^2 + ... + CFn/(1+IRR)^n
CF0 is the equity invested, entered as a negative number. Each later cash flow is discounted back to today. IRR is the rate that makes the total exactly zero. There is no closed-form solution, so spreadsheets solve it by trial and error. In Excel or Google Sheets, use IRR for evenly spaced annual cash flows and XIRR when cash flows land on specific dates.
02
Year 0 equity (hypothetical)
minus $1,000,000
Years 1 to 4 cash flow
$55,000, $58,000, $61,000, $64,000
Year 5 cash flow plus sale proceeds
$67,000 plus $1,300,000
Total returned
$1,605,000
Equity multiple
1.61x
IRR
About 10.9%
Now change only the timing. If the same $1,000,000 grew to $1,650,000 with no interim cash flow and sold in year three, the IRR would be about 18.2%. Sold in year seven, it falls to about 7.4%. Same profit, very different IRR.
03
Unlevered IRR uses property-level cash flows before any mortgage, so it measures the asset. Levered IRR uses cash flows after debt service and loan payoff, so it measures the equity. When the property earns more than the cost of debt, leverage raises IRR. When it earns less, leverage lowers it and adds risk. Ask which one a sponsor is quoting, and whether it is before or after fees and promote.
04
01
Exit cap rate: a small change in the assumed sale cap rate moves IRR more than almost any other input. Ask for a sensitivity table.
02
Hold period: shorter holds can show higher IRRs with less total profit. Read IRR next to equity multiple.
03
Reinvestment assumption: IRR implicitly assumes interim cash can be reinvested at the same rate. Modified IRR (MIRR) lets you set a more realistic reinvestment rate.
04
Capital calls and refinances: cash flows that change sign more than once can produce more than one mathematical IRR.
05
Subscription lines and delayed capital calls in funds can raise reported IRR without changing total profit.
05
01
Cap rate: a one-year snapshot of unlevered yield on price.
02
Cash on cash return: one year of levered cash flow on equity.
03
Equity multiple: total profit with no time value.
04
IRR: total return with time value, sensitive to every assumption.
06
There is no universal number. Target returns depend on risk: stabilized core assets aim lower, value-add and development aim higher to compensate for execution risk. Compare a deal's projected IRR with others of the same strategy, property type, leverage, and hold period, and with what you could earn on lower-risk alternatives such as Treasury bonds.
07
Why does XIRR give a different answer than IRR? IRR assumes evenly spaced periods. XIRR uses exact dates, so it is more accurate for real deals with irregular distributions.
Is a projected IRR a promise? No. It is the output of assumptions about rent, expenses, financing, and sale price. Ask for the model and test the assumptions that move it most.
Should I compare IRRs across different hold periods? Carefully. Pair IRR with equity multiple and consider what you would do with returned capital.
08
01
Start from actual rent rolls and trailing 12-month expenses, not the broker's pro forma.
02
Set rent growth and expense growth separately, and keep both near what the local market has delivered.
03
Model the loan correctly: interest-only periods, amortization, fees, and payoff at sale.
04
Include selling costs at exit, not just the sale price.
05
Run a downside case with higher vacancy and a higher exit cap rate, and look at whether the IRR still clears your minimum.
If a deal only hits its target IRR in the base case, the target is doing the work, not the property.
TAKEAWAYS
01
IRR is the discount rate that sets a deal's net present value to zero.
02
It rewards speed, so read it with equity multiple.
03
Use XIRR when cash flows land on real dates.
04
Levered and unlevered IRR answer different questions.
05
Exit cap rate and hold period assumptions drive most IRR outcomes.
SOURCES
Every figure on this page links to the primary or named source we checked on November 16, 2026. Worked examples use round hypothetical numbers and are labeled as such.
KEEP READING
BRIEFCASE STUDIO
Briefcase Studio builds newsletters, animated data visuals, short-form video, and launch campaigns for proptech and real estate brands. Square Footage is the free weekday briefing of the top US real estate stories.