Investment approach
How to Calculate Real Estate Investment Returns: ROI, IRR, Multiple
A project's return is measured with three numbers: ROI, equity multiple and IRR. Formulas and one worked example, where the naive profit comes out 2.4 times larger than the real one.
Real estate investment returns are calculated with three numbers: ROI (profit relative to invested capital), equity multiple (how many euros came back per euro invested) and IRR (an annual rate that accounts for timing). For a renovate-and-resell project, you first add up all costs, then subtract them from net proceeds. Below are the formulas and one worked example.
What goes in and what comes out
Invested: everything you paid before the sale. Purchase price, taxes and closing costs on purchase, renovation, a contingency reserve, holding costs (IBI, the property tax; comunidad, the owners' association fees; utilities; insurance) for the whole period, and loan interest if there is a loan. Returned: the sale price minus selling costs (agent commission, certificado energético, cédula de habitabilidad, other items).
The most common beginner mistake is to calculate profit as "sale minus purchase". That produces a number nobody ever receives in hand. The full list of line items is in the breakdown of a complete investment project budget, and the typical omissions are collected in 12 calculation mistakes.
How to calculate real estate investment returns: three formulas
| Metric | Formula | What it answers |
|---|---|---|
| ROI | (net proceeds − all costs) / all costs | What percentage was earned on the capital invested |
| Equity multiple (EM) | net proceeds / all costs | How many euros came back per €1 invested |
| IRR | the rate r at which the cash flows, discounted at r, sum to zero | Annual return that reflects when money went out and came back |
IRR is defined as the rate at which the present value of all cash flows equals zero; the CFA Institute describes it as an estimate of a project's return under certain assumptions (CFA Institute, Capital Investments and Capital Allocation). For a single investment and a single payback it needs no iteration: IRR = EM^(1/n) − 1, where n is in years. If there are several cash flows at different dates, you need a table (the XIRR function in Excel) or a calculator.
ROI and EM say the same thing in different units: ROI = EM − 1. The difference between them and IRR is only time. A project with 13% ROI over a year and a half and a project with 13% ROI over four years look identical by ROI and very different by IRR.
Worked example: an 18-month project
Worked example, not a forecast and not a DNPI project. The numbers are round, capital gains tax is not included, there is no loan. The 10% ITP (transfer tax) is taken from the general Catalan scale for values up to €600,000 (Agència Tributària de Catalunya, scale from 27 June 2025); the remaining 3.5% and the 4% selling costs are assumptions that you replace with your own.
| Item | Amount, € |
|---|---|
| Purchase price | 400,000 |
| Taxes and closing costs on purchase (13.5% assumed: ITP 10% plus 3.5% for notary, registry, gestoría and other items) | 54,000 |
| Renovation | 70,000 |
| Contingency reserve | 7,000 |
| Holding costs over the period | 12,000 |
| Total invested | 543,000 |
| Sale price | 640,000 |
| Selling costs (4% assumed) | 25,600 |
| Net proceeds | 614,400 |
Profit before capital gains tax: 614,400 − 543,000 = €71,400. ROI = 71,400 / 543,000 = 13.1%. EM = 614,400 / 543,000 = 1.13x. IRR with a single up-front investment and a 1.5-year term: 1.1315^(1/1.5) − 1 = 8.6% a year.
Compare this with the "naive" calculation: 640,000 − 400,000 − 70,000 = €170,000, which is 36% on 470,000. The naive profit is 2.4 times larger because it leaves out purchase taxes, the reserve, holding costs and selling costs.
What changes if the money goes in tranches
The purchase with taxes goes out on day zero, and the renovation is paid in pieces. If €38,500 goes out after 4 months and another €38,500 after 9, the holding costs of €12,000 fall in month 12, and the sale closes in month 18, XIRR in our example gives 9.2% instead of 8.6%. EM stays at 1.13x. The capital was at work for less time, and IRR showed it where ROI did not.
With a loan the numbers shift more: profit falls by the interest, and the equity invested becomes smaller. IRR on equity can rise, but risk rises with it. That calculation needs a separate look at the capital structure.
When these formulas do not fit
They do not work when there is no clear exit date (long-term holding for rent) or when you compare projects of different size by percentages alone. For rentals, you calculate net rental yield. To compare projects, look at both the percentages and the absolute profit in euros. The formulas describe a project, they do not promise anything: until the sale, every input remains an assumption.
On the /methodology page, project ROI is defined the same way: net result to total investment, and the annualised equivalent brings it to a single period. Ludovic Phalippou wrote about the limits of IRR on the blog of the CFA Institute Research and Policy Center (8 November 2024): IRR is not the same as ROI, and the return on assets with interim cash flows cannot be determined without assumptions about the reinvestment rate. If you want to test the example on your own numbers, start with the cost table and see how IRR behaves over different terms and how it differs from equity multiple.
Questions and answers
What is the ROI formula in real estate?
ROI equals net proceeds minus all costs, divided by all costs. Costs include purchase taxes, renovation, holding costs and selling costs, not just the price of the property.
What is a good ROI for a renovation project?
There is no universal number, and I will not name one. Compare ROI against the term (through IRR), against the project's risk and against what the same capital would have earned elsewhere (how to compare on one horizon). Separately, calculate the break-even point: the sale price below which the project loses money.
How is IRR different from annual ROI?
Annual ROI simply divides ROI by the number of years. IRR accounts for compounding and the exact payment dates. On short projects the difference is small; on long ones and with tranches it is noticeable.
Do I need to calculate returns after tax?
Yes, but the tax depends on the seller's status: a resident individual, a non-resident and a company are taxed under different rules. A pre-tax calculation is useful for comparing projects, a post-tax one for the decision. Put the question for your situation to an asesor fiscal (tax adviser).
