Reinsurance Loss Outputs#

The reinsurance calculations generates estimates of retention and cession under the different reinsurance treaties. The following output files are produced:

  1. Reinsurance by event: aggregated estimated per event for the claim, retention, cession and overspills under each reinsurance treaty.

    event_id

    retention

    claim

    treaty_1

    treaty_2

    xlr1

    overspill_treaty_2

    year

    0

    738.429

    1833.73

    142.206

    400.000

    553.096

    180.819

    1

    1

    319.755

    701.219

    51.7092

    179.292

    150.463

    0.00000

    1

    2

    1226.97

    3210.91

    282.622

    400.000

    1301.32

    474.357

    1

    3

    1318.88

    3600.81

    294.502

    400.000

    1587.42

    629.187

    1

  2. Reinsurance curves: reinsurance loss exceedance curves describe the probabilities of exceeding a set of loss ratios or loss values, within a given time span (or investigation interval). The curves are generated for the claim, retention, cession and overspills under each reinsurance treaty.

    rlz_id

    return_period

    retention

    claim

    treaty_1

    treaty_2

    xlr1

    overspill_treaty_2

    0

    50.0000

    319.755

    701.219

    51.7092

    179.292

    150.463

    0.00000

    0

    100.000

    1226.97

    3210.91

    282.622

    400.000

    1301.32

    474.357

    0

    200.000

    1318.88

    3600.81

    294.502

    400.000

    1587.42

    629.187

  3. Average reinsurance losses: the average reinsurance losses indicates the expected value within the time period specified by risk_investigation_time for the claim, retention, and cessions under each reinsurance treaty for all policies in the Exposure Model.

    rlz_id

    retention

    claim

    treaty_1

    treaty_2

    xlr1

    overspill_treaty_2

    0

    1.80202E+01

    4.67333E+01

    3.85520E+00

    6.89646E+00

    1.79615E+01

    6.42181E+00

  4. Aggregated reinsurance by policy: the average reinsurance losses for each policy, by ignoring the overspill logic.

    rlz_id

    policy_id

    retention

    claim

    treaty_1

    treaty_2

    xlr1

    0

    p1_a1

    4.61304

    19.0934

    1.90934

    3.81867

    8.75232

    0

    p1_a2

    3.01643

    6.48621

    1.94586

    0.648621

    0.875298

    0

    p1_a3

    38.9468

    1.29823

    0.00000

    0.908759

    0.00000

    0

    p2

    3.57945

    19.8555

    0.00000

    7.94221

    8.33388

The parameters indicated in the previous outputs include:

  • policy: identifier of the unique policies indicated in the exposure model and policy files.

  • claim: ground up losses minus the deductible and up to the policy liability.

  • retention: net losses that the insurance company keeps for its own account.

  • cession_i: net losses that are ceded by the insurance company to the reinsurer(s) under treaty i. The cession is indicated by the treaty name defined in the reinsurance information.

  • overspill_treaty_i: net losses that exceed the maximum cession per event (“max_cession_event”) for proportional and/or catxl treaties.

NOTE: The sum of the claim is not equal to the ground up losses, since usually the deductible is nonzero. Moreover there could be “non-insured” losses corresponding to policies with no insurance contracts or that exceed the policy liability.