Self-Study Downloads
The following zipped folder contains the self-study materials required to work through the practical exercise which is undertaken as a part of the Financial Modelling Fundamentals training course. This exercise is designed to provide participants with a general understanding of the development of dynamic financial statements within a spreadsheet model - i.e. the creation of live, linked income statements, balance sheets and cash flow statements.
Alternatively, the files within this zipped folder can be downloaded individually by right-clicking on the download links corresponding to each file in the below table and selecting 'Save Target As...' from the displayed shortcut menu:
|
|
|
| File |
Description |
Download |
| 1. |
Theory Book |
• |
Provides an overview of the process used to create dynamic, 3-way financial statements, including a summary of the different types of financial statements impacts. Also discusses the layout of each of the income statement, balance sheet and cash flow statement and the links into these financial statements and between them. |
 |
| 2. |
Training Manual |
• |
Practical, step-by-step instructions governing the creation of basic, dynamic 3-way financial statements. Requires the practical exercise workbook below. |
 |
| 3. |
Practical Exercise |
• |
Skeleton workbook that contains the infrastructure and assumptions around which the user undertakes the steps outlined in the above training manual. |
|  |
| 4. |
Practical Exercise - Solution |
• |
Final solution file against which users can check their practical exercise file either on completion or during the exercise. |
|  |
| 5. |
Financial Statements Impacts Analyser |
• |
Interactive financial statements workbook designed to provide users with an understanding of some of the most common financial statement impacts. |
|  |
For more information about this training course, and any of the other BPM training courses, contact BPM.