Combination Model
Originally published: 10/10/2016 15:21
Publication number: ELQ-20154-1
View all versions & Certificate
certified

Combination Model

A 22 section excel model to assess the impact on the financials of the combination of companies

Description
This excel model includes the following sections to assess the impact of combining two companies in the case of an acquisition:

Main Elements:
- Transaction Structure
- Synergies

For the NewCo:
- Income Detail
- Balance Sheet
- Income Statement
- Projected Cash Flow Statement + Debt Repayment Schedule
- Book Depreciation and Amortization Schedule
- Shareholder's Equity Schedule
- Working Capital and Balance Sheet Assumptions
- Income Statement Assumptions
- Free Cash Flow Summary
- Discounted Cash Flow Analysis + Table Summary

For Company A (the acquiror) & B (the target):
- Historical and Projected Balance Sheet + Income Statement + Cash Flow Statement
- Projected Debt Repayment Schedule
- Book Depreciation and Amortization Schedule
- Shareholder's Equity Schedule
- Working Capital and Balance Sheet Assumptions
- Income Statement Assumptions and Historical Performance
- Performance Assumptions
- Free Cash Flow Summary
- Discounted Cash Flow Analysis + Table Summary
- Estimated Weighted Average Cost of Capital Calculation

=> John P. Burns

This Best Practice includes
1 Excel Model

John P. Burns offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


4.6 / 5 (109 votes)

please wait...