Financial Modeling for Startups

Learn how to model a startup business in Excel and draw conclusions about your business
Financial Modeling for Startups
File Size :
1.92 GB
Total length :
2h 53m

Category

Instructor

Asen Gyczew

Language

Last update

8/2023

Ratings

4.5/5

Financial Modeling for Startups

What you’ll learn

Model your business in Excel
Manage your business based on numbers / KPIs
Set well priorities to value creating activities
Pick the right business model for your business idea
You will understand what is important in your business
You will know what KPI you should look at and what are the benchmarks
You will be able to write down your business model in the form of an Excel model and to draw conclusion out of it

Financial Modeling for Startups

Requirements

Basic or intermediate Excel
Basic knowledge of economics or finance

Description

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 181 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 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 be able also 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 well 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

Overview

Section 1: Introduction

Lecture 1 What the course will be about

Lecture 2 A little bit about me

Lecture 3 How this course will be organized?

Lecture 4 How to deal with Blurry image

Lecture 5 How to reach additional resources

Section 2: E-commerce business model

Lecture 6 Introduction to e-commerce

Lecture 7 Examples of e-commerce businesses

Lecture 8 Logic flow of customers in e-commerce

Lecture 9 Main KPIs for e-commerce

Lecture 10 Main challenges in e-commerce

Lecture 11 E-commerce financial model – basic version

Section 3: B2C Services Business Model

Lecture 12 Introduction to the B2C Services Business Model

Lecture 13 Things that matter in hairderssers, beauty salons etc.

Lecture 14 Things that matter in other B2C Services Business Model

Lecture 15 Introduction to modeling B2C Services in Excel

Lecture 16 Business model of a restaurant in Excel – basic model

Lecture 17 Business model of a restaurant in Excel – advanced model

Lecture 18 Restaurant chain – how to model it in Excel?

Section 4: 2-sided market business model

Lecture 19 Introduction to 2-sided market

Lecture 20 Examples of 2-sided market businesses

Lecture 21 Logic flow of customers in 2-sided market

Lecture 22 Main KPIs for 2-sided market

Lecture 23 Main challenges in 2-sided market

Lecture 24 2-sided market financial model – basic version

Section 5: SaaS business model

Lecture 25 Introduction to SaaS

Lecture 26 Examples of SaaS businesses

Lecture 27 Logic flow of customers in SaaS

Lecture 28 Main KPIs for SaaS

Lecture 29 Main challenges in SaaS

Lecture 30 SaaS financial model – basic version

Section 6: B2B Services Business Model

Lecture 31 B2B Service Business Model – Introduction

Lecture 32 Things that matter in B2B Services Business Model

Lecture 33 General thoughts on B2B Services

Lecture 34 Introduction to modeling B2B Services in Excel

Lecture 35 Mechanics of business model for a consulting firm

Lecture 36 The business model of a consulting firm in Excel – Capacity and revenues

Lecture 37 The business model of a consulting firm in Excel – costs and profit & loss

Section 7: Media site business model

Lecture 38 Introduction to media site

Lecture 39 Examples of media site businesses

Lecture 40 Logic flow of customers in media site

Lecture 41 Main KPIs for media site – Part 1

Lecture 42 Main KPIs for media site – Part 2

Lecture 43 Main challenges in media site

Lecture 44 Media site financial model – basic version

Section 8: Other Financial Models

Lecture 45 Other Business Models

Lecture 46 How to scale up a business – best practices from top firms

Section 9: Conclusions

Lecture 47 Bonus Lecture

Startup founders,Investment Directors,Business Analyst,Small and medium business owners,Financial Analyst,Controllers,Management Consultants

Course Information:

Udemy | English | 2h 53m | 1.92 GB
Created by: Asen Gyczew

You Can See More Courses in the Business >> Greetings from CourseDown.com

New Courses

Scroll to Top