Course Overview
This Investment Banking Course is an awesome bundle of 16 Investment Banking Courses with 100+ hours of video tutorials and This
Core Coverage
This course includes various aspects of IB such as Investment Banking - An Overview | Basic Excel Training | Microsoft Excel - Advanced | Accounting - The Foundation | Accounting: 01 - Income Statement | Accounting: 02 - Balance Sheet | Accounting: 03 - Cash Flows Analysis | Accounting: 04 - Financial Analysis Techniq | Accounting: 05 - Income Taxes | Banking Operations | Financial Modeling Tesla | Merger & Acquisition | Leveraged Buyout (LBO) | Private Equity | Fixed Income | Venture Capital
Eligibility
Anyone serious about learning Investment Banking Course and wants to make a career in this Field | Anytime, Anywhere Access: Learn at your own pace, wherever you are | Verifiable Certificates: Earn certificates for course completion
Investment Banking Course Curriculum
- Investment Banking - Introduction new (3:34)
- Investment Banks VS Retail & Commercial Banks new (11:31)
- Investment Banking & Research new (11:34)
- Amc, Buy Side And Sell Side Of An Investment Bank new (6:10)
- Sales & Trading And Equity Research new (5:21)
- Raising Capital & Ipo new (12:06)
- Underwriting And Market Maker new (7:07)
- M&A Advisory And Pitch-Book new (7:31)
- Reorganizations And Restructuring new (3:50)
- Structure Of An Investment Bank new (8:15)
- Investment Banking - Conclusions new (5:31)
- accessing MS Excel new (2:41)
- MS Excel Startup Screen (2:27)
- Understanding the Ribbon (3:03)
- Cells in Excel (1:18)
- Worksheet Essentials (3:10)
- Saving the File (1:14)
- Formatting Cells (14:23)
- Custom Cell Styles (6:12)
- Custom Number Formatting in Excel (11:39)
- More on Custom Number Formatting (10:59)
- Custom Formats of Data (13:33)
- The BEDMAS Order of Mathematical Operations (9:04)
- Mathematical Operations without Functions new1 (9:43)
- Mathematical Operations without Functions Continued (11:38)
- IF Function (10:32)
- More on IF Function (8:25)
- Importing Data and Calculations (10:46)
- Working with the Count Function (12:40)
- Conditional Counts - CountIF Function (4:58)
- Working with the Sum Function (14:02)
- Finding the Average (11:17)
- Conditional Average - Average IFS Function (8:31)
- Finding the Maximum Value Using the MAX Function (8:36)
- Finding the Minimum Value Using the MINFS Function (8:04)
- Determining Proportions and Updating a Calculation (10:06)
- Conditional Formatting new1 (18:24)
- More on Conditional Formatting (7:47)
- Working with Tables (13:03)
- Formatting Table (13:31)
- Filtering and Sorting of Data (9:40)
- Freeze and Split (11:18)
- Printing and Layouts in Excel (9:51)
- Pivot Tables (7:50)
- Creating Custom Tables (8:58)
- Organizing Pivot Tables (8:35)
- Column Chart (10:32)
- Bar Chart (8:03)
- Line Chart (14:24)
- Pie Chart (10:27)
- Map Chart (6:46)
- Common Errors in Excel (11:12)
- More on Common Errors (13:42)
- Logical Function - IF new (8:21)
- AND OR and XOR Functions (8:48)
- IFS Function - Example 1 (6:25)
- IFS Function - Example 2 (9:02)
- SWITCH Function (10:17)
- Other Logical Functions (8:20)
- Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
- Date Functions - TODAY DAY (9:36)
- MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
- EDATE and EOMONTH Functions (8:38)
- YEARFRAC Function (7:19)
- Joining Data using CONCAT and TEXTJOIN (9:59)
- LEN FIND LEFT RIGHT TRIM (10:26)
- Using UNIQUE and TRANSPOSE (11:27)
- TEXT Function (10:00)
- CHOOSE Function (10:46)
- More on CHOOSE Function (6:34)
- VLookUp Function (12:47)
- HLOOKUP Function (5:12)
- Index Function (10:31)
- Match Function (9:24)
- XLOOKUP and XMATCH Functions (8:43)
- Using the OFFSET Function (8:49)
- OFFSET Function - Total and Average Score (9:29)
- OFFSET Function - Highest and Lowest Score (8:57)
- OFFSET Function - Year to Month Sales (11:01)
- OFFSET Function - Quarterly and Half-Month Sales (6:39)
- Naming of Cell (12:30)
- Naming a Range (10:01)
- Text to Columns (6:35)
- Grouping Tabs and Subtotal Function (12:47)
- Working with Hyperlinks (11:17)
- Data Validation (11:00)
- Data Validation Continued (11:14)
- Custom Data Validation (12:17)
- Generating Random Numbers (6:10)
- Custom Views (10:34)
- Protecting Worksheet and Workbook (17:36)
- PivotTable - Advanced Features (10:02)
- More on Advanced Features (6:50)
- Slicers and Timelines (6:43)
- Solver (11:37)
- Data Tables (10:42)
- More on Data Tables (9:53)
- Goal Seek (8:43)
- Combo Charts (13:51)
- More on Combo Charts (12:11)
- Sparklines (8:10)
- Waterfall Chart (9:37)
- Box Chart (12:48)
- Whisker Chart (11:29)
- TreeMap and Sun Burst Charts (11:53)
- Radar Chart (7:55)
- Scroll Bar (10:00)
- Spin Button and Radio Button (10:52)
- Form Control Application (10:01)
- Form Control Application Continued (5:32)
- Data Entry Form (3:44)
- An Introduction To Financial Accounting (0:48)
- Purpose Of Financial Statements (3:16)
- Explaining A Business Cycle (2:16)
- Accounting For Income Statement (9:31)
- Accounting For Balance Sheet 1 (7:47)
- Accounting For Balance Sheet 2 (9:53)
- Accounting For Balance Sheet 3 (6:24)
- Accounting For Cash Flows (5:20)
- Conclusion (0:28)
- Financial Statements - Fiscal Year Vs Calendar Year new (6:34)
- Income Statement Format new (8:23)
- Calculating Profit Margins (2:33)
- Non Recurring Items new (9:10)
- Changes In Accounting Estimates new (3:00)
- Final Remarks new (3:09)
- Revenue Recognition Percentage Completion and Completed Contract new (11:30)
- Revenue Recognition Installment Method and Cost Recovery new (6:22)
- Depreciation Expense x (10:40)
- Downloading Colgates Income Statement new (12:21)
- Analyst Format Of Colgate-S Income Statement (3:17)
- Formatting The Income Statement (2:39)
- Investigating The Non-Recurring Charges (4:58)
- Seperating non-recurring Items (7:07)
- Comparision Of Margins - Before And After Adjustments (3:34)
- Introduction to Balance Sheet New (3:35)
- Introduction to Current Assets (1:56)
- Cash And Cash Equivalents (3:30)
- Cash And Cash Equivalents - Colgate, PandG, Microsoft (6:05)
- Accounts Receivables (1:50)
- Accounts Receivables Case Study (10:36)
- Inventory (3:02)
- Inventory - Case Study (2:08)
- Inventory - Lcm (5:52)
- Inventory - Colgate (2:27)
- Inventory Valuations (8:33)
- Inventory Valuation - Recap (2:59)
- Prepaid Expenses (2:23)
- Other Current Assets - Colgate (1:39)
- Financial Reporting Standards (7:42)
- Current Liabilities (2:18)
- Current Liabilities - Colgate (4:51)
- Long Term Assets (7:50)
- Introduction to Goodwill (6:37)
- Pooling Method Of Accounting (1:51)
- Purchase Method Of Accounting (9:09)
- Goodwill Impairment (3:56)
- Long Term Investments Part 1 (3:03)
- Long Term Investments part 2 (7:31)
- Long Term Investments - Example (2:53)
- Long Term Liabilities (5:52)
- Long Term Liabilities - Risk Profile (3:28)
- Introduction to Shareholder-s Equity (6:39)
- Common Stock - Par Value And Apic (4:31)
- Treasury Stock or Shares (4:48)
- Retained Earnings and Dividends (4:30)
- Additional Other Comprehensive Income (6:30)
- Introduction to Preference Shares (3:56)
- Macdonald-S Shareholder-S Equity (3:08)
- Dividends - Types (2:34)
- Cash And Property Dividend - Example (5:32)
- Stock Dividends (3:37)
- Small and Large Stock Dividends - Example (5:42)
- Stock Split (3:06)
- Introduction To Cash Flows (7:19)
- Cfo - Direct Method (6:05)
- Cfo - Direct Method - Continued (9:33)
- Cfo - Direct Method - Example (7:46)
- Cfo - Indirect Method (5:37)
- Cfo - Indirect Method - Example (5:22)
- Cfi (8:09)
- Cff (0:59)
- Comprehensive Example - Cfo - Direct Method - 1 (8:09)
- Comprehensive Example - Cfo - Direct Method - 2 (3:48)
- Comprehensive Example - Cfo - Indirect Method (5:59)
- Comprehensive Example - Cfi (4:12)
- Comprehensive Example - Cff (3:05)
- Comprehensive Example - Ending Cash Balance (2:09)
- Horizontal and Vertical Analysis (7:05)
- Income Statement - Horizontal and Vertical Analysis - Example (8:01)
- Balance Sheet Vertical Analysis - Example (6:37)
- Introduction to Ratio Analysis (2:24)
- Activity Ratios (6:24)
- Activity Ratios - Receivables Turnover (4:37)
- Activity Ratios - Inventory and Payables Turnover (6:45)
- Activity Ratios - Cash Conversion Cycle Discussion (4:53)
- Activity Ratios - Working Capital and Fixed Asset Turnover (6:09)
- Liquidity Ratios (8:31)
- Solvency Ratios (5:48)
- Profitability Ratios (8:37)
- Comprehensive Example - Activity Ratio - Cash Conversion - Part 1 (10:24)
- Comprehensive Example - Activity Ratio - Cash Conversion - Part 2 (4:53)
- Comprehensive Example - Activity Ratio - Working Capital and Fixed Asset Turnover (4:53)
- Comprehensive Example - Liquidity Ratios (5:48)
- Comprehensive Example - Solvency Ratios (8:50)
- Comprehensive Example - Profitability Ratios (8:17)
- ROE (9:08)
- ROE Example (9:12)
- Dividends Payout Ratio (3:42)
- Introduction to Income Taxes - Part 1 (10:53)
- Introduction to Income Taxes - Part 2 (6:29)
- Sources of Deferred Taxes (1:22)
- Deferred Tax Liabilities - Example - Part 1 (10:28)
- Deferred Tax Liabilities - Example - Part 2 (6:11)
- Deferred Tax Liabilities - Example - Part 3 (6:11)
- Deferred Tax Assets - Example (7:08)
- Temporary and Permanent Difference (5:48)
- Valuation Allowance - Deferred Tax Assets (5:53)
- Tax Base - Deferred Taxes (4:27)
- Effect of Changes in Tax Rates on Deferred Taxes (4:31)
- Basic functions of Banking (6:01)
- Banking channels (11:45)
- Organization chart of a bank (8:42)
- Account opening process (8:45)
- Opening of different types of accounts (9:49)
- Need of KYC and AML (11:10)
- Dormant accounts (6:17)
- Nomination (8:29)
- Non resident deposits (5:53)
- Bank lending principlels (8:18)
- Further Principles of Banks (7:51)
- Continuation of principles of banks (5:24)
- Nonfund based limits and its assessment (9:05)
- Working capital and methods of assessment (4:24)
- Continuation of Working capital and methods of assessment (5:09)
- Securities, their charging and Retail loans (6:07)
- Continuation of Securities, their charging and Retail loans (9:33)
- Various forms of charging of securities (9:16)
- Mortgages (4:08)
- Assignment, Lien and Set off (8:07)
- Lending terms and documents (8:00)
- Continuation of Lending terms and documents (5:10)
- Documentation (7:47)
- Procedure for documentation (5:32)
- Continuation of Procedure for documentation (6:20)
- Post disbursement activities of bank (4:27)
- Continuation of Post disbursement activities of bank (5:12)
- Non Performing Assets New (4:00)
- Continuation of Non Performing Assets (4:29)
- Classification of assets (6:07)
- Management of NPAs (4:44)
- Continuation of Management of NPAs (4:07)
- SARFAESI ACT,2002 (7:00)
- Processing of payments and CTS sytem (5:52)
- Continuation of Processing of payments and CTS sytem (6:19)
- Products of payment services (4:26)
- Continuation of Products of payment services (5:13)
- Collection Services and Forex (8:21)
- Core Banking Solutions (5:46)
- Inernet frauds (4:42)
- Continuation of Inernet frauds (4:49)
- Money Mule, Nigerian Scam and safety measures (8:19)
- Tesla Unveiled (4:05)
- Analyzing Teslas Sales Performance (2:23)
- Sourcing Historical Data (6:01)
- Navigating Teslas Annual Report (3:38)
- Consolidated Financial Statements (5:22)
- Historical Revenue Growth Rate (3:02)
- Projecting Teslas Revenue (17:38)
- Color-Coding in Financial Models (2:53)
- Projecting Cost of Sales (18:07)
- Forecasting Operating Expenses (9:07)
- Working Capital Ratios (7:14)
- Working Capital Projections (12:21)
- Calculating Proportion of Assets (5:47)
- CAPEX Projections (3:31)
- CAPEX Distribution (2:21)
- Using TRANSPOSE Function (4:14)
- Calculating Machinery and Equipment Depreciation (8:38)
- Completing Ending Net PPE (9:04)
- Common Stock Calculations (5:16)
- Retained Earnings Calculations (4:48)
- Net Income Attributable to Non-Controlling Interests (7:58)
- Provision for Income Taxes (8:21)
- Cash Flow Statement (14:11)
- Balance Sheet Linkages (9:09)
- Completing cash Flow Linkages (11:59)
- Cash Available for Debt Repayment (3:03)
- Long-Term Debt Payments (6:48)
- Income Statement Linkages (11:52)
- FCFF Calculations (4:19)
- Understanding WACC (4:57)
- WACC Calculations (12:08)
- Terminal Value Explained (7:19)
- NPV Calculation Steps (13:14)
- Target Share Price Calculations (5:51)
- Sensitivity Analysis (7:13)
- Weighted Average Number of Shares (12:11)
- Basic & Diluted EPS (5:13)
- EBITDA Calculations (3:57)
- Tesla Ratio Analysis (16:26)
- Introduction to Merger & Acquisitions on Balance Sheet new1 (11:51)
- Merger & Acquisitions on Balance Sheet of Two Organisation new (10:42)
- Merger & Acquisitions on Balance Sheet of Two Organisation Continues new (10:32)
- Claculating Net Assest in Merger & Acquisitions new (10:01)
- More on Merger & Acquisitions on Balance Sheet new (10:50)
- Purchase Consideration new (11:37)
- More on Purchase Consideration new (8:23)
- Relisation Account new (8:21)
- Journal Entries in M and A new (10:19)
- Journal Entries in M and A Continues new (9:17)
- Discuss the Journal Entries (10:31)
- Assets and Liabilities (11:00)
- Reconstruct the Balance Sheet (5:06)
- Current Inventory (8:26)
- Security Premium (8:14)
- Introduction to LBO (9:38)
- Consolidated Balance Sheet (8:59)
- Consolidated Balance Sheet Continue (3:14)
- Assumptions (11:27)
- Assumptions Continue (9:00)
- Entry and Exit Price (3:26)
- Entry and Exit Price Continue (8:18)
- Sources Uses of Funds (6:26)
- Opening Balance Sheet (5:59)
- Forecast Financial Statements (8:19)
- Forecast Financial Statements Continues (12:41)
- Debt Amortization Schedule (9:16)
- Cash Available for TLB (12:18)
- Forecast Financial Statements and IRR (9:00)
- More on Forecast Financial Statements 5 and IRR (5:11)
- IRR Sensitivity (8:19)
- Introduction Private Equity Modelling (6:44)
- Illustration for Accounting Approach (2:59)
- Illustration for Accounting Approach Continues (11:52)
- Overview of Trade and Private Firm (7:30)
- Valuing of Private Firm (7:32)
- Illustration for Fundamental Approach in Private Firm (6:20)
- Illustration for Fundamental Approach in Private Firm Continues (5:05)
- Bottom Up Approach to Estimate the Levered Risk (7:05)
- Estimate Levered Risk for Info Soft (7:11)
- Adjusting for Non Diversification in Bottom Up Approach (4:17)
- Illustration for Non Diversification in Bottom Up Approach (7:35)
- Alternative Adjustment for Private Firm Risk (11:32)
- Cost of Equity to Cost of Capital (1:14)
- Debt Ratio in (9:53)
- Illustration to Esitmate Cost of Capital (9:06)
- Cash Flow in Equity Modeling (10:54)
- Illustration on Operating and Net Income (11:48)
- Illustration on Operating and Net Income Continues (6:44)
- Growth in Equity Modeling (12:12)
- Illustration on Estimating Growth (8:10)
- Key Person Effect on Value (11:14)
- Illiquidity Discount in Equity Modeling (10:55)
- Example of Illiquidity Discount (5:41)
- Valuation Motives and Value Estimates in Equity Modeling (8:08)
- Illustration on Valuation Motives (10:41)
- Illustration on Value Estimates (11:35)
- Illustration on Value Estimates Continues (7:18)
- Introduction to Fixed Income Market (9:25)
- Principal Repayment Structure (8:36)
- Coupon Repayment Structure (10:45)
- Global Fixed Income Market (8:26)
- Primary and Secondary Bond Market (8:11)
- Types of Issuer of Fixed Income Market Continues (10:33)
- Fixed Income Valuation (9:02)
- Example of Fixed Income Valuation (8:38)
- Example of Fixed Income Valuation Continues (4:23)
- Prices and Yields (7:36)
- Prices and Yields Continue (9:07)
- Certificate of Deposite (9:55)
- Floating Rate Note (10:35)
- Mony Market (12:56)
- Understanding Fixed Income Risk and Return (10:16)
- Souces of Rturn (7:46)
- Interest Rate Risk on Fixed Rate Bonds (9:41)
- Approximate Modified Duration (9:40)
- Computation of Fixed Income (7:52)
- Mony Duration (7:53)
- Approximate Convexity (10:45)
- Fundamentals of Credit Analysis (10:28)
- Fundamentals of Credit Analysis Continue (8:18)
- More on Fundamentals of Credit Analysis (8:31)
- Credit Analysis Model (7:14)
- Credit Analysis Model Continue (6:55)
- Moe on Credit Analysis Model (8:09)
- Backed Securities (9:32)
- Residentioal Mortagage Loans (8:56)
- Commercial Mortgage (7:06)
- Collateralized Debt Obligations (6:31)
- The Arbitration-Free Framework (9:34)
- Example of The Arbitration-Free Framework (6:59)
- Pricing Bonds using a Binomial Tree (11:09)
- Calibrating Binomial Tree (9:23)
- Bond with Embedded Options (11:18)
- Example of Embedded Options (7:16)
- Bond with Interest Rate Volatility (10:54)
- Valuation of a Floored Floater (6:01)
- The Term Structure and Interest Rate Dynamics (12:10)
- The Term Structure and Interest Rate Dynamics Continues (11:05)
- More on Term Structure and Interest Rate Dynamics (12:26)
- Framework for Fixed Income Portfolio Management (7:41)
- Managing Funds Against Bond Markets (9:04)
- Managing Funds Against Liabilities (6:45)
- More on Managing Funds Against Liabilities (9:24)
- Fixed Income Strategies (12:13)
- Fixed Income Strategies Continues (10:34)
- International Bond Investment (8:51)
- Selecting Fixed Income Manager (6:30)
- Relative-Value Methodologies for Global Portfolio Management (9:55)
- Relative-Value Methodologies for Global Portfolio Management Continues (7:27)