Merger, Valuation and LBO Modelling
-
With this course, I learned multiple new financial modeling tools. Also, some new information about LBO deal structuring. I've gained knowledge about financial rates analysis.
← | →
-
The access to the delivery of the technical content was a blend of theory with practice. It was a proporcionate combination. Good course.
← | →
-
I appreciated building the distinct steps of the full BS/ CF/ P&L model.
← | →
Course
In London
Description
-
Type
Course
-
Level
Intermediate
-
Location
London
-
Class hours
7h
-
Duration
3 Days
To enhance delegate's Excel modelling skills and learn how to structure models so that they can be used to analyse particular transactions such as leveraged buy outs (LBOs), mergers and acquisitions (M&A), as well as examine DCF valuation impacts. Suitable for: Analysts, executives, associates and managers who would like an opportunity to imporve their Excel financial modelling skills.
Important information
Documents
- Excel financial modelling course outline
Facilities
Location
Start date
Start date
About this course
None
Reviews
-
With this course, I learned multiple new financial modeling tools. Also, some new information about LBO deal structuring. I've gained knowledge about financial rates analysis.
← | →
-
The access to the delivery of the technical content was a blend of theory with practice. It was a proporcionate combination. Good course.
← | →
-
I appreciated building the distinct steps of the full BS/ CF/ P&L model.
← | →
Course rating
Recommended
Centre rating
Orville
Tammie
Kaitlyn
Mark
Anonymous
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 14 years
Subjects
- Financial Training
- Financial
- Mergers and Acquisitions
- MS Excel
- Excel
- Skills and Training
- Transactions
- Financial Modelling
- Excel Modelling
- LBO
- Valuation
Teachers and trainers (1)
Course Tutor
Senior trainer
This programme is taught by an experienced corporate finance practitioner. Please click on www.financialtrainingassociates.com for further details.
Course programme
EXCEL FINANCIAL MODELLING FOR A MERGER, LBO (LEVERAGED BUY OUT) OR VALUATION - THREE DAYS
This course equips participants for analysing, valuing and modelling complicated transactions such as mergers, acquisitions or LBOs (leveraged buyouts). It improves participants’ understanding of the attractions and risks of mergers, acquisitions and levered structures, as used by corporates and private equity firms.
By the end of this course, participants will understand:
- Drivers on M&As (mergers and acquisitions)
- How to model integrated financial statements
- How to clean and adjust source data
- How to use financial statements to value a business
- How to model the balance sheet impact of acquisitions, spin-offs and demergers and prepare pro-forma acquisition accounts
- How to analyse and differentiate between financing and operating synergies
- How to model and present the impact of changes in deal structure, financing mix and capital structure, together with the impact on value
- How acquisition debt facilities can be structured and modelled
- Drivers on debt capacity and the interests of debt holders
- The impact of the choice of financial instrument such as equity, debt or hybrid
- Risks and rewards to different parties.
Additional information
Credits/Points: 18
Students per class: 10
Merger, Valuation and LBO Modelling