✉️ Get insider updates on webinars, Excel tips, and more! Subscribe Now
Client Login

Forgot password?

Citigroup logo
Goldman Sachs logo
Bank of America Merrill Lynch logo
JPMorgan Chase logo
Oppenheimer logo
FTI Consulting logo
Lazard logo
Apollo Global Management logo
TIAA logo
Greenhill logo
TPG Capital logo

If banking professionals and regulators took our training...

SVB wouldn’t have collapsed.
they’d understand why bank modeling is opposite from other industries.
translating term structure of interest rates to the P&L wouldn’t be so much brain damage.
they’d understand why capital adequacy ratios are ineffective.

SVB's collapse could've been avoided if they knew how banks work.

Everything In Reverse

Flip your modeling knowledge upside down. For banks, it’s BS first, then IS.

Key Bank Drivers

Evaluate interest rate term structures and asset-liability duration matching.

Anatomy of a Bank Run

Model out relevant capital requirements to account for potential catastrophe.

Who needs this?

Financial professionals with exposure to this industry, such as:

Bankers Research Analysts Advisors Asset Managers Internal Corporate Finance Professionals

… and anyone fed up with the Fed, who needs to adapt to a changing interest rate environment.

  • Understand the impact of interest rates, term structure, and credit spreads
  • Masterfully analyze a bank's entire Balance Sheet (assets and liabilities)
  • Quantify drivers of profitability, EPS growth, and valuation

Course Sections

Section 1

Banking Industry Primer

Take a broad overview of the 3 main banking functions, and understand what Tier I, Tier II, and Basel II mean.

In short: What makes a bank so unique to analyze?

Section 2

Banking Financial Statement Terminology & Drivers

Step into the world of banking financial statements: Net Interest Income Margin, special Balance Sheet items, and key valuation multiples.

Develop the logic of loan losses and provisions, especially how they impact everything else.

Section 3

Financial & Capital Ratios

Identify critical credit ratios and capital adequacy metrics - including all the nuances and ways to game them.

These will play a central role in any bank model.

Section 4

Bank Valuation Metrics

Analyze internal profitability ratios to measure the bank’s core performance.

Walk through the proper calculation of multiples used in the banking industry.

Section 5

Bank Financial Modeling

Take your pick: Basic, Intermediate, or Advanced.

Believe us when we say the rabbit hole gets quite deep.

Training Methodology

Our approach is to teach you how to fish, rather than give you a fish.

We don't give a one-way lecture where you memorize every cell and formula.

We nudge you toward uncovering answers on your own by leading with the right questions.

The end result? Longer-term knowledge retention that will last an entire career.

I really felt that WST was world class and would recommend it to anyone starting a new career on Wall Street. In particular, the strength of the program is that it concentrates on how analytical work is actually conducted in real life rather than the academic approach of some other competitors.
You'll walk out of this class with the confidence to:
  • Evaluate the quality of a bank’s book of loans and analyze net charge-offs
  • Model net interest income margin as the main revenue driver
  • Implement the proper modeling flow, starting on the BS, proceeding to the IS and CF
  • Set and calculate valuation parameters (key banking valuation multiples)
Not bad for a few days' work.

Get Started

Detailed Curriculum

Package: Bank Financial Modeling

Balance sheet based companies, such as banks, play by different rules and methodologies based on the unique nature of their business. Focus is placed on our Commercial Banks financial statements primer which dives deep into a bank’s unique financial statement terminology and drivers. Understand how to analyze a bank and why the standard financial analysis and valuation methodologies that apply to most companies do not apply to industries that “use money to make money”. Start with a brief overview of the main banking functions (commercial, investment, asset management) and quickly turn to the quality of book of loans and analysis of net vs gross charge-offs vs provisions, etc. Understand the critical credit ratios and capital adequacy analysis as well as Tier 1 and II definitions and Basel II impact. Crystallize the impact of Interest Rates, importance of term structure and credit spreads and implications on a bank’s profitability. Examine best practices in calculating net interest income via average asset and liability balances on the income statement. Dive into an analysis of Balance Sheet assets & liabilities and articulate the drivers of EPS growth. Wrap up by analyzing valuation parameters: key banking valuation multiples (PE, PEG, Book Value, ROE).

Banking Industry Overview
  • Overview of main banking functions (commercial, investment, asset management)
  • Quality of book of loans and analysis of net charge-offs
  • Critical credit ratios and capital adequacy analysis; Tier 1 and 2 definitions and Basel impact
  • Impact of Interest Rates, importance of term structure and credit spreads
Banking Financial Statement Terminology & Drivers
  • Net Interest Income Margin (Interest Expense net against Revenue not COGS)
  • Analysis of Balance Sheet Assets & Liabilities
  • Drivers of EPS growth
  • Valuation Parameters: key banking valuation multiples (PE, PEG, Book Value, ROE)
Prerequisites
  • Accounting & Financial Statements Integration
  • Corporate Valuation Methodologies
  • Basic Financial Modeling
