Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Architect-designed villa in Ruzafa
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
-111
10-yr return
118%
Net cashflow / mo
-111
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
387200 EUR
Down payment (30%)
116160 EUR
Acquisition fees (10.0%)
38720 EUR
Mortgage principal
271040 EUR
Total cash-in at close
154880 EUR
🏦 Financing
Loan amount
271040 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1416 EUR
Annual debt service
16989 EUR
📊 Year-1 operating P&L
Gross rent
+24781
Operating costs (22%)
−5452
Net operating income (NOI)
19329
− Debt service
−16989
− Income tax (19%)
−3673
Net cashflow
-1332 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 24781 | 5452 | -1332 | 398816 | 134310 |
| Y2 | 25524 | 5615 | -863 | 410780 | 153068 |
| Y3 | 26290 | 5784 | -379 | 423104 | 172455 |
| Y4 | 27079 | 5957 | 120 | 435797 | 192492 |
| Y5 | 27891 | 6136 | 633 | 448871 | 213201 |
| Y6 | 28728 | 6320 | 1161 | 462337 | 234606 |
| Y7 | 29590 | 6510 | 1706 | 476207 | 256729 |
| Y8 | 30477 | 6705 | 2267 | 490493 | 279597 |
| Y9 | 31392 | 6906 | 2844 | 505208 | 303234 |
| Y10 | 32333 | 7113 | 3439 | 520364 | 327667 |
| Σ 10y | Cumulative net cashflow | 9597 | Equity at exit | 327667 | |
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.