| How to use this page: Modelling Team – Only complete the two (2) sections highlighted in Purple It is imperative that the relevant teams stick to completing their sections only and no existing data to questions be removed. This avoids confusion and important steps are not missed by other teams. Thank you for your assistance in advance. Any questions please refer to @Lyle De Groot @Robin Morris @Anjali Dharma-Wardana @Nadia Baptista |
| Underwriters to fill out the BEIGE sections only | |
| Underwriters to fill out the BEIGE sections only | |
| Description | Value |
| Programme Name | {{issue.summary}} |
| Date Created | {{now.format(“dd/MM/yyyy”)}} |
| Submission name | {{issue.customfield_10545}}_ {{now.format(“yyyyMMdd”)}} |
| Underwriter(s) | {{issue.customfield_10588}} |
| Capacity Provider(s) | {{issue.customfield_10293}} |
| Path to data files | <Path to Excel files> |
| YOA (Year of Account) | {{issue.customfield_10192}} |
| Deal Type | {{issue.customfield_10166}} |
| Submission Type | {{issue.customfield_10294}} |
| Cleansing Due Date | {{issue.customfield_10588}} |
| Modelling Due Date | {{issue.customfield_10149}} |
| Quote Due Date | {{issue.customfield_10162}} |
| Claims Basis | {{issue.customfield_10612}} |
| Reinsurance Structures | {{issue.customfield_10507}} |
| SPI | {{issue.customfield_10161}} |
| Ingest Instructions | ||
| Description | Value/Instructions | Examples |
| Section mapping | If one section leave empty. If multiple, give instruction on how to set sections. Examples:
if colname is ‘OM’ set section to ‘om’. sheet 2.4 is section ‘us’. Section names should not contain any special characters or spaces, and preferably match with the submission last year. |
|
| Premium column name | <colname> | |
| Aggregate limit column name | <colname> | |
| Other column mapping instructions |
Examples:
|
|
| Currency of the submission |
If all one currency, say which: USD, TRY etc. If mixed, give instruction. Examples:
|
|
| Quota share |
Give instruction on how quota share should be recorded or calculated. Examples:
|
|
| Direct coverage area exclusions | Yes/No | If yes, give instruction. Example:
[cmc, ce, lof] |
| Dependent coverage area exclusions | Yes/No | If yes, give instruction. Examples:
if section is ‘om’ exclude [cmc, ce, lof] if <colname> is ‘ABC’, exclude all except [cmc, ce, lof] |
| Tech E&O present? | Yes/No | If yes, give instruction. Examples:
tab 2.3 is all Tech E&O if <colname> = ‘erisk’, then row is blended tech and cyber. |
| Sections with excess policies | Yes/No | If all sections, say ‘all sections’, otherwise, write the section names that have excess policies. |
| Lloyd’s exposure? | Yes/No | If yes, give instruction on how they are identified. Examples:
the whole portfolio section ‘om’ has Lloyds exposure if <colname> = ‘erisk’, then Lloyds exposure |
| Single row binders | <candidate to remove> | If none, say ‘None’. If there are single row binders within the data, give instruction on how they are identified. |
| Expected BDX aggregate limit | Provide breakdown by section | |
| Expected BDX premium | Provide breakdown by section. Explain how the premium was calculated.
For example, did the UW filter to policies in the last calendar year or last 12 months. |
|
| Forecast premium | Provide breakdown by section | |
| Forecast rate change | Provide breakdown by section | |
| Comments | Any other instructions for cleaning | |
| List the section names and their sheet names in the raw data, including RBE and DA: | ||
| Section Name | Risk Bearing Entity | Delegated Authority |
| <sectionname> | CapacityProvider1 (Do not abbreviate the name, we require the full name, i.e. BICI should be ‘British Caribbean Insurance Company’ ) | MGA1 (Do not abbreviate the name, we require the full name, i.e. BICI should be ‘British Caribbean Insurance Company’ ) |
Primary Modelling Analysis
|
Modelling team to fill out the PURPLE sections below only Read any documents accompanying the portfolio that outline any constraints that need to be taken into account when cleaning the submission. If instructions are dependent on sections, duplicate the row and indicate the relevant section in section column. |
|||
| Description | Section | Value/Instruction | Examples: |
| Analysis performed by | <Modellers Name> | ||
| Today’s date | {{now.format(“dd/MM/yyyy”)}} | ||
| Limits | |||
| Attachments | |||
| Direct coverage area exclusions | Yes/No | If yes, give instruction. Example:
[cmc, ce, lof] |
|
| Dependent coverage area exclusions | Yes/No | If yes, give instruction. Examples:
if section is ‘om’ exclude [cmc, ce, lof] if colname is ‘ABC’, only include [cmc, ce, lof] |
|
| Allowed size | Provide breakdown by section | ||
| Allowed sector | Provide breakdown by section | ||
| Allowed region | Provide breakdown by section | ||
| Are loss triangles present? If so, are ransomware triangles split out? | No Triangles/Loss Triangles Present/Ransomware Triangles Present | ||
| Modeller comments | |||
Data Handler Analysis
| Data Handlers to fill out all the GREEN sections below, only | |
| Task | Answer |
| Analysis performed by | <Data Handler> |
| Today’s Date | {{now.format(“dd/MM/yyyy”)}} |
| Were there documents accompanying the portfolio that outline any constraints that need to be taken into account when cleaning the submission and have these been read? | Yes/No |
| Summarise what was read and understood | |
| Provide links to all of the relevant documents mentioned above. In absence of these documents, post a link to the box folder that was checked for them. | <Link(s) here> |
| Claims | |
| If Claims exist, insert the Claims Jira ticket and assign the ticket to yourself for completion |
<Create & Insert Jira ticket url from this board > Format: <cedant>_<YYYYMMDD>_claims |
| What type of claims listings are included? | Ground up / Partial (>100k) |
| Underlying Primary Policy Wording |
Yes/No
|
| Loss reserve information (incurred loss+ alae at the minimum or more granular) |
Yes/No
|
| Modelling Outputs |
Yes/No
|
| Treaty Performance (if applicable) |
Yes/No
|
| Insert Sublimit table as Markdown, below: | |
|
<Markdown text goes here>
|
|
Post Enrichment Ingestion Analysis & QA Signoff
| Results can be viewed in this notebook for each submission POST-enrichment phase: | |
| Question | Answer |
| Analysis performed by: | <External QA Reviewer’s Name> |
| Today’s Date | {{now.format(“dd/MM/yyyy”)}} |
| What is the total limit? | |
| What is the Total premium/subject base? | |
| Provide a breakdown by peril | |
| Quality control checklist: | |
| Spot check top risks | Yes/No |
|
Is the premium correct? |
Yes/No |
|
How did it compare to last year? |
|
|
Do the forecasting portfolio growth parameters v growth output look acceptable? (sum of premium and policy count by section and peril) |
Yes/No |
|
Are the limit bands correct? |
Yes/No |
|
How did it compare to last year? |
|
| Are the retention bands correct? | Yes/No |
|
Do quota shares look ok? |
Yes/No |
|
Does the primary/excess split make sense, based off the policy listing? |
Yes/No |
|
Does the microsegment breakdown look reasonable based on:
|
Yes/No |
| Is Enrichment rate as expected? | Yes/No |
| Have the following attributes of the product been fully checked and verified: | |
| Have the Exclusions been excluded and sub-limits been sub-limited by section when compared to last year? | Yes/No |
| Endorsements (Standalone / Add on) | Yes/No |
| Insert screenshot(s) of Dashboard results below:
|
|
| Modelling Results | |
| Results Produced by: | <Modellers Name> |
| Today’s Date | {{now.format(“dd/MM/yyyy”)}} |
| Link to Modelling results | <Paste link to results from this location> |
