Other Industry Event, Other Industry Events, Virtual Events & Programming

13-Week Cash Flow Modeling – Wall Street Prep

Tuesday, May 10 | 9:00 AM - 5:00 PM

Loading Events

Wait! A Note on Registration:

We’ve launched Cvent—our new events platform!

Registration for any event with a start date after Sept. 28 now requires a CFA Institute account.

I don’t have a CFA Institute account

  • No problem! You’ll have the chance to create one prior to registration.

I already have a CFA Institute account

  • Great! Be sure to use your existing credentials at registration.
Cvent Transition Guide

Presented by Wall Street Prep, learn to Build a 13-Week Cash Flow Model

What You’ll Learn

  • 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

CFANY.org: $559
Standard Rate: $699

Agenda

Please note: Each daily session goes from 9AM – 5PM EST


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.

Boot Camp Details

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.


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

This virtual training session is scheduled for 9a-5p (ET). The session will use interactive exercises as learners move back and forth between classroom lecture and small group breakout rooms.

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.


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
Earn 9.5 CPE Credits for this Seminar

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