Budgeting and financial planning in Excel
Budgeting and financial planning in Excel: module 2/5
French
25 and 26 November 2024
Luxembourg City
20 participants max.
1.400 € EXCL. VAT
1,442 INCLUDING VAT
VAT rate : 3%
Objectives
Taking this course will enable you to develop essential financial modelling and budget planning skills in Excel. You will learn how to create and interpret comprehensive financial statements, enabling you to better analyse the financial health of your business. In addition, you will be able to build interactive models to forecast cash flows and perform sensitivity analyses to assess the impact of economic changes, thereby improving your strategic decision-making. This module follows on from module 1, "Diagnosis and financial planning"..
The content
1- Model and interpret the three financial statements (balance sheet, income statement and cash flow statement)
- Introduction to financial modelling
- Creation of interactive models based on financial statements
- Modelling techniques: financial functions, graphs, formulae
- Structuring data
- Building integrated models: linking financial statements
(balance sheet, income statement and cash flows) - Model validation and verification
- Sensitivity and scenarios: analysing the impact of changes
2- Mastering budgeting and reporting tools
- Presentation of a budget and financial plan
Your Trainer
Pr Guadi KAHIL | Budgeting and financial planning in Excel
- Senior Consultant Valuation, Modeling & Economics - Strategy and Transactions at EY
Registration | Budgeting and financial planning in Excel
Next dates: 25 and 26 November 2024 in Luxembourg City