SWOT-Risk Analysis template

The spreadsheet has been designed for users to do a SWOT Analysis with quantified, risk-based results.

The methodology used on this template are as follow:

1. In broad terms, the assessment system used to analyse enterprise risks will be applied.

EXTERNAL

2. Identify Opportunities, Strengths, Threats and Weaknesses.

3. Assess each element identified on a scale of 10-1; with "10" being extremely high, and "1" being insignificant.

4. Consider the likelihood that an identified opportunity or threat may mature (remember, on a scale of 10-1).

5. Consider the impact on the business's profitability if the identified opportunity or threat mature (10-1).

INTERNAL

In the case of Strengths and Weaknesses, assess your business’s internal capacity, using the following assessment criteria:

6. If a Strength, how much (10-1) does it impact on the likelihood of pursuing an opportunities effectively, and how would you rate the impact of the Strength on the capacity of the business to pursue its objectives?

7. If a Weaknesses, how much (10-1) does it impact on the likelihood of not being able to pursue an opportunities effectively, and how would you rate the destructive impact of the Weakness on the capacity of the business to pursue its objectives?

In this spreadsheet,

1- cells coloured in shades of grey contains formulas or statistic data and are closed (cannot be changed by users).

2- Type in the cells that are white coloured. (Note that all text and data captured in this cells are replacement text only. Please erase or replace as required by your own requirements).

3- Type on headings for more guidelines about the contents of cells.