eiopa. · xls file · web view · 2015-09-14b9=somme(b1:b7)...

103
BS-C1 document.xlsx Page 1 06/21/2022 C1 Balance sheet Cell not relevant Assets Solvency II value Statutory accounts value Goodwill AS1 Deferred acquisition costs AS24 Intangible assets A2 AS2 Deferred tax assets A26 AS26 Pension benefit surplus A25B AS25B Property, plant & equipement held for own use A3 AS3 Property (other than for own use) A5 AS5 Participations A6 AS6 Equities A7B=A7+A7A AS7B=AS7+AS7A Equities - listed A7 AS7 Equities - unlisted A7A AS7A Bonds A8E=A8+A8A+A8C+A8D AS8E=AS8+AS8A+AS8C+AS8D Government Bonds A8 AS8 Corporate Bonds A8A AS8A Structured notes A8C AS8C Collateralised securities A8D AS8D Investment funds A9 AS9 Derivatives A10A AS10A Deposits other than cash equivalents A10B AS10B Other investments A11 AS11 Assets held for index-linked and unit-linked funds A12 AS12 Loans & mortgages (except loans on policies) A14=A14B+A14C AS14 Loans & mortgages to individuals A14B Other loans & mortgages A14C Loans on policies A14A AS14A Reinsurance recoverables from: A16=A17A+A19B+A19A AS16=AS17A+AS19B+AS19A Non-life and health similinar to non-life A17A=A17+A18 AS17A=AS17+AS18 Non-life excluding health A17 AS17 Health similar to non-life A18 AS18 Life and health similar to life, excluding health and index-linked and unit-linked A19B=A18A+A19 AS19B=AS18A+AS19 Health similar to life A18A AS18A Life excluding health and index-linked and unit-linked A19 AS19 Life index-linked and unit-linked A19A AS19A Deposits to cedants A13 AS13 Insurance & intermediaries receivables A21 AS21 Reinsurance receivables A20 AS20 Receivables (trade, not insurance) A23 AS23 Own shares A28A AS28A A28B AS28B Cash and cash equivalents A27 AS27 Any other assets, not elsewhere shown A29 AS29 Total assets Liabilities Solvency II value Statutory accounts value Technical provisions – non-life (excluding health) L1=L1A+L2+L3 LS1 TP calculated as a whole L1A Best Estimate L2 Risk margin L3 Technical provisions - health (similar to non-life) L4=L4A+L5+L6 LS4 TP calculated as a whole L4A Best Estimate L5 Risk margin L6 Technical provisions - health (similar to life) L6B=L6C+L6D+L6E LS6B TP calculated as a whole L6C Best Estimate L6D Risk margin L6E L7=L7A+L8+L9 LS7 TP calculated as a whole L7A Best Estimate L8 Risk margin L9 Technical provisions – index-linked and unit-linked L10=L10A+L11+L12 LS10 TP calculated as a whole L10A Best Estimate L11 Risk margin L12 Other technical provisions LS14 Contingent liabilities L23 Provisions other than technical provisions L18 LS18 Pension benefit obligations L22 LS22 Deposits from reinsurers L13 LS13 Deferred tax liabilities L17 LS17 Derivatives L16 LS16 Debts owed to credit institutions L19 LS19 Financial liabilities other than debts owed to credit institutions L20 LS20 Insurance & intermediaries payables L15A LS15A Reinsurance payables L15B LS15B Payables (trade, not insurance) L15C LS15C Subordinated liabilities not in BOF L15D Cell used more than once in one single template Cell reported in a different template Investments (other than assets held for index-linked and unit- linked funds) A4=A5+A6+A7B+A8E+A9+A10A+A1 0B+A11 AS4=AS5+AS6+AS7B+AS8E+AS9+AS10A +AS10B+AS11 Amounts due in respect of own fund items or initial fund called up but not yet paid in A30=A2+A26+A25B+A3+A4+A11+A 12+A14+A14A+A16+A13+A20+A21 +A22+A23+A28A+A28B+A27+A29 AS30=AS2+AS26+AS25B+AS3+AS4+AS1 1+AS12+AS14+AS14A+AS16+AS13+AS2 0+AS21+AS22+AS23+AS28A+AS28B+AS 27+AS29 Technical provisions – life (excluding health and index-linked and unit-linked)

Upload: vankhanh

Post on 15-Mar-2018

218 views

Category:

Documents


4 download

TRANSCRIPT

Page 1: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

BS-C1

document.xlsx Page 1 05/06/2023

C1

Balance sheet Cell not relevant Formula

Assets Solvency II value Statutory accounts value

Goodwill AS1Deferred acquisition costs AS24Intangible assets A2 AS2Deferred tax assets A26 AS26Pension benefit surplus A25B AS25BProperty, plant & equipement held for own use A3 AS3

Investments (other than assets held for index-linked and unit-linked funds)

Property (other than for own use) A5 AS5 Participations A6 AS6Equities A7B=A7+A7A AS7B=AS7+AS7A Equities - listed A7 AS7 Equities - unlisted A7A AS7ABonds A8E=A8+A8A+A8C+A8D AS8E=AS8+AS8A+AS8C+AS8D Government Bonds A8 AS8 Corporate Bonds A8A AS8A Structured notes A8C AS8C Collateralised securities A8D AS8D Investment funds A9 AS9 Derivatives A10A AS10A Deposits other than cash equivalents A10B AS10B Other investments A11 AS11Assets held for index-linked and unit-linked funds A12 AS12Loans & mortgages (except loans on policies) A14=A14B+A14C AS14 Loans & mortgages to individuals A14B Other loans & mortgages A14CLoans on policies A14A AS14A

Reinsurance recoverables from:A16=A17A+A19B+A19A AS16=AS17A+AS19B+AS19A

Non-life and health similinar to non-life A17A=A17+A18 AS17A=AS17+AS18 Non-life excluding health A17 AS17 Health similar to non-life A18 AS18

A19B=A18A+A19 AS19B=AS18A+AS19 Health similar to life A18A AS18A Life excluding health and index-linked and unit-linked A19 AS19 Life index-linked and unit-linked A19A AS19ADeposits to cedants A13 AS13Insurance & intermediaries receivables A21 AS21Reinsurance receivables A20 AS20Receivables (trade, not insurance) A23 AS23Own shares A28A AS28A

A28B AS28BCash and cash equivalents A27 AS27Any other assets, not elsewhere shown A29 AS29

Total assets

LiabilitiesSolvency II value Statutory accounts value

Technical provisions – non-life (excluding health) L1=L1A+L2+L3 LS1 TP calculated as a whole L1A Best Estimate L2 Risk margin L3Technical provisions - health (similar to non-life) L4=L4A+L5+L6 LS4 TP calculated as a whole L4A Best Estimate L5 Risk margin L6Technical provisions - health (similar to life) L6B=L6C+L6D+L6E LS6B TP calculated as a whole L6C Best Estimate L6D Risk margin L6E

L7=L7A+L8+L9 LS7 TP calculated as a whole L7A Best Estimate L8 Risk margin L9Technical provisions – index-linked and unit-linked L10=L10A+L11+L12 LS10 TP calculated as a whole L10A Best Estimate L11 Risk margin L12Other technical provisions LS14Contingent liabilities L23Provisions other than technical provisions L18 LS18Pension benefit obligations L22 LS22Deposits from reinsurers L13 LS13Deferred tax liabilities L17 LS17Derivatives L16 LS16Debts owed to credit institutions L19 LS19Financial liabilities other than debts owed to credit institutions L20 LS20Insurance & intermediaries payables L15A LS15AReinsurance payables L15B LS15BPayables (trade, not insurance) L15C LS15CSubordinated liabilities not in BOF L15D

LS15DSubordinated liabilities in BOF L26

Cell used more than once in one single template

Cell reported in a different template

A4=A5+A6+A7B+A8E+A9+A10A+A10B+A11

AS4=AS5+AS6+AS7B+AS8E+AS9+AS10A+AS10B+AS11

Life and health similar to life, excluding health and index-linked and unit-linked

Amounts due in respect of own fund items or initial fund called up but not yet paid in

A30=A2+A26+A25B+A3+A4+A11+A12+A14+A14A+A16+A13+A20+A21+A22+A23+A28A+A28B+A27+A29

AS30=AS2+AS26+AS25B+AS3+AS4+AS11+AS12+AS14+AS14A+AS16+AS13+AS20+AS21+AS22+AS23+AS28A+AS28B+AS27+AS29

Technical provisions – life (excluding health and index-linked and unit-linked)

Page 2: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

BS-C1

document.xlsx Page 2 05/06/2023

Any other liabilities, not elsewhere shown L25 LS25

Total liabilities

Excess of assets over liabilities L27=A30-L25A LS27=AS30-LS25A

L25A=L1+L4+L6B+L7+L10+L23+L18+L22+L13+L17+L16+L19+L20+L15A+L15B+L15C+L15D+L26+L25

LS25A=LS1+LS4+LS6B+LS7+LS10+LS14+LS18+LS22+LS13+LS17+LS16+LS19+LS20+LS15A+LS15B+LS15C+LS15D+LS25

Page 3: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

C1B

Off-balance sheet items Cell not relevant Formula

Guarantees received

Maximum value

Guarantees received by the undertaking directly A2 Of which, guarantees received from other entities of the same group A3A

List of unlimited guarantees receivedA3C E3C B3C C3C D3C

Maximum value

Guarantees received for assets held by the undertaking A3B B3B

Collateral held

SII value

Collateral held for loans made or bonds purchased A10 B10Collateral held for derivatives A12A B12AAssets pledged by reinsurers for ceded technical provisions A13 B13Other collateral held A13A B13A

Total collateral held

Collateral pledged

SII value

Collateral pledged for loans received or bonds issued A14 B14Collateral pledged for derivatives A15A B15AAssets pledged to cedants for technical provisions (reinsurance accepted) A17 B17Other collateral pledged A17A B17A

Total collateral pledged

Contingent liabilities

Contingent liabilities not in SII BS A18A5

A9A

List of unlimited guarantees provided by the undertakingA9B D9B B9B C9B

Contingent liabilities in SII BS A19 B19

Cell used more than once in one single

template Cell reported in a different template

Name of provider of guarantee

Provider of guarantee belonging to the same

groupY/N

Triggering event(s) of guarantee

Application date of guarantee

Ancillary Own Funds

Y/N

Value of guaranteed assets

Value of guaranteed assets

A13B=A10+A12A+A13+A13A

B13B=B10+B12A+B13+B13A

Value of guaranteed liabilities

A17B=A14+A15A+A17+A17A

B17B=B14+B15A+B17+B17A

Maximum possible value

Of which guarantees off BS provided by the undertaking Including guarantees off BS provided by the undertaking to entities of the same group

Name of receiver of guarantee

Provider of guarantee belonging to the same

groupY/N

Triggering event(s) of guarantee

Application date of guarantee

Maximum possible value

Expected value (SII value)

Page 4: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

C1D

Assets and liabilities by currency Cell not relevant Formula

Currencies

Total

Currency codeB1 C1 D1 E1 etc. Other

AssetsA3 Sum

A4 SumA5 Sum

Reinsurance recoverables A5A SumDeposits to cedants and insurance and reinsurance receivables A6 SumAny other assets A7 SumTotal assets A7A=sum (A3:A7) B7A=sum sum sum sum sum sum sum Liabilities

A8 SumA9 Sum

Deposits from reinsurers and insurance, intermediaries and reinsurance payables A10 SumDerivatives A11 SumFinancial liabilities A12 SumContingent liabilities A13 SumAny other liabilities A14 SumTotal liabilites A15=sum (A8:A14) B15=sum sum sum sum sum sum sum

Cell used more than once in one single template

Cell reported in a different template

A1/reporting currency

Investments (other than assets held for index-linked and unit-linked funds)

Other assets within scope of Assets-D1 (other than index-linked and unit-linked funds)Assets held for index-linked and unit-linked funds

Technical provisions (excluding index-linked and unit-linked funds)Technical provisions - index-linked and unit-linked funds

Page 5: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

K1

Activity by country Cell not relevant Formula

Home country Country 1 (EEA member state)

Branch FPS Branch FPS Branch FPSClass 1Premiums written A1 A2 A3 A4Claims incurred C1 C2 C3 C4Commissions E1 E2 E3 E4Class 2Premiums written

Claims incurredCommissions

Class etc.Same information as aboveFrequency of claims for Motor Vehicle Liability (except carrier's liability) H1 H2 H3Average cost of claims for Motor Vehicle Liability (except carrier's liability)

H1A H2A H3A

Cell used more than once in one single template

Cell reported in a different template

Country ... (EEA member state)

Country 29 (EEA member

state)

Country X (not an EEA member state)

Country Y (not an EEA member state)

Page 6: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20
Page 7: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

A1A

Premiums, claims & expenses - annual data Cell not relevant Formula

Non-life Top 5 countries (by amount of gross premiums written)

Health (13) Property (14) Casualty (15) Country 1 Country 2 Country 3 Country 4 Country 5

Premiums written Gross - Direct Business A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A19 A20 A21 A22 A23

B1 B2 … B13 B14 B15 B16C1

D1=A1+B1-C1Premiums earned Gross - Direct Business A1A

B1AC1A

D1A=A1A+B1A-C1AClaims incurred Gross - Direct Business E1

F1G1

H1=E1+F1-G1Expenses incurred Administrative expenses Gross - Direct Business E1A

F1AG1A

H1A=E1A+F1A-G1A Investment management expenses Gross - Direct Business E1B

F1BG1B

H1B=E1B+F1B-G1B Claims management expenses Gross - Direct Business E1C

F1CG1C

H1C=E1C+F1C-G1C Acquisition expenses Gross - Direct Business E1D

F1DG1D

H1D=E1D+F1D-G1D Overhead expenses Gross - Direct Business E1E

F1EG1E

H1E=E1E+F1E-G1EOther expenses H1FTotal expenses H1G=H1A+..+H16A+H1B+…+H16B+H1C+…+H16C+H1D+..+H16D+H1E+..+H16E+H1F H1H

Cell used more than once in one single

template Cell reported in a different template

Line of Business for: non-life obligations Line of business for:accepted non-proportional reinsurance

Medical expense insurance

(1)

Income protection insurance

(2)

Workers' compensation

insurance(3)

Motor vehicle liability insurance

(4)

Other motor insurance

(5)

Marine, aviation and transport

insurance(6)

Fire and other damage to property

insurance(7)

General liability

insurance(8)

Credit and suretyship insurance

(9)

Legal expenses insurance

(10)

Assistance(11)

Miscellaneous financial loss

(12)

Marine, aviation, transport

(16)

Gross - Reinsurance accepted Reinsurers' share Net

Gross - Reinsurance accepted Reinsurers' share Net

Gross - Reinsurance accepted Reinsurers' share Net

Gross - Reinsurance accepted Reinsurers' share Total Net

Gross - Reinsurance accepted Reinsurers' share Total Net

Gross - Reinsurance accepted Reinsurers' share Total Net

Gross - Reinsurance accepted Reinsurers' share Total Net

Gross - Reinsurance accepted Reinsurers' share Total Net

Page 8: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Life Top 5 countries (by amount of gross premiums written)

Other life insurance Health insurance Country 1 Country 2 Country 3 Country 4 Country 5

Premiums written Gross I1 I2 I3 I3A I3B I4 I5 I6 I7 I8 I9 I10 I11

J1K1=I1-J1

Premiums earned Gross I1A

J1AK1A=I1A-J1A

Claims incurred Gross L1

M1N1=L1-M1

Expenses incurred Administrative expenses Gross L1A

M1AN1A=L1A-M1A

Investment management expenses Gross O1

P1Q1=O1-P1

Claims management expenses Gross O1A

P1AQ1A=O1A-P1A

Acquisition expenses Gross O1B

P1BQ1B=O1B-P1B

Overhead expenses Gross O1C

P1CQ1C=O1C-P1C

Other expenses RTotal expenses S1=N1A+…+N16A+Q1+…+Q16+Q1A+…+Q16A+Q1B+…+Q16B+Q1C+…+Q16C+R S2

