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!

 

Beatae cum fugiat atque aut qui eligendi optio. Quo tempora ipsum magni quis voluptas saepe.

Career Advancement Opportunities

April 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 03 97.1%

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $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

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...”