Relative Valuation and Corporate Valuation with MS Excel
Master the art of Relative and Corporate Valuation with hands-on Excel models and real-world strategies
4.30 (23 reviews)
7,122
students
7.5 hours
content
Oct 2024
last update
$19.99
regular price
What you will 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).
Forecasting Financial Statements – Projecting income statements, balance sheets, and cash flows.
Working Capital and Cash Flow Analysis – Learning the intricacies of working capital and how it affects valuations.
Excel Skills for Corporate Valuation – Using Microsoft Excel to implement financial models, calculations, and sensitivity analysis.
5533192
udemy ID
8/31/2023
course created date
9/1/2023
course indexed date
Bot
course submited by