Budgeting and financial planning in Excel

Budgeting and financial planning in Excel

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

Registration | Budgeting and financial planning in Excel

Next dates: 25 and 26 November 2024 in Luxembourg City