Modelling for a merger

This spreadsheet outlines the steps for a business combination and how the resulting pro-forma numbers on the acquirer's balance sheet looks like.

Note: The above represents illustrative numbers and not for use in a pure commercial setting.