{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Index","Control","Participant Information","Regulatory Balance Sheet","Own Funds","Operational Risk","Market Risk","Counterparty Default Risk","Life Underwriting Risk","Health Underwriting Risk","Ring-Fenced Fund Adjustment","SCR Summary","MCR Summary","Revenue Account Total","Revenue Account RFF","Investment Data","Quarterly Industry Statistics","Change Analysis","Revenue Account Projected","Expense Analysis","Annual Industry Statistics","Reinsurance Contracts","Insurance Obligations","Data","Raw Data","Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":5,"defined_names":451,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Index","index":0,"n_rows":82,"n_cols":7,"rows_kept":82,"cut":false,"hidden":false,"merged":[[18,0,18,11]]}
[1,null,null,"Index"]
[]
[]
["Throughout this Return, 'Regulation' refers to the Insurance (Long-Term Business Valuation and Solvency) Regulations 2021 unless stated otherwise. "]
[]
["Where applicable, the terms used in this Return should be taken to have the same meaning as defined in the Regulations."]
[]
["This Return, \"LTB_Return\" should be completed by the insurer for assets and liabilities relating to all its lines of business."]
[]
[" The signatories required in the Participant Information tab must be Controlled Function Role Holders."]
[]
["This Return must be completed in the reporting currency of the insurer. "]
[]
["When expressing the value of any asset or liability denominated in a currency other than the reporting currency, the value shall be converted into the reporting currency "]
["as if the conversion had taken place at the closing exchange rate on the last day for which the appropriate rate is available in the reporting period to which the asset or liability relates. "]
[]
["The conversion into the reporting currency shall be calculated by applying the exchange rate from the same source as that used for the insurer's financial statements."]
[]
["When submitting an annual return in place of a quarterly return, please submit the return twice - one version with 'Quarterly' Selected in cell E6 of the Control tab and one version with 'Annual' selected in cell E6 of the Control tab. "]
[]
[]
[null,null,null,null,null,"Key"]
[]
[null,null,null,null,null,"Input Cell"]
[]
[null,null,null,null,null,"Formula Cell"]
[]
[null,null,null,null,null,"Fixed value cell"]
[]
[null,null,null,null,null,"Fixed value cell"]
[]
[null,null,null,null,null,"           *          \nClick on cell for info"]
[]
[]
[null,"Tab",null,"Content",null,"Quarterly or Annual","Included in scope of Annual Audit?"]
[]
[null,"Control",null,"Specify the return period, and if required, the file locations of returns to be input and macro to be run to amalgamate SCR results by line of business. Use the button to generate the file for submission",null,"Quarterly & Annual","N/A"]
[]
[null,"Participant Information",null,"Information regarding the insurer.",null,"Quarterly & Annual","N/A"]
[]
[null,"Regulatory Balance Sheet",null,"Information on the economic balance sheet for both the insurer's accounting basis and the regulatory basis.",null,"Quarterly & Annual","Yes"]
[]
[null,"Own Funds",null,"Breakdown of capital section from the economic balance sheet, determines eligible own funds to cover the SCR.",null,"Quarterly & Annual","Yes"]
[]
[null,"Operational Risk",null,"Calculation of the operational risk capital requirement.",null,"Quarterly & Annual","Yes"]
[]
[null,"Market Risk",null,"Calculation of the market risk capital requirement.",null,"Quarterly & Annual","Yes"]
[]
[null,"Counterparty Default Risk",null,"Calculation of the counterparty default risk capital requirement.",null,"Quarterly & Annual","Yes"]
[]
[null,"Life Underwriting Risk",null,"Calculation of the life underwriting risk capital requirement. ",null,"Quarterly & Annual","Yes"]
[]
[null,"Health Underwriting Risk",null,"Calculation of the health underwriting risk capital requirement.",null,"Quarterly & Annual","Yes"]
[]
[null,"Ring-Fenced Fund Adjustment",null,"This should be completed where the insurer has one or more ring-fenced funds and/or marked-to-model portfolios. Adjustment to the diversification benefit of the SCR and to tier 1 own-funds.",null,"Quarterly & Annual","Yes"]
[]
[null,"SCR Summary",null,"Calculation of the insurer's solvency capital requirement; summary of capital resources and the related SCR coverage ratio.",null,"Quarterly & Annual","Yes"]
[]
[null,"MCR Summary",null,"Calculation of the insurer's minimum capital requirement; summary of capital resources and the related MCR coverage ratio.",null,"Quarterly & Annual","Yes"]
[]
[null,"Revenue Account Total",null,"The regulatory revenue account for the insurer covering all written insurance business.",null,"Quarterly & Annual","Yes"]
[]
[null,"Revenue Account RFF",null,"This should be completed where the insurer has one or more ring-fenced funds and/or marked-to-model portfolios. The tab should be duplicated for the number of ring-fenced funds held by the insurer, with each tab representing a ring-fenced fund.\n",null,"Quarterly & Annual","Yes"]
[null,"Investment Data",null,"Analysis of the types of assets held by the insurer.",null,"Quarterly & Annual","Yes"]
[]
[null,"Quarterly Industry Statistics",null,"Information for industry statistics.",null,"Quarterly & Annual","No"]
[]
[null,"Change Analysis",null,"A high-level analysis of change in the insurer's basic own funds.",null,"Annual","No"]
[]
[null,"Revenue Account Projected",null,"A 3-year projection of the insurer's revenue account and solvency position. ",null,"Annual","No"]
[]
[null,"Insurance Obligations",null,"Details of the insurer's insurance obligations.",null,"Annual","No"]
[]
[null,"Reinsurance Contracts",null,"Details of the insurer's reinsurance contracts.",null,"Annual","No"]
[]
[null,"Expense Analysis",null,"Details of the expense analysis carried out by the insurer.",null,"Annual","No"]
[]
[null,"Annual Industry Statistics",null,"Information for industry statistics.",null,"Annual","No"]
[]
[null,"Data",null,"Information only.",null,"N/A","N/A"]
[]
[null,"Raw Data",null,"Information only, amalgamation of all LoB results from other templates. Used in the rest of the tabs in this worksheet.",null,"N/A","N/A"]

