Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Family villa with pool, 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
-64
10-yr return
118%
Net cashflow / mo
-64
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
222500 EUR
Down payment (30%)
66750 EUR
Acquisition fees (10.0%)
22250 EUR
Mortgage principal
155750 EUR
Total cash-in at close
89000 EUR
🏦 Financing
Loan amount
155750 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
814 EUR
Annual debt service
9762 EUR
📊 Year-1 operating P&L
Gross rent
+14240
Operating costs (22%)
−3133
Net operating income (NOI)
11107
− Debt service
−9762
− Income tax (19%)
−2110
Net cashflow
-766 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 14240 | 3133 | -766 | 229175 | 77180 |
| Y2 | 14667 | 3227 | -496 | 236050 | 87959 |
| Y3 | 15107 | 3324 | -218 | 243132 | 99099 |
| Y4 | 15560 | 3423 | 69 | 250426 | 110613 |
| Y5 | 16027 | 3526 | 364 | 257938 | 122513 |
| Y6 | 16508 | 3632 | 667 | 265677 | 134813 |
| Y7 | 17003 | 3741 | 980 | 273647 | 147527 |
| Y8 | 17513 | 3853 | 1303 | 281856 | 160667 |
| Y9 | 18039 | 3969 | 1635 | 290312 | 174250 |
| Y10 | 18580 | 4088 | 1976 | 299021 | 188290 |
| Σ 10y | Cumulative net cashflow | 5515 | Equity at exit | 188290 | |
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.