Advanced Financial Modeling Highlights

This is the condensed version of this outline. Click Here for the full version.

How to Master Advanced Financial Modeling Skills and Leap Ahead of Your Class - Before You Even Set Foot on the Job

BIWS Advanced Financial Modeling Is a Fast-Track Course in Financial Modeling... as it is Performed in Real-Life, Every Day at Investment Banks, Hedge Funds and Private Equity Firms

Advanced Financial Modeling from Breaking Into Wall Street teaches you how investment bankers model and value real companies in real life.

It allows you to master advanced financial modeling skills, without rocket-science math and without hundreds of hours of boring academic study.

  • There are 100 videos with accompanying Excel files as well as quick reference guide PDFs on key topics. That amounts to 36 hours of video altogether – but you also get full transcripts, so you can quickly skip to anything you need to review.
  • All the content is downloadable to your preferred device (works with all media players and on common devices, including desktops, laptops, tablets, and smartphones).
  • Easily keep track of your progress: As you move through the lessons, you can check off what you’ve completed and what’s still on your “to-do” list.
  • Fast answers to all your questions: Our expert support team is standing by to answer any questions you have about any of the content, 365 days a year.
  • Quizzes and Certifications. After you have completed each course, you will be eligible to take our challenging Certification Quiz. Once you pass the Quiz, you’ll be issued a Certificate that you can add to your resume / CV and refer to in interviews.
  • Included Lifetime Access: You also get lifetime access, so you can come back to the course whenever you need it – whether that’s in 1 month, 1 year, or 10 years.

What Others Are Saying About Our Modeling Courses...

"Great value for [The] Money And I've Recommended BIWS TO A Lot Of Friends"

I signed up of BIWS soon after its release and have since found it to be a really useful training product. Having moved into a pure M&A role but without any ACA or much formal finance training, I needed to get up to speed with DCF and LBO modelling quite quickly, as well as brush up on my accounting knowledge. The Financial Modeling Fundamentals and Advanced Modeling courses were both great for this and gave me enough knowledge and practical skills to get started with. One of the best features of the site and the whole concept is that if there are areas where you need more detailed explanations than those provided in the videos, you ca always get your questions answered in a clear and easy-to-understand fashion through the Comments section at the bottom of each lesson. I think it's been great value for money and I've recommended BIWS to a lot of friends who want to enter investment banking

"It Has Become a Must for Landing Offers"

It is with great pleasure that write the following testimony:

The BIWS course has been instrumental to secure an internship at a BB, and I used it again to prepare and succeed at interviews for an elite boutique. I think that going into an interview without the course immediately puts you at a great disadvantage, as it has become a must for landing offers.

Thanks again for the great work and the awesome articles.

"I believe One of the Main Reasons Behind My Successful Recruitment Efforts Was BIWS"

To be honest, I have been contemplating sending you an email regarding BIWS, but your message comes as a reminder.

The BIWS advanced financial modelling video tutorials and the interview guides have been an invaluable assistant in my recent job search. I managed to get several full-time and internship offers from "bulge bracket" and boutique investment banks (e.g. JP Morgan, Barclays Capital, Houlihan Lokey) and I believe one of the main reasons behind my successful recruitment efforts was BIWS. The technical interview guide covered 70% of all IBD related questions. The financial modelling courses gave me the additional 30%, as well as the confidence needed when discussing more complex valuation and modelling questions.

Additionally, prior to my interviews I was working in a start-up advisory company and, as you might imagine, there was no structured training process. That was the initial and main reason I bought your guides. I found them extremely useful in understanding the fundamental principles behind financial modelling and valuation - linking the three financial statements, building an LBO and merger models from scratch, adjusting multiples, etc.

Hope that helps and thank you for all the efforts in building the website and the related services.

Module 1: Advanced Financial Modeling: Yahoo! Operating Model
  • This module will teach you how to create a detailed 3-statement model for Yahoo!, including revenue and expense builds by segment and supporting schedules such as the PP&E, Working Capital, and Share/Dividend schedules.
  • We'll use a combination of Yahoo's own filings, their investor presentations, and an equity research report from Morgan Stanley to create our 5-year projection model.
  • Once we finish the core operating model, we'll also cover supplemental topics such as deferred income taxes, quarterly projections and calendarization, and possible interview questions and answers.
Module 2: Advanced Financial Modeling: Yahoo! Valuation
  • In this module, you'll learn how to value Yahoo! using public company comparables, precedent transactions, DCF, and more "exotic" methodologies like future share price analysis, sum-of-the- parts, and liquidation valuation.
  • We'll also look at how to value Yahoo's equity investments and net operating losses, and how to factor these into our analysis.
  • Just like at a real bank, we'll use 10-K and 10-Q filings as well as real equity research to complete this exercise.
Module 3: Advanced Financial Modeling: Microsoft / Yahoo! Merger Model
  • In this module, you'll learn how to create a full-fledged 3-statement merger model showing what Microsoft's acquisition of Yahoo would really look like.
  • In addition to covering how to combine and project the 3 statements for both companies, we'll look at more advanced topics like detailed transaction adjustments, asset write-ups, net operating losses in M&A, synergies, and contribution analysis.
  • Just like at a real bank, we'll use 10-K and 10-Q filings as well as real equity research to complete this exercise.
Module 4: Advanced Financial Modeling: Yahoo! LBO Model
  • In this module, you'll learn how to create a detailed LBO model for a hypothetical buyout of Yahoo! by large-cap private equity firms such as KKR and Blackstone.
  • We'll look at how to modify our 3-statement model to support an LBO, and then go into more advanced topics like multiple debt tranches, PIK vs. cash interest, a complex debt schedule with mandatory and optional repayments, tax implications, asset write-ups, balance sheet adjustments, and dividend recaps.
  • In addition, we'll also give you a crash course on the different types of debt and how to use each of them in an LBO model.
Module 5: Advanced Financial Modeling: Deal Commentary & Pitch Book
  • In this module, you'll learn all about the history behind Microsoft's proposed transaction of Yahoo and what impact it would have had on the industry.
  • We'll also look at a sample pitch book that bankers would have used to present the deal to Yahoo's Board of Directors, and go through the contents of the presentation as well as a PowerPoint tutorial on how to create such a pitch book.
  • Finally, we'll conclude with sample interview questions and answers you might receive on this case study and give you Excel printouts you can bring with you to interviews.

Our Promise To You...

  • Get Immediate Access. The instant you sign up, you'll have immediate access to 100 lessons, 36 hours of video and all the PDF Quick Start Guides.
  • Unlimited, 365-Day per Year Support. We have a team of experienced bankers standing by to respond to your questions, comments, and emails 365 days per year, for as you need.
  • Money-Back Guarantee. Breaking Into Wall Street is the first and only financial modeling training program that comes with an unconditional 12-Month Money-Back Guarantee.
  • Course Certifications. After completing the course material, you're eligible to take our Certification Quiz. Once you pass the quiz, you'll be issued a Certificate that you can add to your resume / CV and refer to in interviews.