What you will learn
- 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.
About this pack
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 courses, you will have built a complete set of financial statements and will be able to repeat this process when building models, including knowledge of the importance of error checks and sensitivity / scenario analyses.
Key information
- 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 have a basic understanding of Microsoft Excel.
- This pack requires you to use (for Windows) Excel 2016 (or newer), Excel for the web or Excel 365; (for Mac) Excel 2021 (Excel 2019 for MAC support will end in October 2023).
- The recommended operating systems for Windows are Windows 10 or 11; for MacOS is Big Sur 11 or later.
- CPD certificate is available upon successful completion of the pack.