`

Line of Business for: life obligations

Insurance with profit participation

Index-linked and unit-linked insurance

Annuities stemming from non-life

insurance contracts and relating to

health insurance obligations

Annuities stemming from

non-life insurance

contracts and relating to insurance obligations other than

health insurance obligations

Life reinsurance Health reinsurance

Reinsurers' share Net

Reinsurers' share Net

Reinsurers' share Net

Reinsurers' share Total Net

Reinsurers' share Total Net

Reinsurers' share Total Net

Reinsurers' share Total Net

Reinsurers' share Total Net

Page 9: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

OF-B1A (solo)

Own funds (annual template - for solo entities)Cell not relevant

Basic own funds

Total

Ordinary share capital (gross of own shares) A1=B1+C1

Share premium account related to ordinary share capital A2=B2+C2

A3=B3+C3

Subordinated mutual member accounts A4=B4+C4+D4

Surplus funds A6=B6Preference shares A8=B8+C8+D8Share premium account related to preference shares A9=B9+C9+D9Reconciliation reserve (solo) A12=B12

Subordinated liabilities A13=B13+C13+D13An amount equal to the value of net deferred tax assets A15=D15

A16=B16+C16+D16

Total

Deductions not included in the reconcilation reserveTotal

Deductions for participations in financial and credit institutions A503 = SUM(B503:E503)

Own funds items that meet the criteria in COF2, COF4, COF8 or TOF1

Iinitial funds, members' contributions or the equivalent basic own - fund item for mutual and mutual-type undertakings

Other items approved by supervisory authority as basic own funds not specified above

Own funds from the financial statements that should not be represented by the reconciliation reserve and do not meet the criteria to be classified as Solvency II own funds

Own funds from the financial statements that should not be represented by the reconciliation reserve and do not meet the criteria to be classified as Solvency II own funds

B502 = SUM(B501.1:B501.n)

Page 10: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Total

Total basic own funds after adjustments (solo)

Validation check (solo)

Ancillary own fundsUnpaid and uncalled ordinary share capital callable on demand A33 = C33

A34 = C34

Unpaid and uncalled preference shares callable on demand A35 =C35+D35A36 =C36+D36

A37=C37

A38 =C38+D38

A39=C39

A40 =C40+D40

Other ancillary own funds A42 =C42+D42Total ancillary own funds (solo) A43 =C43+D43

Total

Total available own funds to meet the SCR (solo) A46=B46+C46+D46+E46

Total available own funds to meet the MCR (solo) A47=B47+C47+D47

Total

A20= A1+A2+A3+A4+A6+A8+A9+A12+A13+A15+A16-B502-

A503

A22=: A20 = BS-C1 "L27"-B24-B25-B27-B502-A503+ BS-C1 "L26"

Unpaid and uncalled initial funds, members' contributions or the equivalent basic own fund item for mutual and mutual - type undertakings, callable on demand

A legally binding commitment to subscribe and pay for subordinated liabilities on demand

Letters of credit and guarantees under Article 96(2) of the Framework Directive

Letters of credit and guarantees other than under Article 96(2) of the Framework Directive

Supplementary members calls under Article 96(3) of the Framework Directive

Supplementary members calls - other than under Article 96(3) of the Framework Directive

Page 11: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Total eligible own funds to meet the SCR A50 = B50+C50+D50+E50

Total eligible own funds to meet the MCR A51=B51+C51+D51

SCR A52MCR A53Ratio of Eligible own funds to SCR A54 = A50/A52Ratio of Eligible own funds to MCR A55 = A51/A53

Reconciliation reserveExcess of assets over liabilitiesOwn shares (included as assets on the balance sheet)Forseeable dividends and distributionsOther basic own fund items

Restricted own fund items due to ring fencingReconciliation reserve (total solo)

A30 = B30

A31 = B31

Total EPIFP A32=A30+A31

Ordinary share capital TotalPaid in A56=B56

Called up but not yet paid in A57=C57

Own shares held A58 = B58

Total ordinary share capital A59=A56+A57

Ordinary share capital - movements in the reporting period Balance b/fwd

Paid in A60Called up but not yet paid in A61Own shares held A62Total ordinary share capital A63 = A60+A61

Balance b/fwd

Expected profits included in future premiums (EPIFP) - Life businessExpected profits included in future premiums (EPIFP) - Non- life business

Share premium account related to ordinary share capital - movements in the reporting period

Page 12: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Tier 1 A64

Tier 2 A65

Total A66=A64+A65

TotalPaid in A67=B67

Called up but not yet paid in A68=C68

Total initial fund A69 = B69 + C69

Balance b/fwd A70

Called up but not yet paid in A71Total initial fund A72=A70+A71

Subordinated mutual members accounts (MMA)Total

Dated subordinated MMA A73= B73+D73+F73Undated subordinated MMA with a call option A74= B74+D74+F74

A75= B75+D75+F75

Total subordinated MMA A76=A73+A74+A75

Balance b/fwd Tier 1 A511

Tier 2 A512

Tier 3 A513

Total subordinated MMA A514=A511+A512+A513

Description of subordinated MMA (solo)A77.1 B77.1A77.n B77.n

Surplus fundsBalance b/fwd

The initial fund members' contributions or the equivalent basic own - fund item for mutual and mutual - type undertakings

The initial fund (Mutuals) - movements in the reporting period

Paid in

Undated subordinated MMA with no contractual opportunity to redeem

Subordinated mutual members accounts - movements in the reporting period

Amount (in reporting currency)

Page 13: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

A505

Preference shares TotalDated preference shares A79=B79+D79+F79Undated preference shares with a call option A80=B80+D80+F80

A81=B81+D81+F81

Total preference shares A82=B82+D82+F82

Preference shares - movements in the reporting period Balance b/fwd Tier 1 A83Tier 2 A84

A85Total preference shares A86=A83+A84+A85

Description of preference shares AmountA87.1 B87.1A87.n B87.n

Share premium relating to preference shares Balance b/fwd Tier 1 A88Tier 2 A89Tier 3 A90Total A91=A88+89+A90

Subordinated liabilitiesTotal

Dated subordinated liabilities A92=B92+D92+F92A93=B93+D93+F93

A94=B94+D94+F94

Total subordinated liabilities A95=A92+A93+A94

Subordinated liabilities - movements in the reporting period Balance b/fwd Tier 1 A96

Tier 2 A97

Tier 3 A98

Undated preference shares with no contractual opportunity to redeem

Tier 3

Undated subordinated liabilities with a contractual opportunity to redeemUndated subordinated liabilities with no contractual opportunity to redeem

Page 14: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Total subordinated liabilities A99=A96+A97+A98

Description of subordinated liabilities (solo)A100.1 B100.1A100.n B100.n

Balance b/fwd A504

Balance b/fwd Tier 1 to be treated as COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items A102

Tier 1 to be treated as COF1 (1)(c), (1)(e), and (2) items A102A

Tier 2 A103

Tier 3 A104

Total basic own funds items not specified above A105=A102+A103+A104

AmountA106.1 B106.1A106.n B106.n

TotalDescription of itemA501.1 B501.1

A501.n B501.n

Ancillary own funds Tier 2

Amount (in reporting currency)

An amount equal to the value of net deferred tax assets

Other items approved by supervisory authority as basic own funds not specified above - movements in the reporting period

Other items approved by supervisory authority as basic own funds not specified above (solo)

Own funds from the financial statements that should not be represented by the reconciliation reserve and do not meet the criteria to be classified as Solvency II own funds

Page 15: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Items for which an amount was approved A108

Items for which a method was approved

Ancillary own funds - movements in the reporting period Balance b/fwd Tier 2 A110

Tier 3 A111

Total ancillary own funds A112=A110+A111

Description of ancillary own funds (solo) AmountA113.1 B113.1A113.n B113.n

Adjustment for ring fenced funds

Name of ring-fenced fund Notional SCRA115.1 B115.1

A115.n B115.n

Risks outside any ring-fenced fund B116

Totals

RFF deduction

Adjustment for participations

Name of related undertaking Total

Initial amounts approved

Article 71 POF1 (1) financial and credit institutions (>10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

Page 16: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

A506.1

A506.n

Name of related undertaking Total

A507.1 B507.1

A507.n B507.n

Total

Article 71 POF1 (1) deductionA508 = B508+C508+D508

Article 71 POF1 (2) deduction A509 = B509+C509+D509Total A510 = B510+C510+D510

Excess of assets over liabilities - attribution of valuation differencesReferences to BS-C1, refer to the balance sheet remplate

Difference in the valuation of assets

Difference in the valuation of technical provisions

Difference in the valuation of other liabilities

Q4

Other, please explain why you need to use this line. Q5

Q6 = Q1-Q2-Q3+Q4+Q5

B506.1= C506.1+D506.1+E506.1

B506.n= C506.n+D506.n+E506.n

Article 71 POF1 (2) financial and credit institutions (<10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

S2 Value - Statutory accounts

Q1 = BS-C1 "A30" - BS-C1 "AS30"

Q2 = BS-C1("L1"+"L4"+"L6B"+"L7"+"

L10") - BS-C1("LS1"+"LS4"+"LS6B"+"L

S7"+"LS10"+"AS14")

Q3 = BS-C1("L25A" -"LS25A") - Q2

Total of reserves and retained earnings from financial statements

Reserves from financial statements adjusted for Solvency II valuation differences

Page 17: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Q7 = B26

Excess of assets over liabilities Q8 = B23 = Q6+ Q7

Excess of assets over liabilities attributable to basic own fund items (excluding the reconciliation reserve)

Page 18: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Formula

Tier 1 Tier 1 Tier 2 Tier 3

B1=B59 C1=C59

B2=D64 C2=D65

B3=B67 C3=C68

B4=B76 C4=D76 D4=F76

B6 = B505B8=B82 C8=D82 D8=F82B9=D88 C9=D89 D9=D90

B12=B29

B13=B95 C13=D95 D13=F95D15=B504

B16=E102 B16A = E102A C16=E103 D16=E104

Tier 1 Tier 1 Tier 2

B503 = B510 C503 = C510 D503 = D510

Cell used more than once in one single

template Cell reported in a different template

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

Page 19: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Tier 1 Tier 1 Tier 2 Tier 3

Tier 2 Tier 3C33

C34

C35 D35C36 D36

C37

C38 D38

C39

C40 D40

C42 D42D43 = D35+D36+D38+D40+D42

Tier 1 Tier 1 Tier 2 Tier 3

B46=B20 C46 = B20A D46=C20+C43 E46=D20+D43

B47=B46 C47 = C46 D47=C20

Tier 1 Tier 1 Tier 2 Tier 3

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

B20= B1+B2+B3+B6+B12+B1

6-B502-B503

B20A= B4+B8+B9+B13+B16A-

C503

C20= C1+C2+C3+C4+C8+C9+C

13+C16-D503

D20= D4+D8+D9+D13+D15+D16

C43 = SUM(C33:C40) + C42

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

Page 20: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

B50=B46

B51=B50 C51=C50

B23=BSC-C1 "L27"B24=BSC-C1 "A28A"B25

B27 = F118

B30

B31

B32 =B30+B31

Tier 1 Tier 2 Tier 3B56 = D60

C57 = D61

B58 = "BS-C1 A28A"

B59 = B56 C59 = C57

Increase Reduction Balance c/fwdB60 C60 D60 = A60 + B60 - C60B61 C61 D61= A61 + B61 - C61B62 C62 D62 = A62 + B62 - C62

B63 = B60+B61 C63 = C60+C61 D63 = A63 + B63 - C63

Increase Reduction Balance c/fwd

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

C50=MAX(0,(MIN(B50*0.25, C46)))

D50=MAX(0,(MIN(0.5*A52,((C46)-C50)+ (D46))))

E50=MAX(0,MIN(((0.5*A52)-D50), 0.15*A52, (E46)))

D51=MAX(0,(MIN(0.2*A53,((C46)-C51)+ (D46))))

B26=(A1-B24)+A2+A3+A4 +A6+A8+A9+A15+A16

B29 = B23-B24-B25-B26-B27

Page 21: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

B64 C64 D64 = A64+B64-C64

B65 C65 D65 = A65+B65-C65

B66=B64+B65 C66=C64+C65 D66 = A66+B66-C66

Tier 1 Tier 2 Tier 3B67 = D70

C68 = D71

B69=B67 C69=C68

Increase Reduction Balance c/fwdB70 C70 D70 = A70 + B70 - C70B71 C71 D71 = A71 + B71 - C71

B72=B70+B71 C72=C70+C71 D72 = A72 + B72 - C72

Tier 1 Tier 2B73 C73 D73 E73B74 C74 D74 E74B75 C75 D75 E75

B76=B73+B74+B75 C76=C73+C74+C75 D76=D73+D74+D75 E76=E73+E74+E75

issued redeemed Regulatory actionB511 C511 D511 E511

B512 C512 D512 E512

B513 C513 D513 E513

D514=D511+D512 +D513 E514=E511+E512+E513

Tier Counterparty (if specific)C77.1 D77.1 F77.1 G77.1C77.n D77.n F77.n G77.n

Balance c/fwd

Of which counted under transitionals

Of which counted under transitionals

Movements in valuation

B514=B511+B512 +B513

C514=C511+C512 +C513

Currency Code (if different to reporting

currency)Is this counted under

transitionals?

Page 22: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

B505

Tier 1 Tier 2B79 C79 D79 E79B80 C80 D80 E80B81 C81 D81 E81

B82=B79+B80+B81 C82=C79+C80+C81 D82=D79+D80+D81 E82=E79+E80+E81

Increase Reduction Balance c/fwdB83 C83 E83=A83+B83-C83B84 C84 E84=A84+B84-C84B85 C85 E85=A85+B85-C85

B86=B83+B84+B85 C86=C83+C84+C85 E86=E83+E84+E85

First call dateC87.1 D87.1 E87.1 F87.1C87.n D87.n E87.n F87.n

Increase Reduction Balance c/fwdB88 C88 D88 = A88 + B88 - C88B89 C89 D89 = A89 + B89 - C89B90 C90 D90 = A90 + B90 - C90

B91=B88+B89+B90 C91=C88+C89+C90 D91=D88+D89+D90

Tier 1 Tier 2B92 C92 D92 E92B93 C93 D93 E93

B94 C94 D94 E94

B95=B92+B93+B94 C95=C92+C93+C94 D95=D92+D93+D94 E95=E92+E93+E94

issued redeemed Regulatory actionB96 C96 D96 E96

B97 C97 D97 E97

B98 C98 D98 E98

Of which counted under transitionals

Of which counted under transitionals

Is this counted under transitionals?

Counterparty (if specific)

issue date

Of which counted under transitionals

Of which counted under transitionals

Movements in valuation

Page 23: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

B99=B96+B97+B98 C99=C96+C97+C98 D99=D96+D97+D98 E99=E96+E97+E98

Tier Lender (if specific)C100.1 D100.1 E100.1 F100.1C100.n D100.n E100.n F100.n

Balance c/fwdB504

issued redeemed Balance c/fwdB102 C102 D102 E102=A102+B102-C102+D102

B102A C102A D102A

B103 C103 D103 E103=A103+B103-C103+D103

B104 C104 D104 E104=A104+B104-C104+D104

B105=B102+B103+B104 C105=C102+C103+C104 D105=D102+D103+D104 E105=E102+E103+E104

Currency Code Tier 1 Tier 2 Tier 3C106.1 D106.1 E106.1 F106.1C106.n D106.n E106.n F106.n

Tier 2 Tier 3

Currency Code (if different to reporting

currency)Is this counted under

transitionals?

Movements in valuation

E102A=A102A+B102A-C102A+D102A

Page 24: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Current amounts Current amountsB108 C108 D108

B109 D109

Balance c/fwdB110 C110 D110 F110=A110+B110-C110-D110

B111 C111 D111 F111=A111+B111-C111-D111

B112=B110+B111 C112=C110+C111 D112=D110+D111 F112=F110+F111

Counterpart Date of authorisationC113.1 D113.1 E113.1C113.n D113.n E113.n

Own fundsD115.1 E115.1

D115.n E115.n

D116 E116 F116

F118=D117-F117

Additional Tier 1 Tier 2

Initial amounts approved

New amount made available

Reduction to amount available

Called up to basic own fund

issue date

Notional SCR (negative results set

to zero)Shareholder value in

RFFOwn funds eligible for

undertakingC115.1=IF(B115.1<0,0,B

115.1)F115.1=IF((D115.1>=C115.1),

(C115.1+E115.1),D115.1)C115.n=IF(B115.n<0,0,B

115.n)F115.n=IF((D115.n>=C115.n),

(C115.n+E115.n),D115.n)

C116=IF(B116<0,0,B116)

D117=sumD115.1:D115.n+D116

F117=sumF115.1:F115.n + F116

Article 71 POF1 (1) financial and credit institutions (>10% of items included in (a), (b), (d) and (f) of Article

Common Equity Tier 1

Page 25: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

C506.1 D506.1 E506.1

C506.n D506.n E506.n

Additional Tier 1 Tier 2

C507.1 D507.1 E507.1

C507.n D507.n E507.n

Tier 1 Tier 1 Tier 2

B509 C509 D509B510 = B508+B509 C510 = C508+C509 D510 = D508+D509

Explanation

Article 71 POF1 (2) financial and credit institutions (<10% of items included in (a), (b), (d) and (f) of Article

Common Equity Tier 1

COF1 (1)(a), (1)(b), (1)(d) and (1)(f) items

COF1 (1)(c), (1)(e), and (2) items

B508 = SUM(C506.1:C506.n)

C508 = SUM(D506.1:D506.n)

D508 = SUM(E506.1:E506.n)

Page 26: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Tier 3F73F74F75

F76=F73+F74+F75

Balance c/fwd

F514=F511+F512+F513

maturity date First call dateH77.1 I77.1 J77.1 K77.1 L77.1H77.n I77.n J77.n K77.n L77.n

F511=A511+B511-C511+D511+E511F512=A512+B512-C512+D512+E512F513=A513+B513-C513+D513+E513

issue date

Details of further call

dates

Details of incentives to

redeem

Page 27: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Tier 3F79F80F81

F82=F79+F80+F81

G87.1 H87.1G87.n H87.n

Tier 3F92F93

F94

F95=F92+F93+F94

Balance c/fwd

Details of further call dates

Details of incentives to redeem

F96=A96+B96-C96+D96+E96F97=A97+B97-C97+D97+E97F98=A98+B98-C98+D98+E98

Page 28: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

F99=F96+F97+F98

maturity date First call dateH100.1 I100.1 J100.1 K100.1 L100.1H100.n I100.n J100.n K100.n L100.n

Date of authorisationG106.1G106.n

issue date

Further call dates

Details of incentives to

redeem

Page 29: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

noticeM77.1 N77.1M77.n N77.n

Buy back during the year

Page 30: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Notice periodM100.1M100.n

Page 31: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Participations

Cell not relevant

Name of related undertaking Total

A1.1 B1.1

A1.n B1.n

Name of related undertaking Total

A2.1 B2.1

A2.n B2.n

Name of related undertaking Total

A3.1 B3.1

A3.n B3.n

Name of related undertaking Total

A4.1 B4.1

A4.n B4.n

Name of related undertaking Total

A5.1 B5.1

A5.n B5.n

Total

Total participations in financial and credit institutionsA6 = B6+C6+D6

Article 71 POF1 (1) financial and credit institutions (>10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

Article 71 POF1 (2) financial and credit institutions (<10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

Article 71 POF1 (3) financial and credit institutions (consolidated strategic participations)

Other strategic participations, not included in A1.1 to A1.n, A2.1 to A2.n and A2.1 to A2.n

Other non-strategic participations, not included in A1.1 to A1.n, A2.1 to A2.n and A2.1 to A2.n

Page 32: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Total

A7 = B7+C7+D7

of which strategic A8 = B8+C8+D8

of which non-strategic A9 = B9+C9+D9

TotalTotal of all participations A10 = A6 +A7

Participations from balance sheet A11

Own funds deductionsTotal

Article 71 POF1 (1) deduction

Article 71 POF1 (2) deduction

Total

Total participations in related undertakings that are not financial and credit institutions

A12 = B12+C12+D12

A13 = B13+C13+D12

Remainder following POF1 (2) deductions which are strategic

A14 = B14+C14+D14

Remainder following POF1 (2) deductions which are not strategic

A15 = B15+C15+D15

Page 33: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Formula

Additional Tier 1 Tier 2

C1.1 D1.1 E1.1

C1.n D1.n E1.n

Additional Tier 1 Tier 2

C2.1 D2.1 E2.1

C2.n D2.n E2.n

Type 1 Equity Type 2 Equity

C3.1 D3.1 E3.1

C3.n D3.n E3.n

Type 1 Equity Type 2 EquityUntertaking type

C4.1 D4.1 E4.1 F4.1

C4.n D4.n E4.n F4.n

Type 1 Equity Type 2 EquityUntertaking type

C5.1 D5.1 E5.1 F5.1

C5.n D5.n E5.n F5.n

Additional Tier 1 Tier 2

Cell used more than once in one single template

Cell reported in a different template

Article 71 POF1 (1) financial and credit institutions (>10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

Common Equity Tier 1

Article 71 POF1 (2) financial and credit institutions (<10% of items included in (a), (b), (d) and (f) of Article 58(1), not including consolidated strategic participations)

Common Equity Tier 1

Subordinated liabilities

Subordinated liabilities

Subordinated liabilities

Common Equity Tier 1

B6=Sum(C1.1:C1.n)+Sum(C2.1:C2.n)+

Sum(C3.1:C3.n)

C6=Sum(D1.1:D1.n)+Sum(D2.1:D2.n)+

Sum(D3.1:D3.n)

D6=Sum(E1.1:E1.n)+Sum(E2.1:E2.n)+

Sum(E3.1:E3.n)

Page 34: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Type 1 Equity Type 2 Equity

B7=B8+B9 C7=C8+C9 D7=D8+D9

B8=Sum(C4.1:C4.n) C8=Sum(D4.1:D4.n) D8=Sum(E4.1:E4.n)

B9=Sum(C5.1:C5.n) C9=Sum(D5.1:D5.n) D9=Sum(E5.1:E5.n)

Tier 1 Tier 1 Tier 2

B12 = Sum(C1.1:C1.n) D12 = Sum(E1.1:E1.n)

B13 C13 D13

Type 1 Equity Type 2 Equity

B14 C14 D14

B15 C15 D15

Subordinated liabilities

COF1 (1)(a), (1)(b), (1)(d) and (1)(f)

items

COF1 (1)(c), (1)(e), and (2) items

C12 = Sum(D1.1:D1.n)

Subordinated liabilities

Page 35: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

C2A

Summary analysis of changes in BOF Cell not relevant Formula

Reconciliation with OF-B1Basic Own funds items Year N Year N-1 VarOrdinary share capital (gross of own shares) N1 O1 V1=N1-O1

N2 O2 V2=N2-O2

N3 O3 V3=N3-O3Subordinated mutual member accounts N4 O4 V4=N4-O4Surplus funds N5 O5 V5=N5-O5Preference shares N6 O6 V6=N6-O6Reconciliation reserve N7 O7 V7=N7-O7 See belowSubordinated liabilities (in Basic Own Funds) N8 O8 V8=N8-O8An amount equal to the value of net deferred tax assets N9 O9 V9=N9-O9

N10 O10 V10=N10-O10Variation of total BOF items before adjustments =sum =sum V11=sum(V1:V10)

Variation of components of reconciliation reserveExcess of assets over liabilities V12 Variations of BOF explained by Variation Analysis TemplatesOwn shares (included as assets on the balance sheet) V13

Forseeable dividends and distributions V14

Other basic own fund items

Restricted own fund items due to ring fencing V16

Total variation of Reconciliation Reserve

Summary Analysis of Variation of Excess of Assets over Liabilities

Changes due to investments and financial liabilities V17= AA3 (VA C2B) Template VA C2BChanges due to technical provisions Template VA C2C

V19= -V15 Variation in Deffered Tax position (var DTA-DTL) V20 From BS-C1Income Tax of the reporting period V21Dividend distribution V22Other changes in Excess of Assets over Liabilities

Cell used more than once in one single

template Cell reported in a different template

Variation detailed in OF-B1Share premium account (both related to preference shares and to ordinary share capital)

Variation detailed in OF-B1

Iinitial funds, members' contributions or the equivalent basic own - fund item for mutual and mutual-type undertakings

Variation detailed in OF-B1

Variation detailed in OF-B1Variation detailed in OF-B1Variation detailed in OF-B1

Variation detailed in OF-B1Variation detailed in OF-B1

Other items approved by supervisory authority as basic own funds not specified above (Article 67 COF10 of the Delegated Acts)

Variation detailed in OF-B1

V15=sum(V1:V6)+V9+V10

V7 = V12-V13-V14-V15-V16

V18=AA5L + AA5NL + AA6L + AA6NL (VA C2C)

Variations in capital basic own fund items and other items approved explained in OF-B1

Already mostly explained in OF-B1

V23= V12-V17-V18-V19-V20-V21-V22

Page 36: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

VA C2B

Analysis of changes due to investments and financial liabilities Cell not relevant Formula

Overview

Reconciliation with BS-C1 Year N Year N-1 Var

AssetsInvestments (other than assets held for index-linked and unit-linked funds) P1 Q1 V1=P1-Q1 BS C1Own shares P2 Q2 V2=P2-Q2 BS C1LiabilitiesDerivatives P3 Q3 V3=P3-Q3 BS C1Financial liabilities other than debts owed to credit institutions P4 Q4 V4=P4-Q4 BS C1Subordinated liabilities (whether or not in BOF) P5 Q5 V5=P5-Q5 BS C1

Analysis of movements affecting Excess of Assets over Liabilities

Of which movements in valuation with an impact on Excess of Assets over Liabilities

Valuation movements on investments incl. On sales and acquisitions

Valuation movements on own shares incl. On sales and acquisitions

Valuation movements on financial liabilities and subordinated liabilities

Of which Investments revenues and expenses with an impact on Excess of Assets over LiabilitiesInvestment revenues AA1=A4

AA2

Variation in Excess of Assets over Liabilities explained by Investments and financial liabilities management check VA C2A

Detail of Investment revenues

Dividends A1 link with Asset D3Interests A2 link with Asset D3Rents A3 link with Asset D3Total Investment Revenues A4=sum(A1:A3)

Cell used more than once in one single

template Cell reported in a different template

O4

O4A

O4B

Investments expenses incl. Interest charges on subordinated and financial liabilities

AA3 = O4+O4A-O4B-AA2

Page 37: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

C2C

Analysis of changes due to technical provisions Cell not relevant Formula

OverviewReconciliation with BS C1

Year N Year N-1 VarLiabilities TP calculated as a whole - Life N1 O1 V1=N1-O1 BS C1 Best Estimate - Life N2 O2 V2=N2-O2 BS C1 Risk margin - Life N3 O3 V3=N3-O3 BS C1 TP calculated as a whole - Non Life N4 O4 V4=N4-O4 BS C1 Best Estimate - Non Life N5 O5 V5=N5-O5 BS C1 Risk margin - Non Life N6 O6 V6=N6-O6 BS C1AssetsAssets held for index-linked and unit-linked funds N7 O7 V7=N7-O7 BS C1Reinsurance recoverables - Life N8 O8 V8=N8-O8 BS C1Reinsurance recoverables - Non Life N9 O9 V9=N9-O9 BS C1

Analysis of movements affecting Excess of Assets over LiabilitiesOf which the following breakdown of Variation in Best Estimate - analysis per UWY if applicable

LIFE NON LIFE

Gross of reinsurance Gross of reinsurance

Opening Best estimate A1 B1 C1 D1Exceptional elements triggering restating of opening BE A2 C2

Changes in perimeter A3 C3Foreign exchange variation A4 C4

BE on risk accepted during the period A5 C5Variation of BE due to unwinding of discount rate - risks accepted prior to period A6 C6

Variation of BE due to year N projected in and out flows - risks accepted prior to period A7 C7Variation of BE due to experience and other sources - risks accepted prior to period A8 C8

Variation of BE due to changes in non economic assumptions - risks accepted prior to period A9 C9

Variation of BE due to changes in economic environment - risks accepted prior to period A10 C10Closing Best Estimate A11=sum(A1:A10) B2 C11=sum(C1:C10) D2

Of which the following breakdown of Variation in Best Estimate - analysis per AY if applicableLIFE NON LIFE

Gross of reinsurance Gross of reinsurance

Opening Best estimate AA1 BB1 CC1 DD1Exceptional elements triggering restating of opening BE AA2 CC2

Changes in perimeter AA3 CC3Foreign exchange variation AA4 CC4

Variation of BE on risk covered after the period AA5 CC5Variation of BE on risks covered during the period AA6 CC6

Variation of BE due to unwinding of discount rate - risks covered prior to period AA7 CC7Variation of BE due to year N projected in and out flows - risks covered prior to period AA8 CC8

Variation of BE due to experience and other sources - risks covered prior to period AA9 CC9

Variation of BE due to changes in non economic assumptions - risks covered prior to period AA10 CC10

Variation of BE due to changes in economic environment - risks covered prior to period AA11 CC11Closing Best Estimate AA12=sum(AA1:AA11) BB2 CC12=sum(CC1:CC11) DD2

Of which adjustments in Technical Provisions related to valuation of Unit linked contracts, with theoretically a neutralizing impact on Assets over LiabilitiesLIFE

Variation in Investments in U-L U1=V7

Technical flows affecting Technical provisions LIFE NON LIFEPremiums written during the period CF1L from Cover A1 CF1NL from Cover A1

Claims & benefits during the period, net of salvages and subrogations CF2L* *from Cover A1 adjusted from S&S CF2NL* *from Cover A1 adjusted from S&SExpenses (excl Investment expenses) CF3L from Cover A1 CF3NL from Cover A1

TOTAL TECHNICAL FLOWS ON GROSS TECHNICAL PROVISIONS CF5L= CF1L-CF2L-CF3L CF5NL= CF1NL-CF2NL-CF3NLTechnical flows related to reinsurance during the period (recoverables received net of premiums paid) CF4L from Cover A1 CF4NL from Cover A1

Variation in Excess of Assets over Liabilities explained by Technical provisionsLIFE NON LIFE

Gross TP Gross TP AA5NL = - (V4+V5+V6-CF5NL)

Reinsurance recoverables AA6L= V8 + CF4L AA6NL= V9+VF4NL

Detailed analysis per period - Technical flows versus Technical provisions - UWY

A0A

Written premiums on contract underwritten during period UW1 UW12Claims & benefits - net of salvages and subrogations recovered UW2 UW13Expenses (related to insurance & reinsurance obligations) UW3 UW14BE on risk accepted during the period UW4=A5

UW15=A8TP as a whole on risks accepted during the period UW5Variation of TP as a whole on risks accepted prior to period UW16Adjustment of valuation of Assets held for unit-linked funds UW6 UW17

Total

Detailed analysis per period - Technical flows versus Technical provisions - AY

A0A

Premiums earned AY11 AY22Unearned premiums AY1Claims & benefits - net of salvages and subrogations recovered AY2 AY12 AY23Expenses (related to insurance & reinsurance obligations) AY3 AY13 AY24Variation of BE (gross of reinsurance) AY4=AA5 AY14 =AA6

AY25 =AA9Variation of TP as a whole AY15 AY26Adjustment of valuation of Assets held for unit-linked funds AY5 AY16 AY27

Cell used more than once in one single template

Cell reported in a different template

BE of reinsurance recoverables

BE of reinsurance recoverables

BE of reinsurance recoverables

BE of reinsurance recoverables

AA5L = - (V1+V2+V3 -V7-CF5L)

Reinsurance recoverables

Line of business

Risks accepted during period

Risks accepted prior to period

Variation of BE due to experience and other sources on risks accepted prior to period (gross of reinsurance)

UW7=UW1-UW2-UW3-UW4-UW5+UW6

UW18=UW12-UW13-UW14-UW15-UW16+UW17

Line of business

Risks covered after the period

Risks covered during the period

Risks covered prior to period

Variation of BE due to experience and other sources on risks covered prior to period (gross of reinsurance)

Total AY6=AY1-AY2-AY3-AY4+AY5

AY17=AY11-AY12-AY13-AY14-AY15+AY16

AY28=AY22-AY23-AY24-AY25-AY26+AY27

Page 38: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B2ASolvency Capital Requirement - for undertakings on Standard Formula or Partial Internal Models

Cell not relevant Formula

A1 B1

A2 B2

A3 B3

Health underwriting risk A4

Non-life underwriting risk A5 B5=A5

Diversification A6 B6

Intangible asset risk A7 B7=A7

A8 B8

A9 B9

Basic Solvency Capital Requirement A10 = sum(A1…A9) B10 = Sum (B1….B9)

Loss-absorbing capacity of technical provisions

Loss-absorbing capacity of deferred taxes A12

Operational risk A13

A14

Diversification within ring fenced funds A14A

A15= A15A+A15B+A15C

Credit institution & investment firms and financial institutions

A15A

Institutions for occupational retirement provisionA15B

Non regulated entities carrying out financial activties A15C

Non-controlled participation requirements (groups only) A16

A17

Solvency capital requirement, excluding capital add-on

Capital add-ons already set A19

Solvency Capital Requirement

Solvency capital requirement floor (groups only) A21

Cell used more than once in one single template

Cell reported in a different

template

Net solvency capital requirement (including the loss-absorbing capacity of

technical provisions)

Gross solvency capital requirement (excluding the loss-absorbing capacity of

technical provisions)

Market risk Counterparty default risk

Life underwriting riskB4=A4

Remaining part of the Solvency Capital Requirement calculated using partial internal model

Diversification (between Standard Formula and Partial Internal Model components)

A11=-max (min(B10-A10;FDB);0)

Notional Solvency Capital Requirement for ring fenced funds (other than those referred to in cell A17)

Capital requirements of other financial sectors (Non-insurance capital requirements) (groups only):

Capital requirement for business operated in accordance with Art. 4 of Directive 2003/41/EC (transitional)

A18 = A10+A11+A12+A13+A14+A14A+A1

5+A16+A17

A20 = A18+A19

Page 39: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B2B Solvency Capital Requirement - for undertakings on Partial Internal Models

Cell not relevant

Components in descending order of sizeA1.1 A1A.1 B1.1 C1.1

A1.n A1A.n B1.n C1.n

Total undiversified components B2=sum(B1.1:B1.n) C2=sum(C1.1:C1.n)

Diversification B3 C3

B4=B2+B3 C4=C2+C3

Loss-absorbing capacity of technical provisionsB5

Loss absorbing capacity for deferred taxes B6 C6

B7=B4+ B5+B6

Cell used more than once in one single template

Unique number of component

Net solvency capital requirement (including the loss absorbing

capacity of technical provisions and/or deferred taxes when

applicable)

Gross solvency capital requirement (excluding the loss-absorbing

capacity of technical provisions and/or deferred taxes when

applicable)

Solvency capital requirement calculated using partial internal model before adjustments

C5 = if(B5<>0,0,max (min(C4-B4-C6;FDB);0))

Solvency capital requirement calculated using partial internal model

Page 40: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

For information only:B8

Diversification within ring fenced funds B8A

Date of formal approval of partial internal model B9

Notional Solvency Capital Requirement for ring fenced funds

Page 41: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

FormulaCell reported in a different template

Page 42: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B2CSolvency Capital Requirement - for undertakings on Full Internal Models

Cell not relevant Formula

Components in descending order of sizeA1.1 A1A.1 B1.1 C1.1

A1.n A1A.n B1.n C1.n

Total undiversified components C2=sum(C1.1:C1.n)

Diversification B3 C3

B4=B2+B3 C4=C2+C3

Loss-absorbing capacity of technical provisions

B5

Loss absorbing capacity for deferred taxes B6C6

B7 = B7A+ B7B+B7C

Credit institution & investment firms and financial institutions B7A

Institutions for occupational retirement provision B7B

Non regulated entities carrying out financial activties B7C

Non-controlled participations requirements (groups only): B8

B9

Capital add-ons B11

B12 = B10 + B11

Solvency capital requirement floor (groups only)B13

For information only:

B14

Diversification within ring fenced funds B14A

Date of formal approval of internal model B15

Cell used more than once in one single template

Cell reported in a different template

Unique number of component

Net solvency capital requirement (including the loss absorbing capacity of technical provisions and/or

deferred taxes when applicable)

Gross solvency capital requirement (excluding the loss-absorbing

capacity of technical provisions and/or deferred taxes when

applicable)

B2=sum B1.1:B1.n

Solvency capital requirement calculated using full internal model before adjustments

C5 = if(B5<>0,0,max (min(C4-B4-C6;FDB);0))

Capital requirements of other financial sectors (Non-insurance capital requirements) (groups only):

Capital requirement for business operated in accordance with Art. 4 of Directive 2003/41/EC (transitional)

Solvency capital requirement calculated using full internal model, excluding capital add - on

B10 =B4 + B5 + B6 + B7+B8+ B9

Solvency capital requirement calculated using full internal model

Notional Solvency Capital Requirement for ring fenced funds

Page 43: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3A

Solvency Capital Requirement - Market riskFormula

Market risk - basic informationInitial absolute values before shock Absolute values after shock

Assets Liabilities Assets

Interest rate risk C0=sum(C1:C2) D0=sum(D1:D2)

interest rate down shock

A1 A1A B1 B1A B1B

interest rate up shock

A2=A1 A2A=A1A B2 B2A B2B

39

Equity risk

type 1 equities

A4A B4A B4B

type 1 equity A5 B5

strategic participations (type 1 equities) A6 B6

duration-based (type 1 equities) A7 B7

type 2 equities

A8A B8A B8B

type 2 equity A9 B9

strategic participations (type 2 equities) A10 B10

duration-based (type 2 equities) A11 B11

Property risk

A12 A12A B12 B12A B12B

Spread risk

bonds and loans

A14 A14A B14 B14A B14B

credit derivatives

downward shock on credit derivatives

A16 A16A B16 B16A B16B

upward shock on credit derivatives

A17 A17A B17 B17A B17B

A18 A18A B18 B18A B18B

Market risk concentrations A19 A19A C19 D19

Currency risk A20 A20A C20 D20

Counter-cyclical premium risk

A21 A21A B21 B21A B21B

Diversification within module C22 D22

Total capital requirement for market risk C23 D23

Cell not relevant

Cell used more than once in one single

template

Cell reported in a different template

Liabilities (including the

loss absorbing capacity of technical

provisions)

Net solvency capital requirement (including the loss-absorbing

capacity of technical provisions) Liabilities (excluding the loss-absorbing

capacity of technical

provisions)

Gross solvency capital requirement (excluding the loss-absorbing capacity of

technical provisions)

C1 = (A1 – B1) – (A1A- B1A) D1 = (A1 – B1) – (A1A - B1B)

C2 = (A2 – B2) – (A2A - B2A) D2 = (A2 – B2) – (A2A - B2B)

C3 = (C4²+2*0.75*C4*C8+C8²) º^0.5, C3 >/= 0

D3 = (D4²+2*0.75*D4*D8+D8²) º^0.5, D3 >/= 0

A4=sum(A5:A7) B4=sum(B5:B7) C4 = (A4 – B4) – (A4A- B4A), C4 >/= 0

D4 = (A4 – B4) – (A4A- B4B), D4 >/= 0.

A8=sum(A9:A11) B8=sum(B9:B11) C8 = (A8 – B8) – (A8A - B8A), C8 >/= 0.

D8 = (A8 – B8) – (A8A - B8B), D8 >/= 0

C12 = (A12 – B12) – (A12A - B12A), C12 >/= 0.

D12 = (A12 – B12) – (A12A - B12B), D12 >/= 0

C13 = (C14+C15+C18), C13 >/= 0 D13 = (D14+D15+D18), D13 >/= 0.

C14 = (A14 – B14) – (A14A- B14A), C14 >/= 0.

D14 = (A14 – B14) – (A14A - B14B), D14 >/= 0

C15 >/= 0, if C16>C17, C15=C16, if C16<C17, C15=C17

D15 >/= 0, ) If C16>C17, D15=D16; If C17> C16, D15=

C16 = (A16 – B16) – (A16A - B16A), C16 >/= 0

D16 = (A16 – B16) – (A16A - B16B), D16 >/= 0.

C17 = (A17 – B17) – (A17A - B17A) ,C17 >/= 0

D17 = (A17 – B17) – (A17A - B17B), D17 >/= 0.

tradable securities or other financial instruments based on repackaged loans

C18 = (A18 – B18) – (A18A - B18A), C18 >/= 0

D18 = (A18 – B18) – (A18A - B18B), D18 >/= 0

C21 = (A21 – B21) – (A21A - B21A), C21 >/= 0.

D21 = (A21 – B21) – (A21A - B21B), D21 >/= 0.

Page 44: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3B

Solvency Capital Requirement - Counterparty default riskCell not relevant

Loss Given Default Probability of Default

Type 1 exposures C0

Single name exposure 1 A0.1 B0.1

Single name exposure 2 A0.2 B0.2

… … …

Single name exposure 10 A0.10 B0.10

Type 2 exposures C1= 0.9*A2 + 0.15*A3

A2

A3

Diversification within module C3=C4-(C0+C1)

Cell used more than once in one single template

Counterparty default risk - basic information

Gross solvency capital requirement (excluding the loss-absorbing capacity of

technical provisions)

Receivables from Intermediaries due for more than 3 months

All type 2 exposures other than receivables from Intermediaries due for more than 3 months

Total capital requirement for counterparty default risk C4 = √CO² + 1.5 C0*C1 + C1²

Page 45: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Formula

D4

Cell reported in a different template

Net solvency capital requirement (including the loss-absorbing capacity of

technical provisions)

Page 46: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3C

Solvency Capital Requirement - Life underwriting riskCell not relevant Formula

Life underwriting risk - basic informationAbsolute values after shock

Assets Liabilities Assets

Mortality riskA1 A1A B1 B1A C1= (A1-A1A)-(B1-B1A), C1>=0 B1B

Longevity riskA2 A2A B2 B2A B2B

Disability-morbidity riskA3 A3A B3 B3A B3B

Lapse riskC04= Max (C4, C5, C6)

risk of increase in lapse rates A4 A4A B4 B4A B4B

risk of decrease in lapse ratesA5 A5A B5 B5A B5B

mass lapse riskA6 A6A B6 B6A B6B

Life expense riskA7 A7A B7 B7A B7B

Revision riskA8 A8A B8 B8A B8B

A9 A9A B9 B9A B9B

Diversification within module

Total capital requirement for life underwriting risk C11 D11

Further details on revision risk USPFactor applied for the revision shock A12

Cell used more than once in one single template

Cell reported in a different template

Initial absolute values before shock

Liabilities (including the

loss absorbing capacity of technical

provisions)

Net solvency capital requirement (including

the loss-absorbing capacity of technical

provisions)

Liabilities (excluding the loss-absorbing capacity

of technical provisions)

Gross solvency capital requirement (excluding the loss-absorbing capacity of

technical provisions)

D1= (A1-A1A)-(B1-B1B), D1>=0

C2= (A2-A2A)-(B2-B2A), C2>=0.

D2= (A2-A2A)-(B2-B2B) , D2>=0.

C3= (A3-A3A)-(B3-B3A), C3>=0

D3= (A3-A3A)-(B3-B3B), D3>=0.

D04 = IF (C04 = C4, D4, IF (C04 = C5, D5, D6))

C4= (A4-A4A)-(B4-B4A), C4>=0.

D4= (A4-A4A)-(B4-B4B), D4>=0

C5= (A5-A5A)-(B5-B5A), C5>=0.

D5= (A5-A5A)-(B5-B5B), D5>=0.

C6 = (A6-A6A)-(B6-B6A), C6 >=0.

D6 = (A6-A6A)-(B6-B6B), D6>=0.

C7 = (A7-A7A)-(B7-B7A), C7>=0.

D7 = (A7-A7A)-(B7-B7B), D7>=0.

C8 = (A8-A8A)-(B8-B8A), C8>=0.

D8 = (A8-A8A)-(B8-B8B), D8>=0.

Life catastrophe riskC9 = (A9-A9A)-(B9-B9A),

C9>=0.D9 = (A9-A9A)-(B9-B9B),

D9>=0.

C10 = C11 – C1 – C2 – C3 – C04 – C7 – C8 – C9

D10 = D11 – D1 – D2 – D3 – D04 – D7 – D8 – D9

Page 47: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3D

Solvency Capital Requirement - Health underwriting riskFormula

SLT health underwriting risk - basic informationInitial absolute values before shock Absolute values after shock

Assets Liabilities Assets

Health mortality risk A1 A1A B1 B1A C1= (A1-A1A)-(B1-B1A), C1>=0 B1B D1= (A1-A1A)-(B1-B1B), D1>=0

Health longevity riskA2 A2A B2 B2A B2B D2= (A2-A2A)-(B2-B2B) , D2>=0.

Health disability-morbidity riskA3 A3A B3 B3A B3B D3= (A3-A3A)-(B3-B3B), D3>=0.

SLT health lapse riskC04= Max (C4, C5, C6)

risk of increase in lapse ratesA4 A4A B4 B4A B4B D4= (A4-A4A)-(B4-B4B), D4>=0

risk of decrease in lapse ratesA5 A5A B5 B5A B5B D5= (A5-A5A)-(B5-B5B), D5>=0.

mass lapse riskA6 A6A B6 B6A B6B D6 = (A6-A6A)-(B6-B6B), D6>=0.

Health expense riskA7 A7A B7 B7A B7B D7 = (A7-A7A)-(B7-B7B), D7>=0.

Health revision riskA8 A8A B8 B8A B8B D8 = (A8-A8A)-(B8-B8B), D8>=0.

Diversification within SLT health underwriting risk

Total capital requirement for SLT health underwriting risk C10 D10

Further details on revision risk USPFactor applied for the revision shock A11

Standard deviation for premium risk Volume measure for premium and reserve risk

USP V

Medical expenses insurance and proportional reinsurance A12 A12A B12 C12 D12 E12 F12= (C12 + D12) x (0.75 + 0.25E12)Income protection insurance and proportional reinsurance A13 A13A B13 C13 D13 E13 F13= (C13 + D13) x (0.75 + 0.25E13)Worker's compensation insurance and proportional reinsurance A14 A14A B14 C14 D14 E14 F14= (C14 + D14) x (0.75 + 0.25E14)Non-proportional health reinsurance A15 A15A B15 C15 D15 E15 F15= (C15 + D15) x (0.75 + 0.25E15)

Total Volume measure F16=sum(F12:F15)Combined standard deviation A16

Total NSLT health premium and reserve risk A17

Initial absolute values before shock Absolute values after shock

Assets Liabilities Assets

NSLT health lapse riskA18 A18A B18 B18A B18B

Diversification within NSLT health underwriting risk C19 D19

Total NSLT health underwriting risk C20 D20

Health catastrophe risk - basic information

Mass accident risk A21

Accident concentration risk A22

Pandemic risk A23

Diversification within health catastrophe risk A24

Total capital requirement for health catastrophe risk A25

A27

Cell not relevant

Cell used more than once in one single template

Cell reported in a different template

Liabilities (including the loss absorbing capacity of technical provisions)

Net solvency capital requirement (including the loss-absorbing capacity of

technical provisions)

Liabilities (excluding the loss-absorbing

capacity of technical provisions)

Gross solvency capital requirement (excluding the loss-absorbing

capacity of technical provisions)

C2= (A2-A2A)-(B2-B2A), C2>=0.

C3= (A3-A3A)-(B3-B3A), C3>=0

D04 = IF (C04 = C4, D4, IF (C04 = C5, D5, D6))

C4= (A4-A4A)-(B4-B4A), C4>=0.

C5= (A5-A5A)-(B5-B5A), C5>=0.

C6 = (A6-A6A)-(B6-B6A), C6 >=0.

C7 = (A7-A7A)-(B7-B7A), C7>=0.

C8 = (A8-A8A)-(B8-B8A), C8>=0.

C9 = C10 – C1 – C2 – C3 – C04 – C7 – C8

D9 = D10 – D1 – D2 – D3 – D04 – D7 – D8

Standard deviation for reserve risk

NSLT Health premium and reserve risk - basic information

USP Standard Deviation

USPAdjustment

factor for non-proportional reinsurance

Vprem VresGeographical

Diversification

Liabilities (including the loss-absorbing capacity of technical provisions)

Net solvency capital requirement (including the loss-absorbing capacity of

technical provisions)

Liabilities (excluding the loss-absorbing

capacity of technical provisions)

Gross solvency capital requirement (excluding the loss-absorbing

capacity of technical provisions)

C18 = (A18-A18A)-(B18-B18A), C18>=0.

D18 = (A18-A18A)-(B18-B18B), D18>=0

Diversification within health underwriting risk module (Net)A26 =SUM(C10, C20,

A25) - A27

Total capital requirement for health underwriting risk (Net)

Page 48: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3E

Solvency Capital Requirement - Non-life underwriting riskCell not relevant Formula

Non-life underwriting risk

Standard deviation for premium risk Volume measure for premium and reserve risk

Premium and reserve Risk - Basic information

USP V

Motor vehicle liability A1 A1A B1 C1 D1 E1 F1= (C1 + D1) x (0.75 + 0.25E1)Motor, other classes A2 A2A B2 C2 D2 E2 F2= (C2 + D2) x (0.75 + 0.25E2)Marine, aviation, transport (MAT) A3 A3A B3 C3 D3 E3 F3= (C3 + D3) x (0.75 + 0.25E3)Fire and other property damage A4 A4A B4 C4 D4 E4 F4= (C4 + D4) x (0.75 + 0.25E4)Third-party liability A5 A5A B5 C5 D5 E5 F5= (C5 + D5) x (0.75 + 0.25E5)Credit and suretyship A6 A6A B6 C6 D6 E6 F6= (C6 + D6) x (0.75 + 0.25E6Legal expenses A7 A7A B7 C7 D7 E7 F7= (C7 + D7) x (0.75 + 0.25E7)Assistance A8 A8A B8 C8 D8 E8 F8= (C8 + D8) x (0.75 + 0.25E8)Miscellaneous A9 A9A B9 C9 D9 E9 F9= (C9 + D9) x (0.75 + 0.25E9)Non-proportional reinsurance - property A10 A10A B10 C10 D10 E10 F10= (C10 + D10) x (0.75 + 0.25E10)Non-proportional reinsurance - casualty A11 A11A B11 C11 D11 E11 F11= (C11 + D11) x (0.75 + 0.25E11)Non-proportional reinsurance - MAT A12 A12A B12 C12 D12 E12 F12= (C12 + D12) x (0.75 + 0.25E12)

Total Volume measure F13=sum(F1:F12)

Combined standard deviation A13

Total non-life premium and reserve risk A14

Non-Life lapse riskInitial absolute values before shock Absolute values after shock

Assets Liabilities Assets Liabilities

Non-life lapse risk A15 A15A B15 B15A C15

Non-life catastrophe risk A16

Diversification within module

A18

Cell used more than once in one single

template

Cell reported in a different template

Standard deviation for reserve risk

USPStandard Deviation

USP Adjustment factor

for non-proportional reinsurance

Vprem VresGeographical Diversification

Solvency capital requirement

A17=A18-C15-A16-A14

Total capital requirement for non-life underwriting risk

Page 49: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3F

Solvency Capital Requirement - Non-life catastrophe riskCell not relevant Formula

Non-life catastrophe risk - Summary Gross SCR Total risk mitigation Net SCRNatural catastrophe risk A1 B1=A1-C1 C1 Windstorm A2=AF39 B2=A2-C2 C2=AI39 Earthquake A3=BE39 B3=A3-C3 C3=BH39 Flood A4=CF33 B4=A4-C4 C4=CI33 Hail A5=DF28 B5=A5-C5 C5=DI28 Subsidence A6=EE3 B6=A6-C6 C6=EH3 Diversification between perils A7=SUM(A2:A6)-A1 B7=A7-C7 C7=SUM(C2:C6)-C1

Catastrophe risk non-proportional property reinsurance A8=FB1 B8=A8-C8 C8=FE1

Man-made catastrophe risk A9 B9=A9-C9 C9 Motor vehicle liability A10=GA3 B10=A10-C10 C10=GA6 Marine A11=HC3 B11=A11-C11 C11=HC5 Aviation A12=IC1 B12=A12-C12 C12=IF1 Fire A13=JA1 B13=A13-C13 C13=JA4 Liability A14=KC8 B14=A14-C14 C14=KC10 Credit & Suretyship A15=LC12 B15=A15-C15 C15=LC14 Diversification between perils A16=SUM(A10:A15)-A9 B16=A16-C16 C16=SUM(C10:C15)-C9

Other non-life catastrophe risk A17 B17=A17-C17 C17 Diversification between perils A18=MG2 B18=A18-C18 C18=MG4

Total Non-life catastrophe risk before diversification A19=A1+A8+A9+A17 B19=A19-C19 C19=C1+C8+C9+C17 Diversification between sub-modules A20=A19-A21 B20=A20-C20 C20=C19-C21 Total Non-life catastrophe risk after diversification A21 B21=A21-C21 C21

Health catastrophe risk - Summary Gross SCR Total risk mitigation Net SCRHealth catastrophe risk A22 B22=A22-C22 C22 Mass accident A23=NK34 B23=A23-C23 C23=NN34 Accident concentration A24=OG18 B24=A24-C24 C24=OJ18 Pandemic A25=PJ21 B25=A25-C25 C25=PM21 Diversification between sub-modules A26=SUM(A23:A25)-A27 B26=A26-C26 C26=SUM(C23:C25)-C27

Natural Catastrophe risk - Windstorm Exposure Specified Gross Loss Scenario A or B Estimated Risk MitigationEEA Region 1 AA1 AB1 AC1 AD1=AC1/AB1 AE1 AF1 AG1 AH1 AI1=AF1-AG1+AH1 EEA Region 2 AA2 AB2 AC2 AD2=AC2/AB2 AE2 AF2 AG2 AH2 AI2=AF2-AG2+AH2 EEA Region 3 AA3 AB3 AC3 AD3=AC3/AB3 AE3 AF3 AG3 AH3 AI3=AF3-AG3+AH3

EEA Region 20 AA20 AB20 AC20 AD20=AC20/AB20 AE20 AF20 AG20 AH20 AI20=AF20-AG20+AH20 Total Windstorm EEA Regions before diversification AA21=SUM(AA1:AA20) AB21=SUM(AB1:AB20) AC21=SUM(AC1:AC20) AD21=AC21/AB21 AF21=SUM(AF1:AF20) AG21=SUM(AG1:AG20) AH21=SUM(AH1:AH20) AI21=SUM(AI1:AI20) Other Regions 1 AA22 AB22Other Regions 2 AA18 AB18

Other Regions 3 AA24 AB24Other Regions 14 AA35 AB35

Total Windstorm Other Regions before diversifications AA36=SUM(AA22:AA35) AB36=SUM(AB22:AB35) AF36 AG36 AH36 AI36=AF36-AG36+AH36 Total Windstorm all Regions before diversification AA37=AA21+AA36 AB37=AB21+AB36 AF37=AF21+AF36 AG37=AG21+AG36 AH37=AH21+AH36 AI37=AI21+AI36Diversification effect between regions AF38=AF37-AF39 AI38=AI37-AI39Total Windstorm after diversification AF39 AI39

Natural Catastrophe risk - Earthquake Exposure Specified Gross Loss Estimated Risk MitigationEEA Region 1 BA1 BB1 BC1 BD1=BC1/BB1 BE1 BF1 BG1 BH1=BE1-BF1+BG1 EEA Region 2 BA2 BB2 BC2 BD2=BC2/BB2 BE2 BF2 BG2 BH2=BE2-BF2+BG2 EEA Region 3 BA3 BB3 BC3 BD3=BC3/BB3 BE3 BF3 BG3 BH3=BE3-BF3+BG3 EEA Region 20 BA20 BB20 BC20 BD20=BC20/BB20 BE20 BF20 BG20 BH20=BE20-BF20+BG20 Total Earthquake EEA Regions before diversification BA21=SUM(BA1:BA20) BB21=SUM(BB1:BB20) BC21=SUM(BC1:BC20) BD21=BC21/BB21 BE21=SUM(BE1:BE20) BF21=SUM(BF1:BF20) BG21=SUM(BG1:BG20) BH21=SUM(BH1:BH20) Other Regions 1 BA22 BB22Other Regions 2 BA18 BB18Other Regions 3 BA24 BB24Other Regions 14 BA35 BB35Total Earthquake Other Regions before diversifications BA36=SUM(BA22:BA35) BB36=SUM(BB22:BB35) BE36 BF36 BG36 BH36=BE36-BF36+BG36 Total Earthquake all Regions before diversification BA37=BA21+BA36 BB37=BB21+BB36 BE37=BE21+BE36 BF37=BF21+BF36 BG37=BG21+BG36 BH37=BH21+BH36Diversification effect between regions BE38=BE37-BE39 BH38=BH37-BH39Total Earthquake after diversification BE39 BH39

Natural Catastrophe risk - Flood Exposure Specified Gross Loss Scenario A or B Estimated Risk MitigationEEA Region 1 CA1 CB1 CC1 CD1=CC1/CB1 CE1 CF1 CG1 CH1 CI1=CF1-CG1+CH1 EEA Region 2 CA2 CB2 CC2 CD2=CC2/CB2 CE2 CF2 CG2 CH2 CI2=CF2-CG2+CH2 EEA Region 3 CA3 CB3 CC3 CD3=CC3/CB3 CE3 CF3 CG3 CH3 CI3=CF3-CG3+CH3 EEA Region 14 CA14 CB14 CC14 CD14=CC14/CB14 CE14 CF14 CG14 CH14 CI14=CF14-CG14+CH14 Total Flood EEA Regions before diversification CA15=SUM(CA1:CA14) CB15=SUM(CB1:CB14) CC15=SUM(CC1:CC14) CD15=CC15/CB15 CF15=SUM(CF1:CF14) CG15=SUM(CG1:CG14) CH15=SUM(CH1:CH14) CI15=SUM(CI1:CI14) Other Regions 1 CA16 CB16Other Regions 2 CA17 CB17Other Regions 3 CA18 CB18Other Regions 14 CA29 CB29Total Flood Other Regions before diversifications CA30=SUM(CA16:CA29) CB30=SUM(CB16:CB29) CF30 CG30 CH30 CI30=CF30-CG30+CH30 Total Flood all Regions before diversification CA31=CA15+CA30 CB31=CB15+CB30 CF31=CF15+CF30 CG31=CG15+CG30 CH31=CH15+CH30 CI31=CI15+CI30Diversification effect between regions CF32=CF31-CF33 CI32=CI31-CI33Total Flood after diversification CF33 CI33

Natural Catastrophe risk - Hail Exposure Specified Gross Loss Scenario A or B Estimated Risk MitigationEEA Region 1 DA1 DB1 DC1 DD1=DC1/DB1 DE1 DF1 DG1 DH1 DI1=DF1-DG1+DH1 EEA Region 2 DA2 DB2 DC2 DD2=DC2/DB2 DE2 DF2 DG2 DH2 DI2=DF2-DG2+DH2 EEA Region 3 DA3 DB3 DC3 DD3=DC3/DB3 DE3 DF3 DG3 DH3 DI3=DF3-DG3+DH3 EEA Region 9 DA9 DB9 DC9 DD9=DC9/DB9 DE9 DF9 DG9 DH9 DI9=DF9-DG9+DH9 Total Hail EEA Regions before diversification DA10=SUM(DA1:DA9) DB10=SUM(DB1:DB9) DC10=SUM(DC1:DC9) DD10=DC10/DB10 DF10=SUM(DF1:DF9) DG10=SUM(DG1:DG9) DH10=SUM(DH1:DH9) DI10=SUM(DI1:DI9) Other Regions 1 DA11 DB11Other Regions 2 DA12 DB12Other Regions 3 DA13 DB13Other Regions 14 DA24 DB24Total Hail Other Regions before diversifications DA25=SUM(DA11:DA24) DB25=SUM(DB11:DB24) DF25 DG25 DH25 DI25=DF25-DG25+DH25 Total Hail all Regions before diversification DA26=DA10+DA25 DB26=DB10+DB25 DF26=DF10+DF25 DG26=DG10+DG25 DH26=DH10+DH25 DI26=DI10+DI25Diversification effect between regions DF27=DF26-DF28 DI27=DI26-DI28Total Hail after diversification DF28 DI28

Natural Catastrophe risk -Subsidence Exposure Specified Gross Loss Estimated Risk MitigationTotal Subsidence before diversification EA1 EB1 EC1 ED1=EC1/EB1 EE1=EC1 EF1 EG1 EH1=EE1-EF1+EG1 Diversification effect between zones EE2=EE1-EE3 EH2=EH1-EH3 Total Subsidence after diversification EE3 EH3

Natural Catastrophe risk - Non-proportional property reinsurance Estimated Risk MitigationNon-proportional property reinsurance FA1 FB1 FC1 FD1 FE1=FB1-FC1+FD1

Man made catastrophe risk - Motor Vehicle Liability TotalNumber of vehicles policy limit above 24M€ GA1Number of vehicles policy limit below or equal to 24M€ GA2Gross Cat Risk Charge Motor Vehicle Liability GA3Estimated Risk Mitigation GA4Estimated Reinstatement Premiums GA5Net Cat Risk Charge Motor Vehicle Liability GA6=GA3-GA4+GA5

Man made catastrophe risk - Marine Tanker Collision Estimated Risk Mitigation Name vesselMarine Tanker Collision HA1 HB1 HC1 HD1=SUM(HA1:HC1) HE1 HF1 HG1=HD1-HE1+HF1 HH1

Man made catastrophe risk - Marine Platform Explosion Estimated Risk Mitigation Name platformMarine Platform Explosion HA2 HB2 HC2 HD2 HE2 HF2=SUM(HA2:HE2) HG2 HH2 HI2=HF2-HG2+HH2 HJ2

Man made catastrophe risk - Marine Total after diversificationGross Cat Risk Charge Marine HA3=HD1+HF2 HB3=HA3-HC3 HC3Estimated Total Risk Mitigation HA4=HA3-HA5 HB4=HA4-HC4 HC4=HC3-HC5Net Cat Risk Charge Marine HA5=HG1+HI2 HB5=HA5-HC5 HC5

Man made catastrophe risk - Aviation Estimated Risk MitigationGross Cat Risk Charge Aviation IA1 IB1 IC1=IA1+IB1 ID1 IE1 IF1=IC1-ID1+IE1

Man made catastrophe risk - Fire TotalGross Cat Risk Charge Fire JA1Estimated Risk Mitigation JA2Estimated Reinstatement Premiums JA3Net Cat Risk Charge Fire JA4=JA1-JA2+JA3

Man made catastrophe risk - Liability Employers liability Other liability TotalEarned premium last 12 months KA1 KB1 KC1 KD1 KE1 KF1=SUM(KA1:KE1)Largest liability limit provided KA2 KB2 KC2 KD2 KE2Number of claims KA3 KB3 KC3 KD3 KE3

Gross Cat Risk Charge Liability KA4 KB4 KC4 KD4 KE4 KF4=SUM(KA4:KE4)Estimated Risk Mitigation KA5 KB5 KC5 KD5 KE5 KF5=SUM(KA5:KE5)Estimated Reinstatement Premiums KA6 KB6 KC6 KD6 KE6 KF6=SUM(KA6:KE6)Net Cat Risk Charge Liability KA7=KA4-KA5+KA6 KB7=KB4-KB5+KB6 KC7=KC4-KC5+KC6 KD7=KD4-KD5+KD6 KE7=KE4-KE5+KE6 KF7=SUM(KA7:KE7)

Man made catastrophe risk - Liability Total after diversificationGross Cat Risk Charge Liability KA8=KF4 KB8=KA8-KC8 KC8Estimated Total Risk Mitigation KA9=KF5+KF6 KB9=KA9-KC9 KC9=KC8-KC10Net Cat Risk Charge Liability KA10=KF7 KB10=KA10-KC10 KC10

Man made catastrophe risk - Credit & Suretyship - Large Credit Default Largest exposure 1 Largest exposure 2 TotalExposure (individual or group) LA1 LB1 LC1=LA1+LB1Proportion of damage caused by scenario LA2 LB2 LC2=LC3/LC1Gross Cat Risk Charge Credit & Surety - Large Credit Default LA3=LA1 x LA2 LB3=LB1 x LB2 LC3=LA3+LB3Estimated Risk Mitigation LA4 LB4 LC4=LA4+LB4Estimated Reinstatement Premiums LA5 LB5 LC5=LA5+LB5Net Cat Risk Charge Credit & Surety - Large Credit Default LA6=LA3-LA4+LA5 LB6=LB3-LB4+LB5 LC6=LA6+LB6

Man made catastrophe risk - Credit & Suretyship - Recession Risk TotalEarned premium last 12 months LA7 Gross Cat Risk Charge Credit & Suretyship - Recession Risk LA8 Estimated Risk Mitigation LA9Estimated Reinstatement Premiums LA10Net Cat Risk Charge Credit & Suretyship - Recession Risk LA11=LA8-LA9+LA10

Man made catastrophe risk - Credit & Suretyship Total after diversificationGross Cat Risk Charge Credit & Suretyship LA12=LC3+LA8 LB12=LA12-LC12 LC12Estimated Total Risk Mitigation LA13=LA12-LA14 LB13=LB12-LB14 LC13=LC12-LC14Net Cat Risk Charge Credit & Suretyship LA14=LC6+LA11 LB14=LA13-LC14 LC14

Man made catastrophe risk - Other non-life catastrophe risk Total after diversificationEstimation of the gross premiums to be earned MA1 MB1 MC1 MD1 ME1 Gross Cat Risk Charge Other non-life catastrophe risk MA2 MB2 MC2 MD2 ME2 MF2=SUM(MA2:ME2) MG2=MF2-MH2 MH2Estimated Total Risk Mitigation MF3 MG3=MG2-MG4 MH3=MH2-MH4Net Cat Risk Charge Other non-life catastrophe risk MF4 MG4=MF4-MH4 MH4

Health Catastrophe risk - Mass accident

Accidental death Accidental death Permanent disability Permanent disability Disability 10 years Disability 10 years Disability 12 months Disability 12 months Medical treatment Medical treatment

# Policyholders # Policyholders # Policyholders # Policyholders # Policyholders Net Catastrophe Risk ChargeCountry 1 NA1 NB1 NC1 ND1 NE1 NF1 NG1 NH1 NI1 NJ1 NK1 NL1 NM1 NN1=NK1-NL1+NM1 Country 2 NA2 NB2 NC2 ND2 NE2 NF2 NG2 NH2 NI2 NJ2 NK2 NL2 NM2 NN2=NK2-NL2+NM2 Country 3 NA3 NB3 NC3 ND3 NE3 NF3 NG3 NH3 NI3 NJ3 NK3 NL3 NM3 NN3=NK3-NL3+NM3 Country 31 NA31 NB31 NC31 ND31 NE31 NF31 NG31 NH31 NI31 NJ31 NK31 NL31 NM31 NN31=NK31-NL31+NM31 Total Mass accident all countries before diversification NK32=SUM(NK1:NK31) NL32=SUM(NL1:NL31) NM32=SUM(NL1:NL31) NN32=SUM(NN1:NN31)Diversification effect between countries NK33=NK32-NK34 NN33=NN32-NN34Total Mass accident all countries after diversification NK34 NN34

Health Catastrophe risk - Concentration accident

Accidental death Permanent disability Disability 10 years Disability 12 months Medical treatment

Average sum insured Average sum insured Average sum insured Average sum insured Average sum insured Estimated Risk MitigationCountry 1 OA1 OB1 OC1 OD1 OE1 OF1 OG1 OH1 OI1 OJ1=OG1-OH1+OI1 Country 2 OA2 OB2 OC2 OD2 OE2 OF2 OG2 OH2 OI2 OJ2=OG2-OH2+OI2 Country 3 OA3 OB3 OC3 OD3 OE3 OF3 OG3 OH3 OI3 OJ3=OG3-OH3+OI3 Country 20 OA20 OB20 OC20 OD20 OE20 OF20 OG20 OH20 OI20 OJ20=OG20-OH20+OI20 Total Concentration accident all countries before diversification OG21=SUM(OG1:OG20) OH21=SUM(OH1:OH20) OI21=SUM(OI1:OI20) OJ21=SUM(OJ1:OJ20)Diversification effect between countries OG22=OG21-OG18 OJ22=OJ21-OJ18Total Concentration accident all countries after diversification OG18 OJ18

Income protection Income protection Medical expense Medical expense Medical expense Medical expense Medical expense Medical expense Medical expense

Health Catastrophe risk - Pandemic Number of insured people Total pandemic exposure Number of insured people Net Catastrophe Risk ChargeCountry 1 PC1 PD1 PE1 PF1 PG1 PH1 PI1 PJ1 Country 2 PC2 PD2 PE2 PF2 PG2 PH2 PI2 PJ2 Country 3 PC3 PD3 PE3 PF3 PG3 PH3 PI3 PJ3 Country 20 PC20 PD20 PE20 PF20 PG20 PH20 PI20 PJ20 Total Pandemic all countries PA21 PB22 PJ21=SUM(PJ1:PJ20) PK21 PL21 PM21=PJ21-PK21+PL21

Cell used more than once in one single

template Cell reported in a different template

Estimation of the gross premiums to be earned

Gross Cat Risk Charge Factor

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Estimation of the gross premiums to be earned

Gross Cat Risk Charge Factor

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Estimation of the gross premiums to be earned

Gross Cat Risk Charge Factor

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Estimation of the gross premiums to be earned

Gross Cat Risk Charge Factor

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Estimation of the gross premiums to be earned

Gross Cat Risk Charge Factor

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Estimation of the premiums to be earned

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Gross Cat Risk Charge Share marine hull in

tanker t

Gross Cat Risk Charge Share marine liability in

tanker t

Gross Cat Risk Charge Share marine oil pollution

liability in tanker tGross Cat Risk Charge Marine Tanker Collision

Estimated Reinstatement Premiums

Net Cat Risk Charge Marine Tanker Collision

Gross Cat Risk Charge Property damage

Gross Cat Risk Charge Removal of wreckage

Gross Cat Risk Charge Loss of production

income

Gross Cat Risk Charge Capping of the well or making the well secure

Gross Cat Risk Charge Liability insurance and reinsurance obligations

Gross Cat Risk Charge Marine Platform Explosion

Estimated Reinstatement Premiums

Net Cat Risk Charge Marine Platform Explosion

Total before diversification

Diversification between type of event

Gross Cat risk Charge Aviation hull

Gross Cat risk Charge Aviation liability

Gross Cat Risk Charge Aviation

Estimated Reinstatement Premiums

Net Cat Risk Charge Aviation

Professional malpractice liability

Directors and officers liability

Non-proportional reinsurance

Total before diversification

Diversification between type of cover

Total before diversification

Diversification between type of event

MAT other than Marine and Aviation

Non-proportional MAT reinsurance other than

Marine and AviationMiscellaneous financial

loss

Non-proportional Casualty reinsurance other than

General liabilityNon-proportional Credit &

Surety reinsuranceTotal before

diversificationDiversification between groups of obligations

Total value of benefits payable

Total value of benefits payable

Total value of benefits payable

Total value of benefits payable

Total value of benefits payable

Gross Catastrophe Risk Charge

Estimated Risk Mitigation

Estimated Reinstatement Premiums

Largest known accident risk concentration

Gross Catastrophe Risk Charge

Estimated Reinstatement Premiums

Net Catastrophe Risk Charge

Unit claim cost hospitalisation

Expected number of uses hospitalisation

Unit claim cost medical practitioner

Expected number of uses medical practitioner

Unit claim cost no formal medical care

Expected number of uses no formal medical care

Gross Catastrophe Risk Charge

Estimated Risk Mitigation

Estimated Reinstatement Premiums

Page 50: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

SCR-B3G

Solvency Capital Requirement - Operational riskCell not relevant

Operational risk - basic information

Capital requirement

A1

A2

A3

A5

A6

A7

A8

A9

A10

A12=max(A4, A11)A13 =0.3 * A10 on SCR-B2A

Capital requirement for operational risk charge after capping A14=min(A12, A13)

A15

Capital requirement for operational risk A16= A14 + 0.25*A15

KeyData to be enteredCell not relevantCell calculated by a formulaTotal calculated by a formula

Life gross technical provisions - TP life

Life gross technical provisions unit-linked - TP Life-ul

Non-life gross technical provisions - TP nl

Capital requirement for operation risk based on technical provisions (Opprovisions) A4=0.0045*max(0, (A1-A2))+0.03*max(0, A3)

Earned life gross premiums (previous 12 months) - Earn life

Earned life gross premiums unit-linked (previous 12 months) - Earn life-ul

Earned non-life gross premiums (previous 12 months) - Earn nl

Earned life gross premiums (12 months prior to the previous 12 months) - pEarn life

Earned life gross premiums unit-linked (12 months prior to the previous 12 months) - pEarn life-ul

Earned non-life gross premiums (12 months prior to the previous 12 months) - pEarn nl

Capital requirement for operational risk based on earned premiums (Oppremiums) A11=0.04*(A5-A6) +0.3*A7+max(0, 0.04*(A5-1.2*A8-(A6-1.2*A9)))

+max(0, 0.03*A7-1.2*A10)

Capital requirement for operational risk charge before capping (Op)Percentage of Basic Solvency Capital Requirement (0.3 BSCR)

Expenses incurred in respect of unit linked business (previous 12 months) (Expul)

Page 51: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

FormulaCell used more than once in one single template

Cell reported in a different template

Page 52: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

MCR-B4A

Linear formula component for non-life insurance and reinsurance obligations

Medical expensesIncome protection insurance Workers' compensation insurance Motor vehicle liability insurance and proportional reinsuranceOther motor insurance and proportional reinsuranceMarine, aviation and transport insurance and proportional reinsuranceFire and other damage to property insurance and proportional reinsuranceGeneral liability insurance and proportional reinsuranceCredit and suretyship insurance and proportional reinsuranceLegal expenses insurance and proportional reinsuranceAssistance and its proportional reinsuranceMiscellaneous financial loss insurance and proportional reinsuranceNon-proportional casualty reinsuranceNon-proportional marine, aviation and transport reinsurance Non-proportional property reinsuranceNon-proportional health reinsurance

Linear formula component for life insurance and reinsurance obligations

Obligations with profit participation - guaranteed benefitsObligations with profit participation - future discretionary benefits

Capital at risk for all life (re)insurance obligations

Overall MCR calculation

Minimum Capital Requirement (except for composite undertakings)

MCRNL Result

MCRL Result

Index-linked and unit-linked insurance obligations Other life (re)insurance and health obligations

Page 53: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Linear MCR

MCR capMCR floorCombined MCRAbsolute floor of the MCR

Minimum Capital Requirement

SCR with add-on

Page 54: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

MCR components Background informationLinear formula component for non-life insurance and reinsurance obligations

A1

B2 C2B3 C3B4 C4B5 C5B6 C6

Marine, aviation and transport insurance and proportional reinsurance B7 C7Fire and other damage to property insurance and proportional reinsurance B8 C8

B9 C9B10 C10B11 C11B12 C12B13 C13B14 C14B15 C15B16 C16B17 C17

Linear formula component for life insurance and reinsurance obligations

A18

Capital at risk

B19B20B21B22

C23

(except for composite undertakings)Cell not relevant

Cell used more than once in one single

template Cell reported in a different template

Net (of reinsurance) best estimate

provisions

Net (of reinsurance) written premiums in the

last 12 months

Net (of reinsurance) best estimate

provisions

Page 55: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

A24=A1+A18A25A26A27

A28=min(max(A24,A27),A26)

A29

A30=max(A28,A29)

Page 56: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Formula

Page 57: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

MCR-B4B

Minimum capital Requirement - Composite undertakings

Linear formula component for non-life insurance or reinsurance obligations

Medical expense insurance and proportional reinsurance Income protection insurance and proportional reinsurance Workers' compensation insurance and proportional reinsurance Motor vehicle liability insurance and proportional reinsuranceOther motor insurance and proportional reinsuranceMarine, aviation and transport insurance and proportional reinsuranceFire and other damage to property insurance and proportional reinsuranceGeneral liability insurance and proportional reinsuranceCredit and suretyship insurance and proportional reinsuranceLegal expenses insurance and proportional reinsuranceAssistance and its proportional reinsuranceMiscellaneous financial loss insurance and proportional reinsuranceNon-proportional casualty reinsuranceNon-proportional property reinsuranceNon-proportional marine, aviation and transport reinsurance Non-proportional health reinsurance

Linear formula component for life insurance or reinsurance obligations

Obligations with profit participation - guaranteed benefitsObligations with profit participation - future discretionary benefitsIndex-linked and unit-linked obligations Other life (re)insurance obligationsCapital at risk for all life (re)insurance obligations

Overall MCR calculationLinear MCR A24=B1+C1+B18+C18

Page 58: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

A25MCR cap A26MCR floor A27Combined MCR A28=min(max(A24,A27),A26)

A29

MCR A30=max(A28,A29)

Notional non-life and life MCR calculationNotional linear MCR

Notional MCR capNotional MCR floorNotional Combined MCRAbsolute floor of the notional MCRNotional MCR

SCR with add-on

Absolute floor of the MCR

Notional SCR with add-on (annual or latest calculation)

Page 59: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Cell not relevant Formula

MCR components Background informationNon-life activities Life activities Non-life activities

B1 C1

D2 E2D3 E3D4 E4D5 E5D6 E6D7 E7D8 E8D9 E9

D10 E10D11 E11D12 E12D13 E13D14 E14D15 E15D16 E16D17 E17

Non-life activities Life activities Non-life activities

B18 C18

D19D20D21D22

E23

Cell used more than once in one single

template

Cell reported in a different template

MCR(NL,NL) Result MCR(NL,L)Result

Net (of reinsurance) best estimate

provisions

Net (of reinsurance)

written premiums in the last 12 months

MCR(L,NL) Result MCR(L,L) Result

Net (of reinsurance) best estimate

provisions

Net (of reinsurance) capital at risk

Page 60: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Non-life activities Life activitiesB32 C32B33 C33B34 C34B35 C35B36 C36B37 C37B38 C38

Page 61: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Background informationLife activities

F2 G2F3 G3F4 G4F5 G5F6 G6F7 G7F8 G8F9 G9

F10 G10F11 G11F12 G12F13 G13F14 G14F15 G15F16 G16F17 G17

Life activities

F19F20F21F22

G23

Net (of reinsurance) best

estimate provisions

Net (of reinsurance)

written premiums in the last 12

months

Net (of reinsurance) best

estimate provisions

Net (of reinsurance) capital at risk

Page 62: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Assets - D1S

document.xlsx Page 62 05/06/2023

D1S

Structured products Data - Portfolio list Cell not relevant Formula

Identification section Categorisation section Data sectionID Code Collateral Collateral type Attachment point

Cell Number A1 A2 A3 A4 A5 A6 A8 A15 A16 A9 A10 A12 A13 A14

Cell used more than once in one single template

Cell reported in a different template

Type of structured

product

Capital protection

Underlying security / index /

portfolio

Callable or Putable

Synthetic structured

product (Y/N)

Prepayment structured

product (Y/N)

Fixed Annual Return

Variable Annual Return

Loss given default

Detachment point

Page 63: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Assets - D3

document.xlsx Page 63 05/06/2023

D3

Return on investment assets (by asset category) Formula

Identification section Profitability sectionPortfolio Asset category Dividends Rent Net gains and losses

Cell Number A1 A3 A4 A6 A8 A15

Cell not relevant

Cell used more than once in one single template

Cell reported in a different template

Asset held in unit linked and index

linked funds (Y/N)

Page 64: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Assets - D4

document.xlsx Page 64 05/06/2023

D4

Investment funds (look-through approach) Cell not relevant Formula

Identification section Data sectionID Code ID Code type Fund number Underlying asset category Total amount

Cell Number A1 A2 A3 A4 A5 A6 A7

Cell used more than once in one single template

Cell reported in a different template

Geographical zone of issue

Currency - Local or foreign

Page 65: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Assets - D5

document.xlsx Page 65 05/06/2023

D5

Securities lending and repos Cell not relevant Formula

Identification section Data sectionPortfolio Fund number Asset category Counterparty ID Collateral type Near leg amount Far leg amount Start date Maturity date SII Value

Cell Number A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A12 A13 A14

Cell used more than once in one single

template Cell reported in a different template

Asset held in unit linked and index

linked funds (Y/N)

Type of repo / securities lending

Buyer or seller / Lender or borrower

Page 66: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

D6

Assets held as collateral Cell not relevant Formula

Identification section (on the collateral) Categorisation section (on the collateral) Data section (on the collateral) Information on the asset for which collateral is heldID Code ID Code type Security Title Issuer Name Issuer Sector CIC Quantity Unit SII price Total SII amount Maturity date Accrued interest Type of asset

Cell Number A2 A3 A4 A5 A6 A7 A8 A9 A10 A12 A19 A20 A21 A24 A25 A26 A27 A28

Cell used more than once in one single

template Cell reported in a different template

Issuer Group (Code)

Issuer Country

Country of custody

Currency (ISO code)

Valuation method SII

Name of debtor pledging the collateral

Group of debtor pledging the

collateral (code)

A22=A19*A20+A25

Page 67: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - F1

document.xlsx Page 67 05/06/2023

F1

Life and Health SLT Technical Provisions (Annual) Cell not relevant Formula

Index-linked and unit-linked insurance Other life insurance Accepted reinsurance

Health insurance (direct business)

Total (Health similar to life insurance)

Technical provisions calculated as a whole (Replicable portfolio) A1 A3 A5 A6 A7=A7A+A7B+A7C A9=A1+A3+A5+A6+A7 A10 A12 A13 A14=A10+A12+A13

Of which WP A7AOf which UL A7B

Technical provisions calculated as a sum of BE and RM (Non-Replicable portfolio) Of which OL A7C

Best Estimate Gross B1 B2 B3 B4 B5 B6 B7 B9=SOMME(B1:B7) B10 B11 B12 B13 B14=SOMME(B10:B13)

CA1=CB1+CC1+CD1 CA2=CB2+CC2+CD2 CA6=CB6+CC6+CD6 CA7=CB7+CC7+CD7 CA9=SOMME(CA1:CA7) CA13=CB13+CC13+CD13 CA14=SOMME(CA10:CA13)

CB1 CB2 CB3 CB4 CB5 CB6 CB7 CB9=SOMME(CB1:CB7) CB10 CB11 CB12 CB13 CB14=SOMME(CB10:CB13) Recoverables from SPV before adjustment for expected losses CC1 CC2 CC3 CC4 CC5 CC6 CC7 CC9=SOMME(CC1:CC7) CC10 CC11 CC12 CC13 CC14=SOMME(CC10:CC13) Recoverables from Finite Reinsurance before adjustment for expected losses CD1 CD2 CD3 CD4 CD5 CD6 CD7 CD9=SOMME(CD1:CD7) CD10 CD11 CD12 CD13 CD14=SOMME(CD10:CD13)

C1 C2 C3 C4 C5 C6 C7 C9=SOMME(C1:C7) C10 C11 C12 C13 C14=SOMME(C10:C13)Best estimate minus recoverables from reinsurance and SPV - total D1=B1-C1 D2=B2-C2 D3=B3-C3 D4=B4-C4 D5=B5-C5 D6=B6-C6 D7=B7-C7 D9=SOMME(D1:D7) D10=B10-C10 D11=B11-C11 D12=B12-C12 D13=B13-C13 D14=SOMME(D10:D13)

Risk Margin E1 E2 E4 E6 E7 E9=E1+E2+E4+E6+E7 E10 E12 E13 E14=E10+E12+E13

Technical provisions - total F1=A1+B1+E1 F2=A3+B2+B3+E2 F4=A5+B4+B5+E4 F6=A6+B6+E6 F7=A7+B7+E7 F9=SOMME(F1:F7) F10=A10+B10+B11+E10 F12=A12+B12+E12 F13=A13+B13+E13 F14=SOMME(F10:F13)

Technical provisions minus recoverables from reinsurance and SPV - total FB1=F1-C1 FB2=F2-C2-C3 FB4=F4-C4-C5 FB6=F6-C6 FB9=SOMME(FB1:FB7) FB10=F10-C10-C11 FB12=F12-C12 FB13=F13-C13 FB14=SOMME(FB10:FB13) Of which WP FB7A

Of which UL FB7BOf which OL FB7C

Best Estimate of products with a surrender option IA1 IA2 IA4 IA6 IA9=IA1+IA2+IA4+IA6 IA10 IA12 IA14=IA10+IA12

ADDITIONAL INFORMATION Gross BE for different countries Home J1 J2 J4 J6 J7 J9=J1+J2+J4+J6+J7 J10 J12 J13 J14=J10+J12+J13AT JA1 JA2 JA4 JA6 JA7 JA9=JA1+JA2+JA4+JA6+JA7 JA10 JA12 JA13 JA14=JA10+JA12+JA13BE JB1 JB2 JB4 JB6 JB7 JB9=JB1+JB2+JB4+JB6+JB7 JB10 JB12 JB13 JB14=JB10+JB12+JB13CZ JC1 JC2 JC4 JC6 JC7 JC9=JC1+JC2+JC4+JC6+JC7 JC10 JC12 JC13 JC14=JC10+JC12+JC13… JD1 JD2 JD4 JD6 JD7 JD9=JD1+JD2+JD4+JD6+JD7 JD10 JD12 JD13 JD14=JD10+JD12+JD13

JE1 JE2 JE4 JE6 JE7 JE9=JE1+JE2+JE4+JE6+JE7 JE10 JE12 JE13 JE14=JE10+JE12+JE13US JF1 JF2 JF4 JF6 JF7 JF9=JF1+JF2+JF4+JF6+JF7 JF10 JF12 JF13 JF14=JF10+JF12+JF13CA JG1 JG2 JG4 JG6 JG7 JG9=JG1+JG2+JG4+JG6+JG7 JG10 JG12 JG13 JG14=JG10+JG12+JG13AU JH1 JH2 JH4 JH6 JH7 JH9=JH1+JH2+JH4+JH6+JH7 JH10 JH12 JH13 JH14=JH10+JH12+JH13CH JI1 JI2 JI4 JI6 JI7 JI9=JI1+JI2+JI4+JI6+JI7 JI10 JI12 JI13 JI14=JI10+JI12+JI13JP JJ1 JJ2 JJ4 JJ6 JJ7 JJ9=JJ1+JJ2+JJ4+JJ6+JJ7 JJ10 JJ12 JJ13 JJ14=JJ10+JJ12+JJ13… JK1 JK2 JK4 JK6 JK7 JK9=JK1+JK2+JK4+JK6+JK7 JK10 JK12 JK13 JK14=JK10+JK12+JK13

JL1 JL2 JL4 JL6 JL7 JL9=JL1+JL2+JL4+JL6+JL7 JL10 JL12 JL13 JL14=JL10+JL12+JL13

Gross BE for Cash flow

Cash out-flows Future guaranteed benefits BA1

BA2 BA4 BA6 BA7 BA10 BA12 BA13 Future discretionary benefits BB1 Future expenses and other cash out-flows BC1 BC2 BC4 BC6 BC7 BC9=BC1+BC2+BC4+BC6+BC7 BC10 BC12 BC13 BC14=BC10+BC12+BC13

Cash in-flows Future premiums BD1 BD2 BD4 BD6 BD7 BD9=BD1+BD2+BD4+BD6+BD7 BD10 BD12 BD13 BD14=BD10+BD12+BD13

Other cash in-flows BF1 BF2 BF4 BF6 BF7 BF9=BF1+BF2+BF4+BF6+BF7 BF10 BF12 BF13 BF14=BF10+BF12+BF13

Amount of gross TP calculated using simplified methods O1 O2 O4 O6 O7 O10 O12 O13

Total amount of surrenders P1 P2 P4 P6 P7 P9=P1+P2+P4+P6+P7 P10 P12 P13 P14=P10+P12+P13

Additional information in case of use of discount rates other than risk free rates Q1 Q2 Q4 Q6 Q7 Q9=Q1+Q2+Q4+Q6+Q7 Q10 Q12 Q13 Q14+Q10+Q12+Q13(to be further developed when L2 decided)

Cell used more than once in one single

template Cell reported in a different template

Insurance with profit participation

Annuities stemming from non-life insurance

contracts and relating to insurance obligation other

than health insurance obligations

Total (Life other than health insurance, incl. Unit-Linked)

Annuities stemming from non-life

insurance contracts and relating to health insurance obligations

Health reinsurance (reinsurance accepted)

Contracts without options and guarantees

Contracts with options and guarantees

Contracts without options and guarantees

Contracts with options and guarantees

Contracts without options and guarantees

Contracts with options and guarantees

Total recoverables from reinsurance and SPV before the adjustment for expected losses due to counterparty default

CA3=CB3+CC3+CD3

CA4=CB4+CC4+CD4

CA5=CB5+CC5+CD5

CA10=CB10+CC10+CD10

CA11=CB11+CC11+CD11

CA12=CB12+CC12+CD12

Recoverables from reinsurance (except SPV and Finite Reinsurance) before adjustment for expected losses

Total Recoverables from reinsurance and SPV after the adjustment for expected losses due to counterparty default

FB7=F7-C7=FB7A+FB7B+FB7C

other EEA (sum of not material countries)

other non-EEA (sum of not material countries)

Page 68: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - F2

document.xlsx Page 68 05/06/2023

F2

Projection of future cash flows (Best Estimate - Life) Formula

Insurance with profit participation Index linked and unit-linked insurance Other life insurance Annuities stemming from non-life contracts Accepted reinsurance Health insurance Health reinsurance

Gross Gross Gross Gross Gross GrossCash out-flows Cash in-flows Cash out-flows Cash in-flows Cash out-flows Cash in-flows Cash out-flows Cash in-flows Cash out-flows Cash in-flows Cash out-flows Cash in-flows Cash out-flows Cash in-flows

Future premiums

1 A1 C1 D1 F1 AU1 CU1 DU1 FU1 I1 J1 K1 L1 M1 N1 O1 P1 Q1 R1 S1 T1 U1 CH1 DH1 FH1 V1 X1 Y1 Z1 GH12 A2 C2 D2 F2 AU2 CU2 DU2 FU2 I2 J2 K2 L2 M2 N2 O2 P2 Q2 R2 S2 T2 U2 CH2 DH2 FH2 V2 X2 Y2 Z2 GH23 A3 C3 D3 F3 AU3 CU3 DU3 FU3 I3 J3 K3 L3 M3 N3 O3 P3 Q3 R3 S3 T3 U3 CH3 DH3 FH3 V3 X3 Y3 Z3 GH34 A4 C4 D4 F4 AU4 CU4 DU4 FU4 I4 J4 K4 L4 M4 N4 O4 P4 Q4 R4 S4 T4 U4 CH4 DH4 FH4 V4 X4 Y4 Z4 GH45 A5 C5 D5 F5 AU5 CU5 DU5 FU5 I5 J5 K5 L5 M5 N5 O5 P5 Q5 R5 S5 T5 U5 CH5 DH5 FH5 V5 X5 Y5 Z5 GH56 A6 C6 D6 F6 AU6 CU6 DU6 FU6 I6 J6 K6 L6 M6 N6 O6 P6 Q6 R6 S6 T6 U6 CH6 DH6 FH6 V6 X6 Y6 Z6 GH67 A7 C7 D7 F7 AU7 CU7 DU7 FU7 I7 J7 K7 L7 M7 N7 O7 P7 Q7 R7 S7 T7 U7 CH7 DH7 FH7 V7 X7 Y7 Z7 GH78 A8 C8 D8 F8 AU8 CU8 DU8 FU8 I8 J8 K8 L8 M8 N8 O8 P8 Q8 R8 S8 T8 U8 CH8 DH8 FH8 V8 X8 Y8 Z8 GH89 A9 C9 D9 F9 AU9 CU9 DU9 FU9 I9 J9 K9 L9 M9 N9 O9 P9 Q9 R9 S9 T9 U9 CH9 DH9 FH9 V9 X9 Y9 Z9 GH910 A10 C10 D10 F10 AU10 CU10 DU10 FU10 I10 J10 K10 L10 M10 N10 O10 P10 Q10 R10 S10 T10 U10 CH10 DH10 FH10 V10 X10 Y10 Z10 GH1011 A11 C11 D11 F11 AU11 CU11 DU11 FU11 I11 J11 K11 L11 M11 N11 O11 P11 Q11 R11 S11 T11 U11 CH11 DH11 FH11 V11 X11 Y11 Z11 GH1112 A12 C12 D12 F12 AU12 CU12 DU12 FU12 I12 J12 K12 L12 M12 N12 O12 P12 Q12 R12 S12 T12 U12 CH12 DH12 FH12 V12 X12 Y12 Z12 GH1213 A13 C13 D13 F13 AU13 CU13 DU13 FU13 I13 J13 K13 L13 M13 N13 O13 P13 Q13 R13 S13 T13 U13 CH13 DH13 FH13 V13 X13 Y13 Z13 GH1314 A14 C14 D14 F14 AU14 CU14 DU14 FU14 I14 J14 K14 L14 M14 N14 O14 P14 Q14 R14 S14 T14 U14 CH14 DH14 FH14 V14 X14 Y14 Z14 GH1415 A15 C15 D15 F15 AU15 CU15 DU15 FU15 I15 J15 K15 L15 M15 N15 O15 P15 Q15 R15 S15 T15 U15 CH15 DH15 FH15 V15 X15 Y15 Z15 GH1516 A16 C16 D16 F16 AU16 CU16 DU16 FU16 I16 J16 K16 L16 M16 N16 O16 P16 Q16 R16 S16 T16 U16 CH16 DH16 FH16 V16 X16 Y16 Z16 GH1617 A17 C17 D17 F17 AU17 CU17 DU17 FU17 I17 J17 K17 L17 M17 N17 O17 P17 Q17 R17 S17 T17 U17 CH17 DH17 FH17 V17 X17 Y17 Z17 GH1718 A18 C18 D18 F18 AU18 CU18 DU18 FU18 I18 J18 K18 L18 M18 N18 O18 P18 Q18 R18 S18 T18 U18 CH18 DH18 FH18 V18 X18 Y18 Z18 GH1819 A19 C19 D19 F19 AU19 CU19 DU19 FU19 I19 J19 K19 L19 M19 N19 O19 P19 Q19 R19 S19 T19 U19 CH19 DH19 FH19 V19 X19 Y19 Z19 GH1920 A20 C20 D20 F20 AU20 CU20 DU20 FU20 I20 J20 K20 L20 M20 N20 O20 P20 Q20 R20 S20 T20 U20 CH20 DH20 FH20 V20 X20 Y20 Z20 GH2021 A21 C21 D21 F21 AU21 CU21 DU21 FU21 I21 J21 K21 L21 M21 N21 O21 P21 Q21 R21 S21 T21 U21 CH21 DH21 FH21 V21 X21 Y21 Z21 GH2122 A22 C22 D22 F22 AU22 CU22 DU22 FU22 I22 J22 K22 L22 M22 N22 O22 P22 Q22 R22 S22 T22 U22 CH22 DH22 FH22 V22 X22 Y22 Z22 GH2223 A23 C23 D23 F23 AU23 CU23 DU23 FU23 I23 J23 K23 L23 M23 N23 O23 P23 Q23 R23 S23 T23 U23 CH23 DH23 FH23 V23 X23 Y23 Z23 GH2324 A24 C24 D24 F24 AU24 CU24 DU24 FU24 I24 J24 K24 L24 M24 N24 O24 P24 Q24 R24 S24 T24 U24 CH24 DH24 FH24 V24 X24 Y24 Z24 GH2425 A25 C25 D25 F25 AU25 CU25 DU25 FU25 I25 J25 K25 L25 M25 N25 O25 P25 Q25 R25 S25 T25 U25 CH25 DH25 FH25 V25 X25 Y25 Z25 GH2526 A26 C26 D26 F26 AU26 CU26 DU26 FU26 I26 J26 K26 L26 M26 N26 O26 P26 Q26 R26 S26 T26 U26 CH26 DH26 FH26 V26 X26 Y26 Z26 GH2627 A27 C27 D27 F27 AU27 CU27 DU27 FU27 I27 J27 K27 L27 M27 N27 O27 P27 Q27 R27 S27 T27 U27 CH27 DH27 FH27 V27 X27 Y27 Z27 GH2728 A28 C28 D28 F28 AU28 CU28 DU28 FU28 I28 J28 K28 L28 M28 N28 O28 P28 Q28 R28 S28 T28 U28 CH28 DH28 FH28 V28 X28 Y28 Z28 GH2829 A29 C29 D29 F29 AU29 CU29 DU29 FU29 I29 J29 K29 L29 M29 N29 O29 P29 Q29 R29 S29 T29 U29 CH29 DH29 FH29 V29 X29 Y29 Z29 GH2930 A30 C30 D30 F30 AU30 CU30 DU30 FU30 I30 J30 K30 L30 M30 N30 O30 P30 Q30 R30 S30 T30 U30 CH30 DH30 FH30 V30 X30 Y30 Z30 GH30

31-40 A33 C33 D33 F33 AU33 CU33 DU33 FU33 I33 J33 K33 L33 M33 N33 O33 P33 Q33 R33 S33 T33 U33 CH33 DH33 FH33 V33 X33 Y33 Z33 GH3341-50 A34 C34 D34 F34 AU34 CU34 DU34 FU34 I34 J34 K34 L34 M34 N34 O34 P34 Q34 R34 S34 T34 U34 CH34 DH34 FH34 V34 X34 Y34 Z34 GH34

51 & after A35 C35 D35 F35 AU35 CU35 DU35 FU35 I35 J35 K35 L35 M35 N35 O35 P35 Q35 R35 S35 T35 U35 CH35 DH35 FH35 V35 X35 Y35 Z35 GH35

Cell not relevant

Cell used more than once in one single template

Cell reported in a different template

Year (projection of undiscounted

expected cash-flows)

Total recoverable

from reinsurance

(after the adjustment)

Gross

Future Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Future Benefits

Future expenses and other cash

out-flowsOther cash

in-flowsFuture

Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Future Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Future Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Future Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Future Benefits

Future expenses and

other cash out-flows

Future premiums

Other cash in-flows

Page 69: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - F3

document.xlsx Page 69 05/06/2023

F3

Life obligations analysis Formula

Identification and classification Stock and Movements Best Estimate and guarantees

ID code Line of Business Type of product Type of premium Country

A1 A1A A2A A2B A2C A3 A4 A5 A6 A7 A8 A9 A10 A15 A20 A21 A24 A26 A30 A41

Legend Scope

Cell not relevant

Cell used more than once in one single

template Cell reported in a different template

Product denomination

Number of HRGs in products

Are HRG common to other products? (Y/N)

Ring fenced fund or other internal funds (ID

of fund or Not Ring-fenced)

Product still commercialized ? (Y/N) Product

classification ID (harmonized

code)

Number of contracts at the end of the year

Number of new contracts during year

Total amount of premiums

written during the year

Total amount of claims paid during year

Best Estimate (by HRG - merger of

different cells)

Capital-at-risk (by HRG - merger of

different cells)

Surrender value (where available) (by HRG - merger of different cells)

Annualized guaranteed rate (by

HRG - merger of different cells)

Use of financial instrument for

replication ? (Y/N)

Blue reflects requirements of reporting for financial stability

Solo undertakings above the threshold and not belonging to

groups with FS deadlines

Page 70: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

F3A

Only for Variable Annuities - Description of guarantees by product Cell not relevant Formula

Identification Description of guarantees Detail of GMDB guarantees Detail of GMAB guarantees Detail of GMIB guarantees Detail of GMWB guarantees

Entity General Description Cover Term Present? Level Description Present? Level Description Present? Level Description Present? Level Description

A1 A2=A1(F3) A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A14 A15 A16

Cell used more than once in one single

template Cell reported in a different template

Product Denomination

Page 71: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

F3B

Only for Variable Annuities - Hedging of guarantees Formula

Identification Hedging Results

Other hedged risks

A1=A1(F3)=A2(F3A) A2 A3 A4 A5 A6 A7 A8 A9 A10

Cell not relevant

Cell used more than once in one single

template Cell reported in a different template

Product Denomination

Type of strategy

Delta hedged

Rho hedged

Gamma hedged

Vega hedged

FX hedged

Economic result without hedging

Economic result with hedging

Page 72: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - F4

document.xlsx 72 05/06/2023

F4

Information on annuities stemming from Non-Life Insurance obligationsCell not relevant Formula

The related non-life line of business A00Currency: A01

Reporting Year A02Accident year / Underwriting year: A03

Year

A0 A1 A2 A3 A4 A5

Prior years

N-14N-13N-12N-11N-10N-9N-8 N-7N-6N-5N-4N-3N-2N-1N

SUM

The average technical rate in year N B1

The average duration of the obligations C1

The weighted average age of the beneficiaries D1

Cell used more than once in one single

template

Cell reported in a different template

Undiscounted annuity claims

provisions at the start of year N

Undiscounted annuity claims

provisions set up during year N

Annuity payments paid during year N

Undiscounted annuity claims

provisions at the end of year N

Number of annuities obligations at the

end of year N

Best Estimate for annuity claims

provisions at the end of year N (discounted

basis)

Test for under / over reserving

(A6) = (A0+A1-A2)-(A3)

Page 73: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E1

document.xlsx Page 73 05/06/2023

E1 - Non-Life Technical Provisions (annual) Cell not relevant Formula

Segmentation for:

Total Non-Life obligation

Direct business and accepted proportional reinsurance accepted non-proportional reinsurance:

Technical provisions calculated as a whole (REPL.) A1=A2+A3 B1=B2+B3 C1=C2+C3 D1=D2+D3 E1=E2+E3 F1=F2+F3 G1=G2+G3 H1=H2+H3 I1=I2+I3 J1=J2+J3 K1=K2+K3 L1=L2+L3 M1=M4 N1=N4 O1=O4 P1=P4 Q1=SOMMA(A1:P1)Direct business A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 Q2=SOMMA(A2:L2)Accepted proportional reinsurance business A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3 Q3=SOMMA(A3:L3)Accepted non-proportional reinsurance M4 N4 O4 P4 Q4=SOMMA(M4:P4)

Technical provisions calculated as a sum of BE and RM (NON-REPL.)Best estimatePremium provisionsGross - direct business A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 L5 Q5=SOMMA(A5:L5)Gross - accepted proportional reinsurance business A6 B6 C6 D6 E6 F6 G6 H6 I6 J6 K6 L6 Q6=SOMMA(A6:L6)

Gross - accepted non-proportional reinsurance business M7 N7 O7 P7 Q7=SOMMA(M7:P7)

A8=A9+A10+A11 B8=B9+B10+B11 C8=C9+C10+C11 D8=D9+D10+D11 E8=E9+E10+E11 F8=F9+F10+F11 G8=G9+G10+G11 H8=H9+H10+H11 I8=I9+I10+I11 J8=J9+J10+J11 K8=K9+K10+K11 L8=L9+L10+L11 M8=M9+M10+M11 N8=N9+N10+N11 O8=O9+O10+O11 P8=P9+P10+P11 Q8=SOMMA(A8:P8) Recoverables from reinsurance (except SPV and Finite Reinsurance) before adjustment for expected losses A9 B9 C9 D9 E9 F9 G9 H9 I9 J9 K9 L9 M9 N9 O9 P9 Q9=SOMMA(A9:P9)

Recoverables from SPV before adjustment for expected losses A10 B10 C10 D10 E10 F10 G10 H10 I10 J10 K10 L10 M10 N10 O10 P10 Q10=SOMMA(A10:P10)

Recoverables from Finite Reinsurance before adjustment for expected losses A11 B11 C11 D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 P11 Q11=SOMMA(A11:P11)

A12 B12 C12 D12 E12 F12 G12 H12 I12 J12 K12 L12 M12 N12 O12 P12 Q12=SOMMA(A12:P12)Net Best Estimate of Premium Provisions A13=A5+A6-A12 B13=B5+B6-B12 C13=C5+C6-C12 D13=D5+D6-D12 E13=E5+E6-E12 F13=F5+F6-F12 G13=G5+G6-G12 H13=H5+H6-H12 I13=I5+I6-I12 J13=J5+J6-J12 K13=K5+K6-K12 L13=L5+L6-L12 M13=M7-M12 N13=N7-N12 O13=O7-O12 P13=P7-P12 Q13=SOMMA(A13:P13)

Claims provisionsGross - direct business A14 B14 C14 D14 E14 F14 G14 H14 I14 J14 K14 L14 Q14=SOMMA(A14:L14)

Gross - accepted proportional reinsurance business A15 B15 C15 D15 E15 F15 G15 H15 I15 J15 K15 L15 Q15=SOMMA(A15:L15)Gross - accepted non-proportional reinsurance business M16 N16 O16 P16 Q16=SOMMA(M16:P16)

A17=A18+A19+A20 B17=B18+B19+B20 C17=C18+C19+C20 D17=D18+D19+D20 E17=E18+E19+E20 F17=F18+F19+F20 G17=G18+G19+G20 H17=H18+H19+H20 I17=I18+I19+I20 J17=J18+J19+J20 K17=K18+K19+K20 L17=L18+L19+L20 M17=M18+M19+M20 N17=N18+N19+N20 O17=O18+O19+O20 P17=P18+P19+P20 Q17=SOMMA(A17:P17)

Recoverables from reinsurance (except SPV and Finite Reinsurance) before adjustment for expected losses A18 B18 C18 D18 E18 F18 G18 H18 I18 J18 K18 L18 M18 N18 O18 P18 Q18=SOMMA(A18:P18)

Recoverables from SPV before adjustment for expected losses A19 B19 C19 D19 E19 F19 G19 H19 I19 J19 K19 L19 M19 N19 O19 P19 Q19=SOMMA(A19:P19) Recoverables from Finite Reinsurance before adjustment for expected losses A20 B20 C20 D20 E20 F20 G20 H20 I20 J20 K20 L20 M20 N20 O20 P20 Q20=SOMMA(A20:P20)

A21 B21 C21 D21 E21 F21 G21 H21 I21 J21 K21 L21 M21 N21 O21 P21 Q21=SOMMA(A21:P21)

Net Best Estimate of Claims Provisions A22=A14+A15-A21 B22=B14+B15-B21 C22=C14+C15-C21 D22=D14+D15-D21 E22=E14+E15-E21 F22=F14+F15-F21 G22=G14+G15-G21 H22=H14+H15-H21 I22=I14+I15-I21 J22=J14+J15-J21 K22=K14+K15-K21 L22=L14+L15-L21 M22=M16-M21 N22=N16-N21 O21=O16-O21 P22=P16-P21 Q22=SOMMA(A22:P22)

Total Best estimate - gross A23=A5+A6+A14+A15 B23=B5+B6+B14+B15 C23=C5+C6+C14+C15 D23=D5+D6+D14+D15 E23=E5+E6+E14+E15 F23=F5+F6+F14+F15 G23=G5+G6+G14+G15 H23=H5+H6+H14+H15 I23=I5+I6+I14+I15 J23=J5+J6+J14+J15 K23=K5+K6+K14+K15 L23=L5+L6+L14+L15 M23=M7+M16 N23=N7+N16 O23=O7+O16 P23=P7+P16 Q23=SOMMA(A23:P23)

Total Best estimate - net A24=A13+A22 B24=B13+B22 C24=C13+C22 D24=D13+D22 E24=E13+E22 F24=F13+F22 G24=G13+G22 H24=H13+H22 I24=I13+I22 J24=J13+J22 K24=K13+K22 L24=L13+L22 M24=M13+M22 N24=N13+N22 O24=O13+O22 P24=P13+P22 Q24=SOMMA(A24:P24)

Risk margin A25 B25 C25 D25 E25 F25 G25 H25 I25 J25 K25 L25 M25 N25 O25 P25 Q25=SOMMA(A25:P25)

Technical provisions - totalTechnical provisions - total A26=A1+A23+A25 B26=B1+B23+B25 C26=C1+C23+C25 D26=D1+D23+D25 E26=E1+E23+E25 F26=F1+F23+F25 G26=G1+G23+G25 H26=H1+H23+H25 I26=I1+I23+I25 J26=J1+J23+J25 K26=K1+K23+K25 L26=L1+L23+L25 M26=M1+M23+M25 N26=N1+N23+N25 O26=O1+O23+O25 P26=P1+P23+P25 Q26=SOMMA(A26:P26)

A27=A12+A21 B27=B12+B21 C27=C12+C21 D27=D12+D21 E27=E12+E21 F27=F12+F21 G27=G12+G21 H27=H12+H21 I27=I12+I21 J27=J12+J21 K27=K12+K21 L27=L12+L21 M27=M12+M21 N27=N12+N21 O27=O12+O21 P27=P12+P21 Q27=SOMMA(A27:P27)

Technical provisions minus recoverables from reinsurance and SPV - total A28=A1+A24+A25 B28=B1+B24+B25 C28=C1+C24+C25 D28=D1+D24+D25 E28=E1+E24+E25 F28=F1+F24+F25 G28=G1+G24+G25 H28=H1+H24+H25 I28=I1+I24+I25 J28=J1+J24+J25 K28=K1+K24+K25 L28=L1+L24+L25 M28=M1+M24+M25 N28=N1+N24+N25 O28=O1+O24+O25 P28=P1+P24+P25 Q28=SOMMA(A28:P28)

ADDITIONAL INFORMATION:

Additional information in case of use of discount rates other than risk-free rates (to be further developed) A29 B29 C29 D29 E29 F29 G29 H29 I29 J29 K29 L29 M29 N29 O29 P29

Line of Business (LoB): further segmentation (Homogeneous Risk Groups - HRG)a) Premium provisionsfurther segmentation into homogeneous risk groups (Y/N) A30 B30 C30 D30 E30 F30 G30 H30 I30 J30 K30 L30 M30 N30 O30 P30

If yes, specify total number of homogenious risk groups (HRGs) A31 B31 C31 D31 E31 F31 G31 H31 I31 J31 K31 L31 M31 N31 O31 P31

b) Claims provisionsfurther segmentation into homogeneous risk groups (Y/N) A32 B32 C32 D32 E32 F32 G32 H32 I32 J32 K32 L32 M32 N32 O32 P32

If yes, specify total number of homogenious risk groups (HRGs) A33 B33 C33 D33 E33 F33 G33 H33 I33 J33 K33 L33 M33 N33 O33 P33

Best estimate of Premium Provisions (Gross)

Cash out-flowsFuture benefits and claims A34 B34 C34 D34 E34 F34 G34 H34 I34 J34 K34 L34 M34 N34 O34 P34 Q34=SOMMA(A34:P34)

Future expenses and other cash-out flows A35 B35 C35 D35 E35 F35 G35 H35 I35 J35 K35 L35 M35 N35 O35 P35 Q35=SOMMA(A35:P35)

Cash in-flows Future premiums A36 B36 C36 D36 E36 F36 G36 H36 I36 J36 K36 L36 M36 N36 O36 P36 Q36=SOMMA(A36:P36)

Other cash-in flows (incl. Recoverable from salvages and subrogations) A37 B37 C37 D37 E37 F37 G37 H37 I37 J37 K37 L37 M37 N37 O37 P37 Q37=SOMMA(A37:P37)

Best estimate of Claims Provisions (Gross)

Cash out-flows Future benefits and claims A38 B38 C38 D38 E38 F38 G38 H38 I38 J38 K38 L38 M38 N38 O38 P38 Q38=SOMMA(A38:P38)

Future expenses and other cash-out flows A39 B39 C39 D39 E39 F39 G39 H39 I39 J39 K39 L39 M39 N39 O39 P39 Q39=SOMMA(A39:P39)

Cash in-flows Future premiums A40 B40 C40 D40 E40 F40 G40 H40 I40 J40 K40 L40 M40 N40 O40 P40 Q40=SOMMA(A40:P40)

Other cash-in flows (incl. Recoverable from salvages and subrogations) A41 B41 C41 D41 E41 F41 G41 H41 I41 J41 K41 L41 M41 N41 O41 P41 Q41=SOMMA(A41:P41)

Use of simplified methods and techniques to calculate technical provisionsAmount of gross TP calculated using simplified methods A42 B42 C42 D42 E42 F42 G42 H42 I42 J42 K42 L42 M42 N42 O42 P42 Q42=SOMMA(A42:P42)

Gross Best estimate for different countriesHome A43 B43 C43 D43 E43 F43 G43 H43 I43 J43 K43 L43 Q43=SOMMA(A43:L43)

AT A44 B44 C44 D44 E44 F44 G44 H44 I44 J44 K44 L44 Q44=SOMMA(A44:L44)

BE A45 B45 C45 D45 E45 F45 G45 H45 I45 J45 K45 L45 Q45=SOMMA(A45:L45)

CZ A46 B46 C46 D46 E46 F46 G46 H46 I46 J46 K46 L46 Q46=SOMMA(A46:L46)

… A47 B47 C47 D47 E47 F47 G47 H47 I47 J47 K47 L47 Q47=SOMMA(A47:L47)

other EEA (sum of not material countries) A48 B48 C48 D48 E48 F48 G48 H48 I48 J48 K48 L48 Q48=SOMMA(A48:L48)

US A49 B49 C49 D49 E49 F49 G49 H49 I49 J49 K49 L49 Q49=SOMMA(A49:L49)

CA A50 B50 C50 D50 E50 F50 G50 H50 I50 J50 K50 L50 Q50=SOMMA(A50:L50)

AU A51 B51 C51 D51 E51 F51 G51 H51 I51 J51 K51 L51 Q51=SOMMA(A51:L51)

CH A52 B52 C52 D52 E52 F52 G52 H52 I52 J52 K52 L52 Q52=SOMMA(A52:L52)

JP A53 B53 C53 D53 E53 F53 G53 H53 I53 J53 K53 L53 Q53=SOMMA(A53:L53)

… A54 B54 C54 D54 E54 F54 G54 H54 I54 J54 K54 L54 Q54=SOMMA(A54:L54)

other non-EEA (sum of not material countries) A55 B55 C55 D55 E55 F55 G55 H55 I55 J55 K55 L55 Q55=SOMMA(A55:L55)

Cell used more than once in one single template

Cell reported in a different template

Medical expense insurance

(1)

Income protectioninsurance

(2)

Workers' compensation

insurance(3)

Motor vehicle liability insurance

(4)

Other motor insurance

(5)

Marine, aviation and transport

insurance(6)

Fire and other damage to property

insurance(7)

General liability insurance

(8)

Credit and suretyship insurance

(9)

Legal expenses insurance

(10)Assistance

(11)Miscellaneous financial loss

(12)

Non-proportional health reinsurance

(13)

Non-proportional casualty

reinsurance(14)

Non-proportional marine, aviation and

transport reinsurance

(15)

Non-proportional property

reinsurance(16)

Total recoverable from reinsurance/SPV before the adjustment for expected losses due to counterparty default

Total recoverable from reinsurance/SPV after the adjustment for expected losses due to counterparty default

Total recoverable from reinsurance/SPV before the adjustment for expected losses due to counterparty default

Total recoverable from reinsurance/SPV after the adjustment for expected losses due to counterparty default

Recoverable from reinsurance contract/SPV after the adjustment for expected losses due to counterparty default - total

Page 74: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E2

document.xlsx Page 74 05/06/2023

E2: Projection of future cash flows (Best Estimate - Non Life)

Cell not relevant Formula

Cash out-flows Cash in-flows Cash out-flows Cash in-flows

Future benefits Future premiums Other cash-in flows Future benefits Future premiums

1 A1 B1 C1 D1 E1 F1 G1 H1 I12 A2 B2 C2 D2 E2 F2 G2 H2 I23 A3 B3 C3 D3 E3 F3 G3 H3 I34 A4 B4 C4 D4 E4 F4 G4 H4 I45 A5 B5 C5 D5 E5 F5 G5 H5 I56 A6 B6 C6 D6 E6 F6 G6 H6 I67 A7 B7 C7 D7 E7 F7 G7 H7 I78 A8 B8 C8 D8 E8 F8 G8 H8 I89 A9 B9 C9 D9 E9 F9 G9 H9 I9

10 A10 B10 C10 D10 E10 F10 G10 H10 I1011 A11 B11 C11 D11 E11 F11 G11 H11 I1112 A12 B12 C12 D12 E12 F12 G12 H12 I1213 A13 B13 C13 D13 E13 F13 G13 H13 I1314 A14 B14 C14 D14 E14 F14 G14 H14 I1415 A15 B15 C15 D15 E15 F15 G15 H15 I1516 A16 B16 C16 D16 E16 F16 G16 H16 I1617 A17 B17 C17 D17 E17 F17 G17 H17 I1718 A18 B18 C18 D18 E18 F18 G18 H18 I1819 A19 B19 C19 D19 E19 F19 G19 H19 I1920 A20 B20 C20 D20 E20 F20 G20 H20 I2021 A21 B21 C21 D21 E21 F21 G21 H21 I2122 A22 B22 C22 D22 E22 F22 G22 H22 I2223 A23 B23 C23 D23 E23 F23 G23 H23 I2324 A24 B24 C24 D24 E24 F24 G24 H24 I2425 A25 B25 C25 D25 E25 F25 G25 H25 I2526 A26 B26 C26 D26 E26 F26 G26 H26 I2627 A27 B27 C27 D27 E27 F27 G27 H27 I2728 A28 B28 C28 D28 E28 F28 G28 H28 I2829 A29 B29 C29 D29 E29 F29 G29 H29 I2930 A30 B30 C30 D30 E30 F30 G30 H30 I30

31 & after A31 B31 C31 D31 E31 F31 G31 H31 I31

Cell used more than once in one single template

Cell reported in a different template

Year(projection of undiscounted

expected cash-flows)

Best Estimate Premium Provision(Gross)

Best Estimate Claim Provision(Gross)

Total recoverable from reinsurance

(after the adjustment)

Future expenses and other cash-

out flows

Future expenses and other cash-

out flowsOther cash-in

flows

Page 75: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E3

document.xlsx Page 75 05/06/2023

E3: Non-life Insurance Claims Information

Line of Business A00

Formula

Reporting Year A01

Currency A02

A03

Gross Claims Paid (non-cumulative) Gross undiscounted Best Estimate Claims Provisions Gross Reported but not Settled Claims (RBNS)(absolute amount) (absolute amount) (absolute amount)

Development year Development year Development year

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + In Current year Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year end

Prior J0 J0 Prior J0 J0.1 Prior J0 J0N-14 A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 O1 =Somma(A1:O1) N-14 P1 Q1 R1 S1 T1 U1 V1 W1 X1 Y1 Z1 AA1 AB1 AC1 AD1 AD1.1 N-14 AE1 AF1 AG1 AH1 AI1 AJ1 AK1 AL1 AM1 AN1 AO1 AP1 AQ1 AR1 AS1 AS1N-13 A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2 N2 N2 =Somma(A2:N2) N-13 P2 Q2 R2 S2 T2 U2 V2 W2 X2 Y2 Z2 AA2 AB2 AC2 AC2.1 N-13 AE2 AF2 AG2 AH2 AI2 AJ2 AK2 AL2 AM2 AN2 AO2 AP2 AQ2 AR2 AR2N-12 A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3 M3 M3 =Somma(A3:M3) N-12 P3 Q3 R3 S3 T3 U3 V3 W3 X3 Y3 Z3 AA3 AB3 AB3.1 N-12 AE3 AF3 AG3 AH3 AI3 AJ3 AK3 AL3 AM3 AN3 AO3 AP3 AQ3 AQ3N-11 A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 K4 L4 L4 =Somma(A4:L4) N-11 P4 Q4 R4 S4 T4 U4 V4 W4 X4 Y4 Z4 AA4 AA4.1 N-11 AE4 AF4 AG4 AH4 AI4 AJ4 AK4 AL4 AM4 AN4 AO4 AP4 AP4N-10 A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 K5 =Somma(A5:K4) N-10 P5 Q5 R5 S5 T5 U5 V5 W5 X5 Y5 Z5 Z5.1 N-10 AE5 AF5 AG5 AH5 AI5 AJ5 AK5 AL5 AM5 AN5 AO5 AO5N-9 A6 B6 C6 D6 E6 F6 G6 H6 I6 J6 J6 =Somma(A6:J6) N-9 P6 Q6 R6 S6 T6 U6 V6 W6 X6 Y6 Y6.1 N-9 AE6 AF6 AG6 AH6 AI6 AJ6 AK6 AL6 AM6 AN6 AN6N-8 A7 B7 C7 D7 E7 F7 G7 H7 I7 I7 =Somma(A7:I7) N-8 P7 Q7 R7 S7 T7 U7 V7 W7 X7 X7.1 N-8 AE7 AF7 AG7 AH7 AI7 AJ7 AK7 AL7 AM7 AM7N-7 A8 B8 C8 D8 E8 F8 G8 H8 H8 =Somma(A8:H8) N-7 P8 Q8 R8 S8 T8 U8 V8 W8 W8.1 N-7 AE8 AF8 AG8 AH8 AI8 AJ8 AK8 AL8 AL8N-6 A9 B9 C9 D9 E9 F9 G9 G9 =Somma(A9:G9) N-6 P9 Q9 R9 S9 T9 U9 V9 V9.1 N-6 AE9 AF9 AG9 AH9 AI9 AJ9 AK9 AK9N-5 A10 B10 C10 D10 E10 F10 F10 =Somma(A10:F10) N-5 P10 Q10 R10 S10 T10 U10 U10.1 N-5 AE10 AF10 AG10 AH10 AI10 AJ10 AJ10N-4 A11 B11 C11 D11 E11 E11 =Somma(A11:E11) N-4 P11 Q11 R11 S11 T11 T11.1 N-4 AE11 AF11 AG11 AH11 AI11 AI11N-3 A12 B12 C12 D12 D12 =Somma(A12:D12) N-3 P12 Q12 R12 S12 S12.1 N-3 AE12 AF12 AG12 AH12 AH12N-2 A13 B13 C13 C13 =Somma(A13:C13) N-2 P13 Q13 R13 R13.1 N-2 AE13 AF13 AG13 AG13N-1 A14 B14 B14 =Somma(A14;B14) N-1 P14 Q14 Q14.1 N-1 AE14 AF14 AF14N A15 A15 A15 N P15 P15.1 N AE15 AE15

Total =O1+…A15 formula=SOMMA Total =JO.1+…Q14.1 Tot =J0+…+AE15

Reinsurance Recoveries received (non-cumulative) Undiscounted Best Estimate Claims Provisions - Reinsurance recoverable Reinsurance RBNS Claims(absolute amount) (absolute amount) (absolute amount)

Development year Development year Development year

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + In Current year Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year end

Prior J16 J16 Prior J16 J16.1 Prior J0 J0N-14 A17 B17 C17 D17 E17 F17 G17 H17 I17 J17 K17 L17 M17 N17 O17 O17 =Somma(A17:O17) N-14 P17 Q17 R17 S17 T17 U17 V17 W17 X17 Y17 Z17 AA17 AB17 AC17 AD17 AD17.1 N-14 AE17 AF17 AG17 AH17 AI17 AJ17 AK17 AL17 AM17 AN17 AO17 AP17 AQ17 AR17 AS17 AS17N-13 A18 B18 C18 D18 E18 F18 G18 H18 I18 J18 K18 L18 M18 N18 N18 =Somma(A18:N18) N-13 P18 Q18 R18 S18 T18 U18 V18 W18 X18 Y18 Z18 AA18 AB18 AC18 AC18.1 N-13 AE18 AF18 AG18 AH18 AI18 AJ18 AK18 AL18 AM18 AN18 AO18 AP18 AQ18 AR18 AR18N-12 A19 B19 C19 D19 E19 F19 G19 H19 I19 J19 K19 L19 M19 M19 =Somma(A19:M19) N-12 P19 Q19 R19 S19 T19 U19 V19 W19 X19 Y19 Z19 AA19 AB19 AB19.1 N-12 AE19 AF19 AG19 AH19 AI19 AJ19 AK19 AL19 AM19 AN19 AO19 AP19 AQ19 AQ19N-11 A20 B20 C20 D20 E20 F20 G20 H20 I20 J20 K20 L20 L20 =Somma(A20:L20) N-11 P20 Q20 R20 S20 T20 U20 V20 W20 X20 Y20 Z20 AA20 AA20.1 N-11 AE20 AF20 AG20 AH20 AI20 AJ20 AK20 AL20 AM20 AN20 AO20 AP20 AP20N-10 A21 B21 C21 D21 E21 F21 G21 H21 I21 J21 K21 K21 =Somma(A21:K21) N-10 P21 Q21 R21 S21 T21 U21 V21 W21 X21 Y21 Z21 Z21.1 N-10 AE21 AF21 AG21 AH21 AI21 AJ21 AK21 AL21 AM21 AN21 AO21 AO21N-9 A22 B22 C22 D22 E22 F22 G22 H22 I22 J22 J22 =Somma(A22:J22) N-9 P22 Q22 R22 S22 T22 U22 V22 W22 X22 Y22 Y22.1 N-9 AE22 AF22 AG22 AH22 AI22 AJ22 AK22 AL22 AM22 AN22 AN22N-8 A23 B23 C23 D23 E23 F23 G23 H23 I23 I23 =Somma(A23:I23) N-8 P23 Q23 R23 S23 T23 U23 V23 W23 X23 X23.1 N-8 AE23 AF23 AG23 AH23 AI23 AJ23 AK23 AL23 AM23 AM23N-7 A24 B24 C24 D24 E24 F24 G24 H24 H24 =Somma(A24:H24) N-7 P24 Q24 R24 S24 T24 U24 V24 W24 W24.1 N-7 AE24 AF24 AG24 AH24 AI24 AJ24 AK24 AL24 AL24N-6 A25 B25 C25 D25 E25 F25 G25 G25 =Somma(A25:G25) N-6 P25 Q25 R25 S25 T25 U25 V25 V25.1 N-6 AE25 AF25 AG25 AH25 AI25 AJ25 AK25 AK25N-5 A26 B26 C26 D26 E26 F26 F26 =Somma(A26:F26) N-5 P26 Q26 R26 S26 T26 U26 U26.1 N-5 AE26 AF26 AG26 AH26 AI26 AJ26 AJ26N-4 A27 B27 C27 D27 E27 E27 =Somma(A27:E27) N-4 P27 Q27 R27 S27 T27 T27.1 N-4 AE27 AF27 AG27 AH27 AI27 AI27N-3 A28 B28 C28 D28 D28 =Somma(A28:D28) N-3 P28 Q28 R28 S28 S28.1 N-3 AE28 AF28 AG28 AH28 AH28N-2 A29 B29 C29 C29 =Somma(A29:C29) N-2 P29 Q29 R29 R29.1 N-2 AE29 AF29 AG29 AG29N-1 A30 B30 B30 =Somma(A30:B30) N-1 P30 Q30 Q30.1 N-1 AE30 AF30 AF30N A31 A31 =A31 N P31 P31.1 N AE31 AE31

Total =O17+…+A31 formula=SOMMA Total =J16.1+…P31.1 Total =J0+…+AE31

Net Claims Paid (non-cumulative) Net Undiscounted Best Estimate Claims Provisions Net RBNS Claims(absolute amount) (absolute amount) (absolute amount)

Development year Development year Development year

Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + In Current year Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 & + Year end

Prior formula formula Prior formula formula Prior formula formulaN-14 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-14 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-14 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formulaN-13 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-13 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-13 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formulaN-12 formula formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-12 formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-12 formula formula formula formula formula formula formula formula formula formula formula formula formula formulaN-11 formula formula formula formula formula formula formula formula formula formula formula formula formula formula N-11 formula formula formula formula formula formula formula formula formula formula formula formula formula N-11 formula formula formula formula formula formula formula formula formula formula formula formula formulaN-10 formula formula formula formula formula formula formula formula formula formula formula formula formula N-10 formula formula formula formula formula formula formula formula formula formula formula formula N-10 formula formula formula formula formula formula formula formula formula formula formula formulaN-9 formula formula formula formula formula formula formula formula formula formula formula formula N-9 formula formula formula formula formula formula formula formula formula formula formula N-9 formula formula formula formula formula formula formula formula formula formula formulaN-8 formula formula formula formula formula formula formula formula formula formula formula N-8 formula formula formula formula formula formula formula formula formula formula N-8 formula formula formula formula formula formula formula formula formula formulaN-7 formula formula formula formula formula formula formula formula formula formula N-7 formula formula formula formula formula formula formula formula formula N-7 formula formula formula formula formula formula formula formula formulaN-6 formula formula formula formula formula formula formula formula formula N-6 formula formula formula formula formula formula formula formula N-6 formula formula formula formula formula formula formula formulaN-5 formula formula formula formula formula formula formula formula N-5 formula formula formula formula formula formula formula N-5 formula formula formula formula formula formula formulaN-4 formula formula formula formula formula formula formula N-4 formula formula formula formula formula formula N-4 formula formula formula formula formula formulaN-3 formula formula formula formula formula formula N-3 formula formula formula formula formula N-3 formula formula formula formula formulaN-2 formula formula formula formula formula N-2 formula formula formula formula N-2 formula formula formula formulaN-1 formula formula formula formula N-1 formula formula formula N-1 formula formula formulaN formula formula formula N formula formula N formula formula

Total formula formula Total formula Total formula

ADDITIONAL INFORMATION: INFLATION RATES (only in the case of using methods that take into account inflation to adjust data)

N-14 N-13 N-12 N-11 N-10 N-9 N-8 N-7 N-6 N-5 N-4 N-3 N-2 N-1 NHistoric inflation rate - total

Historic inflation rate: external inflationHistoric inflation rate: endogenous inflation

N+1 N+2 N+3 N+4 N+5 N+6 N+7 N+8 N+9 N+10 N+11 N+12 N+13 N+14Expected inflation rate - total

Expected inflation rate: external inflationExpected inflation rate: endogenous inflation

Cell not relevant

Cell used more than once in one single template

Cell reported in a different

template

Accident year /Underwriting year

Sum of years (cumulative)

Year end (discounted data)

Sum of years (cumulative)

Year end (discounted data)

Sum of years (cumulative)

Year end (discounted data)

Description of inflation rate used:

Page 76: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E4

E4: Movements of RBNS Claims

Cell not relevant Formula

Line of business:Reporting Year N

(1) (2) (3) (4) (5) (6) (7) (8) (9) (10) (11) (12) (13) (14) (15) (16) (17) (18) (19) (20)

Gross

RBNS claims. Open Claims at the beginning of the year Claims reported during the year Reopen Claims during the year

Open Claims at the end of the periodClosed Claims at the end of the period:

Open Claims at the end of the periodClosed Claims at the end of the period:

Open Claims at the end of the period Closed Claims at the end of the period:settled settled without any payment settled

Number of claims Number of claims Number of claims

Prior A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1 Q1 R1 S1 T1N-14 A2 B2 C2 D2 E2 F2 G2 H2 I2 J2 K2 L2 M2 N2 O2 P2 Q2 R2 S2 T2N-13 A3 B3 C3 D3 E3 F3 G3 H3 I3 J3 K3 L3 M3 N3 O3 P3 Q3 R3 S3 T3N-11 A4 B4 C4 D4 E4 F4 G4 H4 I4 J4 K4 L4 M4 N4 O4 P4 Q4 R4 S4 T4

N - 10 A5 B5 C5 D5 E5 F5 G5 H5 I5 J5 K5 L5 M5 N5 O5 P5 Q5 R5 S5 T5N - 9 A6 B6 C6 D6 E6 F6 G6 H6 I6 J6 K6 L6 M6 N6 O6 P6 Q6 R6 S6 T6N - 8 A7 B7 C7 D7 E7 F7 G7 H7 I7 J7 K7 L7 M7 N7 O7 P7 Q7 R7 S7 T7N - 7 A8 B8 C8 D8 E8 F8 G8 H8 I8 J8 K8 L8 M8 N8 O8 P8 Q8 R8 S8 T8N - 6 A9 B9 C9 D9 E9 F9 G9 H9 I9 J9 K9 L9 M9 N9 O9 P9 Q9 R9 S9 T9N - 5 A10 B10 C10 D10 E10 F10 G10 H10 I10 J10 K10 L10 M10 N10 O10 P10 Q10 R10 S10 T10N - 4 A11 B11 C11 D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11 P11 Q11 R11 S11 T11N - 3 A12 B12 C12 D12 E12 F12 G12 H12 I12 J12 K12 L12 M12 N12 O12 P12 Q12 R12 S12 T12N - 2 A13 B13 C13 D13 E13 F13 G13 H13 I13 J13 K13 L13 M13 N13 O13 P13 Q13 R13 S13 T13N - 1 A14 B14 C14 D14 E14 F14 G14 H14 I14 J14 K14 L14 M14 N14 O14 P14 Q14 R14 S14 T14

Total previous year =Somma(A1:A14) =Somma(B1:B14) =Somma(C1:C14) =Somma(D1:D14) =Somma(E1:E10) =Somma(F1:F14) =Somma(G1:G14) =Somma(H1:H14) =Somma(I1:I14) =Somma(J1:J14) =Somma(K1:K14) =Somma(L1:L14) =Somma(M1:M14) =Somma(N1:N14) =Somma(O1:O14) =Somma(P1:P14) =Somma(Q1:Q14) =Somma(R1:R14) =Somma(S1:S14) =Somma(T1:T14)

N J15 K15 L15 M15 N15 O15Total =Somma(J1:J14)+J15 =Somma(K1:K14)+K15 =Somma(L1:L14)+L11 =Somma(M1:M14)+M14 =Somma(N1:N14)+N15 =Somma(O1:O14)+O15

Cell used more than once in one single

template Cell reported in a different template

Accident year/ underwriting year

settled without any payment

YearGross RBNS at the beginning of the year

Gross payments made during the current year

Gross RBNS at the end of the period

Number of claims ended with payments

Gross RBNS at the beginning of the year

Gross payments made during the

current year

Number of claims ended without any payments

Gross RBNS at the beginning of the year referred to claim settled without any payment

Gross payments made during the

current year

Gross RBNS at the end of the

period

Number of claims ended with payments

Gross payments made during the

current year

Number of claims ended without any

payments

Gross payments made during the

current year

Gross RBNS at the end of the

period

Number of claims ended with payments

Gross payments made during the

current year

Page 77: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E6

document.xlsx Page 77 05/06/2023

Technical provisions non-life E6

Loss distribution profile non-lifeCell not relevant Formula

Line of business A00

1 2 3 4 5 6 7 8 9 10 11 12 31 32

A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 AE1 AF1A20 B20 C20 D20 E20 F20 G20 H20 I20 J20 K20 L20 AE20 AF20A21 B21 C21 D21 E21 F21 G21 H21 I21 J21 K21 L21 AE21 AF21

Total sum(C1..C21) sum(D1..D21) sum(E1..E21) sum(F1..F21) sum(G1..G21) sum(H1..H21) sum(I1..I21) sum(J1..J21) sum(K1..K21) sum(L1..L21) sum(AE1..AE21) sum(AF1..AF21)

Cell used more than once in one single

template Cell reported in a different template

Start claims incurred

End claims incurred

Number of claims UWY/AY N

Total claims incurred UWY/AY N

Number of claims UWY/AY N-1

Total claims incurred UWY/AY

N-1Number of claims

UWY/AY N-2

Total claims incurred UWY/AY

N-2Number of claims

UWY/AY N-3

Total claims incurred UWY/AY

N-3Number of claims

UWY/AY N-4

Total claims incurred UWY/AY

N-4Number of claims

UWY/AY N-14

Total claims incurred UWY/AY

N-14

Page 78: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E7A

document.xlsx Page 78 05/06/2023

Technical provisions non-life - E7A

Underwriting risks non-life Cell not relevant Formula

Peak risks (based on net retention)

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Description risk Line of business Currency Sum insured (SI)A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1=I1-J1-M1-N1

Cell used more than once in one single

template Cell reported in a different template

Risk identification

code(Policy number)

InsuredDescription risk

category coveredValidity period

(start date)Validity period (expiry date)

Original deductible

policyholder

Type of underwriting

model (SI, MPL, PML, EML or

Other)

Amount underwriting

model

Amount share sum insured facultative reinsurers

Amount share sum insured

other reinsurersNet retention of

the insurer

Page 79: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

TP - E7B

document.xlsx Page 79 05/06/2023

Technical provisions non-life - E7B

Underwriting risks non-life Cell not relevant Formula

Underwriting risk portfolio

Line of business A00

1 2 3 4 5

End sum insured Total sum insuredA1 B1 C1 D1 E1

A20 B20 C20 D20 E20A21 B21 C21 D21 E21

Cell used more than once in one single

template Cell reported in a different template

Start sum insured

Number of underwriting

risksTotal annual

premium

Page 80: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Duration of liabilities

Duration of liabilities, Life FS-1 A7Duration of liabilities, Non-Life FS-1 A8

Legend Scope

Cell not relevant

Blue reflects requirements of reporting for financial stability

Solo undertakings above the threshold and not belonging to groups with FS deadlines

Cell used more than once in one single

template Cell reported in a different template

Page 81: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Formula

Page 82: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Reinsurance - J1_basic

Facultative covers non-life (10 most important risks in terms of reinsured exposure)Cell not relevant Formula

Line of business A00

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

Description risk Currency Sum insured (SI)A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1 Q1

Facultative covers life (10 most important risks in terms of reinsured exposure)

Line of business A01

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

Currency Insured capital Risk capitalA11 B11 C11 D11 E11 F11 G11 H11 I11 J11 K11 L11 M11 N11 O11

Cell used more than once in one single template

Cell reported in a different template

These are fields in common with Re-J1_shares and could be automatically duplicated to Re-J1_shares.

Reinsurance program code

Risk identification

code

Facultative reinsurance placement

identification code

Non-traditional reinsurance

and/or Finite Re (Y/N)

Proportional (Y/N)

(Policy number) Insured

Description risk category covered

Validity period (start date)

Validity period (expiry date)

Type of underwriting

model (SI, MPL, PML, EML or

Other)

Amount underwriting

model

100%Amount

reinsured on a facultative basis,

with all reinsurers

100% Facultative reinsurance

premium ceded to all

reinsurers for 100% of the reinsurance placement

Facultative reinsurance commission

These are fields in common with Re-J1_shares and could be automatically duplicated to Re-J1_shares.

Reinsurance program code

Risk identification

code

Facultative reinsurance placement

identification code

Non-traditional reinsurance

and/or Finite Re (Y/N)

Proportional (Y/N)

(Policy number) Insured

Description risk category covered

Validity period (start date)

Validity period (expiry date)

100%Amount

reinsured on a facultative basis,

with all reinsurers

100% Facultative reinsurance

premium ceded to all

reinsurers for 100% of the reinsurance placement

Facultative reinsurance commission

Page 83: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Reinsurance - J1_shares

Facultative covers non-life (10 most important risks in terms of reinsured exposure)

Line of business A00Cell not relevant Formula

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Code reinsurer Type of reinsurer Rating Rating agency Code broker Currency AnnotationsA1 B1 C1 D1 E1 (D1-result) F1 (D1-result) G1 (D1-result) H1 I1 J1 K1 L1 (K1 -result) M1 N1 O1 P1="Re-J1_basic_O1"*N1 Q1="Re-J1_basic_P1"*N1) R1

Facultative covers life (10 most important risks in terms of reinsured exposure)

Line of business A01

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Code reinsurer Type of reinsurer Rating Rating agency Code broker Currency AnnotationsA11 B11 C11 D11 E11 (D11-result) F11 (D1-result) G11(D11-result) H11 I11 J11 K11 L11 (K11 -result) M11 N11 O11 P11="Re-1_basic_M11" *N11 Q11="Re-J1_basic_N11" *N11 R11

These fields are in common with Re-J1_basic and could be automatically replicated from Re-J1_basic.

Cell used more than once in one single template

Cell reported in a different template

Reinsurance program code

Risk identification

code

Facultative reinsurance placement

identification code

Legal name reinsurer

Country of residency

Date rating assigned

Legal name broker

Activity code broker

Share reinsurer (%)

Amount of exposure ceded to facultative reinsurer

Facultative cededreinsurance premium

These fields are in common with Re-J1_basic and could be automatically replicated from Re-J1_basic.

Reinsurance program code

Risk identification

code

Facultative reinsurance placement

identification code

Legal name reinsurer

Country of residency

Date rating assigned

Legal name broker

Activity code broker

Share reinsurer (%)

Amount of exposure ceded to facultative reinsurer

Facultative ceded reinsurance premium

Page 84: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Reinsurance - J2_basic

Outgoing Reinsurance Program in the next reporting year

Cell not relevant Formula

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Line of business Currency Limit (amount) Limit (%) XL rate 1 XL rate 2A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1 Q1 R1 S1 T1 U1 V1 W1 X1 Y1 Z1 AA1 AB1 AC1 AD1 AE1

Legend Scope

These are fields in common with Re-J2_shares and could be automatically duplicated to Re-J2_shares.

Cell used more than once in one single

template Cell reported in a different template

Reinsurance program code

Treaty identification

code

Progressive section number

in treaty

Progressive number of

surplus/layer in program

Quantity of surplus/layers in

program

Non-traditional reinsurance

and/or Finite Re (Y/N)

Description risk category covered

Type of reinsurance treaty

Inclusion of catastrophic guarantees

Validity period (start date)

Validity period (expiry date)

Type of underwriting

model (SI, MPL, PML, EML)

Estimated Subject Premium income (XL-ESPI)

Gross Estimated Treaty Premium

Income (proportional and non proportional)

Aggregate deductibles

(amount)

Aggregate deductibles

(%)

Retention or priority (amount)

Retention or priority (%)

Maximum cover per risk or event

Maximum cover per treaty

Number and descriptions of reinstatements

Reinsurance Commission (flat or sliding)

Overriding commission

(flat or sliding)

Profit commission

(flat or sliding) XL premium flat

(Y/N)

Blue reflects requirements of reporting for financial stability

Solo undertakings above the threshold and not belonging to groups with FS

deadlines

Page 85: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Reinsurance - J2_shares

Outgoing Reinsurance Program in the next reporting year

Cell not relevant Formula

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18

Code reinsurer Type of reinsurer Rating Rating agency Code broker Currency AnnotationsNew reference A1 B1 C1 D1 E1 (D1-result) F1 (D1-result) G1 (D1-result) H1 I1 J1 K1 L1 (K1-result) M1 N1 O1 P1="Re-2_basic_W1"*N1 Q1="Re-J2_basic_P1"*N1) R1

Legend Scope

These fields are in common with Re-J2_basic;they could be automatically replicated

Cell used more than once in one single

template Cell reported in a different template

Reinsurance program code

Treaty identification

code

Progressive section number

in treatyLegal name

reinsurerCountry of residency

Date rating assigned

Legal name broker

Activity code broker

Share reinsurer (%)

Exposure ceded for reinsurer's share

(amount)

Estimated outgoing reinsurance premium for

reinsurer's share

Blue reflects requirements of reporting for financial stability

Solo undertakings above the threshold and not belonging to groups with FS

deadlines

Page 86: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Reinsurance - J3

Share of reinsurersCell not relevant Formula

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20Reinsurance recoverables Guarantees received

Code reinsurer Type of reinsurer Rating Rating agency Code broker Net receivables Cash depositsA1 B1 C1 (B1-result) D1 (B1-result) E1 (B1-result) F1 G1 H1 I1 J1 (I1-result) K1 L1 M1 N1 O1=L1+M1+N1 P1 Q1 R1 S1 T1=Q1+R1+S1

Cell used more than once in one single template

Cell reported in a different template

Name of reinsured entity (only for groups)

Legal name reinsurer

Country of residency

Date rating assigned

Legal name broker

Activity code broker

Premium provision Non-life

including Non-SLT Health

Claims provisions Non-

life including Non-SLT Health

Technical provisions Life including SLT

HealthTotal reinsurance

recoverablesAssets pledged

by reinsurerFinancial

guaranteesTotal guarantees

received

Page 87: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

document.xlsx Pagina 87

SPV

Special Purpose Insurance Vehicles Cell not relevant Formula

Identification Risk(s) ceded Risk transfer Assets for settling cedant-specific obligations Alignment of interests

Name of SPV Rating agency ID Code Type Current recoverables from SPVA1 B1 B1A C1 E1 D1 F1 F1A G1 H1 I1 J1 K1 L1 M1 N1 O1 Q1 R1 S1 U1 V1 W1 X1 Y1 Z1

Cell used more than once in one single

template Cell reported in a different template

Recoverables (prior to adjusments for expected losses)

Name of reinsured entity (only for groups)

Legal nature of SPV

Incorporation no. of SPV (where

applicable)SPV authorisation

conditions

SPV country of authorisation

(where applicable)

SPV External Rating

ID Code of SPV notes or other

financing mechanism

issued

Portfolio to which SPV

securitisation relates

Type of Risks Transferred

Type of Trigger(s) in the SPV

Contractual trigger event

Same trigger as in underlying

cedant's portfolio? (Y/N)

Basis risk arising from risk-transfer

structure

Basis risk arising from contractual

terms

SPV assets ring-fenced to settle cedant-specific

obligations

Other non cedant-specific SPV Assets for which recourse

may exist

Other recourse arising from

securitisation

Total maximum possible

obligations from SPV under

reinsurance policy

SPV sufficiently collateralised to

meet cedant obligations

throughout the reporting period

(Y/N)

Identification of material investments held by cedant in securitisation

Classification of cedant

investment in SPV

Securitisation assets related to

cedant held in trust with other third party than

cedant / sponsor? (Y/N)

Page 88: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

Profit or loss sharing

FS-1 A6

Legend Scope

Cell not relevant

Average profit (or loss) sharing (i.e. own fund share of gain/loss)

Blue reflects requirements of reporting for financial stability

the threshold and not belonging to groups with

FS deadlines

Page 89: eiopa. · XLS file · Web view · 2015-09-14b9=somme(b1:b7) b14=somme(b10:b13) ... s19 t19 u19 ch19 dh19 fh19 v19 x19 y19 z19 gh19 au20 cu20 du20 fu20 n20 o20 p20 q20 r20 s20 t20

FormulaCell used more

than once in one single template

Cell reported in a different

template