Financial Modeling

​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​
  

​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​
  

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​

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
  

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​

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

 ​

« Back to the overview of our Audit Services​​​​