Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Family villa with pool, Ciutat Vella · Ref 7573
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
-87
10-yr return
118%
Net cashflow / mo
-87
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
303300 EUR
Down payment (30%)
90990 EUR
Acquisition fees (10.0%)
30330 EUR
Mortgage principal
212310 EUR
Total cash-in at close
121320 EUR
🏦 Financing
Loan amount
212310 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1109 EUR
Annual debt service
13308 EUR
📊 Year-1 operating P&L
Gross rent
+19411
Operating costs (22%)
−4270
Net operating income (NOI)
15141
− Debt service
−13308
− Income tax (19%)
−2877
Net cashflow
-1044 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 19411 | 4270 | -1044 | 312399 | 105207 |
| Y2 | 19994 | 4399 | -676 | 321771 | 119901 |
| Y3 | 20593 | 4531 | -297 | 331424 | 135087 |
| Y4 | 21211 | 4666 | 94 | 341367 | 150782 |
| Y5 | 21847 | 4806 | 496 | 351608 | 167004 |
| Y6 | 22503 | 4951 | 910 | 362156 | 183770 |
| Y7 | 23178 | 5099 | 1336 | 373021 | 201100 |
| Y8 | 23873 | 5252 | 1776 | 384211 | 219013 |
| Y9 | 24590 | 5410 | 2228 | 395738 | 237528 |
| Y10 | 25327 | 5572 | 2694 | 407610 | 256666 |
| Σ 10y | Cumulative net cashflow | 7518 | Equity at exit | 256666 | |
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.