Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
1-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
-92
10-yr return
118%
Net cashflow / mo
-92
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
321600 EUR
Down payment (30%)
96480 EUR
Acquisition fees (10.0%)
32160 EUR
Mortgage principal
225120 EUR
Total cash-in at close
128640 EUR
🏦 Financing
Loan amount
225120 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1176 EUR
Annual debt service
14110 EUR
📊 Year-1 operating P&L
Gross rent
+20582
Operating costs (22%)
−4528
Net operating income (NOI)
16054
− Debt service
−14110
− Income tax (19%)
−3050
Net cashflow
-1107 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 20582 | 4528 | -1107 | 331248 | 111555 |
| Y2 | 21200 | 4664 | -716 | 341185 | 127135 |
| Y3 | 21836 | 4804 | -315 | 351421 | 143237 |
| Y4 | 22491 | 4948 | 99 | 361964 | 159880 |
| Y5 | 23166 | 5096 | 526 | 372823 | 177080 |
| Y6 | 23861 | 5249 | 965 | 384007 | 194858 |
| Y7 | 24576 | 5407 | 1417 | 395527 | 213234 |
| Y8 | 25314 | 5569 | 1883 | 407393 | 232227 |
| Y9 | 26073 | 5736 | 2363 | 419615 | 251860 |
| Y10 | 26855 | 5908 | 2857 | 432204 | 272153 |
| Σ 10y | Cumulative net cashflow | 7971 | Equity at exit | 272153 | |
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.