Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Private villa with garden, Confluence · Ref 4678
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.6%
Cashflow / mo
-2056
10-yr return
50%
Net cashflow / mo
-2056
EUR · after debt service & taxes
Cap rate
3.6%
NOI ÷ asking price
Cash-on-cash
-4.8%
Year-1 cashflow ÷ cash-in
10-yr total return
50%
4.2% annualised
💼 Acquisition
Asking price
1379100 EUR
Down payment (30%)
413730 EUR
Acquisition fees (7.5%)
103433 EUR
Mortgage principal
965370 EUR
Total cash-in at close
517163 EUR
🏦 Financing
Loan amount
965370 EUR
Mortgage rate
4.10%
Term
25 years
Monthly payment
5149 EUR
Annual debt service
61788 EUR
📊 Year-1 operating P&L
Gross rent
+63439
Operating costs (22%)
−13956
Net operating income (NOI)
49482
− Debt service
−61788
− Income tax (25%)
−12371
Net cashflow
-24677 EUR
📈 10-year projection
2.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 63439 | 13956 | -24677 | 1406682 | 463942 |
| Y2 | 64707 | 14236 | -23935 | 1434816 | 515652 |
| Y3 | 66002 | 14520 | -23178 | 1463512 | 568909 |
| Y4 | 67322 | 14811 | -22405 | 1492782 | 623766 |
| Y5 | 68668 | 15107 | -21618 | 1522638 | 680278 |
| Y6 | 70041 | 15409 | -20814 | 1553091 | 738500 |
| Y7 | 71442 | 15717 | -19995 | 1584152 | 798492 |
| Y8 | 72871 | 16032 | -19159 | 1615835 | 860313 |
| Y9 | 74328 | 16352 | -18306 | 1648152 | 924028 |
| Y10 | 75815 | 16679 | -17437 | 1681115 | 989700 |
| Σ 10y | Cumulative net cashflow | -211522 | Equity at exit | 989700 | |
Modelling assumptions
- Country baseline: FR — operating costs 22% of gross rent, income tax 25%, capital appreciation 2.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.