Financial Modeling Professional Certificate
Learn how to build common to complex financial models on Excel with information provided both on financial statements and from external sources.
CPE学分:35
Prerequisite knowledge:
- Undergraduate degree or equivalent, proficiency in basic Excel, Word processing skills
Module 1: Advanced Excel for Financial Modeling
- 介绍/建议 & tricks that will help you speed up your spread sheeting
- 多个表模型
- 多个文件模型
- Drilling down: allows one to double-click a formula, and move back to its source. This can be particularly useful in the creation of menus
- 逻辑测试
- 保护你的数据
- 数据库活动
- 数据透视表
- Grouping downloaded data by account headings
- Vertical and horizontal lookup tables
- 选择函数
- Interactive formulas to extract data
- 字符串函数
- 数据表
- 概述
- 图
- 间接寻址
Module 1: Financial Modeling
- Introduction and Overview
- Projection-Valuation Modeling Best Practices
- 预估模型
- 练习
Module 1: Basic Valuation Techniques
- Case Study: Analyze historic information and develop a projection basis
- 合并 and 收购
- Projecting financial statements for a complex M&A
- Debt capacity and credit analysis for the acquisition
- Alternative financing methods
- Sensitivity analysis on cash flows
- 案例研究练习
- Cost of Capital and CAPM
- 股本回报率
- Seven steps using CAPM to determine the cost of capital
- Implied risk premium in the current P/E multiple
模块1:估值
- Four Steps using the Gordon Model to determine the cost of capital
- Four steps using the P/E multiple to determine the cost of capital
- Financial Valuation 案例研究练习 Review and Discussion
- Accrual 会计 Valuation
- Accrual accounting valuation exercises
- Valuation Using Multiples
- Multiples valuation exercises
- 交易倍数
Module 1: Special Valuation Issues
- 隐含的利润率
- Three-stage valuation model
- Develop an accrual accounting valuation model Review and Discussion
- Warrants and Executive Stock 选项
- 权证估值
- Value outstanding warrants
- 股票回购
- Using share repurchases to calculate growth in distributions
- Sustainable growth rate
- Share repurchases for comparable companies
- Presentation of Valuation and conclusion
Module 2: Desk Ready Skills Knowledge Check