Project Risk Management With a Risk Assessment Matrix
Budgets, deadlines, and deliverables create exposure even in well-run projects. A structured risk process helps you spot what could go wrong early enough to act. The workflow covered here has five stages: identify, assess, prioritize, respond, and monitor. A risk assessment matrix supports the assess and prioritize stages by turning a long list of concerns into a ranked set of actions.
What a risk assessment matrix does
A risk assessment matrix is a scoring grid that pairs two judgments for each potential problem: how serious it would be, and how likely it is to occur. The pairing produces an overall impact rating. That rating makes trade-offs visible, so the team can address the most consequential issues first instead of treating every concern as equally urgent.
Three scales do the work:
- Severity: Acceptable means little felt impact; Tolerable means the project will hurt but recover; Generally unacceptable means the project could be knocked seriously off course.
- Likelihood: Not likely means occurrence is remote; Possible means there is a decent chance; Probable means occurrence is expected.
- Risk impact: Low events are unlikely and not a serious threat; Medium events act as speed bumps that slow progress; High events can throw the project seriously off course without mitigation.
Keep the distinction clear: severity alone does not set priority, and likelihood alone does not either. Impact is the combined result, and it is the field to sort by.
Where the matrix earns its keep
Use the matrix in three practical situations:
- With clients: show in advance how risks will be handled, so expectations are set before surprises appear in deliverables.
- With the internal team: brief people on likely setbacks so they can anticipate problems rather than react to them.
- When resources are limited: direct time, money, and staff toward the highest-impact risks, since not every risk can be mitigated at once.
A quick decision check before you start: can you name the specific risk in one sentence, judge its worst credible outcome, and judge how likely that outcome is? If any of those is vague, refine the risk description first; scoring a vague item produces a vague priority.
Scoring and ranking risks in Excel
Work through the list in this order:
- Open the Risk Assessment List tab.
- Enter each potential risk in the Risk column, with as much specific detail as possible.
- Select a Severity option from the drop-down for each risk.
- Select a Likelihood option from the drop-down for each risk.
- Check the Risk Assessment Matrix tab and record the Risk Impact where the chosen severity and likelihood intersect.
- Sort the completed list from highest to lowest risk impact and build the mitigation plan starting at the top.
Worked example: a risk rated Acceptable for severity and Probable for likelihood lands in the Medium category. That result is a useful reminder that a low-severity issue can still deserve attention when it is very likely to happen, while a severe but remote issue may rank lower than intuition suggests.
Customizing and printing the matrix
The template works as-is, but you can adapt it to your project and brand:
- Title: double-click cell A-2, enter a new title, and format the header with standard text tools.
- Colors: highlight a cell, row, or column, then use Format > Cells > Fill and the Background Color drop-down to apply brand colors.
- Rows and columns: use Insert > Rows to add a row above the selection, or Insert > Columns to add a column to the left; both inherit formulas and formatting from the neighboring row or column. This is where you might add more graduated severity or likelihood options, or a column for areas affected.
- Removing items: select the row or column, then use Edit > Delete and choose Entire Row or Entire Column.
- Logo: right-click the header image in row 1, choose Change Picture, select your image file, and click Insert.
- Printing: drag to highlight the cells to print, set the print area with File > Print Area > Set Print Area, adjust scale under File > Page Setup > Page if you want a single page, then print with File > Print.
Keeping the assessment current
Risk management does not end when the matrix is scored. Revisit the list as the project changes: new risks enter, likelihoods shift, and mitigations change severity. Keeping the matrix current is what turns a one-time exercise into ongoing monitoring. For schedule-level visibility, pair the matrix with a Gantt chart template hub for planning across industries, or an Excel Gantt chart template when you want tasks and dates organized in a spreadsheet.
| Severity | Likelihood | Risk impact | What it means for priority |
|---|---|---|---|
| Acceptable | Probable | Medium | Likely but low-damage; mitigate after higher-impact items |
| Tolerable | Possible | Use matrix intersection | Check the intersecting cell rather than guessing |
| Generally unacceptable | Probable | High | Act first; can throw the project seriously off course |
Ratings use the three-level scales described above; the matrix intersection determines impact.
Frequently asked questions
How do severity and likelihood determine risk impact?
Severity asks how bad the outcome would be if it happens. Likelihood asks how probable that outcome is. Risk impact combines the two: find the severity column, follow it to the likelihood row, and the intersecting cell gives Low, Medium, or High. For example, Acceptable severity with Probable likelihood gives Medium impact.
What is the order for completing a risk assessment list?
List each specific risk, choose its severity and likelihood from the drop-downs, look up the combined impact on the matrix tab, then sort from highest to lowest impact and plan mitigation for the highest-impact items first.
When is a risk matrix most useful in a project?
Use the matrix to set expectations with clients by showing risks were planned for, brief the internal team so setbacks are anticipated, and focus limited time, money, and staff on the largest threats first.