Property purchase calculator

Estimate purchase costs, mortgage payments, rental yield, and returns for Andorra, Spain, or custom rates, with or without a mortgage.

Country
Purchase intent
Buyer status
Residents with ≥3 years of Andorran residency pay standard 4% ITP. The IIEI foreign investment tax does not apply.
Property & purchase costs
Expected annual growth in property value
Taxes
Mortgage
Use mortgage calculation
€100'000
Applied to the loan amount (price minus down payment).
Results summaryPrice: €400'000 · Loan: €300'000 · 25 yrs
Gross return
0.00%
Gross yearly income over cash outlay.
Net return, cash buyer
-1.45%
Net yearly income over cash outlay.
Net return, mortgaged
-18.38%
Net yearly income over mortgaged outlay.
Total outlay, cash buyer
€428'500
Full price + purchase costs
Monthly cashflow, cash buyer
-517/mo
Year 1 net monthly cashflow
Total outlay, mortgaged
€131'800
Down payment + purchase costs + mortgage fees
Monthly cashflow, mortgaged
€-2'019/mo
Year 1 net monthly cashflow
Tax & fees
€28'500
ITP 4% + €3'300 mortgage fees on mortgaged purchase
Est. property value at end
€837'511
3%/yr property appreciation
Monthly mortgage payment
€1'502
Principal + interest (yr 1)
Total interest paid
€150'561
Over 25 years
Monthly cashflow, year 1

Cash buyer

Gross rent (occupancy adj.)+€0/mo
After income tax & mgmt€0/mo
Running costs€517/mo
Net monthly cashflow-517/mo

With mortgage

Gross rent (occupancy adj.)+€0/mo
After income tax & mgmt€0/mo
Running costs€517/mo
Mortgage payment€1'502/mo
Net monthly cashflow-2'019/mo
Monthly mortgage, principal vs interest
Rental yield & returns
Gross yield (yr 1)
0.00%
No rental income modelled
Net yield, cash buyer (yr 1)
-1.45%
Annual NCF / cash outlay
Net yield, mortgaged (yr 1)
-18.38%
Annual NCF / cash outlay
Annual gross income (yr 1)
€0
No rental income modelled
Annual net income (yr 1)
€0
No rental income modelled
Annual cashflow, cash buyer (yr 1)
-6'200
Income grows 0%/yr thereafter
Annual cashflow, mortgaged (yr 1)
€-24'222
Income grows 0%/yr thereafter
Total return, cash buyer
€254'011
Over 25 yrs, income +0%/yr, sold at end
Total return, mortgaged
€100'150
Over 25 yrs, income +0%/yr, sold at end
Full amortization schedule
Annual summary
YrRatePayment/moPrincipalInterestBalance
13.50%€1'502€7'644€10'378€292'356
23.50%€1'502€7'916€10'106€284'440
33.50%€1'502€8'198€9'825€276'242
43.50%€1'502€8'489€9'533€267'752
53.50%€1'502€8'791€9'231€258'961
63.50%€1'502€9'104€8'919€249'857
73.50%€1'502€9'428€8'595€240'430
83.50%€1'502€9'763€8'259€230'667
93.50%€1'502€10'110€7'912€220'556
103.50%€1'502€10'470€7'553€210'086
113.50%€1'502€10'842€7'180€199'244
123.50%€1'502€11'228€6'795€188'016
133.50%€1'502€11'627€6'395€176'389
143.50%€1'502€12'041€5'982€164'348
153.50%€1'502€12'469€5'553€151'879
163.50%€1'502€12'913€5'110€138'967
173.50%€1'502€13'372€4'651€125'595
183.50%€1'502€13'847€4'175€111'748
193.50%€1'502€14'340€3'683€97'408
203.50%€1'502€14'850€3'173€82'558
213.50%€1'502€15'378€2'644€67'180
223.50%€1'502€15'925€2'097€51'255
233.50%€1'502€16'491€1'531€34'763
243.50%€1'502€17'078€944€17'685
253.50%€1'502€17'685€337€0

For indicative purposes only. Monthly cashflow shows year-1 figures. Total returns apply annual rent growth as a geometric series. All rates and conditions must be verified with a licensed local solicitor or tax advisor.