Breaking Into Wall Street – Master Financial Modeling for Investment Banking

Here’s How to Get a Crash Course in Accounting, Valuation, and Financial Modeling

So You Can Ace Your Investment Banking Interviews and Succeed On The Job

• Become a financial modeling pro
  158 videos, detailed written guides, Excel files, quizzes, and more
• Complete 10+ detailed global case studies
  These include both the theory and the practical applications
• Prepare for your internship or full-time job
  Gain the skills you need to “hit the ground running” on Day 1

When you’re interviewing for internships and full-time positions at investment banks, you’ll always get a few questions over and over…

• How much do you know about accounting?
• Can you walk me through a valuation?
• What happens in a merger model or LBO model when you adjust the assumptions…
• How would you describe your financial modeling skills?

When you master real-world techniques and case studies, you have a significantly better chance of landing prime jobs and internships with the top investment banks, private equity firms, and hedge funds.

The Core Financial Modeling course helps you gain all that real-world knowledge via video-based training created by investment bankers.

You’ll get a total of 158 videos – everything you need to beat the competition in interviews and get a head start before you start working. You’ll also get detailed written guides and transcripts to make it easier to scan and review the topics (and each video comes with full captions/subtitles).

MUCH MORE THAN THEORY

We base everything in the Core Financial Modeling course on what investment bankers and other finance professionals actually do in real life:

• To gain the proper background, you’ll start by learning key accounting and finance concepts with examples based on real companies, such as Target and Best Buy; you’ll learn how the financial statements link together and how you can analyze them with key metrics and ratios.
• Then, you’ll move into the “global case studies,” which include companies such as Monster Beverage (U.S.), Stadler Rail (Switzerland), Coles (Australia), Vivendi (France), Steel Dynamics (U.S.), Builders FirstSource / BMC Stock Holdings (U.S.), NichiiGakkan (Japan), Great Canadian Gaming Corporation (Canada), and Netflix (U.S.).
• In each case study, you’ll analyze a company or deal, build a model, and then make an investment recommendation or recommend the proper price and deal structure. This is the type of work you do all day in investment banking, private equity, and hedge funds.

Through these case studies, you’ll:

• Build 3-statement projection models and learn how to answer accounting questions in interviews.
• Understand Equity Value and Enterprise Value at a deep level – way beyond whatever the paid monkey army on Investopedia or ChatGPT can regurgitate!
• Value a company – from finding public comps and precedent transaction to building a DCF model to using the valuation output in a stock pitch, pitch book, and equity research report.
• Create merger models – from combining and adjusting the financial statements to evaluating accretion/dilution
• and other metrics to using the model to advise clients on their best options.
• Build LBO models, from the transaction assumptions to the debt schedules, financial projections, cash flows, and calculations of the IRR and money-on-money multiples – and the investment recommendation at the end.

The information you’ll find is so detailed and so thorough that our customers regularly come from top-ranked universities, investment banks, and business schools.

What You’ll Learn In Master Financial Modeling for Investment Banking

• Module 1: Modeling Overview and Core Concepts
  In this introductory module, you’ll learn what “financial modeling” means, how you use it in real life, and the core concepts required to understand the rest of this course, including the time value of money, Present Value and Net Present Value, the Discount Rate, and the Internal Rate of Return (IRR).
• Module 2: Accounting Concepts and the Financial Statements
  In this module, you’ll learn the fundamental concepts of accounting, including the three financial statements, cash vs. non-cash revenue and expenses, and how companies record short-term and long-term changes. You’ll also learn about CapEx, leases, and M&A accounting.
• Module 3: Accounting Summary, Interview Questions, and Financial Statement Analysis
  This module gives you a summary of the financial statements and practice interview questions so you can test your knowledge (along with solutions in our “interview question” 3-statement Excel model). The lessons also cover financial statement analysis.
• Module 4: 3-Statement Modeling Case Studies from Templates (30 Minutes and 60 Minutes)
  In this module, you’ll complete two 3-statement modeling case studies with varying time limits and difficulties based on companies in different industries and regions (Monster Beverage in the U.S. and Stadler Rail AG in Switzerland).
• Module 5: 3-Statement Modeling Case Study from a Blank Sheet (2 Hours)
  You’ll complete a 3-statement model for Coles, a grocery retailer in Australia, starting from a blank Excel sheet in this module. You’ll learn how to find and input data, simplify the statements, and make reasonable forecasts under a strict time limit.
• Module 6: Equity Value, Enterprise Value, and Valuation Multiples (Target, Vivendi, and Zendesk)
  In this module, you’ll learn how to calculate Equity Value, Enterprise Value, and valuation multiples for companies, including both the fundamentals and more advanced items, such as Equity Investments, Noncontrolling Interests, Pensions, Leases, and Net Operating Losses.
• Module 7: 3-Hour Valuation and DCF Case Study from Blank Sheet (Steel Dynamics)
  In this module, you’ll complete a 3-hour valuation and DCF case study based on Steel Dynamics, a steel manufacturing company in the U.S., and you’ll learn how to project Free Cash Flow, calculate the Discount Rate, estimate Terminal Value, and use Public Comps and Precedent Transactions.
• Module 8: Real-Life Valuation Usage and Supplemental Methodologies [OPTIONAL]
  In this optional module, you’ll learn how to use a valuation in an investment banking pitch book, hedge fund stock pitch, and equity research report, and you’ll learn about less-common valuation methodologies, such as the Levered DCF, Dividend Discount Model, and Sum of the Parts Analysis.
• Module 9: M&A Concepts and 60-Minute Merger Model
  In this module, you’ll learn the fundamentals of mergers and acquisitions (M&A), including several short exercises in the beginning and a 60-minute version of a full merger model for Builders FirstSource’s $2.5 billion acquisition of BMC Stock Holdings.
• Module 10: Full Merger Model (3 Hours)
  In this module, you’ll complete a 3-hour merger model for Builders FirstSource’s $2.5 billion acquisition of BMC Stock Holdings. Features include a full Balance Sheet combination, an IRR vs. Discount Rate analysis, a quick valuation, a Contribution Analysis, and a Value Creation Analysis.
• Module 11: Leveraged Buyout Concepts and Simple LBO Models (30-Minute to 90-Minute Case Studies)
  In this module, you’ll get an introduction to leveraged buyouts and LBO models, starting with simple models that can be completed in 30-90 minutes. You’ll learn the most common topics tested in LBO case studies and how to complete them efficiently under time pressure.
• Module 12: 3-Hour LBO Model from a Template (Great Canadian Gaming Corporation)
  You’ll complete a 3-hour LBO modeling test based on Apollo’s leveraged buyout of the Great Canadian Gaming Corporation (GCGC) in this module, and you’ll learn how to build a full 3-statement LBO with support for earn-outs, a complex debt schedule, and a variable exit year.
• Module 13: Debt vs. Equity, Bond Analysis, and Equity Offerings (Netflix) [OPTIONAL]
  In this optional module, you’ll learn about topics relevant to groups such as DCM (Debt Capital Markets), Leveraged Finance (LevFin), and Equity Capital Markets (ECM), including debt vs. equity analysis, bond analysis, and models for IPOs and Follow-On Offerings.