Success Story: Property valuation with the Discounted Cashflow method at alstria

PROPERTY VALUATION
WITH THE DISCOUNTED
CASH FLOW METHOD

at alstria

alstria and bdg develop a solution for the valuation of commercial properties in Board

In order to continuously optimise corporate planning, alstria office REIT-AG has been working with bdg for several years on various business intelligence (BI) and enterprise performance management (EPM) projects. The aim of this co-operation is the gradual implementation of fully integrated corporate planning, which includes financial, HR and operations planning.

An important building block on this path was the development of a property valuation tool that enables the fair market valuation of properties based on the discounted cash flow (DCF) method. The introduction of this solution should not only reduce dependence on external service providers, but also enable alstria to value its property portfolios more efficiently, quickly and cost-effectively overall.

In Excel, the data volumes were simply no longer manageable and the processes took an enormous amount of time – we would not have been able to realise our required evaluation frequency under these conditions. Now the amount of data is no longer a problem at all and we can use our time for analyses.

alstria

PROJECT OBJECTIVE

The project focused on implementing a standardised valuation approach for the entire property portfolio. The solution was to precisely calculate property values based on the discounted cash flow (DCF) method. This combines a long-term cash flow forecast with a discount factor to determine the market value of a property.

The aim was to simplify standard valuations: In order to fulfil the requirements of the parent company, which is subject to US stock corporation regulations (SOX), alstria carries out eight valuations per year for each property. Previously, property valuations were conducted externally. The internal tool was designed to simplify the process and make it more efficient, so that only one valuation per year is carried out externally and the other seven valuations can be done internally.

Read the whole story now

… and learn about all the highlights in detail:

Development of a valuation tool for commercial property using the DCF method
Seamless integration into existing corporate planning processes
Improved efficiency and process reliability
Cooperative collaboration and high commitment to the success of the project

About alstria

alstria office REIT-PLC is a German public limited company with its registered office in Hamburg. The company has been operating under the legal form of a REIT (Real Estate Investment Trust) since 2007 and was the first PLC of its kind in Germany. alstria owns and manages a high-quality portfolio of office properties in major German office centres. As a long-term oriented company, alstria manages the properties over their entire life cycle: from acquisition to leasing, ongoing management, modernisation and possible sale. A detailed concept is developed for each individual building, and modernising the properties is an essential part of the business model in order to create consistent value.

Industry	Region	Application	Number of users
Real Estate	Hamburg, Germany	Controlling/Real Estate Operations	90

EXPLORE MORE SUCCESS STORIES

better decisions group GmbH | HC 800x450

Planning Transformed: How Hawes & Curtis Elevated Sales and Stock Visibility

Heritage menswear brand Hawes & Curtis had outgrown their Excel-based planning setup, with stock intake and weekly performance becoming increasingly difficult to track as the business grew. Working with bdg, they implemented a tailored MFP and WSSI solution on Board, giving the team real-time visibility of sales and stock, a structured weekly planning process, and the confidence to build and maintain their own reports going forward.

better decisions group GmbH | Agentic AI

Will AI replace the CFO? Not quite.

Agentic AI is fundamentally reshaping the finance function – faster than most people expect. CFO Kyanush Kay and Jochen Heßler (bdg) discuss the reality of Excel, the AI hype, and what it all means for the CFO role.

Make the budget cycle easy

The Four Phases of a Budget Cycle – Made Easy with the Right BI Tool

Have you ever thought about why the regular financial budget season spans over three months? It‘s because Controlling and FP&A departments have to walk a tightrope between accuracy and timely completion as they often rely on a variety of spreadsheets. What falls short is the flexibility to react to today’s world with its rapid market dynamics. Read on to learn how the right BI tool can help!