Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
4-bed apartment, El Cabanyal
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
5.0%
Cashflow / mo
-192
10-yr return
118%
Net cashflow / mo
-192
EUR · after debt service & taxes
Cap rate
5.0%
NOI ÷ asking price
Cash-on-cash
-0.9%
Year-1 cashflow ÷ cash-in
10-yr total return
118%
8.1% annualised
💼 Acquisition
Asking price
670600 EUR
Down payment (30%)
201180 EUR
Acquisition fees (10.0%)
67060 EUR
Mortgage principal
469420 EUR
Total cash-in at close
268240 EUR
🏦 Financing
Loan amount
469420 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2452 EUR
Annual debt service
29423 EUR
📊 Year-1 operating P&L
Gross rent
+42918
Operating costs (22%)
−9442
Net operating income (NOI)
33476
− Debt service
−29423
− Income tax (19%)
−6361
Net cashflow
-2307 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 42918 | 9442 | -2307 | 690718 | 232615 |
| Y2 | 44206 | 9725 | -1494 | 711440 | 265102 |
| Y3 | 45532 | 10017 | -656 | 732783 | 298678 |
| Y4 | 46898 | 10318 | 207 | 754766 | 333381 |
| Y5 | 48305 | 10627 | 1096 | 777409 | 369247 |
| Y6 | 49754 | 10946 | 2012 | 800731 | 406318 |
| Y7 | 51247 | 11274 | 2955 | 824753 | 444635 |
| Y8 | 52784 | 11613 | 3926 | 849496 | 484240 |
| Y9 | 54368 | 11961 | 4926 | 874981 | 525177 |
| Y10 | 55999 | 12320 | 5957 | 901230 | 567493 |
| Σ 10y | Cumulative net cashflow | 16622 | Equity at exit | 567493 | |
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.