Introduction
In this comprehensive course, you'll dive deep into the art of Relative Valuation and Corporate Valuation techniques using practical examples and real-world applications. We’ll explore different valuation ratios, comparable company analysis, and advanced financial models, such as Discounted Cash Flow (DCF) and Dividend Discount Models (DDM). This course is designed to take you from a beginner to a pro in corporate valuation using Microsoft Excel, providing you with the essential tools to evaluate company performance and make informed financial decisions.
This course includes:
🎥 7.5 Hours On-Demand Video
Access comprehensive video content to learn at your own pace.
📱 Access on Mobile and TV
Learn anytime, anywhere with support for multiple devices.
🔓 Unlimited Access
Enjoy unrestricted access to the course materials forever, empowering you to learn at your own pace.
📜 Certificate of Completion
Receive a certificate to showcase your skills and accomplishments.
What you'll learn
- Introduction to Relative Valuation – Understanding its importance and use in financial analysis.
- Different Types of Valuation Ratios – Exploring Price-to-Earnings (PE), Price-to-Book (PBV), Price-to-Sales (PS), and PEG Ratios.
- Advantages and Disadvantages of Valuation Ratios – When to apply each and their limitations.
- Practical Application of Valuation Ratios – Hands-on exercises with real-world company examples.
- Comparable Company Analysis – Identifying and evaluating public companies for benchmarking.
- Equity Value vs. Enterprise Value – Calculating and understanding the differences between these key metrics.
- Building Financial Models – Constructing advanced models like Dividend Discount Model (DDM) and Discounted Cash Flow (DCF).
Who this course is for
- Finance Professionals – Those working in investment banking, financial analysis, corporate finance, or related fields looking to enhance their valuation skills.
- Business Students – MBA students or those studying finance who want practical knowledge in company valuation and financial modeling.
- Investors & Traders – Individuals looking to evaluate companies more effectively through relative valuation and improve their investment decisions.
- Accountants & Auditors – Professionals interested in understanding company valuations to complement their financial reporting or auditing practices.
- Entrepreneurs – Business owners seeking to better understand the value of their company or potential investment opportunities.
- Career Changers – Individuals transitioning into finance or corporate valuation roles who want to build foundational skills.
-
Anyone Interested in Corporate Valuation – Whether you're a beginner or have some experience, this course is for those eager to understand and apply valuation techniques.
Course Curriculum
Comprehensive Relative Valuation Training
Available in
days
days
after you enroll
- Introduction to Relative Valuation (2:09)
- Types of Relative Valuation (3:45)
- Advantages and Disadvantages (8:08)
- Earning and Book Multiples (7:38)
- Understand EV Ratio (8:56)
- Understand EV Ratio Continues (7:55)
- Finding List of Public Company (6:38)
- PE Ratio (6:46)
- Advantages and Disadvantages of PE Ratio (4:58)
- Advantages and Disadvantages Continues (8:18)
- Equity Value (6:18)
- PBV Ratio (9:51)
- PBV Ratio Continues (4:39)
- Price to Sales Ratio (4:54)
- Advantages and Disadvantages of PS Ratio (7:39)
- PEG Ratio (2:26)
- Equity Value Vs Enterprise Value (3:26)
- Understand Comparable Company Analysis (4:42)
- Use of Comparable Company Analysis (6:19)
- Method of Comparable Company Analysis (9:31)
- Get Financial Information (3:46)
- List Of Comparable Company List (10:48)
- Bench Marking Analysis (5:02)
- Working on Target Sheet (4:06)
- Reported Income Statement (8:27)
- Adjusted Income Statement (3:35)
- Cash Flow Statement Data (7:22)
- Equity Value and Enterprise Value (4:26)
- Trading Multiples (9:49)
- Working on Company A Sheet (5:23)
- Calculating Gross Profit (3:55)
- Working on Balance Sheet Data (10:32)
- Working on Company B Sheet (9:27)
- Select Market Data (5:26)
- Working on Sheet C (4:53)
- Understand Bench Marking Summary (10:15)
- Understand Bench Marking Summary Continue (4:55)
- Working on Output Sheet (6:23)
- Working on Industry Average Sheet (2:37)
- Input Sheet (7:29)
- Relative Valuation Sheet (1:49)
- Working on DCF Valuation Sheet (4:08)
- Operating Leases (5:24)
- Total Capita Invested (8:19)
- Calculating Reinvestment Rate (8:01)
Corporate Valuation - DCF and Relative Valuation
Available in
days
days
after you enroll
- Corporate Valuations - Overview (2:07)
- Ddm - Dividend Discount Model- Intrinsic Value (5:42)
- Ddm - Dividend Discount Model- Required Rate Of Return (6:31)
- Ddm - Dividend Discount Model- Compare Intrinsic And Market Price (5:04)
- Ddm - Intrinsic Value Of Growth Companies (4:02)
- Ddm - Dividend Discount Model- Present Value (8:12)
- Introduction To Dcf (4:53)
- Forecasting Income Statement - EBITDA (6:26)
- Understanding The Working Capital (2:30)
- Completing The Working Capital Calculations (2:42)
- Linking The Free Cash Flow To Firm Fcff (7:06)
- Discounting The Explicit Period Cash Flows (5:12)
- Calculation Of Terminal Values (6:49)
- Dcf Valuation Summary (6:22)
- Dcf Sensitivity Analysis (7:18)
- Understanding The Capital Structure (11:48)
- Options Treasury Stock Method (6:18)
- Options Explained (2:03)
- Calculation Of In The Money Convertibles (4:28)
- Calculation Of In The Money Stock Options (5:11)
- Calculation Of Debt Equity Ratio (4:06)
- Cost Of Debt Calculations (4:05)
- Cost Of Equity Calculation (7:32)
- Enterprise Value Calculation Completing The Missing Links (3:29)
- Introduction To Relative Valuation (7:49)
- Relative Valuations Enterprise Value And Equity Value (5:18)
- Relative Valuations Comparable Comp Sheet (6:17)
- Understanding Pe Ratio (6:46)
- Forward And Trailing Pe (3:19)
- Advantages And Limitations Of Pe (4:26)
- Understanding PBV Ratio (2:13)
- Why Pbv Is Used In Banks (8:10)
- Pbv And Roe Used For Energy Sector (2:12)
- Understanding PCF Ratio (3:01)
- Why Pcf Used In Oil Gas Gold Real Estate (3:03)