How to Calculate IRR on a Real Estate Investment (With Real Numbers)

What IRR Actually Measures

Internal Rate of Return is the discount rate that sets the net present value of all cash flows to zero. That sentence is technically precise but practically opaque, so here is the translation: IRR tells you the annualized rate at which your invested capital is compounding, accounting for the exact timing of every dollar received.

Cap rate measures income relative to asset value at a single point in time. Cash-on-cash measures annual pre-tax cash flow relative to equity deployed. Both are snapshots. IRR is the full film.

A $500,000 acquisition that returns $50,000 per year and sells for $700,000 after seven years does not have a 10% IRR simply because $50,000 divided by $500,000 equals 10%. The actual IRR on that deal is approximately 12.1%, because the $700,000 exit arrives seven years from now and its present value is lower than $700,000 today. The discount on time is real, and ignoring it produces decisions that destroy capital.

The IRR Formula and Why You Do Not Solve It by Hand

The formal expression is:

0 = CF₀ + CF₁/(1+r)¹ + CF₂/(1+r)² + ... + CFₙ/(1+r)ⁿ

Where CF₀ is the initial outflow (negative), CF₁ through CFₙ are subsequent cash flows, and r is the IRR you are solving for.

There is no closed-form algebraic solution. You solve for r through iteration, which is why spreadsheets and purpose-built calculators exist. Excel uses the =IRR() function. CalcMoney runs the same iterative logic with real estate-specific inputs already structured.

What matters is understanding the inputs, not the calculus behind them.

The Five Inputs Every Real Estate IRR Calculation Requires

1. Initial equity outflow. This is your actual cash out of pocket on day one. On a $600,000 property with 25% down and $18,000 in closing costs, your CF₀ is -$168,000.

2. Annual net cash flows. Gross rent minus vacancy, operating expenses, property management, and debt service. These are the actual after-financing cash flows, not NOI. Use realistic figures. An 8% vacancy rate on a $36,000 annual gross rent costs $2,880 per year. That matters over a 7-year hold.

3. Timing of each cash flow. A renovation that delays cash flow by 14 months meaningfully reduces IRR compared to a stabilized asset that distributes from day one.

4. Hold period. IRR is acutely sensitive to hold period. Extending a hold from 5 years to 8 years on the same property can drop IRR by 2.3 to 3.1 percentage points if appreciation slows in years 6 through 8.

5. Net sale proceeds. Gross sale price minus selling costs (typically 5% to 6%), mortgage payoff, and any capital gains tax reserve you account for at the asset level.

Worked Example 1: A Stabilized Single-Family Rental

Purchase price: $425,000 Down payment (25%): $106,250 Closing costs: $9,500 Total CF₀: -$115,750

Mortgage: $318,750 at 7.1% over 30 years. Monthly payment: $2,139. Annual debt service: $25,668.

Annual gross rent: $31,200 Vacancy (7%): -$2,184 Operating expenses (insurance, taxes, maintenance, management at 30%): -$9,360 Net Operating Income: $19,656 Less debt service: -$25,668 Annual cash flow: -$6,012

This property runs slightly negative in year one. Not unusual for a 7.1% rate environment at this price point.

Annual appreciation assumption: 3.8% (consistent with the 20-year average for mid-tier residential markets).

Year 5 value: $425,000 x (1.038)⁵ = $510,430 Selling costs at 5.5%: -$28,074 Mortgage balance at year 5: approximately $294,300 Net sale proceeds: $510,430 - $28,074 - $294,300 = $188,056

Cash flows:

• Year 0: -$115,750
• Years 1 through 5: -$6,012 per year
• Year 5 terminal: +$188,056

IRR: approximately 8.7%

Remove the appreciation and assume flat value. The IRR collapses to approximately 1.2%. This is why appreciation assumptions require discipline. A 1% difference in annual appreciation on a $425,000 property produces a 2.4 to 3.1 percentage point swing in IRR over five years.

Worked Example 2: A Value-Add Duplex

