Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Penthouse-style apartment, 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
-913
10-yr return
92%
Net cashflow / mo
-913
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
891600 EUR
Down payment (30%)
267480 EUR
Acquisition fees (10.0%)
89160 EUR
Mortgage principal
624120 EUR
Total cash-in at close
356640 EUR
🏦 Financing
Loan amount
624120 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3260 EUR
Annual debt service
39120 EUR
📊 Year-1 operating P&L
Gross rent
+44580
Operating costs (22%)
−9808
Net operating income (NOI)
34772
− Debt service
−39120
− Income tax (19%)
−6607
Net cashflow
-10954 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 44580 | 9808 | -10954 | 918348 | 309274 |
| Y2 | 45917 | 10102 | -10109 | 945898 | 352468 |
| Y3 | 47295 | 10405 | -9239 | 974275 | 397109 |
| Y4 | 48714 | 10717 | -8342 | 1003504 | 443248 |
| Y5 | 50175 | 11039 | -7419 | 1033609 | 490935 |
| Y6 | 51680 | 11370 | -6468 | 1064617 | 540223 |
| Y7 | 53231 | 11711 | -5488 | 1096556 | 591167 |
| Y8 | 54828 | 12062 | -4479 | 1129452 | 643824 |
| Y9 | 56473 | 12424 | -3440 | 1163336 | 698252 |
| Y10 | 58167 | 12797 | -2370 | 1198236 | 754513 |
| Σ 10y | Cumulative net cashflow | -68309 | Equity at exit | 754513 | |
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.