The course programme includes:
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.
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.
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.
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
To view the speaker profiles, please click here
Course Fee (excluding accommodation)
Invest Europe Members: €1,600
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.
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.
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.
The working language of the course will be English.
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.
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.
Cookie settings in most versions of Internet Explorer can be found by clicking the tools option and then the privacy tab.
Cookie settings in Firefox are managed in the Options window's Privacy panel. See Options window - Privacy Panel for information on these settings.
Click on the spanner icon on the toolbar, select settings, click the under the bonnet tab, click on content settings in the privacy section.
You can manage cookies in Opera if you Click on settings, then Preferences, then Advanced and finally Cookies
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.
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.
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.
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