Download risk calculation sheet with four risk types updated for

Supplemental Material: How to Create a Risk Heatmap in Excel – Part 2

Instructions

You must complete the risk calculation sheet
Download risk calculation sheet first then score your risks based on factors you researched about the organization.

Review news articles and other online materials regarding the organization
Update the risk calculation sheet

Download risk calculation sheet with four risk types updated for impact. The likelihood scores will remain as provided.

Using the risk log
Download risk log（risk register file）, score your risks based on external and internal factors as well as information on the competition, which you found in news articles and materials about the organization.

Once scored, develop your risk heat map using excel.

 Develop a chart that takes the values of likelihood on the “X” axes and “Y” for values of Impact.

 Do NOT use 1 to 10 as your values are not 1 to 10.

 You must reflect what is in the risk calculation sheet.

Plot your scores in relation to the total risk score in a risk heat map.

Once plotted, document the high, medium and low thresholds. 

These ranges will then be carried over to the heat map in terms of red = high, medium = yellow and low = green.