This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Investment Banking Learning Path
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)
Excel Proficiency For Investment Banking
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)
Advanced Excel For Analysts
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 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
Introduction to Venture Capital (6:10)
Feature of Venture Capital (8:44)
Stages of Venture Capital (11:54)
Advantages Of Venture Capital (9:12)
Naming of Cell
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock