BCG Matrix Template Excel
The BCG Matrix Template, also known as the Boston Consulting Group BCG Growth Share Matrix Template, the BCG Model, BCG Chart or the Boston Consulting Group Diagram, is available for MS-Excel and MS-Word. The BCG matrix is widely used to perform business portfolio analysis as one of the steps in strategic planning process. Get a FREE copy of our Strategic Planning Workbook with each copy of this Excel version of the BCG Matrix.
The BCG Growth-Share matrix maps the business units (or products) on the basis of their relative market shares and market growth rates. The framework assumes that (a) an increase in relative market share will result in an increase in the generation of cash; (b) a growing market requires cash investment to respond to the market growth.
Using the Market Growth Rate and Relative Market Share axes the BCG matrix template plots a four-cell chart. The four cells are:
Cash cows are units with high market share in a slow-growing industry. These units typically generate cash in excess of the amount of cash needed to maintain the business. As the markets are mature new competitors do not enter and many of the weaker existing competitors withdraw from what they see as an unattractive market with little growth prospects. The “cash cows” tend to become dominant suppliers and get good cash returns with very little investment being required to maintain market share.
Dogs, refer to business units/products with low market share in a mature, slow-growing industry. These units typically are cash traps with money tied up in a business that has little future potential. They also tend to depress the overall return on assets. The disposal of Dogs can generate cash to invest in more attractive sectors.
Question marks tend to pose an investment dilemma in that they are potentially attractive in that because they are in a high growth market they have the possibility to be turned into “Stars”. Because of their high growth rate and the need to increase market share they typically require significant cash investment. Being high growth sectors they will frequently be very competitive and may already have some “Stars”. Question marks must be analyzed carefully in order to determine whether they are worth the investment required to grow market share.
Stars are business units/products with a high market share in a fast-growing sector. Market leadership generates significant cash, but considerable ongoing cash investment is required to maintain that market leadership. The hope is that “Stars” become the next “Cash Cows”. If market leadership is maintained, then as the market matures and growth slows down, the “Stars” become “Cash Cows” and generate significant cash and a high return on assets.
The overall objective of the analysis is to help executives to decide which of their business units/products to fund, and business units/products to dispose of. The result is a balanced portfolio of high growth and cash generating lower growth units/products with the appropriate risk and reward profile.
The Boston Consulting Group (BCG) Matrix template can be used in conjunction with, or as an alternative to, other strategic planning tools such as Business SWOT Analysis and GE/McKinsey Nine Cell Matrix template in basic strategic planning and analysis.
The BCG Matrix Template uses the standard MS-Excel bubble chart format and can be easily modified and customised by anybody with basic Excel skills. The size of the individual bubbles show the relative market sizes.
Check out the Excel Boston Consulting Group BCG Matrix Templates User Guide before purchasing!
We also provide GE McKinsey Matrix templates which you can use to generate a GE McKinsey Matrix to depict the result of a business portfolio analysis. Our SWOT Matrix Templates can be used to generate the results of a SWOT analysis. Excel and Word templates for the Ansoff Product/Market Matrix are also available.
Order the individual MS-Word or Excel BCG matrix template that you require or alternatively order both templates and get 25% discount or order the package our Strategic Planning Package (includes SWOT, BCG and GE-McKinsey templates) and get up to 50% discount!
All your purchases come with a "No quibble MONEY BACK GUARANTEE"