Financial Modeling for the Finance Department

Development of an integrated financial model in Excel to simulate scenarios, liquidity requirements as well as financial covenants and rating implications

Dates & Place

04/19 - 04/20/2023 ONLINE
21.11. - 22.11.2023 ONLINE

Level

Special knowledge

Duration

2 days

Costs

EUR 2.100,- plus VAT.

Speakers

Bernhard Kopinits

Senior consultant

Schwabe, Ley & Greiner

Christof Kornfeld

Senior consultant

Schwabe, Ley & Greiner

Content

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

Registration

Main topics

Basics

What are the tasks of the cash manager in the company?
What are the minimum standards to be taken into account in the organizational structure & process organization?
What are the differences in the accounting or treasury perspective? Which business management approaches do you need to understand?
What are the requirements vis-à-vis banks?
What are the current trends in cash management for large and small companies?

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.

Structure of the financial model based on a case study

Basic structure: Structure of the input sheet and auxiliary technical calculations (timing, counters, flags, indexing, etc).
Operational planning: modeling the revenue structure and cost drivers
Structuring of the financing: modeling of a redemption
loan and a working capital line (utilization taking into account blocked/trapped cash)
Working capital: modeling of trade/net working capital (using DSO, DIO, DPO, etc)
Taxes: Modeling Tax Implications
Dividends: Modeling of distributions under consideration of limitations (e.g. retained earnings)

Creation of a management cockpit and reporting

Liquidity requirements: derivation of liquidity peaks and funding requirements, taking into account off-balance sheet positions and cash swing
KPI analysis: monitoring of financial covenants and common KPIs (working capital, etc)
Creditworthiness assessment: rating compilation on the basis of standard market ratios
Sensitivity analyses using selected value drivers

Group of participants

Employees and managers who work in or are responsible for corporate finance, as well as corporate account managers from banks who want to learn about their customers' day-to-day business from their perspective (participants need basic knowledge of accounting and Excel for the training)

Targets

After a brief introduction to model-relevant basic knowledge (financial modeling, accounting, Excel), participants build their own integrated financial model in Excel. Finally, a management cockpit is created with reports on the most important issues from the perspective of finance or treasury (liquidity, key figures, credit rating).