Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Private villa with garden, Soho · Ref 7731
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
-319
10-yr return
111%
Net cashflow / mo
-319
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
640700 EUR
Down payment (30%)
192210 EUR
Acquisition fees (10.0%)
64070 EUR
Mortgage principal
448490 EUR
Total cash-in at close
256280 EUR
🏦 Financing
Loan amount
448490 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2343 EUR
Annual debt service
28111 EUR
📊 Year-1 operating P&L
Gross rent
+38442
Operating costs (22%)
−8457
Net operating income (NOI)
29985
− Debt service
−28111
− Income tax (19%)
−5697
Net cashflow
-3824 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 38442 | 8457 | -3824 | 659921 | 222243 |
| Y2 | 39595 | 8711 | -3095 | 679719 | 253282 |
| Y3 | 40783 | 8972 | -2344 | 700110 | 285361 |
| Y4 | 42007 | 9241 | -1571 | 721113 | 318516 |
| Y5 | 43267 | 9519 | -775 | 742747 | 352784 |
| Y6 | 44565 | 9804 | 45 | 765029 | 388202 |
| Y7 | 45902 | 10098 | 890 | 787980 | 424810 |
| Y8 | 47279 | 10401 | 1760 | 811620 | 462649 |
| Y9 | 48697 | 10713 | 2656 | 835968 | 501761 |
| Y10 | 50158 | 11035 | 3579 | 861047 | 542190 |
| Σ 10y | Cumulative net cashflow | -2682 | Equity at exit | 542190 | |
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.