Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Family villa with pool, Soho
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
-293
10-yr return
111%
Net cashflow / mo
-293
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
588700 EUR
Down payment (30%)
176610 EUR
Acquisition fees (10.0%)
58870 EUR
Mortgage principal
412090 EUR
Total cash-in at close
235480 EUR
🏦 Financing
Loan amount
412090 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2152 EUR
Annual debt service
25830 EUR
📊 Year-1 operating P&L
Gross rent
+35322
Operating costs (22%)
−7771
Net operating income (NOI)
27551
− Debt service
−25830
− Income tax (19%)
−5235
Net cashflow
-3513 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 35322 | 7771 | -3513 | 606361 | 204206 |
| Y2 | 36382 | 8004 | -2844 | 624552 | 232725 |
| Y3 | 37473 | 8244 | -2154 | 643288 | 262201 |
| Y4 | 38597 | 8491 | -1444 | 662587 | 292665 |
| Y5 | 39755 | 8746 | -712 | 682465 | 324151 |
| Y6 | 40948 | 9009 | 41 | 702939 | 356695 |
| Y7 | 42176 | 9279 | 817 | 724027 | 390332 |
| Y8 | 43442 | 9557 | 1617 | 745748 | 425100 |
| Y9 | 44745 | 9844 | 2440 | 768120 | 461038 |
| Y10 | 46087 | 10139 | 3288 | 791164 | 498185 |
| Σ 10y | Cumulative net cashflow | -2464 | Equity at exit | 498185 | |
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.