|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-modelling-financial-planning-and-dcf-valuation/
课程评论：没有评论
**课程名称：** 金融建模、财务规划与现金流折现估值 **课程概述：** 本课程是一门全实践操作的课程，将带您从一个空白的Excel文件出发，学习如何构建一个强大、动态且全自动化的财务模型，可用于初创公司或现有公司。课程还帮助您为高级金融建模师（AFM）认证做好准备。 **主要内容：** * 金融模型模板创建与Excel技巧 * 构建集成的模型输入表，汇总客户的各项规划 * 创建乐观、保守、悲观三种动态情景，并贯穿整个财务报表预测 * 收入明细表创建 * 销售成本明细表创建 * 营运资本明细表创建 * 折旧明细表创建 * 债务明细表创建 * 股权明细表创建 * 税收明细表创建 * 动态生成利润表 * 动态生成资产负债表 * 动态生成现金流量表 * 实施现金流折现（DCF）估值 * 计算财务比率 **特色：** 课程提供定期的实时支持会话，以提供更丰富的学习体验，并帮助您将所学知识与职业发展相结合。现在报名，即可终身享受此项福利！
**We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life!**This is a fully hands-on course that will take you from a blank Excel file to creating a robust, dynamic and fully automated financial model that can be used for a startup or an existing company. It also prepares you for the Advanced Financial Modeler (AFM) certification.It covers the following sections:Financial Model template creation and Excel tipsFleshing out a dedicated Model Input sheet to aggregate all the client's plans Creating scenarios - Optimistic, Conservative, Pessimistic - that will flow dynamically into the entire financial statements forecastCreating the Revenue ScheduleCreating the Cost of Sales ScheduleCreating the Working Capital ScheduleCreating the Depreciation ScheduleCreating the Debt ScheduleCreating the Equity ScheduleCreating the Tax ScheduleCreating the Income Statement dynamicallyCreating the Balance Sheet dynamicallyCreating the Cashflow Sheet dynamicallyCarrying out the DCF ValuationComputing the Financial Ratios
