$40.00 $399.00
Tailored for FIG professionals in banking, equity research, and corporate finance, this course provides comprehensive training on bank financial statements, key drivers, and regulatory frameworks.
Course Objective
At completion, trainees will have built a fully integrated financial statement model, RI model and DDM
The analysis of banks is different from that of most other types of industries. As a result, analysis requires adjustments and different approaches from traditional valuation methodologies. Wall Street Prep’s bank modeling course will guide you step-by-step through a bank’s financial statements, unique drivers and regulatory framework. You will build a fully integrated financial statement model, a residual income (RI) model, and a dividend discount model (DDM) using Valley National Bank as a case study.
What You Will Learn
SECTION ONE: BUILDING A BANK FORECAST MODEL
- Build an advanced bank forecast model, projecting asset and liability balances, interest rates and spreads for key assets and liabilities, using industry best practices.
- Learn to effectively forecast the loan portfolio, investment securities, and deposits.
- Understand the modeling and forecasting of allowances for loan losses and net charge offs (NCOs).
- Model regulatory constraints and analyze effects on leverage, capital ratios, and profitability.
- Forecast net interest income (NII), asset yields, funding costs and interest earning assets (IEA) and liabilities (IBL) using an approach that takes into account typical disclosure gaps, is internally consistent, and avoids common modeling pitfalls.
- Build an advanced bank forecast model, projecting asset and liability balances, interest rates and spreads for key assets and liabilities, using industry best practices.
- Learn common forecast approaches for the non-interest income and expenses such as fees, and compensation.
- Identify the most appropriate “plugs” in a bank model to ensure the model balances, and address circular reference issues in the model.
SECTION TWO: BUILDING A BANK VALUATION MODEL
- Using the results derived from the forecast model, build a residual (excess returns) income model.
- Build an adjusted dividend discount model using the prevailing beset practices for banks (not the same as non-banks).
- Analyze how regulatory capital constraints effect valuation.
- Develop assumptions about return on equity (ROE), risk weight assets (RWA), cost of equity, and minimal capital ratio that are internally consistent for a multiple stage model.
- Compare the other valuation approaches such as comps and DCF and identify strengths and limitations of each approach.
Course Highlights
Real World “On the Job” Investment Banking Training
The Bank Modeling Self Study Program bridges the gap between academics and the real world to equip industry professionals with the practical financial skill set they need on the job. The program utilizes a case study format, as students follow their tutorial guide alongside the Excel model templates, and are directed to the appropriate external documents (SEC filings, research reports, etc.) in order to build complex financial & valuation models the way they would on the job.
Support Center
Upon enrollment, students gain 24-month free access to Wall Street Prep’s Online Support Center, where they receive answers to questions, free downloads, and important updates.
Prerequisites
This course does not assume a prior background in Bank & FIG Modeling. However, those who enroll should have an introductory knowledge of accounting (e.g. interaction of balance sheet, cash flow, and income statement) and proficiency in Excel. Students with no prior background in Accounting should enroll in the Accounting Crash Course. Students with limited experience using Excel should enroll in the Excel Crash Course.
About the author
Wall Street Prep was established in 2004 by investment bankers to train the financial services industry. Our instructor-led and online training programs bridge the gap between academia and the real world by teaching the practical skills needed to succeed on the job. Our global faculty is a group of 90+ highly specialized investment bankers, private equity and investment professionals.
Wall Street Prep
RELATED COURSES
VIEW ALL-
Raghee Horner’s Workspace Bundle + Live Trading – Simpler Trading$59.00
$597.00Raghee Horner’s Workspace Bundle + Live Trading – Simpler TradingUpdate 18 Jul 2022Raghee Horner’s Workspace Bundle + Live Trading by Simpler Trading instructs you on many powerful trading tools for various instruments and time frames.
Add to wishlist -
The New Micro Voodoo Line Strategy (Elite Package) – Simpler Trading$150.00
$1,297.00The New Micro Voodoo Line Strategy (Elite Package) – Simpler TradingUpdate 21 Apr 2023All LevelsThe New Micro Voodoo Line Strategy by Simpler Trading is a trading strategy designed to help traders identify potential entry and exit points in the market. It is suitable for all experience levels and comes with educational materials and support.
Add to wishlist -
Price Action Manipulation Course – Piranha Profits$89.00
$897.00Price Action Manipulation Course – Piranha ProfitsUpdate 18 Jul 2022Price Action Manipulation Course by Piranha Profits shares the guideline of how to adapt such a strategy to multiple instruments and time frames.
Add to wishlist -
Trading Psychology and Money Management Blueprint – Simpler Trading$44.00
$297.00Trading Psychology and Money Management Blueprint – Simpler TradingUpdate 21 Sep 2022All LevelsTrading Psychology and Money Management Blueprint by Simpler Trading highlights the crucial role in the success of a trader in any instrument. Tried-and-true methods to control emotions while trading by John Carter and Danielle Shay are what you can expect.
Add to wishlist -
Value Trap Indicator Complete Package – Einvesting For Beginners$15.00
$197.00Value Trap Indicator Complete Package – Einvesting For BeginnersUpdate 28 Jan 2025The Value Trap Indicator Package helps you analyze companies using key metrics, with tools like a book, audiobook, spreadsheet, bankruptcy data, and a special report.
Add to wishlist -
SpotGamma Trading Bootcamp – SpotGamma Academy$200.00
$2,497.00SpotGamma Trading Bootcamp – SpotGamma AcademyUpdate 09 Dec 2022AdvancedDetailed instructions and practical case studies are what you can learn from the SpotGamma Trading Bootcamp by the SpotGamma Academy. Access to powerful tools and proven approaches by SpotGamma Academy opens an ample chance to enhance your trading for better risk/reward ratios.
Add to wishlist