Investment Banking Prep Course (Exams Included)

What’s included in this course package?

This course contains one investment banking course (covering five core subjects); and two Microsoft Office Specialist courses in Excel and PowerPoint 2016. The course material and exams are valid for 12 months from the time of enrolment. As part of this package, you will get access to a GMetrix practice test for each Microsoft certification course. This will help prepare you to pass the final exams.

Courses included:

Welcome to Investment Banking

• Leveraged Finance

Leveraged Finance and LBO Analysis Introduction

• Key LBO Participants
• Candidates for an LBO and Core LBO Economics
• Monetization Strategies and Structure of LBO Financing
• Financial Sources and Determining Financing Structure
• Session Assessment

LBO Analysis

• Building the Pre-LBO Model
• Modeling the LBO Transaction Structure
• Completing the Post-LBO Model
• Analyzing LBO Structure and Financial Returns
• Determining Valuation and Creating Transaction Summary
• Session Assessment

Test Bank

• Quiz Builder

Comparable Companies Analysis

• Welcome
• Investment Banking Valuation Introduction
• Overview of Comparable Companies Analysis
• Selecting Comparable Companies and Locating Financial Information (Steps I and II)
• Spreading Key Statistics, Ratios, and Trading Multiples (Step III)
• Spreading Key Statistics- Summary Calculations (Step III)
• Spreading Key Statistics- Support Calculations (Step III)
• Benchmarking and Determining Value (Steps IV and V)
• Simplified Comparable Companies Analysis – Problem/Example
• Session Assessment

Precedent Transactions Analysis

• Overview of Precedent Transactions Analysis
• Selecting a Universe of Comparable Acquisitions and Locating the Necessary Information (Steps I and II)
• Spreading Key Statistics and Ratios (Step III)
• Transaction Multiples, Benchmarking the Comparable Acquisitions, and Determining Value (Steps III, IV, and V)
• Session Assessment

Discounted Cash Flow Analysis

• Overview of Discounted Cash Flow Analysis and Studying the Target to Determine Key Performance Drivers
• Projecting Free Cash Flow (Step II) Part 1
• Projecting Free Cash Flow (Step II) Part 2
• Calculation of Weighted Average Cost of Capital (Step III)
• Determining Terminal Value (Step IV)
• Calculate the Present Value and Determine Valuation (Step V) Part I
• Calculate the Present Value and Determine Valuation (Step V) Part 2
• Illustrative Discounted Cash Flow Analysis
• Session Assessment

Test Bank

• Quiz Builder

Welcome

Foundational Accounting Concepts and Qualitative Considerations of Accounting

• Investment Banking Accounting Introduction
• Explore the Relationship between Accounting in Investment Banking
• Identify Insightful Accounting Information
• Understand Management Incentives Affecting Financial Statements
• Elaborate on the Audit Process Benefits and Pitfalls
• Session Assessment

Technical Accounting, the Financial Statements, and Financial Analysis

• The Three Primary Financial Statements
• Interpret the Profit Performance of a Company
• Explain the Importance of Information on the Financial Condition of a Company
• Explain the Statement of Cash Flows
• Examine Financial Analysis and Compare Various Financial Ratios
• Session Assessment

Test Bank

• Quiz Builder

Welcome

Sell-Side M&A

• Investment Banking M&A Introduction
• Overview of Sell-Side M&A
• Auctions
• Auction Process—Organization and Preparation
• Auction Process—First Round
• Auction Process—Second Round
• Auction Process—Negotiations
• Auction Process—Closing
• Negotiated Sale
• Sell-Side M&A Session Assessment

Buy-Side M&A

• Overview of Buy-Side M&A
• Buyer MotivationAcquisition Strategies
• Form of Financing
• Deal Structure
• Buy-Side Valuation
• Merger Consequences Analysis
• Buy-Side M&A Session Assessment

Test Bank

• Quiz Builder

Welcome

• Welcome

Introduction and Preparation

• Investment Banking Financial Modeling Introduction Video
• Introduction to Financial Modeling
• Building a ToolKit: Financial, Date/Timing, and Logical Functions
• Building a ToolKit: Lookup Functions
• Building a ToolKit: Statistical/Math Functions
• Building a ToolKit: Naming and Lists
• Setting Up a Model: Scenarios, Assumptions & Approach
• Session Assessment

