MR_button_ruin.bmp Ruin Calculation

MR_dice_icon.jpg Download a complete copy of this risk analysis resource for free here.

See also: ModelRisk functions and windows, Vose Depletion

image1101.gif

 

Introduction


The Ruin Calculation window
from ModelRisk 2.0

The Ruin Calculation models scenarios for the cash flow that comes with an insurance policy: the available funds are decreased by payment events of random size that occur randomly in time, and increased by selling policies of fixed size.

A time horizon is set, and Ruin Calculation models wether or not we have a Ruin (i.e. funds dropping below zero within the time horizon).

A dividend threshold can be set. When the budget exceeds this threshold, a dividend is paid out, and the available funds remain at the same threshold level.

The discount rate at which the value of the funds decreases over time can be set. This discount rate is taken into account when calculating the Net Present Value (NPV) of the policy in this scenario (i.e. the total dividend we have).

To see the output functions of this window, click here .

Window elements

In the Source data region, you can set the following quantities, as described above:

The graph displays the time (horizontal axis), fund level (left vertical axis), dividends paid (right vertical axis), dividend threshold (horizontal red line), fund level at every point in time (black curve with dots for every funds-altering event) and time horizon (green vertical line).

For explanations about other fields, buttons, graphs and summary statistics tables in this window, see Common elements of ModelRisk windows.

Useful tips and tricks

See also: Graphics, workflow and error handling in ModelRisk

Using View Function to return to a window

The output of ModelRisk windows always corresponds to VoseFunctions (the functions ModelRisk adds to Excel) being entered into one or more spreadsheet cells.

You can always re-open the window for a ModelRisk function that is in a spreadsheet cell by using View Function. Select the spreadsheet cell and then select View Function from the ModelRisk menu/toolbar/ribbon.