skip to Main Content

BCG Matrix Excel Template

4.2 (5 reviews)

Excel spreadsheet for BCG charts. Draw growth vs. share matrix in seconds. Data visualization with dynamic dashboard for your presentations.

Learn more about License Types


Someka refunds icon

30-Days
Return

Someka one time payment icon

One-Time
Payment

Someka direct download icon

Instant
Download

TEMPLATE DESCRIPTION

The BCG Matrix, created in 1968 by Boston Consulting Group founder, Bruce Henderson, is a framework that helps to assess the value of investments in portfolio management. So, this BCG Matrix Excel Template includes four quadrants which are Stars, Question Marks, Cash Cow and Poor Dog.

Basically, each of these quadrants represents a different analysis of market growth rate and relative market share.

BCG-Matrix-Star-Question-Cashcow-Dog

In particular, this tool helps to understand which products the company should invest in, and which ones should be divested.

BCG Matrix Excel Template Features:

Firstly, list down all the products that you wanted to show on the matrix. Moreover, if you enter the brand’s market share and the largest competitor’s market share then it calculates the Relative Market Share column automatically.

Once you finished the input the data in these 6 columns, it will be automatically displayed in Numerical Visualization and the original BCG matrix. Additionally, 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 in this BCG Matrix area.

Features Summary:

  • Evaluates the balance in your company’s 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

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

PRODUCT VIDEO

Watch the video below to see the template in action! Presentantation also includes usage notes, explanations and tips & tricks about the template.

FREQUENTLY ASKED QUESTIONS

USER REVIEWS & COMMENTS

5 reviews for BCG Matrix Excel Template

  1. Peter S.

    That is an excellent solution based on Excel. It is nearly as good as the online tool fancy bcg matrix, which I slightly prefer since it is a bit cheaper and somewhat I have an Excel phobia :-).

  2. Charlie

    I have download the template and have been using it for a while. I was searching this bcg matrix for my project. But, most of them just show the matrix for making a comment about the position of the brand, I mean only the graph on the right. But, this tool also provides me a numerical table to play with numbers to see the results. I purchased to modifiable to enlarge the scale of the graphs. It is useful and visually satisfying. Thanks guys!

    • Someka

      Hi Charlie,

      Thanks a lot for the time to spare to write this review!
      For further questions and comments please do not hesitate to contact us.

      Best regards,

  3. Jeff m.

    Visually greatttt. I am not a professional Excel user but I easily figured out how I can use this spreadsheet. Thanks for the product video suggestion.

    • Someka

      Hi Jeff,
      Thanks a lot for your comments! We are preparing product videos and detailed product descriptions for our customers. We hope these are helpful to you!

      Regards,

  4. Pietro

    As a former BCG employee, I find it does not capture the richness of the BCG framework. E.g.: the horizontal scale is linear (i.e. an RMS of 0.5 is distant from 1 as 1.5 from 2) while it should be a log, comparing directly the ratios. Guess bubbles have the same distortion…

    • Someka

      Hi Pietro,
      First of all, thanks a lot for your valuable comments! We will direct your comments to our developer team. If this is necessary to update the template, we will do it asap.
      Thanks again!
      Regards,

  5. Bit Kang

    Everything is really good. Thanks, guys.
    But There have problem if the Market growth are over 10% they not showed in the BCG matrix chart
    How can I make it show on it?

    • Someka

      Hi Bit,
      Thanks a lot for your time to spent writing a comment on our templates.

      While we are creating the BCG Matrix template, we tried to create an optimized chart. Otherwise, there is not a limit to enlarging the chart to being enough to show.
      With the modifiable version of the template, you can rearrange the limit of both horizontal and vertical axis. In that way, you will be able to show larger Market Growths on the matrix.

      If you have further questions please do not hesitate to contact us anytime!

      Regards,

Leave a customer review

Only verified users who have downloaded and used the template may leave a review.

RELATED TEMPLATES