Contract Analysis

Understand how to use the Contract Analysis screens in Tide

Overview

The Contract Analysis button can be selected from the top right of the Contract screen. This opens the Contract Analysis screen, with tabs for each analysis screen. 

Standard permissions apply to these screens. For example, if you are only associated with one Section of a Contract, then you will only be able to view that Sections data in these screens.

In all analysis screens, you can select different Section(s) of the Contract in the top right of the screen where the Contract Currency of the Contract is also displayed.

Estimated Premium Income (EPI)

The EPI screen provides analysis on the Contract’s performance against EPI.

There are two views: the chart view (displayed by default), and the grid view, which can be selected using the switch above the chart.

The Period Basis drop down gives you the option to display data based on Bordereau reporting periods or Risk Inception Date.

If Bordereau Period is selected the EPI chart will present Written Gross Premium data based on the bordereau period within which it is reported. If multiple Section(s) are selected, then an aggregate value is presented.

If Risk Inception Date is selected the EPI chart will present approved Written Gross Premium data based on the Inception Date of the risks processed.

You can also choose to select one or many of the previous Contract YOAs for which they are associated. Previous Contract is a multi-select drop down field where you can select none, one, or many of the previous Contract Year of Accounts.

The chart displays the following lines:

  • Straight Line EPI – this is EPI, evenly spread over the Contract period
  • GPIL – the Gross Premium Income Limit of the Contract
  • GPIL Notification Level – the notification level of the GPIL of the Contract
  • Gross Premium – a solid green line represents the actual Gross Written Premium received from Approved Risk (or Risk & Premium) Bordereaux, and the continuing dotted green line represents the projected premium if it were to continue to be received at the same rate.
  • Previous Contract – the Gross Written Premium of the previous Contract(s) (assuming there is at least one Approved Bordereaux, and you have permissions to view that Contract). Up to 5 previous Years of Account can be displayed, distinguished by different colours.

The grid displays the following columns:

  • Period & Section – there are rows for each Period by Section, and a total of all Sections per Period. At the top of the grid are rows for All Periods by Section and a total of All Periods for all Sections.
  • Gross Premium – the received Written Gross Premium from Approved Risk (or Risk & Premium) Bordereaux
  • EPI – EPI is spread evenly across Periods of the Contract
  • Gross Premium vs EPI

Loss Ratio

The Loss Ratio screen enables you to view the Loss Ratio and other key statistics by any selected risk characteristic. 

You can select up to 3 Tide fields (excluding financial and decimal fields) in the drop down, and the grid will update group rows by each unique value. For example, you could select Risk State, and the grid will then display a row for each unique Risk State in the Contract.

The grid displays the following columns for each row:

  • Risk Count - The total number of risks that relate to the value of the row.
  • Gross Premium - The total Gross Premium of the returned Risks.
  • Final Net Premium - The total Final Net Premium of the returned Risks.
  • Earned Gross Premium - The total Gross Premium that has been earned of the returned Risks, where earned is the percentage of total underlying policy period days that have passed multiplied by the Gross Premium. This cannot exceed 100% of Gross Premium.
  • Earned Final Net Premium - The total Final Net Premium that has been earned of the returned Risks, where earned is the percentage of total underlying policy period days that have passed multiplied by the Final Net Premium. This cannot exceed 100% of Final Net Premium.
  • Total Sums Insured - The total Total Sums Insured of the returned Risks.
  • Average Rate - The average premium rate of the returned Risks.
  • Total Incurred - The total Total Incurred of the returned Risks.
  • Gross Loss Ratio - The Loss Ratio of the returned Risks, using Gross Premium.
  • Final Net Loss Ratio - The Loss Ratio of the returned Risks, using Final Net Premium.

When calculating the Loss Ratio, if the Claim does not have a Sub-Risk Identifier and the Risk does have a Sub-Risk Identifier, then the Total Incurred is to be evenly split across the Risks matched based on Risk Reference.

You have the option to download data presented in the Loss Ratio grid as an Excel file by selecting the Export button.

Was this article helpful?

Can't find what you're looking for?

Contact Support