Financial Modelling: Building a Model
Financial modelling is an invaluable skill for accountants but in the wrong hands, models can be confusing and misleading. This course will teach you to build robust financial models in Excel to forecast future performance, and to measure and respond to uncertainty and change.
£100 +VAT
Financial Modelling: Building a Model
£100 +VAT
Financial Modelling: Building a Model
This course is not currently available. To find out more, please get in touch.
This course will enable you to
- Set up financial models to forecast future performance and guide decision making.
- Model costs to help anticipate potential changes, make appropriate adjustments and remain profitable and competitive.
- Use financial models to estimate revenues, set targets and monitor progress.
- Build financial models that remain relevant over time, by factoring in inflation, indexation, interest and exchange rates.
- Present information in clear and accessible reports and visualisations, to inform decision making.
About the course
Financial modelling has become an invaluable part of finance and an indispensable skill for every accountant. But in the wrong hands, models can be confusing and misleading.
This practical course looks at the various inputs that must come together to enable you to create financial models to plan and prepare for the future. The step-by-step approach to building models, will give you the tools you need to make informed business decisions, protect against potential volatility, and deliver real value to your organisation.
Contents
Setting up a financial model
Starting with the end user
The importance of best practice
The power of Excel
Making the most of Excel
Getting your Excel settings right
What to include in a template
Structuring your model
Setting up the sheets: part one
Costs
Before you start
Getting the right information
Finding further information
The importance of costs
Modelling costs
Revenues
The importance of revenues
Looking for growth
Linear services revenue forecast: part one
Linear services revenue forecast: part three
Controls and checks
Time periods, checks and balances
The importance of time periods
The benefits of modelling time
Choosing the right periods
Flags
Checking your models
Accounting for human error
Keeping models up to date
Cash balances
Inflation, indexation and interest
The importance of inflation and interest
Car price inflation model: part two
Indexation
Interest rates
Deposit options: part two
Foreign exchange
Historical rates
Forex in Excel
Reports and visualisations
End users and you
What the user wants
Reporting to different stakeholders
Presenting your data
Bringing data to life
Summary reports – gold price: part two
Golden rules
How it works
Author
Samuel Ellis
Sam has been using modern data technologies for the past decade to operate a lean and agile accounting function. He uses data analytics software e.g. Tableau to transform accounting reporting in a modern, shareable and actionable format whilst reducing time taken to prepare reports and streamlining content to minimise noise. Sam was a founding member and Chair of ACCA’s Global Technology Forum, steering ACCA’s approach to updating members around key technology developments and trends.
You might also like
Take a look at some of our bestselling courses
