LBO MODEL EXAM QUESTIONS AND ANSWERS WITH COMPLETE SOLUTIONS VERIFIED LATEST UPDATE

LBO MODEL EXAM QUESTIONS AND ANSWERS WITH

COMPLETE SOLUTIONS VERIFIED LATEST UPDATE


Set Up Order

1) Transaction Assumptions

2) Debt Assumptions

3) Sources & Uses

4) Goodwill Creation & Purchase Price Allocation

5) Margins, Expense and Working Capital Trends, and BS / CFS Assumptions

6) Income Statement

7) Balance Sheet

8) Cash Flow Statement

9) Debt & Interest Schedules

10) Investor Returns

11) Sensitivity Analysis

1) Enterprise Value

Diluted Equity Value

Plus: Net Debt (Plus: Debt Less: Cash)

Plus: Non controlling Interests

Plus: Preferred Stock

Plus: Other Liabilities

1) Total Funds Required (excl. fees)

, Equity Purchase Price

Plus: Net Debt (Plus: Debt Refinanced Less: Excess Cash)

Less: Founder Cash Contribution

Less: Founder Rollover

3) Sources & Uses

Sources:

Revolver

Term Loan B[C]

ABL Facility

1st[2nd] Lien Bridge Facility

Assume Existing Debt [w/ no refi]

Company - Excess Cash

Founder - Cash Contribution for Equity

MD Investors - Founder Rollover Equity

Silver Lake - Investor Equity



Uses:

Equity Value of Company

Refinance Existing Debt [w/ yes refi]

Assume Existing Debt [w/ no refi]

Advisory Fees

Capitalized Financing Fees

Legal & Misc. Fees