How to use history in making an acquisition analysis

Description
This is an in-depth and extensive excel tool for modelling with regard to acquisitions, and how to use history when making an acquisition analysis.

This tool is made up of 17 functional tabs, which will enable you to model the finances of the target and acquiring company. These tabs are:

- Summary DCF
- Tornado Diagram
- Master Scenario
- Historic Financial Statements
- Financial Model Assumptions
- Financial Model
- Valuation and ROIC
- EV to EBITDA and Stable Ratios
- PE Ratio
- Acquisition Model
- Break-even Chart
- Shipments and Capacity
- Simple Scenario
- Basic Model
- Offset Chart
- Stock Prices
- NOL

Each tab comes with 'Comment' sections which explains what happens on each sheet, as well as any instructions you may need.

The Excel file attached is an example of Suntech's acquisition analysis.