Log in
Log inBook a demo

Restructuring Modeling

Wall Street Prep
5 hrs 54 mins

Restructuring Modeling

Wall Street Prep
5 hrs 54 mins
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry for free

Course Overview

This course is designed to teach restructuring and bankruptcy modeling to students and professionals pursuing careers in restructuring, bankruptcy and distress. Using the Borders bankruptcy as our primary case study, we begin with an overview of the restructuring and bankruptcy framework. Then we will learn to build an advanced bankruptcy model from scratch, incorporating bankruptcy specific elements like DIP financing, the creation of liabilities subject to compromise, working capital drivers, cancellation of debt income, and Fresh Start accounting.  We conclude the course with valuation analysis and a recovery analysis, where we will layer various valuation scenarios onto the model to analyze possible recoveries to the various creditors.

Instructor - Matan Feldman

Matan Feldman is Wall Street Prep’s Founder and Managing Partner. His responsibilities include business development, development of courses, and overseeing training programs. Matan has overseen training programs for clients including Morgan Stanley, Credit Suisse, Raymond James, Stifel Nicolaus, FBR Capital Markets, Sagent Advisors, Giuliani Capital Advisors, JP Morgan, Cerberus, Wharton Business School, London Business School, Kellogg, Booth, Stern (NYU), and Cornell. Prior to founding Wall Street Prep, Matan served in several capacities on Wall Street — first as an Analyst in Chase Manhattan Bank's Mergers & Acquisitions Group in New York, and subsequently as an Associate within JP Morgan's Equity Research Group, covering Food & Drug Retail Equities.

Chapter 1: Restructuring Primer
Restructuring Overview, Part 1video • 31 mins
Restructuring Overview, Part 2video • 39 mins
Restructuring Overview, Part 3video • 23 mins
Restructuring Overview, Part 4video • 13 mins
Chapter 2: Restructuring Modeling Program
Model Structurevideo • 10 mins
Introduction to Restructuring Modelingvideo • 3 mins
Model Structure, Part 2video • 9 mins
Inputting Historicalsvideo • 16 mins
Forecasting the Income Statementvideo • 11 mins
Forecasting Working Capitalvideo • 13 mins
Forecasting Property, Plant, and Equipment (PP&E)video • 11 mins
Forecasting Goodwill and Financing Feesvideo • 11 mins
Forecasting Accounts Payablevideo • 6 mins
Forecasting Accounts Payable, Part 2video • 5 mins
Forecasting Accounts Payable, Part 3video • 5 mins
Accrued Liabilities and Other Long Term Liabilitiesvideo • 7 mins
Lease Rejection Claims and Professionals Feesvideo • 6 mins
Cleaning up the Balance Sheet and Income Statementvideo • 7 mins
Debt Introduction and Modeling Prepetition Term Loansvideo • 9 mins
Modeling the Cash Flow Statementvideo • 13 mins
Modeling the Prepetition Revolver, Part 1video • 15 mins
Modeling the Prepetition Revolver, Part 2video • 5 mins
Modeling the DIP Revolvervideo • 10 mins
Referencing Debt Related Forecasts into the CFSvideo • 4 mins
Valuation and Debt Capacityvideo • 6 mins
Sources and Uses of Fundsvideo • 9 mins
Modeling the Priority of Claims Waterfallvideo • 26 mins
Exit Revolvervideo • 12 mins
Debt Reinstatementvideo • 5 mins
Modeling the Equityvideo • 8 mins
Completing the Modelvideo • 13 mins
Additional Topics The Thirteen Week Cash Flowvideo • 11 mins
Supporting Documents
Supporting Documents Kittext