This is one of 4124 IT projects that we have successfully completed with our customers.

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

Planing-Tool for finance modeling

Project duration: 9 months

Brief description

The aim of the project is to provide a tool to the group functions to consolidate different data coming from the business units. All business units provide the data in the format of a Microsoft Excel file. All these files shall be controlled by one main excel file. This file take over the versioning, the aggregation and the consolidation of all the data, which arrives from the business units.

Supplement

The process is a mixture between classical process model and agile processes. The technology used is Visual Basic for Applications (VBA).

Subject description

The expected result of the group and the group performance is an important function of the group functions. This is includes also internal group reporting, group planning and modelling. The financial models use date from the past to provide a forecast of for the result. Also the adjustments of the financial data based on the budget helps to improve the quality of the forecast. Every business unit has to provide there plan data to the group function. The data is provided in excel file. They are based on the standard excel template for their division.

Overview

Project period01.12.2012 - 31.08.2013

Have we sparked your interest?

Portrait von Dr. Tim Walleyo

Dr. Tim Walleyo

Member of the Management Board

Jetzt Kontakt aufnehmen

Zum Umgang mit den hier erhobenen Daten informieren wir in unserer Datenschutzerklärung.

Contact now

We provide information on the handling of the data collected here in our privacy policy.

Download file

We provide information on the handling of the data collected here in our privacy policy.