Example Courses
Financial Modelling Example Training Courses
Testimonials
“The Pre-course modelling manual and spreadsheets really helped me to prepare for the training.”
Introduction to Financial Modelling
Global Wholesale Bank
“This was one of the best trainer I met in the ten years at the bank. He has deal experience , is capable, patient and flexible. ”
Financial Analysis Modelling Bootcamp
Global Wholesale Bank
“I enjoyed the course and believe I have taken on lots of information, which will be effectively used at work on a daily basis”
Capital Markets Financing
Full Service Investment Bank, Hong Kong
“Great Process, Structure and build of knowledge during the course. ”
Advanced Modelling Training
Global Wholesale Bank
Financial
Modelling
Modelling
Bootcamp
Modelling and
Valuation and Training course
-
Some Excel basics and the basics of design
-
Excel tricks and shortcuts
-
Excel fucntions
-
Math & Trig functions
-
Excel tool
-
Excel shortcuts
Financial Modelling in Excel
-
Excel basics
-
Building the framework
-
Forecasting the income statement
-
Fixed assets
-
Working capital
-
Balancing the balance sheet
-
Linking the cash flow statement
-
Building a debt schedule
Financial Modelling Introduction
-
Building the framework - intermediate
-
Building the schedules
-
Forecasting the income statement - intermediate
-
More complex issues
-
Fixed assets - intermediate
-
Working capital - intermediate
-
Balancing the balance sheet - intermediate
-
Net income and shareholder’s equity
-
Balancing - straightaway
-
Linking the cash flow statement - intermediate
-
Building a debt schedule - intermediate
-
Ratio analysis
Intermediate Financial Modelling
Advanced Modelling
-
How much to pay?
-
Transaction analysis
-
Financing the deal
-
Modelling M&A transactions
M&A Modelling
-
Structuring project finance
-
Assumptions
-
Building the financial statements
-
Debt and equity financing
-
Structuring
-
Pulling it all together
Project Finance Modelling
-
Valuation and modelling
-
Correct cash flows
-
Cost of capital
-
Terminal values
-
Relative valuation in context
-
Relative valuation multiples
-
Relative valuation model
Corporate Valuation Techniques
-
LBO overview
-
LBO deals
-
Financing alternatives
-
Basic modelling structure
-
Advanced structures
-
LBO tools for modelling
-
Forecasting for LBO's