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

The 13-Week Cash Flow Model By Matan Feldman – Wall Street Prep For Immediate Digital Download!

The 13-Week Cash Flow Model

Learn how to build an Integrated 13-week cash flow model step-by-step.

Why you should take this cash flow modeling course

• 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

Wall Street Prep delivers restructuring training to some of the world’s leading turnaround consulting & advisory firms, investment banks and distressed debt funds

Course Highlights

Taught by experienced professionals
Our instructors are former finance professionals and consultants who know what it takes to build great looking decks during deals and client engagements.

The same employee training used at top firms
This is the same course our corporate clients use to teach their finance professionals and consultants how to build better pitchbooks and client decks.

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

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