|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/financial-modeling-for-startups/
课程评论：没有评论
课程名称：创业公司的财务建模 课程概述：为什么我决定创建这个课程？我每天都与初创公司、风险投资（VC）和私募股权（PE）基金合作，注意到尽管有很多关于精益方法的优秀书籍（如《精益分析》、《精益经营》等），初创公司及中小企业在实践中应用这些知识存在困难。尤其是首次创业者往往不理解自己的商业模式，使得他们难以确定需要专注的方向。大多数企业家虽然有比较明确的商业想法，但往往不知道所选择的商业模型在实践中如何运作，最终只能通过自身的错误来学习。他们更难将商业想法和商业模型转化为一个连贯的Excel模型，以验证这个想法是否值得尝试。本课程旨在帮助您花一些时间构建一个财务或商业模型形式的Excel工具，以帮助您估算商业价值、所需现金以及商业想法和关键绩效指标（KPI）对业务的影响。 课程内容：本课程是一个实用的逐步指南，包含大量的提示和工具，可以显著加快您的业务发展。课程中包括示例、经验分享及其他值得提及的成功案例。内容涵盖了四种在线商业模型（电子商务、市场、软件服务（SaaS）、媒体网站）以及两种传统商业模型（餐饮和咨询公司）。课程分为七个部分，分别为：简介、电子商务商业模型、B2C服务、双边市场商业模型、SaaS商业模型、B2B服务和媒体网站商业模型。在每个模块中，您将学习该商业模型的定义、面对的主要挑战、应关注的KPI和预期的价值，同时也将展示如何在Excel中构建模型并得出结论。 学习成果：完成课程后，学生能够在Excel中建模经营管理，根据数据设定优先事项，选择适合自己商业理念的商业模型，了解商业中的重要因素，识别关键性能指标，以及根据构建的Excel模型得出结论。 适合人群：初创公司创始人、中小企业所有者、投资主任、业务分析师、财务分析师、 controllers 等。
Why have I decided to create this course? I work with startups, VC, and PE funds daily and I have noticed that despite tons of very good books on lean methods (i.e. Lean Analytics, Running Lean, etc.) startups, as well as small/medium businesses, have problems with applying this knowledge in practice. We have noticed that especially first-time startups, do not really understand their business model (which is totally understandable). That's why it is very difficult for them to know what they should concentrate on. Most entrepreneurs/startups have a more or less clear business idea but quite often they do not know the business models they have chosen work in practice and they end up learning it the hard way, through their own mistakes. They have even more problems with translating the business idea/business model into a coherent Excel model and checking whether the idea is worth trying. No matter what business you are trying to start it is worth devoting some time and building a financial / business model in the form of Excel. This simple tool will help you estimate the value of your business, see how much cash you need, and how your business ideas and KPIs are affecting your business. Once you build the model you can play with it and see how using different assumptions and parameters your profit will change. This course is based on my 15 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, performance improvement, and turn-arounds in the biggest firms from Retail, FMCG, SMG, B2B, and services sectors that I worked for. I have carried out or supervised over 90 different performance improvement projects in different industries that generated a total of 2 billion in additional EBITDA. On the basis of what you will find in this course, I have trained in person over 100 consultants, business analysts, and managers who now are Partners in PE and VC funds, Investment Directors and Business Analysts in PE and VC, Operational Directors, COO, CRO, CEO, Directors in Consulting Companies, Board Members, etc. On top of that my courses on Udemy were already taken by more than 224 000 students including people working in EY, Walmart, Booz Allen Hamilton, Adidas, Naspers, Alvarez & Marsal, PwC, Dell, Walgreens, Orange, and many others.What will this course give you? The course is a practical, step-by-step guide loaded with tons of tips and tools that will help you significantly speed up your business, especially if you are a startup or a small/medium business. There is little theory - mainly examples, a lot of tips from our own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know: what your business model is about, what to concentrate on and what are the key KPIs for you? How you can translate it into Excel and evaluate your business? How to make conclusions on the basis of your business model presented in the form of ExcelIn this course, I will talk about 4 online business models: e-commerce, marketplaces, SaaS, media sites, and 2 more traditional ones: restaurant and consulting (service) firm How the course is organized? Currently, the course is divided into 7 sections: Introduction. In this section, I give you a quick overview of the purpose and approach we will use in each and every section E-commerce business model. In this section, you will get insight t into the business model of different e-commerce companies. The E-commerce business group is very diversified so we will try to show the similarities and differences between concepts. You will learn here the definition of this business model, and see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it. B2C Services. In this section, I will discuss the business model of B2C services i.e. hairdressers, restaurant chains, plumbers, electricians, etc. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. We will go into more detail when it comes to the restaurant chain and I will show you how to model it in Excel 2-sided market business model. This business model has been very popular over the last 5-years and successful companies in this model can grow to be truly global players on a big scale. Here you will get insight into the business model of a 2-sided market, especially marketplaces. You will learn not only the definition of this business model but you will have also the opportunity to see some examples of companies using these models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it. SaaS business models. Here you will get insight into the business model of a Software as a Service company. You will learn the definition of the business model, and see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. In the end, I will show you how you can build the model in Excel and what conclusions can you draw from it. B2B Services. Next, we will move on to the business model of B2B services. They behave a little bit differently than the B2C service. I will show you the main challenges they are facing, the KPIs that matter in B2C service, and examples of companies. In the end, I will show you how to model a consulting business in Excel. Media site business models. Here you will have a look at a relatively simple and cheap business model - a media site. You will learn the definition of this business, and see some examples of companies using these business models. You will also understand what really matters in this sort of business, what KPIs you should look at, and what values you can expect. Afterward, I will show you how you can build the model in Excel and what conclusions can you draw from it. You will also be able to download many additional resources Models in Excel shown in lectures Links to books worth reading Links to additional resourcesAt the end of my course, students will be able to… Model your business in ExcelManage, based on numbers, your business, and set good prioritiesPick the right business model for your business ideaYou will understand what is important in your businessYou will know what KPI you should look at and what are the benchmarksYou will be able to write down your business model in the form of an Excel model and draw a conclusion from itWho should take this course? Who should not? Startup foundersSmall and medium business ownersInvestment DirectorsBusiness analystFinancial AnalystControllers
