Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Sea-facing villa in Centro Histórico
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
192000 EUR
Down payment (30%)
57600 EUR
Acquisition fees (10.0%)
19200 EUR
Mortgage principal
134400 EUR
Total cash-in at close
76800 EUR
🏦 Financing
Loan amount
134400 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
702 EUR
Annual debt service
8424 EUR
📊 Year-1 operating P&L
Gross rent
+11520
Operating costs (22%)
−2534
Net operating income (NOI)
8986
− Debt service
−8424
− Income tax (19%)
−1707
Net cashflow
-1146 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 11520 | 2534 | -1146 | 197760 | 66600 |
| Y2 | 11866 | 2610 | -927 | 203693 | 75902 |
| Y3 | 12222 | 2689 | -703 | 209804 | 85515 |
| Y4 | 12588 | 2769 | -471 | 216098 | 95450 |
| Y5 | 12966 | 2852 | -232 | 222581 | 105720 |
| Y6 | 13355 | 2938 | 13 | 229258 | 116333 |
| Y7 | 13755 | 3026 | 267 | 236136 | 127304 |
| Y8 | 14168 | 3117 | 527 | 243220 | 138643 |
| Y9 | 14593 | 3211 | 796 | 250516 | 150364 |
| Y10 | 15031 | 3307 | 1072 | 258032 | 162479 |
| Σ 10y | Cumulative net cashflow | -804 | Equity at exit | 162479 | |
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.