Course curriculum

    1. Download Supporting Files

    2. Introduction to Excel

    3. Excel Shortcuts

    4. Excel 101 General

    5. Excel 101 Borders

    6. Excel 101 Rows and Columns

    7. Excel 101 Alignment

    8. Basic Calculations

    9. Common Errors

    10. Anchoring Cells: Part 1

    11. Anchoring Cells: Part 2

    12. Naming Cells

    13. Custom Formatting

    14. Dynamic Text and Concatenate

    15. Tracking and Editing Data

    16. Conditional Formatting

    17. Sumproduct

    18. Rounding Functions

    19. Text Functions: Part 1

    20. Text Functions: Part 2

    21. Flash Fill

    22. Vlookup and Hlookup

    23. Freezing and Splitting Panes

    24. Find and Replace

    25. The If Function: Part 1

    26. The If Function: Part 2

    27. The If Function: Part 3

    28. Sumifs and Averageifs

    29. Data Validation

    30. Choose Function

    31. Counting Functions: Part 1

    32. Counting Functions: Part 2

    33. Date Functions

    34. Goalseek and Data Tables

    35. Future Value and Present Value

    36. Net Present Value (NPV) and XNPV

    37. Internal Rate of Return (IRR) and XIRR

    38. Inserting Charts

    39. Index and Match

    40. Xlookup: Part 1

    41. Xlookup: Part 2

    42. VBA and Macros

    43. The Ifs Function

    44. Text to Columns

    45. Filtering and Subtotal

    46. Sorting

    47. Pivot Tables: Part 1

    48. Pivot Tables: Part 2

    1. Download Supporting Files

    2. Introduction to Accounting

    3. The Importance of Accounting

    4. Accounting Principles

    5. The Income Statement

    6. The Accounting Equation

    7. The Balance Sheet

    8. The Cash Flow Statement

    9. Accrual Accounting

    10. Revenue Recognition and Matching Principles

    11. Historical Cost Principle

    12. Public Filings

    13. Case Study Introduction

    14. Case Study Income Statement

    15. How Does a Business Earn Revenue?

    16. What is Cost of Goods (COGS)?

    17. Revenue on Cash

    18. Revenue on Credit

    19. Cost of Goods Sold

    20. Fixed Costs Vs. Variable Costs

    21. Selling, General and Admin (SG&A) Expenses: Part 1

    22. Selling, General and Admin (SG&A) Expenses: Part 2

    23. What is Depreciation?

    24. What is Amortization?

    25. Depreciation and Amortization (D&A)

    26. Interest Expense

    27. Tax Expense

    28. Income Statement Exercise

    29. Case Study: Income Statement Revisited

    30. Importance of the Income Statement

    31. Case Study Balance Sheet

    32. Accounts Receivable

    33. Prepaid Expenses

    34. Inventory

    35. Property, Plant and Equipment (PP&E)

    36. Intangible Assets

    37. Visualizing PP&E and Intangible Assets

    38. Accounts Payable

    39. Accrued Expenses

    40. Equity Vs. Debt

    41. Types of Debt and How They Work

    42. Bank Loan

    43. Types of Equity and How They Work

    44. Common Equity

    45. What are Retained Earnings?

    46. Balance Sheet Exercise: Part 1

    47. Balance Sheet Exercise: Part 2

    48. Importance of the Balance Sheet

    49. Cash is King!

    50. Working Capital

    51. Cash Conversion Cycle (CCC)

    52. CCC Exercise

    53. Capital Expenditure (Capex)

    54. Financing

    55. Case Study: Cash Flow Statement

    56. Cash Flow Statement Exercise

    57. Importance of the Cash Flow Statement

    58. How the 3 Financial Statements are Linked Together

    59. Introduction to Ratio Analysis

    60. Liquidity Ratios

    61. Solvency Ratios

    62. Profitability Ratios

    63. Efficiency Ratios

    64. Coverage Ratios

    65. Capital Leases Vs. Operating Leases

    66. Capital Lease Exercise

    67. Operating Lease Exercise

    68. Bad Debt Expense Exercise

    69. Deferred Revenue Exercise

    70. Non-Operating Items

    71. Goodwill

    72. Goodwill Exercise

    73. Equity Discussion

    74. What are Common Shares

    75. Shares and Earnings Per Share (EPS)

    76. Treasury Shares

    77. EBITDA: A Non-GAAP Metric

    78. Drawbacks of EBITDA

    79. Inventory Accounting

    80. Last In First Out (LIFO)

    81. First in First Out (FIFO)

    82. Average Cost Method

    83. Accouting Regulations

    84. Differences between GAAP and IFRS

    1. Download Supporting Files

    2. Introduction to Corporate Finance

    3. A Corporation and the Corporate Mission

    4. Risk-Return Tradeoff

    5. RECAP: Common Shares

    6. Shareholders Vs Stakeholders

    7. Public Vs. Private Corporatons

    8. What is Corporate Finance?

    9. The Corporate Lifecycle: Type of Entity

    10. Types of Risk

    11. What are Capital Markets?

    12. Market Participants

    13. The Corporate Lifecycle: Source of Funding

    14. Angels, VCs and PEs

    15. Primary Vs Secondary Capital Markets

    16. Going Public: Initial Public Offering (IPO)

    17. The IPO Process

    18. Recent IPO: Nuvei

    19. Going Private: Leveraged Buyout (LBO)

    20. Popular LBO: Dell Computers

    21. What is Liquidity?

    22. Capital Gains Vs. Income

    23. Calculating Percentage Returns

    24. Different Uses of Capital

    25. Time Value of Money

    26. Future Value and Present Value

    27. Case Study Introduction

    28. Analyzing Capital Investments

    29. Net Present Value (NPV)

    30. Internal Rate of Return (IRR)

    31. Payback Period

    32. NPV, IRR and Payback Period Exercise

    33. Introduction to M&A

    34. Types of Buyers

    35. Types of M&A

    36. Purchase Consideration: Cash, Stock or Both?

    37. All-Cash Transaction: Microsoft acquires LinkedIn

    38. All-Stock Transaction: Salesforce acquires Tableau

    39. Mixed Transaction: Salesforce acquires Slack

    40. Why M&A?

    41. What is Goodwill?

    42. What are Synergies?

    43. Enterprise and Equity Value

    44. Book Value Vs. Market Value of Equity

    45. Cash Free Debt Free

    46. Valuation Methods

    47. Intrinsic Vs. Relative Valuations

    48. Intrinsic and Relative Valuations Exercise

    49. Price / Earnings Multiple

    50. Enterprise Value / EBITDA Multiple

    51. Enterprise Value / Revenue Multiple

    52. M&A Process Sell-Side View

    53. Auction Vs. Proprietary Process

    54. Friendly Vs. Hostile Takeovers

    55. Defense Tactics: Poison Pill

    56. Other Defense Tactics

    57. What is Due Diligence (DD)

    58. M&A Process Buy-Side View

    59. Platform Vs. Add-On acquisitions

    60. Mister Car Wash

    61. Sources of Capital

    62. Equity Vs Debt

    63. RECAP: Equity Discussion

    64. RECAP: Types of Equity and How They Work

    65. Common Equity

    66. Preferred Equity

    67. RECAP: Shares and Earnings Per Share (EPS)

    68. Diluted Shares Outstanding

    69. Dilutive Securities

    70. RECAP: Treasury Shares

    71. Treasury Stock Method

    72. Share Repurchases Canada Goose

    73. Stock Splits and Reverse Stock Splits

    74. RECAP: Types of Debt and How They Work

    75. Seniority of Debt

    76. Debt Covenants

    77. Credit Ratings

    78. Revolving Credit Facilities

    79. Term Loans

    80. Subordinated Debt

    81. Capital Structure: Part 1

    82. Capital Structure: Part 2

    83. Weighted Average Cost of Capital (WACC)

    84. Capital Structure: Debt and Equity value

    85. The Cost of Debt

    86. The Cost of Equity

    87. Optimal Capital Structure

    88. Understanding Beta

    89. WACC Excel Exercise

    1. Download Supporting Files

    2. Welcome!

    3. RECAP: How the 3 Financial Statements Are Linked

    4. Introduction to Financial Modeling

    5. Introducing the Case Study

    6. Completed Model Overview

    7. Historical Financial Statements

    8. Model Inputs

    9. Modeling Revenue

    10. Revenue Schedule: Cereals

    11. Revenue Schedule: Jams

    12. Revenue Schedule: Breads

    13. Sensitizing Revenue: Part 1

    14. Sensitizing Revenue: Part 2

    15. Modeling COGS

    16. COGS Schedule: Cereals

    17. COGS Schedule: Jams and Breads

    18. Sensitizing COGS

    19. Modeling SG&A

    20. Rent Expense

    21. Salaries and Wages

    22. Retailer Commission

    23. Administrative Costs

    24. Executive Compensation

    25. Marketing Costs

    26. Modeling Tangible Assets

    27. Tangible Capex Spend

    28. Modeling Intangible Assets

    29. Intangible Capex Spend

    30. Depreciation Expense

    31. Amortization Expense

    32. Modeling Taxes

    33. Tax Expense

    34. Modeling Retained Earnings

    35. Retained Earnings Schedule

    36. RECAP: Working Capital

    37. Modeling Working Capital

    38. Working Capital Schedule

    39. Modeling Debt

    40. Debt Schedule

    41. Preliminary Income Statement

    42. Preliminary Balance Sheet

    43. Preliminary Cash Flow Statement

    44. Modeling Cash and the Revolver

    45. Revolver Schedule

    46. Modeling Interest Expense

    47. Interest Expense

    48. Building a Circuit Breaker

    49. Common Size Financial Analysis

    50. Common Size Income Statement

    51. Common Size Balance Sheet

    52. Compounded Annual Growth Rate (CAGR)

    53. CAGR Exercise

    54. RECAP: Ratio Analysis

    55. Liquidity Ratios

    56. Liquidity Ratios Exercise

    57. Solvency Ratios

    58. Solvency Ratios Exercise

    59. Profitability Ratios

    60. Profitability Ratios Exercise

    61. Efficiency Ratios

    62. Efficiency Ratios Exercise

    63. Coverage Ratios

    64. Coverage Ratios Exercise

    65. Remaining Deliverables

    66. Business Analysis

    67. Income Statement Analysis

    68. Common Size Income Statement Analysis

    69. Balance Sheet Analysis

    70. Cash Flow Statement Analysis

    71. Reading Liquidity Ratios

    72. Reading Solvency Ratios

    73. Reading Profitability Ratios

    74. Reading Efficiency Ratios

    75. Reading Coverage Ratios

    76. Question List

    1. Download Supporting Files

    2. Introduction to Valuations

    3. Valuation Techiques

    4. Enterprise and Equity Value

    5. Book Vs. Market Value Equity

    6. Enterprise and Equity Value Revisited

    7. What is a Trading Comparables Analysis?

    8. Trading Comparables Analysis: Excel Exercise

    9. The Liquidity Discount

    10. Enterprise Value / EBITDA Multiple

    11. Enterprise Value / Revenue Multiple

    12. Last Twelve Months (LTM)

    13. Preparing a Trading Comps Analysis

    14. Step 1: Determine the Universe of Comparables

    15. How to Find Trading Comps

    16. Step 2: Find the Required Financial Information

    17. Step 3: Spread the Comps

    18. Step 4: Refine the Comps

    19. Step 5: Determine Valuation

    20. Case Study Revisited

    21. Finding the Trading Comps Universe

    22. Finding Trading Comps using NAICS

    23. Refining the Comps

    24. Locating Information from Financial Statements

    25. Refined Comps

    26. Inputting Financials: Relevant Comps

    27. Inputting Financials: Related Comps

    28. Deriving a Valuation Range

    1. Download Supporting Files

    2. What is a Precedent Transactions Analysis?

    3. Precedent Transactions: Excel Exercise

    4. The Control Premium

    5. Preparing a Precedents Analysis

    6. Step 1: Determine the Universe of Precedents

    7. How to find Precedents

    8. Step 2: Find Financial Information

    9. Step 3: Spread the Precedents

    10. Step 4: Refine the Precedents

    11. Locating Precedents

    12. Locating Financial Metrics

    13. Refining the Precedents

    14. Deriving a Valuation Range

About this course

  • $30.00
  • 423 lessons
  • 41.5 hours of video content