IRR Formula for Rental Property
Are you curious about the IRR formula because you want to model expected returns from a potential real estate investment? Maybe you just sold a rental property and are wondering how to calculate your all-in return over the life of the deal?
Well, unless you have a master’s degree in mathematics or finance, the actual IRR formula for real estate won’t get you very far. You can’t actually calculate an internal rate of return (IRR) by hand without running through a lot of painful iterative calculations. That’s why real estate investors have been using Excel to do their dirty work for decades. Google Sheets will now do the trick as well.
Quick Answer: What is IRR for Rental Property?
IRR (Internal Rate of Return) is the annualized return on your rental property investment, accounting for all cash flows (down payment, mortgage payments, rental income, expenses, and eventual sale proceeds) and their timing.
Think of it as: The interest rate your investment “earns” over its lifetime.
What’s a good IRR for real estate investments?
- 15-20%: Solid for most rental properties
- 20-25%: Excellent
- 25%+: Outstanding (but verify the numbers!)
- 8-12%: Acceptable for stable, low-effort investments
How to calculate: Use Excel’s =XIRR(values, dates) function. You can’t calculate it by hand without painful math.
IRR Formula Options in Excel
What’s the IRR formula in Excel? Well, there are a couple of options…
For regular annual cash flows, you can just use:
=IRR(values)
Each value in the range is assumed to represent a distinct annual cash flow. You’ll of course need a negative value to appear at the start of the range, representing your initial investment.
That said, the preferable way to calculate IRR in Excel is actually with:
= XIRR(values, dates)
With this alternative IRR formula, each value in the range can be tied to a specific date, rather than having Excel assume that each cash flow occurred in regular one year intervals. This more accurately represents actual cash flows, which tend to be irregular and are often distributed monthly or at random dates throughout the year.
Why XIRR is better: Real estate cash flows don’t happen in neat annual buckets. You buy on March 15th, collect rent on the 1st of each month, pay for a new roof in August, and sell on November 3rd. XIRR accounts for all this irregular timing. IRR doesn’t.
Why is the IRR Formula Important in Real Estate?
Calculating the internal rate of return is highly valued in real estate analysis because it’s the most reliable way to compare all-in deal performance to all sorts of other investments. “Other investments” here can mean anything from another real estate deal to stocks, bonds, commodities, or even a partnership interest in a business.
Since IRR is calculated as a percentage, rather than aggregate dollars, it’s an easy way to compare your returns even when the actual dollars invested in one project are much larger than another project.
The other big selling point for using the IRR metric for real estate is that it can handle capital expenses, leverage, interest and principal payments, and the generally lumpy cash flows that come with fix and flips and significant value appreciation.
Since (X)IRR essentially links each dollar in and each dollar out with a precise date, the IRR is a highly accurate assessment of performance that takes into account speed of execution and the time value of money.
Bottom line: IRR is great because it…
- Handles irregular cash flows (monthly rent, random repair bills, eventual sale)
- Accounts for leverage (your mortgage)
- Considers timing (money today > money tomorrow)
- Lets you compare $150K SFR and $500K apartment building investments on equal footing
IRR vs Other Real Estate Metrics
Cash-on-Cash Return:
- Simple: Annual cash flow ÷ initial cash investment
- Example: $6,000 annual cash flow ÷ $67,500 down = 8.9% CoC
- Limitation: Doesn’t account for appreciation, mortgage paydown, or sale proceeds
Cap Rate:
- Simple: Net operating income ÷ purchase price
- Example: $12,000 NOI ÷ $250,000 = 4.8% cap rate
- Limitation: Ignores leverage, financing, and your actual cash invested
IRR:
- Complex: Annualized return on all cash flows over time
- Advantage: Captures everything—cash flow, appreciation, leverage, timing, sale proceeds
When to use each:
- Cap rate: Comparing properties without considering financing
- Cash-on-cash: Evaluating annual cash flow relative to down payment
- IRR: Measuring total performance including eventual sale
- All three: Get the complete picture!
What’s a Good IRR for Rental Property?
This is the question everyone wants answered, and like most things in real estate: it depends.
General benchmarks:
- 8-12%: Acceptable for stable, low-maintenance properties in good areas
- 15-20%: Solid performance for most rental strategies
- 20-25%: Excellent returns (you’re doing well!)
- 25-35%: Outstanding (but double-check your assumptions)
- 35%+: Exceptional (or your projections are too optimistic)
Location:
- San Francisco with 12% IRR might be great if you can find it (stable, low vacancy)
- Cleveland with 12% IRR might be just mediocre (higher risk justifies higher returns)
Strategy:
- Buy-and-hold long-term rental: 10-15% is good
- BRRRR (buy, rehab, rent, refinance, repeat): 20%+ possible
- Fix-and-flip: 30%+ might be needed (higher risk, shorter timeline)
- Turnkey rental: 8-12% realistic (convenience premium)
Risk level:
- Lower risk = accept lower IRR (stable area, good tenants, newer property)
- Higher risk = demand higher IRR (rough area, value-add, major rehab)
Your alternatives:
- Stock market average: ~10% long-term
- Bonds/CDs: ~4-5% long-term
- Your projected IRR should best these alternatives given the extra work involved and leverage available on real estate investments.
Bottom line: If you’re consistently hitting 15-20% IRR on rental properties, you’re doing well. Anything above 20% is excellent. Below 12%? Question whether the extra work is worth it versus passive stock investing or the hundreds of other things you could be doing with your money.
How Might IRR Calculations Lead Us Astray?
The simple fact that the IRR calculation results in a percentage (instead of actual dollars) is both it’s strength and it’s Achilles heel. While this aspect makes IRR useful when comparing a real estate deal to a stock or bond investment, it makes IRR somewhat problematic when you’re trying to decide what to do going forward.
Let’s say you’re presented with a real estate opportunity that promises a killer 35% IRR. Sounds great, right? The danger is that if it’s a relatively small deal that requires a lot of your time and attention, it could still end up being a real loser. A much larger deal with a 22% projected IRR might be the smarter choice when you consider the profit potential in terms of actual dollars.
After all, I haven’t yet found a bank that will let me deposit an IRR percentage into a checking account. Actual dollars is what you’re after, right?
Bottom line: Use IRR to compare opportunities, but also pay attention to absolute dollar returns, time commitment, and risk. Don’t chase high IRR percentages on tiny deals while ignoring substantial profits from larger opportunities.
When IRR Doesn’t Tell the Whole Story
IRR works great for:
- Comparing multiple investment opportunities
- Measuring performance after you sell
- Evaluating deals with clear exit timelines
IRR is less useful for:
1. Buy-and-hold-forever strategies
- If you never plan to sell, IRR becomes theoretical
- Cash-on-cash return is more relevant for infinite hold periods
2. Very short-term deals (<1 year)
- IRR can look artificially inflated on quick flips
- Focus on absolute return and ROI instead
3. Comparing different time horizons
- 40% IRR over 6 months may appear better than an 18% IRR over 5 years
- But the 5-year deal might be less risky and more passive
4. When cash flow timing is highly uncertain
- IRR requires knowing when cash flows happen
- If timing is a wild guess, your IRR is a wild guess
Better approach: Use IRR (or projected IRR) alongside other metrics (cash-on-cash, cap rate, absolute profit, risk assessment) to make informed decisions.
FAQ
Use Excel’s =XIRR(values, dates) function. Set up a spreadsheet with one row for dates (purchase date, each monthly rent check, repair expenses, sale date) and another row for cash flows (negative for money out, positive for money in). XIRR calculates the annualized return that makes all those cash flows “break even” in present value terms.
IRR assumes cash flows happen at regular intervals (annually). XIRR lets you specify exact dates for each cash flow. For real estate, always use XIRR because cash flows are irregular—you don’t buy on January 1st, collect rent in perfect annual chunks, and sell exactly one year later. The XIRR function handles real-world messiness.
15-20% is solid for most rental properties. 20-25% is excellent. Above 25% is outstanding (but verify the numbers aren’t too optimistic). Below 12%? Question whether the hassle is worth it compared to passive stock market investing at ~10% long-term. Context matters: higher-risk deals should deliver higher IRR.
Yes, and it means you lost money. If your IRR is negative, the investment underperformed a 0% return (keeping cash under your mattress). Negative IRR happens when you sell for less than you paid, or when expenses exceed income by too much for too long.
Use both! Cash-on-cash measures annual cash flow relative to your down payment (simpler, focuses on year-one performance). IRR measures total return including appreciation and sale proceeds over the entire hold period (complex, comprehensive). CoC tells you about immediate cash flow, IRR tells you about long-term wealth building.
Leverage typically increases IRR (if the deal works). Example: 25% down payment might generate 20% IRR, while 100% cash purchase might only generate 12% IRR. Why? You’re earning returns on the bank’s money too. But leverage also increases risk—if the property declines in value, your IRR can crater faster with leverage.
Higher than buy-and-hold rentals—typically 25-35%+ for flips. Why? Fix-and-flip involves more risk (market timing, rehab cost overruns, holding costs) and more active work. If you’re only hitting 15% IRR on a flip, you could be better off buying a stabilized rental property that comes with a lot less stress.
Yes, if you calculate it correctly. When you sell and pay off the mortgage, the remaining equity (including all the principal you paid down over the years) flows back to you as positive cash flow. XIRR captures this in the final sale proceeds. This is why leveraged real estate often shows better IRR than the cap rate might suggest.
The Bottom Line on IRR
IRR is a powerful tool for measuring rental property performance because it attempts to capture everything—cash flow, appreciation, leverage, timing, and eventual sale—in one tidy percentage.
Use IRR to:
- Compare different real estate deals on equal footing
- Measure actual performance after selling
- Evaluate whether your projected returns justify the risk and effort
Don’t use IRR as your only metric:
- Look at absolute dollar profits too
- Consider cash-on-cash return for annual cash flow
- Factor in risk, time commitment, and market conditions
How to calculate it: Use Excel’s =XIRR(values, dates) function. Set up your dates and cash flows, let Excel do the painful math, and you’ll know exactly what return you’re projecting or have already earned.
And remember: A 35% IRR on a tiny deal that consumes your life might be worse than an 18% IRR on a larger deal that runs itself. Don’t let the allure of high percentages blind you to actual dollars and quality of life.
For more rental property analysis:
- Rental Property Depreciation Calculator – Calculate tax deductions
- Simple Mortgage Calculator – Model financing scenarios
- Airbnb Income Calculator – Project vacation rental returns
