Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
2-bed apartment, Pedregalejo
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
4.7%
Cashflow / mo
-410
10-yr return
111%
Net cashflow / mo
-410
EUR · after debt service & taxes
Cap rate
4.7%
NOI ÷ asking price
Cash-on-cash
-1.5%
Year-1 cashflow ÷ cash-in
10-yr total return
111%
7.7% annualised
💼 Acquisition
Asking price
825300 EUR
Down payment (30%)
247590 EUR
Acquisition fees (10.0%)
82530 EUR
Mortgage principal
577710 EUR
Total cash-in at close
330120 EUR
🏦 Financing
Loan amount
577710 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3018 EUR
Annual debt service
36211 EUR
📊 Year-1 operating P&L
Gross rent
+49518
Operating costs (22%)
−10894
Net operating income (NOI)
38624
− Debt service
−36211
− Income tax (19%)
−7339
Net cashflow
-4925 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 49518 | 10894 | -4925 | 850059 | 286276 |
| Y2 | 51004 | 11221 | -3987 | 875561 | 326258 |
| Y3 | 52534 | 11557 | -3020 | 901828 | 367580 |
| Y4 | 54110 | 11904 | -2024 | 928882 | 410288 |
| Y5 | 55733 | 12261 | -999 | 956749 | 454429 |
| Y6 | 57405 | 12629 | 58 | 985451 | 500052 |
| Y7 | 59127 | 13008 | 1146 | 1015015 | 547208 |
| Y8 | 60901 | 13398 | 2266 | 1045465 | 595949 |
| Y9 | 62728 | 13800 | 3421 | 1076829 | 646330 |
| Y10 | 64610 | 14214 | 4610 | 1109134 | 698407 |
| Σ 10y | Cumulative net cashflow | -3454 | Equity at exit | 698407 | |
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.