Real Estate IRR: How to Calculate IRR/XIRR for Rental Properties and Flips

Quick Answer

Real estate IRR is the annualized return implied by all property cash flows: money you put in (down payment, closing costs, renovations/CapEx), money you receive during ownership (net operating cash flow after expenses and, for equity IRR, after debt service), and money you receive at exit (net sale proceeds after selling costs and loan payoff). Use XIRR when dates are irregular (typical in real estate).

Why IRR Matters in Real Estate (And What It Actually Measures)

Real estate returns come from multiple sources:

• Cash flow: rent minus expenses (and minus debt service if levered).
• Equity build: loan principal paydown (if amortizing).
• Appreciation: value changes over time (often modeled via NOI growth and exit cap rate).
• Timing: receiving money earlier boosts annualized returns.

IRR combines all of that into a single annualized rate. It answers: “What constant annual rate makes the present value of money in equal money out?” The key is that IRR is heavily influenced by timing—early cash flows can boost IRR even if total profit is modest.

Why investors like IRR

• It’s a single number that includes the whole timeline (not just year 1).
• It lets you compare strategies with different timing (flip vs long-term hold).
• It incorporates the exit, which is where many real estate profits occur.

Why IRR can mislead in real estate

• It can be inflated by optimistic exit assumptions.
• It can be inflated by refinance cash-outs (early return of capital).
• It can “favor” shorter projects even when they create fewer dollars.
• It hides key assumptions (vacancy, repairs, rent growth, exit cap rate).

IRR vs Cap Rate vs Cash-on-Cash vs Equity Multiple

Cap rate

Cap rate is typically NOI ÷ price. It’s a snapshot yield at a point in time and usually ignores financing and growth. Cap rate is useful for comparing stabilized properties, but it’s not a full return metric.

Cash-on-cash return

Cash-on-cash is typically annual pre-tax cash flow ÷ cash invested. It focuses on current income, often year 1. It can ignore appreciation and equity build unless you explicitly model those separately.

Equity multiple

Equity multiple is total cash returned ÷ total cash invested. It tells you the size of the win in dollars, but ignores timing. A 2.0x multiple over 2 years is very different from 2.0x over 12 years—IRR captures that.

IRR

IRR uses the entire cash flow stream and includes timing. It’s best used alongside at least one “dollars-based” metric like equity multiple or NPV.

Levered vs Unlevered IRR (This Is Where People Get Apples-to-Oranges)

Unlevered IRR (property-level)

Unlevered IRR ignores financing and looks at the property itself. Cash flows are typically:

• negative: purchase price + closing costs + CapEx (property-level)
• positive: NOI (rent minus operating expenses)
• positive at exit: sale proceeds net of selling costs (but no loan payoff because there is no loan)

Unlevered IRR is often used to compare property quality and operations without the noise of financing.

Levered IRR (equity-level)

Levered IRR includes debt and measures return to equity. Cash flows are:

• negative: down payment + closing costs + equity-funded CapEx
• positive/negative: cash flow after debt service (and reserves if you model them)
• positive at exit: net sale proceeds to equity (sale price minus selling costs minus remaining loan payoff)

Levered IRR can be higher or lower than unlevered IRR depending on interest rates, amortization, and risk.

What Cash Flows to Include in Real Estate IRR (Full Checklist)

The quality of your IRR is 90% cash flow integrity. Here’s what to include to avoid inflated results.

Upfront acquisition costs (usually negative)

• Down payment (equity)
• Closing costs (title, escrow, lender fees, etc.)
• Initial inspections, appraisal, due diligence costs (if material)
• Upfront repairs/renovation to make it rentable (CapEx)
• Upfront leasing costs (if applicable)

Operating cash flows during the hold

Decide whether you model at the NOI level or equity level:

• Unlevered model: use NOI (rent - operating expenses).
• Levered model: use cash flow after debt service (NOI - mortgage payments), plus any reserve contributions if you treat them as cash out.

Common operating items to model

• Gross rent
• Vacancy and credit loss (a % or fixed assumption)
• Property taxes
• Insurance
• Repairs and maintenance
• Property management
• HOA (if applicable)
• Utilities paid by owner
• Turnover/leasing costs (if high-turnover property)
• Capital expenditure reserves (roof, HVAC, etc., if you model them as cash out)

