Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Retail unit on 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
-1126
10-yr return
87%
Net cashflow / mo
-1126
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
952700 EUR
Down payment (30%)
285810 EUR
Acquisition fees (10.0%)
95270 EUR
Mortgage principal
666890 EUR
Total cash-in at close
381080 EUR
🏦 Financing
Loan amount
666890 EUR
Mortgage rate
3.90%
Term
25 years
Monthly payment
3483 EUR
Annual debt service
41800 EUR
📊 Year-1 operating P&L
Gross rent
+44777
Operating costs (22%)
−9851
Net operating income (NOI)
34926
− Debt service
−41800
− Income tax (19%)
−6636
Net cashflow
-13510 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 44777 | 9851 | -13510 | 981281 | 330468 |
| Y2 | 46120 | 10146 | -12662 | 1010719 | 376622 |
| Y3 | 47504 | 10451 | -11788 | 1041041 | 424323 |
| Y4 | 48929 | 10764 | -10887 | 1072272 | 473623 |
| Y5 | 50397 | 11087 | -9960 | 1104440 | 524578 |
| Y6 | 51909 | 11420 | -9005 | 1137574 | 577244 |
| Y7 | 53466 | 11763 | -8021 | 1171701 | 631679 |
| Y8 | 55070 | 12115 | -7007 | 1206852 | 687944 |
| Y9 | 56722 | 12479 | -5963 | 1243057 | 746103 |
| Y10 | 58424 | 12853 | -4888 | 1280349 | 806219 |
| Σ 10y | Cumulative net cashflow | -93691 | Equity at exit | 806219 | |
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.