BIWS | Bank Modeling

Bank Modeling

With Bank Modeling, you will master the fundamentals and nuances of bank and financial institution accounting, valuation, and financial modeling with detailed, step-by-step video training.

  • Quickly grasp the concepts and skills via 4 detailed case studies: The first case study in Bank Modeling teaches you how to build an operating model and valuation for Shawbrook, a U.K.-based “challenger bank,” and how to use those models to make an investment recommendation for the company. The second case study covers KeyCorp’s $4.1 billion acquisition of First Niagara and how bank M&A deals are different, and the last two case studies are private equity/growth equity-related – for ANZ (one of the Big 4 Banks in Australia) and the Philippine Bank of Communications.
  • Dominate your interviews. For your convenience, we provide 13 Overview videos, along with written notes and slides, on the topics most likely to come up in interviews. If you’re short on time, you can get up to speed with these in under an hour and review all the concepts in short order – even if your interview is tomorrow and you just found out about it 5 minutes ago.
  • Learn how to write hedge fund stock pitches, equity research reports, and IB pitch books for banks. Most financial modeling training programs teach you the formulas; we teach you how to use the Excel models in real life to make money and advise clients. The Shawbrook case study builds up to a 32-page stock pitch, a 13-page equity research report, and a 48-slide investment banking pitch book where you make an investment recommendation and advise the company on its best options.
  • Overview lessons cover a bank’s financial statements, regulatory capital under Basel III, loan loss accounting, and a simplified 3-statement projection model and valuation you can use in time-pressured case studies. You’ll also learn about regional differences by analyzing banks’ financial statements across the 6 inhabited continents. This module concludes with an overview of Dodd-Frank, CRD IV, and U.S./E.U. stress testing.
  • Operating Model lessons teach you how to project Shawbrook’s loan portfolio based on GDP growth and market share across multiple scenarios, and how you can use those figures, plus its anticipated credit losses and interest spreads, to derive its three financial statements. You’ll also learn how to estimate key figures like the Liquidity Coverage Ratio and Net Stable Funding Ratio, even when the company does not fully disclose this information.
  • Valuation Module covers public comps and precedent transactions for a bank, a regression analysis, and a multi-stage dividend discount model and residual income (excess returns) model. You’ll learn how to adjust for non-recurring charges and excess or deficit capital, and you’ll use the output of this analysis to make an investment recommendation and to advise the company as if it were a client.
  • M&A Module teaches you how to model the acquisition of a commercial bank, including bank-specific features such as loan marks, deposit divestitures, core deposit intangibles, and the write-down of the Allowance for Loan Losses. You’ll get both a simplified bank merger model and a full, complex one for KeyCorp and First Niagara, and you’ll use both models to answer case study questions and recommend for or against these deals.
  • Bank Buyout and Growth Equity Lessons are based on case studies of ANZ and the Philippine Bank of Communications; you’ll learn how private equity firms invest in the financial services sector, how minority-stake deals differ from control deals, and how to analyze the returns to equity investors in different cases. You’ll also learn how NPL divestitures and funding raised to boost a bank’s Net Stable Funding Ratio work in a private equity context.
  • Bonus Insurance Lessons provide an introduction to the insurance industry, including how accounting, the financial statements, and valuation differ. We walk through an introductory 3-statement insurance model for a new firm and explain how to value both a property & casualty (P&C) insurance company and a life insurance firm.
  • Test Your Knowledge with Practice Exercises and Quizzes. You’ll get “Before” and “After” Excel files for each lesson – follow along with the lesson, and then check your answers afterward. You can also test your knowledge with end-of-module practice quizzes (over 150 questions and answers total).
  • Track Your Progress and Take Notes. Thanks to our custom-designed online learning platform, you can check off each module as you go and take notes on all the lessons for your future reference.
  • 365-Day-Per-Year Expert Support. We have a team of experienced bankers standing by 365 days per year to respond to your questions, comments, and emails, for as long as you need. Even if you have a question on Christmas Day or New Year’s, you’re covered by our support services. Note that we cannot complete assignments for you, but we’re happy to answer specific questions.
  • Course Certification. After completing the course material, you’ll be eligible to take our Certification Quiz. Once you pass the quiz, you’ll receive a Certificate that you can add to your resume / CV and refer to in interviews. So you won’t just possess these skills, you’ll be able to prove you possess these skills. Bankers love that.
Add your Certificate of Achievement for Bank Modeling to your resume and present it in interviews to set yourself apart from others.

Bank modeling certificate

We also make sure employers know that this is a serious qualification: Your certificate will contain a link where prospective employers can review what’s on our exams and what you must master to receive certification.

Unlike other training companies that “issue certifications,” our process is completely transparent: you can literally point to the exact questions you had to answer to pass the quiz and become certified.

Once interviewers see you really do have the “chops” to be a banker, your chances of hiring success go way, WAY up.

 

At last count, over 41,053+ students, entry-level professionals, and career changers have used Breaking Into Wall Street to master modeling, win interviews, and break into high-paying jobs in investment banking, private equity, hedge funds, equity research, and more.

Access Bank modeling Course

purchase bank modeling course