Hide form

Planning, forecasting a data analysis at CPI Property Group


users from the ranks of managers and financial controllers use the planning solution


entities covered within the scope of the supplied solution for financial planning and reporting


cost centres included in the planning process with an outlook 5 years in advance

"Thanks to Solitea's solution for planning, budgeting & forecasting, we raised our planning to an entire new level. This solution contributed to us receiving an investment rating from the Moody's Investor Services agancy only a year later, followed by the S&P Global Ratings agency.".

Petr Vojáček
Head of Finance Management and Controlling

Solitea implemented a solution that was custom prepared for a leading real estate group in the area of property investment and management in Central Europe. The CPI Property Group (CPI PG) has assets under management of EUR 672 million (in 2019) and thus ranks amongst the major Central European investors in the real estate segment. The solution enables the planning of financial flows, detailed income and expenses including rental revenues from thousands of rental units across hundreds of companies. A total of 650 users from the ranks of property and asset managers and financial controllers participate in the planning process. Their activities are managed using workflow, which ensures a smooth process for creating and approving plans at several levels from very detailed up to the consolidated plan for the entire group.

Group Report provides a consolidated overview of the company, across all types of expenses, countries and business areas. The system enables a 5-year strategic outlook to be drawn up for the entire group, as well as a detailed annual budget and during the course of the year also rolling forecasts into which known facts and gradual plan clarifications are projected for the upcoming quarters. The solution provides users work comfort in the well-known Microsoft Excel environment. All data is stored in a Microsoft SQL Server database providing a robust environment for the storage of data with secured access rights.

Prior to taking the decision to implement a specialised system for planning, the CPI Property Group considered proceeding with further development of the existing system of interconnected spreadsheets or the implementation of planning in the environment of the company's ERP system. These pathways were shown to be extremely demanding in investment terms, or did not provide sufficient capacity for meeting specific demanding requirements placed on the future system. Solitea's solution got the attention of the CPI Property Group thanks to its extensive possibilities for adaptation as well as by the fact that it retained the favourite, trusted Excel environment for the users. Another important fact was that the entire solution is built on Microsoft technologies, which were already being used at CPI. This made implementation far easier and over the long term reduced IT infrastructure maintenance costs.

The solution enables the CPI PG group to quickly receive information about the total values of plans, including feedback for making corrections to plans and their optimisation. Modelling makes verification of hypotheses and impacts of decisions easier. The strategic planning module enables rapid predictions of the impact of planned or considered investments on the financial results of the entire group. Thanks to the integration of all the data into a single data warehouse, it is possible to utilise it with flexibility and enables significantly faster delivery of documentation to external partners of the group (investors, banks, auditors, supervisory authorities, etc.). This all had the final consequence of significantly raising the credibility of the entire CPI Property Group.

CPI Property Group has a continuously up-to-date outlook into the future, which is very important when managing such a large number of companies and managed assets, and also provides a significant competitive advantage.

Focusing all budgeted data in a single central location into a single application and database enables the consolidation of planning data across the entire breadth of the so-called budgeting pyramid at CPI PG.

Whilst at the beginning of the project, the solution was used at CPI PG by 120 users for planning approximately 150 entities and 300 cost centres, currently, thanks to the scalability of the solution, already more than 650 users, more than 300 entities an

We will help you make business easier

Just leave us your contact details, we will let you know as soon as possible.

* Mandatory fields