Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Flagship street-level retail, 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
-848
10-yr return
87%
Net cashflow / mo
-848
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
717800 EUR
Down payment (30%)
215340 EUR
Acquisition fees (10.0%)
71780 EUR
Mortgage principal
502460 EUR
Total cash-in at close
287120 EUR
🏦 Financing
Loan amount
502460 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2625 EUR
Annual debt service
31494 EUR
📊 Year-1 operating P&L
Gross rent
+33737
Operating costs (22%)
−7422
Net operating income (NOI)
26315
− Debt service
−31494
− Income tax (19%)
−5000
Net cashflow
-10179 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 33737 | 7422 | -10179 | 739334 | 248987 |
| Y2 | 34749 | 7645 | -9540 | 761514 | 283761 |
| Y3 | 35791 | 7874 | -8881 | 784359 | 319701 |
| Y4 | 36865 | 8110 | -8203 | 807890 | 356845 |
| Y5 | 37971 | 8354 | -7504 | 832127 | 395237 |
| Y6 | 39110 | 8604 | -6784 | 857091 | 434917 |
| Y7 | 40283 | 8862 | -6043 | 882803 | 475931 |
| Y8 | 41492 | 9128 | -5280 | 909288 | 518323 |
| Y9 | 42737 | 9402 | -4493 | 936566 | 562142 |
| Y10 | 44019 | 9684 | -3683 | 964663 | 607436 |
| Σ 10y | Cumulative net cashflow | -70590 | Equity at exit | 607436 | |
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.