Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Boutique residence in 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
-1295
10-yr return
92%
Net cashflow / mo
-1295
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
1265000 EUR
Down payment (30%)
379500 EUR
Acquisition fees (10.0%)
126500 EUR
Mortgage principal
885500 EUR
Total cash-in at close
506000 EUR
🏦 Financing
Loan amount
885500 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
4625 EUR
Annual debt service
55503 EUR
📊 Year-1 operating P&L
Gross rent
+63250
Operating costs (22%)
−13915
Net operating income (NOI)
49335
− Debt service
−55503
− Income tax (19%)
−9374
Net cashflow
-15542 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 63250 | 13915 | -15542 | 1302950 | 438797 |
| Y2 | 65148 | 14332 | -14343 | 1342039 | 500081 |
| Y3 | 67102 | 14762 | -13108 | 1382300 | 563418 |
| Y4 | 69115 | 15205 | -11836 | 1423769 | 628879 |
| Y5 | 71188 | 15661 | -10526 | 1466482 | 696537 |
| Y6 | 73324 | 16131 | -9177 | 1510476 | 766467 |
| Y7 | 75524 | 16615 | -7787 | 1555790 | 838747 |
| Y8 | 77790 | 17114 | -6355 | 1602464 | 913456 |
| Y9 | 80123 | 17627 | -4881 | 1650538 | 990679 |
| Y10 | 82527 | 18156 | -3362 | 1700054 | 1070501 |
| Σ 10y | Cumulative net cashflow | -96917 | Equity at exit | 1070501 | |
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.