|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/corporate-valuation-mastery-dcf-ddm-relative-valuation/
课程评论：没有评论
**课程名称：** 公司估值精通 - DCF、DDM 及相对估值 **课程概述：** 本课程全面教授如何使用 Microsoft Excel 进行公司估值，适合初学者及专业人士。 **第一部分：公司估值基础** * 公司估值的重要性与应用 * 股利折现模型 (DDM)：内在价值、必要报酬率计算，内在价值与市场价格比较 * 成长型公司的内在价值、现值概念 * 现金流折现 (DCF) 模型入门 * 预测损益表和 EBITDA * 理解营运资本，联系自由现金流 (FCFF) * 折现显性期现金流 * 计算终值，DCF 估值总结，敏感性分析 * 资本结构理解，债务和股权成本计算方法 **第二部分：全面的相对估值训练** * 相对估值介绍及类型 * 收益倍数、账面倍数、EV 倍数、市盈率 (PE)、市净率 (PBV) 的优缺点 * 寻找可比公司，进行基准分析 * 处理各类财务报表 * 交易倍数，行业平均值，相对估值表 **第三部分：DCF - 现金流折现** * DCF 方法论介绍及课程大纲 * DCF 的基本概念、终值概念及常见特征 * 重要会计方程式 * DCF 的优势，操作步骤，现金流预测 * 案例研究：预测终值，计算债务和股权成本，理解 Beta * 创建敏感性表格，完成案例研究，准备面试问题 **课程目标：** 学员将深入理解 DDM、DCF 及相对估值等公司估值技术，并能运用 Microsoft Excel 有效地分析和评估公司。本课程旨在提升专业技能，助力职业发展。
Course IntroductionWelcome to "Corporate Valuation - Beginner to Pro in Microsoft Excel," a comprehensive course designed to equip you with the skills and knowledge to master corporate valuation using Microsoft Excel. Whether you are a novice or an experienced professional, this course will take you from the basics of valuation models to advanced techniques, providing you with practical, real-world applications.Section 1: Corporate Valuation FundamentalsIn this section, you'll start with an overview of corporate valuations, understanding their significance and application. You'll dive into the Dividend Discount Model (DDM), learning how to calculate intrinsic value, required rate of return, and compare intrinsic and market prices. This section also covers the intrinsic value of growth companies, present value concepts, and introduces the Discounted Cash Flow (DCF) model. You'll forecast income statements and EBITDA, understand working capital, link free cash flow to the firm (FCFF), and discount explicit period cash flows. The section concludes with the calculation of terminal values, DCF valuation summary, sensitivity analysis, understanding capital structure, and various methods for calculating cost of debt and equity.Section 2: Comprehensive Relative Valuation TrainingThis section delves into relative valuation techniques, starting with an introduction and the different types of relative valuation. You'll explore earning and book multiples, EV ratios, PE ratios, and PBV ratios, including their advantages and disadvantages. The course will guide you through the process of finding comparable companies, conducting benchmarking analysis, and working on various financial statements. You'll also learn about trading multiples, industry averages, and relative valuation sheets, providing a holistic understanding of how to perform comprehensive relative valuations.Section 3: DCF - Discounted Cash FlowIn this section, you'll focus on the Discounted Cash Flow (DCF) method, beginning with an introduction and course outline. You'll explore various valuation methodologies, basic concepts of DCF, terminal value concepts, and the common traits of DCF values. The section covers important accounting equations, the advantages of DCF, steps involved in the DCF process, and predicting cash flows. You'll work through a case study to predict terminal values, calculate cost of debt and equity, and understand beta. The section concludes with creating a sensitivity table, finalizing the case study, and preparing for common interview questions.ConclusionBy the end of this course, you will have a deep understanding of corporate valuation techniques, including DDM, DCF, and relative valuation methods. You will be able to apply these concepts using Microsoft Excel to analyze and value companies effectively. Whether you aim to enhance your professional skills or advance your career, this course provides the essential tools and knowledge to achieve your goals.
