Example: Factors for Additional Incurred

In the context of the Estimated Cash Flow Preparation, this function is usually used to calculate the factors to be applied in the Reflect Actual Regime based on the delivered Policy Holder to Primary Insurer lags.

Factors are calculated as a difference between 1 and the cumulated sum of the policy holder to primary insurer lag factors for a certain granularity. The number of periods is determined by the Reflect Actuals attachment point.

Input

Input Data
Contract Coverage Cost Category RAAP LFP Type LFP SUBCAT Period Cal Freq Code Factor
RIC_Q101DT COV_Q101DT 1010 000001 IN2RE PH2PI 000000 11 0.200
RIC_Q101DT COV_Q101DT 1010 000001 IN2RE PH2PI 000001 11 0.100
RIC_Q101DT COV_Q101DT 1010 000001 IN2RE PH2PI 000002 11 0.700
RIC_Q101DT COV_Q101DT 1010 000001 IN2RE PI2RI 000001 11 0.600
RIC_Q101DT COV_Q101DT 1010 000001 IN2RE PI2RI 000002 11 0.400
Input Fields
Lag Factor Pattern Granularity Fields Contract, Cost Category, Coverage
Lag Factor Frequency Field Cal Freq Code
Date Determinant Actual Date of Period
Period Field Period
RA Attachment Pt. Field RAAP
Hold Back Date Field Hold Back Date

Flow Modeling Configuration

Rules (Tab)
Rule Description Rule Type State Rule Grouping Rule Ordering Selection
I2R Factors for Additional Incurred Cash Flows Factors for Additional Incurred Cash Flows Active     
LFP_TYPE = 'IN2RE';LFP_SUBCAT = 'PH2PI'

Output

Output Fields
Lag Factor Pattern Granularity Fields Factor
Lag Factor Frequency Field Period Start Date
Date Determinant Period End Date
Output Data
Contract Coverage Cost Category RAAP LFP Type LFP SUBCAT Period Cal Freq Code Factor Hold Back Date Period End Date Period Start Date
RIC_Q101DT COV_Q101DT 1010 000000 IN2RE PH2PI 1 11 0.70 2018-01-31 2018-01-31 2018-01-01
RIC_Q101DT COV_Q101DT 1010 000000 IN2RE PH2PI 2 11 0.00 2018-01-31 2017-12-31 2017-12-01