Lesson Objective: To construct the fully integrated pro forma balance sheet and cash flow statement for the combined entity, incorporating the purchase accounting adjustments, the new debt and equity financing, and the synergies to provide a comprehensive view of the combined company’s financial position and liquidity post-transaction.

In-Depth Notes:

1. The Pro Forma Balance Sheet (The Consolidated Financial Position):
The pro forma balance sheet combines the acquirer’s balance sheet with the target’s balance sheet, adjusted for the transaction’s purchase accounting and financing.

  • Step 1 – Combine the Balance Sheets: The model adds the acquirer’s balance sheet line items to the target’s balance sheet line items (using the fair value adjustments from the PPA).

  • Step 2 – Record the Purchase Price Consideration: The cash paid for the acquisition reduces the Combined Cash balance. If stock was issued, the Combined Equity (Share Capital and APIC) increases.

  • Step 3 – Record the New Debt Financing: The new debt issued to fund the transaction increases the Combined Debt balance (and increases Combined Cash if the debt proceeds were not immediately spent).

  • Step 4 – Record the Goodwill: The Goodwill is added to the Combined Intangible Assets. This significantly increases the total assets of the combined entity.

  • Step 5 – The “Balance Sheet Check”: The model performs a critical check: Total Assets must equal Total Liabilities + Total Equity after all adjustments. If it does not balance, there is an error in the PPA or the Sources and Uses table.

2. The Pro Forma Cash Flow Statement:
The pro forma cash flow statement is the most challenging part of the integration because it must incorporate the synergies, the financing costs, and the purchase accounting adjustments.

  • The Direct vs. Indirect Method: The indirect method is used for the pro forma CFS.

  • Operating Cash Flow (OCF):

    • Starts with Pro Forma Net Income.

    • Adds back Pro Forma D&A (which is higher due to the step-up).

    • Adjusts for Pro Forma Working Capital Changes (the combined entity’s working capital may be more efficient due to synergies).

  • Investing Cash Flow (ICF):

    • The cash outflow for the acquisition is recorded as a single large investing cash outflow in the quarter of the close.

    • Combined CAPEX is included (target + acquirer).

  • Financing Cash Flow (FCF):

    • The new debt raised is a cash inflow.

    • The repayment of the target’s debt is a cash outflow.

    • Interest payments on the new debt are included (as a reduction to net income in OCF).

  • The “Cash Sweep” Check: The pro forma model must include a cash sweep mechanism (like the integrated statements model) to ensure that the combined entity has sufficient liquidity to service the new debt.

3. The “Synergy Phasing” Timeline:
Synergies are not realized instantly. They are typically phased in over 1 to 3 years post-close.

  • The Phasing Schedule: The model includes a detailed schedule showing the realization of synergies by quarter or year. For example:

    • Year 1: 50% of total synergies realized.

    • Year 2: 75% realized.

    • Year 3: 100% realized.

  • The “Integration Cost” Schedule: One-time integration costs (e.g., severance payments, system migration costs) are modeled as cash outflows in Year 1, partially offsetting the synergies. The model must ensure that the cash flow impact of these integration costs is accurately reflected in the cash flow statement (they are typically recorded as operating cash outflows or investing cash outflows, depending on the nature of the costs).

4. The Pro Forma Leverage and Coverage Ratios:
Post-transaction leverage ratios are a key concern for credit rating agencies and lenders.

  • Pro Forma Net Debt / EBITDA: (Combined Net Debt) / (Combined EBITDA + Synergies). This is the most critical leverage metric. If this ratio exceeds 5.0x, the combined entity may be downgraded by rating agencies, increasing the cost of future debt.

  • Pro Forma Interest Coverage Ratio: (Combined EBIT + Synergies) / Combined Interest Expense. A ratio below 3.0x is considered high risk in both US and European credit markets.

  • The “Covenant Headroom” Analysis: The model calculates the headroom between the projected ratios and the loan covenants. If the headroom is negative under any forecasted scenario (e.g., if synergies are not realized as expected), the model flags a potential covenant breach.

PreviousNext