Wall Street Prep – Restructuring Modeling
Archive : Wall Street Prep – Restructuring Modeling
Designed for restructuring-focused funding bankers, consultants and distress debt consumers. Trainees will research the restructuring framework and assemble a three-statement chapter model the way in which wherein it’s executed on the job.
This course is designed to indicate restructuring and chapter modeling to varsity college students and professionals pursuing careers in restructuring, chapter and distress. Using the Borders chapter as our important case look at, we begin with an abstract of the restructuring and chapter framework. Then we’re going to research to assemble a complicated chapter model from scratch, incorporating chapter specific elements like DIP financing, the creation of liabilities matter to compromise, working capital drivers, cancellation of debt income, and Fresh Start accounting. We conclude with valuation analysis and restoration analysis, the place we layer quite a few valuation conditions onto the model to research attainable recoveries to the numerous collectors.
Course Objective
Using the Borders chapter as our important case look at, we begin with an abstract of the restructuring and chapter framework. Then we’re going to research to assemble a complicated chapter model from scratch, incorporating chapter specific elements like DIP financing, the creation of liabilities matter to compromise, working capital drivers, cancellation of debt income, and Fresh Start accounting. We conclude the course with valuation analysis and a restoration analysis, the place we’re going to layer quite a few valuation conditions onto the model to research attainable recoveries to the numerous collectors.
At completion, trainees can have developed a 3-statement chapter model from scratch and carried out valuation and restoration analyses.
What You Will Learn
Model among the many most tough factors of a chapter, along with:
- Working capital reclassifications akin to essential distributors/AP
- DIP financing, borrowing base and availability calculations, ample security funds
- Balance sheet roll-forward schedules that maintain a continuing hyperlink building to the cash circulation assertion and improve transparency
- Fees, rejection claims and CODI
- Model recoveries at quite a few working conditions
- Construction of a restoration waterfall which will accommodate conditions that deviate from completely the priority rule
- Using conditional formatting and Excel’s native date formulation to sensitize for numerous submitting and emergence date conditions
- Avoiding spherical references throughout the model whereas sustaining model integrity
- Incorporating best practices for error-proofing, auditing, and model effectivity
- Understanding how Fresh Start Accounting impacts the model
- Working capital reclassifications, akin to essential distributors/AP
Wall Street Prep’s Restructuring Modeling course is used at excessive financial institutions and enterprise schools.
Course Highlights
Step-By-Step Modeling Instruction
The Restructuring Modeling Course delivers step-by-step courses by way of motion pictures, readings, ready-to-use restructuring financial and valuation fashions and exercises using an precise case look at.
Real World “On the Job” Investment Banking Training
The Restructuring Modeling self-study course bridges the opening between lecturers and the precise world to equip trainees with the smart financial skill set wished to succeed on the job. The program makes use of a case look at format, as faculty college students adjust to their tutorial info alongside Excel model templates, and are directed to the appropriate exterior paperwork (SEC filings, evaluation tales, and so forth.) in order to assemble precise Restructuring fashions the way in which wherein it’s executed on the job.
Get Wall Street Prep – Restructuring Modeling on #
Support Center
Upon enrollment, faculty college students purchase 24 month free and limitless entry to Wall Street Prep’s Online Support Center, the place they acquire options to questions, free downloads, and mandatory updates from a assist staff comprised completely of expert former funding bankers
Macabacus Excel Plugin
Free entry to Macabacus, all-in-one suite of time-saving devices designed for people who assemble financial fashions in Excel. Use keyboard shortcuts for widespread amount codecs, to cycle rapidly by way of completely completely different font and coloration schemes and to navigate a system’s inputs all through worksheets and workbooks. Easily understand prolonged formulation with the extremely efficient ‘Precedents’ and ‘Dependents’ Tool, and far more. This 6-month free entry is for the whole mannequin of Macabacus that moreover consists of necessary devices for Powerpoint and Word!
Prerequisites
This course would not assume a earlier background in Restructuring Modeling. However, it assumes an introductory information of accounting (e.g. interaction of stability sheet, cash circulation, and income assertion) and proficiency in Excel.
Course Agenda
Bankruptcy/restructuring enterprise primer
- ·Bankruptcy overview
- Imputing asset values and measuring insolvency from market pricing of debt and equity
- The significance and limitation of valuation methodologies like DCF and Comps in restructuring
- Out of court docket docket restructuring course of
- In court docket docket restructuring course of
- Automatic Stay and Adequate Protection
- Cash Collateral and DIP Financing
- Restructuring Leases & Executory Contracts
- Fraudulent Conveyance & Preference Actions
- Plan of Reorg & Disclosure Statement and Cram Down Provisions
- The Absolute Priority Rule
Case look at modeling and valuation
- · Building a totally built-in three assertion chapter model
- Master modeling mechanics that dynamically distinguish between prepetition, postpetition and post-emergence phases of a restructuring
- Make restructuring specific working capital and operational modifications to standard modeling assumptions
- Build an advanced multi tranche debt schedule, along with the chance of a DIP rollup
- Deriving valuation ranges using multiples
- Analyzing proposed plan distribution
- Performing restoration sensitivity by investor class (“waterfall” analysis)
Get Wall Street Prep – Restructuring Modeling on #
Wall Street Prep – Restructuring Modeling Download, Restructuring Modeling Download, Restructuring Modeling Groupbuy, Restructuring Modeling Free, Restructuring Modeling Torrent, Restructuring Modeling Course Download, Wall Street Prep – Restructuring Modeling Review, Restructuring Modeling Review