Subscription Business Models for Management Consultants

Subscription Business Models for Management Consultants, available at $49.99, has an average rating of 4.6, with 70 lectures, based on 41 reviews, and has 888 subscribers.

You will learn about How to model in Excel subscription businesses How to analyze whether the switch to a subscription business What are the main challenges in subscription businesses? How to calculate customer acquisition costs How to reduce customer acquisition costs How to increase the value of customers How to model e-commerce, streaming business and SaaS business in Excel This course is ideal for individuals who are Management Consultants or Business Analysts or Managers or Financial Controllers or Investment Analysts or Startup Founders or Managers responsible for Acquisitions and Mergers It is particularly useful for Management Consultants or Business Analysts or Managers or Financial Controllers or Investment Analysts or Startup Founders or Managers responsible for Acquisitions and Mergers.

Enroll now: Subscription Business Models for Management Consultants

Summary

Title: Subscription Business Models for Management Consultants

Price: $49.99

Average Rating: 4.6

Number of Lectures: 70

Number of Published Lectures: 70

Number of Curriculum Items: 70

Number of Published Curriculum Objects: 70

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

How to model in Excel subscription businesses
How to analyze whether the switch to a subscription business
What are the main challenges in subscription businesses?
How to calculate customer acquisition costs
How to reduce customer acquisition costs
How to increase the value of customers
How to model e-commerce, streaming business and SaaS business in Excel

Who Should Attend

Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Managers responsible for Acquisitions and Mergers

Target Audiences

Management Consultants
Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Managers responsible for Acquisitions and Mergers

What is the aim of this course?

More and more firms are switching from transaction-based businesses to subscription businesses. This business model requires a different approach when it comes to analyzing it in Excel. During some consulting projects, you may be asked to analyze or model subscription business models in Excel and advise firms on the best course of action. In this course, I will teach how to model fast and efficiently subscription businesses in Excel and how to analyze them during consulting projects.

In the course you will learn the following things:

How to model different subscriptionbusinesses in Excel
How to analyze whether the switch to a subscription model makes sense or not
How to analyze customer acquisition

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, McKinsey, PwC, Dell, Walgreens, Orange, and many others.

I teach through case studies, so you will have a lot of lectures showing examples of analyses, and tools that we use. To every lecture, you will find attached (in additional resources) the Excels as well as additional presentations, and materials shown in the lectures so as a part of this course you will also get a library of ready-made analyses that can, with certain modifications, be applied by you or your team in your work.

Why have I decided to create this course?

Subscription businesses are not the dominant form in most industries. Many people struggle with capturing the complexity of such businesses in Excel. Subscription businesses also require a totally different approach to customer acquisition and retention. Most universities are not addressing this sort of business. Also, some consulting firms don’t provide their consultants with enough opportunities to understand and learn how subscription businesses work.

Therefore, I have decided to create this course that will help students understand or refresh their knowledgeof subscription businesses. The course will give you the knowledge and insight into real-life case studies that will make your life during a consulting project much easier. Thanks to this course, you will know what and how to do during consulting projects devoted to subscription businesses. You will master the modeling of subscription businesses in Excel and analyze whether the switch to such a model will make sense. On top of that, you will learn how to approach customer acquisition and retention.

To sum it up, I believe that if you want to become a world-class Management Consultant or Business Analyst you have to have a pretty decent understanding of subscription businesses. That is why, I highly recommend this course to Management Consultants or Business Analysts, especially those who did not finish business school or Economics. The course will help you become an expert in subscription businesses on the level of McKinsey, BCG, Bain, and other top consulting firms.

In what way will you benefit from this course?

The course is a practical, step-by-step guide loaded with tons of analyses, tricks, and hints that will significantly improve the speed with which you understand, and analyze businesses. 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 learn:

1. How to model different subscriptionbusinesses in Excel

2. How to analyze whether the switch to a subscription model makes sense or not

3. How to analyze customer acquisition

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

How the course is organized?

The course is divided currently into the following sections:

Introduction.We begin with a little intro to the course as well as some general info on how the course is organized.
Essential Concepts.We will start by explaining some essential concepts that later we will use to describe and show you the differences between subscription businesses. I will explain what we mean by subscription businesses, churn rate, MRR, and MRR churn. I will also provide examples of firms using a subscription model.
Modeling Subscription Businesses in Excel.Modeling Subscription Businesses in Excel requires a bit different approach than transaction-based businesses. We will show you in this section how to do it. I will start with transaction-based e-commerce, after which we will show you how to model e-commerce as a subscription. Later on, we will also model the streaming businesses.
SaaS.A lot of SaaS businesses run as subscription businesses. We will discuss what SaaS is, what KPIs you should pay attention to, and how to model them in Excel.
Customer Acquisition.Without customer acquisition, you will not enjoy much growth. In e-commerce, you will spend a lot of time optimizing and finding more optimal ways to acquire customers. In this section, we will discuss how to calculate customer acquisition costs, how to lower them, and how to increase the value of the customer.

You will be able also to download many additional resources

1. Useful frameworks and techniques

2. Models & Analyses shown in the course

