Real estate investors look at dozens of deals every year, but picking the best one is rarely about price alone. Two properties with similar cash flow can produce very different long term returns once you factor in time.

That is where IRR steps in. Internal Rate of Return is one of the most trusted metrics serious investors use to compare deals across different holding periods, financing structures, and exit strategies.

Key Takeaways

• IRR is the annualized return rate that makes the net present value of all cash flows equal to zero.
• It accounts for the time value of money, unlike basic ROI or cap rate.
• A “good” IRR for real estate usually falls between 10% and 20%, depending on risk.
• IRR works best when paired with cash on cash return, equity multiple, and NPV.
• Financing structure has a strong impact on the final IRR figure.

What Is IRR in Real Estate?

Internal Rate of Return, often shortened to IRR, is the discount rate at which the net present value (NPV) of every future cash flow from a property equals zero. In simple words, it is the annualized rate of return your investment is expected to earn over the full holding period.

For real estate, this includes the down payment, monthly rental income, renovation costs, and the final sale proceeds. Because IRR factors in when each dollar arrives, it gives a more honest picture than a flat return number.

The IRR Formula

The IRR formula looks complex on paper, but the idea behind it is straightforward. You are solving for the rate “r” that makes the present value of all cash inflows match the original investment.

NPV = Σ [Cₜ / (1 + r)ᵗ] − C₀ = 0

Where:

• Cₜ = Net cash flow during period t
• C₀ = Initial investment
• r = Internal Rate of Return
• t = Time period

In practice, almost no one solves this by hand. Investors use Excel, financial calculators, or modeling software to find the answer through iteration.

How to Calculate IRR (Step by Step)

Calculating IRR for a rental property follows a simple process once you organize your numbers. Start by listing every cash flow tied to the deal, including the negative one at the start.

Here is a quick example. An investor buys a duplex for $300,000 with $75,000 down. Net rental cash flow runs $9,000 per year for five years, and the property sells for $360,000 at the end of year five with a loan payoff of $200,000.

Cash flow timeline:

• Year 0: −$75,000 (down payment)
• Year 1 to 4: +$9,000 each year
• Year 5: +$9,000 + $160,000 net sale proceeds = $169,000

Plugged into Excel, the IRR works out to roughly 22%. That is a strong result driven by both rental income and appreciation.

How to Calculate IRR in Excel

Excel makes IRR calculations almost effortless once your cash flows are listed in a column. The built-in IRR function does the iteration work for you in a single step.

Steps to follow:

1. List all cash flows in one column, starting with the negative initial investment.
2. Click an empty cell where you want the result.
3. Type =IRR(range) where range is your list of cash flows.
4. Press Enter and Excel returns the annualized rate.

For irregular timing, use the XIRR function with matching date columns for more accuracy.

What Is a Good IRR for Real Estate?

A “good” IRR depends entirely on the strategy and risk you are taking on. Stable rentals in established markets carry less risk, so they produce lower IRR. Higher risk projects like ground up development demand stronger returns to be worth the effort.

General benchmarks investors use:

• Core rental properties: 8% to 12%
• Value add deals: 12% to 18%
• Opportunistic projects and flips: 18% and above
• Ground up development: 20%+

Anything below 8% on a leveraged residential deal usually signals the numbers need a second look.

IRR vs. Cash on Cash Return

Cash on cash return measures the annual pre-tax cash flow against the cash you put into a deal. It is simple, fast, and ideal for year one analysis. The catch is that it ignores appreciation, loan paydown, and time.

IRR captures all of those moving parts. For a buy and hold investor planning a five or ten year horizon, IRR paints the full picture while cash on cash gives the quick snapshot.

IRR vs. ROI

Return on Investment is the total profit divided by the initial cost. ROI is easy to communicate, but it treats a 20% return earned in one year the same as a 20% return earned over ten years.

That is the gap IRR fills. By annualizing the return and weighting cash flows by time, IRR lets investors compare a quick flip against a long term rental on equal footing.

IRR vs. CAGR

Compound Annual Growth Rate measures the steady annual rate that would grow an initial value to a final value, assuming no interim cash flows. Real estate rarely works that way because rent comes in monthly.

IRR handles those interim cash flows directly, which is why it is the preferred metric for income producing properties while CAGR fits better for assets like raw land or stocks held without dividends.

How Financing Affects IRR

Financing has a major effect on IRR because debt reduces the cash you put into the deal while keeping most of the upside. A lower equity check against the same total return pushes IRR higher, sometimes by a wide margin.

This is exactly where loan structure matters. At REIF Loans, investors use DSCR loans, cash out refinance options, and investment property loans to keep cash deployed across more deals and hit stronger IRR targets without overextending equity.

Limitations of IRR

IRR is powerful, but it is not perfect. The formula assumes every interim cash flow gets reinvested at the same IRR, which rarely happens in real life.

A few other watch outs:

• IRR can produce multiple results if cash flows switch signs more than once.
• Very short holding periods can inflate IRR and mislead investors.
• It does not measure the size of the gain, only the rate.
• Pair IRR with equity multiple and NPV for a complete view.

The Bottom Line

IRR is one of the most useful tools real estate investors have to compare deals across different timelines and structures. It rewards efficient use of capital and exposes deals that look good on paper but underperform once time is factored in.

The right financing partner can make a real difference in the final number. REIF Loans helps investors finance, refinance, and scale residential and commercial properties with DSCR loans and investor focused solutions across Michigan and 43 states. Connect with REIF Loans to map out the financing that fits your IRR goals.