GoBuyside - Private Equity Recruiting Test 1.xlsx - GoBuyside Inc RST Solutions Private Equity Modeling Test 1 GoBuyside Inc RST Solutions Purchase

GoBuyside - Private Equity Recruiting Test 1.xlsx -...

This preview shows page 1 - 4 out of 9 pages.

GoBuyside Inc. RST Solutions Private Equity Modeling Test 1
Image of page 1
5d14cf3a3d5d84a271d2ead88a5c60a4432749a5.xlsx Page 2 of 9 LBO GoBuyside Inc. - RST Solutions Purchase Assumptions Sources Transaction Value Less: Debt -- $ % Leverage Rate Floor Term Points Fees Plus: Cash -- Available Cash -- Offer Value Revolver (L+4.50%) -- L+4.50% 1.75% 5.0 0.00% Term Loan (L+4.50%) 350.0 L+4.50% 1.75% 6.0 1.00% 2011E EBITDA Senior Notes (11.75%) 200.0 11.75% 7.0 2.00% Entry Multiple 9.5x Sponsor Equity Total Valuation Uses OID 2016 EBITDA $ % Term OID Exit Multiple 8.0x 9.0x 10.0x Purchase of Equity Revolver (L+4.50%) 5.0 100.0 2016 Net Debt Financing Fees Term Loan (L+4.50%) 6.0 100.0 2016 Equity Value Transaction Fees Senior Notes (11.75%) 7.0 99.0 Target Equity Return 25.0% Total Uses Total Holding Period (Years) 5.0 Discounted Equity Value Cash / Debt Assumptions & Fees Sponsor IRR Summary Plus: New Debt Exit Mult. 2014E 2015E 2016E Less: New Cash Financing Fees 8.0x Less: Transaction Fees Transaction Fees 20.0 8.5x Less: Financing Fees Minimum Cash 10.0 9.0x Transaction Value New Revolver Availability 50.0 9.5x Implied Purchase Multiple Interest Rate on Cash 1.0% 10.0x
Image of page 2
5d14cf3a3d5d84a271d2ead88a5c60a4432749a5.xlsx
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 9 pages?

  • Winter '15
  • Stefano Caselli
  • Interest, Generally Accepted Accounting Principles

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture