109 19 LBO Modeling Test Answers
|27753314
)
LBO Modeling Test from Blank Excel Sheet – 60 Minutes – ANSWERS
You have 60 minutes to complete this LBO modelling test from scratch, starting with a blank
Excel sheet and using no outside resources or templates. Once you finish the model, respond to
the case study questions at the bottom.
A private equity firm plans to acquire a private, family-owned widget manufacturer (“Widget
Co.”) with annual sales of $500 million and EBITDA margins of 20% for 12x LTM EBITDA. The
transaction will be structured as a cash-free, debt-free deal, with a possible cash injection in the
beginning.
Total advisory and financing fees will equal 2% of the Purchase Enterprise Value. For simplicity,
assume no amortization of the financing fees.
The PE firm plans to fund the deal with the following:
• Term Loans: 3x EBITDA with a floating cash coupon rate of Benchmark Rate + 300 bps,
mandatory principal repayments of 5%, 10%, 10%, 15%, and 20% in Years 1 – 5, and a
50% cash flow sweep. The Benchmark Rate is expected to increase from 1.5% to 3.0%
over 5 years.
• Senior Notes: 1x EBITDA with a 3% fixed cash coupon rate, 5% PIK interest, and no
principal repayments (mandatory or optional).
• Subordinated Notes: 1x EBITDA with 10% PIK interest and no principal repayments
(mandatory or optional).
|27753314
)
LBO Modeling Test from Blank Excel Sheet – 60 Minutes – ANSWERS
You have 60 minutes to complete this LBO modelling test from scratch, starting with a blank
Excel sheet and using no outside resources or templates. Once you finish the model, respond to
the case study questions at the bottom.
A private equity firm plans to acquire a private, family-owned widget manufacturer (“Widget
Co.”) with annual sales of $500 million and EBITDA margins of 20% for 12x LTM EBITDA. The
transaction will be structured as a cash-free, debt-free deal, with a possible cash injection in the
beginning.
Total advisory and financing fees will equal 2% of the Purchase Enterprise Value. For simplicity,
assume no amortization of the financing fees.
The PE firm plans to fund the deal with the following:
• Term Loans: 3x EBITDA with a floating cash coupon rate of Benchmark Rate + 300 bps,
mandatory principal repayments of 5%, 10%, 10%, 15%, and 20% in Years 1 – 5, and a
50% cash flow sweep. The Benchmark Rate is expected to increase from 1.5% to 3.0%
over 5 years.
• Senior Notes: 1x EBITDA with a 3% fixed cash coupon rate, 5% PIK interest, and no
principal repayments (mandatory or optional).
• Subordinated Notes: 1x EBITDA with 10% PIK interest and no principal repayments
(mandatory or optional).
