Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Flagship street-level retail, 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
-1094
10-yr return
92%
Net cashflow / mo
-1094
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
1068100 EUR
Down payment (30%)
320430 EUR
Acquisition fees (10.0%)
106810 EUR
Mortgage principal
747670 EUR
Total cash-in at close
427240 EUR
🏦 Financing
Loan amount
747670 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3905 EUR
Annual debt service
46864 EUR
📊 Year-1 operating P&L
Gross rent
+53405
Operating costs (22%)
−11749
Net operating income (NOI)
41656
− Debt service
−46864
− Income tax (19%)
−7915
Net cashflow
-13122 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 53405 | 11749 | -13122 | 1100143 | 370498 |
| Y2 | 55007 | 12102 | -12110 | 1133147 | 422242 |
| Y3 | 56657 | 12465 | -11068 | 1167142 | 475721 |
| Y4 | 58357 | 12839 | -9994 | 1202156 | 530993 |
| Y5 | 60108 | 13224 | -8888 | 1238221 | 588120 |
| Y6 | 61911 | 13620 | -7748 | 1275367 | 647165 |
| Y7 | 63768 | 14029 | -6575 | 1313628 | 708194 |
| Y8 | 65681 | 14450 | -5366 | 1353037 | 771275 |
| Y9 | 67652 | 14883 | -4121 | 1393628 | 836478 |
| Y10 | 69681 | 15330 | -2839 | 1435437 | 903876 |
| Σ 10y | Cumulative net cashflow | -81831 | Equity at exit | 903876 | |
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.