Master Financial Modeling In Excel For Investment Banking
How to Learn Valuation and Financial Modeling In Excel and Dominate Your Investment Banking Interviews
Introducing the course that members are calling 'Deal Experience in a Box'... The Excel & Financial Modeling Fundamentals Course is so close to the "real thing" it's uncanny.
No other Investment Banking or Microsoft Excel course on the market today - at ANY price - arms you with the same conceptual and practical expertise.
You'll quickly gain 'virtual deal experience' with 10+ comprehensive, real-life investment banking, private equity, hedge fund, and equity research case studies from around the globe so you can beat out other candidates in interviews and rapidly move up the ladder.
Ensure Your Competitive Edge in Today's Market. Get dozens of
video tutorials, notes for each lesson, transcripts, and 10+ in-depth, practical
case studies from around the globe. Achieve the deep conceptual understanding that
bankers are looking for, but rarely find - and discover how to use financial modeling
using Microsoft Excel in real life to outperform your peers on the job.
Dominate Your Interviews. The Financial Modeling Fundamentals lessons take you from A to Z in accounting, valuation, and financial modeling - and you'll get to test your knowledge by completing practice exercises along the way, and by answering the written case study questions at the end of each module.
Prepare for IB, PE, and HF Case Studies. Everything in the course is based on case studies of real companies – including companies in North America, Europe, Asia, and Australia - to ensure you gain a truly global perspective. You’ll know exactly what interviewers are looking for in case studies, and you'll learn how to set up your models and answer questions successfully.
Learn by Watching with Video-Based Training. Video learning is more engaging, and there’s no substitute for watching over the shoulder of an IB veteran as they work through real-world Excel models. But it’s also helpful to have the written version, so you'll get notes in the Excel files for each lesson, along with quick reference PDFs and the full, word-for-word transcripts.
Master Financial Modeling With Excel. Whether you’re a novice or an experienced user, you’ll be a bona fide pro by the end of this course – and you’ll save hours of spreadsheet drudgery. That translates into better reviews and bigger bonuses... and more lucrative exit opportunities, of course.
Learn Accounting, Valuation, and Merger and LBO Models. These are the fundamental skills you'll need in investment banking, private equity, and hedge funds - and you'll be ahead of the game by mastering them before you start working.
Test Your Knowledge with Practice Exercises. You'll get "Before" and "After" Excel files for each lesson - follow along with the lesson, complete the exercises, and check your answers afterward. You can use these exercises to learn, measure your progress, and review the material quickly whenever you need it.
Test Yourself with In-Video Quiz Questions. Hundreds of in-video quiz questions allow you to test your knowledge, guarantee your engagement, and support quicker mastery of the concepts. You can also test yourself with a separate quiz at the end of each module in the course.
Track Your Progress and Take Notes. You can check off each lesson as you move through the material - and take notes throughout. It’s easy to return and refresh your knowledge whenever you need to do so. You can also bookmark your exact progress in each lesson and create Playlists of the key lessons you want to review.
Get All Your Questions Answered. You get world-class support - experienced bankers will answer your questions, comments, and emails 365 days per year, for a full 24 months after purchase (Yes, even if you get a case study and you have questions on Christmas Day or New Year's).
Course Certifications. After completing the course, 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 as evidence of your knowledge and skill set.
Breaking Into Wall Street has now helped 41,053+ students and entry-level professionals launch lucrative careers in investment banking, private equity, hedge funds, equity research, corporate finance, and related fields.
We spent over a year with our ear to the ground, analyzing every comment and every support email to uncover what NEW challenges BIWS members are facing in today's real-world job market.
Here’s what we discovered, and how the job market and interviews themselves have changed...
The World Has Changed... We’ve Adapted and So Must You!
Case studies and modeling tests have become common in all types of interviews, even for 2nd year
university interns. You need to be able to “talk the talk” AND demonstrate knowledge ‘on demand’ - not
only as it relates to one company from one case study in one industry.
Conceptual explanations have become critical, and you can’t answer interview questions without understanding
the concepts. A lot of candidates have been memorizing responses from interview guides... so interviewers are asking more and more questions related to the concepts rather than specific facts or formulas.
Self-testing is also crucial – yes, you can always complete the Excel files yourself, but you should be able to test yourself in multiple different ways. And, you might just want a very quick review of the key concepts so you’re confident you’ve
‘got it down.’
You need to understand how to use modeling in real life – Many courses are "formula-focused," but knowing the formulas won't teach you how to advise clients or make money from your investment decisions in real life - the key skills you need on the job, and in interviews.
Global deals and local differences are increasingly important - so you need to know how IFRS differs from US GAAP, how companies in different countries might do deals differently, and where to find the information regardless of which region you're in.
In response to those changes, we developed the latest, greatest version of this course.
You'll learn the concepts and put them into practice with companies and deals across 4 continents, and you'll complete a series of case study presentations and written responses for the major topic areas.
Plus, you'll test yourself along the way on both the concepts and the execution, with quiz questions, Excel exercises, and written documents and case study prompts.
What You Get – And What the Excel & Financial Modeling Fundamentals Course Will Do for You...
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
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.
Excel & Financial Modeling Fundamentals lets you gain all that real-world knowledge via video-based training created by investment bankers.
You'll get a total of 351 videos – everything you need to beat the competition in interviews and get a head start before you
start working. You also get word-for-word transcripts of all the videos, to
make scanning and note-taking even easier.
MUCH MORE THAN THEORY
We base everything in the Excel & Financial Modeling Fundamentals course on what investment bankers actually do in real life:
The Excel lessons are based on two real-life case studies:
how to format, manipulate, and analyze customer due
diligence data, and how to build and format a 3-statement
model and valuation of Walmart.
The Financial Modeling Fundamentals lessons are based
on 10+ case studies involving companies such as Atlassian
(Australia), EasyJet (U.K.), Vivendi (France), Steel Dynamics (U.S.),
Jazz Pharmaceuticals (U.S.), Men's Wearhouse / Jos. A. Bank
(U.S.), Suntory / Beam (Japan and U.S.), 7 Days Inn (China),
Chuck E. Cheese's (U.S.), Kakao / Daum (Korea), and Netflix (U.S.).
...and you'll get bonus case studies and tutorials on Intel's
$8B acquisition of McAfee, ConAgra's $5B bid for Ralcorp,
TPG's $3B leveraged buyout of JCrew, and more.
Through these case studies, you'll discover how to:
Use Excel and master all the shortcuts – in any modern
version of Excel, on both the PC and Mac.
Build a 3-statement projection model and answer accounting questions in interviews.
Value a company – how to find public comps and
precedent transaction and get the right data, and how to
build a DCF model to value a company based on its future
cash flows. And then how to use the valuation output in a
stock pitch, a pitch book, and an equity research report.
Create a merger model – learn what happens when one
company acquires another one, how to evaluate accretion
/ dilution and other metrics, and how to use the financial
metrics to advise your clients on what to do.
Build LBO models – how to set up the assumptions, create
debt schedules, model interest and principal repayments,
and calculate the IRR and MoM multiples... and then make
an investment recommendation.
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.
Once you've completed the training, here's what you'll be able to write on your resume / CV:
Financial Modeling Fundamentals (BIWS)
Completed modeling tutorials based on case studies of companies and deals in North America, Europe, Asia, and Australia
Built 3-statement projection model for EasyJet (U.K.) based on airline’s key drivers for revenue, expenses, and cash flows; concluded that company could not use 100% Debt for future financing needs and would have to use 50% Equity and 50% Debt instead
Valued Jazz Pharmaceuticals (U.S.) based on drug-by-drug financial projections and Public Comps, Precedent Transactions, and 10-year DCF analysis; concluded that company was overvalued by 50-70% and made Short recommendation
Completed case study based on Carlyle’s $687 million leveraged buyout of 7 Days Inn (China); projected revenue, expenses, and cash flow, set up LBO model, and made positive investment recommendation based on high probability of achieving 20% IRR over 5 years
Received course certification for Excel and Fundamentals courses by passing quizzes with score of at least 90%
Gain Official Recognition of Your Training With BIWS Certifications
After completing the course materials, you’ll be eligible to take our challenging Certification Quiz. Once you earn a score of at least 90%, you’ll be issued a personalized Certificate of Achievement with your name, the course name, and the date you passed the quiz:
Your Certificate of Achievement can be added to your resume/CV and/or presented in interviews to set yourself apart from other candidates.
We also make sure employers know how challenging the certification process is: 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.
Add To Cart Just 1 Payment of $347 100% Unconditional Money-Back Guarantee
Take a Look at What You’ll Get Immediately After Signing Up...
Excel & VBA Course
In this course, you'll master Excel and learn how to use VBA efficiently to write and edit macros to automate your work. You will complete two case studies: one based on an operating model and valuation of Walmart, and one based on an analysis of customer and sales rep data for due diligence purposes. Through these case studies, you'll learn how to navigate Excel, set up formatting and printing, use formulas and built-in functions, manipulate and analyze data, create graphs and charts, and write macros and VBA code.
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: The 3 Financial Statements
We’ll explore accounting from a business perspective, and we’ll drill down using examples of our own online business to teach you how and why the 3 financial statements work the way they do – and you’ll understand how to think about the rules that link the statements.
Module 3: Accounting Interview Questions & More Advanced Topics
You'll get a crash course on the 4 main categories of accounting-related interview questions here, and you’ll learn about more advanced topics, such as LIFO vs. FIFO for Inventory, Operating Leases vs. Capital Leases, Unrealized Gains, Pension Accounting, Equity Investments and Noncontrolling Interests, Net Operating Losses, PIK interest, and tax-related items on the financial statements.
Module 4: Projecting the 3 Statements (Toro and Atlassian)
In this module, you’ll complete 60-minute and 2-hour case studies based on 3-statement projection models for Toro, a landscape maintenance equipment company, and Atlassian, a subscription-based enterprise software company, and you'll make investment recommendations based on the output of both exercises.
Module 5: More Advanced 3-Statement Projections (EasyJet)
In this module, you’ll complete a 3-hour 3-statement modeling test for EasyJet, a low-cost carrier based in the U.K., with routes all over Europe. You will then use the output of this model to advise the company on its proper mix of Debt and Equity. You will build revenue and expense projections based on drivers such as ASKs, Load Factors, and Passenger Yields, and you'll add a Debt & Equity Schedule to the model to support the company's financing needs.
Module 6: Equity Value, Enterprise Value, and Multiples (Vivendi)
In this case study, you will analyze the financial statements of Vivendi, a leading French media and telecom conglomerate. You’ll use the information to calculate its Equity Value, Enterprise Value, and key valuation metrics and multiples. You’ll understand precisely what these numbers tell you about Vivendi’s valuation relative to its peer companies.
Module 7: Valuation and DCF Case Study (Steel Dynamics)
In this module, you’ll complete a 2-hour valuation and DCF case study based on Steel Dynamics, a leading 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: More Advanced Valuation and DCF Case Study (Jazz Pharmaceuticals)
In this module, you’ll complete a 1-week “take home” valuation and DCF case study based on Jazz Pharmaceuticals, a specialty pharmaceutical company based in the U.S. that develops orphan drugs. You'll project revenue for its existing and pipeline drugs, add stub periods and the mid-year convention to the DCF, and complete Public Comps and Precedent Transactions using corporate filings.
Module 9: Valuation Interpretation and Real-Life Usage (Jazz Pharmaceuticals)
In this module, you’ll learn how to apply and interpret a valuation in real life by creating a short stock pitch (for hedge fund and asset management roles), equity research report, and investment banking pitch book for Jazz Pharmaceuticals based on the valuation and DCF analysis from the previous module.
Module 10: M&A Deals and Merger Models (Jos. A. Bank and Men’s Wearhouse)
In this case study, you’ll analyze the M&A deal between Jos. A. Bank and Men’s Wearhouse, two leading US-based men’s clothing retailers. You’ll make a recommendation on the purchase price and deal structure, and draw some conclusions on the possible accretion / dilution and merits of the deal.
Module 11: More Advanced Merger Models (Suntory and Beam)
In this case study, you’ll analyze Suntory Holdings' $16 billion acquisition of Beam, the world’s 4th largest premium spirits company at the time of the acquisition. You’ll learn more advanced nuances of merger models here, including what to do for cross-border (Japan / US) deals, how to combine valuation work and M&A analysis, how to use quarterly projections in your models, and how to make a detailed recommendation to your client based on the numbers.
Module 12: Leveraged Buyouts and LBO Models (7 Days Inn)
In this case study, you’ll analyze Carlyle’s leveraged buyout of 7 Days Inn, one of the leading business travel hotel chains in China. You’ll get a crash course on the concepts behind leveraged buyouts, and then you’ll complete a quick but accurate analysis for this deal and use it to make an investment recommendation.
Module 13: More Advanced LBO Models (Chuck E. Cheese's)
You will build a more advanced LBO model for Apollo’s buyout of Chuck E. Cheese's, a US-based kids' restaurant chain, in this case study. You’ll add more advanced debt schedules and revenue/expense/CapEx assumptions to your model, and you’ll learn how options such as PIK interest, NOLs and deferred taxes, and sponsor-issued dividends impact the model. At the end, you will write an investment recommendation on the deal.
In this case study, you will learn all about private company valuation and financial modeling via Kakao’s reverse merger with Daum Communications (two Internet/mobile companies in South Korea). You'll learn how to make adjustments for private companies, how to model an initial public offering (IPO), and how to advise the company on a reverse merger vs. traditional M&A deal vs. IPO.
Module 15: Debt, Equity & Convertibles (Netflix)
In this case study, you'll advise Netflix on the best way to secure the $1.5 billion it needs to fund its international expansion efforts. You'll build a 3-statement model for the company with multiple scenarios, analyze its credit stats and ratios and covenants, and analyze bond yields, duration, convexity, call and put options, make-whole calls, refinancing options, and more. You'll also value a possible convertible bond, analyze its payoff profile and dilution, create a follow-on equity proceeds analysis, and draft a credit memo and longer advisory presentation for the company.
Our Customers Love Breaking Into Wall Street
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.
Take a look at what some of them have to say (these are actual unedited email screenshots… a few details have been blacked out to protect customers' privacy.)
“Great news, I just got a full-time offer in IB J.P. Morgan in London!! Your courses have been absolutely key in achieving this.”
“I used your course to build up my financial skills and then wrote my own research and finanical model on Ryanair. I sent this off to a VC, who hired me soon after. I was then transferred to a hedge fund, where I find myself working now - applying the skills you have taught me.”
“I purchased the Financial Modeling and Bank Modeling coursework, and was blown away at the depth of the material. In particular, the accounting material helped me the most. Especially since it was all brought into the context of M&A, as opposed to an Accounting 101 class.”
“I moved from being a tax accountant/lawyer with a Big4 accounting firm to now working in the investments team of a PE fund. This would not have been possible without the core grounding I got from your practical courses in financial modeling.”
“I worked in this role for a little over a year and I was recently offered a position at a PE firm in NYC. I had modeling tests and case studies that I passed with ease because [of] everything that I had done in my down time with BIWS, especially the merger/LBO tutorials.”
“I managed to get a Leveraged Finance internship offer at BNP Paribas thanks to your Excel & Fundamentals course.”
“Three months later, I'm an extremely happy chappy!”
“Your method of training and how focused you are on the necessary techniques to be productive in the office is what makes these courses genuine and unique, and is precisely what I need.”
“I just landed a job in a private equity fund, and I could not have done it without this course.”
“To make up for my lack of financial work experience I listed Modeling Fundamentals on my resume as I was doing it, with a few highlights of case studies completed. So far it has piqued [the] interest of Lazard in Paris, HSBC in London, among others.”
It’s All Here: Lessons, Exercises, Q&A, Tracking, and More
Here's a sample video from the Excel & Financial Modeling Fundamentals course so you can see for yourself exactly what you'll get:
And here's another sample video from the introductory M&A and merger model lessons:
And Here’s the Full Run-Down of Everything You Get in the Excel & Financial Modeling Fundamentals Course:
Here's what you get in the 351 videos (plus full transcripts, written notes, Excel files, and more):
Financial Modeling Lessons cover Accounting 101 up through 3-Statement Models, Valuation, DCF Analysis, Merger Models, and LBO Models.
Excel Lessons include Excel setup, navigation, formatting, formulas, lookups, pivot tables and data analysis, graphs/charts, and VBA and macros.
Time-Saving Excel Shortcuts. Includes shortcuts and quick references for any modern version of Excel.
Accounting Fundamentals Lessons teach you how to how to answer interview questions, build a 3-statement model, and calculate key financial metrics and ratios.
Equity Value, Enterprise Value & Multiple Lessons cover how to calculate diluted shares, move from Equity Value to Enterprise Value, and calculate the most relevant valuation metrics and multiples.
Valuation Lessons teach you how to pick comparable public companies and precedent transactions and how to build a DCF analysis (projections, terminal value, discount rates, and WACC).
Merger Model Lessons cover accretion / dilution, synergies, pro-forma balance sheet adjustments, and sensitivity tables.
LBO Model Lessons teach you both a basic model and a more advanced model with all 3 statements, pro-forma balance sheet, and debt schedules with 6 tranches of debt (Revolver to Mezzanine).
Instant Access when you sign up because everything is delivered online - no shipping charges or trips to the post office.
To get all the details, take a look at the course outlines below.
Please refer to the Excellence with Excel and Financial Modeling Fundamentals sections for what's included in this course.
add to cart Just 1 Payment of $347 100% Unconditional Money-Back Guarantee
Plus Expert Support From Current And Former Investment Bankers
Just moments after you enroll, you’ll receive Instant Access to the entire course.
Everything is digital, so you do not have to wait for physical products to arrive in the mail, and there are no shipping charges.
You can download the videos or other resources to your preferred device, so you can learn whenever and wherever you like.
But that’s not the best part.
The best part is expert support, for a full 24 months after purchase!
If there’s anything at all you don't understand, just go to the "Question/Comment" area below each and every lesson, and ask your question there.
These comments are monitored and responded to by our expert support team – every one of whom has personal experience working on deals at investment banks, private equity firms, and other finance firms.
That ensures that you’ll get responses from people with deep experience in the field – not a clueless high school temp clutching the "Help Desk" manual.
This personalized, expert support is one of the things that sets Breaking Into Wall Street apart and gets you to your goals more quickly.
You can often learn just as much from reading other customers' questions and our responses, as you will from the lessons themselves!
Our 1-on-1 coaching rate is $200+ per hour. But when you invest in the BIWS Excel & Financial Modeling Fundamentals Course, personal support is included for FREE.
NOTE: There are some limitations to these support services. For example, we cannot complete models, case studies, or homework assignments for you.
We also cannot provide play-by-play support with an earpiece during interviews.
We’re happy to answer career-related, qualitative, and technical questions that are related to the course materials.
add to cart Just 1 Payment of $347 100% Unconditional Money-Back Guarantee
One of the most important - and valuable - investments you'll ever make in your Investment Banking career...
If you went to a seminar to learn everything in the Excel & Financial Modeling Fundamentals course, it would cost you upwards of $10,000... plus your time and travel expenses.
But I always like to offer more value at a lower price than alternatives.
That's why I've priced the entire course at just one payment of $347.
At this "no-brainer" price, this will be one of the best investments you ever make in your career.
And when the strategies and techniques you learn in the Excel & Financial Modeling Fundamentals course help you land an internship or a six-figure full-time job at an investment bank, you'll recoup the investment within your first day in the office.
Our 90-Day, No-Questions-Asked, Money-Back Guarantee Means You Take No Risk
Take 90 days to evaluate everything inside the program, and if you're not 100% satisfied, simply contact us via the 'Contact' link displayed on every page of our website and ask for your money back. We'll refund your investment, no questions asked.
There is absolutely no risk to you at all, and there never will be.
Here’s What Will Happen Within Minutes Of You Signing Up
Once you sign up, you’ll immediately have access to the 351 instructional videos, the written quick reference guides, the complete transcripts, all the Excel files, the bonus case studies, and the complete curriculum. And you’ll have access to our expert support team to ask whatever questions you need, for a full 24 months after purchase.
And let’s make it even easier for you to try the Excel & Financial Modeling Fundamentals course today...
You Also Get 7 Bonus Case Studies Based On Real Valuations, Stock Pitches, and M&A and LBO Deals.A $400 Value - Yours Completely Free.
Many students and professionals find that they learn most quickly with real life practice case studies. So we've made it even easier for you to practice to your heart's content with these 8 bonus case studies.
These case studies represent close to an additional 10 hours of video in total - equivalent to another entire course.
Each case study comes with full transcripts, Excel files, slides/Word documents and comprehensive model answers.
What better way to prepare for roles in investment banking, hedge funds, private equity, equity research, asset management, and corporate finance than to get practice modeling real companies, real deals, and real scenarios?
Here Are the 7 Bonus Case Studies You’ll Find Inside:
A Simple Choice...
You can hope that an investment bank hires you without Excel and financial modeling skills... good luck to you there...
Or you can confidently tell banks you've invested in dozens of hours of financial modeling and Excel training based on 10+ global case studies authored by investment bankers who have worked on dozens of deals.
add to cart Just 1 Payment of $347 100% Unconditional Money-Back Guarantee
Upgrade To BIWS Platinum and Save $982 Over Individual Courses
With BIWS Platinum, You Get All Our Financial Modeling, Career, and Interview Prep Courses in One Discounted Package.
BIWS Premium Financial Modeling (Value $497)
Investment Banking Interview Guide (Value $197)
Oil and Gas Modeling (Value $497)
Investment Banking Networking Toolkit (Value $97)
Bank and FIG Modeling (Value $497)
PowerPoint Pro (Value $197)
Real Estate and REIT Modeling (Value $497)
Each Course includes professional support, free lifetime upgrades, and the only 90-Day Money-Back Guarantee in the industry.
Free Lifetime Upgrades
90-Day Money-Back Guarantee
Purchased separately, you would pay $2,479 for this package. But you can save $982 today by investing in BIWS Platinum for just $1,497 - and never pay another cent for your financial modeling and IB career training, ever!