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.
| Year | Rent collected | Costs | Mortgage | Cash 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.

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:
| Appreciation | 10-year IRR | NPV at 5% | Reading |
|---|---|---|---|
| 0% a year | 2.2% | −€14,331 | Below 5%: the project destroys value versus that alternative |
| 2% a year | 6.5% | +€9,452 | Central scenario for the reference flat |
| 4% a year | 10.3% | +€37,427 | Appreciation 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.