- Creation of value ROCE (ROIC), WACC - Creation of value: ROCE (ROIC) - WACC (WACC) - Return on capital employed - Rotation des actifs (assets turn) - Intensité capitalistique (capital intensity)
- Modeling, simulation, scenarios - Modeling, simulation, scenarios
- LT and CT financing methods - Understanding the main LT and CT financing methods
- Financial profitability (ROE) and leverage - ROE (return on equity) - Return on equity - DPS (dividend per share) - Payout ratio - TSR (total share return) - leverage - leverage effect Revenues (sales) - Sales recognition - Contract analysis - Performance obligation - Price allocation
- Spreadsheets for finance (Excel ) - Mastery of spreadsheets for finance
Mastering a complex environment
Target audience
- Bankers / Account managers
- Financial controllers
- Financial directors and controllers
- Accounting managers
- Financial members of executive committees
- Financial managers
- Treasurers
1 day
Excel financial modeling training
Prerequisites
A good command of Excel is recommended.
Objectives
◗ Acquire a concrete and accessible approach to become more efficient in financial modeling
◗ Ensuring model consistency between income statement, balance sheet and cash flow
◗ Optimizing financial indicators
◗ Explore complex choices through constrained simulation to set goals
Training program
◗ Adopt a structured approach to financial modeling
- Building a model: key stages (background, assumptions, states)
- Applying good modeling practices
- Synthesize and make a visual presentation
- Identify constraints and define scenarios
- Appendix: stages in model construction
✔ UNDERSTAND | Illustration: the "3 legs" of financial modeling
✔ ASSESS | Quiz: what do you think... What's a financial model for?
✔ APPLY | Case study: step-by-step reconstruction of a financial modeling diagram
✔ APPLY | Case study: building a dynamic synthesis
◗ Forecasting cash flows and structuring financing
- Ensuring consistency between income statement, balance sheet and cash flow
- Direct and indirect cash-flow forecasting methods
- Dynamic forecasting methods for balance sheet items linked to the operating cycle (WCR)
- Structuring financing: capital, debt, debt characteristics, distribution strategy
distribution strategy, project financing
- Appendix: indicator sheets
✔ APPLY | Case study: complete the balance sheet and cash flow statement of a model using
given assumptions
✔ EXPERIMENTATE | Workshop: analyze the financing of a project.
✔ EVALUATE | Several quizzes: in your opinion...
- What elements are a source of lag?
- What is the average payment time and how many days do we have in receivables
receivables on the balance sheet?
- What is the right level of dividends?
◗ Explore complex choices, optimize and simulate
- Answering questions using the model (using Target Value)
- Optimize under constraint and relax constraints according to an objective
(using the Solver)
- Perform a sensitivity study to improve knowledge of the model
✔ APPLY | Case study: building an automatic sensitivity study
✔ EXPERIMENTATE | Workshop: defining an optimal distribution rate based on shareholder flows
✔ EVALUATE | Case study: answer questions about the model
Why choose this course?
What is the maximum growth rate for my company that will stabilize its debt?
Having an integrated model that simulates the business, manages the impact of revenue and cost drivers, takes financing into account, and reflects contingencies and improvement actions: you've been dreaming about it. FinHarmony has done it. Your proposals will be more robust and well-argued, and decision-making will be better prepared.
Teaching and assessment methods
Before : self-assessment quiz
During the session : The training is largely based on Excel models (supplied), in particular the Cash Model ® FinHarmony. Contextualized discussions and numerous case studies ensure that skills are acquired at every stage.
After : The participant keeps all Excel templates.
The trainer is available to answer any questions relating to the training.
Price
1 295 € EXCL. TAX
Testimonials
Excel financial modeling training
Excel financial modeling training
Excel financial modeling training
Jonathan C.
Company
Training