Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Renovated 3-bedroom flat overlooking Born · Ref 2741
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
-822
10-yr return
87%
Net cashflow / mo
-822
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
695600 EUR
Down payment (30%)
208680 EUR
Acquisition fees (10.0%)
69560 EUR
Mortgage principal
486920 EUR
Total cash-in at close
278240 EUR
🏦 Financing
Loan amount
486920 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2543 EUR
Annual debt service
30520 EUR
📊 Year-1 operating P&L
Gross rent
+32693
Operating costs (22%)
−7193
Net operating income (NOI)
25501
− Debt service
−30520
− Income tax (19%)
−4845
Net cashflow
-9864 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 32693 | 7193 | -9864 | 716468 | 241286 |
| Y2 | 33674 | 7408 | -9245 | 737962 | 274985 |
| Y3 | 34684 | 7631 | -8607 | 760101 | 309813 |
| Y4 | 35725 | 7859 | -7949 | 782904 | 345809 |
| Y5 | 36796 | 8095 | -7272 | 806391 | 383013 |
| Y6 | 37900 | 8338 | -6575 | 830583 | 421466 |
| Y7 | 39037 | 8588 | -5856 | 855500 | 461211 |
| Y8 | 40209 | 8846 | -5116 | 881165 | 502293 |
| Y9 | 41415 | 9111 | -4354 | 907600 | 544756 |
| Y10 | 42657 | 9385 | -3569 | 934828 | 588649 |
| Σ 10y | Cumulative net cashflow | -68407 | Equity at exit | 588649 | |
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.