Most Helpful

If they're going to have you build a recap model, an LBO model is going to get you pretty close. The difference is that you'll probably spend more time on the debt debt schedule than the operating model (as you'd expect). Just like an LBO model, you'll have your usual build to unlevered FCF then a debt schedule that feeds your cash interest and mandatory amortization back to levered FCF then a revolver which feeds off of levered FCF, and min cash. Ultimately, this will get you to a net change in cash.

The difference between the recap and the LBO model will be the transaction modeling which is honestly pretty straightforward once you have the LBO piece. Be comfortable with adding in functionality for new tranches of debt and equitization of existing tranches (% haircut, % participation, fees).

It's possible (but I personally think unlikely), that they ask you to build a full bankruptcy model which will require toggles on each tranche of debt for paying and accruing interest while the Company is in Chapter 11. Then the emergence from bankruptcy sort of functions like an exchange. I'd take a look at some of the wallstreet prep resources to get a full explanation (only after you're comfortable with the recap).

It should go without saying that you'll want to also have a good output tab that has the key summary statistics (EBITDA, ULFCF, LFCF, available liquidity, leverage) as well as some sources and uses for any transactions that you're modeling.

 

That's right, so you've got your LBO model that has your current debt schedule. Each tranche of debt will have the usual principal balance rollforward (BOP Face Amount +/- PIK/Mandatory Amortization (if applicable) = EOP Face Amount). You'll just add a line subtracting debt exchanged which feeds off of participation. If you're modeling a debt exchange rather than equitization, you'll have a new tranche of debt that has a line for something like "new debt issued" or "new debt exchanged" which feeds off of participation and haircut.

As you suggested, if this is just a one hour test, there's only so much they can ask you to do, so I'd just be comfortable building out the debt schedule and then maybe adding a new tranche of debt.

 

If you (or someone you know) happens to have access to the Wall Street Prep premium package, which has a tab of "free courses", there are 2 such free courses on restructuring that are short (3 hr, and 1 hour) and useful, including some template downloads with cap tables, priority waterfall, cash flow and debt balances, etc. May be helpful to you. Good luck!

 

Est natus similique et sit quae praesentium in. Quidem cumque quae qui facere et. Optio voluptas amet dolorem natus nobis voluptatem soluta in. Possimus aspernatur reiciendis aut culpa qui sit qui. Asperiores est non delectus nihil officia consequuntur culpa voluptas.

Perspiciatis omnis quam quis soluta error vel nam. Impedit officia autem perferendis omnis tenetur eum vel. Modi et error expedita quos ut rerum earum. Voluptatum reiciendis ea sint omnis voluptates. Voluptas iusto cumque temporibus molestiae consequuntur. Voluptatem consequatur quasi nam fuga.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
numi's picture
numi
98.8
10
Linda Abraham's picture
Linda Abraham
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”