//Financial Modelling

Financial Modelling

Start your career in financial modelling with a course to build the  financial statements and business projections.

 

225,00

Category:

Description

Description

Financial modelling is a professional skill increasingly sought after, especially in the financial sectors.

The main banks and investment funds, increasingly, demand a profile with a solid base in the construction of financial models, since an important part of their day to day involves the design and creation of models, as well as, the management of Excel. In fact, it is very common for candidates to be given a modelling technical test.

It’s for this reason, we developed this module. In it you will find several examples of financial modelling tests, as they are presented in real situations. Each test includes the solution, and an estimated time of execution, so they will serve as practice for an interview, or as basic preparation for modex certification.

Learning objectives:

  • How to start and build a business plan.
  • Understand the importance of financial modelling in the decision-making process of a company.
  • Work with Excel: we will learn to prepare the work field (sheet, cells, formats and basic functions) as well as the use of graphs and dynamic tables.
  • Excel and its use as a financial tool: in this module, we will focus on the financial functions that Excel offers us for calculation and analysis. In addition, we will learn to create scenarios and use flags.
  • An integrated model: the objective of this module is to be able to build your own financial model, developing the financial statements of a company and learn to calculate cash flows and even an approximation to the valuation.

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. She is the founding partner and CEO of modelandum.

 

Linkedin Profile

 

 

 

Course content

This course consists of 19 online lessons with a total duration of almost 8 hours including videos and practical exercises. In addition, study and reference material with Excel files to practice and their solutions are included.

  • Chapter 1 – INTRODUCTION
  • Chapter 2– TYPES OF FINANCIAL MODELS
  • Chapter 3–FIN. STATEMENTS I
  • Chapter 4–FIN.STATEMENTS II
  • Chapter 5–CASH FLOW METHOD (INDIRECT)
  • Chapter 6 –CASH FLOW METHOD (DIRECT)
  • Chapter 7–CASH FLOW METHOD (EBITDA)
  • Chapter 8–FREE CASH FLOW CALCULATION
  • Chapter 9–HORIZONTAL MODEL BUILDING
  • Chapter 10 – TIMELINE
  • Chapter 11–FINANCIAL STATEMENTS INTEGRATION
  • Chapter 12–REVENUES&ACCOUNTS RECEIVABLE
  • Chapter 13– COGS & INVENTORY
  • Chapter 14 – OPERATING EXPENSES & START UP COSTS
  • Chapter 15 – DEPRECIATION, CAPEX & NET FIXED ASSETS
  • Chapter 16 – TAXES
  • Chapter 17 – CAPITAL STRUCTURE: DEBT & EQUITY
  • Chapter 18–UNLEVERED FCF
  • Chapter 19–OUR MODEL IN CONTEXT

Who is it for?

  • This course is specially designed for students and junior professionals who want to focus their first professional steps to the financial sector (banks, funds, etc.), consultants, business financial departments, audit sector and all those sectors in which the Excel tool is basic for daily work.
icono-telefono+34 91 057 97 69 icono-whatssup+34 619 817 391 +info@modelandum.com