3. Additional resources

4. Links to additional presentations, articles, and movies

5. Links to books worth reading

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

How to model in Excel subscription businesses
How to analyze whether the switch to a subscription business
What are the main challenges in subscription businesses?
How to calculate customer acquisition costs
How to reduce customer acquisition costs
How to increase the value of the customer
How to model e-commerce, streaming business, and SaaS business in Excel

Who should take this course? Who should not?

Management Consultants and Business Analysts
Managers
Financial Controllers
Investment Analysts
Startup Founders
Project Managers
Managers responsible for Acquisitions and Mergers

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

Basic or intermediate Excel
Basic knowledge of economics
Basic or intermediate knowledge of finance & accounting

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction

Lecture 2: A little bit about me

Lecture 3: How to deal with Blurry image

Lecture 4: How to reach additional resources

Chapter 2: Essential Concepts

Lecture 1: Essential Concepts – Introduction

Lecture 2: Examples of Subscription Models

Lecture 3: Drivers of Subscription Models

Lecture 4: What is a Customer Churn Rate

Lecture 5: Monthly Recurring Revenue (MRR)

Lecture 6: What is a MRR Churn Rate

Chapter 3: Modeling Subscription Business in Excel

Lecture 1: Modeling Subscription Business in Excel – Introduction

Lecture 2: E-commerce financial model – Basic version

Lecture 3: Modeling Cash Flow in e-commerce – Introduction

Lecture 4: Cosmetics E-commerce – Case Introduction

Lecture 5: Cosmetics E-commerce – Data Available

Lecture 6: Cosmetics E-commerce – Sales & Margin & Head Office Costs

Lecture 7: Cosmetics E-commerce – P&L

Lecture 8: Cosmetics E-commerce – How to get from Net Profit to Cash Flow

Lecture 9: Cosmetics E-commerce – Some comments on Working Capital

Lecture 10: Cosmetics E-commerce – Back to Excel

Lecture 11: Cosmetics E-commerce – Working Capital, Capex, Debt

Lecture 12: Cosmetics E-commerce – Cash Flow

Lecture 13: Cosmetics E-commerce – Interest Received

Lecture 14: Cosmetics E-commerce – How to create a Flexible Model

Lecture 15: E-commerce subscription – Case Introduction & Drivers

Lecture 16: E-commerce subscription – Data Available

Lecture 17: E-commerce subscription – Customers

Lecture 18: E-commerce subscription – Sales & Margin

Lecture 19: E-commerce subscription – Capex

Lecture 20: E-commerce subscription – Head Office Costs

Lecture 21: E-commerce subscription – P&L

Lecture 22: E-commerce subscription – Working Capital & Debt

Lecture 23: E-commerce subscription – CF

Lecture 24: Streaming Business – Case Introduction & Drivers

Lecture 25: Streaming Business – Data Available

Lecture 26: Streaming Business – Customers

Lecture 27: Streaming Business – Sales & Margin

Lecture 28: Streaming Business – Capex

Lecture 29: Streaming Business – Head Office Costs

Lecture 30: Streaming Business – P&L

Lecture 31: Streaming Business – Working Capital & Debt

Lecture 32: Streaming Business – CF

Chapter 4: SaaS

Lecture 1: Introduction to SaaS

Lecture 2: Examples of SaaS businesses

Lecture 3: Logic flow of customers in SaaS

Lecture 4: Main KPIs for SaaS

Lecture 5: Main challenges in SaaS

Lecture 6: SaaS financial model – Basic Version

Chapter 5: Customer Acquisition

Lecture 1: Customer Acquisition – Introduction

Lecture 2: Customer Acquisition – Definition

Lecture 3: Cost reduction framework

Lecture 4: How to lower Customer Acquisition

Lecture 5: Customer Lifetime Value (LTV)

Lecture 6: How to increase LTV – Examples

Lecture 7: How to increase LTV – General Framework

Lecture 8: Payback Time

Chapter 6: Switching to Subscription Model

Lecture 1: Switching to Subscription Model – Introduction

Lecture 2: Examples of firms that have switched to subscription

Lecture 3: From SMCG to service – Introduction – Part 1

Lecture 4: From SMCG to service – Introduction – Part 2

Lecture 5: From SMCG to service – Case Introduction

Lecture 6: From SMCG to service – If sold as a product

Lecture 7: From SMCG to service – If sold as a service – Part 1

Lecture 8: From SMCG to service – If sold as a service – Part 2

Lecture 9: From SMCG to service – Comparison

Lecture 10: From SMCG to service – Solution in Power Point

Lecture 11: Modeling SMCG business model as a service business – General Remarks

Lecture 12: Modeling SMCG business model as a service business – Head Office costs

Lecture 13: Modeling SMCG business model as a service business – Profit & Loss

Chapter 7: Conclusions

Lecture 1: Bonus Lecture

Instructors

Asen Gyczew
Expert in performance improvement, turnaround and startups

Rating Distribution

1 stars: 0 votes
2 stars: 1 votes
3 stars: 4 votes
4 stars: 9 votes
5 stars: 27 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu