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.
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
Gross
One year of rent (monthly rent times twelve) divided by the price of the home. This is the figure listings quote.
Net
Vacant months are taken off the rent, and property tax, community fees, insurance and other costs off the result. That is divided by the price plus buying costs. It is before tax: income tax on the rent depends on your situation.
Cash flow
What is left each month of the net after paying the mortgage. If it is negative, you put in money every month.
On your own capital
A year of cash flow divided by the money you put in: the down payment plus buying costs.
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.