Financial Modeling

PrintMailRate-it

​​​​​​​​​​​A professional financial model helps avoid bad investments and serves as a solid basis for key business decisions and for communication with stakeholders such as banks and advisory boards. Whether you need a model for an M&A transaction, weekly rolling liquidity planning, a multi-year business plan, or a review of an existing model: you can count on us.

 

We develop complex models for you for a wide variety of cases – and thus take the burden off your shoulders if your controlling and finance team is pressed for time, or lacks the necessary resources or expertise.

 

Tailored to your financial needs and easy to implement: when developing our models, we attach great importance to user-friendliness in order to save your time. 


 

Overview of our financial modeling services

 Business Plan Modeling: Securing financing

​F​rom strategic corporate management to successful financing – a financial model for simulating integrated corporate planning is an indispensable tool which serves as the basis for continuous and transparent reporting to internal and external stakeholders (such as advisory boards, financial investors and debt capital providers).


  • Integrated multi-year planning, i.e. ONE model offering an integrated simulation of the income statement, the balance sheet and the cash flow statement
  • Maximum variability: scenario and sensitivity analyses of key KPIs
  • Maximum transparency by taking into account the "golden rules" of financial modeling
  • Depending on the application, we also support you with the implementation of standardised software, e.g. Lucanet​
​​​

 LIQUIDITY PLANNING: OVERVIEW OF THE CURRENT FIGURES EVERY WEEK

​No plan survives the first reality check. To manage a company safely even in difficult times, rolling liquidity planning is a must. It ensures you always have a weekly liquidity development overview and can calculate various scenarios to reliably forecast the short and medium-term cash flow.


  • Low manual workload thanks to automated interfaces
  • Standardised, weekly liquidity reporting
  • Recognising imminent problems before they occur​

 TRANSACTION MODELING: INDISPENSABLE FOR EVERY PLANNED M&A PROJECT

An M&A transaction is not an everyday undertaking – therefore, it is worth calling in professional support. We are an international team with many years of experience in a wide range of transactions and branches of industry. In our practice, we use specialised tools and draw on the expertise of our colleagues in the areas of tax consulting, auditing and accounting. We will map your M&A transaction comprehensively using fully integrated modules within one tool.


  • Operational value drivers: The target's earnings and cash flow simulation considering KPI variables
  • Evaluation: Purchase price optimisation and value driver analysis through DCF and multiples analyses
  • Financing: Simulation of operational financing needs and mapping of purchase price financing
  • Synergies: Transition of the seller's planning into a buyer's planning and valuation model, including synergies and planned structural adjustments
  • Post deal accounting: Taking into account the accounting-related consequences of the transaction as early as the pre-deal phase​

 Accounting Modeling: Passing the Impairment Test with flying colours

According to the German Financial Reporting Enforcement Panel (FREP), goodwill accounting and the accounting treatment of business acquisitions (purchase price allocations, PPAs) are the most frequent sources of error in annual financial statements  and are therefore usually the focus of audits by the competent institutions. Foolproof PPA and impairment test models are essential in order to obtain an unqualified audit report.


  • Standardised tools for carrying out annual impairment tests (IAS 36) and investment book value tests (IDW RS HFA 10)
  • Considering all relevant accounting regulations and their practical implementation in a model
  • Standardised PPA tools, including valuation of intangible assets

 Management Reporting: Figures prepared for the CEO

Imagine having a transparent overview of all company profits and losses at all times, structured in a m​anner that is most suitable for you. With this at hand, you can evaluate the figures on a  monthly and aggregated basis in a few simple steps and have time to analyse the results in detail.


  • Figures made ready for a CFO: the most important insights on a single dashboard
  • An overview of all company-specific KPIs
  • Ongoing target/actual comparisons
  • Automated interfaces in the existing tool landscape
  • Depending on the application, we also support you with the implementation of standardised software, e.g. Lucan​et​

 MODEL AUDIT/MODEL REVIEW: HOW TO MAKE YOUR MODEL FOOLPROOF

Have you already created your own financial model? Congratulations – that is the cornerstone of good entrepreneurship. Or you got a financial model from a third party or need to have it audited because you're taking part in a tender? To ensure that your model works properly, any errors are eliminated, or to make sure that you submit verified financial models for tenders, we offer you an independent and critical model review.


  • Technical check: Verification of mathematical formulas and references within the tool (including professional review software)
  • Structural review: Check for consistent compliance with modeling standards ("golden rules") to avoid future errors
  • Flawless content: Plausibility check of the input parameters and the resulting outcomes
  • Advice and suggestions for optimisation and further development of your model as part of targeted case-adjusted reporting

 Financial Modeling School

​Take your company finances into your own hands! In the practical workshops of our Financial Modeling School you will learn from the professionals:

  • How to design, develop and check a financial model in Excel
  • Base, M&A, or impairment modeling – the choice is yours
  • Efficient learning: online workshop in small groups

 Further topics from Corporate Finance

Contact

Contact Person Picture

Christoph Hirt

Partner

+49 711 7819 144 77

Send inquiry

Contact Person Picture

Cyril Prengel

Partner

+49 911 9193 3350

Send inquiry

Deutschland Weltweit Search Menu