About private equity

How private equity invests in privately-owned businesses, supports jobs and creates prosperity.

Members

Login to access your exclusive member-only content and account information.

Login

Not a member? Join us

  • Operate to the highest level of professional standards
  • Access authoritative industry research and data
  • Navigate the complex EU regulatory environment
  • Network and engage with industry leaders
Financial Modelling Image

Financial Modelling

Online training
31 Mar - 1 Apr 2021
Add to calendar 2021-03-31 09:00 2021-04-01 16:30 Europe/Brussels Financial Modelling How to build robust forecasting models and apply them to forecasts for reporting, including income statements, balance sheets and cash flow statements.
Share
Overview Practical information
Overview

What is it?

The course programme includes:

  • Structuring the forecast process and model
  • Performing historical financial ratio analysis
  • Analysing industry, strategy and key business drivers
  • Building an operational model from the underlying business drivers
  • Forecasting integrated financial statements
  • Balancing the balance sheet from the cash flow statement
  • Sensitivity and scenario analysis

The seasoned lecturer of this training course is Hans Haanappel. Hans specializes in financial modelling and valuation analysis. He advises various large & mid-sized privately held firms in valuation, mergers and acquisitions, damage calculations and capital budgeting. He has also been engaged as an advisor in the valuations and financial modelling for several private equity transactions.

In order to enhance interactions we will only accept a limited number of participants.

Why should you attend?

This 2-day course focuses on best practices and is aimed at private equity professionals who want to develop practical skills in building forecast models of financial statements in excel starting with the analysis of historical financial performance.

The financial model will be structured from the underlying business drivers and translated into a high quality operating model that result in a fully integrated forecast of income statement, balance sheet and cash flow statement.

Who should attend?

The course is most suitable for professionals such as Financial Accountants, Controllers, Portfolio Managers, Associates & Analysts who are involved in building financial model to evaluate investment opportunities.

The prerequisites of this course are basic excel, finance and accounting skills. Please note that although excel is used extensively and that maximizing the usage of excel is touched upon to support the modelling, this is not an excel training.

Practical information
Venue

This training course will take place online.

 

Programme

WEDNESDAY 31 MARCH 2021

09.00 - 10.30 CET Introduction and performing historical financial analysis

10.30 – 10.45 CET Coffee break

10.45 – 12.30 CET Performing historical financial analysis (continued)

12:30 - 13:30 CET Lunch

13.30 – 15.00 CET Strategy and industry analysis and how to structure and build a forecast model

15:00 - 15:30 CET Coffee break

15.30 – 17.30 CET Forecasting income statement


THURSDAY 1 APRIL 2021

09.00 – 10.30 CET Forecasting the income statement (continued)

10.30 – 10.45 CET Coffee break

10.45 – 12.30 CET Forecasting the Balance Sheet

12.30 –13.30 CET Lunch

13:30 - 15.00 CET Forecasting the balance sheet (continued)

15:00 - 15.30 CET Coffee break

15.30 – 17.00 CET Forecasting the cash flow statement and balancing the balance sheet

Speakers

To view the speaker profiles, please click here

Accommodation

This training course will take place online.

 

Fees, method of payment and cancellation

Course Fee (excluding accommodation)

Invest Europe Members: €1,200

Non-members: €1,660

21% VAT will be added to Belgian-based participants.

The above prices also include all training material relating to this course.


Payment

Participants are requested to pay by cheque, banker's draft, bank transfer or credit card in EURO as shown on the Application Form. Applications sent after 28/02/2021 should be paid by credit card.

Bank transfers: should be made net of bank charges and commission to the following bank: ING Avenue Marnix 24, B-1000 Brussels

International bank transfer account number: IBAN BE33 3300 5785 0046 SWIFT/BIC: BBRUBE BB

Domestic bank transfer account number: 330-0578500-46

A copy of the bank transfer should be sent together with the application form. To avoid any confusion, participants are requested to indicate clearly their names and addresses on transfer orders and cheques. Confirmation of registration for fees and practical information will be sent after receipt of the application form and payment. For late registrations (see above), we require payment via a credit card.


Cancellation

Cancellations can only be accepted if received (in writing) by 28/02/2021. Fees (less 20% administrative charges) will then be refunded. After this date, delegates will be liable for the full fee.

In case of cancellation, a substitution between members of the same company is still possible at any time.

Language

The working language of the course will be English.

Registration

To register for Invest Europe's Financial Modelling course, the candidate should submit the application form and proof of payment. Invest Europe maintains the right to refuse the registration if it is not accompanied by all the supporting documents.

Due to the high demand for Invest Europe Training courses, priority is given to Invest Europe's members. Registrations will be handled on a first-come-first-served basis. Any registration received after 28/02/2021 should mention a credit card number for the payment of course fees.

Share

What can I do to manage cookies stored on my computer or phone?

You can accept or refuse cookies. Accepting cookies is usually the best way to make sure you get the best from a website.

Most PCs automatically accept them but you can change your browser settings to restrict, block or delete cookies if you want. Each browser is different, so check the 'Help' menu of your particular browser (or your mobile phone's handset manual) to learn how to change your cookie preferences. Many browsers have universal privacy settings for you to choose from.

Help on how to set and customise your cookie settings for your browser

How to manage cookies in Internet Explorer

Cookie settings in most versions of Internet Explorer can be found by clicking the tools option and then the privacy tab.

How to manage cookies in Firefox

Cookie settings in Firefox are managed in the Options window's Privacy panel. See Options window - Privacy Panel for information on these settings.

How to manage cookies in Chrome

Click on the spanner icon on the toolbar, select settings, click the under the bonnet tab, click on content settings in the privacy section.

How to manage cookies in Opera 

You can manage cookies in Opera if you Click on settings, then Preferences, then Advanced and finally Cookies

How to manage cookies in Safari

Choose Safari, then preferences and then click security. You should then be able to specify if and when Safari should accept cookies.

To manage cookies on your mobile phone please consult your manual or handbook.

Get more help about how cookies work with specific browsers.

What happens if I don't accept cookies?

If you decline cookies, some aspects of Invest Europe site may not work on your computer or mobile phone and you may not be able to access areas you want on the website. For this reason we recommend that you accept cookies.

What happens if I delete my cookies?

If you delete all your cookies you will have to update your preferences with us again and some aspects of our site may not work.

What happens if I change computers or mobile?

If you use a different device, computer profile or browser you will have to tell us your preferences again.

If you'd like to learn more about cookies in general and how to manage them, visit aboutcookies.org.

We can't be responsible for the content of external websites.

Opt-out of cookies

Login

Join today

This is for members only. To view in full login or join Invest Europe today.