Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Family villa with pool, 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
-1118
10-yr return
87%
Net cashflow / mo
-1118
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
946200 EUR
Down payment (30%)
283860 EUR
Acquisition fees (10.0%)
94620 EUR
Mortgage principal
662340 EUR
Total cash-in at close
378480 EUR
🏦 Financing
Loan amount
662340 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3460 EUR
Annual debt service
41515 EUR
📊 Year-1 operating P&L
Gross rent
+44471
Operating costs (22%)
−9784
Net operating income (NOI)
34688
− Debt service
−41515
− Income tax (19%)
−6591
Net cashflow
-13418 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 44471 | 9784 | -13418 | 974586 | 328213 |
| Y2 | 45806 | 10077 | -12575 | 1003824 | 374052 |
| Y3 | 47180 | 10380 | -11707 | 1033938 | 421428 |
| Y4 | 48595 | 10691 | -10813 | 1064956 | 470392 |
| Y5 | 50053 | 11012 | -9892 | 1096905 | 520999 |
| Y6 | 51555 | 11342 | -8943 | 1129812 | 573305 |
| Y7 | 53101 | 11682 | -7966 | 1163707 | 627369 |
| Y8 | 54694 | 12033 | -6959 | 1198618 | 683251 |
| Y9 | 56335 | 12394 | -5923 | 1234576 | 741012 |
| Y10 | 58025 | 12766 | -4855 | 1271614 | 800718 |
| Σ 10y | Cumulative net cashflow | -93052 | Equity at exit | 800718 | |
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.