Master Excel, financial modeling, and PowerPoint…
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.
There are no reviews yet.
You must be <a href="https://wislibrary.org/my-account/">logged in</a> to post a review.