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

*** Proof of Product ***

Exploring the Essential Features of “Matan Feldman – The 13-Week Cash Flow Modeling – Wall Street Prep“

Why you should take this cash flow modeling course:

Learn how to build an Integrated 13-week cash flow model step-by-step. This course provides a comprehensive guide to creating a fully integrated 13-week cash flow model within the context of a turnaround and financial restructuring.

Course Overview:

• Complete 13-Week Cash Flow (TWCF) Training: This course offers a detailed, step-by-step walkthrough of building a fully integrated 13-week cash flow model, emphasizing its relevance in turnaround and financial restructuring scenarios.
• Not Just Concepts – Real World Modeling: Utilizing a case study, participants will construct a fully integrated model mirroring real-world job requirements. This unique course blends complex model mechanics with the motivations of stakeholders involved in both in-court and out-of-court turnarounds.
• Excel Model Templates Included: The course includes a complete 13-Week Cash Flow Model template, facilitating practical application and reinforcing the learning experience.

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

Course Highlights:

• Taught by experienced professionals: Instructors are former finance professionals and consultants well-versed in building decks during deals and client engagements.
• Used at top firms: The same course employed by leading turnaround consulting & advisory firms, investment banks, and distressed debt funds to train their finance professionals.

Course TOC (Table of Contents):

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

Borrowing Base and Revolver

43. Borrowing base modeling
44. Borrowing base solutions
45. Revolver mechanics
46. Modeling the revolver
47. Modeling revolver interest
48. Avoiding circularity

EBITDA Reconciliation

49. EBITDA reconciliation
50. Modeling EBITDA to cash flows 1
51. Modeling EBITDA to cash flows 2

Case Manager and Sensitivity

52. Building a case manager into a TWCF
53. Integrating cases into the TWCF
54. Sensitizing individual drivers

Adding Model Complexity

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

Account Mapping Using SUMIFS

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/