Merger, Valuation and LBO Modelling

4.3
14 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

In London

£ 2,650 + VAT

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

London
See map
82 Great Eastern Street, EC2A 3JF

Start date

On request

About this course

None

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.3
fantastic
  • 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.
    |
100%
4.5
excellent

Course rating

Recommended

Centre rating

Orville

4.5
11/05/2018
What I would highlight: 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.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Tammie

4.0
11/03/2018
What I would highlight: The access to the delivery of the technical content was a blend of theory with practice. It was a proporcionate combination. Good course.
What could be improved: Everything was positive.
Would you recommend this course?: Yes

Kaitlyn

4.0
11/03/2018
What I would highlight: I appreciated building the distinct steps of the full BS/ CF/ P&L model.
What could be improved: N/A.
Would you recommend this course?: Yes

Mark

4.0
11/09/2017
What I would highlight: I Refreshed my thoughts. It helped me understand big issues with better clarity.
What could be improved: All good.
Would you recommend this course?: Yes

Anonymous

4.5
09/12/2016
What I would highlight: I really appreciated participating in this course and it completely satisfied my expectations. The finest parts of the course were LBO and M&A modelling, debt instruments, Excel hints and modelling best practice.
What could be improved: Everything OK.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

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

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

Career opportunities: This course is designed to improve delegate's Excel modelling abilities.
Credits/Points: 18
Students per class: 10

Merger, Valuation and LBO Modelling

£ 2,650 + VAT