Internal Rate of Return in Real Estate: A Practical Guide

The internal rate of return in real estate is the annual return that makes all of a deal’s cash flows, money in and money out, worth exactly zero in today’s dollars. In plain terms, IRR tells you the yearly rate your cash earned over the life of an investment, after accounting for when each dollar went in and when each dollar came back.

That “when” is what makes IRR different from simpler measures, and it is also what makes it easy to misuse. This guide shows how to calculate IRR for a rental, a flip, and a wholesale deal, how to do it in a spreadsheet, how it compares with cash-on-cash return and equity multiple, and where the number misleads.

What IRR measures, and why timing matters

Most beginner metrics look at a single year or a single total. Cash-on-cash return measures one year’s cash flow against the cash you invested. Total profit adds everything up. Neither cares whether you got your money back in year one or year ten.

IRR does. It treats a dollar received sooner as worth more than a dollar received later, because you can reinvest it. Two deals with the same total profit can have very different IRRs.

Year	Deal A	Deal B
0 (purchase)	-$50,000	-$50,000
1	$0	$6,000
2	$0	$6,000
3	$0	$6,000
4	$0	$6,000
5 (sale)	$80,000	$56,000
Total profit	$30,000	$30,000
IRR	about 9.9%	about 12.0%

These figures are hypothetical. Both deals turn $50,000 into $80,000 over five years, but Deal B returns cash every year, so its money is working sooner. Its IRR is about two points higher even though the total profit is identical.

The formula behind the internal rate of return

IRR is the rate r that solves this equation:

0 = CF0 + CF1 / (1 + r) + CF2 / (1 + r)² + … + CFn / (1 + r)ⁿ

CF0 is the initial investment (a negative number), and CF1 through CFn are the cash flows in each period, including the final sale. There is no algebraic shortcut for most deals. Spreadsheets find r by trial and error, testing rates until the present value of the cash flows equals zero.

The output is easiest to understand by comparison. If a deal’s IRR is 12 percent, your cash grew as if it had been invested in an account that compounded at 12 percent a year, with withdrawals matching the deal’s cash flows. If your alternative use for that money earns 8 percent, the deal beats it, at least on paper.

Worked example: a leveraged rental held five years

The numbers below are hypothetical, built to show the method. Plug in your own market’s rents, expenses, and rates.

Purchase. A single-family rental bought for $200,000 with a 75 percent loan of $150,000 at 7.25 percent on a 30-year schedule, plus $6,000 in closing costs. Cash invested: $56,000. For context, Freddie Mac’s weekly survey put the average 30-year fixed rate at 7.32 percent on October 22, 2026; investor loans usually price higher than owner-occupied ones, so check your own quotes.

Operations. Rent starts at $1,950 a month, or $23,400 a year, and rises 3 percent a year. Operating expenses (taxes, insurance, repairs, vacancy, management) take 40 percent of rent, so year-one net operating income is $14,040. Annual mortgage payments total about $12,279, leaving roughly $1,761 of cash flow in year one. If you need a refresher on that middle number, see our guide to net operating income.

Sale. The property appreciates 3 percent a year and sells at the end of year five for about $231,855. After 7 percent in selling costs and a loan payoff of about $141,568, the net sale proceeds are about $74,057.

Year	Cash flow from operations	Sale proceeds	Total cash flow
0			-$56,000
1	$1,761		$1,761
2	$2,182		$2,182
3	$2,616		$2,616
4	$3,063		$3,063
5	$3,523	$74,057	$77,580

The IRR of that stream is about 9.8 percent. The total cash returned is about $87,200 on $56,000 invested, a profit of roughly $31,200, and an equity multiple of about 1.56. Our guide to the equity multiple in real estate shows how that second number is calculated and where it can mislead.

Notice what drove it. The yearly cash flow was thin, producing a year-one cash-on-cash return of about 3.1 percent. Most of the return came from the sale: appreciation plus five years of loan paydown. That is common for leveraged rentals with thin cash flow, and it is exactly why IRR matters. A cash-on-cash number alone would make this deal look weak; IRR shows the whole picture, including the risk that the sale price is the part you are guessing.

The same deal, paid in cash

