16. Restructuring Modeling

COURSE
Wall Street Prep
5 hrs 54 mins

16. Restructuring Modeling

COURSE
Wall Street Prep
5 hrs 54 mins
$339per person
OR
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry it free
$339per person
OR
Included in GO1 PremiumStarting from $12 per user for teamsLearn moreTry it 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.

Learning
Chapter 1: Restructuring Primer
16.1.1 Restructuring Overview, Part 1video • 31 mins
16.1.2 Restructuring Overview, Part 2video • 39 mins
16.1.3 Restructuring Overview, Part 3video • 23 mins
16.1.4 Restructuring Overview, Part 4video • 13 mins
Chapter 2: Restructuring Modeling Program
16.2.1 Introductionvideo • 3 mins
16.2.2 Model Structurevideo • 10 mins
16.2.3 Model Structure, Part 2video • 9 mins
16.2.4 Inputting Historicalsvideo • 16 mins
16.2.5 Forecasting the Income Statementvideo • 11 mins
16.2.6 Forecasting Working Capitalvideo • 13 mins
16.2.7 Forecasting Property, Plant, and Equipment (PP&E)video • 11 mins
16.2.8 Forecasting Goodwill and Financing Feesvideo • 11 mins
16.2.9 Forecasting Accounts Payablevideo • 6 mins
16.2.10 Forecasting Accounts Payable, Part 2video • 5 mins
16.2.11 Forecasting Accounts Payable, Part 3video • 5 mins
16.2.12 Accrued Liabilities and Other Long Term Liabilitiesvideo • 7 mins
16.2.13 Lease Rejection Claims and Professionals Feesvideo • 6 mins
16.2.14 Cleaning up the Balance Sheet and Income Statementvideo • 7 mins
16.2.15 Debt Introduction and Modeling Prepetition Term Loansvideo • 9 mins
16.2.16 Modeling the Cash Flow Statementvideo • 13 mins
16.2.17 Modeling the Prepetition Revolver, Part 1video • 15 mins
16.2.18 Modeling the Prepetition Revolver, Part 2video • 5 mins
16.2.19 Modeling the DIP Revolvervideo • 10 mins
16.2.20 Referencing Debt Related Forecasts into the CFSvideo • 4 mins
16.2.21 Valuation and Debt Capacityvideo • 6 mins
16.2.22 Sources and Uses of Fundsvideo • 9 mins
16.2.23 Modeling the Priority of Claims Waterfallvideo • 26 mins
16.2.24 Exit Revolvervideo • 12 mins
16.2.25 Debt Reinstatementvideo • 5 mins
16.2.26 Modeling the Equityvideo • 8 mins
16.2.27 Completing the Modelvideo • 13 mins
16.2.28 Additional Topics The Thirteen Week Cash Flowvideo • 11 mins
Supporting Documents - Pre-Reading Files
Primerdocument
01_Introductiondocument
02_Model_Structuredocument
03_Inputting_Historicalsdocument
04_Exercisedocument
04_Forecasting_ISdocument
05_Exercisedocument
05_Forecasting_WCdocument
06_Asset_Sale_Exercisedocument
06_Exercisedocument
06_Forecasting_PPEdocument
07_Exercisedocument
07_GW_Financing_Feesdocument
08_APdocument
08_Exercisedocument
09_Accrued_LT_Liabsdocument
09_Exercisedocument
10_Exercise1document
10_Exercise2document
10_Rejections_Prof_Feesdocument
11_Debt_Introdocument
11_DIP_Trendsdocument
12_Exercisedocument
12_Prepetition_Term_Loandocument
13_CFSdocument
13_Exercisedocument
14_Exercisedocument
14_Revolverdocument
15_DIPdocument
15_Exercisedocument
15_Exercise2document
16_Exercisedocument
16_Recovery_PORdocument
16_Val_Overviewdocument
17_Exercisedocument
18_Exercisedocument
18_Prioritydocument
19_Exercisedocument
19_Exit_Revolverdocument
20_Debt_Reinstatedocument
21_CODIdocument
21_Equitydocument
21_Exercisedocument
22_Exercisedocument
23_Fresh_Startdocument
24_Appendixdocument
25_TWCFdocument
Supporting Documents - Lesson Documents
10K_2010_Bordersdocument
April_2011_Financialsdocument
Borders_List of Creditorsdocument
Claims_Prioritiesdocument
DIP_motion_termsdocument
DIP_term_sheetdocument
July_Financialsdocument
June_2011_Financialsdocument
KERP_2011_rev_estimatedocument
March_2011_financialsdocument
May_2011_Financialsdocument
Q1_2010_Borders_10Qdocument
Q2_2010_Borders_10Qdocument
Q3_2010_Borders_10Qdocument
UCC_objection_to_DIPdocument
Supporting Documents - Models
01_02_Date_Headers_Onlydocument
01_03_Inputting_Historicalsdocument
Borders_Model_Step_1_to_11document
Borders_Model_Step_12document
Borders_Model_Step_13document
Borders_Model_Step_14_to_16document
Borders_Model_Step_17document
Borders_Model_Step_18document
Fresh_Start_Exercise_Sheetdocument
CommunityBlogPartners
© Copyright 2019 GO1 - All Rights Reserved