Investment Banking - An Overview
-
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)
Basic Excel Training
-
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)
Microsoft Excel - Advanced
-
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)
Accounting - The Foundation
-
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)
Accounting: 01 - Income Statement
-
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)
Accounting: 02 - Balance Sheet
-
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)
Accounting: 03 - Cash Flows Analysis
-
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)
Accounting: 04 - Financial Analysis Techniq
-
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)
Accounting: 05 - Income Taxes
-
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)
Banking Operations
-
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)
Financial Modeling Tesla
-
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)
Merger & Acquisition
-
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)
Leveraged Buyout (LBO)
-
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)
Private Equity
-
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)
Fixed Income
-
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)
Venture Capital
