$62.00
Now You Can Master Excel, Financial Modeling, and PowerPoint to Break Into Investment Banking…
File Size: 34.7 GB
302 videos (with subtitles), detailed guides, Excel/PPT files, and more
No other training provides the same conceptual and practical expertise
Detailed study plans give you different pathways to course completion
You can read endlessly about how to prepare for investment banking interviews, internships, and full-time jobs, but it’s always a mix of “soft skills” (communication ability, writing emails, etc.) and “hard skills.”
The BIWS Premium package gives you a leg up over everyone else with detailed training for the three most important “hard skills” in investment banking and private equity:
Technical knowledge is required to win finance internships and full-time jobs today. You need to understand the concepts at a deep level so that you’re prepared for any question that comes up – especially at firms such as “elite boutiques” that love to ask outside-the-box questions.
And you also need the accounting, valuation, and financial modeling skills on the job since you’ll be spending a good chunk of your time valuing clients, potential clients, and potential investments.
The Financial Modeling lessons in this package walk you through 10+ case studies, ranging from simple, 30-minute exercises up to 3-hour models, and they explain everything step-by-step with video tutorials, notes, written guides, and more.
All financial modeling work is done in Excel, so you need to be quick with the key shortcuts, formulas, and formatting – or you’ll be stuck at the office at 4 AM wondering how to fix the color coding in your model or set it up for printing.
Our Excel training walks you through everything from the basic navigation shortcuts up to VBA and macros to automate your workflow – and you’ll get our custom Quick Access Toolbar (QAT) and macro package to make you even more efficient.
Along the way, you’ll get plenty of practice exercises to ensure that everything “sticks.”
In most investment banking roles, you spend a lot of time drafting presentations for clients and potential clients… which makes PowerPoint just as important as Excel.
But people tend to assume it’s “easy” to use – which couldn’t be further from the truth. Using the program efficiently for business purposes is completely different from inserting cat animations or drawing pictures.
You’ll boost your productivity by 10x if you master the key shortcuts to align and format slides and you have plenty of example presentations and pitch books to work from – so you get both of these in spades in this training.
Oh, and you’ll also get our full macro package, which automates 25+ common tasks in IB presentations, and you’ll even put it into practice with a dozen exercises where you use thee macros to fix slides.
Our BIWS Premium package is designed around these three critical topics.
Yes, there’s a ton of other stuff in the package, including investment recommendation templates, sample pitch books, practice quizzes, and the end-of-course certification quizzes…
But if you master the core Excel, PowerPoint, and financial modeling skills, the rest is icing on the cake.
When you’re interviewing for internships and full-time positions at investment banks, you’ll always get a few questions over and over…
Master practical financial modeling skills based on well-known global companies and deals, not abstract theory.
When you master real-world techniques and you have ADVANCED knowledge, you automatically improve your chances of landing prime jobs and internships with the top investment banks, private equity firms, and hedge funds.
To succeed in the super-competitive world of investment banking, the hardest part is often “getting your foot in the door”.
BIWS Premium lets you gain advanced-level knowledge via video-based training and case studies based on client advisory presentations, stock pitches, investment recommendations, and more.
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).
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.
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
Get Digital Download ” Break Into Wall Street – BIWS Premium (Excel & VBA + Financial Modeling Mastery + PowerPoint Pro) ” Right Now!
Reviews
There are no reviews yet.