Country-aware · Mortgage · Taxes · Cashflow · Appreciation
Underwrite the deal on
Underwrite the deal on
Private villa with garden, Lagos
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.3%
Cashflow / mo
-494
10-yr return
119%
Net cashflow / mo
-494
EUR · after debt service & taxes
Cap rate
5.3%
NOI ÷ asking price
Cash-on-cash
-1.7%
Year-1 cashflow ÷ cash-in
10-yr total return
119%
8.2% annualised
💼 Acquisition
Asking price
896600 EUR
Down payment (30%)
268980 EUR
Acquisition fees (8.0%)
71728 EUR
Mortgage principal
627620 EUR
Total cash-in at close
340708 EUR
🏦 Financing
Loan amount
627620 EUR
Mortgage rate
4.10%
Term
25 years
Monthly payment
3348 EUR
Annual debt service
40171 EUR
📊 Year-1 operating P&L
Gross rent
+60969
Operating costs (22%)
−13413
Net operating income (NOI)
47556
− Debt service
−40171
− Income tax (28%)
−13316
Net cashflow
-5931 EUR
📈 10-year projection
3.0% capital appreciation /yr| Year | Gross rent | Opex | Net cashflow | Property value | Equity |
|---|---|---|---|---|---|
| Y1 | 60969 | 13413 | -5931 | 923498 | 310591 |
| Y2 | 62798 | 13816 | -4903 | 951203 | 353623 |
| Y3 | 64682 | 14230 | -3845 | 979739 | 398127 |
| Y4 | 66622 | 14657 | -2756 | 1009131 | 444154 |
| Y5 | 68621 | 15097 | -1633 | 1039405 | 491758 |
| Y6 | 70680 | 15550 | -477 | 1070587 | 540994 |
| Y7 | 72800 | 16016 | 714 | 1102705 | 591920 |
| Y8 | 74984 | 16496 | 1940 | 1135786 | 644595 |
| Y9 | 77233 | 16991 | 3204 | 1169860 | 699081 |
| Y10 | 79550 | 17501 | 4505 | 1204955 | 755443 |
| Σ 10y | Cumulative net cashflow | -9183 | Equity at exit | 755443 | |
Modelling assumptions
- Country baseline: PT — operating costs 22% of gross rent, income tax 28%, 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.