|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-modelling-for-making-business-decisions-and-plans/
课程评论：没有评论
课程名称：为商业决策和计划制定的财务建模 课程概述：财务建模是创建用于做出涉及财务的商业决策的模型。财务建模的过程是将公司的支出和收益汇总成电子表格，以便计算未来事件或决策的影响。通过财务建模，用户可以做出财务决策并理解对损益表、投资回报率（ROI）、内部收益率（IRR）和现金流的影响。在本课程中，我们将教授财务建模的关键方面，并进行实时案例研究，展示财务建模的最佳实践、如何避免错误及发现错误、如何进行假设、决策所需的输入、如何将决策流程建模到Excel模型中、如何进行财务预测以及如何制作三份财务报表（损益表、现金流量表、资产负债表）。本课程还将指导你关于如何假设预测并在潜在投资者提问时进行辩护的过程。通过学习本课程，您将能够评估收入和成本模型、理解盈亏平衡点、计算资金消耗及预测所需资金。您还将获得课程中使用的Excel模板，以便进行跟随学习。
Financial modeling, as the name suggests is to create models for making business decisions involving finance.Financial modeling is the process of creating a summary of a company's expenses and earnings in the form of a spreadsheet that can be used to calculate the impact of a future event or decision.The financial modeling process helps users make financial decisions and understand their impact on profit & loss statements, ROI, IRR, Cash Flow.In this course, we will teach you key aspects of financial modeling and will be doing a live case study & demonstrating - Best Practices in financial modeling - How to avoid errors and spot them- How do we make assumptions- What inputs are required for making decisions.- How we model decision flow into excel model. - How to make projections- Making 3 Financial statements (Profit & Loss Statement, cash flow, balance sheet)This course will also take you through the process of making assumptions about projections and how to justify them and defend when potential investors may ask questions. By taking this course you will be able to - Evaluate your revenue and cost models. - understand what can breakeven - calculate cash burns and the ability to project how much you need.You will get an excel template used in the course for following along.
