Matan Feldman – Wall Street Prep – The 13-Week Cash Flow Model

*** 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

1. TWCF Course Welcome
2. Course Downloads
3. Introduction to the TWCF
4. TWCF as a decision-making tool
5. An example of a TWCF AHP
6. Non-operating disbursements
7. Lyondell’s TWCF American Home Products Case Study
8. AHP case study introduction
9. AHP Case Study: 363 sale “Stalking Horse Bidder”
10. AHP case study: Credit bidding
11. AHP Case Study: The role of the TWCF

Introduction to TWCF Modeling 12. Introduction to TWCF modeling

13. Introducing the TWCF model case study
14. Catalyst for distress
15. Getting organized with the TWCF
16. TWCF model architecture
17. Company information provided

TWCF Modeling Step-by-Step 18. Modeling 30000-foot view

19. AR rollforward
20. Modeling disbursements
21. AR rollforward complete
22. Non-receivables receipts
23. Forecasting employee wages
24. Payroll Excel solution
25. Wages payable rollforward 1
26. Wages payable rollforward 2
27. Inventory rollforward intro
28. DOH and inventory turnover
29. Interpreting inventory KPIs
30. Building the inventory rollforward
31. Accounts payable rollforward intro
32. DPO calculation and KPI discussion
33. Building the AP rollforward
34. Forecasting inventory disbursements
35. Rent utilities other disbursements
36. Modeling other disbursements
37. Modeling non-operating disbursements
38. Capital expenditures
39. Professional fees 1
40. Professional fees 2
41. Interest payable and debt rollforwards
42. Completing the pre-revolver TWCF
43. Borrowing base modeling

44. Borrowing base solutions
45. Revolver mechanics
46. Modeling the revolver
47. Modeling revolver interest
48. Avoiding circularity
49. EBITDA reconciliation

50. Modeling EBITDA to cash flows 1
51. Modeling EBITDA to cash flows 2
52. Building a case manager into a TWCF

53. Integrating cases into the TWCF
54. Sensitizing individual drivers
55. Most common TWCF complexities

56. Working with messy data
57. Commingled line items
58. Forecasting a Messy Monthly IS 1
59. Forecasting a Messy Monthly IS 2
60. Forecasting a Messy Monthly IS 3
61. Converting Monthly Data to Weekly 1
62. Converting Monthly Data to Weekly 2
63. Remodeling: Updating TWCF for new weeks
64. Account mapping

65. Using UNIQUE to map accounts

---

Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/