This is one of 4620 IT projects that we have successfully completed with our customers.How can we support you?
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
- Industries insurance
- Specialist tasks finance plannung, forecast, reinsurance
- DV tasks customised software further development
- System environment technical data processing
- Procedure model agile software development
- Development/ test tools Subversion
- Operating systems Windows 7
Project period01.09.2012 - 31.08.2013
Contact
PTA GmbH Head Office
Weberstraße 2-4
D-68165 Mannheim
© Copyright 2024 PTA GmbH | All rights reserved | Imprint | Privacy | Legal notice | Values & Code of Conduct
