Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • Combination Model
  • 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

acquisitionscombinationfinancefinancial statementsimpactm&amergers

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 business tool includes
1 Excel Model

John P. Burns offers you this business tool for free!

download for free

Discuss

Reviews


Discussion feed for Combination Model

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

  • Dojo919
    Tony, your model does not open in highly secure environment due to outdated xls. Any chance you'd want to update latest version of excel?
    arrow_drop_uparrow_drop_downReply reply
    please wait...