Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Penthouse-style apartment, Born
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
3.7%
Cashflow / mo
-373
10-yr return
87%
Net cashflow / mo
-373
EUR · after debt service & taxes
Cap rate
3.7%
NOI ÷ asking price
Cash-on-cash
-3.6%
Year-1 cashflow ÷ cash-in
10-yr total return
87%
6.5% annualised
💼 Acquisition
Asking price
315600 EUR
Down payment (30%)
94680 EUR
Acquisition fees (10.0%)
31560 EUR
Mortgage principal
220920 EUR
Total cash-in at close
126240 EUR
🏦 Financing
Loan amount
220920 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
1154 EUR
Annual debt service
13847 EUR
📊 Year-1 operating P&L
Gross rent
+14833
Operating costs (22%)
−3263
Net operating income (NOI)
11570
− Debt service
−13847
− Income tax (19%)
−2198
Net cashflow
-4476 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 14833 | 3263 | -4476 | 325068 | 109474 |
| Y2 | 15278 | 3361 | -4194 | 334820 | 124763 |
| Y3 | 15737 | 3462 | -3905 | 344865 | 140565 |
| Y4 | 16209 | 3566 | -3607 | 355211 | 156897 |
| Y5 | 16695 | 3673 | -3299 | 365867 | 173776 |
| Y6 | 17196 | 3783 | -2983 | 376843 | 191223 |
| Y7 | 17712 | 3897 | -2657 | 388148 | 209256 |
| Y8 | 18243 | 4013 | -2321 | 399793 | 227895 |
| Y9 | 18790 | 4134 | -1976 | 411786 | 247161 |
| Y10 | 19354 | 4258 | -1619 | 424140 | 267075 |
| Σ 10y | Cumulative net cashflow | -31037 | Equity at exit | 267075 | |
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.