Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in Pedregalejo
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
4.7%
Cashflow / mo
-95
10-yr return
111%
Net cashflow / mo
-95
EUR · after debt service & taxes
Cap rate
4.7%
NOI ÷ asking price
Cash-on-cash
-1.5%
Year-1 cashflow ÷ cash-in
10-yr total return
111%
7.7% annualised
💼 Acquisition
Asking price
191300 EUR
Down payment (30%)
57390 EUR
Acquisition fees (10.0%)
19130 EUR
Mortgage principal
133910 EUR
Total cash-in at close
76520 EUR
🏦 Financing
Loan amount
133910 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
699 EUR
Annual debt service
8393 EUR
📊 Year-1 operating P&L
Gross rent
+11478
Operating costs (22%)
−2525
Net operating income (NOI)
8953
− Debt service
−8393
− Income tax (19%)
−1701
Net cashflow
-1142 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 11478 | 2525 | -1142 | 197039 | 66357 |
| Y2 | 11822 | 2601 | -924 | 202950 | 75625 |
| Y3 | 12177 | 2679 | -700 | 209039 | 85203 |
| Y4 | 12542 | 2759 | -469 | 215310 | 95102 |
| Y5 | 12919 | 2842 | -231 | 221769 | 105334 |
| Y6 | 13306 | 2927 | 13 | 228422 | 115909 |
| Y7 | 13705 | 3015 | 266 | 235275 | 126840 |
| Y8 | 14116 | 3106 | 525 | 242333 | 138138 |
| Y9 | 14540 | 3199 | 793 | 249603 | 149816 |
| Y10 | 14976 | 3295 | 1069 | 257091 | 161887 |
| Σ 10y | Cumulative net cashflow | -801 | Equity at exit | 161887 | |
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.