Financial modeling of Offline Businesses in Excel
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
710 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Financial modeling of Offline Businesses in Excel to your Wishlist.

Add to Wishlist

Financial modeling of Offline Businesses in Excel

Practical guide for Business Analysts and Consultants how to do financial and business modeling
4.3 (6 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
710 students enrolled
Created by Asen Gyczew
Last updated 7/2017
English
Price: Free
Includes:
  • 2.5 hours on-demand video
  • 25 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Create business models in Excel
  • Analyze offline business models in Excel
  • You will understand what is important in your business
  • You will know what KPI you should look at and what are the benchmarks
View Curriculum
Requirements
  • Basic or intermediate Excel
  • Basic knowledge of economics or finance
Description

What is the aim of this course?

This course will help you drastically improve your knowledge and skills in creating business models in Excel for traditional offline business such as: Retail, B2C services and products, B2B services and products. It is designed for those who want to become consultants, business analysts and people who need to be able to analyze any business in Excel. In the course you will learn 4 things:

  1. What your business model is about, what to concentrate on and what are the most important KPIs for you?
  2. How to translate your business model into Excel and evaluate it?
  3. How to draw conclusions using your business model in Excel?
  4. Estimate what will be the impact of specific changes that you may consider in your business

The course is based on my 12 years of experience as a consultant in top consulting companies and as a Board Member responsible for strategy, improvement and turn-arounds in biggest companies from FMCG, SMG, B2B sector that I worked for. On many occasions I had to build business models in in Excel in order to estimate what is the value of the business and find ways in which I can improve it. Business models are also useful for internal purposes: planning, looking for opportunities, analyzing performance, business development.  On the basis of what you will find in this course I have trained over 100 consultants, business analysts and managers who now are Investment Directors, CEO, COO, Partners in PE, Operational  Directors, Directors in Consulting Companies, Board Members etc.

I teach through cases so most of the lectures are case studies showing how to present the business model in Excel. To every lecture showing a business model in Excel you will find attached  (in additional resources) the Excels shown in the Lecture, so as a part of this course you will also get a library of ready-made business models that you can, with certain modification, apply in your work.

Why I decided to create this course?

Most consultants and business analysts struggle with building the business models in Excel as it requires a mixture of knowledge about the business, some fluency in simplification and presentation in Excel the logic behind the business. By training modeling your business in Excel you gain in-depth knowledge about your business and you can spot faster the links between seemingly unrelated issues. This course is designed to fill in the gaps and turn you into expert in business modeling. I strongly recommend this course to people who want to be in charge of the business as it will empower you to move your business forward.

To sum it up, I believe that if you want to build or to find improvements in any business you should master techniques related to modeling the business in Excel. That is why I highly recommend this course not only to consultants or business analyst that have to advice their customer but also to owners, founders  of businesses as well as investment directors.

In what way will you benefit from this course?

The course is a practical, step by step guide loaded with tones of analyses, tricks, hints that will significantly improve the speed with which you analyze and create business models in Excel. There is little theory – mainly examples, a lot of tips from my own experience as well as other notable examples worth mentioning. Our intention is that thanks to the course you will know:

  1. How to build the model in Excel for your business
  2. How to identify important issues for your business and how to reflect them in Excel
  3. How to find ways in which you can significantly increase value of the business
  4. How to calculate the impact of proposed changes in Excel

You can also ask me any question either through the discussion mode or by messaging me directly.

How the course is organized?

The course is divided currently in 6 sections and will be adding new section to address other important issues. Currently you will find the following sections:

  • Introduction. We begin with little intro into the course as well as some general info on production
  • Retail. In the second section I will discuss the business model of Retailers. I will show you the main challenges they are facing, KPIs that matter in Retail, examples of companies. Since more and more Retailers operate also on-line I will also show you the details of e-commerce business model. I will show you how to model traditional retail as well as e-commerce in Excel
  • 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.
  • 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.
  • FMCG. In this section we will move to products. The first one to be discussed are FMCG products. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. As an example I will show you how to model in Excel Cosmetics business.
  • Commodity. On the other scale are products for which the brand is not that important and that are simply selling well known, not differentiated product. . I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. As an example I will show you how to model in Excel production of plywood

I will be adding new sections and lectures in the coming months

 

You will be able also to download many additional resources

  1. Models in Excel show in lectures
  2. Links to books worth reading
  3. Presentations of different business models
  4. Links to additional presentations and movies

 

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

  • Pick the right business model for their 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?

  • Consultants
  • Business analysts
  • Investment Directors
  • Small and medium business owners
  • Startups founders
  • Controllers

What will students need to know or do before starting this course?

  • Basic or intermediate Excel
  • Basic knowledge of economics or finance
Who is the target audience?
  • Management Consultants interested in modeling
  • Business Analysts
  • Operations Directors in Retail
  • Investment Directors in Private Equity
  • Controllers
  • Startup founders
  • Small and medium business owners
Students Who Viewed This Course Also Viewed
Curriculum For This Course
45 Lectures
02:39:59
+
Introduction
2 Lectures 04:57

We begin with little intro into the course as well as some general info on production

Introduction
03:10

A little bit about me and my experience

About me
01:47
+
Retail Business Model
8 Lectures 48:43

In the second section I will discuss the business model of Retailers. I will show you the main challenges they are facing, KPIs that matter in Retail, examples of companies. Since more and more Retailers operate also on-line I will also show you the details of e-commerce business model. I will show you how to model traditional retail as well as e-commerce in Exce

Introduction to retailer business model
04:14

I will start by showing main challenges in Retail

Main challenges in Retail
03:01

I will show you in this lecture what KPI I the retail business model driven by. This will help you understand the modeling in Excel done in next lectures

Business model of Retail - main drivers
02:12

Here I will show you how to model the Retailer business in Excel.

Business model of Retailer in Excel - transaction version - 1 store
03:58

Here I will show you how to model the Retailer business in Excel.

Business model of Retailer in Excel - transaction version - retail chain
04:04

Here I will show you how to model the Retailer business in Excel.

Business model of Retailer in Excel - sq m version
01:07

In this lecture you will get insight 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.

E-commerce business model - intro
20:57

In this Lecture I will go through a business model of e-commerce and show you how you can model the behaviour of the customer, acquisition methods and margins in Excel. Attachted to this lecture you will find the file that I show in the video so dowload it and go through it. You can use it to model the e-commerce business you are analyzing

E-commerce business model - Excel example
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

Introduction to the B2C Services Business Model
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 hairdressers, 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. 

Business model of a restaurant in Excel - basic model
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
+
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.

Introduction to the B2B Services Business Model
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 we will talk abou the model of service company and consulting firm. It is an introduction to modelling it in Excel

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 B2C 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.

The business model of a consulting firm in Excel - Capacity and revenues
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
+
FMCG Business Model
11 Lectures 22:11

In this section we will move to products. The first one to be discussed are FMCG products. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. As an example I will show you how to model in Excel Cosmetics business.

Introduction to the FMCG Business Model
00:51

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

Things that matter in FMCG Business Model
03:01

I will show you how we will approach modeling FMCG business model in Excel

Introduction to modeling FMCG Services in Excel
00:32

I will show you in this lecture what KPIs, drivers are important for the FMCG model and how do they generated the end results – operating profti

Drivers for FMG business model
01:52

In this lecture I will go briefly through the main assumptions for the model that we will work on in Excel. I will also go through the first sheet in which I generate the sales

FMCG business model in Excel - Basic assumptions and Sales
02:26

In this lecture I will show you how we will estimate the fixed and variable costs in production

FMCG business model in Excel - Fixed and Variable Production Costs
03:25

In this lecture I will show you how to estimate the Gross Margin using sales and production costs

FMCG business model in Excel - Gross Margin
02:17

Now it is time to estimate the cost of sales by channels and cost of marketing

FMCG business model in Excel - Cost of sales and marketing and Net Margin
02:44

In this lecture I will show you how to estimate the Net Margin using Gross Margin and the cost of sales and marketing

FMCG business model in Excel - Net Margin
01:44

We have also take care of head office costs to get to profit and loss account

FMCG business model in Excel - Head Office costs
00:56

Finally we estimate the profit and loss account and we can try to draw conclusion on the business

FMCG business model in Excel - P&L
02:23
+
Commodity Business Model
10 Lectures 29:00

On the other scale are products for which the brand is not that important and that are simply selling well known, not differentiated product. I will show you the main challenges they are facing, KPIs that matter in B2C service, examples of companies. As an example I will show you how to model in Excel production of plywood

Introduction to the Commodity Business Model
02:37

I will shortly go through things that are important in Commodities

Things that matter in Commodity Business Model
04:23

Drivers for Commodity business model
02:43

Here I will show you what model we will build for commodity business model and what are the assumptions

Commodity business model in Excel - Basic assumptions and Sales
03:27

In this lecture we will discuss how to model production costs in FMCG

Commodity business model in Excel - Fixed and Variable Production Costs
04:45

We move on to modeling the Gross Margin in commodit

Commodity business model in Excel - Gross Margin
01:18

Now it is time to add the cost of sales and marketing

Commodity business model in Excel - Cost of sales and marketing
02:12

Now we can calculate the net margin

Commodity business model in Excel - Net Margin
02:22

We cannot forget the head office costs in our clacuations

Commodity business model in Excel - Head Office costs
00:54

FInally we can calculate the P&L for commodity

Commodity business model in Excel - P&L
04:19
About the Instructor
Asen Gyczew
4.3 Average rating
848 Reviews
18,706 Students
22 Courses
Expert in performance improvement, turnaround and startups

Expert in performance improvement, startuping and turning-around companies with significant experience both in management as well as in supervision of medium size companies (EUR 20 – 40 million) as well as startups.

Specialties:

Functional experience: performance improvement, strategy development, startups, intrapreneurship, post-merger integration and cost reduction, due diligence;

Industry experience: SMCG (domestic appliances, furniture, ceramic tiles), FMCG (cosmetics, juice, meat), retail (electronics, convenience shops, pharmaceuticals, DIY, vending), B2B (aluminum system, plywood, alcohol, reagents, loading systems), services (MRO, consulting, outsourcing)

Countries: Poland, Serbia, Russia, Ukraine