Which asset is really underperforming? (EN)

3:07 · English · Portfolio Analytics

Watch this video

Enter your details to access the library. We'll email you a code to verify your address.

See how we use your data in our Privacy Policy.

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.

Fifth Dimension for portfolio managers

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