Buy the same house with $206,000 of cash and no loan, and the yearly cash flow jumps to the full net operating income, starting at $14,040. The IRR falls to about 8.0 percent, and the equity multiple to about 1.41. Leverage raised the IRR here because the property’s unleveraged return (about 8 percent) was higher than the 7.25 percent cost of the borrowed money. When borrowing costs more than the property earns, leverage lowers IRR instead, and it always increases risk.

How sensitive is the answer?

IRR projections are only as good as their assumptions. Changing just the appreciation rate on the leveraged example shows how much the sale assumption carries:

Annual appreciation	Approximate IRR	Total profit
0%	0.6%	about $1,600
3%	9.8%	about $31,200
5%	15.0%	about $53,000

Holding the same deal for ten years at 3 percent appreciation instead of five pushes the IRR to about 12.4 percent and the equity multiple to about 2.8, mostly because rent growth and loan paydown compound over a longer hold. Always run a pessimistic case. If the deal only works with optimistic appreciation, it is a bet on the market, not an investment in the property.

IRR on flips: why short holds look spectacular

Now take a flip. An investor puts in $40,000 of their own cash for the down payment and rehab and gets back $52,000 when the house sells six months later. That is a $12,000 profit, or 30 percent on the cash invested.

Annualized, that six-month return works out to an IRR of about 69 percent, because the math assumes you could repeat the same 30 percent gain twice a year. If the same flip took twelve months, the IRR would be 30 percent.

Both IRRs are mathematically correct, and both can mislead. Most flippers cannot find, fund, and finish a new project the day the last one closes, so the money sits idle between deals. For flips, pair IRR with plain profit per project and profit per month of your own time. Our fix-and-flip calculator lays out the costs that decide whether that $12,000 is real.

IRR on wholesale deals: the wrong tool entirely

Suppose you put down $1,000 of earnest money, assign the contract 30 days later, and collect an $11,000 fee with your deposit back. Run that through an IRR formula and you get a percentage with more than a dozen digits. That is not a typo; it is a sign that IRR is meaningless when the investment is tiny and the hold is short.

Wholesaling returns come mostly from your time, marketing, and skill, not from capital compounding. Better measures are profit per deal, marketing cost per deal, and how many deals you close each quarter. Our guide to the assignment fee covers how to think about the economics of a wholesale deal.

Where IRR does matter to wholesalers is on the other side of the table. Landlords, syndicators, and funds on your buyers list often underwrite with IRR. Knowing how they think helps you package deals they will buy.

How to calculate IRR in Excel or Google Sheets

You do not need a financial calculator. Three spreadsheet functions cover almost every situation.

1. IRR for evenly spaced periods. List the cash flows in one column, starting with the negative investment, and use =IRR(B2:B7). Microsoft’s IRR function documentation covers the details. Monthly cash flows give a monthly rate; convert it to annual with =(1+monthly)^12-1.
2. XIRR for real dates. Real deals do not close on January 1. Put each cash flow next to its actual date and use =XIRR(values, dates). According to Microsoft’s XIRR documentation, the function returns the internal rate of return for cash flows that are not necessarily periodic, and assumes a 10 percent starting guess if you do not provide one. XIRR is the right choice for flips, rehabs with staged draws, and anything where timing is irregular.
3. MIRR when you want a more conservative answer. Standard IRR implicitly assumes interim cash flows are reinvested at the IRR itself. The MIRR function lets you set a finance rate for the money you put in and a separate reinvestment rate for the money that comes out, which usually gives a lower, more realistic figure for high-IRR deals.

Two practical tips. First, every cash flow stream needs at least one negative and one positive value, or the function returns an error. Second, if your cash flows change sign more than once, for example a big capital call in year three, IRR can have more than one mathematically valid answer. When that happens, use MIRR or net present value instead.

Internal rate of return vs other real estate metrics

Each metric answers a different question. Experienced investors look at several together.

Metric	Question it answers	Accounts for timing?	Best used for
Internal rate of return	What annual rate did my cash earn over the whole hold?	Yes	Comparing multi-year deals with different cash flow patterns
Cash-on-cash return	What did my cash earn this year?	No	Year-one income checks on rentals
Equity multiple	How many times did I get my money back?	No	Sizing total profit; pairs well with IRR
Cap rate	What does the property earn on its price, ignoring financing?	No	Comparing property prices and income across a market
Profit per project	How much did I make?	No	Flips and wholesale deals

