Asoleo
Asoleo
Find my flat

€19 · in two minutes · card or Bizum, no account

Mortgage and rental yield calculator

The payment, the interest, and how much of every hundred euros you pay the bank goes to interest. And if you buy to let, the gross and net yield, with property tax, community fees, insurance and vacant months, before tax.

Example values: replace them with your own.

You can type 250000, 250,000 or 250k.

That is 20% of the price.

The nominal rate in the bank's offer (TIN).

Adds yield and cash flow.

If you rent it out

8.3% is one month a year.

Taxes, notary and registry. Leave it at 0 not to count them.

Work them out with the buying costs tool

Monthly payment

€843.21a month

360 payments (30 years)

  • Capital: €200,000
  • Interest: €103,555

Of every €100 you pay the bank, €34 is interest.

Amount borrowed
€200,000
Of which, interest
€103,555
Total you will pay
€303,555

If you rent it out

4.8%

Gross yield

One year of rent divided by the price.

4.07%

Net yield

What is left in a year, after costs and vacant months, divided by the price plus buying costs. Before income tax.

€5

Cash flow per month

What you have left each month from the rent collected (after vacant time) once you pay property tax, community fees, insurance and the mortgage payment.

0.12%

On your own capital

Yearly cash flow divided by the money you put in (€50,000). It does not count the part of the payment that repays principal, which is your own saving.

Where it comes from

One year of rent
€12,000
− Vacant months (5%)
€600
− Property tax, community fees and insurance
€1,220
= Net per year
€10,180
− Mortgage payments per year
€10,118

It does not include income tax on the rent, appreciation or works. The example values are not market data.

How the payment is calculated

We use the French system, the usual one for mortgages in Spain: a fixed payment each month in which, at first, you mostly pay interest and, at the end, mostly capital.

The formula is payment = C · i / (1 − (1 + i)^−n), where C is the capital, i the monthly interest (the annual rate divided by 12) and n the number of payments. With no interest, the payment is the capital divided by the number of payments.

It is the payment of a fixed-rate mortgage. On a variable or mixed mortgage the payment changes when the index (Euribor) changes; we do not forecast that. Fees, tied insurance and bank discounts are not included either.

How the yield is calculated

An example

A flat of €250,000 with €50,000 down, at 3% over 30 years, has a payment of €843.21 a month and €103,555 of interest in total. Let at €1,000 a month, with 5% vacant, property tax of €350, community fees of €60 a month and insurance of €150, it gives 4.8% gross and 4.07% net, before purchase costs. These are example numbers, not market data.

Frequently asked questions

Which interest rate do I enter?

The one the bank offers you: the nominal rate (TIN), not the APR. The APR includes fees and the cost of the products the bank requires to grant you the loan, and would make the payment higher than it is.

What is the difference between gross and net yield?

Gross is one year of rent divided by the price. Net takes off vacant months and costs (property tax, community fees, insurance) and counts the buying costs as part of what you paid. Net is closer to what you earn, before tax.

What is cash flow?

What is left of the rent each month after paying the costs and the mortgage payment. If it is negative, you are paying the difference every month.

Does it work for variable mortgages?

For a variable or mixed one it gives the payment at the rate you enter, which is today's. It does not forecast Euribor going up or down.

Before you pay a deposit, look at what the viewing doesn't show you

The direct sun that reaches each window, the noise on the façade, whether the flat floods, the planning rules and the building's data. Measured figures, with their source and date.