/, UNIVERSITARIOS/Financial Modelling (Eng)

Financial Modelling (Eng)

This modelling course sets the basis for becoming a fluent financial modeller. It is based on a simple case, but the concepts learnt are critical to then be able to understand more complex transactions or sector based models. The course helps you to think clearly about the correct approach to build a model and understand it.

 

225,00

Description

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)

COURSE DETAILS

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.

Category: Universitarios

Paula Gómez Medina

Paula has been working in the financial services industry for over 18 years. She started working for ABN AMRO as an analyst and then continued her career in financial services in GE Capital in various divisions such as Real Estate, Leasing, Private Equity and Consumer Lending. She founded modelandum in 2004 and since then has been involved in financial modelling, primarily in Private Equity projects. Paula has built many customized models for funds and delivered modelling workshops for different universities including London School of Economics, King College, UCL, LBS, IE, ESADE, IESE and hundreds of individuals. She is also a regular judge at the IESE PE competition. She is the founding partner of modelandum.

 

Perfil Linkedin

 

 

 

Course content

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.

icono-telefono+34 91 057 97 69 icono-whatssup+34 619 817 391 +info@modelandum.com