Capital expenditures during the hold (negative)

Big-ticket costs are not “optional.” Ignoring them is how bad IRRs happen. Examples:

• roof replacement
• HVAC replacement
• major plumbing/electrical
• unit turns and remodeling
• exterior paint, parking lot

Refinance proceeds (if applicable)

• Cash-out proceeds (positive) on the refinance date
• Refinance fees (negative) on the refinance date
• Update debt service going forward

Exit cash flows (sale) — net proceeds only

At sale, you should include:

• Sale price (gross)
• minus selling costs (agent commissions, transfer taxes, closing fees)
• minus remaining loan payoff (for levered IRR)
• minus any modeled taxes (if you include them)
• equals net sale proceeds to equity (positive)

IRR vs XIRR for Real Estate: Use Dates (Usually)

Real estate cash flows are rarely perfectly periodic: the purchase might happen mid-month, renovations might be paid on irregular days, rent might start later, and the sale will happen on a specific closing date.

That’s why XIRR is often the correct tool for real estate: it uses actual dates. See: XIRR for irregular cash flows.

When IRR is acceptable

If you model everything monthly and assume one cash flow per month at the same spacing, IRR can be used as an approximation. But if you have major irregular events (renovations, refi, sale mid-month), XIRR is more accurate.

Real Estate IRR/XIRR Template (Structure You Can Copy)

The simplest reliable structure is a cash flow table with three columns:

• Date
• Cash flow (negative out, positive in)
• Description (purchase, reno, rent, mortgage, refi, sale)

Minimum required lines

• Purchase date: down payment + closing costs (negative)
• Operating cash flows (monthly/quarterly)
• Sale date: net sale proceeds (positive)

Typical additional lines

• Renovation costs (negative) on their payment dates
• CapEx events (negative)
• Refinance proceeds/fees (positive/negative)

Worked Example: Rental Property IRR (Levered)

Let’s outline a realistic levered rental property scenario (numbers simplified for clarity). Assume:

• Purchase: $400,000
• Down payment (20%): $80,000
• Closing costs: $10,000
• Initial renovation: $15,000 (paid across two months)
• Net monthly cash flow after expenses and debt service: $350 starting in month 3
• Hold period: 5 years
• Sale price: $470,000
• Selling costs: 7% of sale price (commission + closing)
• Remaining loan payoff at sale: $290,000 (illustrative)

Cash flow lines (conceptual)

• Day 0: -$90,000 (down payment + closing)
• Month 1: -$7,500 (reno)
• Month 2: -$7,500 (reno)
• Months 3–60: +$350 per month (net cash flow)
• Sale date: +[net sale proceeds]

Compute net sale proceeds

Sale price: $470,000
Minus selling costs (7%): -$32,900
Net before debt: $437,100
Minus loan payoff: -$290,000
Net sale proceeds to equity: $147,100

That final $147,100 is the cash flow you include at sale in an equity IRR model (plus the last month’s operating cash flow if it’s separate). If you accidentally used $470,000 as the final cash flow, your IRR would explode upward and be meaningless.

Interpretation

Once you compute XIRR/IRR, sanity-check:

• Does the result feel plausible relative to total profit?
• Is the exit line net of costs and loan payoff?
• Does a small change in sale price change IRR a lot? (It often does.)

Fix-and-Flip IRR Example (Why Short Holds Can Show Huge IRRs)

Flips often show very high IRRs because the timeline is short: even a modest dollar profit can annualize to a high percentage. That doesn’t mean flips are “better” than long-term holds—just different.

Flip cash flow structure

• Purchase + closing + rehab: big negatives upfront
• No operating cash flow (usually)
• Sale proceeds: one big positive at exit

Why IRR can be misleading here

• IRR doesn’t tell you if the deal is scalable (can you do 10 flips at once?).
• IRR doesn’t capture operational bandwidth, permit delays, contractor risk.
• IRR is extremely sensitive to timeline: a 2-month delay can crush annualized return.

Refinance and Cash-Out: How to Model It Without Lying to Yourself

Refinancing can change IRR dramatically because it can return capital earlier. The math rewards early cash return. But you must model it correctly.

Cash-out refinance modeling

