Ladrillómetro
ES
✎

IRR of a property investment in Spain: what it is, how to calculate it and a 10-year example

What IRR and NPV measure on a rental flat, how to build 10-year cash flows and a mortgaged example: 6.5% IRR and NPV at 5% of +€9,452 if the price rises 2% a year.

YIELD · 9 MIN READ

The IRR of a property investment is the annualised return of every cash flow on the flat (rent, mortgage and sale), and NPV is what those cash flows are worth today at a discount rate. For Ladrillómetro’s reference flat, €65,000 of equity, a 3% mortgage and 2% annual appreciation, the 10-year IRR is 6.5% and the NPV at 5% is +€9,452.

To see the IRR and NPV of your own flat, open the rental yield calculator. This guide explains what they measure, how to build 10-year cash flows, why IRR beats cash-on-cash and how the result changes if the price is flat or rises 4% a year.

Why is a one-year yield not enough?

Gross yield, net yield and cash-on-cash look at a single year. On the reference flat they come out at 6.8% gross, 4.1% net and 1.5% cash-on-cash: the rent barely covers costs and the mortgage. That does not tell you whether, over 10 years, the deal beats leaving the money elsewhere.

IRR and NPV put each year’s cash flow, the debt you pay down and the net sale proceeds into one account. They answer the question that matters: what annual return does the equity you put in earn over the whole cycle?

What is the IRR of a property investment?

IRR (internal rate of return; TIR in Spanish) is the interest rate that makes the present value of every receipt and payment on the project equal zero. In practice: the constant annual return that matches the real sequence of cash flows.

On a mortgaged flat the typical sequence is:

  • Year 0: you put in equity (deposit, buying costs and works). Here, −€65,000.
  • Years 1 to 9: rental cash flow (rent collected − running costs − mortgage payment).
  • Year 10: that year’s cash flow plus the net sale (sale price minus selling costs minus outstanding debt).

There is no simple closed formula: it is solved by iteration (Excel’s =IRR() or Ladrillómetro’s calculator). What matters is to treat every cash flow consistently and not mix income tax on rent with tax on the sale if you have not modelled it.

An extreme case is bare ownership: you pay today and collect nothing until you get the flat back, so the IRR depends almost entirely on how long the usufruct lasts. We work it out in bare ownership in Spain: is it a better deal than letting?

What is NPV and which discount rate should you use?

NPV (net present value; VAN in Spanish) adds up each cash flow discounted at a rate you choose. If NPV is positive, the project is worth more, in today’s euros, than that alternative. In plain text:

NPV = CF₀ + CF₁/(1+r) + CF₂/(1+r)² + … + CFₙ/(1+r)ⁿ, where r is the annual discount rate.

Which r? A common reference is what you would expect from another investment of similar risk (for example 5% for a long-term mix of bonds and equities). It is not a forecast: it is your opportunity cost. In the example we use 5%.

Useful link: if IRR is above your discount rate, NPV is positive; if it is below, NPV is negative.

NPV and IRR in a property investment

In generic finance, “NPV and IRR” are often discussed as a pair. On a rental flat the pair has a twist: most of the return does not arrive as monthly rent, but at sale (appreciation and debt pay-down). That is why 1.5% cash-on-cash can sit next to a 6.5% IRR if the price rises 2% a year.

Use both together:

  • IRR: to compare the flat’s annualised return with other options (funds, another property, paying down the mortgage).
  • NPV: to see, in euros, how much you gain or lose versus your discount rate. An NPV of +€9,452 at 5% means that, on those assumptions, the flat leaves you about €9,450 more (in today’s value) than investing the €65,000 at 5%.

Neither replaces cash flow: if the month-to-month does not clear, a neat 10-year IRR will not pay next month’s mortgage.

How do you calculate 10-year cash flows on a flat?

We start from the reference flat: price €150,000, buying costs €15,000, works €5,000 (total investment €170,000), €105,000 mortgage at 3% fixed over 25 years (€497.92/month), rent €850/month with one empty month, annual running costs €2,410. Equity: €65,000. In the central scenario, rent, costs and price rise 2% a year; on sale, 5% costs; outstanding debt after 10 years is €72,102.

