Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in Ciutat Vella · Ref 4594
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
-128
10-yr return
118%
Net cashflow / mo
-128
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
446700 EUR
Down payment (30%)
134010 EUR
Acquisition fees (10.0%)
44670 EUR
Mortgage principal
312690 EUR
Total cash-in at close
178680 EUR
🏦 Financing
Loan amount
312690 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1633 EUR
Annual debt service
19599 EUR
📊 Year-1 operating P&L
Gross rent
+28589
Operating costs (22%)
−6290
Net operating income (NOI)
22299
− Debt service
−19599
− Income tax (19%)
−4237
Net cashflow
-1537 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 28589 | 6290 | -1537 | 460101 | 154949 |
| Y2 | 29446 | 6478 | -995 | 473904 | 176590 |
| Y3 | 30330 | 6673 | -437 | 488121 | 198956 |
| Y4 | 31240 | 6873 | 138 | 502765 | 222071 |
| Y5 | 32177 | 7079 | 730 | 517848 | 245963 |
| Y6 | 33142 | 7291 | 1340 | 533383 | 270657 |
| Y7 | 34137 | 7510 | 1968 | 549385 | 296180 |
| Y8 | 35161 | 7735 | 2615 | 565866 | 322562 |
| Y9 | 36215 | 7967 | 3282 | 582842 | 349831 |
| Y10 | 37302 | 8206 | 3968 | 600327 | 378018 |
| Σ 10y | Cumulative net cashflow | 11072 | Equity at exit | 378018 | |
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.