How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
  • How to use history in making an acquisition analysis
Originally published: 30/04/2018 10:24
Publication number: ELQ-27506-1
View all versions & Certificate
certified

How to use history in making an acquisition analysis

An extensive excel tool for acquisition analysis, and how to use history when making an acquisition analysis.

acquisitionacquisition analysisanalysishistorym&amergers and aquisition

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.

This business tool includes
1 Excel File

Prof. Ed Bodmer offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More tools from Prof. Ed Bodmer

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on How To Use History In Making An Acquisition Analysis?

The user community and author are here to help. Go ahead!

please wait...