YearRent collectedCostsMortgageCash flow
1€9,350€2,410€5,975€965
2€9,537€2,458€5,975€1,104
3€9,728€2,507€5,975€1,245
4€9,922€2,558€5,975€1,390
5€10,121€2,609€5,975€1,537
6€10,323€2,661€5,975€1,687
7€10,530€2,714€5,975€1,841
8€10,740€2,768€5,975€1,997
9€10,955€2,824€5,975€2,156
10€11,174€2,880€5,975€2,319 + €101,605 net sale = €103,924

Sale breakdown (year 10, +2%): price €182,849 × 0.95 = €173,707 after selling costs; minus €72,102 of debt = €101,605 net; plus €2,319 of operating cash flow = €103,924 in the final year.

IRR of a property investment by 0%, 2% and 4% appreciation: 2.2%, 6.5% and 10.3%; NPV at 5% of −€14,331, +€9,452 and +€37,427; 10-year operating cash flows at +2%
IRR and NPV of the reference flat by appreciation, and operating cash flows in the +2% scenario. Original Ladrillómetro chart.

Open this example in the calculator

The button loads price and rent. To match the same case, set occupancy 91.67%; IBI 400; community fees 960; insurance 550; maintenance 500; loan 105,000; deposit 45,000; payment 497.92; works 5,000; annual appreciation 2 and discount rate 5. You should see cash flow near +€965/year and the 10-year IRR/NPV.

How does IRR change if the flat appreciates 0%, 2% or 4%?

Same mortgage, same starting costs; only the annual growth of rent, costs and price changes:

Appreciation10-year IRRNPV at 5%Reading
0% a year2.2%−€14,331Below 5%: the project destroys value versus that alternative
2% a year6.5%+€9,452Central scenario for the reference flat
4% a year10.3%+€37,427Appreciation dominates the return

The gap between 0% and 2% is more than four IRR points: with no price rise the flat barely beats low inflation and loses to a 5% opportunity cost. That is why buy-to-let only “works” on paper if you assume reasonable appreciation… or accept a lower return in exchange for the rent.

Why is IRR higher than cash-on-cash?

Year-1 cash-on-cash is 965 ÷ 65,000 ≈ 1.5%. It only looks at money hitting your account that year. IRR also counts:

  • That the payment pays down principal (in 10 years debt falls from €105,000 to €72,102: about €32,898 the tenant helps you repay).
  • That on sale you recover the net after clearing what is left of the mortgage.
  • That, if the price rises, that gain enters the final cash flow.

So a 6.5% IRR does not contradict 1.5% cash-on-cash: they measure different things. Cash-on-cash tells you whether the month-to-month is comfortable; IRR, whether the full cycle is worth it.

Run your own numbers

Enter your flat’s price, rent, costs, mortgage, appreciation and discount rate and see its 10-year IRR and NPV. Free, no sign-up.

Open the rental yield calculator Calculate the mortgage payment

For information only; this is not financial or tax advice.

FREQUENT QUESTIONS

Frequently asked questions

What is a good IRR on property?

There is no official figure. Compare it with your opportunity cost and with the risk (voids, major works, regulation). In the example, 6.5% with 2% appreciation beats a 5% alternative; with no appreciation, IRR falls to 2.2% and NPV at 5% is negative.

Which discount rate should I use for NPV?

The return you would require from another investment of similar risk. 5% is a common long-term reference; if you are stricter, raise the rate and NPV falls. If IRR beats that rate, NPV comes out positive.

Does IRR include tax?

In this example, no: cash flows are before income tax on rent and before tax on the capital gain at sale. For an after-tax IRR, subtract estimated tax each year and, on sale, tax on the gain.

Why is IRR higher than cash-on-cash?

Because cash-on-cash only looks at that year’s cash flow (here 1.5%). IRR also counts the debt you pay down and the net sale. With 2% appreciation, that part dominates the 10-year return.

How do you calculate IRR on a mortgaged flat?

Year 0: −equity. Years 1 to N−1: rent collected − costs − mortgage payment. Year N: that cash flow plus sale price × (1 − selling costs) − outstanding debt. IRR is the rate that makes the present value of that series zero.

Can NPV and IRR compare two flats?

Yes, if you use the same horizon, the same discount rate and coherent assumptions on voids, costs and appreciation. NPV ranks in euros; IRR in annualised return. Also check monthly cash flow: a high NPV does not pay a mortgage you cannot afford.

More guides