Wall Street Prep
Wed Feb 9, 9a-5p (CT)

13-Week Cash Flow Modeling

1-Day Virtual Boot Camp
Format: Live Virtual
Date: Feb 9
Time: 9a-5p (CT)
CPE Credits: 9.5

Learn to Build a 13-Week Cash Flow Model

  • 13-Week Cash Flow Model
  • Balance Sheet Rollforwards
  • Borrowing Base & Revolver/DIP Schedules
  • Cash flow to EBITDA Analysis
  • Best practice modeling for timing differences and frequent updating
  • Complete 13 Week Cash Flow (TWCF) TrainingThis course begins with an introduction to restructuring, and then follows with a step-by-step buildup of a TWCF model.
  • Real World Case StudyUsing a case study, the learners will build a model step-by-step while weaving the motivations of the various stakeholders to provide learners with context for.
  • Used at Top Financial InstitutionsThis is the same training program delivered to some of the world's leading turnaround consulting & advisory firms, investment banks, and distressed debt funds

All Upcoming Dates

13-Week Cash Flow Modeling 1-Day Virtual Boot Camp
Feb 9
$699
13-Week Cash Flow Modeling 1-Day Virtual Boot Camp
May 3
$699

Agenda

Morning
Introduction to financial restructuring
  • Bankruptcy overview
  • Imputing asset values and measuring insolvency from market pricing of debt and equity
  • The importance and limitation of valuation methodologies like DCF and Comps in restructuring
  • Out of court restructuring process
  • In court restructuring process
Begin to Model the TWCF
  • Importance and Role of TWCF in restructuring
  • Modeling a Basic 13 Week Cash Flow
  • Modeling Receipts and Operating Disbursements
  • Building the Working Capital Rollforwards
Afternoon
Continue Modeling the TWCF
  • Modeling Non-Operating Disbursements
  • Modeling the Borrowing Base Revolver
  • Cash flow to EBITDA Reconciliation
  • Updating a TWCF for new weeks
  • Modeling Best Practices - Quarterly to Monthly, Monthly to Weekly
  • Sensitizing model assumptions and Impact on TWCF Output
Online
Pre-Seminar Excel training

This boot camp assumes proficiency in Excel. Enrollment includes access to our popular Excel Crash Course for those who need an Excel refresher.

Show More Show Less

Wall Street Prep training is used at ...

clients clients

Who is this boot camp for?

  • Investment banking analysts and associates
  • Private equity, asset management and hedge fund associates
  • Corporate finance and business development professionals
  • MBA students and business undergraduates
  • Anyone seeking to improve their financial modeling skill set

Boot Camp Details

Revisit what you learn This virtual seminar will be recorded and available for you to review any time from your Wall Street Prep learning dashboard.

This boot camp is an intensive instructor-led training program where trainees learn 13-Week Cash Flow Modeling in Excel using an intuitive, step-by-step approach. Participants will use real case studies to build financial models from scratch the way it is done at financial institutions. The program is a synthesis of Excel modeling, navigating through various financial reports, and the application of accounting, corporate finance, and valuation.

What’s Included?

Comprehensive training materials (manuals and online exercises), Detailed reusable modifiable Excel model templates, Unlimited e-mail support for content-related questions for 12 months post-seminar.

What to Bring

Laptop, Notepad, and Calculator.

Prerequisites

This seminar presumes knowledge of financial accounting (at least 1 semester or equivalent). Participants without this background must enroll in and complete the Accounting Crash Course prior to attending the seminar.

CPE Credit

CPE logoWall 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 the 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.learningmarket.org.

Cancellation Policy

Participants may cancel up to 3 weeks prior to the event for a full refund. A 20% cancellation fee will apply up to 1 week prior to the event. No refunds will be granted for cancellations made within 1 week of the event. Wall Street Prep reserves the right to cancel the seminar if enrollment is insufficient. Trainees will be refunded in full in the event of a cancellation.

Show More Show Less

Why attend a boot camp?


  • Comprehensive training

    Our live courses pulls no punches. Each boot camp is the same intensive training used to prepare incoming analysts at top financial institutions.


  • Learn by doing

    Attendees “learn by doing” by working through practical exercises and building financial models from scratch using real case studies.


  • Networking opportunity

    Boot camps provide an opportunity to network with MBAs and professionals from industries including investment banking, corp dev and FP&A.


  • Experienced instructors

    Our instructor-practitioners are experienced bankers who give real-world context by connecting training to their own experience on the desk.


  • Excel Mastery

    Our training reinforces speed, efficiency and consistency in Excel that investment banking analysts are expected to have on Day 1.


  • Continuing ed & webinars

    Enrollment to most boot camps includes access to our continuing education online training platform and webinar series.

Can't Attend? Learn Online Now

Online Course: 13-Week Cash Flow Modeling

  • Learn how to build an Integrated 13-week cash flow model step-by-step.
  • The only course available that teaches complex model mechanics for a 13-week cash flow model.
  • Excel Model Templates Included: Complete 13-Week Cash Flow Model template included with this course
Learn More
CPE logo

Earn 9.5 CPE Credits for this Seminar

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.

Questions? We're standing by.

To learn more about this boot camp, fill out the form below or call us at: 617-314-7685









    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.