Wehrspohn Risk Management

Part 2: From Risk Inventory to Risk-Bearing Capacity: ERM in Excel

October 13, 2025

Part 2: From Risk Inventory to Risk-Bearing Capacity: ERM in Excel In the last post, I described why risk managers can barely experiment anymore in productive ERM systems. This is exactly where Risk Kit comes in: as a methodologically sound, transparent, and at the same time flexible development environment. Risk Kit includes a fully developed case study on Enterprise Risk Management (ERM). It shows step by step how an entire ERM process can be mapped directly in Excel, from the risk inventory through aggregation to the risk-bearing capacity calculation. The template covers all the central elements of integrated risk management: • Assessment using expert judgment or mathematical models • Risk aggregation and action tracking • Risk-bearing capacity, risk maps, and sensitivity analyses • Intermediate aggregates for sub-portfolios or business units But the real value lies deeper: This template is not a simple example, but a development environment in which risk managers can test hypotheses, change assumptions, and try out new methods, free from the constraints of a production system. This is how risk management becomes what it should be again: an active, learning process that creates transparency and lays the groundwork for well-founded decisions. Ideal for anyone who wants to not just administer ERM in their company but develop it further, or who wants to introduce themselves and colleagues to the topic in a hands-on way. You'll find the download link in the first comment. #ERM #RiskManagement #RiskKit #Simulation #RiskBearingCapacity #GRC #Excel

View image

This post was originally published on LinkedIn. View and join the discussion there