Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in Salamanca
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
3.9%
Cashflow / mo
-978
10-yr return
92%
Net cashflow / mo
-978
EUR · after debt service & taxes
Cap rate
3.9%
NOI ÷ asking price
Cash-on-cash
-3.1%
Year-1 cashflow ÷ cash-in
10-yr total return
92%
6.8% annualised
💼 Acquisition
Asking price
954900 EUR
Down payment (30%)
286470 EUR
Acquisition fees (10.0%)
95490 EUR
Mortgage principal
668430 EUR
Total cash-in at close
381960 EUR
🏦 Financing
Loan amount
668430 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3491 EUR
Annual debt service
41897 EUR
📊 Year-1 operating P&L
Gross rent
+47745
Operating costs (22%)
−10504
Net operating income (NOI)
37241
− Debt service
−41897
− Income tax (19%)
−7076
Net cashflow
-11732 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 47745 | 10504 | -11732 | 983547 | 331231 |
| Y2 | 49177 | 10819 | -10827 | 1013053 | 377492 |
| Y3 | 50653 | 11144 | -9895 | 1043445 | 425303 |
| Y4 | 52172 | 11478 | -8935 | 1074748 | 474717 |
| Y5 | 53737 | 11822 | -7946 | 1106991 | 525789 |
| Y6 | 55350 | 12177 | -6927 | 1140201 | 578577 |
| Y7 | 57010 | 12542 | -5878 | 1174407 | 633138 |
| Y8 | 58720 | 12918 | -4798 | 1209639 | 689533 |
| Y9 | 60482 | 13306 | -3685 | 1245928 | 747826 |
| Y10 | 62296 | 13705 | -2538 | 1283306 | 808080 |
| Σ 10y | Cumulative net cashflow | -73159 | Equity at exit | 808080 | |
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.