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.
£150 +VAT
Financial Modelling: Building a Model
£150 +VAT
365 days’ access
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
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.
26 reviews for Financial Modelling: Building a Model
You might also like
Take a look at some of our bestselling courses
David Selfe –
The content and explanations were very easy to understand
Alastair Leahy –
Excellent course with very helpful guides, videos and excel sheet templates.
Viktar Sakalouski –
Great
Stephane Dardel –
I loved the fact that there was some practicle Excel examples. It made the course much more relevant and interesting.
Melissa Simmons –
I loved that there were lots of examples and data to follow along with. The information was very well presented and clear.
Shahibur Alam –
excellent
Anjani Kumar –
This was good at reinforcing my understanding.
David Archer –
very good grounding and reminder
Gerard Archbold –
Course provides a good overview of modelling and introduces techniques and tools to utilize without turning course into a Excel course
Toni Grinham –
Clunky module. Didn’t offer too much value
Keith Holmes –
Good external reference material Good Excel models provided to complement learning Some useful hints and tips for Excel modelling
Sydney Matiringe –
It is a well structured course, but the downside for me is the assumption that participants are already versatile in Excel. It will help if some the excel concepts are explained, especially the formlae
Pauline Borg –
enjoyed the course, was very informative and practical
Nick Rudderforth –
Plenty of useful insight and new ideas!
Lara Sorrentino –
Great course for beginners – found the reflective process a good tool to relate the workings to day to day activities/periodic reports, the training was setup in a good format that kept attention
Breege Timoney –
Course was a bit more basic than I had expected
Nyasha Mkombo –
Excellent!
Gemma Bryce –
Great overview but I did note an audio mismatch and an error in one of the workbooks.
Sylwia Wyborska –
I would expect more information about Excel features useful in financial modelling.
Matthew Cooper –
Really good course for those looking to work on their reporting and presentation skills. It helps to understand how to strategically prepare a financial model for various users of the data, and best ways to ensure information is reliable and accurate.
Collette Alexander –
Easy to understand
Kanako Womersley –
It was good to recap and brush up skills
Allan Young –
Provided helpful explanations to enhance my model building skills, introduced me to concepts I hadn’t previously considered.
Heather Bamforth –
Easy to understand
Yuk Yu Pun –
easy to understand
Simone Eastmure –
Very relevant for my role as a FC