Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Renovated 3-bedroom flat overlooking Centro Histórico
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
-574
10-yr return
111%
Net cashflow / mo
-574
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
1154900 EUR
Down payment (30%)
346470 EUR
Acquisition fees (10.0%)
115490 EUR
Mortgage principal
808430 EUR
Total cash-in at close
461960 EUR
🏦 Financing
Loan amount
808430 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
4223 EUR
Annual debt service
50672 EUR
📊 Year-1 operating P&L
Gross rent
+69294
Operating costs (22%)
−15245
Net operating income (NOI)
54049
− Debt service
−50672
− Income tax (19%)
−10269
Net cashflow
-6892 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 69294 | 15245 | -6892 | 1189547 | 400606 |
| Y2 | 71373 | 15702 | -5579 | 1225233 | 456556 |
| Y3 | 73514 | 16173 | -4226 | 1261990 | 514381 |
| Y4 | 75719 | 16658 | -2833 | 1299850 | 574144 |
| Y5 | 77991 | 17158 | -1397 | 1338846 | 635914 |
| Y6 | 80331 | 17673 | 81 | 1379011 | 699757 |
| Y7 | 82741 | 18203 | 1603 | 1420381 | 765746 |
| Y8 | 85223 | 18749 | 3172 | 1462993 | 833953 |
| Y9 | 87780 | 19312 | 4787 | 1506883 | 904455 |
| Y10 | 90413 | 19891 | 6451 | 1552089 | 977330 |
| Σ 10y | Cumulative net cashflow | -4834 | Equity at exit | 977330 | |
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.