Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Retail unit on Gràcia
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
-759
10-yr return
87%
Net cashflow / mo
-759
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
642400 EUR
Down payment (30%)
192720 EUR
Acquisition fees (10.0%)
64240 EUR
Mortgage principal
449680 EUR
Total cash-in at close
256960 EUR
🏦 Financing
Loan amount
449680 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2349 EUR
Annual debt service
28186 EUR
📊 Year-1 operating P&L
Gross rent
+30193
Operating costs (22%)
−6642
Net operating income (NOI)
23550
− Debt service
−28186
− Income tax (19%)
−4475
Net cashflow
-9110 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 30193 | 6642 | -9110 | 661672 | 222833 |
| Y2 | 31099 | 6842 | -8538 | 681522 | 253954 |
| Y3 | 32032 | 7047 | -7948 | 701968 | 286118 |
| Y4 | 32992 | 7258 | -7341 | 723027 | 319361 |
| Y5 | 33982 | 7476 | -6716 | 744718 | 353720 |
| Y6 | 35002 | 7700 | -6072 | 767059 | 389232 |
| Y7 | 36052 | 7931 | -5408 | 790071 | 425937 |
| Y8 | 37133 | 8169 | -4725 | 813773 | 463877 |
| Y9 | 38247 | 8414 | -4021 | 838186 | 503093 |
| Y10 | 39395 | 8667 | -3296 | 863332 | 543629 |
| Σ 10y | Cumulative net cashflow | -63175 | Equity at exit | 543629 | |
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.