Financial Modeling for the Finance Department 2022 - Mannhein (B) | Schwabe, Ley & Greiner | 10 October 2022 | TBA , Mannheim - Online

Not only the Covid crisis has underlined the importance of integrated corporate planning for the simulation of a wide variety of scenarios. Well-founded simulation results "at the push of a button" are also decisive when evaluating investment projects or savings programs. We have years of experience from customer projects in the modeling of business plans, project financing or M&A projects. On this basis, we have designed a 2-day training in which the participants, with our support, build their own financial model. The financial model includes flexible input factors as well as automatic checks to check the model consistency and is created according to the internationally recognized FAST standards. The results of the financial model provide the answers to the central treasury questions: liquidity requirements,

Main topics:

Basics for practice.
• Financial modeling: goals, golden modeling rules, international FAST standard.
• Accounting: model-relevant relationships between income statement, balance sheet and cash flow statement.
• Excel: Tips on helpful settings, avoiding circular references.

Development of a financial model based on a case study.
• Basic structure: structure of the input sheet and technical auxiliary calculations (timing, counters, flags, indexing, etc.).
• Operational planning: Modeling the revenue structure and cost drivers.
• Structuring the financing: Modeling a repayment.
• Loan and a working capital line (utilization taking into account blocked / trapped cash).
• Working capital: Modeling the trade / net working capital (based on DSO, DIO, DPO, etc.).
• Taxes: Modeling tax implications.
• Dividends: Modeling of distributions taking into account limitations (e.g. retained earnings).

Creation of a management cockpit and reporting.
• Liquidity requirements: Deriving liquidity peaks and the financing requirements, taking into account off-balance sheet positions and the cash swing.
• KPI analysis: Monitoring of financial covenants and common KPIs (working capital, etc.).
• Credit assessment: Rating creation based on standard market key figures.
• Sensitivity analyzes using selected value drivers.

Group of participants;
Employees and managers who work in or are responsible for corporate finance as well as corporate customer advisors from banks who want to get to know their customers' day-to-day business from their perspective (participants need basic knowledge of accounting and Excel for the training)

Goals
After a short introduction to basic knowledge relevant to the model (financial modeling, accounting, Excel), the participants set up their own, integrated financial model in Excel. Finally, a management cockpit is created with reports on the most important questions from the perspective of the finance department or treasury (liquidity, key figures, creditworthiness).

2022 Speakers

Bernhard Kopinits
Senior Consultant, Schwabe, Ley & Greiner

Christof Kornfeld
Senior Consultant, Schwabe, Ley & Greiner