Spain Life & Houses

10-year investment simulator

5-bedroom villa in Pilar de la Horadada

Pilar de la Horadada, Alicante Ref. SPA3314

Asking price €475,000
  • 5 bedrooms
  • 3 bathrooms
  • 168 m² built
  • 1,210 m² plot

Your agent: Anna Parfenova

Photo of 5-bedroom villa in Pilar de la Horadada
Scenario
Buyer profile
Use

Net result if sold in year 10

+€95,322

After all costs, taxes and the mortgage

Annual return (IRR)

2.8%

On your own money

Cash needed at purchase

€240,823

€381,919 incl. yearly shortfalls

Average net cash flow per year

−€14,110

After mortgage payments and tax

Gross yield 5.7%Net yield 1.0%

Good to know

Assumptions

Move any slider. The figures update straight away.

Purchase & financing
€475,000
40%

€190,000 of own money

3.90%
25 years
Rental income
€1,800 / week
95%
€1,210 / week
60%
€670 / week
25%
3 weeks
12.0%

of gross holiday income

VAT on short stays (10%, in force since 8 Oct 2026, pending ratification) On
Running costs
24.2%

of rental income after VAT

€1,211 / year
€450 / year
€843 / year
€0 / year
€1,513 / year
€6,000 / year
0.50%

of the property value, each year

€600 / year
Growth
5.00%

per year

2.50%

per year

2.50%

per year

Exit & tax
10 years
6.05%

of the sale price, incl. VAT

€2,400

Value, equity and mortgage

Projection at the end of each year

  • Property value
  • Equity
  • Mortgage balance
Line chart of property value, equity and mortgage balance over 10 years. €0€200k€400k€600k€800kNow12345678910

Equity = property value minus mortgage, before sale costs and taxes.

Year by year

Swipe sideways to see all columns

YearNet cash flowValueMortgage balanceEquityGross rental incomeMgmt & opsMortgage paymentsTax & VATNet cash flow
1−€14,267€498,750€278,129€220,621€29,909−€22,618−€17,864−€3,694−€14,267
2−€14,234€523,688€270,986€252,702€30,657−€23,184−€17,864−€3,843−€14,234
3−€14,200€549,872€263,559€286,313€31,423−€23,763−€17,864−€3,996−€14,200
4−€14,165€577,365€255,837€321,529€32,209−€24,357−€17,864−€4,152−€14,165
5−€14,130€606,234€247,808€358,426€33,014−€24,966−€17,864−€4,313−€14,130
6−€14,094€636,545€239,461€397,085€33,839−€25,591−€17,864−€4,479−€14,094
7−€14,058€668,373€230,782€437,591€34,685−€26,230−€17,864−€4,649−€14,058
8−€14,021€701,791€221,759€480,033€35,552−€26,886−€17,864−€4,823−€14,021
9−€13,984€736,881€212,377€524,504€36,441−€27,558−€17,864−€5,003−€13,984
10−€13,946€773,725€202,623€571,102€37,352−€28,247−€17,864−€5,187−€13,946
Total−€141,097€335,082−€253,402−€178,637−€44,140−€141,097

Gross rental income − mgmt & ops − mortgage payments − tax = net cash flow. Tax includes VAT on short stays and income tax.

If you sell in year 10

Sale price
€773,725
Agency fee
−€46,810
Plusvalía
−€2,400
Capital gains tax
−€44,651
Mortgage repayment
−€202,623
Net proceeds
€477,241

For a non-resident seller, the buyer withholds 3% of the price (€23,212) and pays it to the tax office. You get it back, or it is set against your capital gains tax. It is a timing item, not a cost.

Purchase costs

Transfer tax (9.0%)
€42,750
Notary & land registry
€1,425
Lawyer (incl. VAT)
€5,748
Mortgage set-up (valuation, gestoría)
€900
Total purchase costs
€50,823
Down payment
€190,000
Mortgage amount
€285,000
Total cash needed
€240,823

Get the full report

Leave your details and the full report with your assumptions opens straight away. Spain Life & Houses may contact you about this property.

Include your country code, for example +44