Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Penthouse-style apartment, 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
-113
10-yr return
118%
Net cashflow / mo
-113
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
394300 EUR
Down payment (30%)
118290 EUR
Acquisition fees (10.0%)
39430 EUR
Mortgage principal
276010 EUR
Total cash-in at close
157720 EUR
🏦 Financing
Loan amount
276010 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1442 EUR
Annual debt service
17300 EUR
📊 Year-1 operating P&L
Gross rent
+25235
Operating costs (22%)
−5552
Net operating income (NOI)
19683
− Debt service
−17300
− Income tax (19%)
−3740
Net cashflow
-1357 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 25235 | 5552 | -1357 | 406129 | 136773 |
| Y2 | 25992 | 5718 | -878 | 418313 | 155875 |
| Y3 | 26772 | 5890 | -386 | 430862 | 175617 |
| Y4 | 27575 | 6067 | 122 | 443788 | 196021 |
| Y5 | 28402 | 6249 | 644 | 457102 | 217110 |
| Y6 | 29255 | 6436 | 1183 | 470815 | 238908 |
| Y7 | 30132 | 6629 | 1737 | 484939 | 261437 |
| Y8 | 31036 | 6828 | 2308 | 499487 | 284724 |
| Y9 | 31967 | 7033 | 2897 | 514472 | 308794 |
| Y10 | 32926 | 7244 | 3503 | 529906 | 333675 |
| Σ 10y | Cumulative net cashflow | 9773 | Equity at exit | 333675 | |
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.