Property valuation is an implementation of a DCF-based model for real estate appraisal. The system calculates net operating income for 10 years for each portfolio based on the input data (rent roll, market assumptions, cost categories, etc.) provided by the user. Some intermediate statistics like income by rent roll item type (Office, Parking, Retail, etc.) are computed on-line. Some charts are available to visualize the results.
prop) is a central dimension which contain three hierarchy levels: portfolios, properties (buildings) and (rent roll) items (or tenants).
cat) describes the type of the rent-roll item (Office, Parking, Retail, etc.).
class) is a simple subdivision of lease categories into four possible types (A, B, C, D) which is used to allow for different market assumptions on the same lease category (f.e. market rent could be 40 Euro for Office/A and 50 Euro for Office/B).
pos) is a technical dimension to distinguish different measures/values in the cube. It contains members like: market rent, net operating income, discount rate, and so on.
posType) is a helper type which is not used in the cube directly. It describes formatting options for each position. (Currency, Date, Percentage, etc.)
reg) is a helper type which is not used in the cube directly. It describes the location of each property (from the Property Information dimension) and is intended to be used for analysis to compute information like average rent or vacancy rate in a region. Possible values are: Munich, Frankfurt, etc...
year) is the report year. Possible values are: 1, 2, 3, ... ,10
age) is used for automatic building maintenance costs computation. It divides building into 4 categories according to their age. (up to 5 years old, 6 - 10 years old, and so on)
mLevel) is used for automatic building maintenance costs computation. It describes how well the building is beeing serviced. Possible values are: high, average and low.
There are two views: Appraisal and Maintenance costs (one per cube). Maintenance costs view contains a single worksheet with maintenance costs. The Appraisal view contains most of the functionality. The view is organized by the Property Information dimension. Following are the most important worksheets:
YEARFRAC-function. Then contract income (based on contract data) and market income (based on market assumptions) amounts are determined for each year. Turnover vacancy costs are substracted from years containing the end of a contract period. Maintenance costs are substracted as the last step.