Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Bright pied-à-terre in Centro Histórico
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
-438
10-yr return
111%
Net cashflow / mo
-438
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
880600 EUR
Down payment (30%)
264180 EUR
Acquisition fees (10.0%)
88060 EUR
Mortgage principal
616420 EUR
Total cash-in at close
352240 EUR
🏦 Financing
Loan amount
616420 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3220 EUR
Annual debt service
38637 EUR
📊 Year-1 operating P&L
Gross rent
+52836
Operating costs (22%)
−11624
Net operating income (NOI)
41212
− Debt service
−38637
− Income tax (19%)
−7830
Net cashflow
-5255 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 52836 | 11624 | -5255 | 907018 | 305458 |
| Y2 | 54421 | 11973 | -4254 | 934229 | 348119 |
| Y3 | 56054 | 12332 | -3222 | 962255 | 392210 |
| Y4 | 57735 | 12702 | -2160 | 991123 | 437780 |
| Y5 | 59467 | 13083 | -1066 | 1020857 | 484878 |
| Y6 | 61251 | 13475 | 62 | 1051482 | 533558 |
| Y7 | 63089 | 13880 | 1223 | 1083027 | 583874 |
| Y8 | 64982 | 14296 | 2418 | 1115518 | 635881 |
| Y9 | 66931 | 14725 | 3650 | 1148983 | 689638 |
| Y10 | 68939 | 15167 | 4919 | 1183453 | 745204 |
| Σ 10y | Cumulative net cashflow | -3686 | Equity at exit | 745204 | |
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.