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
04/19 - 04/20/2023 ONLINE
21.11. - 22.11.2023 ONLINE
EUR 2.100,- plus VAT.
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.
- 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)
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).