Financial Modeling for Startups
4.2 (101 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,330 students enrolled

Financial Modeling for Startups

Learn how to model a startup business in Excel and draw conclusions about your business
4.2 (101 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,330 students enrolled
Created by Asen Gyczew
Last updated 7/2020
English
English [Auto]
Current price: $62.99 Original price: $89.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 3 hours on-demand video
  • 1 article
  • 16 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
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
Requirements
  • Basic or intermediate Excel
  • Basic knowledge of economics or finance
Description

Why I decided to create this course?

I work with startups, VC and PE funds on daily and I have noticed that despite tones 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 more or less clear business idea but quite often they do not know the business models they have chosen works 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 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.

The course is based on my 14 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, new business development, improvement and turn-arounds in biggest firms from Retail, FMCG, SMG, B2B and services sector that I worked for. On many occasions I was working on building new businesses and supporting startups.  On the basis of what you will find in this course I have trained startup founders, entrepreneurs but also Business Analysts working for PE / VC funds, Investment Directors, Business Development Managers creating new businesses as a part of a bigger corporation.

What will this course give you?

The course is a practical, step by step guide loaded with tones of tips and tools that will help you significantly speed up with 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:

  1. what your business model is about, what to concentrate on and what are the key KPIs for you?
  2. How you can translate it into Excel and evaluate your business?
  3. How to make conclusions on the basis of your business model presented in the form of Excel

In this course I will talk about 4 online business models: e-commerce, marketplaces, SaaS, media site 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 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. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this 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. Afterwards, 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. hairdresser, restaurant chains, plumber, electricians etc. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. We will go into more details when it comes to 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 true global players at big scale.  Here you will get insight into the business model of 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. Afterwards, 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 Software as a Service companies. You will learn the definition of the business model , see some examples of companies using this 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. At 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 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, KPIs that matter in B2C service, examples of companies. At the end I will show you how to model consulting business in Excel.
  • Media site business models.  Here you will have a look at relatively simple and cheap business model – media site. You will learn the definition of this business, see some examples of companies using this 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. Afterwards, 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

  1. Models in Excel show in lectures
  2. Links to books worth reading
  3. Links to additional resources

At the end of my course, students will be able to…

  • Model your business in Excel
  • Manage based on numbers your business and set well priorities
  • 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

Who should take this course? Who should not?

  • Startup founders
  • Small and medium business owners
  • Investment Directors
  • Business analyst
  • Financial Analyst
  • Controllers
Who this course is for:
  • Startup founders
  • Investment Directors
  • Business Analyst
  • Small and medium business owners
  • Financial Analyst
  • Controllers
  • Management Consultants
Course content
Expand all 45 lectures 02:51:45
+ Introduction
5 lectures 10:20

I work with startups, VC and PE funds on daily and I have noticed that despite tones 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 more or less clear business idea but quite often they do not know the business models they have chosen works 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 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.   

The course is based on my 14 years of experience as a consultant in top consulting firms and as a Board Member responsible for strategy, new business development, improvement and turn-arounds in biggest firms from Retail, FMCG, SMG, B2B and services sector that I worked for. On many occasions I was working on building new businesses and supporting startups.  On the basis of what you will find in this course I have trained startup founders, entrepreneurs but also Business Analysts working for PE / VC funds, Investment Directors, Business Development Managers creating new businesses as a part of a bigger corporation.

Preview 02:20

In this lecture I will share some info on who am I and what is my experience

Preview 01:47

Here I will talk briefly how the course is organized and how I recommend approach i

Preview 03:04

Here I will show you what to do if a blurry image appears

How to deal with Blurry image
02:04

Here I will show you how to find additional resources attached to the coruse like Excel files, presentations, links etc.

How to reach additional resources
01:05
+ E-commerce business model
6 lectures 30:06

In this section you will get insight t into the business model of different e-commerce companies. E-commerce businesses group is very diversified so we will try to show the similarities and the differences between concepts.. You will learn here the definition of this business model, see some examples of companies using this 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. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 03:28

In this lecture I will show you examples of firms that work in this specific business model.

Preview 01:53

In this lecture I will show you how the potential customer flow through your business  / sites.

Preview 01:09

In this lecture I will discuss the KPIs that you should concentrate on in this business

Main KPIs for e-commerce
09:36

It is time to discuss the main challenges in this business

Main challenges in e-commerce
04:50

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 09:10
+ B2C Services Business Model
7 lectures 34:58

We can be talking about 3 different models in B2C services

  • Services performed at specialized place no production involved
  • Services performed at specialized place with some production
  • Services performed at customer place

I will discuss the differences between them in this lecture

Preview 01:17

I will shortly go through things that matter in the case of B2C Services performed at specialized place no production involved such as hairdressers, beauty salons and other

Things that matter in hairderssers, beauty salons etc.
05:30

I will shortly go through things that are important in other B2C Services such as restaurant chains, services performed at the customer place etc.

Things that matter in other B2C Services Business Model
01:57

In the next lecture I will show you the main drivers of the B2C model and on the basis of this we will create a business model in Excel. I will concentrate on the example of restaurant chain

Introduction to modeling B2C Services in Excel
01:00

Excel gives you great opportunities to calculate whether your idea makes sense or not. For this you will use the knowledge you have gathered in the previous lectures on your concept, location and your customers. Excel is obviously less emotion than you and the model you will create here can be used as a cornerstone of your business plans. It shows also to banks and potential investors what is your cash flow. We start with a simple model so you can understand it and learn how to use it. 

Preview 09:11

In this lecture we make more advanced model. We introduce the traffic parameter and show how it is converted first into people that are engaged (stop and enter your restaurant) and later into customers (they buy something from you). Here we will be operating on 2 customer groups: first one eats at the restaurant; second one comes for take-aways. For both customer groups we calculate separate conversion rates and Average ticket (ATV). We still here show you a business model for a 1 restaurant

Business model of a restaurant in Excel - advanced model
08:58

Finally we show you how to model in Excel a restaurant chain.

Restaurant chain - how to model it in Excel?
07:05
+ 2-sided market business model
6 lectures 24:29

This business model has been very popular over the last 5-years and successful companies in this model can grow to be true global players at big scale.  Here you will get insight into the business model of 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. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 01:37

In this lecture I will show you examples of firms that work in this specific business model.

Examples of 2-sided market businesses
02:55

In this lecture I will show you how the potential customer flow through your business  / sites.

Logic flow of customers in 2-sided market
01:09

In this lecture I will discuss the KPIs that you should concentrate on in this business

Main KPIs for 2-sided market
03:16

It is time to discuss the main challenges in this business

Main challenges in 2-sided market
05:50

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 09:42
+ SaaS business model
6 lectures 27:12

Here you will get insight into the business model of Software as a Service companies. You will learn the definition of the business model , see some examples of companies using this 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. At the end, I will show you how you can build the model in Excel and what conclusions can you draw from it.

Preview 00:51

In this lecture I will show you examples of firms that work in this specific business model.

Examples of SaaS businesses
02:03

In this lecture I will show you how the potential customer flow through your business  / sites.

Logic flow of customers in SaaS
01:59

In this lecture I will discuss the KPIs that you should concentrate on in this business

Main KPIs for SaaS
09:08

It is time to discuss the main challenges in this business

Main challenges in SaaS
05:05

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

SaaS financial model - basic version
08:06
+ B2B Services Business Model
7 lectures 20:10

Next we will move on to 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, KPIs that matter in B2C service, examples of companies. At the end I will show you how to model consulting business in Excel.

Preview 01:51

I will shortly go through things that are important in other B2B Services.

Things that matter in B2B Services Business Model
02:47

Here I will share with you some general thoughts on the service business model

General thoughts on B2B Services
04:28

In the next lecture I will show you the main drivers of the B2C model and on the basis of this we will create a business model in Excel. I will concentrate on the example of restaurant chain

Introduction to modeling B2B Services in Excel
00:39

Before I show you the model in Excel I want to present you in this lecture the overall logic

Mechanics of business model for a consulting firm
02:26

I show you in the lecture the model of the consulting firm in Excel. After modifying it you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.

Preview 02:54

I show you in the lecture the model of the consulting firm in Excel. After modifying it you can use it for your purposes (we attach the Excel files to the lecture). This model will let you check whether your business idea makes sense.

The business model of a consulting firm in Excel - costs and profit & loss
05:05
+ Media site business model
7 lectures 23:16
  • Here you will have a look at relatively simple and cheap business model – media site. You will learn the definition of this business, see some examples of companies using this 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. Afterwards, I will show you how you can build the model in Excel and what conclusions can you draw from it.
Preview 04:26

In this lecture I will show you examples of firms that work in this specific business model.

Examples of media site businesses
02:46

In this lecture I will show you how the potential customer flow through your business  / sites.

Logic flow of customers in media site
00:58

In this lecture I will discuss the KPIs that you should concentrate on in this business

Main KPIs for media site - Part 1
01:30

In this lecture I will discuss the KPIs that you should concentrate on in this business

Main KPIs for media site - Part 2
05:03

It is time to discuss the main challenges in this business

Main challenges in media site
03:40

In this lecture I will show you how you can build the model in Excel and what conclusions can you draw from it.

Media site financial model - basic version
04:53
+ Conclusions
1 lecture 01:14
Bonus Lecture: up to 90% discounts for all my courses
01:14