Logo
Search
Tools
Tools

Price Cut Map

Where sellers are cutting prices, 50 metros

Resources
Resources

Guides

Proptech, CRE, and marketing guides

FAQs

Quick answers on DSCR, proptech, and marketing

Glossary

NNN, cap rate, NOI, DSCR, and more

Build With Us
Log In
Subscribe free
Logo

BRIEFCASE GUIDES / UNDERWRITING METRICS

IRR in Real Estate: What Internal Rate of Return Means and How to Read It

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.

UPDATED

November 16, 2026


READ TIME

3 min read


TOPIC

Underwriting metrics


All ​guides ​→

FAQs ​→

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

The definition in plain terms

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

A five-year example

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

Levered vs unlevered IRR

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

The traps

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

How IRR fits with other metrics

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.

Equity ​multiple ​→

Cap ​rate ​vs ​cash ​on ​cash ​→

Preferred ​return ​and ​waterfalls ​→


06

What is a good IRR?

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

IRR FAQ

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

Building an IRR model you can trust

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

Summary

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

Where the facts come from

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.

Microsoft ​Support: ​XIRR ​function ​→

Microsoft ​Support: ​MIRR ​function ​→

KEEP READING

Related reading

Browse ​all ​guides ​→

FAQs ​→

Glossary ​→

GUIDE

Equity ​Multiple ​→

GUIDE

Preferred ​Return ​and ​Waterfalls ​→

GUIDE

Real ​Estate ​Syndication ​→

GUIDE

Cash ​on ​Cash ​Return ​→

GUIDE

Cap ​Rate ​vs ​Cash ​on ​Cash ​→

GUIDE

Net ​Operating ​Income ​(NOI) ​→

BRIEFCASE STUDIO

Turn research into a marketing system.

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.

Talk to Briefcase StudioSubscribe to Square Footage

© 2026 briefcase.
beehiivPowered by beehiiv