{"sheet":"Control","index":1,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[[5,2,5,3],[23,2,23,6],[19,2,19,6],[20,2,20,6],[21,2,21,6],[22,2,22,6],[6,2,6,3]]}
[1,null,null,null,"Control"]
[null,null,null,null,null,null,{"$f":"IF(COUNTIF(G7,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[]
[]
[null,null,"Submission Type",null,"Quarterly"]
[null,null,"Enter Abbreviated Firm Name",null,null,null,{"$f":"IF(ISBLANK(E7),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[null,null,"File Name",null,"Folder Location",null,"Applicable?*"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"File path for Form"]
[]
[null,null,{"$f":"IF(G11=\"Yes\",IF(RIGHT(E11,1)=\"\\\",E11&C11&\".xlsx\",E11&\"\\\"&C11&IF(RIGHT(C11,5)<>\".xlsx\",\".xlsx\",\"\")),\"\")","v":""}]
[null,null,{"$f":"IF(G12=\"Yes\",IF(RIGHT(E12,1)=\"\\\",E12&C12&\".xlsx\",E12&\"\\\"&C12&IF(RIGHT(C12,5)<>\".xlsx\",\".xlsx\",\"\")),\"\")","v":""}]
[null,null,""]
[null,null,""]
[null,null,""]
[]
[]
[]
[null,null,"ENSURE ALL LINKS TO BACKING SPREADSHEETS IN THE TEMPLATES LISTED ABOVE ARE BROKEN BEFORE RUNNING 'UPDATE RESULTS' BELOW:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Click to finalise submission before sending to the Authority"]
[null,null,"This will produce a separate return file which checks if all links to external spreadsheets have been broken, all macros have been removed and the file name in a specified format. "]

{"sheet":"Participant Information","index":2,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[29,1,29,4],[22,1,22,4],[24,1,24,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[25,1,25,4],[8,1,8,4],[3,1,3,6],[9,1,9,2],[13,1,13,4],[21,1,21,4],[30,1,30,4],[31,1,31,4],[42,1,42,4],[43,1,43,4],[44,1,44,4],[35,1,35,4],[38,1,38,4],[32,1,32,4],[40,1,40,4],[34,1,34,4],[36,1,36,4],[37,1,37,4],[39,1,39,4],[33,1,33,4]]}
[1,null,"Participant Information"]
[]
[]
[]
[]
[]
[]
[]
[null," Long-Term Business Insurance Return",null,null,null,null,{"$f":"IF(COUNTIF(G11:G45,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Firm Information",null,"Return Version Number","V0.03"]
[null,"Firm Name",null,"Return Reporting Currency",null,null,{"$f":"IF(OR(ISBLANK(C11),ISBLANK(E11)),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Date Return From (dd/mm/yyyy)",null,"Date Return To (dd/mm/yyyy)",null,null,{"$f":"IF(OR(C12=\"\",E12=\"\"),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[null,"Firm Declaration"]
[null,"I/we are authorised by ('the Firm') to make this Return on behalf of the Firm."]
[null,"I/we declare that the information supplied in this return is complete and accurate to the best of our knowledge and belief."]
[null,"Return Signed Off by 1:",null,"Return Signed Off by 2:",null,null,{"$f":"IF(OR(C17=\"\",E17=\"\"),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Position:",null,"Position:",null,null,{"$f":"IF(OR(C18=\"\",E18=\"\"),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Firm Name:",null,"Firm Name:",null,null,{"$f":"IF(OR(C19=\"\",E19=\"\"),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Date (dd/mm/yyyy):",null,"Date (dd/mm/yyyy):",null,null,{"$f":"IF(OR(C20=\"\",E20=\"\"),\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[]
[null,"Comments  (optional)"]
[]
[]
[null,"Validation Table"]
[null,"Is the Control Sheet complete?",null,null,null,null,{"$f":"IF(Control!G2=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Is the Regulatory Balance Sheet complete?",null,null,null,null,{"$f":"IF('Regulatory Balance Sheet'!I3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Own Funds Sheet complete?",null,null,null,null,{"$f":"IF('Own Funds'!M2=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Market Risk Sheet complete?",null,null,null,null,{"$f":"IF('Market Risk'!S3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Counterparty Default Risk Sheet complete?",null,null,null,null,{"$f":"IF('Counterparty Default Risk'!O3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Ring-Fenced Fund Adjustment Sheet complete?",null,null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!AI6=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Market Risk Inputs Sheet complete?",null,null,null,null,{"$f":"IF('Market Risk'!S3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the SCR Summary Sheet complete?",null,null,null,null,{"$f":"IF('SCR Summary'!K2=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the MCR Summary Sheet complete?",null,null,null,null,{"$f":"IF('MCR Summary'!I3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"Is the Revenue Account Total Sheet complete?",null,null,null,null,{"$f":"IF('Revenue Account Total'!Z3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Revenue Account RFF Sheet complete?",null,null,null,null,{"$f":"IF('Revenue Account RFF'!R3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Investment Data Sheet complete?",null,null,null,null,{"$f":"IF('Investment Data'!J3=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Quarterly Industry Statistics Sheet complete?",null,null,null,null,{"$f":"IF('Quarterly Industry Statistics'!H2=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Change Analysis Sheet complete?",null,null,null,null,{"$f":"IF('Change Analysis'!N4=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Revenue Account Projected Sheet complete?",null,null,null,null,{"$f":"IF('Revenue Account Projected'!AA4=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Is the Annual Industry Statistics Sheet complete?",null,null,null,null,{"$f":"IF('Annual Industry Statistics'!O7=\"Incomplete\",\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"An offence may be committed under s52 of the Insurance Act 2008 for failing to supply any information required by the Authority, or for supplying false or misleading information."]
[]
[null,"🔒 Data Protection Notice\nThe Authority is registered with the Information Commissioner as a data controller under Isle of Man data protection legislation. The Authority collects and processes personal data to carry out its functions under relevant legislation and may share personal data with other parties where there is a legal basis for doing so. Information on how the Authority collects and processes personal data can be found in the Privacy Policy on the Authority’s website: https://www.iomfsa.im/terms-conditions/privacy-policy/ \nPlease call +44 (0)1624 646000 if you have any queries."]

{"sheet":"Regulatory Balance Sheet","index":3,"n_rows":164,"n_cols":9,"rows_kept":164,"cut":false,"hidden":false,"merged":[]}
[1,null,null,"Regulatory Balance Sheet"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(I164,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Balance Sheet - Assets",null,"Acc basis        ",null,"Reg basis       "]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Fixed Assets"]
[]
[null,"Goodwill",null,{"$f":"'Raw Data'!$I$11","v":0},null,0]
[null,"Other intangible assets",null,{"$f":"'Raw Data'!$I$12","v":0},null,{"$f":"'Raw Data'!$I$13","v":0}]
[null,"Property, plant & equipment held for own use",null,{"$f":"'Raw Data'!$I$14","v":0},null,{"$f":"'Raw Data'!$I$15","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D9:D11)","v":0},null,{"$f":"SUM(F9:F11)","v":0}]
[]
[null,"Investments *"]
[]
[null,"Property","*",{"$f":"'Raw Data'!$I$16","v":0},null,{"$f":"'Raw Data'!$I$17","v":0}]
[null,"Participations",null,{"$f":"'Raw Data'!$I$18","v":0},null,{"$f":"'Raw Data'!$I$19","v":0}]
[null,"Listed equities/other shares","*",{"$f":"'Raw Data'!$I$20","v":0},null,{"$f":"'Raw Data'!$I$21","v":0}]
[null,"Unlisted equities/other shares","*",{"$f":"'Raw Data'!$I$22","v":0},null,{"$f":"'Raw Data'!$I$23","v":0}]
[null,"Government Bonds","*",{"$f":"'Raw Data'!$I$24","v":0},null,{"$f":"'Raw Data'!$I$25","v":0}]
[null,"Corporate Bonds (asset backed)","*",{"$f":"'Raw Data'!$I$26","v":0},null,{"$f":"'Raw Data'!$I$27","v":0}]
[null,"Corporate Bonds (other)",null,{"$f":"'Raw Data'!$I$28","v":0},null,{"$f":"'Raw Data'!$I$29","v":0}]
[null,"Structured notes",null,{"$f":"'Raw Data'!$I$30","v":0},null,{"$f":"'Raw Data'!$I$31","v":0}]
[null,"Investment funds",null,{"$f":"'Raw Data'!$I$32","v":0},null,{"$f":"'Raw Data'!$I$33","v":0}]
[null,"Derivatives",null,{"$f":"SUM(D27:D31)","v":0},null,{"$f":"SUM(F27:F31)","v":0}]
[null,"Futures",null,{"$f":"'Raw Data'!$I$34","v":0},null,{"$f":"'Raw Data'!$I$35","v":0}]
[null,"Call Options",null,{"$f":"'Raw Data'!$I$36","v":0},null,{"$f":"'Raw Data'!$I$37","v":0}]
[null,"Put Options",null,{"$f":"'Raw Data'!$I$38","v":0},null,{"$f":"'Raw Data'!$I$39","v":0}]
[null,"Swaps",null,{"$f":"'Raw Data'!$I$40","v":0},null,{"$f":"'Raw Data'!$I$41","v":0}]
[null,"Forwards",null,{"$f":"'Raw Data'!$I$42","v":0},null,{"$f":"'Raw Data'!$I$43","v":0}]
[null,"Long term bank deposits",null,{"$f":"'Raw Data'!$I$44","v":0},null,{"$f":"'Raw Data'!$I$45","v":0}]
[null,"Other investments",null,{"$f":"'Raw Data'!$I$46","v":0},null,{"$f":"'Raw Data'!$I$47","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D17:D26,D32:D33)","v":0},null,{"$f":"SUM(F17:F26,F32:F33)","v":0}]
[]
[null,"Assets held for UL funds"]
[]
[null,"Assets held for UL funds",null,{"$f":"'Raw Data'!$I$48","v":0},null,{"$f":"'Raw Data'!$I$49","v":0}]
[null,"Cash deposits to cedants",null,{"$f":"'Raw Data'!$I$50","v":0},null,{"$f":"'Raw Data'!$I$51","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D39:D40)","v":0},null,{"$f":"SUM(F39:F40)","v":0}]
[]
[null,"Mortgages and loans made"]
[]
[null,"Uncollateralised loans made",null,{"$f":"'Raw Data'!$I$52","v":0},null,{"$f":"'Raw Data'!$I$53","v":0}]
[null,"Collateralised loans made","*",{"$f":"'Raw Data'!$I$54","v":0},null,{"$f":"'Raw Data'!$I$55","v":0}]
[null,"Loans on policies",null,{"$f":"'Raw Data'!$I$56","v":0},null,{"$f":"'Raw Data'!$I$57","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D46:D48)","v":0},null,{"$f":"SUM(F46:F48)","v":0}]
[]
[null,"Reinsurance recoverables"]
[]
[null,"Reinsurance share of Technical Provisions",null,{"$f":"SUM(D55:D56)","v":0},null,{"$f":"SUM(F55:F56)","v":0}]
[null,"Life excluding unit-linked",null,{"$f":"'Raw Data'!$I$58","v":0},null,{"$f":"'Raw Data'!$I$59","v":0}]
[null,"Life unit-linked",null,{"$f":"'Raw Data'!$I$60","v":0},null,{"$f":"'Raw Data'!$I$61","v":0}]
[null,"Other reinsurance recoverables",null,{"$f":"'Raw Data'!$I$62","v":0},null,{"$f":"'Raw Data'!$I$63","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D54,D57)","v":0},null,{"$f":"SUM(F54,F57)","v":0}]
[]
[null,"Other Assets"]
[]
[null,"SPV recoverables",null,{"$f":"'Raw Data'!$I$64","v":0},null,{"$f":"'Raw Data'!$I$65","v":0}]
[null,"Intermediaries recoverables",null,{"$f":"'Raw Data'!$I$66","v":0},null,{"$f":"'Raw Data'!$I$67","v":0}]
[null,"Insurance recoverables (Excluding intermediaries)",null,{"$f":"'Raw Data'!$I$68","v":0},null,{"$f":"'Raw Data'!$I$69","v":0}]
[null,"Deferred acquisition costs",null,{"$f":"'Raw Data'!$I$70","v":0},null,0]
[null,"Receivables (trade, not insurance)",null,{"$f":"'Raw Data'!$I$71","v":0},null,{"$f":"'Raw Data'!$I$72","v":0}]
[null,"Pension benefit surplus",null,{"$f":"'Raw Data'!$I$73","v":0},null,{"$f":"'Raw Data'!$I$74","v":0}]
[null,"Cash and cash equivalents",null,{"$f":"'Raw Data'!$I$75","v":0},null,{"$f":"'Raw Data'!$I$76","v":0}]
[null,"Short term bank deposits",null,{"$f":"'Raw Data'!$I$77","v":0},null,{"$f":"'Raw Data'!$I$78","v":0}]
[null,"Amounts due in respect of called but unpaid capital",null,{"$f":"'Raw Data'!$I$79","v":0},null,{"$f":"'Raw Data'!$I$80","v":0}]
[null,"Other assets, not shown elsewhere",null,{"$f":"'Raw Data'!$I$81","v":0},null,{"$f":"'Raw Data'!$I$82","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D63:D72)","v":0},null,{"$f":"SUM(F63:F72)","v":0}]
[]
[null,"Total Assets"]
[]
[null,"TOTAL",null,{"$f":"SUM(D13,D35,D42,D50,D59,D74)","v":0},null,{"$f":"SUM(F13,F35,F42,F50,F59,F74)","v":0}]
[]
[]
[null,"Balance Sheet - Liabilities",null,"Acc basis",null,"Reg basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Technical Provisions - Life and Non-Life excluding UL"]
[]
[null,"Technical provisions calculated as a whole",null,{"$f":"'Raw Data'!$I$83","v":0},null,0]
[null,"Best Estimate Provision - VGB",null,0,null,{"$f":"'Raw Data'!$I$84","v":0}]
[null,"Best Estimate Provision - VDB",null,0,null,{"$f":"'Raw Data'!$I$85","v":0}]
[null,"Risk Margin",null,0,null,{"$f":"'Raw Data'!$I$86","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D86:D89)","v":0},null,{"$f":"SUM(F86:F89)","v":0}]
[]
[null,"Technical Provisions - Life UL funds"]
[]
[null,"Technical provisions calculated as a whole ",null,{"$f":"'Raw Data'!$I$87","v":0},null,0]
[null,"Best Estimate Provision - VGB",null,0,null,{"$f":"'Raw Data'!$I$88","v":0}]
[null,"Best Estimate Provision - VDB",null,0,null,{"$f":"'Raw Data'!$I$89","v":0}]
[null,"Risk Margin",null,0,null,{"$f":"'Raw Data'!$I$90","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D95:D98)","v":0},null,{"$f":"SUM(F95:F98)","v":0}]
[]
[null,"Other Liabilities"]
[]
[null,"Cash deposits from reinsurers",null,{"$f":"'Raw Data'!$I$91","v":0},null,{"$f":"'Raw Data'!$I$92","v":0}]
[null,"Insurance accounts payable",null,{"$f":"'Raw Data'!$I$93","v":0},null,{"$f":"'Raw Data'!$I$94","v":0}]
[null,"Derivatives",null,{"$f":"'Raw Data'!$I$95","v":0},null,{"$f":"'Raw Data'!$I$96","v":0}]
[null,"Provisions other than technical provisions",null,{"$f":"'Raw Data'!$I$97","v":0},null,{"$f":"'Raw Data'!$I$98","v":0}]
[null,"Amounts owed to credit institutions",null,{"$f":"'Raw Data'!$I$99","v":0},null,{"$f":"'Raw Data'!$I$100","v":0}]
[null,"Financial liabs ","*",{"$f":"'Raw Data'!$I$101","v":0},null,{"$f":"'Raw Data'!$I$102","v":0}]
[null,"Payables ","*",{"$f":"'Raw Data'!$I$103","v":0},null,{"$f":"'Raw Data'!$I$104","v":0}]
[null,"Pensions benefit obligations",null,{"$f":"'Raw Data'!$I$105","v":0},null,{"$f":"'Raw Data'!$I$106","v":0}]
[null,"Uncalled investments",null,{"$f":"'Raw Data'!$I$107","v":0},null,{"$f":"'Raw Data'!$I$108","v":0}]
[null,"Contingent liabilities",null,{"$f":"'Raw Data'!$I$109","v":0},null,{"$f":"'Raw Data'!$I$110","v":0}]
[null,"Any other liabilities not shown elsewhere","*",{"$f":"'Raw Data'!$I$111","v":0},null,{"$f":"'Raw Data'!$I$112","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D104:D114)","v":0},null,{"$f":"SUM(F104:F114)","v":0}]
[]
[null,"Total Liabilities"]
[]
[null,"TOTAL",null,{"$f":"SUM(D91,D100,D116)","v":0},null,{"$f":"SUM(F91,F100,F116)","v":0}]
[]
[]
[null,"Net Assets",null,"Acc basis",null,"Reg basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"TOTAL",null,{"$f":"Acc_Total_Assets-Acc_Total_Liabs","v":0},null,{"$f":"Reg_Total_Assets-Reg_Total_Liabs","v":0}]
[]
[]
[null,"Capital *",null,"Acc basis",null,"Reg basis"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Capital and Reserves"]
[]
[null,"Share Capital",null,0,null,{"$f":"'Own Funds'!J12","v":0}]
[null,"Initial fund",null,0,null,{"$f":"'Own Funds'!J20","v":0}]
[null,"Share premium",null,0,null,{"$f":"'Own Funds'!J24","v":0}]
[null,"Retained earnings",null,0,null,{"$f":"'Own Funds'!J28","v":0}]
[null,"Other reserves ","*",0,null,{"$f":"'Own Funds'!J32","v":0}]
[null,"Surplus funds",null,0,null,{"$f":"'Own Funds'!J46","v":0}]
[null,"EPIFP","*",0,null,{"$f":"'Own Funds'!J50","v":0}]
[null,"Preference Shares",null,0,null,{"$f":"'Own Funds'!J58","v":0}]
[null,"Subordinated liabilities",null,0,null,{"$f":"'Own Funds'!J66","v":0}]
[null,"Ancillary own funds","*",0,null,{"$f":"AOF_Total","v":0}]
[null,"Other items not specified above",null,0,null,{"$f":"'Own Funds'!J74","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D134:D144)","v":0},null,{"$f":"SUM(F134:F144)","v":0}]
[]
[null,"Reconciliation reserve"]
[]
[null,"Adjustment to assets",null,0,null,{"$f":"'Own Funds'!J36","v":0}]
[null,"Adjustment to TPs",null,0,null,{"$f":"'Own Funds'!J37","v":0}]
[null,"less EPIFP",null,0,null,{"$f":"'Own Funds'!J38","v":0}]
[null,"Adjustments to other liabilities",null,0,null,{"$f":"'Own Funds'!J39","v":0}]
[null,"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 own funds",null,0,null,{"$f":"'Own Funds'!J40","v":0}]
[]
[null,"Total",null,{"$f":"SUM(D150:D154)","v":0},null,{"$f":"SUM(F150:F154)","v":0}]
[]
[null,"Total Capital and Reserves"]
[]
[null,"TOTAL",null,{"$f":"D146","v":0},null,{"$f":"SUM(F156,F146)","v":0}]
[]
[]
[]
[null,"Check balance sheet is balanced",null,{"$f":"IF(AND(ABS(Acc_NAV-Acc_Cap)<0.001),\"OK\",\"ERROR\")","v":"OK"},null,{"$f":"IF(ABS(Reg_NAV-Reg_Cap+F154)<0.001,\"OK\",\"ERROR\")","v":"OK"},null,null,{"$f":"IF(OR(D164=\"Error\",F164=\"Error\"),\"Incomplete\",\"Complete\")","v":"Complete"}]

{"sheet":"Own Funds","index":4,"n_rows":143,"n_cols":13,"rows_kept":143,"cut":false,"hidden":false,"merged":[]}
[1,null,null,"Own Funds"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(M9:M144,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Basic Own Funds *",null,"Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Ordinary Share Capital *"]
[]
[null,"Paid up",null,0,null,0,null,0,null,{"$f":"SUM(D9,F9,H9)","v":0},null,null,{"$f":"IF(OR(D9=\"\",F9=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Called up",null,0,null,0,null,0,null,{"$f":"SUM(D10,F10,H10)","v":0},null,null,{"$f":"IF(OR(F10=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total",null,{"$f":"SUM(D9:D10)","v":0},null,{"$f":"SUM(F9:F10)","v":0},null,{"$f":"SUM(H9:H10)","v":0},null,{"$f":"SUM(J9:J10)","v":0}]
[]
[null,"Initial Fund *"]
[]
[null,"Paid up",null,0,null,0,null,0,null,{"$f":"SUM(D16,F16,H16)","v":0},null,null,{"$f":"IF(OR(D16=\"\",F16=\"\",H16),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Called up",null,0,null,0,null,0,null,{"$f":"SUM(D17,F17,H17)","v":0},null,null,{"$f":"IF(OR(H17=\"\",F17=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Callable",null,0,null,0,null,0,null,{"$f":"SUM(D18,F18,H18)","v":0},null,null,{"$f":"IF(OR(H18=\"\",F18=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total",null,{"$f":"SUM(D16:D18)","v":0},null,{"$f":"SUM(F16:F18)","v":0},null,{"$f":"SUM(H16:H18)","v":0},null,{"$f":"SUM(J16:J18)","v":0}]
[]
[null,"Share Premium Account"]
[]
[null,"Share Premium Account",null,0,null,0,null,0,null,{"$f":"SUM(D24,F24,H24)","v":0},null,null,{"$f":"IF(OR(D24=\"\",F24=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Retained earnings  *"]
[]
[null,"Retained earnings",null,0,null,0,null,0,null,{"$f":"SUM(D28,F28,H28)","v":0},null,null,{"$f":"IF(OR(D28=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Other reserves *"]
[]
[null,"Other reserves",null,0,null,0,null,0,null,{"$f":"SUM(D32,F32,H32)","v":0},null,null,{"$f":"IF(OR(D32=\"\",F32=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Reconciliation reserve"]
[]
[null,"Adjustment to assets",null,{"$f":"Reg_Total_Assets-Acc_Total_Assets","v":0},null,0,null,0,null,{"$f":"SUM(D36,F36,H36)","v":0}]
[null,"Adjustments to technical provisions",null,{"$f":"SUM('Regulatory Balance Sheet'!D91,'Regulatory Balance Sheet'!D100)-SUM('Regulatory Balance Sheet'!F91,'Regulatory Balance Sheet'!F100)","v":0},null,0,null,0,null,{"$f":"SUM(D37,F37,H37)","v":0}]
[null,"less EPIFP",null,{"$f":"-D50","v":0},null,0,null,0,null,0]
[null,"Adjustments to other liabilities",null,{"$f":"'Regulatory Balance Sheet'!D116-'Regulatory Balance Sheet'!F116","v":0},null,0,null,0,null,{"$f":"SUM(D39,F39,H39)","v":0}]
[null,"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 Tier 1 own funds *",null,0,null,0,null,0,null,{"$f":"SUM(D40,F40,H40)","v":0},null,null,{"$f":"IF(OR(D40=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total",null,{"$f":"SUM(D36:D40)","v":0},null,{"$f":"SUM(F36:F40)","v":0},null,{"$f":"SUM(H36:H40)","v":0},null,{"$f":"SUM(J36:J40)","v":0}]
[]
[null,"Surplus funds"]
[]
[null,"Surplus funds",null,0,null,0,null,0,null,{"$f":"SUM(D46,F46,H46)","v":0},null,null,{"$f":"IF(OR(D46=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"EPIFP"]
[]
[null,"EPIFP",null,0,null,0,null,0,null,{"$f":"SUM(D50,F50,H50)","v":0},null,null,{"$f":"IF(OR(D50=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Preference shares"]
[]
[null,"Dated",null,0,null,0,null,0,null,{"$f":"SUM(D54,F54,H54)","v":0},null,null,{"$f":"IF(OR(D54=\"\",F54=\"\",H54),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Undated with a call option",null,0,null,0,null,0,null,{"$f":"SUM(D55,F55,H55)","v":0},null,null,"Complete"]
[null,"Undated no call option",null,0,null,0,null,0,null,0,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D54:D56)","v":0},null,{"$f":"SUM(F54:F56)","v":0},null,{"$f":"SUM(H54:H56)","v":0},null,{"$f":"SUM(J54:J56)","v":0}]
[]
[null,"Subordinated liabilities"]
[]
[null,"Dated",null,0,null,0,null,0,null,{"$f":"SUM(D62,F62,H62)","v":0},null,null,{"$f":"IF(OR(D62=\"\",F62=\"\",H62),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Undated with a call option",null,0,null,0,null,0,null,{"$f":"SUM(D63,F63,H63)","v":0},null,null,"Complete"]
[null,"Undated no call option",null,0,null,0,null,0,null,0,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D62:D64)","v":0},null,{"$f":"SUM(F62:F64)","v":0},null,{"$f":"SUM(H62:H64)","v":0},null,{"$f":"SUM(J62:J64)","v":0}]
[]
[null,"Subordinated mutual member accounts"]
[]
[null,"Subordinated mutual member accounts",null,0,null,0,null,0,null,{"$f":"SUM(D70,F70,H70)","v":0},null,null,{"$f":"IF(OR(D70=\"\",F70=\"\",H70),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Other items not specified elsewhere"]
[]
[null,"Other items",null,0,null,0,null,0,null,{"$f":"SUM(D74,F74,H74)","v":0}]
[]
[null,"Total Basic Own Funds"]
[]
[null,"TOTAL",null,{"$f":"SUM(D12,D20,D24,D28,D32,D42,D46,D50,D58,D66,D70,D74)","v":0},null,{"$f":"SUM(F12,F20,F24,F28,F32,F42,F46,F50,F58,F66,F70,F74)","v":0},null,{"$f":"SUM(H12,H20,H24,H28,H32,H42,H46,H50,H58,H66,H70,H74)","v":0},null,{"$f":"SUM(D78,F78,H78)","v":0}]
[]
[]
[null,"Adjustments to BOF",null,"Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Deductions"]
[]
[null,"Restricted reserves",null,0,null,0,null,0,null,{"$f":"SUM(D86,F86,H86)","v":0},null,null,{"$f":"IF(OR(D86=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Own-funds that belong to immaterial ring-fenced funds",null,0,null,0,null,0,null,{"$f":"SUM(D87,F87,H87)","v":0},null,null,"Complete"]
[]
[null,"Total inc. material RFF adj from RFF adjustment tab",null,{"$f":"SUM(D86:D87)+('Ring-Fenced Fund Adjustment'!AD36-'Ring-Fenced Fund Adjustment'!AF36)","v":0},null,{"$f":"SUM(F86:F87)","v":0},null,{"$f":"SUM(H86:H87)","v":0},null,{"$f":"SUM(J86:J87)","v":0}]
[]
[null,"Change of tier"]
[]
[null,"Restricted reserves",null,0,null,{"$f":"-D93","v":0},null,0,null,{"$f":"SUM(D93,F93,H93)","v":0},null,null,{"$f":"IF(OR(D93=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Other adjustments",null,0,null,0,null,0,null,{"$f":"SUM(D94,F94,H94)","v":0},null,null,{"$f":"IF(OR(D94=\"\",F94=\"\",H94),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total",null,{"$f":"SUM(D93:D94)","v":0},null,{"$f":"SUM(F93:F94)","v":0},null,{"$f":"SUM(H93:H94)","v":0},null,{"$f":"SUM(J93:J94)","v":0}]
[]
[null,"Total Adjustments"]
[]
[null,"TOTAL",null,{"$f":"D96-D89","v":0},null,{"$f":"F96-F89","v":0},null,{"$f":"H96-H89","v":0},null,{"$f":"SUM(D100,F100,H100)","v":0}]
[]
[]
[null,"Total Available Own Funds to meet SCR"]
[]
[null,"Eligible Own Funds",null,{"$f":"SUM(BOF_Tier_1,BOF_Adj_Tier_1)","v":0},null,{"$f":"SUM(BOF_Tier_2,BOF_Adj_Tier_2,AOF_Tier_2)","v":0},null,{"$f":"SUM(BOF_Tier_3,BOF_Adj_Tier_3,AOF_Tier_3)","v":0},null,{"$f":"SUM(BOF_Total,BOF_Adj_Total,AOF_Total)","v":0}]
[]
[]
[null,"Total Available Own Funds to meet MCR"]
[]
[null,"Eligible Own Funds",null,{"$f":"EOF_Tier_1","v":0},null,{"$f":"EOF_Tier_2","v":0},null,0,null,{"$f":"D110+F110+H110","v":0}]
[]
[]
[null,"Total Eligible Own Funds to meet SCR"]
[]
[null,"Eligible Own Funds",null,{"$f":"(D12+D20+D24+D28+D32+D42+D46+D50)+MAX(0,(MIN((D12+D20+D24+D28+D32+D42+D46+D50)*0.25,SUM(D58,D66,D70,D74))))","v":0},null,{"$f":"MAX(0,MIN(0.5*SCR,(EOF_Tier_1-D115)+EOF_Tier_2))","v":0},null,{"$f":"MAX(0,MIN(0.5*SCR-F115,0.15*SCR,EOF_Tier_3))","v":0},null,{"$f":"SUM(D115,F115,H115)","v":0}]
[]
[]
[null,"Total Eligible Own Funds to meet MCR"]
[]
[null,"Eligible Own Funds",null,{"$f":"D115","v":0},null,{"$f":"MAX(0,MIN(0.2*MCR_SII,(EOF_Tier_1-D115)+EOF_Tier_2))","v":0},null,0,null,{"$f":"D120+F120+H120","v":0}]
[]
[]
[null,"Ancillary own funds *",null,"Tier 1",null,"Tier 2",null,"Tier 3",null,"Total"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Unpaid share capital or initial fund not paid up"]
[]
[null,"Total",null,0,null,0,null,0,null,{"$f":"SUM(D128,F128,H128)","v":0},null,null,{"$f":"IF(OR(H128=\"\",F128=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Letters of credit and guarantees "]
[]
[null,"Letter of credit",null,0,null,0,null,0,null,{"$f":"SUM(D132,F132,H132)","v":0},null,null,{"$f":"IF(OR(H132=\"\",F132=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Guarantees held in trust",null,0,null,0,null,0,null,{"$f":"SUM(D133,F133,H133)","v":0},null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D132:D133)","v":0},null,{"$f":"SUM(F132:F133)","v":0},null,{"$f":"SUM(H132:H133)","v":0},null,{"$f":"SUM(J132:J133)","v":0}]
[]
[null,"Other items *"]
[]
[null,"Other items",null,0,null,0,null,0,null,{"$f":"SUM(D139,F139,H139)","v":0},null,null,{"$f":"IF(OR(H139=\"\",F139=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total  Ancillary Own Funds"]
[]
[null,"TOTAL",null,{"$f":"SUM(D128,D135,D139,)","v":0},null,{"$f":"SUM(F128,F135,F139,)","v":0},null,{"$f":"SUM(H128,H135,H139,)","v":0},null,{"$f":"SUM(J128,J135,J139,)","v":0}]

{"sheet":"Operational Risk","index":5,"n_rows":11,"n_cols":15,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,null,"Operational Risk"]
[]
[]
[null,"Operational Risk",null,null,"Current Valuation Date",null,"Previous Valuation Date",null,null,"EXPUL",null,null,"OpPremiums",null,"OpProvisions"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,null,{"$f":"\"'000\"","v":"'000"},null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,null,"Total expenses allocated to Unit Linked business",null,{"$f":"'Raw Data'!I6","v":0},null,null,null,null,{"$f":"E7","v":0}]
[]
[null,null,"Earned Premiums ",null,{"$f":"'Raw Data'!I7","v":0},null,{"$f":"'Raw Data'!I8","v":0},null,null,null,null,null,{"$f":"(0.04*E9)+MAX(0,0.04*(E9-1.2*G9))","v":0}]
[]
[null,null,"Technical Provisions ",null,{"$f":"'Raw Data'!I9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"0.0045*MAX(E11,0)","v":0}]

{"sheet":"Market Risk","index":6,"n_rows":159,"n_cols":19,"rows_kept":159,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"Market Risk"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(S23,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Market Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketinterest",null,null,null,{"$f":"Mkt_Int","v":0},null,{"$f":"nMkt_Int","v":0}]
[null,"Marketequity",null,null,null,{"$f":"Mkt_Eq","v":0},null,{"$f":"nMkt_Eq","v":0}]
[null,"Marketproperty",null,null,null,{"$f":"Mkt_Prop","v":0},null,{"$f":"nMkt_Prop","v":0}]
[null,"Marketfx",null,null,null,{"$f":"IF(Curr_Simp=\"N\",Mkt_Curr,IF(Curr_Simp=\"Y\",Mkt_Curr_Simp,0))","v":0},null,{"$f":"IF(Curr_Simp=\"N\",nMkt_Curr,IF(Curr_Simp=\"Y\",nMkt_Curr_Simp,0))","v":0}]
[null,"Marketspread",null,null,null,{"$f":"Mkt_Sp","v":0},null,{"$f":"nMkt_Sp","v":0}]
[null,"Marketconc",null,null,null,{"$f":"Mkt_Conc","v":0},null,{"$f":"nMkt_Conc","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F7:F12)","v":0},null,{"$f":"SUM(H7:H12)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F18-F14","v":0},null,{"$f":"H18-H14","v":0}]
[]
[null,"SCRmarket",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F12),MarketCorr),F7:F12))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H12),MarketCorr),H7:H12))","v":0}]
[]
[]
[null,"Simplification to be used?"]
[]
[null,"Currency *",null,"N",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Curr_Simp=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"Reg_Total_Assets","v":0},null,{"$f":"SUM('Regulatory Balance Sheet'!$F$87,'Regulatory Balance Sheet'!$F$96)","v":0},null,{"$f":"SUM('Regulatory Balance Sheet'!$F$88,'Regulatory Balance Sheet'!$F$97)","v":0},null,{"$f":"$D29-$F29-$H29","v":0},null,{"$f":"$D29-$F29-$H29","v":0}]
[]
[]
[null,"Interest Rate Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"MarketinterestUp",null,{"$f":"'Raw Data'!$I$114","v":0},null,{"$f":"'Raw Data'!$I$115","v":0},null,{"$f":"'Raw Data'!$I$116","v":0},null,{"$f":"$D35-$F35-BE_Liabs_VDB","v":0},null,{"$f":"$D35-$F35-$H35","v":0},null,{"$f":"-($J35-$J$29)","v":0},null,{"$f":"-($L35-$L$29)","v":0}]
[null,"MarketinterestDown",null,{"$f":"'Raw Data'!$I$117","v":0},null,{"$f":"'Raw Data'!$I$118","v":0},null,{"$f":"'Raw Data'!$I$119","v":0},null,{"$f":"$D36-$F36-BE_Liabs_VDB","v":0},null,{"$f":"$D36-$F36-$H36","v":0},null,{"$f":"-($J36-$J$29)","v":0},null,{"$f":"-($L36-$L$29)","v":0}]
[]
[null,"Marketinterest",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_Int_Up>nMkt_Int_Down,Mkt_Int_Up,Mkt_Int_Down))","v":0},null,{"$f":"MAX(0,nMkt_Int_Up,nMkt_Int_Down)","v":0}]
[]
[]
[null,"Equity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketequity,1VolUp",null,{"$f":"'Raw Data'!$I$120","v":0},null,{"$f":"'Raw Data'!$I$121","v":0},null,{"$f":"'Raw Data'!$I$122","v":0},null,{"$f":"$D44-$F44-BE_Liabs_VDB","v":0},null,{"$f":"$D44-$F44-$H44","v":0},null,{"$f":"MAX(0,-($J44-$J$29))","v":0},null,{"$f":"MAX(0,-($L44-$L$29))","v":0}]
[null,"Marketequity,1Level",null,{"$f":"'Raw Data'!$I$123","v":0},null,{"$f":"'Raw Data'!$I$124","v":0},null,{"$f":"'Raw Data'!$I$125","v":0},null,{"$f":"$D45-$F45-BE_Liabs_VDB","v":0},null,{"$f":"$D45-$F45-$H45","v":0},null,{"$f":"MAX(0,-($J45-$J$29))","v":0},null,{"$f":"MAX(0,-($L45-$L$29))","v":0}]
[null,"Marketequity,1VolDown",null,{"$f":"'Raw Data'!$I$126","v":0},null,{"$f":"'Raw Data'!$I$127","v":0},null,{"$f":"'Raw Data'!$I$128","v":0},null,{"$f":"$D46-$F46-BE_Liabs_VDB","v":0},null,{"$f":"$D46-$F46-$H46","v":0},null,{"$f":"MAX(0,-($J46-$J$29))","v":0},null,{"$f":"MAX(0,-($L46-$L$29))","v":0}]
[]
[null,"Marketequity,2VolUp",null,{"$f":"'Raw Data'!$I$129","v":0},null,{"$f":"'Raw Data'!$I$130","v":0},null,{"$f":"'Raw Data'!$I$131","v":0},null,{"$f":"$D48-$F48-BE_Liabs_VDB","v":0},null,{"$f":"$D48-$F48-$H48","v":0},null,{"$f":"MAX(0,-($J48-$J$29))","v":0},null,{"$f":"MAX(0,-($L48-$L$29))","v":0}]
[null,"Marketequity,2Level",null,{"$f":"'Raw Data'!$I$132","v":0},null,{"$f":"'Raw Data'!$I$133","v":0},null,{"$f":"'Raw Data'!$I$134","v":0},null,{"$f":"$D49-$F49-BE_Liabs_VDB","v":0},null,{"$f":"$D49-$F49-$H49","v":0},null,{"$f":"MAX(0,-($J49-$J$29))","v":0},null,{"$f":"MAX(0,-($L49-$L$29))","v":0}]
[null,"Marketequity,2VolDown",null,{"$f":"'Raw Data'!$I$135","v":0},null,{"$f":"'Raw Data'!$I$136","v":0},null,{"$f":"'Raw Data'!$I$137","v":0},null,{"$f":"$D50-$F50-BE_Liabs_VDB","v":0},null,{"$f":"$D50-$F50-$H50","v":0},null,{"$f":"MAX(0,-($J50-$J$29))","v":0},null,{"$f":"MAX(0,-($L50-$L$29))","v":0}]
[]
[null,"Marketequity,1Level & VolUp",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N44:N45),EqVolUpCorr),N44:N45))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P44:P45),EqVolUpCorr),P44:P45))","v":0}]
[null,"Marketequity,1Level & VolDown",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N45:N46),EqVolDownCorr),N45:N46))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P45:P46),EqVolDownCorr),P45:P46))","v":0}]
[]
[null,"Marketequity,2Level & VolUp",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N48:N49),EqVolUpCorr),N48:N49))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P48:P49),EqVolUpCorr),P48:P49))","v":0}]
[null,"Marketequity,2Level & VolDown",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N49:N50),EqVolDownCorr),N49:N50))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P49:P50),EqVolDownCorr),P49:P50))","v":0}]
[]
[null,"Marketequity,1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nEq_1_vol_Up>nEq_1_vol_Down,Eq_1_vol_Up,Eq_1_vol_Down)","v":0},null,{"$f":"MAX(nEq_1_vol_Up,nEq_1_vol_Down)","v":0}]
[null,"Marketequity,2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nEq_2_vol_Up>nEq_2_vol_Down,Eq_2_vol_Up,Eq_2_vol_Down)","v":0},null,{"$f":"MAX(nEq_2_vol_Up,nEq_2_vol_Down)","v":0}]
[]
[null,"Marketequity",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N58:N59),EqCorr),N58:N59))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P58:P59),EqCorr),P58:P59))","v":0}]
[]
[]
[null,"Property Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketproperty",null,{"$f":"'Raw Data'!$I$138","v":0},null,{"$f":"'Raw Data'!$I$139","v":0},null,{"$f":"'Raw Data'!$I$140","v":0},null,{"$f":"$D67-$F67-BE_Liabs_VDB","v":0},null,{"$f":"$D67-$F67-$H67","v":0},null,{"$f":"MAX(0,-($J67-$J$29))","v":0},null,{"$f":"MAX(0,-($L67-$L$29))","v":0}]
[]
[]
[null,"Currency Risk                        ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketfx,CurrGroup1Up",null,{"$f":"'Raw Data'!$I$141","v":0},null,{"$f":"'Raw Data'!$I$142","v":0},null,{"$f":"'Raw Data'!$I$143","v":0},null,{"$f":"$D73-$F73-BE_Liabs_VDB","v":0},null,{"$f":"$D73-$F73-$H73","v":0},null,{"$f":"-($J73-$J$29)","v":0},null,{"$f":"-($L73-$L$29)","v":0}]
[null,"Marketfx,CurrGroup1Down",null,{"$f":"'Raw Data'!$I$144","v":0},null,{"$f":"'Raw Data'!$I$145","v":0},null,{"$f":"'Raw Data'!$I$146","v":0},null,{"$f":"$D74-$F74-BE_Liabs_VDB","v":0},null,{"$f":"$D74-$F74-$H74","v":0},null,{"$f":"-($J74-$J$29)","v":0},null,{"$f":"-($L74-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup2Up",null,{"$f":"'Raw Data'!$I$147","v":0},null,{"$f":"'Raw Data'!$I$148","v":0},null,{"$f":"'Raw Data'!$I$149","v":0},null,{"$f":"$D76-$F76-BE_Liabs_VDB","v":0},null,{"$f":"$D76-$F76-$H76","v":0},null,{"$f":"-($J76-$J$29)","v":0},null,{"$f":"-($L76-$L$29)","v":0}]
[null,"Marketfx,CurrGroup2Down",null,{"$f":"'Raw Data'!$I$150","v":0},null,{"$f":"'Raw Data'!$I$151","v":0},null,{"$f":"'Raw Data'!$I$152","v":0},null,{"$f":"$D77-$F77-BE_Liabs_VDB","v":0},null,{"$f":"$D77-$F77-$H77","v":0},null,{"$f":"-($J77-$J$29)","v":0},null,{"$f":"-($L77-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup3Up",null,{"$f":"'Raw Data'!$I$153","v":0},null,{"$f":"'Raw Data'!$I$154","v":0},null,{"$f":"'Raw Data'!$I$155","v":0},null,{"$f":"$D79-$F79-BE_Liabs_VDB","v":0},null,{"$f":"$D79-$F79-$H79","v":0},null,{"$f":"-($J79-$J$29)","v":0},null,{"$f":"-($L79-$L$29)","v":0}]
[null,"Marketfx,CurrGroup3Down",null,{"$f":"'Raw Data'!$I$156","v":0},null,{"$f":"'Raw Data'!$I$157","v":0},null,{"$f":"'Raw Data'!$I$158","v":0},null,{"$f":"$D80-$F80-BE_Liabs_VDB","v":0},null,{"$f":"$D80-$F80-$H80","v":0},null,{"$f":"-($J80-$J$29)","v":0},null,{"$f":"-($L80-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup4Up",null,{"$f":"'Raw Data'!$I$159","v":0},null,{"$f":"'Raw Data'!$I$160","v":0},null,{"$f":"'Raw Data'!$I$161","v":0},null,{"$f":"$D82-$F82-BE_Liabs_VDB","v":0},null,{"$f":"$D82-$F82-$H82","v":0},null,{"$f":"-($J82-$J$29)","v":0},null,{"$f":"-($L82-$L$29)","v":0}]
[null,"Marketfx,CurrGroup4Down",null,{"$f":"'Raw Data'!$I$162","v":0},null,{"$f":"'Raw Data'!$I$163","v":0},null,{"$f":"'Raw Data'!$I$164","v":0},null,{"$f":"$D83-$F83-BE_Liabs_VDB","v":0},null,{"$f":"$D83-$F83-$H83","v":0},null,{"$f":"-($J83-$J$29)","v":0},null,{"$f":"-($L83-$L$29)","v":0}]
[null,null,null,null,null,null,null,null,null,"."]
[null,"Marketfx,CurrGroup5Up",null,{"$f":"'Raw Data'!$I$165","v":0},null,{"$f":"'Raw Data'!$I$166","v":0},null,{"$f":"'Raw Data'!$I$167","v":0},null,{"$f":"$D85-$F85-BE_Liabs_VDB","v":0},null,{"$f":"$D85-$F85-$H85","v":0},null,{"$f":"-($J85-$J$29)","v":0},null,{"$f":"-($L85-$L$29)","v":0}]
[null,"Marketfx,CurrGroup5Down",null,{"$f":"'Raw Data'!$I$168","v":0},null,{"$f":"'Raw Data'!$I$169","v":0},null,{"$f":"'Raw Data'!$I$170","v":0},null,{"$f":"$D86-$F86-BE_Liabs_VDB","v":0},null,{"$f":"$D86-$F86-$H86","v":0},null,{"$f":"-($J86-$J$29)","v":0},null,{"$f":"-($L86-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup6Up",null,{"$f":"'Raw Data'!$I$171","v":0},null,{"$f":"'Raw Data'!$I$172","v":0},null,{"$f":"'Raw Data'!$I$173","v":0},null,{"$f":"$D88-$F88-BE_Liabs_VDB","v":0},null,{"$f":"$D88-$F88-$H88","v":0},null,{"$f":"-($J88-$J$29)","v":0},null,{"$f":"-($L88-$L$29)","v":0}]
[null,"Marketfx,CurrGroup6Down",null,{"$f":"'Raw Data'!$I$174","v":0},null,{"$f":"'Raw Data'!$I$175","v":0},null,{"$f":"'Raw Data'!$I$176","v":0},null,{"$f":"$D89-$F89-BE_Liabs_VDB","v":0},null,{"$f":"$D89-$F89-$H89","v":0},null,{"$f":"-($J89-$J$29)","v":0},null,{"$f":"-($L89-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup7Up",null,{"$f":"'Raw Data'!$I$177","v":0},null,{"$f":"'Raw Data'!$I$178","v":0},null,{"$f":"'Raw Data'!$I$179","v":0},null,{"$f":"$D91-$F91-BE_Liabs_VDB","v":0},null,{"$f":"$D91-$F91-$H91","v":0},null,{"$f":"-($J91-$J$29)","v":0},null,{"$f":"-($L91-$L$29)","v":0}]
[null,"Marketfx,CurrGroup7Down",null,{"$f":"'Raw Data'!$I$180","v":0},null,{"$f":"'Raw Data'!$I$181","v":0},null,{"$f":"'Raw Data'!$I$182","v":0},null,{"$f":"$D92-$F92-BE_Liabs_VDB","v":0},null,{"$f":"$D92-$F92-$H92","v":0},null,{"$f":"-($J92-$J$29)","v":0},null,{"$f":"-($L92-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup8Up",null,{"$f":"'Raw Data'!$I$183","v":0},null,{"$f":"'Raw Data'!$I$184","v":0},null,{"$f":"'Raw Data'!$I$185","v":0},null,{"$f":"$D94-$F94-BE_Liabs_VDB","v":0},null,{"$f":"$D94-$F94-$H94","v":0},null,{"$f":"-($J94-$J$29)","v":0},null,{"$f":"-($L94-$L$29)","v":0}]
[null,"Marketfx,CurrGroup8Down",null,{"$f":"'Raw Data'!$I$186","v":0},null,{"$f":"'Raw Data'!$I$187","v":0},null,{"$f":"'Raw Data'!$I$188","v":0},null,{"$f":"$D95-$F95-BE_Liabs_VDB","v":0},null,{"$f":"$D95-$F95-$H95","v":0},null,{"$f":"-($J95-$J$29)","v":0},null,{"$f":"-($L95-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup9Up",null,{"$f":"'Raw Data'!$I$189","v":0},null,{"$f":"'Raw Data'!$I$190","v":0},null,{"$f":"'Raw Data'!$I$191","v":0},null,{"$f":"$D97-$F97-BE_Liabs_VDB","v":0},null,{"$f":"$D97-$F97-$H97","v":0},null,{"$f":"-($J97-$J$29)","v":0},null,{"$f":"-($L97-$L$29)","v":0}]
[null,"Marketfx,CurrGroup9Down",null,{"$f":"'Raw Data'!$I$192","v":0},null,{"$f":"'Raw Data'!$I$193","v":0},null,{"$f":"'Raw Data'!$I$194","v":0},null,{"$f":"$D98-$F98-BE_Liabs_VDB","v":0},null,{"$f":"$D98-$F98-$H98","v":0},null,{"$f":"-($J98-$J$29)","v":0},null,{"$f":"-($L98-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup10Up",null,{"$f":"'Raw Data'!$I$195","v":0},null,{"$f":"'Raw Data'!$I$196","v":0},null,{"$f":"'Raw Data'!$I$197","v":0},null,{"$f":"$D100-$F100-BE_Liabs_VDB","v":0},null,{"$f":"$D100-$F100-$H100","v":0},null,{"$f":"-($J100-$J$29)","v":0},null,{"$f":"-($L100-$L$29)","v":0}]
[null,"Marketfx,CurrGroup10Down",null,{"$f":"'Raw Data'!$I$198","v":0},null,{"$f":"'Raw Data'!$I$199","v":0},null,{"$f":"'Raw Data'!$I$200","v":0},null,{"$f":"$D101-$F101-BE_Liabs_VDB","v":0},null,{"$f":"$D101-$F101-$H101","v":0},null,{"$f":"-($J101-$J$29)","v":0},null,{"$f":"-($L101-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup11Up",null,{"$f":"'Raw Data'!$I$201","v":0},null,{"$f":"'Raw Data'!$I$202","v":0},null,{"$f":"'Raw Data'!$I$203","v":0},null,{"$f":"$D103-$F103-BE_Liabs_VDB","v":0},null,{"$f":"$D103-$F103-$H103","v":0},null,{"$f":"-($J103-$J$29)","v":0},null,{"$f":"-($L103-$L$29)","v":0}]
[null,"Marketfx,CurrGroup11Down",null,{"$f":"'Raw Data'!$I$204","v":0},null,{"$f":"'Raw Data'!$I$205","v":0},null,{"$f":"'Raw Data'!$I$206","v":0},null,{"$f":"$D104-$F104-BE_Liabs_VDB","v":0},null,{"$f":"$D104-$F104-$H104","v":0},null,{"$f":"-($J104-$J$29)","v":0},null,{"$f":"-($L104-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup12Up",null,{"$f":"'Raw Data'!$I$207","v":0},null,{"$f":"'Raw Data'!$I$208","v":0},null,{"$f":"'Raw Data'!$I$209","v":0},null,{"$f":"$D106-$F106-BE_Liabs_VDB","v":0},null,{"$f":"$D106-$F106-$H106","v":0},null,{"$f":"-($J106-$J$29)","v":0},null,{"$f":"-($L106-$L$29)","v":0}]
[null,"Marketfx,CurrGroup12Down",null,{"$f":"'Raw Data'!$I$210","v":0},null,{"$f":"'Raw Data'!$I$211","v":0},null,{"$f":"'Raw Data'!$I$212","v":0},null,{"$f":"$D107-$F107-BE_Liabs_VDB","v":0},null,{"$f":"$D107-$F107-$H107","v":0},null,{"$f":"-($J107-$J$29)","v":0},null,{"$f":"-($L107-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup13Up",null,{"$f":"'Raw Data'!$I$213","v":0},null,{"$f":"'Raw Data'!$I$214","v":0},null,{"$f":"'Raw Data'!$I$215","v":0},null,{"$f":"$D109-$F109-BE_Liabs_VDB","v":0},null,{"$f":"$D109-$F109-$H109","v":0},null,{"$f":"-($J109-$J$29)","v":0},null,{"$f":"-($L109-$L$29)","v":0}]
[null,"Marketfx,CurrGroup13Down",null,{"$f":"'Raw Data'!$I$216","v":0},null,{"$f":"'Raw Data'!$I$217","v":0},null,{"$f":"'Raw Data'!$I$218","v":0},null,{"$f":"$D110-$F110-BE_Liabs_VDB","v":0},null,{"$f":"$D110-$F110-$H110","v":0},null,{"$f":"-($J110-$J$29)","v":0},null,{"$f":"-($L110-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup14Up",null,{"$f":"'Raw Data'!$I$219","v":0},null,{"$f":"'Raw Data'!$I$220","v":0},null,{"$f":"'Raw Data'!$I$221","v":0},null,{"$f":"$D112-$F112-BE_Liabs_VDB","v":0},null,{"$f":"$D112-$F112-$H112","v":0},null,{"$f":"-($J112-$J$29)","v":0},null,{"$f":"-($L112-$L$29)","v":0}]
[null,"Marketfx,CurrGroup14Down",null,{"$f":"'Raw Data'!$I$222","v":0},null,{"$f":"'Raw Data'!$I$223","v":0},null,{"$f":"'Raw Data'!$I$224","v":0},null,{"$f":"$D113-$F113-BE_Liabs_VDB","v":0},null,{"$f":"$D113-$F113-$H113","v":0},null,{"$f":"-($J113-$J$29)","v":0},null,{"$f":"-($L113-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup15Up",null,{"$f":"'Raw Data'!$I$225","v":0},null,{"$f":"'Raw Data'!$I$226","v":0},null,{"$f":"'Raw Data'!$I$227","v":0},null,{"$f":"$D115-$F115-BE_Liabs_VDB","v":0},null,{"$f":"$D115-$F115-$H115","v":0},null,{"$f":"-($J115-$J$29)","v":0},null,{"$f":"-($L115-$L$29)","v":0}]
[null,"Marketfx,CurrGroup15Down",null,{"$f":"'Raw Data'!$I$228","v":0},null,{"$f":"'Raw Data'!$I$229","v":0},null,{"$f":"'Raw Data'!$I$230","v":0},null,{"$f":"$D116-$F116-BE_Liabs_VDB","v":0},null,{"$f":"$D116-$F116-$H116","v":0},null,{"$f":"-($J116-$J$29)","v":0},null,{"$f":"-($L116-$L$29)","v":0}]
[]
[null,"Marketfx,CurrGroup1",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_1_Up>nMkt_fx_1_Down,Mkt_fx_1_Up,Mkt_fx_1_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_1_Up,nMkt_fx_1_Down)","v":0}]
[null,"Marketfx,CurrGroup2",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_2_Up>nMkt_fx_2_Down,Mkt_fx_2_Up,Mkt_fx_2_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_2_Up,nMkt_fx_2_Down)","v":0}]
[null,"Marketfx,CurrGroup3",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_3_Up>nMkt_fx_3_Down,Mkt_fx_3_Up,Mkt_fx_3_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_3_Up,nMkt_fx_3_Down)","v":0}]
[null,"Marketfx,CurrGroup4",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_4_Up>nMkt_fx_4_Down,Mkt_fx_4_Up,Mkt_fx_4_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_4_Up,nMkt_fx_4_Down)","v":0}]
[null,"Marketfx,CurrGroup5",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_5_Up>nMkt_fx_5_Down,Mkt_fx_5_Up,Mkt_fx_5_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_5_Up,nMkt_fx_5_Down)","v":0}]
[null,"Marketfx,CurrGroup6",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_6_Up>nMkt_fx_6_Down,Mkt_fx_6_Up,Mkt_fx_6_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_6_Up,nMkt_fx_6_Down)","v":0}]
[null,"Marketfx,CurrGroup7",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_7_Up>nMkt_fx_7_Down,Mkt_fx_7_Up,Mkt_fx_7_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_7_Up,nMkt_fx_7_Down)","v":0}]
[null,"Marketfx,CurrGroup8",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_8_Up>nMkt_fx_8_Down,Mkt_fx_8_Up,Mkt_fx_8_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_8_Up,nMkt_fx_8_Down)","v":0}]
[null,"Marketfx,CurrGroup9",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_9_Up>nMkt_fx_9_Down,Mkt_fx_9_Up,Mkt_fx_9_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_9_Up,nMkt_fx_9_Down)","v":0}]
[null,"Marketfx,CurrGroup10",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_10_Up>nMkt_fx_10_Down,Mkt_fx_10_Up,Mkt_fx_10_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_10_Up,nMkt_fx_10_Down)","v":0}]
[null,"Marketfx,CurrGroup11",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_11_Up>nMkt_fx_11_Down,Mkt_fx_11_Up,Mkt_fx_11_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_11_Up,nMkt_fx_11_Down)","v":0}]
[null,"Marketfx,CurrGroup12",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_12_Up>nMkt_fx_12_Down,Mkt_fx_12_Up,Mkt_fx_12_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_12_Up,nMkt_fx_12_Down)","v":0}]
[null,"Marketfx,CurrGroup13",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_13_Up>nMkt_fx_13_Down,Mkt_fx_13_Up,Mkt_fx_13_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_13_Up,nMkt_fx_13_Down)","v":0}]
[null,"Marketfx,CurrGroup14",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_14_Up>nMkt_fx_14_Down,Mkt_fx_14_Up,Mkt_fx_14_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_14_Up,nMkt_fx_14_Down)","v":0}]
[null,"Marketfx,CurrGroup15",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_fx_15_Up>nMkt_fx_15_Down,Mkt_fx_15_Up,Mkt_fx_15_Down))","v":0},null,{"$f":"MAX(0,nMkt_fx_15_Up,nMkt_fx_15_Down)","v":0}]
[]
[null,"Marketfx",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N118:N132),CurrencyCorr),N118:N132))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P118:P132),CurrencyCorr),P118:P132))","v":0}]
[]
[null,"Currency Simplification"]
[]
[null,"Marketfx",null,{"$f":"'Raw Data'!$I$231","v":0},null,{"$f":"'Raw Data'!$I$232","v":0},null,{"$f":"'Raw Data'!$I$233","v":0},null,{"$f":"$D138-$F138-BE_Liabs_VDB","v":0},null,{"$f":"$D138-$F138-$H138","v":0},null,{"$f":"MAX(0,-($J138-$J$29))","v":0},null,{"$f":"MAX(0,-($L138-$L$29))","v":0}]
[]
[]
[null,"Spread Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketspbonds",null,{"$f":"'Raw Data'!$I$234","v":0},null,{"$f":"'Raw Data'!$I$235","v":0},null,{"$f":"'Raw Data'!$I$236","v":0},null,{"$f":"$D144-$F144-BE_Liabs_VDB","v":0},null,{"$f":"$D144-$F144-$H144","v":0},null,{"$f":"-($J144-$J$29)","v":0},null,{"$f":"-($L144-$L$29)","v":0}]
[]
[null,"Marketspsecuritisations",null,{"$f":"'Raw Data'!$I$237","v":0},null,{"$f":"'Raw Data'!$I$238","v":0},null,{"$f":"'Raw Data'!$I$239","v":0},null,{"$f":"$D146-$F146-BE_Liabs_VDB","v":0},null,{"$f":"$D146-$F146-$H146","v":0},null,{"$f":"-($J146-$J$29)","v":0},null,{"$f":"-($L146-$L$29)","v":0}]
[]
[null,"Marketspcdupward",null,{"$f":"'Raw Data'!$I$240","v":0},null,{"$f":"'Raw Data'!$I$241","v":0},null,{"$f":"'Raw Data'!$I$242","v":0},null,{"$f":"$D148-$F148-BE_Liabs_VDB","v":0},null,{"$f":"$D148-$F148-$H148","v":0},null,{"$f":"MAX(0,-($J148-$J$29))","v":0},null,{"$f":"MAX(0,-($L148-$L$29))","v":0}]
[null,"Marketspcddownward",null,{"$f":"'Raw Data'!$I$243","v":0},null,{"$f":"'Raw Data'!$I$244","v":0},null,{"$f":"'Raw Data'!$I$245","v":0},null,{"$f":"$D149-$F149-BE_Liabs_VDB","v":0},null,{"$f":"$D149-$F149-$H149","v":0},null,{"$f":"MAX(0,-($J149-$J$29))","v":0},null,{"$f":"MAX(0,-($L149-$L$29))","v":0}]
[]
[null,"Marketspcd",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(0,IF(nMkt_sp_cd_Up>nMkt_sp_cd_Down,Mkt_sp_cd_Up,Mkt_sp_cd_Down))","v":0},null,{"$f":"MAX(0,nMkt_sp_cd_Up,nMkt_sp_cd_Down)","v":0}]
[]
[null,"Marketspread",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Mkt_sp_Bonds,Mkt_sp_Sec,Mkt_sp_cd)","v":0},null,{"$f":"SUM(nMkt_sp_Bonds,nMkt_sp_Sec,nMkt_sp_cd)","v":0}]
[]
[]
[null,"Concentration Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Marketconc",null,{"$f":"'Raw Data'!$I$246","v":0},null,{"$f":"'Raw Data'!$I$247","v":0},null,{"$f":"'Raw Data'!$I$248","v":0},null,{"$f":"$D159-$F159-BE_Liabs_VDB","v":0},null,{"$f":"$D159-$F159-$H159","v":0},null,{"$f":"-($J159-$J$29)","v":0},null,{"$f":"-($L159-$L$29)","v":0}]

{"sheet":"Counterparty Default Risk","index":7,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"Counterparty Default Risk"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(O4:O29,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Counterparty Default Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(D23:D24)","v":0},null,{"$f":"SUM(F23:F24)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"D26-F7","v":0},null,{"$f":"F26-H7","v":0}]
[]
[null,"SCRdefault",null,null,null,{"$f":"SUM(F7,F9)","v":0},null,{"$f":"SUM(H7,H9)","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D17-$F17-$H17","v":0},null,{"$f":"$D17-$F17-$H17","v":0}]
[]
[]
[null,"Counterparty Default Risk",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCRdefault,1",null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SCR_Def_1=\"\",nSCR_Def_1=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"SCRdefault,2",null,0,null,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(SCR_Def_2=\"\",nSCR_Def_2=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"SCRdefault",null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(D23:D24),DefaultCorr),D23:D24))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F23:F24),DefaultCorr),F23:F24))","v":0}]

{"sheet":"Life Underwriting Risk","index":8,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"Life Underwriting Risk"]
[]
[]
[null,"Life Underwriting Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifemortality",null,null,null,{"$f":"Life_Mort","v":0},null,{"$f":"nLife_Mort","v":0}]
[null,"Lifelongevity",null,null,null,{"$f":"Life_Long","v":0},null,{"$f":"nLife_Long","v":0}]
[null,"Lifedis+morb",null,null,null,{"$f":"Life_Dis_Morb","v":0},null,{"$f":"nLife_Dis_Morb","v":0}]
[null,"Lifelapse",null,null,null,{"$f":"Life_Lapse","v":0},null,{"$f":"nLife_Lapse","v":0}]
[null,"Lifeexpense",null,null,null,{"$f":"Life_Exp","v":0},null,{"$f":"nLife_Exp","v":0}]
[null,"Liferevision",null,null,null,{"$f":"Life_Rev","v":0},null,{"$f":"nLife_Rev","v":0}]
[null,"LifeCAT",null,null,null,{"$f":"Life_CAT","v":0},null,{"$f":"nLife_CAT","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F7:F13)","v":0},null,{"$f":"SUM(H7:H13)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F19-F15","v":0},null,{"$f":"H19-H15","v":0}]
[]
[null,"SCRlife",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F13),LifeCorr),F7:F13))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H13),LifeCorr),H7:H13))","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D25-$F25-$H25","v":0},null,{"$f":"$D25-$F25-$H25","v":0}]
[]
[]
[null,"Mortality Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifemortality",null,{"$f":"'Raw Data'!$I$250","v":0},null,{"$f":"'Raw Data'!$I$251","v":0},null,{"$f":"'Raw Data'!$I$252","v":0},null,{"$f":"$D31-$F31-BE_Liabs_VDB","v":0},null,{"$f":"$D31-$F31-$H31","v":0},null,{"$f":"-($J31-$J$25)","v":0},null,{"$f":"-($L31-$L$25)","v":0}]
[]
[]
[null,"Longevity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifelongevity",null,{"$f":"'Raw Data'!$I$253","v":0},null,{"$f":"'Raw Data'!$I$254","v":0},null,{"$f":"'Raw Data'!$I$255","v":0},null,{"$f":"$D37-$F37-BE_Liabs_VDB","v":0},null,{"$f":"$D37-$F37-$H37","v":0},null,{"$f":"-($J37-$J$25)","v":0},null,{"$f":"-($L37-$L$25)","v":0}]
[]
[]
[null,"Disability & Morbidity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifedisability",null,{"$f":"'Raw Data'!$I$256","v":0},null,{"$f":"'Raw Data'!$I$257","v":0},null,{"$f":"'Raw Data'!$I$258","v":0},null,{"$f":"$D43-$F43-BE_Liabs_VDB","v":0},null,{"$f":"$D43-$F43-$H43","v":0},null,{"$f":"MAX(0,-($J43-$J$25))","v":0},null,{"$f":"MAX(0,-($L43-$L$25))","v":0}]
[]
[null,"Lifemorbidity",null,{"$f":"'Raw Data'!$I$259","v":0},null,{"$f":"'Raw Data'!$I$260","v":0},null,{"$f":"'Raw Data'!$I$261","v":0},null,{"$f":"$D45-$F45-BE_Liabs_VDB","v":0},null,{"$f":"$D45-$F45-$H45","v":0},null,{"$f":"MAX(0,-($J45-$J$25))","v":0},null,{"$f":"MAX(0,-($L45-$L$25))","v":0}]
[]
[null,"Lifedis+morb",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Life_Dis,Life_Morb)","v":0},null,{"$f":"SUM(nLife_Dis,nLife_Morb)","v":0}]
[]
[]
[null,"Lapse Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lapsedown",null,{"$f":"'Raw Data'!$I$262","v":0},null,{"$f":"'Raw Data'!$I$263","v":0},null,{"$f":"'Raw Data'!$I$264","v":0},null,{"$f":"$D53-$F53-BE_Liabs_VDB","v":0},null,{"$f":"$D53-$F53-$H53","v":0},null,{"$f":"-($J53-$J$25)","v":0},null,{"$f":"-($L53-$L$25)","v":0}]
[null,"Lapseup",null,{"$f":"'Raw Data'!$I$265","v":0},null,{"$f":"'Raw Data'!$I$266","v":0},null,{"$f":"'Raw Data'!$I$267","v":0},null,{"$f":"$D54-$F54-BE_Liabs_VDB","v":0},null,{"$f":"$D54-$F54-$H54","v":0},null,{"$f":"-($J54-$J$25)","v":0},null,{"$f":"-($L54-$L$25)","v":0}]
[null,"Lapsemass",null,{"$f":"'Raw Data'!$I$268","v":0},null,{"$f":"'Raw Data'!$I$269","v":0},null,{"$f":"'Raw Data'!$I$270","v":0},null,{"$f":"$D55-$F55-BE_Liabs_VDB","v":0},null,{"$f":"$D55-$F55-$H55","v":0},null,{"$f":"-($J55-$J$25)","v":0},null,{"$f":"-($L55-$L$25)","v":0}]
[]
[null,"Lifelapse",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(0,P53:P55)=n_Lapse_Down,Lapse_Down,IF(MAX(0,P53:P55)=nLapse_Up,Lapse_Up,IF(MAX(0,P53:P55)=nLapse_Mass,Lapse_Mass,0)))","v":0},null,{"$f":"MAX(0,n_Lapse_Down,nLapse_Up,nLapse_Mass)","v":0}]
[]
[]
[null,"Expense Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Lifeexpense",null,{"$f":"'Raw Data'!$I$271","v":0},null,{"$f":"'Raw Data'!$I$272","v":0},null,{"$f":"'Raw Data'!$I$273","v":0},null,{"$f":"$D63-$F63-BE_Liabs_VDB","v":0},null,{"$f":"$D63-$F63-$H63","v":0},null,{"$f":"-($J63-$J$25)","v":0},null,{"$f":"-($L63-$L$25)","v":0}]
[]
[]
[null,"Revision Risk                        ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Liferevision",null,{"$f":"'Raw Data'!$I$274","v":0},null,{"$f":"'Raw Data'!$I$275","v":0},null,{"$f":"'Raw Data'!$I$276","v":0},null,{"$f":"$D69-$F69-BE_Liabs_VDB","v":0},null,{"$f":"$D69-$F69-$H69","v":0},null,{"$f":"-($J69-$J$25)","v":0},null,{"$f":"-($L69-$L$25)","v":0}]
[]
[]
[null,"Life Catastrophe Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"LifeCAT",null,{"$f":"'Raw Data'!$I$277","v":0},null,{"$f":"'Raw Data'!$I$278","v":0},null,{"$f":"'Raw Data'!$I$279","v":0},null,{"$f":"$D75-$F75-BE_Liabs_VDB","v":0},null,{"$f":"$D75-$F75-$H75","v":0},null,{"$f":"MAX(0,-($J75-$J$25))","v":0},null,{"$f":"MAX(0,-($L75-$L$25))","v":0}]

{"sheet":"Health Underwriting Risk","index":9,"n_rows":75,"n_cols":16,"rows_kept":75,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"Health Underwriting Risk"]
[]
[]
[null,"Health Underwriting Risk",null,null,null,"Capital",null,"nCapital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmortality",null,null,null,{"$f":"Health_Mort","v":0},null,{"$f":"nHealth_Mort","v":0}]
[null,"Healthlongevity",null,null,null,{"$f":"Health_Long","v":0},null,{"$f":"nHealth_Long","v":0}]
[null,"Healthdis+morb",null,null,null,{"$f":"Health_Dis_Morb","v":0},null,{"$f":"nHealth_Dis_Morb","v":0}]
[null,"Healthlapse",null,null,null,{"$f":"Health_Lapse","v":0},null,{"$f":"nHealth_Lapse","v":0}]
[null,"Healthexpense",null,null,null,{"$f":"Health_Exp","v":0},null,{"$f":"nHealth_Exp","v":0}]
[null,"Healthrevision",null,null,null,{"$f":"Health_Rev","v":0},null,{"$f":"nHealth_Rev","v":0}]
[]
[null,"HealthSLT",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F7:F12),HealthCorr_SLT),F7:F12))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H12),HealthCorr_SLT),H7:H12))","v":0}]
[null,"HealthCAT",null,null,null,{"$f":"'Raw Data'!I311","v":0},null,{"$f":"'Raw Data'!I312","v":0}]
[null,"HealthNSLT",null,null,null,{"$f":"'Raw Data'!I313","v":0},null,{"$f":"'Raw Data'!I314","v":0}]
[]
[null,"Capital Requirement (before diversification effects)",null,null,null,{"$f":"SUM(F14:F16)","v":0},null,{"$f":"SUM(H14:H16)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"F22-F18","v":0},null,{"$f":"H22-H18","v":0}]
[]
[null,"SCRHealth",null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F14:F16),HealthCorr),F14:F16))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H14:H16),HealthCorr),H14:H16))","v":0}]
[]
[]
[null,"Best Estimate",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Base",null,{"$f":"BE_Assets","v":0},null,{"$f":"BE_Liabs_VGB","v":0},null,{"$f":"BE_Liabs_VDB","v":0},null,{"$f":"$D28-$F28-$H28","v":0},null,{"$f":"$D28-$F28-$H28","v":0}]
[]
[]
[null,"Mortality Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmortality",null,{"$f":"'Raw Data'!$I$281","v":0},null,{"$f":"'Raw Data'!$I$282","v":0},null,{"$f":"'Raw Data'!$I$283","v":0},null,{"$f":"$D34-$F34-BE_Liabs_VDB","v":0},null,{"$f":"$D34-$F34-$H34","v":0},null,{"$f":"-($J34-$J$28)","v":0},null,{"$f":"-($L34-$L$28)","v":0}]
[]
[]
[null,"Longevity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthlongevity",null,{"$f":"'Raw Data'!$I$284","v":0},null,{"$f":"'Raw Data'!$I$285","v":0},null,{"$f":"'Raw Data'!$I$286","v":0},null,{"$f":"$D40-$F40-BE_Liabs_VDB","v":0},null,{"$f":"$D40-$F40-$H40","v":0},null,{"$f":"-($J40-$J$28)","v":0},null,{"$f":"-($L40-$L$28)","v":0}]
[]
[]
[null,"Disability & Morbidity Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthmedical_up",null,{"$f":"'Raw Data'!I287","v":0},null,{"$f":"'Raw Data'!I288","v":0},null,{"$f":"'Raw Data'!I289","v":0},null,{"$f":"$D46-$F46-BE_Liabs_VDB","v":0},null,{"$f":"$D46-$F46-$H46","v":0},null,{"$f":"MAX(0,-($J46-$J$28))","v":0},null,{"$f":"MAX(0,-($L46-$L$28))","v":0}]
[null,"Healthmedical_down",null,{"$f":"'Raw Data'!I290","v":0},null,{"$f":"'Raw Data'!I291","v":0},null,{"$f":"'Raw Data'!I292","v":0},null,{"$f":"$D47-$F47-BE_Liabs_VDB","v":0},null,0,null,0,null,0]
[]
[null,"Healthmedical",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(nHealth_medical_up>nHealth_medical_down,Health_medical_up,IF(nHealth_medical_down>Health_medical_up,Health_medical_down,MAX(Health_medical_down,Health_medical_up)))","v":0},null,{"$f":"MAX(0,nHealth_medical_up,nHealth_medical_down)","v":0}]
[]
[null,"Healthincome",null,{"$f":"'Raw Data'!$I$293","v":0},null,{"$f":"'Raw Data'!$I$294","v":0},null,{"$f":"'Raw Data'!$I$295","v":0},null,{"$f":"$D51-$F51-BE_Liabs_VDB","v":0},null,{"$f":"$D51-$F51-$H51","v":0},null,{"$f":"MAX(0,-($J51-$J$28))","v":0},null,{"$f":"MAX(0,-($L51-$L$28))","v":0}]
[]
[null,"Healthdis+morb",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Health_medical,Health_income)","v":0},null,{"$f":"SUM(nHealth_medical,nHealth_income)","v":0}]
[]
[]
[null,"Lapse Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"HLapsedown",null,{"$f":"'Raw Data'!$I$296","v":0},null,{"$f":"'Raw Data'!$I$297","v":0},null,{"$f":"'Raw Data'!$I$298","v":0},null,{"$f":"$D59-$F59-BE_Liabs_VDB","v":0},null,{"$f":"$D59-$F59-$H59","v":0},null,{"$f":"-($J59-$J$28)","v":0},null,{"$f":"-($L59-$L$28)","v":0}]
[null,"HLapseup",null,{"$f":"'Raw Data'!$I$299","v":0},null,{"$f":"'Raw Data'!$I$300","v":0},null,{"$f":"'Raw Data'!$I$301","v":0},null,{"$f":"$D60-$F60-BE_Liabs_VDB","v":0},null,{"$f":"$D60-$F60-$H60","v":0},null,{"$f":"-($J60-$J$28)","v":0},null,{"$f":"-($L60-$L$28)","v":0}]
[null,"HLapsemass",null,{"$f":"'Raw Data'!$I$302","v":0},null,{"$f":"'Raw Data'!$I$303","v":0},null,{"$f":"'Raw Data'!$I$304","v":0},null,{"$f":"$D61-$F61-BE_Liabs_VDB","v":0},null,{"$f":"$D61-$F61-$H61","v":0},null,{"$f":"-($J61-$J$28)","v":0},null,{"$f":"-($L61-$L$28)","v":0}]
[]
[null,"Healthlapse",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MAX(0,P59:P61)=n_HLapse_Down,HLapse_Down,IF(MAX(0,P59:P61)=nHLapse_Up,HLapse_Up,IF(MAX(0,P59:P61)=nHLapse_Mass,HLapse_Mass,0)))","v":0},null,{"$f":"MAX(0,n_HLapse_Down,nHLapse_Up,nHLapse_Mass)","v":0}]
[]
[]
[null,"Expense Risk",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthexpense",null,{"$f":"'Raw Data'!$I$305","v":0},null,{"$f":"'Raw Data'!$I$306","v":0},null,{"$f":"'Raw Data'!$I$307","v":0},null,{"$f":"$D69-$F69-BE_Liabs_VDB","v":0},null,{"$f":"$D69-$F69-$H69","v":0},null,{"$f":"-($J69-$J$28)","v":0},null,{"$f":"-($L69-$L$28)","v":0}]
[]
[]
[null,"Revision Risk                         ",null,"Assets",null,"VGB",null,"VDB",null,"BOF",null,"nBOF",null,"Capital",null,"nCapital"]
[null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Healthrevision",null,{"$f":"'Raw Data'!$I$308","v":0},null,{"$f":"'Raw Data'!$I$309","v":0},null,{"$f":"'Raw Data'!$I$310","v":0},null,{"$f":"$D75-$F75-BE_Liabs_VDB","v":0},null,{"$f":"$D75-$F75-$H75","v":0},null,{"$f":"-($J75-$J$28)","v":0},null,{"$f":"-($L75-$L$28)","v":0}]

{"sheet":"Ring-Fenced Fund Adjustment","index":10,"n_rows":44,"n_cols":35,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"Ring-Fenced Fund Adjustment"]
[]
[]
[null,"Do you have ring-fenced Funds?",null,"No"]
[null,"If you have one or more fing-fenced funds, update the below for each ring-fenced fund. You will need to complete the rest of this return as if you don’t have a ring-fenced fund. "]
[null,"You will need to determine the SCR and own-funds for each ring-fenced fund separately and include the results here.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D4=\"No\",\"Complete\",IF(COUNTIF(AI8:AI45,\"Incomplete\")>0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,"Solvency Capital Requirement",null,"RFF1",null,"RFF2",null,"RFF3",null,"RFF4",null,"RFF5",null,"RFF6",null,"RFF7",null,"RFF8",null,"RFF9",null,"RFF10",null,"RFF11",null,"Not ring-fenced",null,"Total SCR",null,"With no RFF constraint",null,"Total SCR allowing for RFFs"]
[null,null,null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,"'000",null,null,null,"'000",null,"'000"]
[]
[null,"SCRmarket",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(D11,F11,H11,J11,L11,N11,P11,R11,T11,V11,X11,Z11)","v":0},null,{"$f":"SUM(D11,F11,H11,J11,L11,N11,P11,R11,T11,V11,X11,Z11)","v":0}]
[null,"SCRdefault",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(D12,F12,H12,J12,L12,N12,P12,R12,T12,V12,X12,Z12)","v":0},null,{"$f":"SUM(D12,F12,H12,J12,L12,N12,P12,R12,T12,V12,X12,Z12)","v":0}]
[null,"SCRlife",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,0]
[null,"SCRhealth",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,0]
[null,"SCRnon-life",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,0]
[null,"SCRintangibles",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,0,null,0]
[]
[null,"BSCR (before diversification effects)",null,{"$f":"SUM(D11:D16)","v":0},null,{"$f":"SUM(F11:F16)","v":0},null,{"$f":"SUM(H11:H16)","v":0},null,{"$f":"SUM(J11:J16)","v":0},null,{"$f":"SUM(L11:L16)","v":0},null,{"$f":"SUM(N11:N16)","v":0},null,{"$f":"SUM(P11:P16)","v":0},null,{"$f":"SUM(R11:R16)","v":0},null,{"$f":"SUM(T11:T16)","v":0},null,{"$f":"SUM(V11:V16)","v":0},null,{"$f":"SUM(X11:X16)","v":0},null,{"$f":"SUM(Z11:Z16)","v":0},null,null,null,{"$f":"SUM(AD11:AD16)","v":0},null,{"$f":"SUM(AF11:AF16)","v":0},null,null,{"$f":"IF(D4=\"No\",\"Complete\",IF(AF18=0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,"Diversification",null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(D11:D15),Corr),D11:D15))-SUM(D11:D15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(F11:F15),Corr),F11:F15))-SUM(F11:F15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H11:H15),Corr),H11:H15))-SUM(H11:H15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(J11:J15),Corr),J11:J15))-SUM(J11:J15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(L11:L15),Corr),L11:L15))-SUM(L11:L15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(N11:N15),Corr),N11:N15))-SUM(N11:N15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(P11:P15),Corr),P11:P15))-SUM(P11:P15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(R11:R15),Corr),R11:R15))-SUM(R11:R15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(T11:T15),Corr),T11:T15))-SUM(T11:T15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(V11:V15),Corr),V11:V15))-SUM(V11:V15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(X11:X15),Corr),X11:X15))-SUM(X11:X15)","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(Z11:Z15),Corr),Z11:Z15))-SUM(Z11:Z15)","v":0},null,null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(AD11:AD15),Corr),AD11:AD15))-SUM(AD11:AD15)","v":0},null,{"$f":"SUM(D20,F20,H20,J20,L20,N20,P20,R20,T20,V20,X20,Z20)","v":0}]
[]
[null,"BSCR",null,{"$f":"SUM(D18,D20)","v":0},null,{"$f":"SUM(F18,F20)","v":0},null,{"$f":"SUM(H18,H20)","v":0},null,{"$f":"SUM(J18,J20)","v":0},null,{"$f":"SUM(L18,L20)","v":0},null,{"$f":"SUM(N18,N20)","v":0},null,{"$f":"SUM(P18,P20)","v":0},null,{"$f":"SUM(R18,R20)","v":0},null,{"$f":"SUM(T18,T20)","v":0},null,{"$f":"SUM(V18,V20)","v":0},null,{"$f":"SUM(X18,X20)","v":0},null,{"$f":"SUM(Z18,Z20)","v":0},null,null,null,{"$f":"AD20+AD18","v":0},null,{"$f":"SUM(AF18,AF20)","v":0}]
[]
[null,"Operational Risk SCR",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SCR_Op_UL+SCRop_nonUL+SCR_Op_Non_life","v":0},null,{"$f":"AD24","v":0}]
[]
[null,"Regulatory Adjustment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Adj_Reg","v":0},null,{"$f":"AD26","v":0}]
[]
[null,"Other Adjustments",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Adj_DT+Adj_TP","v":0},null,{"$f":"AD28","v":0}]
[]
[null,"SCR",null,{"$f":"SUM(D22,D26,D24,D28)","v":0},null,{"$f":"SUM(F22,F26,F24,F28)","v":0},null,{"$f":"SUM(H22,H26,H24,H28)","v":0},null,{"$f":"SUM(J22,J26,J24,J28)","v":0},null,{"$f":"SUM(L22,L26,L24,L28)","v":0},null,{"$f":"SUM(N22,N26,N24,N28)","v":0},null,{"$f":"SUM(P22,P26,P24,P28)","v":0},null,{"$f":"SUM(R22,R26,R24,R28)","v":0},null,{"$f":"SUM(T22,T26,T24,T28)","v":0},null,{"$f":"SUM(V22,V26,V24,V28)","v":0},null,{"$f":"SUM(X22,X26,X24,X28)","v":0},null,{"$f":"SUM(Z22,Z26,Z24,Z28)","v":0},null,{"$f":"SUM(D30,F30,H30,J30,L30,N30,P30,R30,T30,V30,X30,Z30)","v":0},null,{"$f":"SUM(AD22,AD24,AD26,AD28)","v":0},null,{"$f":"SUM(AF22,AF24,AF26,AF28)","v":0}]
[]
[]
[]
[null,"Own Funds",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Own Funds",null,"With no RFF constraint",null,"Total Own Funds allowing for RFFs"]
[]
[null,"Tier 1",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(D36,F36,H36,J36,L36,N36,P36,R36,T36,V36,X36,Z36)","v":0},null,{"$f":"AD36-SUM(D44,F44,H44,J44,L44,N44,P44,R44,T44,V44,X44)","v":0}]
[null,"Tier 2 ",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(D37,F37,H37,J37,L37,N37,P37,R37,T37,V37,X37,Z37)","v":0},null,{"$f":"AD37","v":0}]
[null,"Tier 3 ",null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,{"$f":"SUM(D38,F38,H38,J38,L38,N38,P38,R38,T38,V38,X38,Z38)","v":0},null,{"$f":"AD38","v":0}]
[]
[null,"Total Own Funds",null,{"$f":"SUM(D36:D38)","v":0},null,{"$f":"SUM(F36:F38)","v":0},null,{"$f":"SUM(H36:H38)","v":0},null,{"$f":"SUM(J36:J38)","v":0},null,{"$f":"SUM(L36:L38)","v":0},null,{"$f":"SUM(N36:N38)","v":0},null,{"$f":"SUM(P36:P38)","v":0},null,{"$f":"SUM(R36:R38)","v":0},null,{"$f":"SUM(T36:T38)","v":0},null,{"$f":"SUM(V36:V38)","v":0},null,{"$f":"SUM(X36:X38)","v":0},null,{"$f":"SUM(Z36:Z38)","v":0},null,{"$f":"SUM(D40,F40,H40,J40,L40,N40,P40,R40,T40,V40,X40,Z40)-SUM(D44,F44,H44,J44,L44,N44,P44,R44,T44,V44,X44)","v":0},null,{"$f":"SUM(AD36:AD38)","v":0},null,{"$f":"SUM(AF36:AF38)","v":0},null,null,{"$f":"IF(D4=\"No\",\"Complete\",IF(AF40=0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,"Solvency Coverage Ratio",null,{"$f":"IF(D30<>0,D40/D30,\"N/A\")","v":"N/A"},null,{"$f":"IF(F30<>0,F40/F30,\"N/A\")","v":"N/A"},null,{"$f":"IF(H30<>0,H40/H30,\"N/A\")","v":"N/A"},null,{"$f":"IF(J30<>0,J40/J30,\"N/A\")","v":"N/A"},null,{"$f":"IF(L30<>0,L40/L30,\"N/A\")","v":"N/A"},null,{"$f":"IF(N30<>0,N40/N30,\"N/A\")","v":"N/A"},null,{"$f":"IF(P30<>0,P40/P30,\"N/A\")","v":"N/A"},null,{"$f":"IF(R30<>0,R40/R30,\"N/A\")","v":"N/A"},null,{"$f":"IF(T30<>0,T40/T30,\"N/A\")","v":"N/A"},null,{"$f":"IF(V30<>0,V40/V30,\"N/A\")","v":"N/A"},null,{"$f":"IF(X30<>0,X40/X30,\"N/A\")","v":"N/A"},null,{"$f":"IF(Z30<>0,Z40/Z30,\"N/A\")","v":"N/A"},null,{"$f":"IF(AB30<>0,AB40/AB30,\"N/A\")","v":"N/A"},null,{"$f":"IF(AD30<>0,AD40/AD30,\"N/A\")","v":"N/A"},null,{"$f":"IF(AF30<>0,AF40/AF30,\"N/A\")","v":"N/A"}]
[]
[null,"Own funds in excess of SCR",null,{"$f":"MAX(0,D40-D30)","v":0},null,{"$f":"MAX(0,F40-F30)","v":0},null,{"$f":"MAX(0,H40-H30)","v":0},null,{"$f":"MAX(0,J40-J30)","v":0},null,{"$f":"MAX(0,L40-L30)","v":0},null,{"$f":"MAX(0,N40-N30)","v":0},null,{"$f":"MAX(0,P40-P30)","v":0},null,{"$f":"MAX(0,R40-R30)","v":0},null,{"$f":"MAX(0,T40-T30)","v":0},null,{"$f":"MAX(0,V40-V30)","v":0},null,{"$f":"MAX(0,X40-X30)","v":0}]

{"sheet":"SCR Summary","index":11,"n_rows":54,"n_cols":18,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"SCR Summary"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(K7:K56,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"For info"]
[null,"SCR",null,null,null,"Capital",null,"nCapital",null,null,null,null,null,"Solvency Capital Requirement (25% Op Risk)",null,null,null,"Capital"]
[null,null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCR Market",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"Yes\",'Ring-Fenced Fund Adjustment'!AF11,SCR_Market)","v":0},null,{"$f":"nSCR_Market","v":0},null,null,null,null,null,"SCRmarket",null,null,null,{"$f":"SCR_Market","v":0}]
[null,"SCR Default",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"yes\",'Ring-Fenced Fund Adjustment'!AF12,SCR_Default)","v":0},null,{"$f":"nSCR_Default","v":0},null,null,null,null,null,"SCRdefault",null,null,null,{"$f":"SCR_Default","v":0}]
[null,"SCR Life",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"yes\",'Ring-Fenced Fund Adjustment'!AF13,SCR_Life)","v":0},null,{"$f":"nSCR_Life","v":0},null,null,null,null,null,"SCRlife",null,null,null,{"$f":"SCR_Life","v":0}]
[null,"SCR Health",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"yes\",'Ring-Fenced Fund Adjustment'!AF14,'Health Underwriting Risk'!SCR_Health)","v":0},null,{"$f":"'Health Underwriting Risk'!nSCR_Health","v":0},null,null,null,null,null,"SCRhealth",null,null,null,{"$f":"'Health Underwriting Risk'!SCR_Health","v":0}]
[null,"SCR Non-Life (composites only)",null,null,null,0,null,0,null,null,{"$f":"IF(OR(H11=\"\",F11=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"SCR Intangibles",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"yes\",'Ring-Fenced Fund Adjustment'!AF16,0.8*'Regulatory Balance Sheet'!$F$10)","v":0},null,{"$f":"0.8*'Regulatory Balance Sheet'!$F$10","v":0},null,null,null,null,null,"SCRintangibles",null,null,"*",{"$f":"0.8*'Regulatory Balance Sheet'!$F$10","v":0}]
[]
[null,"BSCR (before diversification)",null,null,null,{"$f":"SUM(F7:F12)","v":0},null,{"$f":"SUM(H7:H12)","v":0},null,null,null,null,null,"BSCR (before diversification effects)",null,null,null,{"$f":"SUM(R7:R12)","v":0}]
[]
[null,"Diversification",null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"Yes\",'Ring-Fenced Fund Adjustment'!AF20,SQRT(MMULT(MMULT(TRANSPOSE(F7:F11),Corr),F7:F11))-SUM(F7:F11))","v":0},null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(H7:H11),Corr),H7:H11))-SUM(H7:H11)","v":0},null,null,null,null,null,"Diversification",null,null,"*",{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(R7:R10),Corr),R7:R10))-SUM(R7:R10)","v":{"$error":"#VALUE!"}}]
[]
[null,"BSCR",null,null,null,{"$f":"SUM(F14,F16)","v":0},null,{"$f":"SUM(H14,H16)","v":0},null,null,null,null,null,"BSCR",null,null,null,{"$f":"SUM(R14,R16)","v":{"$error":"#VALUE!"}}]
[]
[null,"SCR Op-UL",null,null,null,{"$f":"EXPul","v":0},null,{"$f":"SCR_Op_UL","v":0},null,null,null,null,null,"SCROp_risk",null,null,"*",{"$f":"SCR_Op_UL*1/3","v":0}]
[null,"SCR Op-Non-UL",null,null,null,{"$f":"+MAX(Op_premiums,Op_provisions)","v":0},null,{"$f":"SCRop_nonUL","v":0}]
[null,"SCR Op_Non-life",null,null,null,0,null,0,null,null,{"$f":"IF(OR(H22=\"\",F22=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Adj for loss absorbing capacity of TPs",null,null,null,{"$f":"-MAX(0,MIN(IF('Ring-Fenced Fund Adjustment'!D4=\"Yes\",'Ring-Fenced Fund Adjustment'!AD22,BSCR)-nBSCR,'Regulatory Balance Sheet'!F88+'Regulatory Balance Sheet'!F97))","v":0},null,null,null,null,null,null,null,"Adjustment for loss absorbing capacity of TPs",null,null,null,{"$f":"-MAX(0,MIN(BSCR-nBSCR,'Regulatory Balance Sheet'!R88+'Regulatory Balance Sheet'!R97))","v":0}]
[]
[null,"Adj for loss absorbing capacity of deferred taxes",null,null,null,0,null,null,null,null,{"$f":"IF(OR(Adj_DT=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"},null,null,"Adjustment for loss absorbing capacity of deferred tax"]
[]
[null,"Regulatory Adj",null,null,null,0,null,null,null,null,null,null,null,"Regulatory Adjustment"]
[]
[null,"SCR",null,null,null,{"$f":"(BSCR^2+2*0.5*BSCR*SCR_Op_UL+SCR_Op_UL^2)^0.5+SUM(Adj_TP,Adj_DT,Adj_Reg,SCRop_nonUL,SCR_Op_Non_life)","v":0},null,null,null,null,null,null,null,"SCR",null,null,"*",{"$f":"SUM(R18,R20,R24,R26,R28)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"SCR Own-Funds",null,null,null,{"$f":"\"'000\"","v":"'000"},null,null,null,null,null,null,null,"Capital Resources"]
[]
[null,"Tier 1 Own-Funds",null,null,null,{"$f":"'Own Funds'!D115","v":0},null,null,null,null,null,null,null,"Tier 1 Capital",null,null,null,{"$f":"EOF_Tier_1","v":0}]
[null,"Tier 2 Own-Funds",null,null,null,{"$f":"'Own Funds'!F115","v":0},null,null,null,null,null,null,null,"Tier 2 Capital",null,null,null,{"$f":"EOF_Tier_2","v":0}]
[null,"Tier 3 Own-Funds",null,null,null,{"$f":"'Own Funds'!H115","v":0},null,null,null,null,null,null,null,"Tier 3 Capital",null,null,null,{"$f":"EOF_Tier_3","v":0}]
[]
[null,"Tier 1 Regulatory Adj",null,null,null,0,null,null,null,null,null,null,null,"Tier 1 Regulatory Adjustment"]
[null,"Tier 2 Regulatory Adj",null,null,null,0,null,null,null,null,null,null,null,"Tier 2 Regulatory Adjustment"]
[null,"Tier 3 Regulatory Adj",null,null,null,0,null,null,null,null,null,null,null,"Tier 3 Regulatory Adjustment"]
[]
[null,"Total Own-Funds",null,null,null,{"$f":"SUM(F35:F37,F39:F41)","v":0},null,null,null,null,null,null,null,"Regulatory capital resources to meet SCR",null,null,null,{"$f":"SUM(R35:R37,R39:R41)","v":0}]
[]
[null,"SCR Ratio",null,null,null,{"$f":"IF(ISERROR(Cap_Res/SCR),0,Cap_Res/SCR)","v":0},null,null,null,null,null,null,null,"SCR Ratio",null,null,null,{"$f":"R43/R30","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"SCR excl Mgt Actions",null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"SCR *",null,null,null,0,null,null,null,null,{"$f":"IF(OR(F50=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total Own-Funds",null,null,null,0,null,null,null,null,{"$f":"IF(OR(F52=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"SCR Ratio",null,null,null,{"$f":"IF(ISERROR(F52/F50),0,F52/F50)","v":0}]

{"sheet":"MCR Summary","index":12,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[1,null,null,null,null,"MCR Summary"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(I6,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Incomplete"}]
[null,"MCR",null,null,null,{"$f":"\"'000\"","v":"'000"},null,null,{"$f":"IF('Participant Information'!E11=\"GBP\",1,0)","v":0}]
[]
[null,"    Exchange rate",null,null,null,1,"*",null,{"$f":"IF(AND($F$6<1.0000000001,$I$4=0),\"Incomplete\",IF(OR(F6=\"\",F6=0),\"Incomplete\",\"Complete\"))","v":"Incomplete"}]
[]
[null,"SCR",null,null,null,{"$f":"SCR","v":0}]
[null,"SCR excl Mgt Actions",null,null,null,{"$f":"'SCR Summary'!F50","v":0}]
[]
[null,"MCRSCR",null,null,null,{"$f":"MAX(0.35*F8,0.25*F9)","v":0}]
[null,"FMCR",null,null,null,{"$f":"3000*F6","v":3000}]
[]
[null,"Unadjusted MCR",null,null,null,{"$f":"MAX(F11,F12)","v":3000}]
[]
[null,"Regulatory Adjustment",null,null,null,0]
[]
[null,"MCR",null,null,null,{"$f":"F14+F16","v":3000}]
[]
[]
[null,"MCR Own-Funds",null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,"Tier 1 Own-Funds",null,null,null,{"$f":"'Own Funds'!D120","v":0}]
[null,"Tier 2 Own-Funds",null,null,null,{"$f":"'Own Funds'!F120","v":0}]
[null,"Tier 3 Own-Funds",null,null,null,{"$f":"'Own Funds'!H120","v":0}]
[]
[null,"Tier 1 Regulatory Adj",null,null,null,{"$f":"Tier_1_Adj","v":0}]
[null,"Tier 2 Regulatory Adj",null,null,null,{"$f":"Tier_2_Adj","v":0}]
[null,"Tier 3 Regulatory Adj",null,null,null,{"$f":"Tier_3_Adj","v":0}]
[]
[null,"Total Own-Funds",null,null,null,{"$f":"SUM(F23:F25,F27:F29)","v":0}]
[]
[null,"MCR Ratio",null,null,null,{"$f":"F31/MCR_SII","v":0}]

{"sheet":"Revenue Account Total","index":13,"n_rows":65,"n_cols":26,"rows_kept":65,"cut":false,"hidden":false,"merged":[[4,11,5,15],[3,4,3,8],[3,11,3,15],[4,18,5,18]]}
[1,null,null,null,"Revenue Account Total"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(Z10:Z68,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,null,null,"Quarter",null,null,null,null,null,null,"YTD",null,null,null,null,null,null,"Plan"]
[null,null,null,null,null,null,{"$f":"IF(OR('Participant Information'!E12=\"\",'Participant Information'!E12=0),0,EDATE('Participant Information'!E12,-3))","v":"00:00:00"},null,null,null,null,{"$f":"G6","v":"00:00:00"},null,null,null,null,null,null,{"$f":"L5","v":"00:00:00"},null,"YTD",null,"Commentary*"]
[null,null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,"vs"]
[null,null,null,null,"Gross",null,"Reinsurer's share",null,"Net",null,null,"Gross",null,"Reinsurer's share",null,"Net",null,null,"Net",null,"Plan"]
[null,"Income",null,null,"'000",null,"'000",null,"'000",null,null,"'000",null,"'000",null,"'000",null,null,"'000",null,"%"]
[]
[null,"Written premiums","*",null,{"$f":"SUM(E11:E12)","v":0},null,{"$f":"SUM(G11:G12)","v":0},null,{"$f":"E10-G10","v":0},null,null,{"$f":"SUM(L11:L12)","v":0},null,{"$f":"SUM(N11:N12)","v":0},null,{"$f":"L10-N10","v":0},null,null,{"$f":"SUM(S11:S12)","v":0},null,{"$f":"IF(OR(S10=0,S10=0),0,P10/S10)","v":0},null,null,null,null,{"$f":"IF(OR(E10=\"\",G10=\"\",L10=\"\",N10=\"\",S10=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Regular premiums",null,null,0,null,0,null,{"$f":"E11-G11","v":0},null,null,0,null,0,null,{"$f":"L11-N11","v":0},null,null,0,null,{"$f":"IF(OR(S11=0,S11=0),0,P11/S11)","v":0},null,null,null,null,{"$f":"IF(OR(E11=\"\",G11=\"\",L11=\"\",N11=\"\",S11=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Single premiums",null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Fee Income","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Business transfers-in",null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Investment income","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Gains/(losses) on linked and non-linked assets","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,{"$f":"IF(OR(E16=\"\",G16=\"\",L16=\"\",N16=\"\",S16=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Other income","*",null,0,null,0,null,{"$f":"E17-G17","v":0},null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,{"$f":"IF(OR(E17=\"\",G17=\"\",L17=\"\",N17=\"\",S17=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total",null,null,{"$f":"SUM(E10,E13:E17)","v":0},null,{"$f":"SUM(G10,G15:G17)","v":0},null,{"$f":"SUM(I10,I13:I17)","v":0},null,null,{"$f":"SUM(L10,L13:L17)","v":0},null,{"$f":"SUM(N10,N13:N17)","v":0},null,{"$f":"SUM(P10,P13:P17)","v":0},null,null,{"$f":"SUM(S10,S13:S17)","v":0},null,{"$f":"IF(OR(S19=0,S19=0),0,P19/S19)","v":0}]
[]
[null,"Claims incurred *"]
[]
[null,"Death/disability payments","*",null,0,null,0,null,{"$f":"E23-G23","v":0},null,null,0,null,0,null,{"$f":"L23-N23","v":0},null,null,0,null,{"$f":"IF(OR(S23=0,S23=0),0,P23/S23)","v":0},null,null,null,null,{"$f":"IF(OR(E23=\"\",G23=\"\",L23=\"\",N23=\"\",S23=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Lump sums on maturity or retirement","*",null,0,null,0,null,0,null,null,0,null,0,null,{"$f":"L24-N24","v":0},null,null,0,null,{"$f":"IF(OR(S24=0,S24=0),0,P24/S24)","v":0},null,null,null,null,"Complete"]
[null,"Surrenders or partial surrenders","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Individual retirement transfer","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Annuity payments","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,"Total",null,null,{"$f":"SUM(E23:E27)","v":0},null,{"$f":"SUM(G23:G27)","v":0},null,{"$f":"SUM(I23:I27)","v":0},null,null,{"$f":"SUM(L23:L27)","v":0},null,{"$f":"SUM(N23:N27)","v":0},null,{"$f":"SUM(P23:P27)","v":0},null,null,{"$f":"SUM(S23:S27)","v":0},null,{"$f":"IF(OR(S29=0,S29=0),0,P29/S29)","v":0}]
[]
[null,"Business transfers-out *",null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(I31=\"\",P31=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Expenses incurred *"]
[]
[null,"  Acquisition commission","*",null,0,null,0,null,{"$f":"E35-G35","v":0},null,null,0,null,0,null,{"$f":"L35-N35","v":0},null,null,0,null,{"$f":"IF(OR(S35=0,S35=0),0,P35/S35)","v":0},null,null,null,null,{"$f":"IF(OR(E35=\"\",G35=\"\",L35=\"\",N35=\"\",S35=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"  Acquisition mgt expenses","*",null,0,null,0,null,0,null,null,0,null,0,null,{"$f":"L36-N36","v":0},null,null,0,null,{"$f":"IF(OR(S36=0,S36=0),0,P36/S36)","v":0},null,null,null,null,"Complete"]
[null,"  Renewal commission","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Renewal mgt expenses","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Investment mgt expenses","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"  One-off expenses","*",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Other expenses","*",null,0,null,0,null,{"$f":"E41-G41","v":0},null,null,0,null,0,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,"Total",null,null,{"$f":"SUM(E35:E41)","v":0},null,{"$f":"SUM(G35:G41)","v":0},null,{"$f":"SUM(I35:I41)","v":0},null,null,{"$f":"SUM(L35:L41)","v":0},null,{"$f":"SUM(N35:N41)","v":0},null,{"$f":"SUM(P35:P41)","v":0},null,null,{"$f":"SUM(S35:S41)","v":0},null,{"$f":"IF(OR(S43=0,S43=0),0,P43/S43)","v":0}]
[]
[null,"Interest payable *",null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,{"$f":"IF(OR(S45=0,S45=0),0,P45/S45)","v":0},null,null,null,null,{"$f":"IF(OR(I45=\"\",P45=\"\",S45=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Taxation *",null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,{"$f":"IF(OR(S47=0,S47=0),0,P47/S47)","v":0},null,null,null,null,{"$f":"IF(OR(I47=\"\",P47=\"\",S47=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Other expenditure *",null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,{"$f":"IF(OR(S49=0,S49=0),0,P49/S49)","v":0},null,null,null,null,{"$f":"IF(OR(I49=\"\",P49=\"\",S49=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total expenditure *",null,null,null,null,null,null,{"$f":"SUM(I29,I31,I43,I45,I47,I49)","v":0},null,null,null,null,null,null,{"$f":"SUM(P29,P31,P43,P45,P47,P49)","v":0},null,null,{"$f":"SUM(S29,S31,S43,S45,S47,S49)","v":0},null,{"$f":"IF(OR(S51=0,S51=0),0,P51/S51)","v":0}]
[]
[null,"Regulatory balance sheet reconciliation"]
[]
[null,"Net assets brought forward","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,{"$f":"IF(OR(S55=0,S55=0),0,P55/S55)","v":0},null,null,null,null,{"$f":"IF(OR(I55=\"\",P55=\"\",S55=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Excess of income over expenditure",null,null,null,null,null,null,{"$f":"I19+I51","v":0},null,null,null,null,null,null,{"$f":"P19+P51","v":0},null,null,{"$f":"S19+S51","v":0},null,{"$f":"IF(OR(S56=0,S56=0),0,P56/S56)","v":0}]
[null,"Increase (decrease) in outstanding claims","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,{"$f":"IF(OR(I57=\"\",P57=\"\",S57=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Increase (decrease) in reinsurance recoverables","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Increase (decrease) in creditors","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Capital injected","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Dividends paid or payable","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Transfers from (to) other funds","*",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,0,null,0,null,null,null,null,"Complete"]
[null,"Adjustments including valuation differences","*",null,null,null,null,null,{"$f":"I65-SUM(I55:I62)","v":0},null,null,null,null,null,null,{"$f":"P65-SUM(P55:P62)","v":0},null,null,{"$f":"S65-SUM(S55:S62)","v":0},null,0]
[]
[null," Net assets carried forward",null,null,null,null,null,null,{"$f":"Reg_NAV","v":0},null,null,null,null,null,null,{"$f":"I65","v":0},null,null,0,null,{"$f":"IF(OR(S65=0,S65=0),0,P65/S65)","v":0},null,null,null,null,{"$f":"IF(OR(S65=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]

{"sheet":"Revenue Account RFF","index":14,"n_rows":70,"n_cols":18,"rows_kept":70,"cut":false,"hidden":false,"merged":[[6,3,6,14],[8,3,8,7],[8,10,8,14],[9,10,10,14],[4,3,4,14]]}
[1,null,null,"Revenue Account RFF"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Ring-Fenced Fund Adjustment'!D4=\"No\",\"Complete\",IF(COUNTIF(R16:R78,\"Incomplete\")>0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,"Type of Ring-fenced Fund"]
[]
[null,"Details of Fund"]
[]
[null,null,null,"Quarter",null,null,null,null,null,null,"YTD"]
[null,null,null,null,null,{"$f":"'Revenue Account Total'!G5","v":"00:00:00"},null,null,null,null,{"$f":"F11","v":"00:00:00"}]
[null,null,null,null,null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[null,null,null,"Gross",null,"Reinsurer's share",null,"Net",null,null,"Gross",null,"Reinsurer's share",null,"Net"]
[null,"Income",null,"'000",null,"'000",null,"'000",null,null,"'000",null,"'000",null,"'000"]
[]
[null,"Written premiums",null,{"$f":"SUM(D16:D17)","v":0},null,{"$f":"SUM(F16:F17)","v":0},null,{"$f":"D15-F15","v":0},null,null,{"$f":"SUM(K16:K17)","v":0},null,{"$f":"SUM(M16:M17)","v":0},null,{"$f":"K15-M15","v":0}]
[null,"Regular premiums",null,0,null,0,null,{"$f":"D16-F16","v":0},null,null,0,null,0,null,{"$f":"K16-M16","v":0},null,null,{"$f":"IF(OR(D16=\"\",F16=\"\",K16=\"\",M16=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Single premiums",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,{"$f":"IF(OR(D17=\"\",F17=\"\",K17=\"\",M17=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Fee income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Business transfers-in",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Investment income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Gains/(losses) on linked and non-linked assets",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Other income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D15,D18:D22)","v":0},null,{"$f":"SUM(F15,F18:F22)","v":0},null,{"$f":"SUM(H15,H18:H22)","v":0},null,null,{"$f":"SUM(K15,K18:K22)","v":0},null,{"$f":"SUM(M15,M18:M22)","v":0},null,{"$f":"SUM(O15,O18:O22)","v":0}]
[]
[null,"Claims incurred"]
[]
[null,"Death or disability payments",null,0,null,0,null,{"$f":"D28-F28","v":0},null,null,0,null,0,null,{"$f":"K28-M28","v":0},null,null,{"$f":"IF(OR(D28=\"\",F28=\"\",K28=\"\",M28=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Lump sums on maturity or retirement",null,0,null,0,null,0,null,null,0,null,0,null,{"$f":"K29-M29","v":0},null,null,"Complete"]
[null,"Surrenders or partial surrenders",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Individual retirement transfer",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"Annuity payments",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D28:D32)","v":0},null,{"$f":"SUM(F28:F32)","v":0},null,{"$f":"SUM(H28:H32)","v":0},null,null,{"$f":"SUM(K28:K32)","v":0},null,{"$f":"SUM(M28:M32)","v":0},null,{"$f":"SUM(O28:O32)","v":0}]
[]
[null,"Business transfers-out",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H36=\"\",O36=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Expenses incurred"]
[]
[null,"  Acquisition commission",null,0,null,0,null,{"$f":"D40-F40","v":0},null,null,0,null,0,null,{"$f":"K40-M40","v":0},null,null,{"$f":"IF(OR(D40=\"\",F40=\"\",K40=\"\",M40=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"  Acquisition mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,{"$f":"K41-M41","v":0},null,null,"Complete"]
[null,"  Renewal commission",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"  Renewal mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"  Investment mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"  One-off expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[null,"  Other expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D40:D46)","v":0},null,{"$f":"SUM(F40:F46)","v":0},null,{"$f":"SUM(H40:H46)","v":0},null,null,{"$f":"SUM(K40:K46)","v":0},null,{"$f":"SUM(M40:M46)","v":0},null,{"$f":"SUM(O40:O46)","v":0}]
[]
[null,"Interest payable",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H50=\"\",O50=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Taxation",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H52=\"\",O52=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Other expenditure",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H54=\"\",O54=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total expenditure",null,null,null,null,null,{"$f":"SUM(H34,H36,H48,H50,H52,H54)","v":0},null,null,null,null,null,null,{"$f":"SUM(O34,O36,O48,O50,O52,O54)","v":0}]
[]
[null,"Regulatory balance sheet reconciliation"]
[]
[null,"Net assets brought forward",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H60=\"\",O60=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Excess of income over expenditure",null,null,null,null,null,{"$f":"H24+H56","v":0},null,null,null,null,null,null,{"$f":"O24+O56","v":0}]
[null,"Increase (decrease) in outstanding claims",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,{"$f":"IF(OR(H62=\"\",O62=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Increase (decrease) in reinsurance recoverables",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,"Complete"]
[null,"Increase (decrease) in creditors",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,"Complete"]
[null,"Capital injected",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,"Complete"]
[null,"Dividends paid or payable",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,"Complete"]
[null,"Transfers from (to) other funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,"Complete"]
[null,"Adjustments including valuation differences",null,null,null,null,null,{"$f":"H70-SUM(H60:H67)","v":0},null,null,null,null,null,null,{"$f":"O70-SUM(O60:O67)","v":0}]
[]
[null," Net assets carried forward",null,null,null,null,null,{"$f":"Reg_NAV","v":0},null,null,null,null,null,null,{"$f":"H70","v":0}]

{"sheet":"Investment Data","index":15,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":false,"merged":[[4,1,4,3],[4,4,4,6],[21,1,21,3],[21,4,21,6]]}
[1,null,null,null,null,"Investment Data"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(J5:J19,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Assets by market value",null,null,"'000"]
[]
[null,null,"  (a) Government bonds",null,null,0,null,null,null,{"$f":"IF(OR(F7=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"  (b) Corporate bonds",null,null,0,null,null,null,{"$f":"IF(OR(F8=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"  (c) Type 1 equity",null,null,0,null,null,null,"Complete"]
[null,null,"  (d) True type 2 equity (see (h))",null,null,0,null,null,null,"Complete"]
[null,null,"  (e) Property ",null,null,0,null,null,null,"Complete"]
[null,null,"  (f)  Cash",null,null,0,null,null,null,"Complete"]
[null,null,"  (g) Other",null,null,0,null,null,null,"Complete"]
[]
[null,null,"  (h) Assumed to be Type 2 equities",null,null,0,null,null,null,{"$f":"IF(OR(F15=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"TOTAL Assets",null,null,{"$f":"SUM(F7:F15)","v":0}]
[]
[null,null,"Check",null,null,{"$f":"IF(F17=Reg_Total_Assets,\"OK\",\"Does not agree Total Assets in Regulatory Balance Sheet\")","v":"OK"}]
[]
[]
[null,"Assets by %",null,null,"%"]
[]
[null,null,"  (a) Government bonds",null,null,{"$f":"IF($F7=0,0,$F7/$F$17)","v":0}]
[null,null,"  (b) Corporate bonds",null,null,{"$f":"IF($F8=0,0,$F8/$F$17)","v":0}]
[null,null,"  (c) Type 1 equity",null,null,0]
[null,null,"  (d) True type 2 equity (see (h))",null,null,0]
[null,null,"  (e) Property ",null,null,0]
[null,null,"  (f) Cash",null,null,0]
[null,null,"  (g) Other",null,null,{"$f":"IF($F13=0,0,$F13/$F$17)","v":0}]
[]
[]
[null,null,"  (h) Assumed to be Type 2 equities",null,null,{"$f":"IF($F15=0,0,$F15/$F$17)","v":0}]
[]
[null,null,"TOTAL ",null,null,{"$f":"SUM(F24:F33)","v":0}]

{"sheet":"Quarterly Industry Statistics","index":16,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":false,"merged":[[1,3,1,4],[6,4,7,4]]}
[1,null,null,"Quarterly Industry Statistics"]
[null,null,null,null,null,null,null,{"$f":"IF(COUNTIF(H13:H27,\"Incomplete\")>0,\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[null,null,null,"Quarter","YTD"]
[]
[null,null,null,{"$f":"'Participant Information'!C12","v":"00:00:00"},{"$f":"D8","v":"00:00:00"}]
[null,"Premium Data ",null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[]
[]
[null,"New Business"]
[null,null,null,"'000","'000"]
[null,"Single premiums ",null,0,0,null,null,{"$f":"IF(OR(D13=\"\",E13=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Regular premiums - NB",null,0,0,null,null,{"$f":"IF(OR(D14=\"\",E14=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Regular premiums - Top up",null,0,0,null,null,"Complete"]
[]
[null,"New Business APE",null,{"$f":"(D13/10)+D14+D15","v":0},{"$f":"(E13/10)+E14+E15","v":0}]
[]
[null,"Other data "]
[null,null,null,null,"'000"]
[null,"Assets under management",null,null,0,null,null,{"$f":"IF(OR(E21=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Full surrenders /maturities",null,null,0,null,null,{"$f":"IF(OR(E22=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Partial surrenders /withdrawals ",null,null,0,null,null,"Complete"]
[null,"Benefit Claims",null,null,0,null,null,"Complete"]
[null,null,null,null,"Number"]
[null,"No of policies - in force",null,null,0,null,null,{"$f":"IF(OR(E26=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"No of policies - NB",null,null,0,null,null,"Complete"]

{"sheet":"Change Analysis","index":17,"n_rows":199,"n_cols":14,"rows_kept":199,"cut":false,"hidden":false,"merged":[[112,6,112,10],[113,6,113,10],[114,6,114,10],[115,6,115,10],[107,8,107,9]]}
[1,null,null,null,"Change Analysis"]
[]
[]
[null,"Tab requiring completion based on return type chosen:",null,null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,{"$f":"IF(E4=\"No\",\"Complete\",IF(COUNTIF(N9:N149,\"Incomplete\")>0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,null,"Movement in Regulatory Balance Sheet",null,"Current Period",null,"Previous Period",null,"Change",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,"%"]
[null,null,"Assets"]
[null,null,"Fixed assets",null,{"$f":"'Regulatory Balance Sheet'!F13","v":0},null,0,null,{"$f":"IF(E9=\"\",\"\",IF(ISERROR(E9/G9),0,E9/G9-1))","v":0},null,null,null,null,{"$f":"IF(OR(G9=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Assets (other than assets held for unit-linked funds)",null,{"$f":"'Regulatory Balance Sheet'!F35","v":0},null,0,null,{"$f":"IF(E10=\"\",\"\",IF(ISERROR(E10/G10),0,E10/G10-1))","v":0},null,null,null,null,{"$f":"IF(OR(G10=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Assets held for unit-linked funds",null,{"$f":"'Regulatory Balance Sheet'!F42","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Mortgages and loans made",null,{"$f":"'Regulatory Balance Sheet'!F50","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Reinsurance recoverables",null,{"$f":"'Regulatory Balance Sheet'!F59","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Other assets",null,{"$f":"'Regulatory Balance Sheet'!F74","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Total assets",null,{"$f":"SUM(E9:E14)","v":0},null,{"$f":"SUM(G9:G14)","v":0},null,0]
[]
[null,null,"Liabilities"]
[null,null,"Best estimate ",null,{"$f":"SUM(E20:E23)","v":0},null,{"$f":"SUM(G20:G23)","v":0},null,{"$f":"IF(E18=\"\",\"\",IF(ISERROR(E18/G18),0,E18/G18-1))","v":0}]
[null,null,"of which:"]
[null,null,"Unit linked component",null,0,null,0,null,{"$f":"IF(E20=\"\",\"\",IF(ISERROR(E20/G20),0,E20/G20-1))","v":0},null,null,null,null,{"$f":"IF(OR(E20=\"\",G20=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Non-linked component ",null,0,null,0,null,{"$f":"IF(E21=\"\",\"\",IF(ISERROR(E21/G21),0,E21/G21-1))","v":0},null,null,null,null,{"$f":"IF(OR(E21=\"\",G21=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Non-Life component (composites only)",null,0,null,0,null,0,null,null,null,null,{"$f":"IF(OR(E22=\"\",G22=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null," (VIF adjustment) ",null,0,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,null,"Risk margin ",null,{"$f":"'Regulatory Balance Sheet'!F98+'Regulatory Balance Sheet'!F89","v":0},null,0,null,{"$f":"IF(E25=\"\",\"\",IF(ISERROR(E25/G25),0,E25/G25-1))","v":0},null,null,null,null,{"$f":"IF(OR(G25=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Other liabilities",null,{"$f":"'Regulatory Balance Sheet'!F116","v":0},null,0,null,{"$f":"IF(E26=\"\",\"\",IF(ISERROR(E26/G26),0,E26/G26-1))","v":0},null,null,null,null,"Complete"]
[null,null,"Total liabilities",null,{"$f":"SUM(E18,E25:E26)","v":0},null,{"$f":"SUM(G18,G25:G26)","v":0},null,0]
[]
[null,null,"Net Assets",null,{"$f":"E15-E27","v":0},null,{"$f":"G15-G27","v":0},null,{"$f":"IF(E29=\"\",\"\",IF(ISERROR(E29/G29),0,E29/G29-1))","v":0}]
[null,null,null,null,{"$f":"IF(E29=Reg_NAV,\"\",\"ERROR DOESN’T AGREE NET ASSETS IN RBS TAB\")","v":""}]
[]
[]
[null,null,"Change in Own Funds*",null,"Current Period",null,"Previous Period",null,"Change",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,"%"]
[]
[null,null,"Share Capital",null,{"$f":"'Regulatory Balance Sheet'!F134","v":0},null,0,null,{"$f":"IF(E36=\"\",\"\",IF(ISERROR(E36/G36),0,E36/G36-1))","v":0},null,null,null,null,{"$f":"IF(OR(G36=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Initial fund",null,{"$f":"'Regulatory Balance Sheet'!F135","v":0},null,0,null,{"$f":"IF(E37=\"\",\"\",IF(ISERROR(E37/G37),0,E37/G37-1))","v":0},null,null,null,null,"Complete"]
[null,null,"Share premium",null,{"$f":"'Regulatory Balance Sheet'!F136","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Retained earnings",null,{"$f":"'Regulatory Balance Sheet'!F137","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Other reserves from accounting balance sheet",null,{"$f":"'Regulatory Balance Sheet'!F138","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Surplus funds",null,{"$f":"'Regulatory Balance Sheet'!F139","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Expected profit in future premiums ('EPIFP') ",null,{"$f":"'Regulatory Balance Sheet'!F140","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Preference Shares",null,{"$f":"'Regulatory Balance Sheet'!F141","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Subordinated liabilities",null,{"$f":"'Regulatory Balance Sheet'!F142","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Approved ancillary own funds",null,{"$f":"'Regulatory Balance Sheet'!F143","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Reconciliation reserve",null,{"$f":"SUM(E48:E51)","v":0},null,{"$f":"SUM(G48:G51)","v":0},null,0]
[null,null,"of which:"]
[null,null,"Adjustment to assets",null,{"$f":"'Regulatory Balance Sheet'!F150","v":0},null,0,null,{"$f":"IF(E48=\"\",\"\",IF(ISERROR(E48/G48),0,E48/G48-1))","v":0},null,null,null,null,{"$f":"IF(OR(G48=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Adjustments to technical provisions",null,{"$f":"'Regulatory Balance Sheet'!F151","v":0},null,0,null,{"$f":"IF(E49=\"\",\"\",IF(ISERROR(E49/G49),0,E49/G49-1))","v":0},null,null,null,null,"Complete"]
[null,null,"EPIFP",null,{"$f":"-E42","v":0},null,{"$f":"-G42","v":0},null,0]
[null,null,"Other",null,{"$f":"'Regulatory Balance Sheet'!F153+'Regulatory Balance Sheet'!F154","v":0},null,0,null,0,null,null,null,null,{"$f":"IF(OR(G51=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Other items not specified above",null,{"$f":"'Regulatory Balance Sheet'!F144","v":0},null,0,null,{"$f":"IF(E53=\"\",\"\",IF(ISERROR(E53/G53),0,E53/G53-1))","v":0},null,null,null,null,{"$f":"IF(OR(G53=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Total",null,{"$f":"SUM(E36:E46,E53)","v":0},null,{"$f":"SUM(G36:G46,G53)","v":0},null,{"$f":"IF(E55=\"\",\"\",IF(ISERROR(E55/G55),0,E55/G55-1))","v":0}]
[]
[null,null,"Total own-funds with no allowance for management actions",null,{"$f":"'SCR Summary'!F52","v":0},null,0,null,{"$f":"IF(E57=\"\",\"\",IF(ISERROR(E57/G57),0,E57/G57-1))","v":0},null,null,null,null,{"$f":"IF(OR(G57=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Impact of management actions on own funds",null,{"$f":"IF(OR(E57=0,E57=\"\"),0,E55/E57-1)","v":0},null,{"$f":"IF(G57=0,0,G55/G57-1)","v":0}]
[]
[]
[null,null,"Change in SCR*",null,"Current Period",null,"Previous Period",null,"Change",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,"%"]
[]
[null,null,"SCRmarket",null,{"$f":"'SCR Summary'!F7","v":0},null,0,null,{"$f":"IF(E65=\"\",\"\",IF(ISERROR(E65/G65),0,E65/G65-1))","v":0},null,null,null,null,{"$f":"IF(OR(G65=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"SCRdefault",null,{"$f":"'SCR Summary'!F8","v":0},null,0,null,{"$f":"IF(E66=\"\",\"\",IF(ISERROR(E66/G66),0,E66/G66-1))","v":0},null,null,null,null,"Complete"]
[null,null,"SCRlife",null,{"$f":"'SCR Summary'!F9","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"SCRhealth",null,{"$f":"'SCR Summary'!F10","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"SCR non-life",null,{"$f":"'SCR Summary'!F11","v":0},null,0,null,0,null,null,null,null,{"$f":"IF(OR(G69=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"SCRintangibles",null,{"$f":"'SCR Summary'!F12","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Diversification",null,{"$f":"'SCR Summary'!F16","v":0},null,0,null,0,null,null,null,null,"Complete"]
[null,null,"BSCR",null,{"$f":"SUM(E65:E71)","v":0},null,{"$f":"SUM(G65:G71)","v":0},null,0]
[null,null,"SCRoperational risk",null,{"$f":"SCR_Op_UL+SCRop_nonUL+SCR_Op_Non_life","v":0},null,0,null,0,null,null,null,null,{"$f":"IF(OR(G73=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Other Adjustments",null,{"$f":"Adj_TP+Adj_DT+Adj_Reg","v":0},null,0,null,0,null,null,null,null,"Complete"]
[]
[null,null,"SCR",null,{"$f":"SCR","v":0},null,0,null,{"$f":"IF(E76=\"\",\"\",IF(ISERROR(E76/G76),0,E76/G76-1))","v":0},null,null,null,null,{"$f":"IF(OR(G76=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Solvency coverage",null,{"$f":"IF(OR(E76=0,E76=\"\"),0,E55/E76)","v":0},null,{"$f":"IF(OR(G76=0,G76=\"\"),0,G55/G76)","v":0},null,{"$f":"IF(E78=\"\",\"\",IF(ISERROR(E78/G78),0,E78/G78-1))","v":0}]
[]
[]
[null,null,"Impact of management actions on SCR*",null,"With MA",null,"No MA",null,"Change",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,"%"]
[]
[null,null,"SCRmarket",null,{"$f":"E65","v":0},null,0,null,{"$f":"IF(E84=\"\",\"\",IF(ISERROR(E84/G84),0,E84/G84-1))","v":0},null,null,null,null,{"$f":"IF(OR(G84=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"SCRdefault",null,0,null,0,null,{"$f":"IF(E85=\"\",\"\",IF(ISERROR(E85/G85),0,E85/G85-1))","v":0},null,null,null,null,"Complete"]
[null,null,"SCRlife",null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,null,"SCRhealth",null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,null,"SCR non-life",null,0,null,0,null,0,null,null,null,null,{"$f":"IF(OR(G88=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"SCRintangibles",null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,null,"Diversification",null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,null,"BSCR",null,0,null,{"$f":"SUM(G84:G90)","v":0},null,0]
[null,null,"SCRoperational risk",null,0,null,0,null,0,null,null,null,null,{"$f":"IF(OR(G92=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"SCR",null,{"$f":"E76","v":0},null,0,null,{"$f":"IF(E94=\"\",\"\",IF(ISERROR(E94/G94),0,E94/G94-1))","v":0},null,null,null,null,{"$f":"IF(OR(G94=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Solvency coverage",null,{"$f":"E78","v":0},null,{"$f":"IF(OR(G94=\"\",G94=0),0,E57/G94)","v":0},null,{"$f":"IF(E96=\"\",\"\",IF(ISERROR(E96/G96),0,E96/G96-1))","v":0}]
[]
[]
[null,null,"Change in MCR*",null,"Current Period",null,"Previous Period",null,"Change",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"},null,{"$f":"\"'000\"","v":"'000"},null,"%"]
[]
[null,null,"MCR",null,{"$f":"MCR_SII","v":3000},null,0,null,{"$f":"IF(E102=\"\",\"\",IF(ISERROR(E102/G102),0,E102/G102-1))","v":0},null,null,null,null,{"$f":"IF(OR(G102=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Own funds eligible to meet MCR",null,{"$f":"'MCR Summary'!F31","v":0},null,0,null,{"$f":"IF(E103=\"\",\"\",IF(ISERROR(E103/G103),0,E103/G103-1))","v":0},null,null,null,null,"Complete"]
[]
[null,null,"MCR coverage",null,{"$f":"IF(OR(E102=\"\",E102=0),\"\",E103/E102)","v":0},null,{"$f":"IF(OR(G102=\"\",G102=0),0,G103/G102)","v":0},null,{"$f":"IF(E105=\"\",\"\",IF(ISERROR(E105/G105),0,E105/G105-1))","v":0}]
[]
[]
[null,null,"Experience, methodology and assumption changes*",null,"Own Funds",null,null,null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"}]
[]
[null,null,"Opening position",null,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E111=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,null,"Total impact of all experience variances",null,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E113=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,null,"Total impact of all assumption changes",null,0,null,null,null,null,null,null,null,null,"Complete"]
[null,null,"Total impact of all methodology changes",null,0,null,null,null,null,null,null,null,null,"Complete"]
[null,null,"Balancing item",null,{"$f":"E118-E111-SUM(E113:E115)","v":0}]
[]
[null,null,"Closing position",null,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(E118=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[]
[null,null,"Detail for experience variances*",null,"Own-Funds",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"}]
[null,null,"List of material changes:"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,"Balancing Item",null,{"$f":"E113-SUM(E124:E142)","v":0}]
[]
[null,null,"Total impact of experience variation",null,{"$f":"SUM(E124:E143)","v":0}]
[]
[]
[null,null,"Detail for assumption changes*",null,"Own-Funds",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"}]
[null,null,"List of material changes:"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,"Balancing Item",null,{"$f":"E114-SUM(E151:E169)","v":0}]
[]
[null,null,"Total impact of assumption changes",null,{"$f":"SUM(E151:E170)","v":0}]
[]
[]
[null,null,"Detail for methodology and model correction changes*",null,"Own-Funds",null,"Commentary"]
[null,null,null,null,{"$f":"\"'000\"","v":"'000"}]
[null,null,"List of material changes:"]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,"Balancing Item",null,{"$f":"E115-SUM(E178:E196)","v":0}]
[]
[null,null,"Total impact of methodology changes",null,{"$f":"SUM(E178:E197)","v":0}]

{"sheet":"Revenue Account Projected","index":18,"n_rows":87,"n_cols":27,"rows_kept":87,"cut":false,"hidden":false,"merged":[[5,3,5,7],[5,10,5,14],[5,17,5,21]]}
[1,null,null,"Revenue Account Projected"]
[]
[]
["Tab requiring completion based on return type chosen:",null,null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D4=\"No\",\"Complete\",IF(COUNTIF(AA13:AA102,\"Incomplete\")>0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,null,null,"Plan+1",null,null,null,null,null,null,"Plan+2",null,null,null,null,null,null,"Plan+3",null,null,null,null,null,null,"Commentary"]
[]
[null,null,null,null,null,{"$f":"YEAR(QIS_YE_Date)+1","v":1901},null,null,null,null,null,null,{"$f":"YEAR(QIS_YE_Date)+2","v":1902},null,null,null,null,null,null,{"$f":"YEAR(QIS_YE_Date)+3","v":1903}]
[null,null,null,"Gross",null,"Reinsurer's share",null,"Net",null,null,"Gross",null,"Reinsurer's share",null,"Net",null,null,"Gross",null,"Reinsurer's share",null,"Net"]
[null,"Income",null,"'000",null,"'000",null,"'000",null,null,"'000",null,"'000",null,"'000",null,null,"'000",null,"'000",null,"'000"]
[]
[null,"Written premiums",null,{"$f":"SUM(D13:D14)","v":0},null,{"$f":"SUM(F13:F14)","v":0},null,{"$f":"D12-F12","v":0},null,null,{"$f":"SUM(K13:K14)","v":0},null,{"$f":"SUM(M13:M14)","v":0},null,{"$f":"K12-M12","v":0},null,null,{"$f":"SUM(R13:R14)","v":0},null,{"$f":"SUM(T13:T14)","v":0},null,{"$f":"R12-T12","v":0}]
[null,"Regular premiums",null,0,null,0,null,{"$f":"D13-F13","v":0},null,null,0,null,0,null,{"$f":"K13-M13","v":0},null,null,0,null,0,null,{"$f":"R13-T13","v":0},null,null,null,null,{"$f":"IF(OR(K13=\"\",M13=\"\",R13=\"\",T13=\"\",D13=\"\",F13=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Single premiums",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,{"$f":"IF(OR(K14=\"\",M14=\"\",R14=\"\",T14=\"\",D14=\"\",F14=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Fee Income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Business transfers-in",null,0,null,0,null,0,null,null,0,null,0,null,{"$f":"K16-M16","v":0},null,null,0,null,0,null,{"$f":"R16-T16","v":0},null,null,null,null,"Complete"]
[null,"Investment income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Gains / (losses) on linked and non-linked assets",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Other income",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D12,D15:D19)","v":0},null,{"$f":"SUM(F12,F15:F19)","v":0},null,{"$f":"SUM(H12,H15:H19)","v":0},null,null,{"$f":"SUM(K12,K15:K19)","v":0},null,{"$f":"SUM(M12,M15:M19)","v":0},null,{"$f":"SUM(O12,O15:O19)","v":0},null,null,{"$f":"SUM(R12,R15:R19)","v":0},null,{"$f":"SUM(T12,T15:T19)","v":0},null,{"$f":"SUM(V12,V15:V19)","v":0}]
[]
[null,"Claims incurred"]
[]
[null,"Death or disability payments",null,0,null,0,null,{"$f":"D25-F25","v":0},null,null,0,null,0,null,{"$f":"K25-M25","v":0},null,null,0,null,0,null,{"$f":"R25-T25","v":0},null,null,null,null,{"$f":"IF(OR(K25=\"\",M25=\"\",R25=\"\",T25=\"\",D25=\"\",F25=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Lump sums on maturity or retirement",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Surrenders or partial surrenders",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Individual retirement transfer",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"Annuity payments",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D25:D29)","v":0},null,{"$f":"SUM(F25:F29)","v":0},null,{"$f":"SUM(H25:H29)","v":0},null,null,{"$f":"SUM(K25:K29)","v":0},null,{"$f":"SUM(M25:M29)","v":0},null,{"$f":"SUM(O25:O29)","v":0},null,null,{"$f":"SUM(R25:R29)","v":0},null,{"$f":"SUM(T25:T29)","v":0},null,{"$f":"SUM(V25:V29)","v":0}]
[]
[null,"Business transfers-out",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H33=\"\",O33=\"\",V33=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Expenses incurred"]
[]
[null,"  Acquisition commission",null,0,null,0,null,{"$f":"D37-F37","v":0},null,null,0,null,0,null,{"$f":"K37-M37","v":0},null,null,0,null,0,null,{"$f":"R37-T37","v":0},null,null,null,null,{"$f":"IF(OR(K37=\"\",M37=\"\",R37=\"\",T37=\"\",D37=\"\",F37=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"  Acquisition mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Renewal commission",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Renewal mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Investment mgt expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"  One-off expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[null,"  Other expenses",null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,0,null,0,null,0,null,null,null,null,"Complete"]
[]
[null,"Total",null,{"$f":"SUM(D37:D43)","v":0},null,{"$f":"SUM(F37:F43)","v":0},null,{"$f":"SUM(H37:H43)","v":0},null,null,{"$f":"SUM(K37:K43)","v":0},null,{"$f":"SUM(M37:M43)","v":0},null,{"$f":"SUM(O37:O43)","v":0},null,null,{"$f":"SUM(R37:R43)","v":0},null,{"$f":"SUM(T37:T43)","v":0},null,{"$f":"SUM(V37:V43)","v":0}]
[]
[null,"Interest payable",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H47=\"\",O47=\"\",V47=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Taxation",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H49=\"\",O49=\"\",V49=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Other expenditure",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H51=\"\",O51=\"\",V51=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Total expenditure",null,null,null,null,null,{"$f":"SUM(H31,H33,H45,H47,H49,H51)","v":0},null,null,null,null,null,null,{"$f":"SUM(O31,O33,O45,O47,O49,O51)","v":0},null,null,null,null,null,null,{"$f":"SUM(V31,V33,V45,V47,V49,V51)","v":0}]
[]
[null,"Balance sheet reconciliation"]
[]
[null,"Net assets brought forward",null,null,null,null,null,{"$f":"'Revenue Account Total'!P65","v":0},null,null,null,null,null,null,{"$f":"H67","v":0},null,null,null,null,null,null,{"$f":"O67","v":0}]
[null,"Excess of income over expenditure",null,null,null,null,null,{"$f":"H21+H53","v":0},null,null,null,null,null,null,{"$f":"O21+O53","v":0},null,null,null,null,null,null,{"$f":"V21+V53","v":0}]
[null,"Increase (decrease) in outstanding claims",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H59=\"\",O59=\"\",V59=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Increase (decrease) in reinsurance recoverables",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H60=\"\",O60=\"\",V60=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Increase (decrease) in creditors",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"Capital injected",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"Dividends paid or payable",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"Transfers from (to) other funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"Adjustments including valuation differences",null,null,null,null,null,{"$f":"H67-SUM(H57:H64)","v":0},null,null,null,null,null,null,{"$f":"O67-SUM(O57:O64)","v":0},null,null,null,null,null,null,{"$f":"V67-SUM(V57:V64)","v":0}]
[]
[null," Net assets carried forward",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H67=\"\",O67=\"\",V67=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[]
[null,"Proj Solvency (incl dividends)"]
[]
[null,"SCR",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H71=\"\",O71=\"\",V71=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"SCR Own-Funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"SCR Ratio",null,null,null,null,null,{"$f":"IF(H71=0,0,H72/H71)","v":0},null,null,null,null,null,null,{"$f":"IF(O71=0,0,O72/O71)","v":0},null,null,null,null,null,null,{"$f":"IF(V71=0,0,V72/V71)","v":0}]
[]
[null,"MCR",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H75=\"\",O75=\"\",V75=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"MCR Own-Funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"MCR Ratio",null,null,null,null,null,{"$f":"IF(H75=0,0,H76/H75)","v":0},null,null,null,null,null,null,{"$f":"IF(O75=0,0,O76/O75)","v":0},null,null,null,null,null,null,{"$f":"IF(V75=0,0,V76/V75)","v":0}]
[]
[null,"Proj Solvency (excl dividends)"]
[]
[null,"SCR",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H81=\"\",O81=\"\",V81=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"SCR Own-Funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"SCR Ratio",null,null,null,null,null,{"$f":"IF(H81=0,0,H82/H81)","v":0},null,null,null,null,null,null,{"$f":"IF(O81=0,0,O82/O81)","v":0},null,null,null,null,null,null,{"$f":"IF(V81=0,0,V82/V81)","v":0}]
[]
[null,"MCR",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,{"$f":"IF(OR(H85=\"\",O85=\"\",V85=\"\",),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"MCR Own-Funds",null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,null,null,0,null,null,null,null,"Complete"]
[null,"MCR Ratio",null,null,null,null,null,{"$f":"IF(H85=0,0,H86/H85)","v":0},null,null,null,null,null,null,{"$f":"IF(O85=0,0,O86/O85)","v":0},null,null,null,null,null,null,{"$f":"IF(V85=0,0,V86/V85)","v":0}]

{"sheet":"Expense Analysis","index":19,"n_rows":8,"n_cols":4,"rows_kept":8,"cut":false,"hidden":false,"merged":[[5,1,5,4]]}
[1,null,null,"Expense Analysis"]
[]
[]
[null,"Tab requiring completion based on return type chosen:",null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"}]
[]
[null,"Expense Apportionment"]
[]
[null,"Please provide a description of the method of apportionment used to determine the breakdown of expenses incurred in the year preceding the valuation date between acquisition and renewal expenses:"]

{"sheet":"Annual Industry Statistics","index":20,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,11,1,12],[1,3,1,4],[1,5,1,6],[1,7,1,8],[1,9,1,10]]}
[1,null,null,"Annual Industry Statistics"]
[]
[]
[null,"Tab requiring completion based on return type chosen:",null,null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"}]
[]
[null,"Annual new business premium data",null,{"$f":"QIS_YE_Date","v":"00:00:00"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E4=\"No\",\"Complete\",IF(COUNTIF(O13:O21,\"Incomplete\")>0,\"Incomplete\",\"Complete\"))","v":"Complete"}]
[]
[null,"New Business Premium - '000",null,"UK","Europe (ex UK)","Hong Kong","Singapore","Asia Other","Middle East","Latin America","Rest of World","Total"]
[]
[null,"Single Premiums"]
[]
[null,"Open architecture",null,0,0,0,0,0,0,0,0,{"$f":"SUM(D13:K13)","v":0},null,null,{"$f":"IF(OR(D13=\"\",E13=\"\",F13=\"\",G13=\"\",H13=\"\",I13=\"\",J13=\"\",K13=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Guided architecture",null,0,0,0,0,0,0,0,0,{"$f":"SUM(D14:K14)","v":0},null,null,{"$f":"IF(OR(D14=\"\",E14=\"\",F14=\"\",G14=\"\",H14=\"\",I14=\"\",J14=\"\",K14=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Total",null,{"$f":"SUM(D13:D14)","v":0},{"$f":"SUM(E13:E14)","v":0},0,0,0,0,0,0,0]
[]
[null,"Regular Premiums"]
[]
[null,"Regular savings",null,0,0,0,0,0,0,0,0,{"$f":"SUM(D19:K19)","v":0},null,null,{"$f":"IF(OR(D19=\"\",E19=\"\",F19=\"\",G19=\"\",H19=\"\",I19=\"\",J19=\"\",K19=\"\"),\"Incomplete\",\"Complete\")","v":"Complete"}]
[null,"Regular protection - unit linked",null,0,0,0,0,0,0,0,0,{"$f":"SUM(D20:K20)","v":0},null,null,"Complete"]
[null,"Regular protection - non linked",null,0,0,0,0,0,0,0,0,{"$f":"SUM(D21:K21)","v":0},null,null,"Complete"]
[null,"Total",null,{"$f":"SUM(D19:D21)","v":0},{"$f":"SUM(E19:E21)","v":0},0,0,0,0,0,0,0]
[]
[null,"Total"]
[]
[null,"Total APE",null,{"$f":"D15/10+D22","v":0},{"$f":"E15/10+E22","v":0},0,0,0,0,0,0,0]

{"sheet":"Reinsurance Contracts","index":21,"n_rows":305,"n_cols":5,"rows_kept":305,"cut":false,"hidden":false,"merged":[[282,1,282,3],[32,1,32,3],[57,1,57,3],[82,1,82,3],[107,1,107,3],[132,1,132,3],[232,1,232,3],[257,1,257,3],[2,1,2,7],[7,1,7,3],[157,1,157,3],[182,1,182,3],[207,1,207,3],[5,1,5,7]]}
[1,null,"Reinsurance Contracts"]
[]
[]
[null,"Tab requiring completion based on return type chosen:",null,null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"}]
[]
[null,"Please provide a detailed description by product of any reinsurance contracts, including finite and financial reinsurance, that are in force at the valuation date."]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]
[]
[]
[null,"Reinsurance Contracts"]
[]
[null,"Product Name(s):"]
[]
[null,"Are you the cedant or the reinsurer?","Reinsurer"]
[]
[null,"What is the name of the reinsurer (or cedent if appropriate)?"]
[]
[null,"Are you connected to the reinsurer (or cedant if appropriate), if so how?"]
[]
[null,"What is the nature and extent of the cover provided under the treaty?"]
[]
[null,"What is the premium payable/receivable in the year preceding the valuation date?"]
[]
[null,"What were the claims payable/receivable in the year preceding the valuation date?"]
[]
[null,"What was the amount deposited at the valuation date in respect of the treaty under the deposit back arrangements?"]
[]
[null,"Please provide details of any commission loan advances (or financing payments having an equivalent effect) and outstanding balances:"]
[]
[null,"If you are the cedant, please provide details of the extent to which provision has been made for any liability to refund any amounts of reinsurance commission in the event of lapses or surrenders of the contract:"]
[]
[null,"Is the treaty open or closed to new business?","Open"]

{"sheet":"Insurance Obligations","index":22,"n_rows":390,"n_cols":18,"rows_kept":390,"cut":false,"hidden":false,"merged":[[388,1,389,1],[388,3,388,5],[388,7,388,9],[388,11,388,14],[388,15,388,17],[322,1,323,1],[322,3,322,5],[322,7,322,9],[322,11,322,14],[322,15,322,17],[355,1,356,1],[355,3,355,5],[355,7,355,9],[355,11,355,14],[355,15,355,17],[256,1,257,1],[256,3,256,5],[256,7,256,9],[256,11,256,14],[256,15,256,17],[289,1,290,1],[289,3,289,5],[289,7,289,9],[289,11,289,14],[289,15,289,17],[190,1,191,1],[190,3,190,5],[190,7,190,9],[190,11,190,14],[190,15,190,17],[223,1,224,1],[223,3,223,5],[223,7,223,9],[223,11,223,14],[223,15,223,17],[124,1,125,1],[124,3,124,5],[124,7,124,9],[124,11,124,14],[124,15,124,17],[157,1,158,1],[157,3,157,5],[157,7,157,9],[157,11,157,14],[157,15,157,17],[5,1,5,17],[91,1,92,1],[91,3,91,5],[91,7,91,9],[91,11,91,14],[91,15,91,17],[58,1,59,1],[58,3,58,5],[58,7,58,9],[58,11,58,14],[58,15,58,17],[25,15,25,17],[25,1,26,1],[25,3,25,5],[25,7,25,9],[25,11,25,14]]}
[1,null,null,null,null,"Insurance Obligations","2020-12-31"]
[]
[]
[null,"Tab requiring completion based on return type chosen:",null,null,null,{"$f":"IF(Control!$E$6=\"Annual\", \"Yes\",\"No\")","v":"No"}]
[null,"Insurers may either complete this tab or include the relevant information within their Actuary's Report required under Regulation 7. Please indicate if the Actuary's Report is providing this infomation:",null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,"The information required in the table below need not be provided for contract types where the technical provisions at the valuation date in respect of that contract type represent less than 1% of the total technical provisions unless the insurer considers that the disclosure to the Authority is required."]
[]
[null,"Contract Type",null,"Premium and Benefit Description*",null,"Charges*",null,"Options and Guarantees*",null,"Other*"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Product Information"]
[]
[null,"Contract Type"]
[]
[null,"Product Name",null,"Number of Policies",null,null,null,"Annualised premium payable",null,null,null,"Benefits currently guaranteed on death",null,null,null,"Benefits currently guaranteed at maturity"]
[null,null,null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded",null,"Direct Business and Reinsurance Accepted",null,"Reinsurance Ceded"]

{"sheet":"Data","index":23,"n_rows":162,"n_cols":17,"rows_kept":162,"cut":false,"hidden":false,"merged":[[95,1,95,2],[96,1,96,2],[97,1,97,2]]}
[1]
[]
[null,null,null,null,"Data"]
[null,"Currency","Currency Code"]
[null,"United Kingdom Pound","GBP"]
[null,"United States Dollar","USD"]
[null,"Euro","EUR"]
[null,"Sweden Krona","SEK"]
[null,"Afghanistan Afghani","AFN"]
[null,"Albania Lek","ALL"]
[null,"Algeria Dinar","DZD"]
[null,"Argentina Peso","ARS"]
[null,"Australia Dollar","AUD"]
[null,"Bahamas Dollar","BSD"]
[null,"Bahrain Dinar","BHD"]
[null,"Bangladesh Taka","BDT"]
[null,"Barbados Dollar","BBD"]
[null,"Bermuda Dollar","BMD"]
[null,"Brazil Real","BRL"]
[null,"Bulgaria Lev","BGN"]
[null,"Canada Dollar","CAD"]
[null,"Chile Peso","CLP"]
[null,"China Yuan Renminbi","CNY"]
[null,"Colombia Peso","COP"]
[null,"Costa Rica Colon","CRC"]
[null,"Croatia Kuna","HRK"]
[null,"Czech Republic Koruna","CZK"]
[null,"Denmark Krone","DKK"]
[null,"Dominican Republic Peso","DOP"]
[null,"Egypt Pound","EGP"]
[null,"Fiji Dollar","FJD"]
[null,"Hong Kong Dollar","HKD"]
[null,"Hungary Forint","HUF"]
[null,"Iceland Krona","ISK"]
[null,"India Rupee","INR"]
[null,"Indonesia Rupiah","IDR"]
[null,"Iran Rial","IRR"]
[null,"Iraq Dinar","IQD"]
[null,"Israel Shekel","ILS"]
[null,"Jamaica Dollar","JMD"]
[null,"Japan Yen","JPY"]
[null,"Jordan Dinar","JOD"]
[null,"Kenya Shilling","KES"]
[null,"Kuwait Dinar","KWD"]
[null,"Lebanon Pounds","LBP"]
[null,"Lituania Lita","LTL"]
[null,"Malaysia Ringgit","MYR"]
[null,"Mauritius Rupee","MUR"]
[null,"Mexico Peso","MXN"]
[null,"Morocco Dirham","MAD"]
[null,"New Zealand Dollar","NZD"]
[null,"Norway Krone","NOK"]
[null,"Oman Rial","OMR"]
[null,"Pakistan Rupee","PKR"]
[null,"Peru Nuevo Sol","PEN"]
[null,"Philippines Peso","PHP"]
[null,"Poland Zloty","PLN"]
[null,"Qatar Riyal","QAR"]
[null,"Romania New Leu","RON"]
[null,"Russia Ruble","RUB"]
[null,"Saudi Arabia Riyal","SAR"]
[null,"Singapore Dollar","SGD"]
[null,"South Africa Rand","ZAR"]
[null,"South Korea Won","KRW"]
[null,"Sri Lanka Rupee","LKR"]
[null,"Sudan Pound","SDG"]
[null,"Switzerland Franc","CHF"]
[null,"Taiwan New Dollar","TWD"]
[null,"Thailand Baht","THB"]
[null,"Trinidad and Tobago Dollar","TTD"]
[null,"Tunisia Dinar","TND"]
[null,"Turkey Lira","TRY"]
[null,"United Arab Emirates Dirham","AED"]
[null,"Venezuela Bolivares Fuertes","VEF"]
[null,"Vietnam Dong","VND"]
[null,"Zambia Kwacha","ZMK"]
[]
[]
[]
[null,"Corr                                    * ","Market","Default","Life","Health","Non-Life"]
[null,"Market",1,{"$f":"TRANSPOSE(C82:C85)","v":0.25},0.25,0.25,{"$f":"TRANSPOSE(F82:F85)","v":0.25}]
[null,"Default",0.25,1,{"$f":"TRANSPOSE(D83:D$85)","v":0.25},0.25,0.5]
[null,"Life",0.25,0.25,1,0.25,0]
[null,"Health",0.25,0.25,0.25,1,0]
[null,"Non-Life",0.25,0.5,0,0,1]
[]
[]
[null,"MarketCorr                       * ","Interest","Equity","Property","Currency","Spread","Concentration"]
[null,"Interest",1,{"$f":"TRANSPOSE(C90:C$94)","v":0},0,0.25,0,0]
[null,"Equity",{"$f":"A","v":0},1,{"$f":"TRANSPOSE(D91:D$94)","v":0.75},0.25,0.75,0]
[null,"Property",{"$f":"A","v":0},0.75,1,{"$f":"TRANSPOSE(E92:E$94)","v":0.25},0.5,0]
[null,"Currency",0.25,0.25,0.25,1,{"$f":"TRANSPOSE(F93:F$94)","v":0.25},0]
[null,"Spread",{"$f":"A","v":0},0.75,0.5,0.25,1,{"$f":"TRANSPOSE(G94:G$94)","v":0}]
[null,"Concentration",0,0,0,0,0,1]
[]
[null,"Selection of A in MarketCorr             *   ",null,"A"]
[null,"Marketinterest = MarketinterestUp",null,0]
[null,"Marketinterest = MarketinterestDown",null,0.5]
[null,null,"Selected:",{"$f":"IF(nMkt_Int=nMkt_Int_Up,$D$97,$D$98)","v":0}]
[]
[]
[null,"EqVolUpCorr                      *","VolatilityUp","Level"]
[null,"VolatilityUp",1,{"$f":"$C$104","v":0.75}]
[null,"Level",0.75,1]
[]
[]
[null,"EqVolDownCorr                *","Level","VolatilityDown"]
[null,"Level",1,{"$f":"$C$109","v":0}]
[null,"VolatilityDown",0,1]
[]
[]
[null,"EqCorr                                *","Type 1","Type 2"]
[null,"Type 1",1,{"$f":"$C$114","v":0.75}]
[null,"Type 2",0.75,1]
[]
[]
[null,"CurrencyCorr                    *",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15]
[null,"CurrGroup1",1,{"$f":"TRANSPOSE(C119:C$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup2",0.5,1,{"$f":"TRANSPOSE(D120:D$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup3",0.5,0.5,1,{"$f":"TRANSPOSE(E121:E$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup4",0.5,0.5,0.5,1,{"$f":"TRANSPOSE(F122:F$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup5",0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(G123:G$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup6",0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(H124:H$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup7",0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(I125:I$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup8",0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(J126:J$132)","v":0.5},0.5,0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup9",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(K127:K$132)","v":0.5},0.5,0.5,0.5,0.5,0.5]
[null,"CurrGroup10",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(L128:L$132)","v":0.5},0.5,0.5,0.5,0.5]
[null,"CurrGroup11",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(M129:M$132)","v":0.5},0.5,0.5,0.5]
[null,"CurrGroup12",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(N130:N$132)","v":0.5},0.5,0.5]
[null,"CurrGroup13",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(O131:O$132)","v":0.5},0.5]
[null,"CurrGroup14",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1,{"$f":"TRANSPOSE(P132:P$132)","v":0.5}]
[null,"CurrGroup15",0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,1]
[]
[]
[null,"DefaultCorr                       *","Type 1","Type 2"]
[null,"Type 1",1,{"$f":"$C$137","v":0.75}]
[null,"Type 2",0.75,1]
[]
[]
[null,"LifeCorr                              *","Mortality","Longevity","Disability","Lapse","Expenses","Revision","CAT"]
[null,"Mortality",1,{"$f":"TRANSPOSE(C142:C$147)","v":-0.25},0.25,0,0.25,0,0.25]
[null,"Longevity",-0.25,1,{"$f":"TRANSPOSE(D143:D$147)","v":0},0.25,0.25,0.25,0]
[null,"Disability",0.25,0,1,{"$f":"TRANSPOSE(E144:E$147)","v":0},0.5,0,0.25]
[null,"Lapse",0,0.25,0,1,{"$f":"TRANSPOSE(F145:F$147)","v":0.5},0,0.25]
[null,"Expenses",0.25,0.25,0.5,0.5,1,{"$f":"TRANSPOSE(G146:G$147)","v":0.5},0.25]
[null,"Revision",0,0.25,0,0,0.5,1,{"$f":"TRANSPOSE(H147:H$147)","v":0}]
[null,"CAT",0.25,0,0.25,0.25,0.25,0,1]
[]
[]
[null,"HealthCorr                         ","Mortality","Longevity","Disability","Lapse","Expenses","Revision"]
[null,"Mortality",1,{"$f":"TRANSPOSE($C$152:$C$156)","v":-0.25},0.25,0,0.25,0]
[null,"Longevity",-0.25,1,{"$f":"TRANSPOSE($D$153:$D$156)","v":0},0.25,0.25,0.25]
[null,"Disability",0.25,0,1,{"$f":"TRANSPOSE($E$154:$E$156)","v":0},0.5,0]
[null,"Lapse",0,0.25,0,1,{"$f":"TRANSPOSE($F$155:$F$156)","v":0.5},0]
[null,"Expenses",0.25,0.25,0.5,0.5,1,{"$f":"TRANSPOSE(G156:G156)","v":0.5}]
[null,"Revision",0,0.25,0,0,0.5,1]
[]
[]
[null,"HealthCorr                        ","HealthSLT","HealthNSLT","HealthCAT"]
[null,"HealthSLT",1,{"$f":"TRANSPOSE(C161:C162)","v":0.5},0.25]
[null,"HealthNSLT",0.5,1,{"$f":"TRANSPOSE(D162)","v":0.25}]
[null,"HealthCAT",0.25,0.25,1]

{"sheet":"Raw Data","index":24,"n_rows":314,"n_cols":9,"rows_kept":314,"cut":false,"hidden":false,"merged":[]}
[1,null,null,"Raw Data"]
[]
[]
[null,"Sheet","Result",1,2,3,4,5,"Total"]
[]
[null,"Operational Risk Sheet","Current valuation date - Total  expenses for UL business",null,null,null,null,null,{"$f":"SUM(D6:H6)","v":0}]
[null,"Operational Risk Sheet","Current valuation date - Earned premiums ",null,null,null,null,null,{"$f":"SUM(D7:H7)","v":0}]
[null,"Operational Risk Sheet","Previous valuation date - Earned premiums ",null,null,null,null,null,0]
[null,"Operational Risk Sheet","Technical Provisions",null,null,null,null,null,0]
[]
[null,"Economic Balance Sheet","Goodwill - Acc.",null,null,null,null,null,{"$f":"SUM(D11:H11)","v":0}]
[null,"Economic Balance Sheet","Other Intangible assets - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other Intangible assets - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (own use) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (own use) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (not own use) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Property (not own use) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Participations - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Participations - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Listed equities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Listed equities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Unlisted equities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Unlisted equities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Govt. & multilaterals - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Govt. & multilaterals - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (ABS) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (ABS) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (other) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Bonds - Corp. (other) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Structured Notes - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Structured Notes - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Investment funds - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Investment funds - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Futures - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Futures - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Call Options - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Call Options - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Put Options - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Put Options - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Swaps - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Swaps - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Forwards - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Forwards - Reg.",null,null,null,null,null,{"$f":"SUM(D43:H43)","v":0}]
[null,"Economic Balance Sheet","Long term bank deposits - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Long term bank deposits - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other investments - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other investments - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Assets held for UL funds - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Assets held for UL funds - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits to cedants - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits to cedants - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncollateralised loans made - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncollateralised loans made - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Collateralised loans made - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Collateralised loans made - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Loans on policies - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Loans on policies - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Reins. recoverables - Life excl. UL - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Reins. recoverables - Life excl. UL - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other reinsurance recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other reinsurance recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","SPV recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","SPV recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Intermediaries recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Intermediaries recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance recoverables - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance recoverables - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Deferred acquisition costs - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Receivables (trade) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Receivables (trade) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pension benefit surplus - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pension benefit surplus - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash - Acc.",null,null,null,null,null,{"$f":"SUM(D75:H75)","v":0}]
[null,"Economic Balance Sheet","Cash - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Short term bank deposits - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Short term bank deposits - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Called but unpaid capital - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Called but unpaid capital - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other assets - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Other assets - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - Whole TP - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - BEP VGB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - BEP VDB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life excl. UL - RM - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - Whole TP - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - BEP VGB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - BEP VDB - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Life UL - RM - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits from reinsurers - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Cash deposits from reinsurers - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance accounts payable - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Insurance accounts payable - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Derivatives - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Derivatives - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Provisions other than TPs  - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Provisions other than TPs  - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Owed to credit institutions - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Owed to credit institutions - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Financial liabs - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Financial liabs - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Payables (trade, not insurance) - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Payables (trade, not insurance) - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pensions benefit obligations - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Pensions benefit obligations - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Uncalled investments - Acc.",null,null,null,null,null,{"$f":"SUM(D107:H107)","v":0}]
[null,"Economic Balance Sheet","Uncalled investments - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Contingent liabilities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Contingent liabilities - Reg.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Any other liabilities - Acc.",null,null,null,null,null,0]
[null,"Economic Balance Sheet","Any other liabilities - Reg.",null,null,null,null,null,0]
[]
[null,"Market Risk","Interest Rate Risk - Up - Assets",null,null,null,null,null,{"$f":"SUM(D114:H114)","v":0}]
[null,"Market Risk","Interest Rate Risk - Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Assets",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Interest Rate Risk - Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolUp - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - Level - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 1 - VolDown - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolUp - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - Level - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Assets",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Equity Risk - Type 2 - VolDown - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Assets",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Property Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 1 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 1 - Liabilities - VDB",null,null,null,null,null,{"$f":"SUM(D146:H146)","v":0}]
[null,"Market Risk","Currency Risk - Up - Group 2 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 2 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 2 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 2 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 3 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 3 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 4 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 4 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 5 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 5 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 6 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 6 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 7 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 7 - Liabilities - VGB",null,null,null,null,null,{"$f":"SUM(D178:H178)","v":0}]
[null,"Market Risk","Currency Risk - Up - Group 7 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 7 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 8 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 8 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 9 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 9 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 10 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 10 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 11 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 11 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 12 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 12 - Assets",null,null,null,null,null,{"$f":"SUM(D210:H210)","v":0}]
[null,"Market Risk","Currency Risk - Down - Group 12 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 12 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 13 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 13 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 14 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 14 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Up - Group 15 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Down - Group 15 - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Assets",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Currency Risk - Simplification - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Bonds - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Securitisations - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Up - Liabilities - VDB",null,null,null,null,null,{"$f":"SUM(D242:H242)","v":0}]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Assets",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Spread Risk - Credit Derivatives - Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Assets",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Market Risk","Concentration Risk - Liabilities - VDB",null,null,null,null,null,0]
[]
[null,"Life Underwriting Risk","Mortality Risk - Assets",null,null,null,null,null,{"$f":"SUM(D250:H250)","v":0}]
[null,"Life Underwriting Risk","Mortality Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mortality Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Longevity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Disability Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Morbidity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Lapse Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Mass Lapse Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Expense Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Revision Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Assets",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Life Underwriting Risk","Catastrophe Risk - Liabilities - VDB",null,null,null,null,null,0]
[]
[null,"Health Underwriting Risk","Mortality Risk - Assets",null,null,null,null,null,{"$f":"SUM(D281:H281)","v":0}]
[null,"Health Underwriting Risk","Mortality Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mortality Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Longevity Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Medical Expense Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Income Protection Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Down - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Lapse Up - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Mass Lapse Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Expense Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Assets",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Liabilities - VGB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Revision Risk - Liabilities - VDB",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health Catastrophe Risk - Capital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health Catastrophe Risk - nCapital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health NSLT Risk - Capital",null,null,null,null,null,0]
[null,"Health Underwriting Risk","Health NSLT Risk - nCapital",null,null,null,null,null,0]

{"sheet":"Validation","index":25,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Sheet","Area of Sheet/s","Pass/Fail","Overall Pass/Fail","Return Version Number","Return Type & Name"]
[null,null,null,{"$f":"IF('Participant Information'!G9=\"Incomplete\",\"FAIL\",\"PASS\")","v":"FAIL"},{"$f":"'Participant Information'!E10","v":"V0.03"},{"$f":"VLOOKUP(E6&\"_\"&Control!E6,$D$10:$H$17,5,0)","v":"Prudential - Quarterly Return - Life 1, 2, 10 & 12"}]
[]
[]
[]
[null,null,null,"Return Class of template","LT"]
[null,null,null,"New Filename",{"$f":"IF(OR('Participant Information'!$C$11=\"\",'Participant Information'!$E$12=\"\",$D$2=\"FAIL\"),\"\",Control!E7&\"_\"&E6&\"_V\"&RIGHT(E2,2)&\"_\"&LEFT(VLOOKUP(E6&\"_\"&Control!E6,$D$10:$E$17,2,0),1)&TEXT('Participant Information'!$E$12,\"yyyymmdd\")&\".xlsx\")","v":""}]
[]
[null,null,null,"Key","Frequency","Atlas return name","Atlas return type","Return Type & Name"]
[null,null,null,"NLT-C13_Annual","Annual","Annual Return - Non-Life Class 13","Prudential",{"$f":"G10&\" - \"&F10","v":"Prudential - Annual Return - Non-Life Class 13"}]
[null,null,null,"NLT-C13_Biannual","Biannual","Biannual Return - Non-Life Class 13","Prudential",{"$f":"G11&\" - \"&F11","v":"Prudential - Biannual Return - Non-Life Class 13"}]
[null,null,null,"NLT-C3-9&11_Annual","Annual","Annual Return - Non-Life Class 3-9 & 11","Prudential","Prudential - Annual Return - Non-Life Class 3-9 & 11"]
[null,null,null,"NLT-C3-9&11_Quarterly","Quarterly","Quarterly Return - Non-Life Class 3-9 & 11","Prudential","Prudential - Quarterly Return - Non-Life Class 3-9 & 11"]
[null,null,null,"NLT-C12_Annual","Annual","Annual Return - Non-Life Class 12","Prudential","Prudential - Annual Return - Non-Life Class 12"]
[null,null,null,"NLT-C12_Biannual","Biannual","Biannual Return - Non-Life Class 12","Prudential","Prudential - Biannual Return - Non-Life Class 12"]
[null,null,null,"LT_Annual","Annual","Quarterly Return - Life 1, 2, 10 & 12","Prudential","Prudential - Quarterly Return - Life 1, 2, 10 & 12"]
[null,null,null,"LT_Quarterly","Quarterly","Quarterly Return - Life 1, 2, 10 & 12","Prudential","Prudential - Quarterly Return - Life 1, 2, 10 & 12"]