Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Flagship street-level retail, Ruzafa
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
-102
10-yr return
118%
Net cashflow / mo
-102
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
355500 EUR
Down payment (30%)
106650 EUR
Acquisition fees (10.0%)
35550 EUR
Mortgage principal
248850 EUR
Total cash-in at close
142200 EUR
🏦 Financing
Loan amount
248850 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1300 EUR
Annual debt service
15598 EUR
📊 Year-1 operating P&L
Gross rent
+22752
Operating costs (22%)
−5005
Net operating income (NOI)
17747
− Debt service
−15598
− Income tax (19%)
−3372
Net cashflow
-1223 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 22752 | 5005 | -1223 | 366165 | 123314 |
| Y2 | 23435 | 5156 | -792 | 377150 | 140537 |
| Y3 | 24138 | 5310 | -348 | 388464 | 158336 |
| Y4 | 24862 | 5470 | 110 | 400118 | 176732 |
| Y5 | 25608 | 5634 | 581 | 412122 | 195746 |
| Y6 | 26376 | 5803 | 1066 | 424486 | 215398 |
| Y7 | 27167 | 5977 | 1566 | 437220 | 235711 |
| Y8 | 27982 | 6156 | 2081 | 450337 | 256706 |
| Y9 | 28822 | 6341 | 2612 | 463847 | 278408 |
| Y10 | 29686 | 6531 | 3158 | 477762 | 300841 |
| Σ 10y | Cumulative net cashflow | 8812 | Equity at exit | 300841 | |
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.