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

Brussels - Belgium
9 - 10 Apr 2020
Add to calendar 2020-04-09 08:30 2020-04-10 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.
Download PDF 289.75 KB
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

TBC Brussels

 

Programme

THURSDAY 9 APRIL 2020

8.30 – 9.00 Registrations

9.00 - 11.00 Introduction and performing historical financial analysis

11.00 – 11.30 Coffee break

11.30 – 13.15 Performing historical financial analysis (continued)

13:15 - 14:00 Lunch

14.00 – 16.00 Strategy and industry analysis and how to structure and build a forecast model

16:00 - 16:30 Coffee break

16.30 – 18.30 Forecasting income statement

19.30 - 22.00 Networking Dinner in the city centre


FRIDAY 10 APRIL 2020

9.00 – 10.30 Forecasting the income statement (continued)

10.30 – 10.45 Coffee break

10.45 – 12.30 Forecasting the balance Sheet

12.30 –13.30 Lunch

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

15:00 - 15.15 Coffee break

15.15 – 16.30 Forecasting the cash flow statement and balancing the balance sheet

Speakers

To view the speaker profiles, please click here

Accommodation

TBC Brussels

 

Fees, method of payment and cancellation

Course Fee (excluding accommodation)

Invest Europe Members: €1,600

Non-members: €2,215

21% VAT will be added.

The above prices also include all material relating to this course as well as coffee breaks, lunches and dinners for the duration of the course. Hotel accommodation is not included in the course fee.


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 09/03/2020 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 09/03/2020. 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 09.03.2020 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.