Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Private villa with garden, Eixample
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
-1083
10-yr return
87%
Net cashflow / mo
-1083
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
916200 EUR
Down payment (30%)
274860 EUR
Acquisition fees (10.0%)
91620 EUR
Mortgage principal
641340 EUR
Total cash-in at close
366480 EUR
🏦 Financing
Loan amount
641340 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3350 EUR
Annual debt service
40199 EUR
📊 Year-1 operating P&L
Gross rent
+43061
Operating costs (22%)
−9474
Net operating income (NOI)
33588
− Debt service
−40199
− Income tax (19%)
−6382
Net cashflow
-12993 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 43061 | 9474 | -12993 | 943686 | 317807 |
| Y2 | 44353 | 9758 | -12177 | 971997 | 362193 |
| Y3 | 45684 | 10050 | -11336 | 1001156 | 408066 |
| Y4 | 47054 | 10352 | -10470 | 1031191 | 455478 |
| Y5 | 48466 | 10663 | -9578 | 1062127 | 504480 |
| Y6 | 49920 | 10982 | -8660 | 1093991 | 555128 |
| Y7 | 51418 | 11312 | -7713 | 1126810 | 607478 |
| Y8 | 52960 | 11651 | -6739 | 1160615 | 661588 |
| Y9 | 54549 | 12001 | -5735 | 1195433 | 717518 |
| Y10 | 56185 | 12361 | -4701 | 1231296 | 775331 |
| Σ 10y | Cumulative net cashflow | -90102 | Equity at exit | 775331 | |
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.