This course will provide you with the technical knowledge you need to start building financial models from scratch, and to fully grasp the key financial concepts around financial statements integration, and company analysis.
Suitable for all students and professionals coming from non-financial backgrounds or with little or no experience in financial modelling, interested in working in a corporate finance environment. This intensive course is led by an experienced professional with applied expertise as an advisor, entrepreneur and lecturer, very intuitive and easy to follow.
The content of this course is ideal as prep work for the modelling expert unis certification (modex unis)
After completing the course, you will be able to:
- Understand the key terminology for building financial models.
- Structure and organize a model in a clear and logical manner.
- Prepare the three financial statements (profit and loss account, balance sheet, cash flow) and the integration, which is key for a robust financial model.
- Understand the difference between operations and financing of a company.
- Calculate the cash flow with three different methods, EBITDA, direct and indirect.
- Understand the key driver for each of the three financial statements.
- Create a fully flexible financial model with scenarios and a clear and robust structure.
The course includes the complete financial model, as well as a template for you to work independently.
The course will take you between 15-20 hours to complete, depending on your level of understanding.
You can refer to the materials at any time and for an unlimited amount of time.
This course consists of 19 recorded online lessons. It should take you between 15 to 20 hours to complete the course and grasp the materials.
In addition, you can download the excel materials in excel to practice and follow the online course.
Chapter 1 – Introduction
Chapter 2 – Types of financial models
Chapter 3 – The financial statements I
Chapter 4 – The financial statements II
Chapter 5 – Cash flow methods – Indirect
Chapter 6 – Cash flow methods – Direct
Chapter 7 – Cash flow methods – EBITDA
Chapter 8 – Cash flow methods, reconciling all 3 and Free Cash Flow calculation
Chapter 9 – Structuring a model – Horizontal model building
Chapter 10 – Structuring the model in excel – Timeline
Chapter 11 – Creating the financial statements and integration
Chapter 12 – Revenues and Accounts Receivable
Chapter 13 – Costs of Goods Sold (COGS) & Inventario
Chapter 14 – Operating Expenses y Start-up costs
Chapter 15 – Depreciation – Capex – Net Fixed Assets
Chapter 16 – Taxes
Chapter 17 – Capital structure: Debt and Equity
Chapter 18 – Unlevered Free Cash flow
Chapter 19 – Our model in context
Who is it for?
This intensive course bridges the gap between professionals and students with the hands-on practical financial skills that they will need to start building models. The course is designed for university students or professional with little knowledge about financial modelling, even if they have a financial background. It is also ideal as preparation work for the modex unis.