Chargement...
Chargement...
Lease-by-lease modelling — each tenant with their own terms
YYYY-MM
Major maintenance, refurbishments (deducted from NOI)
For equity IRR calculation (0 = no debt)
YYYY-MM
YYYY-MM
YYYY-MM — early exit (active in DCF)
Market rent at renewal
YYYY-MM
YYYY-MM
YYYY-MM — early exit (active in DCF)
Market rent at renewal
YYYY-MM
YYYY-MM
YYYY-MM — early exit (active in DCF)
Market rent at renewal
| Tenant | Area | Rent /m² | ERV /m² | ERV gap | Remaining term | % of rent |
|---|---|---|---|---|---|---|
| Tenant A | 300 m² | 240,00 € | 260,00 € | +8.3% | 1.9 yrs | 51% |
| Tenant B | 180 m² | 220,00 € | 240,00 € | +9.1% | 3.3 yrs | 28% |
| Tenant C | 120 m² | 240,00 € | 250,00 € | +4.2% | 4.9 yrs | 21% |
| Yr. | Rents | Rent-free | Void | Charges | Net income | Discounted |
|---|---|---|---|---|---|---|
| 1 | 151.136 € | — | — | - 12.000 € | 151.136 € | 142.581 € |
| 2 | 154.159 € | — | — | - 12.000 € | 154.159 € | 137.201 € |
| 3 | 152.536 € | — | — | - 12.000 € | 148.536 € | 124.714 € |
| 4 | 154.027 € | — | — | - 12.000 € | 150.027 € | 118.836 € |
| 5 | 153.633 € | — | — | - 12.000 € | 145.633 € | 108.826 € |
| 6 | 108.000 € | — | - 41.040 € | - 12.000 € | 54.960 € | 38.745 € |
| 7 | 108.000 € | — | - 41.040 € | - 12.000 € | 54.960 € | 36.552 € |
| 8 | 151.200 € | — | — | - 12.000 € | 139.200 € | 87.336 € |
| 9 | 151.200 € | — | — | - 12.000 € | 139.200 € | 82.392 € |
| 10 | 108.000 € | — | - 41.040 € | - 12.000 € | 54.960 € | 30.689 € |