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

How can we support you?

Weißes Quadrat mit umrandeten Seiten rechts oben

Planning tool for financial modeling I

Project duration: 1 year

Brief description

The objective of the project is to implement a new financial modeling framework. All strategic and financial planning technical demands should be completed as soon as possible using this solution. The required standards for compliance with financial planning technical requirements are US Generally Accepted Accounting Principles (US GAAP) and Economic Value Measurement (EVM) methods.  Support is required in the areas of analysis, design, implementation and testing of the solution. This also includes support for IT processes, creation of documentation, preparation of workshops, creation of technical documentation and support in project management. In addition, the customer is supported when standardizing and adjusting the budget and the three annual schedules from the IT perspective.

Supplement

The business areas receive templates for the models in order to generate their data or consolidate it. This information is collected by the department for financial planning and modeling. The templates used for the models are adapted and improved during project runtime. The procedure is an agile process framework. The technology used is based on Microsoft Excel and enhanced with Visual Basics for Applications (VBA). Another part of the task is the development of different Excel files.

Subject description

The expanded result of the performance group is an important function of the group functions. This includes internal and external reporting, as well as planning and modeling. The planning models use data from the past to create the best forecast possible. Use of the budget for the forecast improves the quality of the prediction. Every business area must enter its financial figures in Excel and deliver them to the group function. Divisions can be reinsurance cover for property insurance or reinsurance cover for life insurance. You can use this information, for example, to calculate "Shareholder Equity" or total expenditure for "Assets" for a year.

Overview

Project period01.09.2012 - 31.08.2013

Have we sparked your interest?

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.