Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Retail unit on 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
-99
10-yr return
118%
Net cashflow / mo
-99
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
344700 EUR
Down payment (30%)
103410 EUR
Acquisition fees (10.0%)
34470 EUR
Mortgage principal
241290 EUR
Total cash-in at close
137880 EUR
🏦 Financing
Loan amount
241290 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1260 EUR
Annual debt service
15124 EUR
📊 Year-1 operating P&L
Gross rent
+22061
Operating costs (22%)
−4853
Net operating income (NOI)
17207
− Debt service
−15124
− Income tax (19%)
−3269
Net cashflow
-1186 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 22061 | 4853 | -1186 | 355041 | 119568 |
| Y2 | 22723 | 4999 | -768 | 365692 | 136267 |
| Y3 | 23404 | 5149 | -337 | 376663 | 153526 |
| Y4 | 24106 | 5303 | 106 | 387963 | 171363 |
| Y5 | 24830 | 5463 | 563 | 399602 | 189800 |
| Y6 | 25575 | 5626 | 1034 | 411590 | 208855 |
| Y7 | 26342 | 5795 | 1519 | 423938 | 228550 |
| Y8 | 27132 | 5969 | 2018 | 436656 | 248908 |
| Y9 | 27946 | 6148 | 2532 | 449755 | 269950 |
| Y10 | 28784 | 6333 | 3062 | 463248 | 291701 |
| Σ 10y | Cumulative net cashflow | 8544 | Equity at exit | 291701 | |
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.