Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
2-bed 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
-218
10-yr return
118%
Net cashflow / mo
-218
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
759600 EUR
Down payment (30%)
227880 EUR
Acquisition fees (10.0%)
75960 EUR
Mortgage principal
531720 EUR
Total cash-in at close
303840 EUR
🏦 Financing
Loan amount
531720 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
2777 EUR
Annual debt service
33328 EUR
📊 Year-1 operating P&L
Gross rent
+48614
Operating costs (22%)
−10695
Net operating income (NOI)
37919
− Debt service
−33328
− Income tax (19%)
−7205
Net cashflow
-2613 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 48614 | 10695 | -2613 | 782388 | 263487 |
| Y2 | 50073 | 11016 | -1692 | 805860 | 300286 |
| Y3 | 51575 | 11347 | -743 | 830035 | 338318 |
| Y4 | 53122 | 11687 | 235 | 854936 | 377626 |
| Y5 | 54716 | 12038 | 1241 | 880585 | 418253 |
| Y6 | 56357 | 12399 | 2279 | 907002 | 460244 |
| Y7 | 58048 | 12771 | 3347 | 934212 | 503646 |
| Y8 | 59790 | 13154 | 4447 | 962239 | 548507 |
| Y9 | 61583 | 13548 | 5580 | 991106 | 594877 |
| Y10 | 63431 | 13955 | 6748 | 1020839 | 642809 |
| Σ 10y | Cumulative net cashflow | 18828 | Equity at exit | 642809 | |
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.