Core Concepts in Financial Modeling

• Capex and Depreciation: The Basics of Asset Value Going Up and Down
• Capex and Depreciation: When Assets Are Disposed of and Advanced Depreciation
• Loan Amortization: Fixed Rate
• Loan Amortization: Floating Rate
• Loan Amortization: Credit Facilities & How Debt Integrates into the Models
• Paying Liabilities: Avoid Too Much, Track When Too LittleEquity: Deal Equity, Corporate Equity, and Capitalization Tables
• Working Capital Deep Dive
• Advanced Structures: Reserve Accounts
• Advanced Structures: Swaps and Triggers
• Advanced Structures: Net Operating Loss
• Session Assessment

How it’s All Connected

• Tying It All Together: How Each Section in the Project Finance Model Connects to Produce Results
• Tying It All Together: How Each Section in the Structured Finance Model Connects to Produce Results
• Tying It All Together: How Each Section in the Corporate Model Connects to Produce Results
• Model Integrity: Make Sure Everything is Correct
• Output Reporting: Make Sure Everything is Explainable
• Session Assessment

Advanced Modeling Concept

• VBA for Financiers: Enough to be Dangerous
• VBA for Financiers: Enough to be Slightly More Dangerous
• Simulation for Financiers: Basic Monte Carlo
• Modeling Appendix
• Session Assessment

Test Bank

• Quiz Builder

Excel 2016 Beginner

• Tabs And Ribbons Part 1
• Tabs And Ribbons Part 2
• Cells Part 1
• Cells Part 2
• Cells Part 3
• Cells Part 4
• Calculations Part 1
• Calculations Part 2
• Calculations Part 3
• Printing Part 1
• Printing Part 2

Excel 2016 Intermediate

• Menus And Keyboard Shortcuts Part 1
• Menus And Keyboard Shortcuts Part 2
• Menus And Keyboard Shortcuts Part 3
• Tabs Part 1
• Tabs Part 2
• Formulas And Calculations Part 1
• Formulas And Calculations Part 2
• Formulas And Calculations Part 3
• Formulas And Calculations Part 4
• Importing Data Part 1
• Importing Data Part 2
• Invoices

Excel 2016 Advanced

• Advanced Invoice Part 1
• Advanced Invoice Part 2
• Advanced Invoice Part 3
• Advanced Invoice Part 4
• Number Crunching
• Creating A Pivot Table From Scratch
• Smaller Excel Components Part 1
• Smaller Excel Components Part 2
• Smaller Excel Components Part 3 Microsoft Office Specialist (MOS) PowerPoint 2016 (1 EXAM)

PowerPoint Beginner

• What Is PowerPoint Part 1
• What Is PowerPoint Part 2
• New Presentation
• Viewing Presentation
• Inserting Transitions
• More Visual Designs Part 1
• More Visual Designs Part 2
• More Visual Designs Part 3
• More Visual Designs Part 4
• Notes

PowerPoint Intermediate

• Visual Designs With Logos And Animation Part 1
• Visual Designs With Logos And Animation Part 2
• Visual Designs With Logos And Animation Part 3
• Visual Designs With Logos And Animation Part 4
• Visual Designs With Logos And Animation Part 5
• Exit Animation Part 1
• Exit Animation Part 2
• Exit Animation Part 3
• Navigation Buttons
• Layout Options Part 1
• Layout Options Part 2

PowerPoint Advanced

• Master Pages Part 1
• Master Pages Part 2
• Software Simulation Part 1
• Software Simulation Part 2
• Setting Pictures To Music
• Advanced Animation Techniques
• Triggers
• Motion Path Animation
• Video In PowerPoint
• PowerPoint Review Part 1
• PowerPoint Review Part 2
• Additional Options

Certification exams included:

• Microsoft Office Specialist (MOS) 77-727: Excel 2016
• Microsoft Office Specialist (MOS) 77-729: PowerPoint 2016

GMetrix practice tests included:

• Microsoft Office Specialist (MOS) 77-727: Excel 2016
• Microsoft Office Specialist (MOS) 77-729: PowerPoint 2016