What IRR means in real estate, how it uses every cash flow from purchase to sale, how it differs from cap rate and cash-on-cash, and its limits.
Internal rate of return (IRR) is the annual rate of return that sets the net present value of all of an investment’s cash flows, money in and money out, to zero.
In real estate, IRR rolls the purchase price, the yearly cash flow and the sale proceeds into one annual return, so you can compare deals held for different lengths of time. For a simpler yearly measure, see cash-on-cash return, the simpler yearly measure.
This guide explains how IRR works and walks through a full five-year example. It shows how leverage and the exit cap rate change the result, and covers the limits of the measure. It closes with how the measure applies to Colorado mountain and Western Slope property.
How IRR Works in a Real Estate Deal
IRR uses every cash flow over the hold, along with its timing:
- the cash you invest at the start, a negative number;
- the yearly cash flow while you own the property;
- the net proceeds when you sell.
A discounted cash flow analysis projects those cash flows over the hold period, including the sale. IRR is the rate at which their present value equals the investment. Spreadsheets solve for it by trial, because there is no simple formula.
The IRR formula
IRR is the rate r that makes this equation true:
0 = CF0 + CF1 / (1 + r) + CF2 / (1 + r)^2 + … + CFn / (1 + r)^n
CF0 is the money you put in, entered as a negative number. CF1 through CFn are the cash flows in each later year, with the sale proceeds added to the last one. The equation usually has no direct solution, so software tests one rate after another until the net present value lands at zero.
IRR, NPV and the discount rate
Net present value (NPV) is the value today of all future cash flows, discounted at a rate you choose, minus what you invest. IRR is simply the discount rate at which NPV equals zero.
The two measures answer different questions. NPV asks how many dollars a deal adds at your required return. IRR asks what annual return the deal itself produces. If a deal’s IRR is above your required return, its NPV at that return is positive.
Step by step: how to calculate IRR on a property
- Set the hold period. Pick how many years you expect to own the property, often five to ten.
- Enter the equity. Put the purchase price plus closing costs, minus any loan, as a negative number in year 0.
- Project the yearly cash flow. Start from net operating income, the starting point for cash flow. Subtract debt service if the deal uses a loan.
- Estimate the sale. Divide the next year’s NOI by an exit cap rate, subtract selling costs, then subtract the loan balance.
- Add the sale to the last year. The final year’s cash flow plus the net sale proceeds go in one cell.
- Solve. Use the spreadsheet IRR function on the row of cash flows.
A full projection like this is a real estate pro forma built year by year, and IRR is one of the outputs it produces.
A Worked IRR Example
A worked example shows how the pieces fit. The figures below are illustrative, not market data.
An investor buys a small retail building for $1,000,000 in cash. Year 1 NOI is $70,000, and NOI grows 3% a year. The investor sells at the end of year 5 at a 7% cap rate on year 6 NOI, and pays 3% in selling costs.
| Year | Cash flow | What it is |
|---|---|---|
| 0 | -$1,000,000 | Purchase |
| 1 | $70,000 | NOI |
| 2 | $72,100 | NOI |
| 3 | $74,263 | NOI |
| 4 | $76,491 | NOI |
| 5 | $1,203,279 | NOI of $78,786 plus net sale of $1,124,493 |
The sale price is year 6 NOI of $81,149 divided by 0.07, or about $1,159,271. After 3% selling costs, the net is about $1,124,493.
Solving for the rate gives an IRR of about 9.5%. The investor gets back about $1.50 for every dollar invested, an equity multiple of 1.50x.
The same deal with a loan
Now the investor borrows $650,000 at 6.5% interest only, so annual interest is $42,250. The equity check falls to $350,000.
| Year | Cash flow to equity |
|---|---|
| 0 | -$350,000 |
| 1 | $27,750 |
| 2 | $29,850 |
| 3 | $32,013 |
| 4 | $34,241 |
| 5 | $511,029 |
The levered IRR rises to about 14.3%, and the equity multiple rises to about 1.81x. Leverage raised the return because the property’s yield was above the cost of the loan. If the loan cost more than the property earned, leverage would push the IRR down instead. Lenders also test whether NOI covers the payments, which is the debt service coverage ratio lenders use.
What happens if the exit cap rate rises
The sale price drives most of the IRR, so the exit cap rate matters a great deal.
If the same building sells at a 7.5% cap rate instead of 7%, the net sale falls to about $1,049,527. The all-cash IRR drops from about 9.5% to about 8.2%. The levered IRR drops from about 14.3% to about 11.3%. A half-point move in one assumption cost the levered investor about three points of annual return.
Why timing changes IRR
IRR rewards money that comes back sooner. Take two deals that each cost $100,000 and each return $150,000 in total over three years:
- Deal A pays nothing until a single $150,000 payment in year 3. Its IRR is about 14.5%.
- Deal B pays $10,000 in years 1 and 2, then $130,000 in year 3. Its IRR is about 15.7%.
The profit is the same, $50,000. Deal B has the higher IRR only because some cash arrives earlier.
How to Calculate IRR in Excel or Google Sheets
Spreadsheets have three functions for this, and each fits a different kind of deal.
| Function | Use it when | Notes |
|---|---|---|
| IRR(values, [guess]) | Cash flows fall at regular intervals, such as once a year | Needs at least one negative and one positive value |
| XIRR(values, dates, [guess]) | Cash flows fall on irregular dates | Each value has its own date; discounts on a 365-day year |
| MIRR(values, finance_rate, reinvest_rate) | You want to set the borrowing and reinvestment rates yourself | Reduces the reinvestment problem described below |
In Microsoft Excel, IRR and XIRR both start from a default guess of 10% and repeat the calculation until the answer settles. IRR returns a #NUM! error if it finds no result after 20 tries, and XIRR after 100 tries. A different guess often fixes the error.
Real deals rarely pay on neat anniversaries. Closings, capital calls and the sale land on specific days, so XIRR usually gives the more accurate answer.
IRR vs Cash-on-Cash and Cap Rate
A cap rate is one year of NOI against value, cash-on-cash is one year of cash flow against your cash, and IRR covers the whole hold, including the sale.
Cap rates use NOI before financing. See Colorado cap rates by town.
| Measure | Formula | Time covered | Includes loan? | Includes sale? |
|---|---|---|---|---|
| Cap rate | NOI / value | One year | No | No |
| Cash-on-cash return | Pre-tax cash flow / cash invested | One year | Yes | No |
| Equity multiple | Total cash returned / cash invested | Whole hold | Yes, if levered | Yes |
| IRR | Rate that sets NPV to zero | Whole hold | Yes, if levered | Yes |
In the all-cash example above, the year 1 cap rate is 7.0%, and the IRR is about 9.5%. The gap comes from rent growth and the sale. Use the cap rate to price the building and cash-on-cash to judge the yearly yield on your cash. Use IRR with the equity multiple to judge the whole investment.
IRR vs equity multiple
The equity multiple tells you how much money you get back. IRR tells you how fast. A deal that returns 2.0x over 10 years can have a lower IRR than one returning 1.5x over three years. Investors usually read both together, because a high IRR on a short hold may mean few total dollars.
Limits of IRR
IRR is a popular measure, but it should not be used alone.
Its assumptions do not always fit the investment. Check it against net present value and the actual dollars a deal earns.
- Reinvestment assumption: IRR is often read as if interim cash is reinvested at the IRR itself. Finance writers debate how literal that is, but a very high IRR can overstate what you will earn on cash you take out. MIRR lets you set a realistic reinvestment rate instead.
- Multiple answers: When cash flows switch from negative to positive more than once, there can be more than one IRR. This happens when a deal needs a large capital call partway through, such as a roof or a re-tenanting.
- Scale: IRR ignores size. A small deal with a 20% IRR can add fewer dollars than a large deal at 12%. For choosing between deals you cannot do together, NPV is the better guide.
- Assumption risk: Most of the return often sits in the sale, which is a forecast. Small changes in the exit cap rate, rent growth or hold period move the result, as the example shows.
- Timing games: In funds, the sponsor controls when cash goes out and comes back. Early distributions or a credit line can lift a reported IRR without adding profit, so ask for the equity multiple too.
Common IRR mistakes to avoid
- Mixing levered and unlevered IRRs when comparing deals.
- Forgetting closing costs at purchase and selling costs at exit.
- Using an exit cap rate lower than today’s rate without a clear reason.
- Leaving out capital spending, such as roofs, parking lots and tenant improvements.
- Comparing a sponsor’s projected IRR with another sponsor’s actual IRR.
- Ignoring taxes; most quoted IRRs are before tax, and your CPA can show the after-tax picture.
IRR and Exit Cap Rates in Colorado Markets
The exit cap rate is where Colorado local data matters most. Broker-reported cap rates in 2026 run from 4.5% to 6.0% in Aspen-Snowmass (H1 2026) to 8% in Montrose (Q2 2026). Montrose cap rates moved from 7% in Q2 2025 to 8% in Q2 2026, according to RMCRE’s Montrose update. That one-point rise is twice the move in the example above.
Mesa County moved the other way, from 7.75% to 7.0% for June 30 year-to-date 2026, per the Mesa County Q2 2026 market update. An exit assumption that looked cautious in Grand Junction a year ago may now be too high. One that looked safe in Montrose may now be too low.
Frequently Asked Questions
What is a good IRR in real estate?
A good IRR is one that beats your required return for the risk you take. Stable, fully leased property usually justifies a lower target than a vacant building or a ground-up project. Compare a deal’s IRR with your other options, and check the equity multiple and NPV before deciding.
Is IRR the same as annual return?
No. IRR is an annualized rate that accounts for when each dollar comes in and goes out. A simple average annual return ignores timing, so two deals with the same average return can have different IRRs.
What is the difference between levered and unlevered IRR?
Unlevered IRR measures the property’s return as if bought in cash. Levered IRR measures the return on the investor’s equity after loan payments and loan payoff. In the example above, the same building produced about 9.5% unlevered and about 14.3% levered.
Why does IRR fall the longer you hold a property?
It does not always fall, but early gains count for more. If most of the value is created early, such as through a lease-up, holding longer spreads that gain over more years and lowers the IRR. The total profit, and the equity multiple, may still rise.
Should I use IRR or XIRR?
Use XIRR when cash flows fall on actual, uneven dates, which is the case for most real property deals. Use IRR for quick models built on whole years. The two give similar answers when dates fall about a year apart.
Does IRR include taxes?
Usually not. Most deal projections show pre-tax IRR. Depreciation, a 1031 exchange or capital gains tax can change your after-tax return a lot, so ask a CPA to model your own situation.
Underwriting Colorado Deals
RMCRE members test what a property will achieve today against what holding it another cycle is likely to return. More on investing in Colorado commercial real estate.
Rocky Mountain Commercial Real Estate (RMCRE) is a network of partner brokers across Colorado mountain towns, working together since 2010. Members can supply local rents, vacancy and recent sales for a pro forma. For a modeled return on a specific building, ask about investment analysis and valuation counseling.
