Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in El Cabanyal
Tweak any input — down payment, mortgage rate, hold horizon — and the projection refreshes instantly. Country-specific tax and fee schedules are baked in; the formula is documented on the methodology page.
Cap rate
5.0%
Cashflow / mo
-74
10-yr return
118%
Net cashflow / mo
-74
EUR · after debt service & taxes
Cap rate
5.0%
NOI ÷ asking price
Cash-on-cash
-0.9%
Year-1 cashflow ÷ cash-in
10-yr total return
118%
8.1% annualised
💼 Acquisition
Asking price
257600 EUR
Down payment (30%)
77280 EUR
Acquisition fees (10.0%)
25760 EUR
Mortgage principal
180320 EUR
Total cash-in at close
103040 EUR
🏦 Financing
Loan amount
180320 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
942 EUR
Annual debt service
11302 EUR
📊 Year-1 operating P&L
Gross rent
+16486
Operating costs (22%)
−3627
Net operating income (NOI)
12859
− Debt service
−11302
− Income tax (19%)
−2443
Net cashflow
-886 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 16486 | 3627 | -886 | 265328 | 89355 |
| Y2 | 16981 | 3736 | -574 | 273288 | 101835 |
| Y3 | 17490 | 3848 | -252 | 281486 | 114732 |
| Y4 | 18015 | 3963 | 80 | 289931 | 128063 |
| Y5 | 18556 | 4082 | 421 | 298629 | 141840 |
| Y6 | 19112 | 4205 | 773 | 307588 | 156081 |
| Y7 | 19686 | 4331 | 1135 | 316816 | 170799 |
| Y8 | 20276 | 4461 | 1508 | 326320 | 186013 |
| Y9 | 20884 | 4595 | 1892 | 336110 | 201738 |
| Y10 | 21511 | 4732 | 2288 | 346193 | 217993 |
| Σ 10y | Cumulative net cashflow | 6385 | Equity at exit | 217993 | |
Modelling assumptions
- Country baseline: ES — operating costs 22% of gross rent, income tax 19%, capital appreciation 3.0%/yr.
- Projections assume rent grows at the country appreciation rate. Real-world rent growth will diverge.
- Mortgage figures use a constant interest rate for the full term. Re-mortgage events are not modelled.
- Excludes capital-gains tax on exit, currency hedging costs and any local property tax over and above the operating buffer.