About this video
Ellie rolls up a six-asset industrial portfolio from two managing agents' reports and fixes the occupancy definitions before ranking.
Full description
Cinnabar Industrial's monthly reporting set comes from two managing agents who define occupancy differently. Ellie separates reported from physical occupancy, normalises the two conventions, and re-ranks the six assets: the asset the pack ranks second moves to second from last. Refresh of the Portfolio Rollup demo.
Key points
- Two managing agents, two occupancy definitions, one consistent basis
- Ranking corrected once the definitions agree
- Replaces the Portfolio Rollup Loom demo
Transcript
Cinnabar is a portfolio reporting demo about six Sun Belt logistics assets run by two different agents. The monthly review is due to the committee this week with a facility calculation at the end of the month. Here, Ellie shows how comparable looking reports can produce the wrong ranking when the definitions do not match. The data room brings together asset level operating reports and portfolio financials, the supporting leases and lending documents and each assets monthly report.
Together, they let Ellie check whether reported performance is comparable. Ellie is asked to rank the assets by occupancy and income. Before ranking anything, Ellie finds the problem. One agent reports space occupied and paying. The other reports leased area. Ellie states the basis for every figure and flags anything that prevents a like forlike comparison. The same label is being used for two different measures. Next, Ellie explains the gap between reported and restated.
At Verdllo, 122,000 square feet is counted as leased under an expansion that has not commenced. So, no rent is payable. The notice is in the room and the source figure cannot be treated as physical occupancy. Ellie also finds that several agent reported areas do not reconcile to their own rent rolls running in both directions. Ellie then produces the monthly review starting with the ranked workbook. Reported and restated figures sit side by side with the source behind every number.
The covenant sheet carries each action owner and due date. The dashboard shows supported measures only occupancy on one basis. Unsupported measures like lease term are not shown as finished figures. Net operating income by asset with the month affected by the tax true up and the actions required before the calculation date. The committee brief makes every conclusion traceable. Verdlo moves from second place to last on one physical basis. This is what a general model is likely to miss.
It can summarize six reports or rank the percentages it is given. Ellie first establishes that occupancy means different things in different documents. Rebuilds the measure from the rent rolls and challenges the ranking itself. Two reporting conventions in, one defensible portfolio view out.
Portfolio intelligence across the fund
Video details
- Roles
- Asset Manager, Portfolio Manager
- Processes
- Portfolio Analytics, Asset Management
- Geographies
- US
- Markets
- United States
- Tags
- author-demo-2, portfolio roll-up, occupancy, refresh