|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/build-a-trading-comps-valuation-model/
课程评论：没有评论
课程名称：构建交易可比估值模型 概述：本课程旨在教授“可比公司分析”（Comps）的方法，这是投资银行家和金融专业人员使用的最广泛的估值方法，也是核心估值技能的关键部分。您将学习如何选择和清理可比公司，选择合适的估值倍数，并使用真实案例从零开始在Excel中构建完整的可比模型，模拟金融机构的实际操作。 课程内容包括： - 根据运营、财务、规模及其他相似性评估，学习选择合适的可比公司 - 设置评估基准并选择可比公司 - 收集适当的财务历史和预测 - 标准化运营结果，计算反映非经常性费用和股票期权费用的最近十二个月（LTM）经营结果 - 标准化各种费用分类，包括FIFO转LIFO库存会计 - 使用国库股票法计算流通股数量 - 输入财务数据，计算并解释财务和市场比率 - 通过结构化输出表呈现交易可比情况 - 使用VLOOKUP函数选择关键估值倍数并生成多重表格 该课程将使您掌握构建交易可比估值模型的技能和方法，为您的职业发展打下坚实基础。
"Comps" analysis is the most widely used valuation methodology and an essential piece of the core valuation skill set of investment bankers and finance professionals. In this course, you will learn how to select and "scrub" comparables, pick the right multiples, and build complete comps models in Excel from scratch, using a real case study the exact way it's done ay financial institutions. Lessons include: Learn to select appropriate comparable companies by evaluating operational, financial, size, and other similarities Set evaluation benchmarks & select comparable companies Gather appropriate financial history and projections Normalizing operating results and calculating LTM operating results to reflect nonrecurring charges and stock option expenses Standardize various expense classifications including FIFO to LIFO inventory accounting Calculate shares outstanding using the treasury stock method Input financial data & calculate and interpret financial and market ratios Presenting trading comps by structuring output schedule Selecting key valuation multiples using the VLOOKUP function and generating multiple tables
