Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Private villa with garden, Gràcia
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.7%
Cashflow / mo
-1143
10-yr return
87%
Net cashflow / mo
-1143
EUR · after debt service & taxes
Cap rate
3.7%
NOI ÷ asking price
Cash-on-cash
-3.6%
Year-1 cashflow ÷ cash-in
10-yr total return
87%
6.5% annualised
💼 Acquisition
Asking price
966800 EUR
Down payment (30%)
290040 EUR
Acquisition fees (10.0%)
96680 EUR
Mortgage principal
676760 EUR
Total cash-in at close
386720 EUR
🏦 Financing
Loan amount
676760 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3535 EUR
Annual debt service
42419 EUR
📊 Year-1 operating P&L
Gross rent
+45440
Operating costs (22%)
−9997
Net operating income (NOI)
35443
− Debt service
−42419
− Income tax (19%)
−6734
Net cashflow
-13710 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 45440 | 9997 | -13710 | 995804 | 335359 |
| Y2 | 46803 | 10297 | -12849 | 1025678 | 382196 |
| Y3 | 48207 | 10606 | -11962 | 1056448 | 430603 |
| Y4 | 49653 | 10924 | -11048 | 1088142 | 480633 |
| Y5 | 51143 | 11251 | -10107 | 1120786 | 532342 |
| Y6 | 52677 | 11589 | -9138 | 1154410 | 585787 |
| Y7 | 54257 | 11937 | -8139 | 1189042 | 641028 |
| Y8 | 55885 | 12295 | -7111 | 1224713 | 698126 |
| Y9 | 57562 | 12664 | -6052 | 1261455 | 757145 |
| Y10 | 59288 | 13043 | -4961 | 1299298 | 818151 |
| Σ 10y | Cumulative net cashflow | -95078 | Equity at exit | 818151 | |
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.