BIWS Premium (Excel & VBA + Financial Modeling Mastery + PowerPoint Pro) – Break Into Wall Street

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.