Merger analysis of an Acquisition of Retail Shops

Description
This tool contains three excel files that each have similar structures and analogous outputs. Each of them start with a standalone corporate model. Once the corporate model is complete, a transaction page is created that presents the consideration in the merger, financing of the meter, fees and other uses of funds in the merger. The acquisition model is then created using the standalone model key outputs (revenues, cash operating expenses, depreciation expense, capital expenditures and working capital). These are brought into the acquisition model using the MATCH and INDEX function or the LOOKUP function. The 'Meracorp Acquisition' and 'Metroexpress' files use examples of retail stores.

This tool contains three excel models:
> Meracorp Acquisition Example
> Metroexpress
> Refinery Acquisition Model Example