# Portfolio view

# Portfolio view

The portfolio view is one of the key summary views of the Skenarios service. It consists of three tabs: Technical, Property and Finance. These three views capture the essential features of a portfolio. The technical view aggregates features from a building or group point of view, whereas Property and Finance views aggregate features from a unit perspective.

# Technical tab

Overview of the most important technical features of the buildings and the units in the current portfolio is presented in this tab. The main figure of the technical features is the Next 10 years renovation costs, which is the sum of all building renovations1 (excluding unit renovations), is presented in the tab.

###### Renovation forecast

All estimated unit and building renovations of the properties in the portfolio is shown in the stacked bar chart. Note, that the building renovation costs are total costs, not costs in relation to the units owned/administered in the building.

###### Renovation list

The most expensive renovations subject to the buildings in a portfolio for the upcoming years are listed. Maximum five renovations are shown per a year and renovations to which there is no estimate are ranked the highest in the list.

###### Last 3 years maintenance

The unit maintenance costs of the past 3 years and the current year.

###### Energy consumption forecast

Estimated energy consumption per square meter electricity, heating, and cooling demands of the buildings in a portfolio.

###### Technical details

10-year renovation per m2: Next 10 years renovation costs for the next decade per gross floor area of the building.

Repair cost over property value: Next 10 years renovation costs per the sum of the estimated values of the units in a portfolio.

Heating demand: Estimated heating energy consumption of the buildings per m2.

Electricity demand: Estimated electricity energy consumption of the buildings per m2.

Cooling demand: Estimated cooling energy consumption of the buildings per m2.

# Property tab

Overview of the most important features of the properties in the current portfolio is presented in this tab. The main figure is the present Vacancy rate, which is updated in a daily basis.

###### Number of expiring leases

The stacked bar chart shows the count of fixed term and an estimation1 of continuous leases that are about to expire.

###### Current distribution of vacancy rate

Present vacancy rate of units in a portfolio by usage type. Here you also see if you have units which have never been leased, these are labeled as "Never leased units".

###### Property area history

Gross floor area of the units in a portfolio is displayed with respect to the build year of the buildings attached to units.

###### Gross floor area

Total area of the units in a portfolio.

###### Average floor area

Average floor area of the units in a portfolio.

###### Property details

The count of property groups, property buildings and property units in a portfolio.

# Financial status

NetOverview of the most important features of the financial sector of the current portfolio is presented. The main figure is the estimated(1) Total income of the present year, which consists of the expected lease incomes.

The total value and its ratio over gross floor area of the units in a portfolio is displayed for the following quantities.

Stock value: The sum of values of the units in a portfolio.

Gross rental income per month: Total income divided by 12 and its ratio over gross floor area of the units.

CapEx = SUM(A_u * R_b/ A_g + R_u), where the sum is over all groups in a portfolio.

OpEx = SUM(AU * MG / AG. + MU), where the sum runs over all groups in a portfolio.

NOI = Total income - OpEx - CapEx

The value is presented in percentages for the quantities below.

Gross initial yield = Total income / Stock value

Net initial yield = (Total income - OpEx - CapEx) / Stock value

Internal rate of return (IRR): IRR is solved from equation SUM(C_t * (1 + r)^-t) = C, where the sum runs from t = 1 to t = 30, r is IRR, C_t is NOI of the current year + t, and C is Stock value of the current year.

A_u = the sum of the areas of the units in a group.

R_u = the sum of unit renovation costs in a group.

R_u = the sum of building renovation costs in a group.

A_g = the gross floor area of a group.

M_g = the sum of group maintenance, which include administration, administration and maintenance, outdoor maintenance, cleaning, heating, cooling, electricity, water and wastewater, waste management, insurance, rent, property tax and minor repair costs.

M_u = the sum of unit maintenance costs in a group.

###### Lease status

Average days to lease: For the present year and a portfolio, the average count of days between the end and start dates of two subsequent lease agreements.

Tenant turnover: For the present year and a portfolio, the ratio of new leases and units.

###### Estimated property value

The estimated history of Stock value on a monthly basis.

###### Annual vacancy rate at daily basis

The past and the estimated(1) future rate of vacant days in a year.

###### Value of expiring leases

The value of the leases estimated(2) to expire.

###### Capex and income

The estimated future of CapEx(3) and Total income(1).

(1) It is assumed in the estimation that all fixed term lease agreements hold and continuous leases will not be terminated during the estimation period.

(2) The estimation assumes the worst case scenario; a continuous lease expires today according to the first termination date and notice period duration (or today if these are not determined).

(3) SkenarioLabs estimations are used to assume renovations.

Updated on: 28/04/2021

Thank you!