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

9,794.00

Now You Can Master Excel, Financial Modeling, and PowerPoint to Break Into Investment Banking and Fast-Track Your Way to Promotions and Top BonusesWhat You Get – And What the BIWS Premium 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 good are your Excel skills?How much do you know about accounting?Can you walk me through a valuation or DCF?What happens in a merger model or LBO model when you adjust the assumptions…How would you describe your financial modeling skills?Can you show us a sample presentation you’ve created? How are your PowerPoint skills?Module 1: Modeling Overview and Core ConceptsIn 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 StatementsIn 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 AnalysisThis 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 ModelIn 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.And Then You’ll Finish Your Training by Becoming a PowerPoint Pro, Including Shortcuts, Macros, and Templates to Triple Your Efficiency…Setup, Shapes, and Slides Lessons explain how to set up the Quick Access Toolbar (QAT) for improved shortcuts and how to align, distribute, and format shapes and text, including the use of tools such as the ruler and drawing guides. This module is your “crash course overview” for the most useful bits of PowerPoint.Text and Tables Lessons show you how to use line spacing, tab stops, and bullet points on slides and how to use tables to enhance text, shapes, and images and create unique layouts and process diagrams.Slide Master Lessons teach you how to use the Slide Master to create “Layouts” (templates) for different types of slides and how to use it to set up headers, footers, slide numbers, formatting guides, and company logos. You’ll also learn about Sections and the Slide Sorter view.Excel, Image, and Word Integration Lessons explain how to insert Excel models, charts/graphs, images, Word data, and custom objects such as maps into PowerPoint; you’ll also learn how to create charts natively in PowerPoint and how to set up the infamous “football field” valuation graph using tables and Excel data.Shortcut and Macro Practice Exercises give you practice creating the remaining slides in the Jazz Pharmaceuticals presentation using a combination of built-in PowerPoint commands/shortcuts and the macro package in this course. You’ll also learn about more advanced features and slide types, such as SmartArt and “Timeline” slides.The Bank Pitch Book Database and Editable Slide Templates give you a collection of 175+ real bank presentations hosted on the sec.gov website across different industries and deal types. You’ll learn how to find useful slides in these presentations, and you’ll get a set of 50+ editable slide templates based on the best examples.Outside Tools, Add-Ins, VBA, And Macros (Full VBA Course) – This is a full crash course on VBA in PowerPoint, where you’ll build many of the macros included in the course macro package. You’ll start with the basics, such as a macro to swap two shapes’ positions, and you’ll build up to more complex ones involving drawing guides, tables, and objects such as Harvey Balls and Calendars.