How to Use the Free BCG Matrix Template

Using the Free BCG Matrix Excel Template This page contains instructions and a video on how to use the free BCG Matrix Excel template available for download on this website. Here is a how-to-use video for the free BCG Matrix, and please scroll down for the written step-by-step instructions. How to Use the BCG Matrix … Read more…

Free GE Matrix Excel Template

GE-McKinsey Matrix Excel Template The GE matrix is now officially known as the GE-McKinsey nine-box matrix. According to the McKinsey website, the framework “offers a systematic approach for the multibusiness corporation to prioritize its investments among its business units. It was developed in the 1970s, after the development of the Boston Consulting Group (BCG) matrix. … Read more…

Free Excel Matrix Template

About the Matrix Maker A matrix demonstrates the relationships between two attributes in a visual graph format, similar to a scatter-plot chart. However, it is often time-consuming for someone new to Excel to construct a matrix, as the chart needs a reasonable amount of formatting. That’s why have developed a free Excel matrix template for … Read more…

BCG Matrix Formulas

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, … Read more…

Market share in the BCG Matrix

Quick Overview of the BCG Matrix For those people familiar with the BCG matrix, you should recall that the horizontal axis measures relative market share. This is the more important of the two dimensions. A high or low relative market share makes the difference between a cash cow and a dog or a star and … Read more…

Modern Day Design of the BCG Matrix

  It should be remembered that the economic conditions and key business goals have changed substantially since the BCG matrix was initially developed in the late 1960s. As a result, a slight redesign of the matrix is probably required to make it more usable and logical to today’s business world. Design of the X axis/relative … Read more…

BCG Matrix example for a Retailer

BCG Matrix example In this example, a retailer with five business portfolios is considered. Their five portfolios include: A chain of supermarkets A set of department stores A convenience store chain A range of specialist fashion stores and A chain of juice bars As you can see from the BCG matrix, the firm has: One … Read more…