Financial Modelling: Building a Model

by Samuel Ellis

Financial modelling is an invaluable skill for accountants but in the wrong hands, models can be confusing and misleading. This course will enable you to build models to plan for the future, and to anticipate and react to uncertainty and change.

price £75+vat
cpd hours 4 CPD hours
access 120 days' access

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.

Look inside

imac
slide-1
slide-2
slide-3
slide-4
slide-5
slide-1-thumbnail
slide-2-thumbnail
slide-3-thumbnail
slide-4-thumbnail
slide-5-thumbnail

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.

Reviews

Recommended

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Pick n Mix

All you need for this year's CPD.

Licence

All you need for this year and more.

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours4 unitshourshours21 units20 hours21 hours800+ unitshourshours800+ unitshourshours
Access period120 days120 days12 months12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team’s needs
Learn moreLearn moreLearn more
Recommended

Why not upgrade?

Find the best way to complete your CPD

Licence

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Why not upgrade?

Find the best way to complete your CPD

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Why not upgrade?

Find the best way to complete your CPD

Licence

Recommended

All you need for this year and more.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12 months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Course

Need just a few unitshourshours?

Access to this course
Total CPD unitshourshours4 unitshourshours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs

Pick n Mix

All you need for this year's CPD.

Access to this course
Total CPD unitshourshours21 units20 hours21 hours
Access period120 days
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

Team

Keep your whole team up to date.

Access to this course
Total CPD unitshourshours800+ unitshourshours
Access period12+ months
Audit-proof CPD completion certificate
Immediate access to our entire CPD catalogue
Exclusive news and CPD every week plus monthly webinars, all year round
Account manager on hand to support your team's needs
Learn more

You might also like

Take a look at some of our bestselling courses