Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in Ciutat Vella
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
-46
10-yr return
118%
Net cashflow / mo
-46
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
158900 EUR
Down payment (30%)
47670 EUR
Acquisition fees (10.0%)
15890 EUR
Mortgage principal
111230 EUR
Total cash-in at close
63560 EUR
🏦 Financing
Loan amount
111230 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
581 EUR
Annual debt service
6972 EUR
📊 Year-1 operating P&L
Gross rent
+10170
Operating costs (22%)
−2237
Net operating income (NOI)
7932
− Debt service
−6972
− Income tax (19%)
−1507
Net cashflow
-547 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 10170 | 2237 | -547 | 163667 | 55118 |
| Y2 | 10475 | 2304 | -354 | 168577 | 62816 |
| Y3 | 10789 | 2374 | -155 | 173634 | 70772 |
| Y4 | 11113 | 2445 | 49 | 178843 | 78995 |
| Y5 | 11446 | 2518 | 260 | 184209 | 87494 |
| Y6 | 11789 | 2594 | 477 | 189735 | 96278 |
| Y7 | 12143 | 2671 | 700 | 195427 | 105357 |
| Y8 | 12507 | 2752 | 930 | 201290 | 114742 |
| Y9 | 12883 | 2834 | 1167 | 207328 | 124442 |
| Y10 | 13269 | 2919 | 1412 | 213548 | 134469 |
| Σ 10y | Cumulative net cashflow | 3939 | Equity at exit | 134469 | |
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.