Purchase price: $310,000 Renovation budget: $55,000 (months 1 through 8, no rental income) Down payment (20%): $62,000 Closing costs: $8,200 Cash into renovation (partially financed): $35,000 Total CF₀: -$105,200

Post-renovation stabilized rents: $3,800/month ($45,600/year) Vacancy (6%): -$2,736 Operating expenses (32%): -$14,592 NOI: $28,272 Annual debt service on $248,000 at 7.4%: $20,592 Annual net cash flow after stabilization: $7,680

Hold period: 7 years Year 7 value at 4.1% annual appreciation on post-renovation value of $380,000: $380,000 x (1.041)⁷ = $502,800 Selling costs at 5.5%: -$27,654 Mortgage balance at year 7: approximately $220,400 Net sale proceeds: $254,746

Cash flows:

• Year 0: -$105,200
• Year 1 (renovation, no income): -$35,000 (remaining renovation draw plus carrying costs)
• Years 2 through 7: +$7,680
• Year 7 terminal: +$254,746

IRR: approximately 14.3%

The value-add premium is real, but it comes from execution. A renovation that runs 20% over budget ($11,000 additional) and three months long drops the IRR to approximately 11.8%. Budget discipline is not a secondary concern. It is directly embedded in the return metric.

Where IRR Calculations Break Down

Unrealistic terminal cap rates. Many investors model an exit cap rate equal to or below the entry cap rate. In a tightening market, that assumption flatters the IRR by 150 to 300 basis points on a typical $400,000 to $600,000 deal. Model the exit cap rate 25 to 50 basis points above your entry cap rate. It introduces conservatism where the calculation is most vulnerable.

Ignoring capital expenditure reserves. A roof replacement at year 4 costing $18,500, or an HVAC failure at year 3 costing $9,200, hits the cash flow table directly. Omitting these from the model produces an IRR that exists only in the spreadsheet.

Conflating levered and unlevered IRR. An unlevered IRR uses cash flows before debt service and uses the full purchase price as CF₀. A levered IRR uses after-debt-service cash flows and uses only equity as CF₀. Both are useful. They measure different things. Comparing a deal's levered IRR against another deal's unlevered IRR produces a meaningless number.

Using round numbers for hold period. If you plan to hold 7 years, model 7 years. Modeling 10 years because it is cleaner changes the IRR materially when appreciation is front-loaded. Model the actual intended hold.

What IRR Threshold Should You Target?

There is no universal answer. There is a framework.

For stabilized residential assets in primary markets: an IRR below 8% on a levered basis offers insufficient compensation for illiquidity and concentration risk. A 10-year Treasury currently yields approximately 4.4%. Illiquid real estate should command at least 350 to 500 basis points above that.

For value-add plays with execution risk: a minimum levered IRR of 13% to 15% reflects the additional operational burden. Below 12%, the risk-adjusted case weakens significantly.

For opportunistic or development deals: institutional buyers typically require 18% to 22% IRR to justify ground-up risk. Individual investors should demand at least 16%.

These are not targets to hit through optimistic modeling. They are thresholds that should hold under stress-tested assumptions.

Run Your Numbers Before You Make an Offer

IRR belongs in the underwriting process, not the post-closing review. Investors who calculate it before making an offer filter out deals that look attractive on gross yield but fail on time-adjusted total return.

The CalcMoney real estate calculator takes your purchase price, financing terms, projected annual cash flows, hold period, and exit assumptions, then returns the levered IRR alongside cash-on-cash by year. It runs the iterative calculation in real time as you adjust inputs.

Change the hold period from 7 to 5 years. Watch the IRR move. Increase the vacancy rate from 6% to 9%. See what it costs in annualized return. That sensitivity analysis, done before you sign a letter of intent, is the difference between disciplined capital allocation and hope-based investing.

You Might Also Like

• How to Calculate Real Estate Agent Commission (And Negotiate It Down)
• How to Calculate Real Estate ROI Over 10 Years (And Why Most Investors Get It Wrong)
• 1031 Exchange Timeline and Replacement Rules: The Exact Calculations You Need

Open the CalcMoney IRR Calculator and model your next deal →