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

Bank Industry Modeling – Wall Street Prep

August 27, 2022 - August 28, 2022

Share Event

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

What You’ll Learn

The unique regulatory framework and business model of financial institutions pose specific challenges in the areas of analysis, forecasting and valuation. In this 2-day course, participants will focus exclusively on banks. On Day 1, you will understand the operating model of banks and regulatory and capital implication, and learn how to analyze the financial statements of a bank and begin building a complete bank forecast model. On Day 2, you will complete the forecast model, then create a Dividend Discount Model (DDM) for bank valuation. The course will conclude with a discussion of specific considerations around bank M&A. This intensive course is designed to equip professionals engaged in the analysis and valuation of banks, with the hands-on skill set needed on the job and is taught by an experienced FIG investment banker.

  • Learn the regulatory framework of commercial banks
  • Build a financial institution forecast model
  • Understand the challenges with bank valuation
  • Includes Excel Financial Institution model templates

CFANY.org: $1,599
Standard Rate: $1,999


View Full Syllabus


You will learn how to build an annual forecast model for a financial institution while being guided through the unique regulatory framework and business model of banks.


You will build perform valuation modeling on a financial institution, while navigating through the unique industry challenges of expensing of debt service and income, the regulatory constraints on reinvestment, and the calculation of levered vs. unlevered free cash flows. Alternative approaches to valuation will be discussed including Dividend Discount Models (DDM).


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 training program where trainees learn bank and FIG 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 courses.

This virtual training session will run from 9a-5p daily (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.


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