How can we help?

Advanced Analytics How-To - PDF

Analytics Offering Users Guide

08/22/2018

 

Sponsor Metrics Dashboard

Part of the IMS Analytics Offering, the Metrics Dashboard, provides views into the financial data uploaded from your accounting system.  This guide will discuss the Views included within the offering, the Filters that can be applied to the portfolio, and how to Navigate between the views.

 Views

There are many views available allowing you to drill into your portfolio to understand what is being performed and why with an increasing level of data granularity.

 Portfolio Dashboard

This view provides the default portfolio aggregation.  You will see overarching metrics about your portfolio’s financials at the top with bar charts of values by month.  Below that you will see NOI Actual vs Budget a Map showing your property locations.  At the bottom of the view you see aggregates

AA_1.png

Asset One Pager

This view allows you to see details about one specific property.  The Attributes, Debt, and Equity sections are populated from IMS and the other items on the report pull from the accounting system data.

AA_2.png                    

To get the Financial Summary section to appear on one sheet (for printing), hover over the “Category” header and press the “-“ button.

AA_3.png

 P & L Details

The Details view allows you to drill into the specified Actual and Budget values from the filters on the left.

AA_4.png

To drill into the Account Descriptions from your accounting systems, hover over the “Description” header and press on the “+” box

AA_5.png

 Occupancy

Displays Economic and Physical occupancy at the portfolio level, overlaid on EGI, and within a table for each property.

AA_6.png

 Data Integrity

This view provides details on what accounting system financial data has and has not been loaded into our database.  The table at the bottom has one row for each property and provides a color-coded view into what budget and actual data has been loaded for each month.

AA_7.png

 Filters

Using dropdowns on the left of each screen, you can slice and dice your portfolio in different ways.  Most views contain the same filters, with slight differences. Note, date filters applied on other views will carry over to the Asset One Pager

 Property Name

A multi-select dropdown with the name of each property.

AA_8.png

 Property Type

A multi-select dropdown with the property types

AA_9.png

 Sub Property Type

A multi-select dropdown with the sub-property types.  Note, this data must be loaded by IMS into the analytics database

AA_10.png

 Project Status

A multi-select dropdown with the project status per IMS

AA_11.png

 Location

A multi-select dropdown with the city and state together

AA_12.png

 MSA Name

A multi-select dropdown with MSA values that were looked-up from the associated city and states

AA_13.png

 Ownership Duration

The duration which you have owned the properties.

AA_14.png

 Report Date

Allows you to select an associated date range fixed against today’s date. Note, depending upon the “Current Month” filter you may need to select additional months to get the expected number to show.

AA_15.png

 Report Lookback

A dropdown with a variety of Trailing options (including T3, T6, and T12).  Note, this filter is only available on the P&L Details view.

AA_16.png

 Segment 1 and Segment 2

These values can be used to indicate groups of properties in your portfolio, such as funds.  Note, this data must be loaded by IMS into the analytics database.

AA_17.png

Current Month

Depending upon when financials are finalized, you may or may not want to see the current or prior months.  This dropdown allows you the flexibility to see associated dates.

AA_18.png

 Navigation

There are a couple of ways to move around the application.
The first is a drop down in the top right corner of IMS that takes you directly to each view.

AA_19.png

To get back to the Sponsor dashboard you can click on the Home Button  , or a header in any view, such as: AA_20.png

To get to a populated Asset One Pager, you must click on the PROPERTY NAME from a property table on either the Metrics Dashboard or the Portfolio Occupancy views.

AA_21.png

Clicking on an Occupancy number from either the Metrics Dashboard or Asset One Pager will direct you to Portfolio Occupancy.

 

 KPI Calculations

The following calculations are used throughout the offering:

EGI (Effective Gross Income) = The sum of all revenue items across all properties in the portfolio

Operating Expenses = The sum of all operating expense line items in the portfolio (General & Administrative, Repairs & Maintenance, Advertising & Marketing, etc.)

Net Operating Income = EGI - Operating Expenses

Operating Expense Ratio = Operating Expenses / EGI

 

EGI Per Unit = EGI / number of units

Operating Expense Per Unit = Operating Expenses / number of units

Net Operating Income Per Unit = NOI / Total number of units in portfolio

Average In Place Rental Rate Per Unit = (Gross Potential Rent – Vacancy Loss) / Number of Units

 Physical Occupancy = Average of Occupancy across the portfolio. Occupancy is measured in either units or square feet, depending on preference

Economic Occupancy = SUM(Gross Potential Rent + Vacancy Loss + Concessions + Loss Gain to Lease + Model Unit(s) + Subsidy Income + Commercial Income + Commercial Vacancy + Percentage Rent + Bad Debt) / Gross Potential Rent

 

 How to download the data

Follow these steps to access the raw accounting system data used for the reports:

      1. Click on the Income Statements link in the left navigation
      2. Press the Export Button on the top right
      3. Click on the “Full data” tab
      4. Check the “Show all columns” box
      5. Click the “Download all as rows as a text file”
      6. A csv file will be downloaded into your browser’s download directory

 AA_22.png

Income Statement Report

AA_23.png

A clear-cut income statement with multiple filters along the side, including:

  • Timeframe (Month, Quarter, Year, Rolling 12)
  • Actual, Budget and Variance
  • Dates (allows user to view as far back or forward as they like)
  • Active/Inactive properties
  • Property Type
  • Segments
  • Property Name
  • Census Region
  • Metropolitan Statistical Area
  • State
  • City

Positive values are shown in black, negatives are shown in red and in parenthesis. Drill downs in the report allow the user to break out categories by individual line items.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request