Analytical Solution for Property Management
Analytical Solution developed specially for Property Management companies, which are going to or have already bought assets for further
leasing of the assets and possible consequent sale of it. The Real Estate in such cases are normally sold by Portfolios, which
contents of residential, commercial and industrial assets. Assets could include different objects such as parking, support units, etc.
Business Scenario includes borrowing funds and using of company equity for purchasing real assets Portfolios.
In the course of business the company provide quite common activities: pays bank interest for loan, performs repair and all other necessary
activities to keep assets up to the market standards. Company has other sources of income providing legal, management and other type of
services upon its client requests.
Analytical Solution uses number of common Key Performance Indicators to assess effectiveness of business like Return of Equity, Price per
sq.m per asset at purchase and sale, CAPEX per sq.m and others.
Analytical Solution provides "Plan vs. Actual" comparison, including Gross Potential and Actual Income, Gross potential and Actual
Operational Income, Capitalization Rate, etc.
Brief Description of the Analytical Solution
Analytical Solution for Property Management consists of seven subjected areas - Dashboards:
and provides over forty Analytical reports.
"Business Snapshot" Dashboard aimed to meet
enquires of the top managers and owners of the company. The page with the same name consists of tables and graphs with the most
valuable information, which allows the quick assessment of the business situation and provide support for business decision. This page
could be easily modified adjusting its layout and navigation according to specific requirements.
"Business Basics" consolidates main information regarding the initial conditions of the business: number of Real Estate
Portfolios purchased, initial price per Portfolio, amount of borrowed funds and equity invested into business, number of assets and overall
area possessed in sq.m/sq.ft and per Portfolio.
Return of Equity (ROE) analysis has two presentation layouts - table and graph. Calculation of the ROE uses quite common
algorithm, accounted as equity divided by the total difference between overall revenue and total expenses including taxes. ROE per year
presented as a run sum.
This page also contents Vacancy Rate analytics.
The value of Vacancy Rate per year is a result of dividing of the number of non-rented assets by the total number of
assets possessed by the company at the time frame in question. The adjustment is foreseen for the non-rented assets, which are under repair
or renovation. Our Analytical Solution allows quick adjustments of the calculation algorithms.
The page Business-Photo consists of the most valuable
information and analytics regarding the asset in question: purchase price, overall area and area per component, price per sq.m, CAPEX (if
Analytical data includes expenses per year and per type of expense, amount due of accounts receivables, OPEX vs. Rent revenue.
In addition to company business data the Analytical Solution provides storage for external business related data like
Asset Market Price, which could be collected from the particular data source or from several data sources. Based on these
data several analytical reports could be created, i.e. verification of the asset sale by means of the comparison of the sale price per sq.m
and with the same indicator on the market for the same type of asset. The Key Performance Indicators (KPI) algorithm are described in
special "Help" which could be seen by clicking on "?" sign next to the report name.
Profit and Loss management report could be seen by country, region, city, type of asset, portfolio, asset manager, etc.
The scope of revenue and expense sources could be extended according to the specific requirements and will not affect report templates,
though the templates could be modified as well. The use of Microsoft SQL database and Oracle BI provides exact user access to sensitive
data, which is one of the strict requirements for managerial reporting.
(back to top)
"Purchasing" Dashboard consists of the same page presenting the general and analytical information for
the purchased assets. For the purchase data the following (AS-IS) filters could be applied: country, city, region, address, portfolio, type of
asset and asset ID. The system also stores information regarding the underlined purchasing documents and the search of the purchase
information per document is also provided.
Analytical Solution supports different purchasing schemes: purchase entity(s), cost allocation, etc., based on the
In case of purchasing per Portfolio all analytical data could be seen by portfolio, i.e. Income Tax will be calculated
based on the total Revenue Before Tax amount which will represent the overall amount for dedicated Portfolio.
In case of per asset purchase the Income Tax and other data will be calculated for each asset. This issue is solved by the
ETL (Extract-Transfer-Load) procedure in the DWH. By default the system supports asset purchase per Portfolio.
(back to top)
"Renting of Apartments and Units" Dashboard consists of three pages with analytical reporting:
General Renting Data, Renting Details и Arrears. General Renting Data
page summary data of revenue from different sources. Apart from the renting of the assets the additional revenue sources could be as
follows: legal services, additional renovation of the assets, commissions, etc.
Renting data could be filtered by year, country, region, city, address, type and ID of the asset, tenant name, asset manager, portfolio
and document (i.e. invoice for lease
Renting Details page includes detailed analytical report for Vacancy Loss due to non-rented assets. This
report could be filtered by year, country, region, city, address, type and ID of the asset, tenant name, asset manager and portfolio.
Apart from the detailed data this report presents the totals of the above.
Arrears page consists of current amounts due and payments which were executed with delay. By default the delay periods are
as follows: less than 7 days, 8-14 days, 15-21 days and over 21 days. These periods could be changed/adjusted according to the particular
(back to top)
"Expenses" Dashboard consists of two pages :Expense Totals and Expenses
Detailed. Expense Totals provides full analysis of expenses per type and corresponding dimension: country, city,
Expenses Detailed provides deep expense analysis per document while keeping ability to filter data per year, country,
region, city, address, asset type and ID, type of expense, tenant, asset manager and portfolio.
(back to top)
"Apartments and Units Sale" Dashboard consists of the same page providing detailed analytical
information of sale and its assessment: Asset cost and sale price, sale margin in percent and correlated prices per sq.m.
Sale data could be filtered by year, country, region, city, address, asset type and ID, type of expense, tenant, asset manager and
(back to top)
"Planning" Dashboard consists of four pages and presents various "Plan-Actual" analytic scenarios per
revenue and expense sources.
Financial Planning page adds "Plan-Actual" scenario for the main KPI, including Operating Expenses and
Return of Equity. Cross comparison of any revenue and expense sources: any revenue/expense source could be compared with
any revenue/expense source.
Analytical Solution supports several planning scenarios to be compared with the actual data.
(back to top)
Current Info Dashboard consists of miscellaneous information regarding assets, which could be
valuable for some analysis. Apart from the general data of the asset it provides other relevant information like construction year of the
(back to top)
By default we submeet our Analytical Solution in AS-IS configuration (see our demo). Based on client requirements we could
develop Specific Analytical Dashboards which will have certain analytical reports and graphs, both existed and new. Links of
that Dashboard will ease navigation on Analytical Solution as well.