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

Ask a question

Reviews

  • No review yet!

Any questions on Combination Model?

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

please wait...