@RISK is widely used in insurance and reinsurance for premium pricing and loss reserves modeling. A 2006 survey identified @RISK as the third most widely-used software by actuaries, after Microsoft Office and in-house actuarial tools. Download and install a free trial version of @RISK to view the models in full.

» Ver todos os estudos de caso seguro/resseguro.

RiskCompound para Combinar Distribuições
Quando estamos construindo modelos de frequência-severidade no Excel (por exemplo para modelagem de seguros), o @RISK 4.5 e anteriores eram limitados pela estrutura das planilhas, o que em alguns casos resultava em modelos que eram estruturalmente inflexíveis quando vlaores de parâmetros eram alterados ou era necessário o uso de macros em VBA. O @RISK agora contém uma função RiskCompound que permite a criação de modelos de frequência-severidade. O exemplo a seguir usa uma distribuição Poisson para frequência e uma Lognormal para severidade (Distribuições Pareto ou Exponenciais também são usadas para severidade usualmente).

Baixar do modelo-exemplo: RiskCompound.xls

Stress Testing Insurance Claims
This example shows how you might model the uncertainty involved in payment of insurance claims. To model this properly, you must account for the uncertainty in both the total number of claims and the dollar amounts of each claim made. This is done using the RiskCompound function.

Suppose that the company is required by law to have enough money on hand to pay all the claims with the probability of 95%, and that it can only set aside $2000 for the purposes of this particular insurance product. On the other hand, a simulation of the model shows that the 95th percentile of the Total Payment Amount is around $2700. Assume further that the company can purchase from a larger company an insurance policy against the number of claims being in the top decile. The policy under consideration specifies that if the number of claims falls within the top decile, the larger company will satisfy all the claims. The smaller company can model the situation with the policy in place by using Stress Analysis to stress the distribution for total number of claims from the 0th to 90th percentile. With the modified distribution the 95th percentile of the Total Payment Amount is reduced to around $1650. If the policy costs up to $350, the smaller company can purchase it and keep $1650 on hand to comply with the law.

Would the larger company be willing to sell the policy for under $350? There is a 10% probability that it will be required to make payments under the policy. The payments can be analyzed using the same model and stressing the distribution for total number of claims from the 90th to 100th percentile. This analysis shows the mean payment to be around $2800. Since there is only a 10% probability that claims will need to be satisfied, the mean cost to the larger company is around $280. Hence, it does not seem unreasonable for the larger company to sell the policy for $350.

Example model: ClaimsStress.xls (model coming soon)

Event and Operational Risks
In many circumstances one wishes to calculate the aggregate impact of many possible yes/no type events. For example, it is often important to answer questions such as "What is the loss amount that will not be exceeded in 95% of cases?" Simulation is usually required to answer such questions. In this model, the "yes/no" events are modeled using Binomial distributions. The results profile shows a multi-peaked distribution, which is typical when there are discrete-type inputs. It can be seen that a provision level of around $700,000 is necessary to cover 95% of the cases.

Possible generalizations to this model that could be made (and which are explored in more detail on Palisade training courses) include:

a) Assessing the impact of changing the loss resulting from each event into a distribution, rather than assuming a fixed amount.

b) Assessing the impact if mitigating actions could be developed for certain events, so that, e.g., the amount of loss were reduced if these events occur (or the probabilities of events are reduced or both).

c) Creating dependencies or correlations between the occurrence (and/or magnitude) of some of the events.

d) Replacing the Binomial distribution with a Poisson distribution so that each event could occur more than once per period.

Example model: EventandOperationalRisks.xls

Claims Payouts with Correlations,
Fitting, and RiskCompound
This example models different types of insurance claims from different lines of business and sums them in order to calculate an estimated total claims paid out for the next year. It incorporates @RISK’s distribution fitting to define distribution functions for claim amounts, and illustrates the use of correlations to describe relationships between different types of claims. The RiskCompound function is used to combine frequency and severity of claims, simplifying the model.

Example model: ClaimsPayout.xls