Get documents about "TP E3 Finanssivalvonta (Excel)
Shared by: dandanhuanghuang
-
Stats
- views:
- 9
- posted:
- 10/1/2011
- language:
- English
- pages:
- 5
Document Sample
Jump To
Tab Title Content
Go Index Index sheet
Go BS-C1 Balance sheet
Go BS-C1B Off-balance sheet items
Go BS-C1D Assets and liabilities by currency
Go OF - B1A Own funds (annual template)
Go OF - B1Q Own funds (quarterly template)
Go SCR - B2A Solvency capital requirement (for undertaking on standard formula or partial internal models)
Go SCR - B2B Solvency capital requirement (for undertakings on partial internal models)
Go SCR - B2C Solvency capital requirement (for undertaking on internal models)
Go SCR - B3A Solvency capital requirement - market risk
Go SCR - B3B Solvency capital requirement - counterparty risk
Go SCR - B3C Solvency capital requirement - life underwriting risk
Go SCR - B3D Solvency capital requirement - health underwriting risk
Go SCR - B3E Solvency capital requirement - non-life underwriting risk
Go SCR - B3F Solvency capital requirement - non-life catastrophe risk
Go SCR - B3G Solvency capital requirement - operational risk
Go MCR - B4A Minimum capital requirement (except for composite undertakings)
Go MCR - B4B Minimum capital requirement (for composite insurance undertakings)
Go C2 - Summary Analysis of change in Basic Own Funds
Go C2 - Analysis_Life Analysis of change in Basic Own Funds in Reporting Period from risks accepted during period
Analysis of change in Basic Own Funds in Reporting Period from risks accepted prior to period
Go C2 - Analysis_NonLife
Go Country - K1 Activity by country
Go Cover - A1 Premiums, claims & expenses - quarterly data
Go Assets - D1 Investments Data - Portfolio list (detailed list of investments)
Go Assets - D1A Structured products Data - Portfolio list
Go Assets - D2 Derivatives data
Go Assets - D3 Return on investment assets (by asset category)
Go Assets - D4 Investment funds (look-through approach)
Go Assets - D5 Securities lending and repos
Go Assets - D6 Assets held for collateral (especially of ceded reinsurance)
Go TP - F1 Life and Health SLT Technical Provisions (annual)
Go TP - F1Q Life and Health SLT Technical Provisions (quarterly)
Go TP - F2 Projection of future cash flows (Best Estimate - Life)
Go TP - F3 Life obligations analysis
Go TP - F3A Only for Variable Annuities - Description of guarantees by product
Go TP - F3B Only for Variable Annuities - Hedging of guarantees
Go TP - F4 Information on annuities and life-like liabilities stemming from Non-Life and Health non-SLT Claims
Go TP - E1 Non-Life and Health non-SLT Technical Provisions (annual)
Go TP - E1Q Non-Life and Health non-SLT Technical Provisions (quarterly)
Go TP - E2 Projection of future cash flows (non-life)
Go TP - E3 Non-life Insurance Claims Information
Go TP - E4 Movements of Non-life outstanding claim provision
Go TP - E5 Non-life Insurance Premium and Expense Information
Go TP - E6 (old Re - J4A) Loss profile non-life
Go TP - E7 (old Re - J4B) Underwriting risks non-life & life
Go Re - J1 Facultative covers non-life & life
Go Re - J2 Outgoing Reinsurance Program in the next reporting year
Go Re - J3 Share of reinsurers
Go SPV Special Purpose Insurance Vehicles
BS-C1
C1
Balance sheet
Solvency II value Statutory accounts
Assets
valuation basis
Goodwill AS1
Deferred acquisition costs AS24
Other intangible assets A2 AS2
Deferred tax assets A26 AS26
Pension benefit surplus A25B AS25B
Property, plant & equipement held for own use A3 AS3
AS4=AS5+AS6+AS7+AS
A4=A5+A6+A7+A7A+A8+ 7A+AS8+AS8A+AS8C+A
Investments (other than assets held for unit-linked funds)
A8A+A8C+A8D+A9+A10 S8D+AS9+AS10A+AS10
A+A10B+A11+A14 B+AS11+AS14
Property (other than own use) A5 AS5
Participations A6 AS6
Equities - listed A7 AS7
Equities - unlisted A7A AS7A
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
Loans & mortgages (except loans on policies) A14 AS14
Other investments A11 AS11
Assets held for unit-linked & index-linked A12 AS12
Loans on policies A14A AS14A
Reinsurance recoverables from: A16=A17+A18+A18A+A1 AS16=AS17+AS18+AS18
9+A19A+A20 A+AS19+AS19A+AS20
Non-life excluding health A17 AS17
Health similar to non-life A18 AS18
Health similar to life A18A AS18A
Life excluding health and index- & unit-linked A19 AS19
Life index- & unit-linked A19A AS19A
Deposits to cedants A13 AS13
Insurance & intermediaries receivables A21 AS21
Reinsurance receivables A20 AS20
Receivables (trade, not insurance) A23 AS23
Cash and cash equivalents A27 AS27
Any other assets, not elsewhere shown A29 AS29
Total assets A30=SUM(A2:A29) AS30=SUM(AS1:AS29)
Solvency II value Statutory accounts
Liabilities valuation basis
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
Technical provisions – life (excl health and index- & unit-linked) L7=L7A+L8+L9 LS7
TP calculated as a whole L7A
Best Estimate L8
Risk margin L9
Technical provisions – unit-linked & index-linked L10=L10A+L11+L12 LS10
TP calculated as a whole L10A
Best Estimate L11
Risk margin L12
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 LS15D
Any other liabilities, not elsewhere shown L25 LS25
Total liabilities (excl. Subordinated liabilities in BOF) L25A=SUM(L1:L25) LS25A=SUM(LS1:LS25)
Basic own funds
Subordinated liabilities in BOF L26 LS26
Excess of assets over liabilities L27=A30-L25A-L26
Total liabilities & BOF L30=A30 LS30=AS30
Less : Own shares held by the (re)insurance undertaking L27A LS27A
Less: Minority interests (only for group consolidated balance sheet) L28 LS28
Total basic own funds before adjustments (see OF-B1 for more detail) L29=L30-L27A-L28 LS29=LS30-LS27A-LS28
a32288bf-bf14-4f12-9d88-55f411a03c5f.xls Page 3 10/1/2011
Assets - D1
D1
Investments Data - Portfolio list
Identification section Categorisation section Risk section Data section
Portfolio Fund number Asset held in unit ID Code ID Code type Asset Security Title Issuer Name Issuer Sector Issuer Issuer Country of Currency (ISO CIC Participation External rating Rating Underlying Duration Quantity Unit SII price Valuation Acquisition Total SII amount Maturity date
linked and index pledged as Group Country custody code) agency assets of method SII cost
linked funds (Y/N) collateral (Code) securitization
A26=A22*A23 +
Cell Number A1 A2 A3 A4 A5 A6 A7 A8 A9 A10 A11 A12 A13 A15 A16 A17 A18 A19 A20 A22 A23 A24 A25 accrued interest A28
a32288bf-bf14-4f12-9d88-55f411a03c5f.xls Page 4 10/1/2011
E3 TP - E3
Non-life Insurance Claims Information (including allocated claims management expenses)
Line of Business A00 Methodology used for provisions A01
Tail factor used A02
Latest Year A03: N Currency A04
Gross Claims Paid for development year (non-cumulative) Gross Best Estimate Claims Provisions for development year Gross Claims Outstanding for development year
(absolute amount) (absolute amount) (absolute amount)
Year Development year Year Development year Year Development year
(AY or UWY) Sum of years (AY or UWY) (AY or UWY)
In Current year
1 2 3 4 5 6 7 8 9 10 (cumulative) 1 2 3 4 5 6 7 8 9 10 Year end 1 2 3 4 5 6 7 8 9 10 Year end
Prior J0 J0 J0 Prior U0 U0 Prior AF0 AF0
N-9 A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 J1 =Somma(A1:J1) N-9 L1 M1 N1 O1 P1 Q1 R1 S1 T1 U1 U1 N-9 U1 V1 W1 X1 AA1 AB1 AC1 AD1 AE1 AF1 AF1
N-8 A2 B2 C2 D2 E2 F2 G2 H2 I2 I2 =Somma(A2:I2) N-8 L2 M2 N2 O2 P2 Q2 R2 S2 T2 T2 N-8 U2 V2 W2 X2 AA2 AB2 AC2 AD2 AE2 AE2
N-7 A3 B3 C3 D3 E3 F3 G3 H3 H3 =Somma(A3:H3) N-7 L3 M3 N3 O3 P3 Q3 R3 S3 S3 N-7 U3 V3 W3 X3 AA3 AB3 AC3 AD3 AD3
N-6 A4 B4 C4 D4 E4 F4 G4 G4 =Somma(A4:G4) N-6 L4 M4 N4 O4 P4 Q4 R4 R4 N-6 U4 V4 W4 X4 AA4 AB4 AC4 AC4
N-5 A5 B5 C5 D5 E5 F5 F5 =Somma(A5:F5) N-5 L5 M5 N5 O5 P5 Q5 Q5 N-5 U5 V5 W5 X5 AA5 AB5 AB5
N-4 A6 B6 C6 D6 E6 E6 =Somma(A6:E6) N-4 L6 M6 N6 O6 P6 P6 N-4 U6 V6 W6 X6 AA6 AA6
N-3 A7 B7 C7 D7 D7 =Somma(A7:D7) N-3 L7 M7 N7 O7 O7 N-3 U7 V7 W7 X7 X7
N-2 A8 B8 C8 C8 =Somma(A8:C8) N-2 L8 M8 N8 N8 N-2 U8 V8 W8 W8
N-1 A9 B9 B9 =Somma(A9;B9) N-1 L9 M9 M9 N-1 U9 V9 V9
N A10 A10 A10 N L10 L10 N U10 U10
Total =J0+…A10 formula=SOMMA Total =UO+…L10 Total =AFO+…U10
Salvage and subrogation included within Gross Claims Paid for development year (non-cumulative) Salvage and subrogation included within Gross Claims Outstanding for development year
(absolute amount) (absolute amount)
Development year Development year
Year Year
(AY or UWY) Sum of years (AY or UWY)
In Current year
1 2 3 4 5 6 7 8 9 10 (cumulative) 1 2 3 4 5 6 7 8 9 10 Year end
Prior J2 J2 J2 Prior AF2 AF2
N-9 A11 B10 C9 D8 E7 F6 G5 H4 I3 J3 J3 =Somma(A11:J3) N-9 U11 V10 W9 X8 AA7 AB6 AC5 AD4 AE3 AF3 AF3
N-8 A12 B11 C10 D9 E8 F7 G6 H5 I4 I4 =Somma(A12:I4) N-8 U12 V11 W10 X9 AA8 AB7 AC6 AD5 AE4 AE4
N-7 A13 B12 C11 D10 E9 F8 G7 H6 H6 =Somma(A13:H6) N-7 U13 V12 W11 X10 AA9 AB8 AC7 AD6 AD6
N-6 A14 B13 C12 D11 E10 F9 G8 G8 =Somma(A14:G8) N-6 U14 V13 W12 X11 AA10 AB9 AC8 AC8
N-5 A15 B14 C13 D12 E11 F10 F10 =Somma(A15:F10) N-5 U15 V14 W13 X12 AA11 AB10 AB10
N-4 A16 B15 C14 D13 E12 E12 =Somma(A16:E12) N-4 U16 V15 W14 X13 AA12 AA12
N-3 A17 B16 C15 D14 D14 =Somma(A17:D14) N-3 U17 V16 W15 X14 X14
N-2 A18 B17 C16 C16 =Somma(A18:C16) N-2 U18 V17 W16 W16
N-1 A19 B18 B18 =Somma(A19;B18) N-1 U19 V18 V18
N A20 A20 A20 N U20 U20
Total =J2+…A20 formula=SOMMA Total =AF2+…+U20
Reinsurance Recoveries received for development year (non-cumulative) Best Estimate Claims Provisions for development year - Reinsurance recoverable Reinsurance Claims Outstanding for development year
(absolute amount) (absolute amount) (absolute amount)
Development year Development year Development year
Year Year Year
(AY or UWY) Sum of years (AY or UWY) (AY or UWY)
In Current year
1 2 3 4 5 6 7 8 9 10 (cumulative) 1 2 3 4 5 6 7 8 9 10 Year end 1 2 3 4 5 6 7 8 9 10 Year end
Prior J4 J4 J4 Prior U2 U2 Prior AF4 AF4
N-9 A21 B19 C17 D15 E13 F11 G9 H7 I5 J5 J5 =Somma(A21:J5) N-9 L21 M10 N9 O8 P7 Q6 R5 S4 T3 U3 U3 N-9 U21 V19 W17 X15 AA13 AB11 AC9 AD7 AE5 AF5 AF5
N-8 A22 B20 C18 D16 E14 F12 G10 H8 I6 I6 =Somma(A12:I6) N-8 L22 M11 N10 O9 P8 Q7 R6 S5 T4 T4 N-8 U22 V20 W18 X16 AA14 AB12 AC10 AD8 AE6 AE6
N-7 A23 B21 C19 D17 E15 F13 G11 H9 H9 =Somma(A23:H9) N-7 L23 M12 N11 O10 P9 Q8 R7 S6 S6 N-7 U23 V21 W19 X17 AA15 AB13 AC11 AD9 AD9
N-6 A24 B22 C20 D18 E16 F14 G12 G12 =Somma(A24:G12) N-6 L24 M13 N12 O11 P10 Q9 R8 R8 N-6 U24 V22 W20 X18 AA16 AB14 AC12 AC12
N-5 A25 B23 C21 D19 E17 F15 F15 =Somma(A25:F15) N-5 L25 M14 N13 O12 P11 Q10 Q10 N-5 U25 V23 W21 X19 AA17 AB15 AB15
N-4 A26 B24 C22 D20 E18 E18 =Somma(A26:E18) N-4 L26 M15 N14 O13 P12 P12 N-4 U26 V24 W22 X20 AA18 AA18
N-3 A27 B25 C23 D21 D21 =Somma(A27:D21) N-3 L27 M16 N15 O14 O14 N-3 U27 V25 W23 X21 X21
N-2 A28 B26 C24 C24 =Somma(A28:C24) N-2 L28 M17 N16 N16 N-2 U28 V26 W24 W24
N-1 A29 B27 B27 =Somma(A29;B27) N-1 L29 M18 M18 N-1 U29 V27 V27
N A30 A30 A30 N L30 L30 N U30 U30
Total =J4+…+A30 formula=SOMMA Total =U2+…+L30 Total =AF4+…+U30
Net Claims Paid for development year (non-cumulative) Net Best Estimate Claims Provisions for development year Net Claims Outstanding for development year
(absolute amount) (absolute amount) (absolute amount)
Year Development year Year Development year Year Development year
(AY or UWY) Sum of years (AY or UWY) (AY or UWY)
1 2 3 4 5 6 7 8 9 10 In Current year (cumulative) 1 2 3 4 5 6 7 8 9 10 Year end 1 2 3 4 5 6 7 8 9 10 Year end
Prior J6=J0-J2-J4 J6 J6 Prior U4=U0-U2 U4 Prior AF6=AF0-AF2-AF4 AF6
N-9 B28=B1-B10-B19
A31=A1-A11-A21 D E F16=F1-F6-F11G13=G1-G5-G9H10=H1-H4-H7I7=I1-I3-I5
C25=C1-C9-C17 22=D1-D8-D15 19=E1-E7-E13 J7=J1-J3-J5 J7 =Somma(A31:J7) N-9 L31=L1-L21 M19=M1-M10 N17=N1-N9 O15=O1-O8 P13=P1-P7 Q11=Q1-Q6 R9=R1-R5 S7=S1-S4 T4=T1-T3 U5=U1-U3 U5 N-9 U31=U1-U11-U21
V28=V1-V10-V19
W25=W1-W9-W17
X22=X1-X8-X15AA19=AA1-AA7-AA13
AB16=AB1-AB6-AB11
AC13=AC1-AC5-AC9
AD10=AD1-AD4-AD7 AF7=AF1-AF3-AF5
AE7=AE1-AE3-AE5 AF7
N-8 B29=B2-B11-B20
A32=A2-A12-A22 C26=C2-C10-C18
D23=D2-D9-D16 20=E2-E8-E14
E H11=H2-H5-H8I8=I2-I4-I6
F17=F2-F7-F12G14=G2-G6-G10 I8 =Somma(A32:I8) N-8 L32=L2-L22 M20=M2-M11 N18=N2-N10 O16=O2-O9 P14=P2-P8 Q12=Q2-Q7 R10=R2-R6 S8=S2-S5 T5=T2-T4 T5 N-8 U32=U2-U12-U22
V29=V2-V11-V20
W26=W2-W10-W18
X23=X2-X9-X16AA20=AA2-AA8-AA14
AB17=AB2-AB7-AB12
AC14=AC2-AC6-AC10 AE8=AE2-AE4-AE6
AD11=AD2-AD5-AD8 AE8
N-7 B30=B3-B12-B21
A33=A3-A13-A23 C27=C3-C11-C19
D24=D3-D10-D17 H12=H3-H6-H9
F18=F3-F8-F13G15=G3-G7-G11
E21=E3-E9-E15 H12 =Somma(A33:H12) N-7 L33=L3-L23 M21=M3-M12 N19=N3-N11 O17=O3-O10 P15=P3-P9 Q13=Q3-Q8 R11=R3-R7 S9=S3-S6 S9 N-7 U33=U3-U13-U23
V30=V3-V12-V21
W27=W3-W11-W19
X24=X3-X10-X17
AA21=AA3-AA9-AA15
AB18=AB3-AB8-AB13 AD12=AD3-AD6-AD9
AC15=AC3-AC7-AC11 AD12
N-6 B31=B4-B13-B22
A34=A4-A14-A24 C28=C4-C12-C20
D25=D4-D11-D18
E22=E4-E10-E16
F19=F4-F9-F14G16=G4-G8-G12 G16 =Somma(A34:G16) N-6 L34=L4-L24 M22=M4-M13 N20=N4-N12 O18=O4-O11 P16=P4-P10 Q14=Q4-Q9 R12=R4-R8 R12 N-6 V31=V4-V13-V22
U34=U4-U14-U24 W28=W4-W12-W20
X25=X4-X11-X18
AA22=AA4-AA10-AA16 AC16=AC4-AC8-AC12
AB19=AB4-AB9-AB14 AC16
N-5 B32=B5-B14-B23
A35=A5-A15-A25 C29=C5-C13-C21
D26=D5-D12-D19
E23=E5-E11-E17
F20=F5-F10-F15 F20 =Somma(A35:F20) N-5 L35=L5-L25 M23=M5-M14 N21=N5-N13 O19=O5-O12 P17=P5-P11 Q15=Q5-Q10 Q15 N-5 U35=U5-U15-U25
V32=V5-V14-V23
W29=W5-W13-W21
X26=X5-X12-X19 AB20=AB5-AB10-AB15
AA23=AA5-AA11-AA17 AB20
N-4 B33=B6-B15-B24
A36=A6-A16-A26 C30=C6-C14-C22
D27=D6-D13-D20
E24=E6-E12-E18 E24 =Somma(A36:E24) N-4 L36=L6-L26 M24=M6-M15 N22=N6-N14 O20=O6-O13 P18=P6-P12 P18 N-4 U36=U6-U16-U26
V33=V6-V15-V24
W30=W6-W14-W22 AA24=AA6-AA12-AA18
X27=X6-X13-X20 AA24
N-3 C31=C7-C15-C23
B34=B7-B16-B25
A37=A7-A17-A27 D28=D7-D14-D21 D28 =Somma(A27:D28) N-3 L37=L7-L27 M25=M7-M16 N23=N7-N15 O21=O7-O14 O21 N-3 U37=U7-U17-U27
V34=V7-V16-V25 X28=X7-X14-X21
W31=W7-W15-W23 X28
N-2 B35=B8-B17-B26
A38=A8-A18-A28 C32=C8-C16-C24 C32 =Somma(328:C32) N-2 L38=L8-L28 M26=M8-M17 N24=N8-N16 N24 N-2 U38=U8-U18-U28
V35=V8-V17-V26
W32=W8-W16-W24 W32
N-1 B36=B9-B18-B27
A39=A9-A19-A29 B36 =Somma(A39;B36) N-1 L39=L9-L29 M27=M9-M18 M27 N-1 V36=V9-V18-V27
U39=U9-U19-U29 V36
N A40=A10-A20-A30 A40 A40 N L40=L10-L30 L40 N U40=U10-U20-U30 U40
Total SOMMA=J6+…+A40 formula=SOMMA =U4+…+L40 Total =AF6+…+U40
ADDITIONAL INFORMATION: INFLATION RATES (only in the case of using methods that take into account inflation to adjust data)
N-8 N-7 N-6 N-5 N-4 N-3 N-2 N-1 N
Historic inflation rate - total
Historic inflation rate: external inflation
Historic inflation rate: endogenous inflation
N+1 N+2 N+3 N+4 N+5 N+6 N+7 N+8 N+9
Expected inflation rate - total
Expected inflation rate: external inflation
Expected inflation rate: endogenous inflation
Description of inflation rate used:
a32288bf-bf14-4f12-9d88-55f411a03c5f.xls Page 5 10/1/2011
