Calculate the SAP liabilities. (Modeled on 2016.Spring #15b) (shout-out to GS!)

0.000

liabilities (year-end) |

item | CY/AY-1 | CY/AY |

unpaid loss: Case direct & assumed | ||

unpaid loss: Case ceded | ||

unpaid loss: Bulk & IBNR direct & assumed | ||

unpaid loss: Bulk & IBNR ceded | ||

unpaid DCC: Case direct & assumed | ||

unpaid DCC: Case ceded | ||

unpaid DCC: Bulk & IBNR direct & assumed | ||

unpaid DCC: Bulk & IBNR ceded | ||

unpaid A&O: direct & assumed | ||

unpaid A&O: ceded | ||

anticipated salvage & subrogation | ||

net UEP |

For direct & assumed unpaid loss & DCC:

==> sum(AY-1, AY) for Case, Bulk & IBNR

==> sum(AY-1, AY) for Case, Bulk & IBNR

For ceded unpaid loss & DCC:

==> subtract sum(AY-1, AY) for Case, Bulk & IBNR

==> subtract sum(AY-1, AY) for Case, Bulk & IBNR

For direct & assumed unpaid A&O:

==> sum(AY-1, AY) for__Case only__

==> sum(AY-1, AY) for

For ceded unpaid A&O:

==> subtract sum(AY-1, AY) for__Case only__

==> subtract sum(AY-1, AY) for

Add current year net UEP

= (Step 1) – (Step 2) + (Step 3) – (Step 4) + (Step 5)

liabilities |

Step 1 | |

Step 2 | |

Step 3 | |

Step 4 | |

Step 5 |