Bank Industry Modeling 102123

Boot Camp Overview

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

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.

Agenda

This event is in Eastern Time (ET).
Each day runs from 9a-5p.

Day 1

Bank Industry Financial Statement Modeling 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.

Day 2

Bank Industry Valuation Modeling 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).

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.

View Full Syllabus

Wall Street Prep training is used at ...

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.

Overview

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.

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

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

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.

Earn 18 CPE Credits with WSP Online Courses

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