Video Length / Estimated Total Course Time

2.5 hours / 4 hours

Build a basic, streamlined bank financial model that builds upon the bank terminology in our Bank Industry Primer course. Before diving deep into the complex nuances of our Advanced Bank Financial Model, really solidify your understanding of developing the logic in loan losses and provisions and its impact on the rest of the larger bank financial statements. Perform quick back-of-the-envelope calculations for key Balance Sheet items such as Interest Earning Assets and Interest Bearing Liabilities, which yield Net Interest Income. Estimate and calculate capital adequacy ratios to wrap up your summary simplified basic bank model.

Prerequisites
  • Bank Industry Primer
Video Length / Estimated Total Course Time

2 hours / 3 hours

Construct a more robust bank financial model by building a bank balance sheet and derived income statement. Project gross loan balance, provisions for credit losses, gross charge-offs, recoveries, net charge-offs, net loan balance based on important key trends and ratios. Predict the critical funding requirements on the liability side of the balance sheet to support the loans and asset side. Learn the techniques and best practices to balancing the bank model. Examine different techniques to estimate the crucial interest-earning assets and interest-bearing liabilities. Estimate asset yield, funding costs and net interest spread to minimize forecasting error. Identify line items that constitute non-interest fee revenue beyond using simple percent growth rates. Incorporate and integrate provision for credit losses. Calculate compensation and overhead expenses and leave with a completed balance sheet and income statement. Make sure you master the concepts in this Intermediate class before diving into our Advanced Bank Financial Modeling course.

Prerequisites
  • Bank Industry Primer
  • Basic Bank Financial Modeling
Video Length / Estimated Total Course Time

2 hours / 3 hours

The standard financial analysis and valuation methodologies that apply to most companies do not apply to industries that “use money to make money”. Balance Sheet based companies, such as banks, play by different rules and methodologies based on the unique nature of their businesses. First, start off with an interactive primer on commercial banks and their financial statement terminology and drivers. Then, build a fully integrated bank financial model that addresses the key drivers of profitability, cash flow, and valuation. Focus is placed on: projecting the Balance Sheet line items which drive the entire model; estimating interest-earning assets and interest-bearing liabilities which drives profitability; projecting loan portfolio growth, provisions for credit losses, and net charge-offs which determine overall impact on the financial statements. Complete the model by projecting different fee revenue sources and integrating the Cash Flow Statement. Finish the model by calculating and analyzing capital adequacy ratios, financial performance indicators and valuation metrics.

Balance Sheet
  • Project gross loan balance, provisions for credit losses, gross charge-offs, recoveries, net charge-offs, net loan balance based on important key trends and ratios
  • Analyze detailed components of and balance scope vs depth in projecting mix of loan portfolio
  • Project the critical funding requirements on the liability side of the Balance Sheet to support the loans and asset side of the Balance Sheet based on bank modeling best practices
  • Dynamically calculate the critical fed funds sold and purchased line items
  • Properly incorporate the equity account based on financing activities from Cash Flow Statement
  • Calculate crucial interest-earning assets and interest-bearing liabilities from the Balance Sheet
  • Estimate asset yield, funding costs and net interest spread to minimize forecasting error
Income Statement
  • Calculate future Net Interest Income and margin from IEA and IBL
  • Project line items that constitute non-interest fee revenue beyond using simple % growth rates
  • Incorporate and dynamically integrate provision for credit losses on IS and BS
  • Estimate compensation and overhead expenses to round out the Income Statement
  • Correctly incorporate and integrate share buybacks and issuances, treasury options, restricted stock units and stock-based compensation into all three financial statements (IS, BS, CF)
Cash Flow Statement
  • Construct automated Cash Flow Statement based on the Income Statement and Balance Sheet
  • Differentiate between a bank's financial statements by properly allocating and including correct components of CFO, CFI and CFF
  • Understand and appreciate which line items are impossible to calculate independently and must be lumped and grouped together to arrive at the net impact instead of tediously (and incorrectly) trying to project every single item
  • Build more supporting detailed schedules to project dividends and stock repurchases and issuances and have it properly flow through the rest of the financials
Financial & Capital Ratios and Valuation Metrics
  • Construct and analyze internal profitability ratios to analyze core performance of the bank
  • Calculate profitability ratios and asset utilization ratios for direct comparisons
  • Reconstruct and estimate Tier I and Total Capital (Tier I and II) , risk weighted assets, adjusted assets and corresponding capital adequacy ratios for regulatory supervision
  • Calculate current market multiples and valuation metrics relevant for a bank
Prerequisites
  • Basic Financial Modeling
  • Advanced Financial Modeling - Core Model
  • M&A Deal Structuring
  • Merger Modeling Basics
  • LBO Overview
  • Quick & Dirty LBO Modeling
  • Efficiency in Excel
Video Length / Estimated Total Course Time

5 hours / 9 hours

Have more questions?

Text or email us – we're here to help.