• On the refinance date, include the cash-out proceeds as a positive cash flow.
• Include refinance costs/fees as negative cash flows.
• Update debt service going forward based on the new loan.
• At sale, pay off the new remaining loan balance.

Why this inflates IRR (not necessarily “bad,” but needs context)

If you recover most of your initial equity through a refinance, the remaining equity in the deal may be small. Any later cash flows on a small remaining equity base can generate a high IRR. That doesn’t mean risk vanished—it often means leverage increased.

Exit Assumptions: Why Real Estate IRR Is So Sensitive

In many real estate deals, a large portion of total value comes from the exit sale. That means IRR can be dominated by terminal assumptions:

• sale price / appreciation
• exit cap rate
• NOI growth assumptions
• selling costs
• loan payoff at exit

Exit cap rate sensitivity

Small changes in exit cap rate can materially change valuation. A “half-cap” (e.g., from 5.0% to 5.5%) can move your terminal value enough to swing IRR meaningfully.

What to do about it

Don’t bet the deal on one exit number. Run a conservative exit scenario: higher exit cap rate, slower rent growth, and full selling costs. If IRR collapses, the deal is fragile.

Stress Tests and Scenario Analysis (How to Trust Your IRR)

IRR is a model output. Models are wrong in predictable ways. The best defense is fast stress testing.

Stress test #1: Conservative exit

• Lower sale price (or higher exit cap rate)
• Higher selling costs
• Slower NOI growth

Stress test #2: Expense shock

• Higher maintenance
• Higher property taxes/insurance
• Vacancy increase

Stress test #3: Timeline delay

• Lease-up takes longer
• Renovation takes longer
• Sale takes longer

Stress test #4: Interest rate/refi risk

• Higher refinance rate
• No refinance available
• Debt service increases on adjustable terms

Common Mistakes That Inflate Real Estate IRR (Audit This List)

1) Using gross sale price instead of net sale proceeds

The classic mistake. Always subtract selling costs and loan payoff.

2) Ignoring CapEx and big-ticket replacements

If you don’t model roof/HVAC/turnover reserves (or real CapEx events), your IRR is too high.

3) Treating principal payments as a “cost” in unlevered models

In equity models, principal paydown is not a cost—it becomes equity. But you must reflect it correctly in cash flows and exit payoff.

4) Overly aggressive rent growth

Small rent growth changes compound and boost terminal value. Stress-test modest growth.

5) Exit cap rate optimism

Assuming a lower exit cap than going-in is a bullish bet. Test a higher exit cap.

6) Not modeling vacancy and credit loss realistically

0% vacancy is not realistic. Even “good” properties have turnover and collections friction.

7) Incorrect refinance treatment

Cash-out proceeds are not “profit.” They are borrowed money. Model increased debt and payoff at exit.

8) Ignoring taxes/fees inconsistently

If you model taxes in one deal, model them in others, or at least be consistent in comparisons.

How to Interpret Real Estate IRR (What’s “Good”?)

There is no universal “good IRR” because risk varies widely:

• A stabilized, low-risk property should have a lower required return than a heavy rehab in a volatile market.
• Higher leverage can raise IRR but also raise downside risk.
• Short-horizon projects can show high IRR even with moderate profit.

Use a hurdle rate mindset

Instead of chasing a number, compare IRR to your required return for the risk. That required return is effectively your “discount rate” or hurdle rate. See: Discount rate vs IRR.

Pair IRR with other metrics

• Equity multiple: how many dollars returned per dollar invested
• NPV: value created at your hurdle rate
• Downside scenarios: what happens if the exit is weaker or timeline slips

Frequently Asked Questions

Bottom Line

Real estate IRR is powerful because it compresses a multi-year property story into one annualized return. But it’s also easy to inflate. The fix is simple: build an auditable cash flow table with correct signs and dates, include all real costs (closing, selling, CapEx), and use net sale proceeds after loan payoff. Use XIRR when dates are irregular, and never trust a single base-case output—run conservative exit and timeline scenarios. If the IRR still holds up under stress tests, you can trust it much more.

Methodology and assumptions

Educational only. IRR/XIRR are sensitive to cash flow assumptions—especially exit value, selling costs, and timing. Use realistic net sale proceeds (after fees and loan payoff), include CapEx, and run scenario analysis (conservative/base/optimistic) to avoid overfitting.