- Cash management - Mastering cash management tools : - Cash management techniques: cash pooling, SEPA - Master the nature of settlements and processing techniques - Know and know how to use operational levers for cash optimization - Understand banking circuits and conditions, and interest rates - Understand payment methods and know how to contribute to their development
- Public institutions and bodies - Learn about public institutions and bodies: Autorité des marchés financiers (France, International), Autorité des normes comptables, IASB, EFRAG, Autorité de la concurrence, parliamentary committees, etc.
- LT and CT financing methods - Understanding the main LT and CT financing methods
Mastering a complex environment
Target audience
- Bankers / Account managers
- Project managers
- Sales representatives
- Management controllers
- Chartered accountants
- Financial managers
2 day
New training
Prerequisites
It is recommended that you have taken the "Elaborating your Business Plan" module [FHBUSI] and have a good command of Excel.
Objectives
◗ Manage a project's financial performance by linking it to operational levers
◗ Integrating the variability of input data
◗ Perform risk and opportunity analyses, sensitivity studies and advanced simulations
◗ Improving decision-making in this way
Contents
◗ Structuring a coherent forecasting model
- Why make a business plan?
- Project profitability and business strategy
- Gathering input data, calculating cash flows and measuring indicators
(NPV, IRR, Payback, maximum overdraft), cash curve and interpretation of results
- Taking operational actions and productivity into account
✔ UNDERSTANDING | Illustration: action levers and effort curves
✔ APPLY | Case study: mastering the transition from one version of the BP to another
✔ EVALUATE | Quiz: 12 questions to validate prerequisites
◗ Integrate the level of risk into decision-making
- Risk perception: 4 perspectives
- Factoring risk into the discount rate
- Provisions for contingencies in the business plan and risk/opportunity analysis
- Scenario building and variance of business plan results
- Taking decisions into account and the value of a decision
- Multi-company BP and risk sharing
✔ UNDERSTAND | Illustration: diagram of risk consideration in a BP
✔ EXPERIMENT | Simulation: perception of gain and loss, risk aversion
✔ EVALUATE | Quiz: in your opinion... What to do in a totally uncertain universe? 5 approaches
◗ Take into account the origin, reliability and variability of input data
- Cost estimation methods (analogical, parametric, analytical)
- Cost structure approach: economies of scale and learning curve
- How are costs allocated to project activities?
- Cost optimization methods and Design To Cost
- Data volatility, uncertainty and variability
- Impact of deadlines and delays: planning (prospective vision, contextualized vision
contextualized and retrospective views), Estimate At Completion and
and cost variance analysis by origin of cause (top down and bottom up),
contributions of Earned Value Management (earned value, SPI and CPI)
✔ APPLY | Case study: 6 categories of variables affecting projects
✔ EXPERIMENTALIZE | Workshop: quantification and measurement - ways of putting things under control
✔ EVALUATE | Quiz: what do you think... How do you assess risk utility?
◗ Master simulation and optimization tools
- Single- and double-entry data tables for sensitivity studies
- CHOISIR() function, nested IS, dynamic links to create scenarios
- Use Target Value to achieve a financial objective
- Use the Solver to optimize a financial result according to constraints
✔ APPLY | Case study: create an automatic simulation from a target variable
✔ EXPERIMENTATE | Excel workshop: use the Solver to optimize a model
✔ EVALUATE | Quiz: what do you think... How do you accept or reject a result?
Why choose this course?
This high-level course is based on business plan modeling . It covers the economic aspects of project management, taking uncertainty into account, and goes into greater depth on the management dimension. A business case based on a complex model illustrates the concrete implementation of each approach.
Teaching and assessment methods
Before : self-assessment quiz and background information on the topic
During the session: alternating theoretical developments and illustrations drawn from real-life situations. The training is based on a complete Business Plan model at the advanced level. Progressive application of the knowledge acquired through practical case studies and discussions during the session ensure that the participants are fully conversant.
After: the Excel templates used are made available.
The trainer is available to answer any questions relating to the training.
General training | FinHarmony Conseil & Formation
See our full training catalog.
Price
2,090 EXCL.
Testimonials
Advanced business plan training
Advanced business plan training
Advanced business plan training
Advanced business plan training
Jonathan C.
Company
Training