Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Flagship street-level retail, Ciutat Vella
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
5.0%
Cashflow / mo
-84
10-yr return
118%
Net cashflow / mo
-84
EUR · after debt service & taxes
Cap rate
5.0%
NOI ÷ asking price
Cash-on-cash
-0.9%
Year-1 cashflow ÷ cash-in
10-yr total return
118%
8.1% annualised
💼 Acquisition
Asking price
291500 EUR
Down payment (30%)
87450 EUR
Acquisition fees (10.0%)
29150 EUR
Mortgage principal
204050 EUR
Total cash-in at close
116600 EUR
🏦 Financing
Loan amount
204050 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1066 EUR
Annual debt service
12790 EUR
📊 Year-1 operating P&L
Gross rent
+18656
Operating costs (22%)
−4104
Net operating income (NOI)
14552
− Debt service
−12790
− Income tax (19%)
−2765
Net cashflow
-1003 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 18656 | 4104 | -1003 | 300245 | 101114 |
| Y2 | 19216 | 4227 | -649 | 309252 | 115236 |
| Y3 | 19792 | 4354 | -285 | 318530 | 129831 |
| Y4 | 20386 | 4485 | 90 | 328086 | 144916 |
| Y5 | 20997 | 4619 | 476 | 337928 | 160506 |
| Y6 | 21627 | 4758 | 874 | 348066 | 176621 |
| Y7 | 22276 | 4901 | 1284 | 358508 | 193276 |
| Y8 | 22945 | 5048 | 1707 | 369263 | 210492 |
| Y9 | 23633 | 5199 | 2141 | 380341 | 228287 |
| Y10 | 24342 | 5355 | 2589 | 391752 | 246681 |
| Σ 10y | Cumulative net cashflow | 7225 | Equity at exit | 246681 | |
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.