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

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for Combination Model

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

  • mbdeals
    Hi, what's the password to unprotect the sheet if we want to make some adjustments?
    arrow_drop_uparrow_drop_downReply reply
    • John P. Burns
      I don't recall the password, but email me at jburns@8fcapital.com and I can email an unprotected one
      arrow_drop_uparrow_drop_downReply reply
    • 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
      • John P. Burns
        * comment deleted *
        arrow_drop_uparrow_drop_downReply reply
        please wait...