*** Proof of Product ***
Exploring the Essential Features of “Matan Feldman – Wall Street Prep – The 13-Week Cash Flow Model“
The 13-Week Cash Flow Model
Learn how to build an Integrated 13-week cash flow model step-by-step. Discover why you should take this cash flow modeling course:
Course Highlights:
- Complete 13-Week Cash Flow (TWCF) Training: This course is a step-by-step buildup of a fully integrated 13-week cash flow model in the context of a turnaround and financial restructuring.
- Not Just Concepts – Real World Modeling: Using a case study, you will build a fully-integrated model as you would on the job. This is the only course available that teaches complex model mechanics for a 13-week cash flow model while weaving the motivations of the various stakeholders during both in court or out of court turnarounds.
- Excel Model Templates Included: Complete 13-Week Cash Flow Model template included with this course.
What You’ll Learn:
- Integrated 13-Week Cash Flow Modeling
- Working Capital & Other Rollforwards
- Borrowing Base & Revolver/DIP Modeling
- Reconciling EBITDA to the 13-Week Cash Flow
- Case Manager and Multiple Scenarios
- Converting Monthly to Weekly Forecasts
- General Ledger Accounting Mapping Best Practices
Who is this program for?
- Turnaround Consultants & Advisors
- Restructuring Investment Banking Professionals
- Distressed Debt Investors
- FP&A and Corporate Finance
- Private Equity Professionals
About Wall Street Prep: Wall Street Prep delivers restructuring training to some of the world’s leading turnaround consulting & advisory firms, investment banks, and distressed debt funds.
Course TOC:
Introduction to the TWCF
- TWCF Course Welcome
- Course Downloads
- Introduction to the TWCF
- TWCF as a decision-making tool
- An example of a TWCF AHP
- Non-operating disbursements
- Lyondell’s TWCF American Home Products Case Study
- AHP case study introduction
- AHP Case Study: 363 sale “Stalking Horse Bidder”
- AHP case study: Credit bidding
- AHP Case Study: The role of the TWCF
Introduction to TWCF Modeling 12. Introduction to TWCF modeling
- Introducing the TWCF model case study
- Catalyst for distress
- Getting organized with the TWCF
- TWCF model architecture
- Company information provided
TWCF Modeling Step-by-Step 18. Modeling 30000-foot view
- AR rollforward
- Modeling disbursements
- AR rollforward complete
- Non-receivables receipts
- Forecasting employee wages
- Payroll Excel solution
- Wages payable rollforward 1
- Wages payable rollforward 2
- Inventory rollforward intro
- DOH and inventory turnover
- Interpreting inventory KPIs
- Building the inventory rollforward
- Accounts payable rollforward intro
- DPO calculation and KPI discussion
- Building the AP rollforward
- Forecasting inventory disbursements
- Rent utilities other disbursements
- Modeling other disbursements
- Modeling non-operating disbursements
- Capital expenditures
- Professional fees 1
- Professional fees 2
- Interest payable and debt rollforwards
- Completing the pre-revolver TWCF
- Borrowing base modeling
- Borrowing base solutions
- Revolver mechanics
- Modeling the revolver
- Modeling revolver interest
- Avoiding circularity
- EBITDA reconciliation
- Modeling EBITDA to cash flows 1
- Modeling EBITDA to cash flows 2
- Building a case manager into a TWCF
- Integrating cases into the TWCF
- Sensitizing individual drivers
- Most common TWCF complexities
- Working with messy data
- Commingled line items
- Forecasting a Messy Monthly IS 1
- Forecasting a Messy Monthly IS 2
- Forecasting a Messy Monthly IS 3
- Converting Monthly Data to Weekly 1
- Converting Monthly Data to Weekly 2
- Remodeling: Updating TWCF for new weeks
- Account mapping
- Using UNIQUE to map accounts
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/