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

Description

Matan Feldman – Wall Street Prep – The 13-Week Cash Flow Model download, Matan Feldman – Wall Street Prep – The 13-Week Cash Flow Model review, Matan Feldman – Wall Street Prep – The 13-Week Cash Flow Model free

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.

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

Frequently Asked Questions:

1. Innovative Business Model:
   • Embrace the reality of a genuine business! Our approach involves forming a group buy, where we collectively share the costs among members. Using these funds, we purchase sought-after courses from sale pages and make them accessible to individuals facing financial constraints. Despite potential reservations from the authors, our customers appreciate the affordability and accessibility we provide.
2. The Legal Landscape: Yes and No:
   • The legality of our operations falls into a gray area. While we lack explicit approval from the course authors for resale, there’s a technicality at play. When procuring the course, the author didn’t specify any restrictions on resale. This legal nuance presents both an opportunity for us and a boon for those seeking budget-friendly access.
3. Quality Assurance: Unveiling the Real Deal:
   • Delving into the heart of the matter – quality. Acquiring the course directly from the sale page ensures that all documents and materials are identical to those obtained through conventional means. However, our differentiator lies in going beyond personal study; we take an extra step by reselling. It’s important to note that we are not the official course providers, meaning certain premium services aren’t included in our package:
     • No coaching calls or scheduled sessions with the author.
     • No access to the author’s private Facebook group or web portal.
     • No entry to the author’s exclusive membership forum.
     • No direct email support from the author or their team.

   We operate independently, aiming to bridge the affordability gap without the additional services offered by official course channels. Your understanding of our unique approach is greatly appreciated.

Refund is acceptable:

• Firstly, item is not as explained
• Secondly, Item do not work the way it should.
• Thirdly, and most importantly, support extension can not be used.

Thank you for choosing us! We’re so happy that you feel comfortable enough with us to forward your business here.