- Financing through debt - Know the main LT and CT funding tools and levers, the reasons for favoring debt
- Modelling, simulation, scenarios - Know business modeling, simulation, optimization, what-if analysis
- Return on Equity (ROE) and Leverage - ROE (return on equity) – – DPS (dividend per share) – Payout -TSR (total share return) – Financial leverage
- ROCE Value Creation (ROIC), WACC - Value creation: ROCE (ROIC) - WACC - Return on capital employed - Assets turn - Capital intensity
- Spreadsheet for finance (Excel ) - Master the spreadsheet tool for finance
Target audience
- Bankers / Account Managers
- Consolidation and Accounting Directors
- Financial Directors and Controllers
- Financial managers
- Treasurers
1 day
New training
Prerequisite
Proficiency in Excel and financial literacy
Objectives
– Acquire a concrete and accessible approach to become better at financial modeling
– Know how to ensure consistency of the model between income statement, balance sheet and cash flow and optimize financial indicators
– Be able to perform constrained simulations and set objectives
Detailed content
> Financial modeling
– Chain and consistency
– The Cash Model ® by FinHarmony
– Input data dynamics, variability, measure approach to risk
> Leading influencing factors and how to model them
– Volume/mix/churn effects
– Modeling growth and its limits
– Sales price dynamics, sales price index and pricing effects
– Economics (inflation, exchange rates, commodity prices)
– Purchase price and purchase index
> Operating cause and financial effect
– Identifying key variables and productivity levers
– Linear and non-linear impact curves (exponential, semi-log, log-log, logistics)
– Marketing and promotions actions, costs and benefits
> Cash Model ®
– Business flow modeling
– Method for dynamic forecasting of balance sheet items related to the business cycle (WCR)
– Simulation of growth and sustaining investments with their impacts
– Modeling financing flows
– Consideration of hazards
– Simulation, boundary identification and optimization search (using Excel Solver)
> Business case: building a comprehensive cash flow optimization model
Why should you attend?
What is the maximum growth rate of my company that stabilizes its debt?
Having an integrated model that simulates the business, manages the impact of revenue and cost drivers, considers financing, and reflects contingencies and improvement actions. You dreamed of it? FinHarmony did it!
Your ideas and suggestions to Management will be more robust, fact-based, complete and grounded. Hence, decision-making will be better prepared.
Training methods and assessment
The training relies heavily on Excel templates (provided) including the Cash Model ® by FinHarmony.
Assessment questionnaire.
A training certificate is delivered at the end of the session.
The trainer is available by e-mail and telephone to answer any follow-up questions participants may have.
Price
1 020 € Excl. VAT- 1 224 € Incl. VAT
Médias
Témoignages
Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum.
Jonathan C.
Entreprise
Formation