## How to create a BCG Matrix in Excel (video)

In this video, you will learn how to make a BCG matrix on Excel from start to finish. Alternatively there is a free Excel template available for download on this site that automates the process for you.

## When to use the BCG Matrix?

The BCG matrix is often included in strategy and marketing textbooks. It is often presented because it is a very simple model for students to understand and highlights the relationship between competitive strengths and market opportunities – which is a fundamental aspect of strategy development. However the model was developed in 1968 primarily for the …

## BCG matrix formulas and calculations

There are relatively few calculations required in order to construct effective BCG matrix. Probably the most difficult decision is to define the market – as there are often numerous ways of defining the market, as is further discussed below. In terms of constructing the BCG matrix after the market definition, there are two calculations required, …

## Benefits of the BCG matrix

Introduction to the BCG matrix The BCG matrix was developed by the Boston Consulting Group in 1968. It is a portfolio matrix tool and is designed for larger companies to map, compare and analyze their existing business divisions (strategic business units) or sets of products. The Boston Consulting Group matrix is also known as the …

## Good and poor BCG matrix portfolios

Using the BCG matrix for portfolio analysis One of the prime uses of the BCG matrix is for portfolio analysis – that is, to ensure that the overall company has an appropriate mix of business units and/or product in its overall portfolio. In this article on the BCG matrix and portfolio analysis, both good and …

## BCG Matrix Theory

The BCG Matrix is a relatively simple portfolio model. In this theory section of the website, you’ll find an array of information on the BCG Matrix that is designed to help you understand theory and basic concepts. Perhaps surprisingly, although relatively simple in concept and design, the BCG Matrix can deliver a significant amount of …

## Free Excel Template of the BCG Matrix

Download the Free Excel template for the BCG Matrix The BCG Matrix was developed many years ago to help large corporations make investment decisions in regards to their business portfolios and brands. It is a concept that is included in many modern-day marketing and strategy textbooks. The Marketing Study Guide offers a free BCG Matrix Excel template …

Scroll to Top