Financial Statement Modeling and Forecasting Training

Following the successful delivery of several training programs on “hard” corporate finance skills in the Netherlands, London, New York and Asia I offer since 2015 an open programme primarily focussed on analyst and associates of investment banks, corporate finance boutiques, corporate finance advisors, private equity firms, M&A departments of corporates and equity analyst. Based on my experience as an active corporate finance advisor/valuator and being affiliated with several universities, I will provide the courses with a nice blend between practice and theory. Participants of the training programme will improve their hard corporate finance skills and will be able to apply the learnings immediately after the modules in their day-to-day work. Furthermore, the training program gives the delegates an opportunity to network with their peers. 

The main objective of this course is that participants will develop practical skills to build a financial forecast model in excel from scratch. The financial model will be structured from the underlying business drivers and translated into a forecast model including a fully integrated Income Statement, Balance Sheet and Cash Flow Statement. Approximately 50-60% of the time, the students will work on a real life excel based case in class to develop the financial forecast model. 

• Introduction to financial modelling
• Structuring the forecast process
• Analysing industry trends and strategy
• Performing historical ratio analysis
• Forecasting Income Statement
• Forecasting Balance Sheet
• Forecasting Cash Flow Statement
• Balancing the Balance Sheet from the Cash Flow Statement

Prerequisites are: basic accounting and corporate finance knowledge and excel skills

Participants have to bring their laptop along and a pre course instruction will be sent before the course starts. The course venue is located on the Zuidas in Amsterdam (Atrium, Strawinskylaan 3051, first floor). The course venue is located nearby metro/train station Amsterdam Zuid. Lunch and drinks are included. The course will be held in English unless all of the particapants are Dutch. 

Hans Haanappel