Situation:
A client was going public and needed to straight line their rental income for the previous 5 years. The portfolio consisted of close to 20 Million Square Feet and over 2,500 Tenant Records; 3 to 5 year analysis depending on the acquisition date.

Solution:
Realogic created a customized Excel model to calculate the straight line rental revenue and adjustment amount at the tenant level, with building level aggregation.

Realogic then prepared individual building tenant rosters, based on historical rent rolls, to determine the occupied tenant population over the last 5 years.

After the initial setup, Realogic worked in conjunction with the client's accounting firm auditing the results to resolve any discrepancies and assure compliance with standardized accounting guidelines.