Wall Street Prep
The 13-Week Cash Flow Model
Step-By-Step Video Course and Certification Program

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

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 Samples

watch video
Getting organized with the TWCF
watch video
Modeling 30000 foot view
watch video
Building a case manager into a TWCF

Get the 13-Week Cash Flow Modeling Certification

Trainees are eligible to take the WSP The 13-Week Cash Flow Modeling Certification Exam for 24 months from the date of enrollment. Those who complete the exam and score above 70% will receive the certification. The exam is a challenging 1-hour online examination covering the most difficult concepts covered in the program.

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.

  • Breeze though lesson videos at 1.5x & 2x speed

    Save loads of time by bumping up playback speed to breeze through lessons at your own pace.

  • Get instructor support throughout the course

    Have a question on course content? Communicate directly with instructors by asking questions throughout the course.

Course Syllabus

Introduction to the TWCF
1 Introduction to the TWCF 5:56
2 TWCF as a decision making tool 4:40
3 An example of a TWCF AHP 4:58
4 Non-operating disbursements 2:03
5 Lyondell's TWCF 6:22
American Home Products Case Study
6 AHP case study introduction 6:08
7 AHP Case Study: 363 sale "Stalking Horse Bidder" 3:09
8 AHP case study: Credit bidding 3:53
9 AHP Case Study: The role of the TWCF 4:42
Introduction to TWCF Modeling
10 Introduction to TWCF modeling 3:50
11 Introducing the TWCF model case study 4:25
12 Catalyst for distress 2:29
13 Getting organized with the TWCF 4:23
14 TWCF model architecture 2:41
15 Company information provided 3:52
TWCF Modeling Step-by-Step
16 Modeling 30000 foot view 3:20
17 AR rollforward 15:56
18 Modeling disbursements 6:19
19 AR rollforward complete 5:02
20 Non-receivables receipts 6:09
21 Forecasting empoyee wages 2:55
22 Payroll Excel solution 2:02
23 Wages payable rollforward 1 2:34
24 Wages payable rollforward 2 2:43
25 Inventory rollforward intro 4:11
26 DOH and inventory turnover 3:18
27 Interpreting inventory KPIs 1:09
28 Building the inventory rollforward 10:27
29 Accounts payable rollforward intro 1:14
30 DPO calculation and KPI discussion 2:27
31 Building the AP rollforward 3:01
32 Forecasting inventory disbursements 3:22
33 Rent utilities other disbursements 1:26
34 Modeling other disbursements 2:59
35 Modeling non-operating disbursements 3:40
36 Capital expenditures 1:12
37 Professional fees 1 2:13
38 Professional fees 2 0:54
39 Interest payable and debt rollforwards 5:04
40 Completing the pre-revolver TWCF 6:21
Borrowing Base and Revolver
41 Borrowing base modeling 8:32
42 Borrowing base solutions 4:10
43 Revolver mechanics 4:59
44 Modeling the revolver 12:23
45 Modeling revolver interest 6:56
46 Avoiding a circularity 2:49
EBITDA Reconciliation
47 EBITDA reconciliation 5:01
48 Modeling EBITDA to cash flows 1 4:55
49 Modeling EBITDA to cash flows 2 3:42
Case Manager and Sensitivity
50 Building a case manager into a TWCF 8:15
51 Integrating cases into the TWCF 9:38
52 Sensitizing individual drivers 3:17
Adding Model Complexity
53 Most common TWCF complexities 0:55
54 Working with messy data 2:34
55 Commingled line items 2:43
56 Forecasting a Messy Monthly IS 1 5:42
57 Forecasting a Messy Monthly IS 2 5:54
58 Forecasting a Messy Monthly IS 3 2:00
59 Converting Monthly Data to Weekly 1 13:14
60 Converting Monthly Data to Weekly 2 13:29
61 Remodeling: Updating TWCF for new weeks 9:14
Account Mapping Using SUMIFS
62 Account mapping 3:39
63 Using UNIQUE to map accounts 5:37
View More
View Less
CPE logo

Earn CPE Credits with WSP Online Courses

CPE logo Wall Street Prep is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org.
X

The Wall Street Prep Quicklesson Series

7 Free Financial Modeling Lessons

Get instant access to video lessons taught by experienced investment bankers. Learn financial statement modeling, DCF, M&A, LBO, Comps and Excel shortcuts.