Mergers & Acquisition Modelling

click to rate

About


About Course



 



  • This course is a type of financial modeling course that teaches how to build a pro forma model for a merger or acquisition transaction. A pro forma model is a projection of the combined financial statements of the acquirer and the target after the deal is completed.

  • It shows the impact of the transaction on key metrics such as revenue, earnings, cash flow, and valuation. A Mergers & Acquisition Modelling course typically covers topics such as:


    • How to structure an M&A model in Excel.

    • How to set up the sources and uses of cash for the deal.

    • How to adjust the balance sheet for the purchase price allocation and goodwill.

    • How to forecast the income statement and cash flow statement of the combined entity.

    • How to calculate the accretion or dilution of earnings per share and other ratios.

    • How to perform sensitivity analysis on various assumptions and scenarios.

    • How to evaluate the strategic rationale and synergies of the deal.




    • Eligibilities







10 views