Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Bright pied-à-terre in Malasaña
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
3.9%
Cashflow / mo
-1057
10-yr return
92%
Net cashflow / mo
-1057
EUR · after debt service & taxes
Cap rate
3.9%
NOI ÷ asking price
Cash-on-cash
-3.1%
Year-1 cashflow ÷ cash-in
10-yr total return
92%
6.8% annualised
💼 Acquisition
Asking price
1032100 EUR
Down payment (30%)
309630 EUR
Acquisition fees (10.0%)
103210 EUR
Mortgage principal
722470 EUR
Total cash-in at close
412840 EUR
🏦 Financing
Loan amount
722470 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3774 EUR
Annual debt service
45284 EUR
📊 Year-1 operating P&L
Gross rent
+51605
Operating costs (22%)
−11353
Net operating income (NOI)
40252
− Debt service
−45284
− Income tax (19%)
−7648
Net cashflow
-12680 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 51605 | 11353 | -12680 | 1063063 | 358010 |
| Y2 | 53153 | 11694 | -11702 | 1094955 | 408010 |
| Y3 | 54748 | 12045 | -10695 | 1127804 | 459687 |
| Y4 | 56390 | 12406 | -9657 | 1161638 | 513096 |
| Y5 | 58082 | 12778 | -8588 | 1196487 | 568297 |
| Y6 | 59824 | 13161 | -7487 | 1232381 | 625352 |
| Y7 | 61619 | 13556 | -6353 | 1269353 | 684324 |
| Y8 | 63468 | 13963 | -5185 | 1307433 | 745279 |
| Y9 | 65372 | 14382 | -3982 | 1346656 | 808284 |
| Y10 | 67333 | 14813 | -2743 | 1387056 | 873411 |
| Σ 10y | Cumulative net cashflow | -79073 | Equity at exit | 873411 | |
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.