A model that illustrates how the Time Series Fit feature can be used on a series with trend and seasonality.
A model that illustrates how the Time Series Fit feature can be used on a series with trend and seasonality.
A set of examples to illustrate how a copula can be fit to bivariate data.
A model that illustrates the Time Series Fit and Batch Fit features for fitting multiple correlated stock price series.
Unlike other @RISK distribution function such as RiskNormal and RiskBinomial, the RiskCompound function is not used to generate random values from a specific distribution. It is used to generate a sum of random values from a given distribution, where the number of terms in the sum can be a fixed integer or a random integer from some discrete distribution. This example illustrates how the RiskCompound function can be used.
This model illustrates a projection of property damages and human costs from potential natural disasters over a 5-year period that might be assessed by an insurance company. It assumes that each disaster either occurs or doesn't occur in a given year with given probabilities. Then possible property damages and possible human costs are simulated. In each of these, assuming that a disaster occurs, the total damage or cost is composed of the random number of people affected and the damage or cost per person affected._x000D_
This model uses @RISK to run a discrete-event simulation of insurance claims through time. It assumes that a company starts with an initial number of customers and an initial amount of cash. There are three types of events, and the times between each are assumed to be exponentially distributed. A type 1 event is when a customer makes a claim for a random amount, a type 2 event is when a current customer leaves the company, and a type 3 event is when a new customer joins the company. All of the company's customers pay a premium at a given daily rate.
This model enables an insurance company to analyze the possibility of being reinsured. Without reinsurance, the company pays all claims, net of deductibles, for its policy holders. With reinsurance, it pays a fixed premium to another insurance company, the reinsurer. There is a reinsurance deductible. If the company's liability for all claims, net of deductibles, is less than this deductible, the company is liable for all of it. However, if this liability is greater than the reinsurance deductible, the company is liable only for the deductible; the reinsurer pays the rest._x000D_
This model contains a portfolio of potential claims of different types. Each claim has different parameters for the distributions of frequency, severity, and duration. The model illustrates a powerful feature of the RISKCOMPOUND function: the argument that corresponds to the severity can be a reference to a cell containing a formula, rather than just a single distribution function.
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.
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 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.
A model for evaluating a contingent contract, where a penalty must be paid if a target is not met.
How can we help you? Contact us.