Is the training Qualiopi certified?

Yes, Learni is a Qualiopi-certified training organization. This certification guarantees the quality of our courses and enables funding through OPCO and other mechanisms.

How can I fund my training?

Our courses are eligible for OPCO funding. Learni supports you through the funding process. A personalized quote is available upon request.

What are the prerequisites for this training?

The prerequisites for the Training M&A Modeling - Modeling Complex Transactions 2026 training are: Advanced Excel proficiency, VBA, basic DCF and LBO modeling. A preliminary interview validates your eligibility.

Is the training available in person?

Yes, the Training M&A Modeling - Modeling Complex Transactions 2026 training is available in remote. The format can be adapted to your needs (inter, intra, custom).

Training M&A Modeling - Modeling Complex Transac... | Learni

The story of Learni

Founded by passionate advocates of learning and innovation, Learni set out to make professional training accessible to everyone, everywhere in the world. Our team works in the largest cities such as Paris, Lyon, Marseille, and internationally, to support talents and organizations in their skills development.

Configure your training

Response within 24hNo commitment100% free

7 spots remaining for the next session

FormatParticipantsDateDetails

Which format do you prefer?

Methods, approaches, and teaching resources

The Training M&A Modeling - Modeling Complex Transactions 2026 training is delivered in-person or remotely (blended-learning, e-learning, virtual classroom, remote in-person). At Learni, a Qualiopi-certified training organization, each program is designed to maximize skills acquisition, regardless of the training mode chosen.

The trainer alternates between demonstrative, interrogative, and active methods (through practical exercises and/or real-world scenarios). This pedagogical approach ensures concrete and directly applicable learning in the workplace.

Teaching resources provided

To ensure the quality of the Training M&A Modeling - Modeling Complex Transactions 2026 training, Learni provides the following teaching resources:

Mac or PC computers, high-speed fiber internet, whiteboard or flipchart, video projector or interactive touchscreen (for remote sessions)
Training environments installed on workstations or accessible online
Course materials, practical exercises, and supplementary resources
Post-training access to materials and teaching resources

For in-house training at a location external to Learni, the client ensures and commits to having all necessary teaching materials (IT equipment, internet connection...) for the proper conduct of the training action in accordance with the prerequisites indicated in the communicated training program.

* contact us for remote feasibility** ratio varies depending on the training followed

Assessment methods

The assessment of skills acquired during the Training M&A Modeling - Modeling Complex Transactions 2026 training is carried out through:

During training: case studies, practical exercises, and professional scenarios
At the end of training: self-assessment questionnaire and skills evaluation by the trainer
After training: training completion certificate detailing acquired skills

Training accessibility

Learni is committed to the accessibility of its professional training programs. All our training programs are accessible to people with disabilities. Our teams are available to adapt teaching methods to your specific needs. Do not hesitate to contact us for any accommodation request.

Training objectives

Master advanced M&A modeling for precise valuations in corporate settings

Develop professional and certifiable accretion/dilution models

Implement operational synergies in complex M&A simulations

Design optimal financing structures for 2026 deals

Optimize Excel models for audits and rapid due diligence

Deploy post-deal forecasts with macroeconomic sensitivities

Acquire certifiable M&A modeling skills for accelerated career growth

Training program

Module 1M&A Modeling Fundamentals: Deal Structures and Advanced Valuations (Excel, Synergies)

Immersion in 2026 M&A transaction architectures, pro forma modeling with precise accounting adjustments, hands-on Excel for merging balance sheets and income statements, exercises on real carve-out cases, calculation of gross/net synergies using automated VBA formulas, production of first integrated model validated live in session for immediate productivity gains in professional settings.

Module 2Accretion/Dilution M&A Modeling: EPS Impacts and Sensitivity Analyses (Scenarios, Charts)

Build detailed accretion/dilution models for acquirers/targets, integration of updated 2026 EV/EBITDA multiples, sensitivity simulations on interest rates and organic growth, use of Power Query for rapid data cleaning, practical cases on cross-border deals, generation of dynamic Excel charts for investor pitches, deliverable ready-to-use model enhancing credibility in executive meetings.

Module 3Synergies and Financing M&A Modeling: Cost of Capital and Hybrid LBOs (WACC, Debt)

Develop detailed synergy forecasts by P&L and cash-flow lines, weighted WACC calculation for volatile 2026 environments, mixed senior/mezzanine financing structuring, VBA exercises for automated stress-tests, analysis of real M&A LBO cases with bank covenants, production of optimized financing plan, immediate value add for accelerated corporate due diligence.

Module 4Due Diligence M&A Modeling: Financial Audits and Hidden Risks (Adjustments, Waterfalls)

Simulate complete audits using standardized IFRS models, identification of earn-outs and working capital adjustments, equity/debt waterfall modeling for exits, integration of virtual data rooms in Excel, practical cases on post-deal disputes, development of macros for automated reporting, deliverable due diligence toolkit certifying professional skills for secure deals.

Module 5M&A Modeling Optimization 2026: Post-Deal Integration and Pitch Books (Power BI, Macros)

Finalize models integrating 2026 macro-scenarios such as inflation and regulations, creation of professional pitch books with dynamic Excel/Power BI links, post-merger integration exercises with KPI tracking, code review via pair-programming for robustness, defense of red-thread project on realistic fictional deal, delivery of production-ready model portfolio, transformation of skills for M&A leadership in corporate environments.