skip to Main Content

BCG Matrix Template

Rated 0 out of 5
(be the first to review)

BCG Matrix Excel Template demonstrates the strength of the products in your portfolio with market growth rate and relative market share analysis.

Learn more about License Types

Buy Modifiable Version Buy Modifiable Version
PRODUCT DESCRIPTION

The BCG Matrix is a framework that helps to assess the value of investments in the company’s portfolio management. It was created in 1968 by Boston Consulting Group founder, Bruce Henderson.

This BCG Matrix Excel Template has been constructed by four quadrants which are Stars, Question Marks, Cash Cow and Poor Dog and each of them represents the different analysis of market growth rate and relative market share.

BCG-Matrix-Excel-Template-S01

It helps to company to understand which product the company should invest in, and which ones should be divested.

BCG Matrix Template Features:

List down all the products that you wanted to show on the matrix. If you enter brands market share and the largest competitor’s market share then the Relative Market Share column will be calculated automatically.

Once you finished the input the data in these 6 columns, it will be automatically displayed in Numerical Visualization and original BCG matrix. You can comment about what should Brand do as the next step, according to product position by helping with the explanations of the BCG Matrix.

Cash Cows: Companies should milk these “cash cows” to induce growth and to maintain their market share. The market growth rate is low, the relative market share is high.

Stars: Companies should significantly invest in these “stars” as they have high future potential to become a cash cow. The market growth rate is high, the relative market share is high.

Question Marks: Companies should invest in “question marks” depending on their chances of becoming stars on the other side discard or sell if it does not have any chance. The market growth rate is high, the relative market share is low.

Poor Dogs: Companies should liquidate, divest, or retrench these “poor dogs”. The market growth rate is low, the relative market share is low.

Features Summary:

  • Evaluates balance in your companies’ current portfolio
  • Easy to fill Data Section
  • Full Print Ready
  • Informational notes included
  • No installation needed. Ready to use.
  • Works both on Mac and Windows
  • Compatible with Excel 2007 and later versions
  • Does not include any VBA macros

This BCG Matrix Excel template is ready-to-use and provided as is. If you need customization on your reports or in need of more complex templates, please refer to our custom services.

USER REVIEWS

Reviews

There are no reviews yet.


Leave a customer review

Your email address will not be published. Required fields are marked *

Microsoft Excel® is registered trademark of Microsoft Corporation. Someka Excel Solutions is an active member of Microsoft Partner Network (MPN).

Someka SSL Certificate Icon
someka-microsoft-partner-badge-image

Someka Excel Solutions Ltd. Co.
© 2015-2019 All rights reserved.

Someka Bilişim Teknolojileri Ltd. Şti.   |   Address: Mansuroğlu Mah. 286/3 Sk. No:14B Bayraklı Tower 35030 BAYRAKLI / İZMİR   |   Tel: +90 (0232) 700 1883   |   info@someka.net