Please help me finish the BCG Matrix. I'm stuck on the last part for the Division Market Growth rate.
"Enter in the industry growth rate (IGR) for each division.Generally, taking the top 2 or 3 rivals for each division (along with your firm), adding their numbers together for the current year and the previous year and using the equation (Current Year - Previous Year) / Previous Year is sufficient to estimate guess of the industry growth rate. This is because generally the top 3 players dominate an industry. Note, using this process also weights larger firms more, which is exactly what you desire. Do not use total revenues; instead, use divisional revenues. Division industry growth rates (IGR) must be between -0.20 and 0.20.If outside these ranges, simply use -0.20 or 0.20 and mention during your presentation."
AutoSave . Off) H GE Strategic Planning Template update - Excel Jean Pierre Rullier X File Home Insert Page Layout Formulas Data Review View Help 9 Search Share Comments & Cut Times New Roman ~ 11 ~ A" A ap Wrap Text General _ AutoSum Fill AY O 4 Paste [ Copy Format Painter BIU SAY FEE FEE Merge & Center $ ~ % 9 08 20 Conditional Format as Cell Insert Delete Format Sort & Find & Ideas Formatting * Table Styles v Clear Filter ~ Select Clipboard Font Alignment Number Styles Cells Editing Ideas B144 X V fx A B C D E F G H K L Click The Blue Buttons Below to Navigate Part 1 More Efficiently Strengths Weaknesses Opportunities Threats CPM BCG Matrix HOME IE Matrix SPACE Matrix Perceptual Maps GRAND SWOT QSPM 5 Everything is calculated and positioned for you (Other than Industry Growth Rate in Step 4) including the Relative BCG Market Share Position (RMSP). The BCG matrix in this Template does not produce pie slices to show profits. You may 141 wish to discuss divisional profits in your presentation. 142 Top Firm in Division Market Relative Enter in division names below (If less than 5, leave the other spaces blank and no circles will appear) GE's Industry Division Division Growth Rate Market Share 143 Revenues Revenues Step 4) Position 144 145 Gas & Power $18,625 $20,692 0.90 146 Renewable Energy $15,337 $17,836 0.86 147 Aviation / Transportation $32,875 $32,875 1.00 148 Healthcare $19,942 $19,942 1.00 149 NA 150 151 BCG 152 PARTI PART II IFE EFE CPM BCG IE SPACE Perceptual Map GRAND SWOT QSPM Financial Statements Company Valuation EPS_EBIT | Retained Earnings Table Pr ... (+ Ready + 110% 12:50 PM Type here to search O 9 A D ( ()) ENG 10/17/2020
