Financial modelling

Assistance in your financial and decision-making processes

A unified and intuitive financial model can expedite regular processes as well as ad-hoc analyses concerning ongoing decision making, corporate planning and financial reporting. It can also considerably facilitate their understanding and integration. Routine tasks can often be highly automated by either developing suitable tools or slightly adjusting existing ones, thus significantly streamlining and accelerating the relevant processes.

As a basis for your decision-making processes, a financial model should be a clear and simple to use, flexibly adaptable and technically clean representation of your business processes and links.

The development of a financial model starts with noting down your individual business needs and parameters, such as:

Assumptions about future business development
Assumptions about possible further external factors
Strategic options
Correlations between sales, production, capacity and costs
Financing parameters and options
Tax situation

With this information at hand and the understanding of your business model, we can support you with various modelling services.

Areas of application for financial models

Financial models can fulfill different purposes, such as

Planning and reporting:
- Representation and preparation of your (consolidated) monthly, quarterly or annual financial statements, including relevant key performance indicators (KPI) for owners, outside creditors or management bonus calculations (“Reporting Packages”, “Management Accounts” among others)
- Sales planning, taking into account existing and new products (market share, market size and market penetration)
- Mapping and plausibility check of your business planning, including various alternatives in an integrated model composed of an income statement, balance sheet and liquidity calculation
Valuation of businesses and individual assets
- Valuation taking into account integrated (business) planning and the expected rate of return
Financing and investment
- Investment decision, liquidity forecast (scope of existing financial resources), consideration of the fulfillment of financing conditions (interest charge, covenants)

Our services

We support you with

Your already existing financial models: examination and complementation including automatic reconciliations/checks, streamlining, automation of recurring data transfers between files, consolidation of stand-alone solutions, maintenance
The development of a new financial model

Development of a financial model

The configuration of a financial model is oriented towards the individual framework and business requirements. The fundamental features of a financial model are

A cockpit enabling a quick overview of key input parameters (assumptions, dividend payment restrictions, taxation, capacities) and results (if applicable, including the impact of various scenarios)
Integrated worksheets (linked by formulas) in reportable formats

Alternatives to financial models

In certain situations, e.g. in corporate structures or with very large data volumes, Excel may no longer be sufficient in terms of data entry, processing and efficiency. In such cases, we can offer alternative standard software that is tailored exactly to your individual needs.