Take the next step to FinanciAL mASTERY

Capital City Training 
Knowledge Series
Introduction to Mergers and Acquisitions

The Introduction to M&A manual is an indispensable resource for finance professionals, auditors, and business managers looking at beginning their M&A journey.

Our clients

We are trusted by some of the
biggest names in the Industry:

Over 10,000 participants trained

Over 100 years of collective training experience

All courses are accredited with either CISI or IFD

What is Inside the manual?

Model Setup and Structure

This foundational section covers everything from initial design principles to file naming conventions and sheet consistency. It also discusses the importance of freezing panes for ease of use, establishing a coherent model structure.

Inputs, Assumptions, and Outputs

Essential for the integrity and flexibility of financial models, this part delves into how to organise inputs and assumptions effectively, the creation of a control panel for easy scenario adjustments, and the clear presentation of outputs for decision-making.

Advanced Excel Techniques

Focusing on critical Excel functionalities such as relative vs. absolute referencing, naming cells and ranges, and the use of functions like IF, LOOKUP, and INDIRECT. It also covers the management of volatile functions and data consolidation techniques.

Data Analysis and Presentation

This section emphasises tools and methods for analysing model outputs, including pivot tables, array formulas, and sensitivity analysis using Goal Seek and data tables. It also covers the validation of data inputs and outputs, conditional formatting, and the creation of charts for visual representation of data.

Model Auditing and Error Detection

A critical component for ensuring the accuracy and reliability of financial models, this part provides strategies for auditing models, tracking changes, detecting errors, and utilising Excel's built-in auditing tools. It offers a systematic approach to reviewing models and ensuring they are free of errors and ready for use.

Created with

We use cookies to provide you with an optimal experience and relevant communication. Learn more or accept individual cookies.

Necessary

Necessary cookies (First Party Cookies) are sometimes called "strictly necessary" as without them we cannot provide the functionality that you need to use this website. For example, essential cookies help remember your preferences as you navigate through the online school.

Functional

Functional cookies enable this website to provide enhanced functionality and personalization, by remembering information you have entered and choices you make. These preferences are remembered through the use of persistent cookies, so that you will not have to set them again the next time you visit the website.

Analytics

Analytics cookies track information about visits on our website so that we can measure and improve its performance, as well as optimize our course content. These cookies help us analyze user behavior by tracking the number of visits, how visitors use the website, which site or page they come from and how long they are staying for.

Marketing

Marketing cookies are used to deliver advertising material relevant to you and your interests. They are also used to limit the number of times you see an advertisement, resulting to more targeted advertising, as well as help us measure the effectiveness of our campaigns. They are usually placed by advertising networks we collaborate with, with our permission.