The global body for professional accountants

20
UNITS

Online course | SumProduct

Financial modelling

Learn how to build a financial model from the beginning

Overview

Man in silhouhette

This pack tackles financial modelling and breaks down the seemingly complicated process into small segments that are easily understood.

In financial modelling, it’s important to understand the three primary financial statements: the income statement, balance sheet and cash flow statement, and their key impacts upon the business decision making process. Only through understanding the core concepts can you avoid the common mistakes that people make when working with these three statements.  

Using an Excel workbook, you will work through the courses to develop a small, straightforward model that enables our methods to be demonstrated readily and practiced comprehensively.

At the end of the pack, you will have built a complete set of financial statements and will be able to repeat this process when building models.

You will learn about:

  • CRaFT, which introduces best practice modelling
  • the differences between the three primary financial statements
  • a straightforward, repeatable approach that can be employed again for future financial modelling projects
  • how to balance the balance sheet first time, every time
  • how to reconcile direct and indirect cash flow statements
  • how to avoid common mistakes.
  • This pack contains a collection of interactive slides and videos for you to follow, and exercises for you to complete within Excel.
  • This pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021
  • The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
  • This pack requires you to have a basic understanding of Microsoft Excel.
  • CPD certificate is available upon successful completion of the pack.
  • 12-month access.

Price

Price 300 GBP

Location

Global

Date & time

On demand

Course providers

Logos of ACCA and SumProduct