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

25.06. - 26.06.2024 ONLINE
27.11. - 28.11.2024 ONLINE


Special knowledge


2 days


EUR 2.100,- plus VAT.

Bernhard Kopinits

Bernhard Kopinits


Schwabe, Ley & Greiner

Christof Kornfeld

Christof Kornfeld


Schwabe, Ley & Greiner


It was not only the Covid crisis that underlined the importance of integrated corporate planning for simulating 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 the 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.

Main topics


  • 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 repayment 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)


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).

Feedback from our customers

The interactive collaboration and the fact that learning-by-doing or direct participation was possible is very helpful.

Do you have any questions?

Marc Baumgärtner

Marc Baumgärtner

Seminar organization

Treasury Training

Other seminars

Liquidity planning: simple, system-supported, future-proof

What to look out for when setting up modern liquidity planning

Risk management for advanced users

Exposure determination, risk calculation and strategy development with smart hedging

Digitalization in Treasury

New technologies and system functionalities

Credit agreements from a financial perspective

Structure, content, scope for design and stumbling blocks

Supply Chain Finance & Working Capital Management

Recognize, understand and realize potentials

Financial strategy, rating and credit agreements

Creditworthiness as the basis for financial strategy considerations and its influence on financing options and contract content

Portfolio management for investors and debtors

From theory to risk and return calculation to policy and performance measurement

Hedge Accounting and Accounting for Treasurers

Presentation of derivatives and hedging relationships in the balance sheet according to HGB/BilMoG, UGB and IFRS

Treasury Training