A useful habit: report IRR and equity multiple together. A 20 percent IRR on a six-month deal and a 14 percent IRR on a ten-year deal describe very different amounts of wealth. The equity multiple shows the size of the win; the IRR shows the speed. For rentals, our cash-on-cash return calculator handles the year-one view, and the BRRRR calculator shows how a refinance returns capital early, which is exactly what lifts IRR on a BRRRR deal.

How investors use IRR to compare deals

Here is a simple process for using IRR without fooling yourself:

1. Build the cash flow stream honestly. Include closing costs, rehab, reserves, capital expenditures, vacancy, and selling costs. Leaving out a roof replacement in year four can add points of IRR that will never exist.
2. Use conservative exit assumptions. Assume modest appreciation or none, and a realistic exit cap rate for income property.
3. Run three cases. Pessimistic, expected, and optimistic. Decide whether the pessimistic case is survivable.
4. Compare against a hurdle rate. Your hurdle is the return you require for the risk and effort, often set by what you could earn elsewhere plus a premium. A passive investment should clear it easily; a hands-on rental should clear it by more.
5. Check the equity multiple and the cash flow. A high IRR with a thin equity multiple, or with negative cash flow you cannot afford to carry, is a warning sign.

Where IRR misleads

• It hides the size of the profit. A 50 percent IRR on $5,000 for two months makes you less money than a 12 percent IRR on $100,000 for five years.
• It assumes reinvestment at the same rate. Standard IRR implicitly assumes interim cash flows earn the IRR when reinvested, which is unrealistic for high-IRR projects.
• It is easy to inflate. Shortening the hold, raising the exit price, or using more leverage all lift IRR on paper. Sponsors marketing a deal know this. When you review anyone’s projected IRR, ask for the cash flow stream and the assumptions behind the sale.
• It ignores risk. A projected 15 percent IRR on a stabilized rental and on a ground-up development are not equivalent. IRR has no risk adjustment built in.
• It can be undefined or multiple. Irregular cash flows with several sign changes can produce more than one IRR or none.

If you invest passively in a real estate syndication, these points matter even more, because the IRR in the offering materials is a projection from the sponsor, not a promise.

When to use something other than IRR

IRR is the wrong headline number for wholesale fees, for very short projects, and for deals where you are mainly buying cash flow to live on. A retiree buying a paid-off rental for income may care far more about steady cash-on-cash return than IRR. A wholesaler should track profit per deal. A flipper should track profit per project and per month. Use IRR when the question is “how hard did my money work over a multi-year hold?” and use simpler measures for everything else.

Internal rate of return FAQ

What is a good IRR for a rental property?

There is no single answer. It depends on the risk, your alternatives, and the market. A useful approach is to set your own hurdle rate above what lower-risk investments pay you today, and require a bigger margin for properties that need heavy work or active management.

Is IRR the same as ROI?

No. ROI usually means total profit divided by cash invested, with no adjustment for time. IRR converts the return into an annual rate that reflects when each cash flow happened.

Why is my IRR so different from my cash-on-cash return?

Cash-on-cash return only counts one year of operating cash flow. IRR includes loan paydown and the sale, which often make up most of a rental’s total return.

Does IRR include taxes?

Only if you build them in. Most projections show a pre-tax IRR. Depreciation, the tax on the sale, and any deferral through an exchange can move your after-tax return a long way in either direction, so ask a tax professional to review the after-tax picture on any large hold.

Can a refinance raise my IRR?

Yes. Pulling cash out early returns part of your investment sooner, and IRR rewards early cash. That is why a successful BRRRR deal often shows a much higher IRR than the same property bought and held without a refinance, as long as the new loan payment still leaves positive cash flow.

Should I use IRR or XIRR?

Use XIRR whenever your cash flows have real dates that are not evenly spaced, which is most real deals. Use IRR for simple annual projections.

IRR is one of the most useful numbers in real estate when you understand its blind spots. Build honest cash flows, test your assumptions, report it next to the equity multiple, and use it to compare multi-year deals rather than to impress anyone.

Sharpen your deal analysis