Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Family villa with pool, Chamberí
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
-425
10-yr return
92%
Net cashflow / mo
-425
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
414800 EUR
Down payment (30%)
124440 EUR
Acquisition fees (10.0%)
41480 EUR
Mortgage principal
290360 EUR
Total cash-in at close
165920 EUR
🏦 Financing
Loan amount
290360 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1517 EUR
Annual debt service
18200 EUR
📊 Year-1 operating P&L
Gross rent
+20740
Operating costs (22%)
−4563
Net operating income (NOI)
16177
− Debt service
−18200
− Income tax (19%)
−3074
Net cashflow
-5096 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 20740 | 4563 | -5096 | 427244 | 143884 |
| Y2 | 21362 | 4700 | -4703 | 440061 | 163979 |
| Y3 | 22003 | 4841 | -4298 | 453263 | 184748 |
| Y4 | 22663 | 4986 | -3881 | 466861 | 206213 |
| Y5 | 23343 | 5135 | -3452 | 480867 | 228398 |
| Y6 | 24043 | 5290 | -3009 | 495293 | 251329 |
| Y7 | 24765 | 5448 | -2553 | 510152 | 275029 |
| Y8 | 25508 | 5612 | -2084 | 525456 | 299527 |
| Y9 | 26273 | 5780 | -1601 | 541220 | 324849 |
| Y10 | 27061 | 5953 | -1103 | 557457 | 351023 |
| Σ 10y | Cumulative net cashflow | -31780 | Equity at exit | 351023 | |
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.