About this video
Ellie builds one tenant master list across three managers and finds a group concentration the report splits three ways.
Full description
Tessera's committee needs one tenant master list across Hong Kong, Singapore, Sydney and Brisbane. The concentration report counts Caldwyn as three unrelated tenants; read together, the leases and guarantees point to one group at 8.94% of rent (US$19.0m of US$212.41m), over the 7.5% watch line. Ellie flags the Hong Kong link as a documented assumption to confirm, and merges duplicate tenant names so the top-ten share is 33.0%.
Key points
- Three managers' tenant lists reconciled into one
- Group exposure found across leases and guarantees
- Assumptions flagged, not hidden
Transcript
Alabaster is a tenant master data demo for Tessera. It ends on this brief for the committee why three tenants became one group. Both deeds of guarantee call the tenant a subsidiary. And where the number lands above the 7.5% watch threshold below the 10% approval gate. Three property managers report its five buildings, each naming the same tenants its own way. The data room holds their schedules, leases, deeds, and guidelines. The asset team starts with the quarterly concentration report going to the investment committee on the 6th of October asking for its headline, its top tenant groups and how it identified them.
Its headline, the largest group is 4.6% of gross rent with none above the 7.5% watch threshold. That does not hold. Caldwyn appears three times under three names and the report counts it as three unrelated groups. The tenant on that lease is not the parent company. It is the Singapore subsidiary. The Singapore manager keyed the guarantor, the parent company, as the tenant. Ellie checks the other two Caldwyn rent lines against their leases. Tessera's own guidelines settle it.
A tenant group comes from the leases and guarantees, not the manager's names. On that definition, Caldwyn is one group, $18.99 million, 8.94% of gross rent. The Hong Kong tenancy has no parent guarantee. Nothing in the room links it to the group. So Ellie treats it as a documented assumption and gives the committee both bases. The workbook holds every building unit and tenant once from all three managers. Units and tenants follow each tenant resolved to its legal entity.
Every group share is computed by formula. It logs every disagreement between the managers and the leases. On the dashboard, the 10 largest groups make up 32.3%, not 28.7. Caldwyn's three leases sit side by side. 21 disagreements with the source on each side, starting with Caldwyn reported as three unrelated groups. The check then becomes a skill with an agent on the folder. Whenever a manager's report lands, Ellie matches every tenant back to its legal entity and tests concentration again against the 7.5% watch line.
The brief for the committee shows why the three became one. Click a rent figure and the signed lease opens beside it. This is the finding a general model is likely to miss. Each manager's schedule reads correctly on its own. The error only appears when a tenant name is checked against its lease, the lease against its deed of guarantee, and the result against Tessera's definition of a group. Ellie follows that chain across three managers and three markets, and a report inside its limit becomes a note the committee has to see.
Portfolio intelligence across the fund
Video details
- Roles
- Asset Manager, Portfolio Manager
- Processes
- Portfolio Analytics, Lease Abstraction
- Geographies
- APAC
- Markets
- Australia, Hong Kong, Singapore
- Tags
- author-demo-2, tenant master list, concentration