{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Disclaimer","Input","Output","Guidance On Input Data","Calculations","Model Factors","Output Generation","Disclaimer "],"not_rendered":{"charts":4,"images":4,"macros":1,"external_links":1,"defined_names":105,"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":"Disclaimer","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Please Agree to the Disclaimer before you proceed to the model"]
[]
[]
[]
[]
[]
[]
[]
[null,"IMPORTANT — READ THESE TERMS CAREFULLY BEFORE ACCEPTING THIS AGREEMENT AND ACCESSING AND USING THE PROGRAM (AS DEFINED BELOW). BY CLICKING AND ACCEPTING THIS AGREEMENT AND ACCESSING AND USING THE PROGRAM, YOU ACKNOWLEDGE THAT YOU HAVE READ THIS AGREEMENT, THAT YOU UNDERSTAND IT AND THAT YOU AGREE TO BE BOUND BY ITS TERMS AND IF LICENSEE (AS DEFINED BELOW) IS A LEGAL ENTITY, YOU HAVE THE AUTHORITY TO AGREE TO THESE TERMS AND ACCEPT THE AGREEMENT ON BEHALF OF SUCH LEGAL ENTITY. IF YOU DO NOT AGREE, PROMPTLY EXIT THIS PAGE WITHOUT CLICKING AND ACCEPTING THE AGREEMENT OR ACCESSING OR USING THE PROGRAM.\n\nFitch Ratings, Inc. Fitch \"Prism\" FBM Model Agreement\n\nFITCH RATINGS, INC.\nThis Agreement is a legal agreement between you and, where you are an employee of a legal entity, that legal entity (each of whom hereinafter being the \"Licensee\") and Fitch Ratings, Inc., a Delaware corporation whose corporate headquarters are at 33 Whitehall Street New York, NY 10004 USA (\"Fitch\"), and is for use of Fitch's \"Prism\" FBM Model (the \"Model\"). The Model is accompanied with access to proprietary programs held in excel format, data and databases, as well as any accompanying manuals, applicable documentation or user guides (together with the Model, the \"Program\") set forth on the Fitch Website (as defined below), all of which are confidential to Fitch and/or its licensors and provided to or accessible by Licensee solely for Licensee's internal business use under the terms of this Agreement.\nIT IS AGREED as follows: \n\n1 SCOPE OF THE AGREEMENT\n1.1 Fitch has provided Licensee with appropriate access to allow Licensee to access and use the Program as downloaded from www.fitchratings.com (the \"Fitch Website\"). Such access rights are provided for a period expiring on the earliest of (a) the termination of Licensee's subscription to the Fitch Website, (b) 12 months after the date of such download and (c) the date on which a new version of the Program is available to download on the Fitch Website as set forth at Section 2.6 (the \"License Period\"). Notwithstanding the foregoing, Fitch may in its sole discretion design the Program to cease functioning automatically on a certain date, or otherwise terminate the usability of the Program. \n1.2 Fitch hereby grants and Licensee hereby accepts, both subject to the terms of this Agreement, a personal, non-exclusive, non-transferable, revocable, limited license (the \"License\") to use the Program solely for its internal business use and strictly in accordance with the provisions of this Agreement. All rights in or to the Program not specifically granted to Licensee under the provisions of this Agreement are retained by Fitch and/or its licensors. During the License Period, Licensee will maintain a list of all end users of the Program and provide a copy of such list to Fitch upon request.\n\n2 LICENSE TERMS AND CONDITIONS\n2.1 Each component part of the Program, including any and all data and databases a part of, and documentation relating to, the Program, and any changes, modifications, revisions, improvements or updates thereto, or derivatives thereof (collectively, the \"Changes\"), are the proprietary property of Fitch and/or its licensors, and if made available to Licensee, are furnished to Licensee as part of the Program under the License for the term of the License Period solely for Licensee's own internal business use. Reproduction or retransmission, in whole or in part, by Licensee of the Program is strictly prohibited. For purposes of this Agreement, all Changes to the Program are included in the defined term \"Program\".\n2.2 Licensee acknowledges and agrees that Licensee shall (i) only download the Program to one computer (the \"Program Computer\"), which shall be under the exclusive control of Licensee, and (ii) provide password restricted access to and use of the Program on the Program Computer solely to Licensee and its employees who need to have access to and use of the Program as part of their services to and for Licensee. Upon Licensee's request and Fitch's prior written consent, Fitch may, in its sole discretion, permit Licensee to download the Program to additional computers under Licensee's exclusive control.\n2.3 Except (i) as may be specifically permitted under the provisions of this Agreement, (ii) for ordinary and usual caching by Licensee's computer and/or server, or (iii) with Fitch's prior written consent, no portion of the Program may be copied, in whole or in part by Licensee. Neither Licensee nor anyone acting for or on behalf of Licensee shall: (a) change, modify, reverse compile, make alterations, disassemble or otherwise reverse engineer the Program or any portion thereof; or (b) otherwise copy all or any portion of any database accessible through or a part of the Program.\n2.4 Licensee acknowledges and agrees that: (a) the Program and portions of associated documentation, concepts, ideas, systems, formats, lay-outs or processes are proprietary and confidential to Fitch and/or Fitch's licensors; (b) the Program and all components and any applicable rights in patents, copyrights and trade secrets of or related thereto, are owned by and remain in, Fitch and/or its licensors; and (c) Licensee shall not publicly disclose or use the Program, except in strict compliance with this Agreement and applicable documentation and instructions. Furthermore, Licensee shall not do anything inconsistent with or contrary to Fitch's and/or its licensors' title to and ownership of the Program.\n2.5 Licensee represents and warrants to Fitch that (a) the end user accessing and downloading the Program has the authority and power on behalf of Licensee to enter into and comply with Licensee's obligations under this Agreement, (b) this Agreement is binding on Licensee, and (c) the restrictions placed upon Licensee by this Agreement are reasonable and necessary. Licensee indemnifies and agrees to hold Fitch harmless from and against any and all losses, claims, damages and expenses including, but not limited to, attorneys' and experts' fees related to or which result from Licensee's breach of this Agreement, Licensee's use or disclosure of the Program, the results obtained by Licensee from its use of the Program or Licensee's decisions or actions making use of or involving such results, or any action by any of Licensee's clients or customers relating to the Program or Licensee's use of results therefrom.\n2.6 Fitch intends to periodically revise or update the Program or any elements of it.  Fitch will not, and assumes no responsibility to, inform the Licensee of any such revisions or updates, and it is the responsibility of the Licensee to ensure that it is using the latest Program or part thereof by visiting the Fitch Website. FITCH ACCEPTS NO RESPONSIBILITY OR LIABILITY WITH RESPECT TO LICENSEE'S USE OF A NON-CURRENT PROGRAM. \n\n3 TERMINATION\n3.1 Fitch may terminate this Agreement and Licensee's use of the Program at any time without notice, with or without cause by Licensee. Promptly after a termination of this Agreement, regardless of the reason for such termination, Licensee shall cease all use of the Program and Licensee shall delete the Program and all parts thereof from Licensee's computer(s). If requested by Fitch, Licensee shall certify such return and/or destruction of the Program to Fitch in writing.\n3.2 Sections 2 through 5 will survive termination of this Agreement.\n\n4 DISCLAIMER OF WARRANTIES AND REPRESENTATIONS; LIMITATION OF LIABILITY\n4.1 LICENSEE ACKNOWLEDGES AND AGREES THAT THE PROGRAM AND ITS COMPONENTS ARE PROVIDED SOLELY FOR LICENSEE'S INTERNAL BUSINESS USAGE ON AN \"AS-IS\" BASIS, THAT THE PROGRAM AND ITS DATA AND DATABASES MAY CONTAIN ERRORS AND DEFECTS AND THAT FITCH HAS NOT MADE ANY REPRESENTATIONS OR WARRANTIES REGARDING THE ACCURACY, PERFORMANCE OR RELIABILITY OF THE PROGRAM, OR ANY COMPONENTS THEREOF, OR LICENSEE'S USE OR ACCESS THEREOF OR THERETO OR ANY INFORMATION OR DATA LICENSEE OBTAINS FROM THE USE OF SUCH PROGRAM. FITCH DOES NOT REPRESENT OR WARRANT THAT THE PROGRAM, ITS COMPONENTS, ITS DATA, INFORMATION, CONTENT OR OTHER MATERIAL WILL MEET LICENSEE'S REQUIREMENTS, THAT THE OPERATION OF ANY DATABASE, MATERIAL OR OTHER PRODUCT, OR ANY THIRD PARTY SERVICES, PROGRAMS, SYSTEMS OR DATA USED WITH OR THROUGH THE PROGRAM OR PROVIDED THEREWITH BY FITCH, WILL BE UNINTERRUPTED OR FREE FROM ERRORS, BUGS OR SOFTWARE VIRUSES (INCLUDING BUT NOT LIMITED TO WORMS, TROJAN HORSES, CANCERS OR OTHER HARMFUL COMPONENTS (COLLECTIVELY, \"VIRUSES\")) OR THAT ANY DEFECTS IN SUCH PROGRAM, INFORMATION, SERVICES, SYSTEMS, DATABASES OR MATERIALS WILL BE OR CAN BE CORRECTED. FITCH DISCLAIMS ALL IMPLIED WARRANTIES INCLUDING, BUT NOT LIMITED TO THE IMPLIED WARRANTIES OF MERCHANTABILITY, SUITABILITY AND FITNESS FOR A PARTICULAR PURPOSE, AS WELL AS NON-INFRINGEMENT.\n4.2 THE PROGRAM MAY BE ONE COMPONENT USED BY FITCH TO ASSIGN A RATING OR DETERMINE A RATING OUTLOOK, BUT DOES NOT ITSELF ESTABLISH A RATING AND SHOULD NOT BE RELIED ON FOR THAT PURPOSE. OUTPUT FROM THE PROGRAM OBTAINED BY THE LICENSEE MAY VARY FROM RESULTS OBTAINED BY FITCH BASED ON DIFFERENCES IN USER DATA AND INPUT. \n4.3 THE PROGRAM IS DESIGNED TO PROVIDE EXPERIENCED LICENSEES WITH A STARTING POINT FOR THEIR FINANCIAL MODELLING. ALL ASSUMPTIONS AND FORMULAE SHOULD BE REVIEWED BY THE LICENSEE BEFORE USE AS THEY MAY NOT REFLECT THE ASSUMPTIONS AND FORMULAE THAT THE LICENSEE WOULD HAVE CHOSEN TO USE, AND OUTPUTS SHOULD BE CHECKED FOR MECHANICAL ACCURACY AND REASONABLENESS.  THE PROGRAM USES FITCH’S OWN DEFINITIONS OF FINANCIAL TERMS, FOR EXAMPLE EBITDA, DEBT OR FREE CASHFLOW, WHICH DEFINTIONS MAY DIFFER FROM THE LICENSEE’S DEFINITIONS.  \n4.4 FITCH DOES NOT PROVIDE INVESTMENT ADVICE OF ANY SORT. FITCH IS NOT RESPONSIBLE FOR ANY UNDERWRITING, CREDIT LOAN, PURCHASE, STRATEGIC OR INVESTMENT DECISIONS. IN LICENSING THIS PROGRAM TO YOU, FITCH IS NOT MAKING ANY RECOMMENDATION OR SUGGESTION, DIRECTLY OR INDIRECTLY TO YOU OR ANY OTHER PERSON, TO BUY, SELL, MAKE OR HOLD ANY INVESTMENT, LOAN OR SECURITY OR COMMENTING ON THE SUITABILITY OF ANY INVESTMENT, LOAN OR SECURITY FOR LICENSEE OR OF UNDERTAKING ANY INVESTMENT STRATEGY WITH RESPECT TO ANY INVESTMENT, LOAN OR SECURITY OR ANY ISSUER. FITCH IS NOT LICENSEE'S ADVISOR AND IS NOT PROVIDING TO LICENSEE OR ANY OTHER PERSON ANY INVESTMENT OR FINANCIAL ADVICE.\n4.5 AS NO FEE IS BEING CHARGED FOR ACCESS TO AND USE OF THE PROGRAM, THE LICENSEE AGREES THAT, SUBJECT TO SECTION 4.6: \n(a)  NEITHER FITCH OR ANY OF ITS LICENSORS SHALL HAVE ANY LIABILITY IN CONTRACT, STATUTE, TORT (SUCH AS NEGLIGENCE) OR OTHERWISE IN RELATION TO THIS AGREEMENT, THE PROGRAM OR THE USE OF THE PROGRAM BY THE LICENSEE;\n(b)  IN NO EVENT SHALL FITCH AND/OR ITS LICENSORS BE LIABLE FOR: (A) CONSEQUENTIAL, SPECIAL, INDIRECT, INCIDENTAL, PUNITIVE OR EXEMPLARY LOSS, DAMAGE OR EXPENSE OF ANY KIND, WHETHER CAUSED BY CONTRACTUAL BREACH, NEGLIGENCE OR OTHERWISE, EVEN IF KNOWN TO FITCH OR SUCH LICENSORS; (B) DAMAGES RESULTING FROM ERRORS IN THE PROGRAM, THE RESULTS OF THE USE OF THE PROGRAM, LOSS OF DATA, LOSS OF USE OR LOSS OF PROFITS, OR VIRUSES; (C) DAMAGES RESULTING FROM LOST TIME, INACCURATE INPUT OR WORK DELAYS; (D) ANY OTHER DAMAGES RESULTING FROM LICENSEE'S ACCESS TO OR USE OF THE PROGRAM OR ITS RESULTS; OR (E) ANY CLAIMS, WHETHER IN CONTRACT OR TORT, THAT AROSE PRIOR TO THE INSTITUTION OF SUIT THEREON OR WHICH ALLEGE BREACH OF THE INTELLECTUAL PROPERTY RIGHTS OF ANY PERSON OR ENTITY; AND\n(c)  LICENSEE SHALL HAVE THE SOLE RESPONSIBILITY FOR ADEQUATE PROTECTION AND BACK-UP OF ITS PROGRAMMING, DATA OR EQUIPMENT USED IN CONNECTION WITH THE PROGRAM, AND THAT FITCH SHALL HAVE NO LIABILITY FOR ANY LOSS OR DAMAGES RESULTING FROM LICENSEE'S FAILURE TO DO SO.\n4.6 THE PROVISIONS OF SECTION 4.5 SHALL APPLY TO THE FULLEST EXTENT OF THE LAW, WHETHER IN CONTRACT, STATUTE, TORT (SUCH AS NEGLIGENCE) OR OTHERWISE; PROVIDED THAT SHOULD THE LICENSEE BE ENTITLED, NOTWITHSTANDING SECTION 4.5, TO RECOVER LOSS, DAMAGES OR OTHER AMOUNTS FROM FITCH AND/OR ITS LICENSORS UNDER ANY LEGAL THEORY, THE LICENSEE AGREES THAT FITCH AND ITS LICENSORS TOTAL AGGREGATE LIABILITY IN CONNECTION WITH THIS AGREEMENT, THE PROGRAM AND THE USE OF THE PROGRAM BY THE LICENSEE SHALL BE LIMITED TO US$1,000.\n\n5 GENERAL\n5.1 This Agreement, including without limitation, the disclaimers above, as well as the disclaimer and notice provisions contained within the Fitch Website, constitutes the entire Agreement between the parties respecting Licensee's use of the Program and supersedes all prior agreements or representations, oral or written, concerning the subject matter herein and may not be changed except by written amendment signed by both parties.\n5.2 The failure of either party to exercise in any respect any right provided for herein shall not be deemed a waiver of that right or any other right hereunder. Licensee may not assign any of its rights or delegate any of its obligations under this Agreement and any attempted assignment or delegation shall be null and void.\n5.3 All disputes arising out of or relating to this Agreement, its performance or to the Program, whether arising in contract, in tort, under statute or otherwise shall, to the maximum extent permitted by law, be determined exclusively under the laws of the State of New York (without regard to its conflict of laws provisions), and the Licensee agrees and consents to the exercise of personal jurisdiction over the Licensee by any state or federal court of law or equity located in the Borough of Manhattan or New York County, New York, U.S.A. The Licensee shall not initiate any legal proceeding relating to any such dispute in any jurisdiction other than in the state or federal courts located in the Borough of Manhattan or New York County, New York, U.S.A. EACH PARTY ACKNOWLEDGES AND AGREES THAT ANY DISPUTE IS LIKELY TO INVOLVE COMPLICATED AND DIFFICULT ISSUES, AND THEREFORE IT KNOWINGLY, VOLUNTARILY, INTENTIONALLY, IRREVOCABLY AND UNCONDITIONALLY WAIVES ANY RIGHT IT MAY HAVE TO A TRIAL BY JURY IN RESPECT OF ANY DISPUTE. \n5.4 With respect to a breach or threatened breach by the Licensee of any provisions of this Agreement regarding the ownership, use, copying, distribution, confidentiality or nondisclosure of the Program, Fitch would suffer continuing and irreparable injury to its business as a direct result of such breach so the Licensee consents to entry of any injunctive relief necessary to prevent or cure such breach (including temporary and preliminary relief, and relief by order of specific performance), without posting of bond or other security or proof of irreparable harm. \n5.5 This Agreement does not and is not intended to confer any rights or remedies upon any person other than Fitch and Licensee, save that each member from time to time of the Fitch Group of Companies shall expressly have the full right, title and capacity without further notice to the Licensee to enforce the terms of this Agreement as if it were itself Fitch.\n5.6 If any provision of this Agreement shall be considered illegal, invalid or unenforceable, either in whole or in its application to a particular circumstance, in any jurisdiction, then (a) such provision will be deemed amended to conform to applicable laws of such jurisdiction so as to be valid and enforceable or, if it cannot be so amended without materially altering the intention of Fitch and Licensee, it will be stricken; (b) the validity, legality and enforceability of such provision will not in any way be affected or impaired thereby in any other jurisdiction; and (c) the remainder of the Agreement will remain in full force and effect."]

{"sheet":"Input","index":1,"n_rows":250,"n_cols":7,"rows_kept":250,"cut":false,"hidden":true,"merged":[]}
["Insurance | Prism Factor-Based Capital Model"]
[null,"Input Data",null,null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[]
[]
[null,"Introductory text",null,null,null,"Follow the question mark hyperlinks for guidance on the input data"]
[null,"Note, please enter data in the white cells only, where applicable."]
[]
[]
[null,"Company Data"]
[null,"Company Name:  "]
[null,"Type of Company:"]
[null,"Corporation Tax Rate"]
[]
[null,"Reporting Basis"]
[null,"Valuation Year:  ",null,null,null,"Data checks:",{"$f":"D245","v":"Pass"}]
[null,"Reporting Standard:"]
[null,"Consolidated Reporting?:"]
[null,"Reporting Jurisdiction:"]
[null,"Reporting Risk Add-on:"]
[null,"Currency:"]
[null,"Units"]
[]
[null,"Available Capital Data"]
[null,"Capital Breakdown",null,null,null,"Notes"]
[null,"Equity excluding minority interests"]
[null,"Equity assumed to support banking entities"]
[null,"Minority interests"]
[null,"Contractual Service Margin (CSM)"]
[null,"CSM  Haircut"]
[null,"Life deferred acquisition costs"]
[null,"Value of business acquired"]
[null,"Goodwill (tax adjusted)"]
[null,"Intangible assets (excluding DAC, goodwill and deferred tax)"]
[null,"Subordinated debt - 0% equity credit"]
[null,"Subordinated debt - 50% equity credit"]
[null,"Subordinated debt - 100% equity credit"]
[null,"Preference shares"]
[null,"Equalisation reserve (if not in SH equity)"]
[null,"Off balance sheet unrealised gain (loss) bonds"]
[null,"% allocated allowing for tax effect"]
[null,"Off balance sheet unrealised gain (loss) property"]
[null,"% allocated allowing for tax effect"]
[null,"Off balance sheet unrealised gain (loss) shares / affiliates"]
[null,"% allocated allowing for tax effect"]
[null,"Off balance sheet unrealised gain (loss) other"]
[null,"% allocated allowing for tax effect"]
[null,"On balance sheet unrealised gain (loss) bonds"]
[null,"% reduction allowing for tax effect (enter as negative %)"]
[null,"Life - other technical provisions 0% (buffers) "]
[null,"Life - other technical provisions 50% (buffers) "]
[null,"Life - other technical provisions 100% (buffers) "]
[null,"Non-life reserve redundancies - 0% credit"]
[null,"Non-life reserve redundancies - 50% credit"]
[null,"Non-life reserve redundancies - 100% credit"]
[null,"Value of in force (VIF) (life)"]
[null,"Type of VIF"]
[null,"Dividend to be paid not on balance sheet (enter as negative number)"]
[null,"Hybrids capped at 20% AC?"]
[null,"Additional items counting for Fitch Core Capital available capital"]
[null,"Additional items counting for total available capital"]
[null,null,"Type of VIF / Hybrids capped entries present if required?",{"$f":"IF(OR(AND(D57=\"\",D56>0),AND(D59=\"\",SUM(D35:D37)>0)),\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Non Life Premium Data"]
[null,"Non Life Net Written Premium"]
[null,"Non Life Net Written Premium"]
[null,"Non Life Net Written Premium exposed to CAT"]
[]
[null,"Non Life Premium Split (%) (net of reinsurance)"]
[null,"Motor premium"]
[null,"Property premium"]
[null,"Liability premium"]
[null,"Marine, aviation and transport premium"]
[null,"Credit Insurance premium"]
[null,"Accident and health premium"]
[null,"Financial risks premium"]
[null,"Non-proportional reinsurance premium"]
[null,"Other high risk premium"]
[null,"Other low risk premium"]
[null,null,"Sum Check:",{"$f":"SUM(D69:D78)","v":0}]
[null,"Non Life Premium - Additional Loading or Credit"]
[null,"Concentration / underperformance / overperformance (%)"]
[]
[null,"Non Life CAT Risk Data"]
[null,"PMLs"]
[null,"Cat risk - low"]
[null,"Cat risk - med"]
[null,"Cat risk - high"]
[null,"Cat risk - very high"]
[]
[null,"Cat risk - full curve extremely strong"]
[null,"Cat risk - full curve very strong"]
[null,"Cat risk - full curve strong"]
[null,"Cat risk - full curve adequate"]
[null,"Cat risk - full curve somewhat weak"]
[null,null,"Cat risk check (use either PMLs or Full Curve, not both):",{"$f":"IF(AND(SUM(D85:D88)>0,SUM(D90:D94)>0),\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Non Life Reserve Data"]
[null,"Non Life Reserves (net of reinsurance, excluding unearned premium reserve)"]
[null,"Non Life Reserves"]
[]
[null,"Non Life Reserve Split (%) "]
[null,"Motor reserves"]
[null,"Property reserves"]
[null,"Liability reserves"]
[null,"Marine, aviation and transport reserves"]
[null,"Credit insurance reserves"]
[null,"Accident and health reserves"]
[null,"Financial risks reserves"]
[null,"Non-proportional reinsurance reserves"]
[null,"Other high risk reserves"]
[null,"Other low risk reserves"]
[null,null,"Sum Check:",{"$f":"SUM(D101:D110)","v":0}]
[null,"Non Life Reserves - Additional Loading or Credit"]
[null,"Concentration / underperformance / overperformance (%)"]
[]
[null,"Life Reserve Data"]
[null,"Life Reserves (net of reinsurance)",null,null,null,"Notes"]
[null,"Life Reserves"]
[]
[null,"Life reserve split"]
[null,"Unit linked reserves"]
[null,"Variable annuity reserves - high"]
[null,"Variable annuity reserves - med"]
[null,"Variable annuity reserves - low"]
[null,"Participating product reserves (low guars) - high"]
[null,"Participating product reserves (low guars) - med"]
[null,"Participating product reserves (low guars) - low"]
[null,"Participating product reserves (high guars) - high"]
[null,"Participating product reserves (high guars) - med"]
[null,"Participating product reserves (high guars) - low"]
[null,"Protection "]
[null,"UK style annuities NP bonds etc"]
[null,"Life non-proportional reinsurance"]
[null,null,"Sum Check:",{"$f":"IF($D$117<>0,SUM($D$120:$D$132)/$D$117,\"\")","v":""}]
[null,"Asset Information"]
[null,"Total Asset Split (including URG/L)"]
[null,"Total Invested Assets"]
[null,"Non-Life Invested Assets"]
[null,"Life Invested Assets"]
[null,"Assets assumed to belong to banking entity (not charged)"]
[null,null,"Sum Check:",{"$f":"IF(D136<>0,SUM(D137:D139)/D136,\"\")","v":""}]
[null,"Life Asset Split (including URG/L)"]
[null,"Unit Linked Assets"]
[null,"Variable Annuity Assets"]
[null,"Participating Product (Low Guars) Assets"]
[null,"Other Life Assets"]
[]
[null,"Emerging market add-on - typically 25%"]
[null,"Add-on (%)"]
[]
[null,"Non-Life Asset Split (%) (including surplus assets and URG/L)"]
[null,"Bond, AAA under 5 years"]
[null,"Bond, AA- to AA, under 5 years"]
[null,"Bond, A- to A+, under 5 years"]
[null,"Bond, BBB- to BBB+, under 5 years"]
[null,"Bond, Below BBB- & NR, under 5 years"]
[null,"Bond BB+, BB, BB- under 5 years"]
[null,"Bond B+, B, B- under 5 years"]
[null,"Bond below B- & NR under 5 years"]
[null,"Bond, AAA over 5 years"]
[null,"Bond, AA- to AA, over 5 years"]
[null,"Bond, A- to A+, over 5 years"]
[null,"Bond, BBB- to BBB+, over 5 years"]
[null,"Bond Non-invest (< BBB-) & NR over 5 years"]
[null,"Bond BB+, BB, BB- over 5 years"]
[null,"Bond B+, B, B- over 5 years"]
[null,"Bond below B- & NR over 5 years"]
[null,"Equity, low"]
[null,"Equity, high"]
[null,"Property, low"]
[null,"Property, high"]
[null,"Structured/ABS, BBB- and above"]
[null,"Structured/ABS, Below BBB- & NR"]
[null,"Mortgages"]
[null,"Cash/Deposits AA- and above and deposits with cedents"]
[null,"Cash/Deposits between A+ and BBB-"]
[null,"Cash/Deposits BB+ and Below  "]
[null,"Other, low"]
[null,"Other, high"]
[null,null,"Sum Check:",{"$f":"SUM(D151:D178)","v":0}]
[null,"Life Asset Split (%) (excluding UKWP / VA / UL ; including surplus assets; including URG/L)"]
[null,"Bond, AAA under 5 years"]
[null,"Bond, AA- to AA, under 5 years"]
[null,"Bond, A- to A+, under 5 years"]
[null,"Bond, BBB- to BBB+, under 5 years"]
[null,"Bond, Below BBB- & NR, under 5 years"]
[null,"Bond BB+, BB, BB- under 5 years"]
[null,"Bond B+, B, B- under 5 years"]
[null,"Bond below B- & NR under 5 years"]
[null,"Bond, AAA over 5 years"]
[null,"Bond, AA- to AA, over 5 years"]
[null,"Bond, A- to A+, over 5 years"]
[null,"Bond, BBB- to BBB+, over 5 years"]
[null,"Bond Non-invest (< BBB-) & NR over 5 years"]
[null,"Bond BB+, BB, BB- over 5 years"]
[null,"Bond B+, B, B- over 5 years"]
[null,"Bond below B- & NR over 5 years"]
[null,"Equity, low"]
[null,"Equity, high"]
[null,"Property, low"]
[null,"Property, high"]
[null,"Structured/ABS, BBB- and above"]
[null,"Structured/ABS, Below BBB- & NR"]
[null,"Mortgages"]
[null,"Cash/Deposits AA- and above and deposits with cedents"]
[null,"Cash/Deposits between A+ and BBB-"]
[null,"Cash/Deposits BB+ and Below  "]
[null,"Other, low"]
[null,"Other, high"]
[null,null,"Sum Check:",{"$f":"SUM(D181:D208)","v":0}]
[null,"Other Assets"]
[null,"Counterparty credit risk AA- and above"]
[null,"Counterparty credit risk between A+ and BBB-"]
[null,"Counterparty credit risk Below  BBB-"]
[null,"Tangible assets"]
[null,"Asset management assets (off balance sheet)"]
[null,"Charge for off balance sheet assets (excluding asset management assets) (%)"]
[null,"Off balance sheet asset (excluding asset management assets)"]
[null,"Charge on all banking assets - set by analyst (%)"]
[null,"Banking assets charged in model"]
[null,"Assets exposed to currency risk"]
[null,"Charge for currency risk - set by analyst (%)"]
[]
[]
[null,"End of Input Data",null,null,null,null,"é Back to Top"]
[]
[]
[]
[null,"Data Checks","Sum Check Tolerance:",0.01]
[]
[null,null,null,"Pass/Fail?"]
[null,"Sum Checks:"]
[null,"Non-Life Premium Split = 100%",null,{"$f":"IF(SUM($D$69:$D$78)=0,\"\",IF(ABS(1-SUM($D$69:$D$78))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Non-Life Reserves Split = 100%",null,{"$f":"IF(SUM(D101:D110)=0,\"\",IF(ABS(1-SUM(D101:D110))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Life Reserves Split = 100%",null,{"$f":"IF(SUM(D120:D132)=0,\"\",IF(ABS(1-(SUM(D120:D132)/D117))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Total Invested Assets Split = 100%",null,{"$f":"IF(SUM(D137:D139)=0,\"\",IF(ABS(1-(SUM(D137:D139)/D136))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Non-Life Asset Split = 100%",null,{"$f":"IF(SUM(D151:D178)=0,\"\",IF(ABS(1-SUM(D151:D178))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Life Asset Split = 100%",null,{"$f":"IF(SUM(D181:D208)=0,\"\",IF(ABS(1-SUM(D181:D208))<Tol,\"Pass\",\"Fail\"))","v":""}]
[null,"Consistency Checks:"]
[null,"Error values found",null,{"$f":"IF(ISERROR(SUM(InputCells)),\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Negative monetary values (yellow highlight)",null,{"$f":"IF(MIN(InputMonetaryPlus)<0,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Percentage value outside allowable range (orange highlight)",null,{"$f":"IF(OR(MIN(InputPercentagesPlus)<0,MAX(InputPercentagesPlus)>1,$D$49<-1,$D$49>0),\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Non-numeric values (gold highlight)",null,{"$f":"IF(('Output Generation'!J32-'Output Generation'!J33-'Output Generation'!J34)>0,\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Cat risk check",null,{"$f":"IF(AND(SUM(D85:D88)>0,SUM(D90:D94)>0),\"Fail\",\"Pass\")","v":"Pass"}]
[null,"Negative net exposure",null,{"$f":"IF(OR(Calculations!$C$98<0,Calculations!$C$100<0),\"Fail\",\"Pass\")","v":"Pass"}]
[null,null,"Overall:",{"$f":"IF(COUNTIF(D231:D244,\"Fail\")>0,\"Fail\",\"Pass\")","v":"Pass"}]
[]
[null,"Completeness Checks:"]
[null,"Type of VIF",null,{"$f":"IF(AND(D57=\"\",D56>0),\"Warning\",\"Pass\")","v":"Pass"}]
[null,"Hybrid cap",null,{"$f":"IF(AND(D59=\"\",SUM(D35:D37)>0),\"Warning\",\"Pass\")","v":"Pass"}]
[null,null,"Overall:",{"$f":"IF(COUNTIF(D248:D249,\"Warning\")=0,\"Pass\",\"Warning\")","v":"Pass"},{"$f":"IF(D248=\"Warning\",B248&\" not specified. \",\"\")&IF(D249=\"Warning\",B249&\" not specified. \",\"-\")","v":"-"}]

{"sheet":"Output","index":2,"n_rows":84,"n_cols":13,"rows_kept":84,"cut":false,"hidden":true,"merged":[[1,4,1,10],[51,7,52,8],[51,9,52,10],[51,11,52,12],[51,1,52,1],[51,2,53,2],[51,3,52,4],[51,5,52,6],[46,4,46,10]]}
[{"$f":"Input!A1","v":"Insurance | Prism Factor-Based Capital Model"}]
[null,"Output Data",null,null,{"$f":"IF(DataChecks=\"Pass\",EntityName &\" (\" & Year &\")\",\"Data Checks Failed\")","v":" ()"},null,null,null,null,null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[null,{"$f":"IF(Input!$D$250=\"Warning\",Input!E250,\"\")","v":""}]
[]
[null,{"$f":"\"Capital Result for \" & Year & \" - \" & CapitalModelResult","v":"Capital Result for  - Extremely Strong"}]
[null,"Available Capital",{"$f":"CurrencyAbbrv","v":{"$error":"#N/A"}}]
[null,"Fitch Core Capital (FCC)",{"$f":"Calculations!E93","v":0}]
[null,"Total Available Capital (TAC)",{"$f":"Calculations!E80","v":0}]
[null,"Target Capital"]
[null,"Extremely Strong",{"$f":"Calculations!E117","v":0}]
[null,"Very Strong",{"$f":"Calculations!E139","v":0}]
[null,"Strong",{"$f":"Calculations!E161","v":0}]
[null,"Adequate",{"$f":"Calculations!E183","v":0}]
[null,"Somewhat Weak",{"$f":"Calculations!E205","v":0}]
[null,"Available Capital / Target Capital"]
[null,"Extremely Strong",{"$f":"Calculations!$F$117","v":0}]
[null,"Very Strong",{"$f":"Calculations!$F$139","v":0}]
[null,"Strong",{"$f":"Calculations!$F$161","v":0}]
[null,"Adequate",{"$f":"Calculations!$F$183","v":0}]
[null,"Somewhat Weak",{"$f":"Calculations!$F$205","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Output Data",null,null,{"$f":"EntityName &\" (\" & Year &\")\"","v":" ()"},null,null,null,null,null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[]
[]
[]
[null,"Target Capital","Net Reserves / Premium / MV","Extremely Strong",null,"Very Strong",null,"Strong",null,"Adequate",null,"Somewhat Weak"]
[]
[null,{"$f":"Currency","v":0},null,"Target capital","Risk charge","Target capital","Risk charge","Target capital","Risk charge","Target capital","Risk charge","Target capital","Risk charge"]
[null,"Life"]
[null,"Unit linked ",{"$f":"Calculations!M10","v":0},{"$f":"Calculations!D10","v":0},{"$f":"Calculations!N10","v":""},{"$f":"Calculations!E10","v":0},{"$f":"Calculations!O10","v":""},{"$f":"Calculations!F10","v":0},{"$f":"Calculations!P10","v":""},{"$f":"Calculations!G10","v":0},{"$f":"Calculations!Q10","v":""},{"$f":"Calculations!H10","v":0},{"$f":"Calculations!R10","v":""}]
[null,"Variable annuities",{"$f":"Calculations!M11","v":0},{"$f":"Calculations!D11","v":0},{"$f":"Calculations!N11","v":""},{"$f":"Calculations!E11","v":0},{"$f":"Calculations!O11","v":""},{"$f":"Calculations!F11","v":0},{"$f":"Calculations!P11","v":""},{"$f":"Calculations!G11","v":0},{"$f":"Calculations!Q11","v":""},{"$f":"Calculations!H11","v":0},{"$f":"Calculations!R11","v":""}]
[null,"Participating product reserves (LG)",{"$f":"Calculations!M12","v":0},{"$f":"Calculations!D12","v":0},{"$f":"Calculations!N12","v":""},{"$f":"Calculations!E12","v":0},{"$f":"Calculations!O12","v":""},{"$f":"Calculations!F12","v":0},{"$f":"Calculations!P12","v":""},{"$f":"Calculations!G12","v":0},{"$f":"Calculations!Q12","v":""},{"$f":"Calculations!H12","v":0},{"$f":"Calculations!R12","v":""}]
[null,"Participating product reserves (HG)",{"$f":"Calculations!M13","v":0},{"$f":"Calculations!D13","v":0},{"$f":"Calculations!N13","v":""},{"$f":"Calculations!E13","v":0},{"$f":"Calculations!O13","v":""},{"$f":"Calculations!F13","v":0},{"$f":"Calculations!P13","v":""},{"$f":"Calculations!G13","v":0},{"$f":"Calculations!Q13","v":""},{"$f":"Calculations!H13","v":0},{"$f":"Calculations!R13","v":""}]
[null,"Protection ",{"$f":"Calculations!M14","v":0},{"$f":"Calculations!D14","v":0},{"$f":"Calculations!N14","v":""},{"$f":"Calculations!E14","v":0},{"$f":"Calculations!O14","v":""},{"$f":"Calculations!F14","v":0},{"$f":"Calculations!P14","v":""},{"$f":"Calculations!G14","v":0},{"$f":"Calculations!Q14","v":""},{"$f":"Calculations!H14","v":0},{"$f":"Calculations!R14","v":""}]
[null,"UK style annuities NP bonds etc",{"$f":"Calculations!M15","v":0},{"$f":"Calculations!D15","v":0},{"$f":"Calculations!N15","v":""},{"$f":"Calculations!E15","v":0},{"$f":"Calculations!O15","v":""},{"$f":"Calculations!F15","v":0},{"$f":"Calculations!P15","v":""},{"$f":"Calculations!G15","v":0},{"$f":"Calculations!Q15","v":""},{"$f":"Calculations!H15","v":0},{"$f":"Calculations!R15","v":""}]
[null,"Life non-prop reinsurance",{"$f":"Calculations!M16","v":0},{"$f":"Calculations!D16","v":0},{"$f":"Calculations!N16","v":""},{"$f":"Calculations!E16","v":0},{"$f":"Calculations!O16","v":""},{"$f":"Calculations!F16","v":0},{"$f":"Calculations!P16","v":""},{"$f":"Calculations!G16","v":0},{"$f":"Calculations!Q16","v":""},{"$f":"Calculations!H16","v":0},{"$f":"Calculations!R16","v":""}]
[null,"Life Asset Risk",{"$f":"Calculations!M17","v":0},{"$f":"Calculations!D17","v":0},{"$f":"Calculations!N17","v":""},{"$f":"Calculations!E17","v":0},{"$f":"Calculations!O17","v":""},{"$f":"Calculations!F17","v":0},{"$f":"Calculations!P17","v":""},{"$f":"Calculations!G17","v":0},{"$f":"Calculations!Q17","v":""},{"$f":"Calculations!H17","v":0},{"$f":"Calculations!R17","v":""}]
[null,"Non-life"]
[null,"Motor",{"$f":"Calculations!M19","v":0},{"$f":"Calculations!D19","v":0},{"$f":"Calculations!N19","v":""},{"$f":"Calculations!E19","v":0},{"$f":"Calculations!O19","v":""},{"$f":"Calculations!F19","v":0},{"$f":"Calculations!P19","v":""},{"$f":"Calculations!G19","v":0},{"$f":"Calculations!Q19","v":""},{"$f":"Calculations!H19","v":0},{"$f":"Calculations!R19","v":""}]
[null,"Property",{"$f":"Calculations!M20","v":0},{"$f":"Calculations!D20","v":0},{"$f":"Calculations!N20","v":""},{"$f":"Calculations!E20","v":0},{"$f":"Calculations!O20","v":""},{"$f":"Calculations!F20","v":0},{"$f":"Calculations!P20","v":""},{"$f":"Calculations!G20","v":0},{"$f":"Calculations!Q20","v":""},{"$f":"Calculations!H20","v":0},{"$f":"Calculations!R20","v":""}]
[null,"Liability",{"$f":"Calculations!M21","v":0},{"$f":"Calculations!D21","v":0},{"$f":"Calculations!N21","v":""},{"$f":"Calculations!E21","v":0},{"$f":"Calculations!O21","v":""},{"$f":"Calculations!F21","v":0},{"$f":"Calculations!P21","v":""},{"$f":"Calculations!G21","v":0},{"$f":"Calculations!Q21","v":""},{"$f":"Calculations!H21","v":0},{"$f":"Calculations!R21","v":""}]
[null,"Marine, aviation and transport",{"$f":"Calculations!M22","v":0},{"$f":"Calculations!D22","v":0},{"$f":"Calculations!N22","v":""},{"$f":"Calculations!E22","v":0},{"$f":"Calculations!O22","v":""},{"$f":"Calculations!F22","v":0},{"$f":"Calculations!P22","v":""},{"$f":"Calculations!G22","v":0},{"$f":"Calculations!Q22","v":""},{"$f":"Calculations!H22","v":0},{"$f":"Calculations!R22","v":""}]
[null,"Credit Insurance ",{"$f":"Calculations!M23","v":0},{"$f":"Calculations!D23","v":0},{"$f":"Calculations!N23","v":""},{"$f":"Calculations!E23","v":0},{"$f":"Calculations!O23","v":""},{"$f":"Calculations!F23","v":0},{"$f":"Calculations!P23","v":""},{"$f":"Calculations!G23","v":0},{"$f":"Calculations!Q23","v":""},{"$f":"Calculations!H23","v":0},{"$f":"Calculations!R23","v":""}]
[null,"Accident and health ",{"$f":"Calculations!M24","v":0},{"$f":"Calculations!D24","v":0},{"$f":"Calculations!N24","v":""},{"$f":"Calculations!E24","v":0},{"$f":"Calculations!O24","v":""},{"$f":"Calculations!F24","v":0},{"$f":"Calculations!P24","v":""},{"$f":"Calculations!G24","v":0},{"$f":"Calculations!Q24","v":""},{"$f":"Calculations!H24","v":0},{"$f":"Calculations!R24","v":""}]
[null,"Financial risks ",{"$f":"Calculations!M25","v":0},{"$f":"Calculations!D25","v":0},{"$f":"Calculations!N25","v":""},{"$f":"Calculations!E25","v":0},{"$f":"Calculations!O25","v":""},{"$f":"Calculations!F25","v":0},{"$f":"Calculations!P25","v":""},{"$f":"Calculations!G25","v":0},{"$f":"Calculations!Q25","v":""},{"$f":"Calculations!H25","v":0},{"$f":"Calculations!R25","v":""}]
[null,"Non-proportional reinsurance ",{"$f":"Calculations!M26","v":0},{"$f":"Calculations!D26","v":0},{"$f":"Calculations!N26","v":""},{"$f":"Calculations!E26","v":0},{"$f":"Calculations!O26","v":""},{"$f":"Calculations!F26","v":0},{"$f":"Calculations!P26","v":""},{"$f":"Calculations!G26","v":0},{"$f":"Calculations!Q26","v":""},{"$f":"Calculations!H26","v":0},{"$f":"Calculations!R26","v":""}]
[null,"Other high",{"$f":"Calculations!M27","v":0},{"$f":"Calculations!D27","v":0},{"$f":"Calculations!N27","v":""},{"$f":"Calculations!E27","v":0},{"$f":"Calculations!O27","v":""},{"$f":"Calculations!F27","v":0},{"$f":"Calculations!P27","v":""},{"$f":"Calculations!G27","v":0},{"$f":"Calculations!Q27","v":""},{"$f":"Calculations!H27","v":0},{"$f":"Calculations!R27","v":""}]
[null,"Other low",{"$f":"Calculations!M28","v":0},{"$f":"Calculations!D28","v":0},{"$f":"Calculations!N28","v":""},{"$f":"Calculations!E28","v":0},{"$f":"Calculations!O28","v":""},{"$f":"Calculations!F28","v":0},{"$f":"Calculations!P28","v":""},{"$f":"Calculations!G28","v":0},{"$f":"Calculations!Q28","v":""},{"$f":"Calculations!H28","v":0},{"$f":"Calculations!R28","v":""}]
[null,"Analyst adjustment",{"$f":"Calculations!M29","v":0},{"$f":"Calculations!D29","v":0},{"$f":"Calculations!N29","v":""},{"$f":"Calculations!E29","v":0},{"$f":"Calculations!O29","v":""},{"$f":"Calculations!F29","v":0},{"$f":"Calculations!P29","v":""},{"$f":"Calculations!G29","v":0},{"$f":"Calculations!Q29","v":""},{"$f":"Calculations!H29","v":0},{"$f":"Calculations!R29","v":""}]
[null,"Cat risk",{"$f":"Calculations!M30","v":0},{"$f":"Calculations!D30","v":0},{"$f":"Calculations!N30","v":""},{"$f":"Calculations!E30","v":0},{"$f":"Calculations!O30","v":""},{"$f":"Calculations!F30","v":0},{"$f":"Calculations!P30","v":""},{"$f":"Calculations!G30","v":0},{"$f":"Calculations!Q30","v":""},{"$f":"Calculations!H30","v":0},{"$f":"Calculations!R30","v":""}]
[null,"Non-Life Asset Risk",{"$f":"Calculations!M31","v":0},{"$f":"Calculations!D31","v":0},{"$f":"Calculations!N31","v":""},{"$f":"Calculations!E31","v":0},{"$f":"Calculations!O31","v":""},{"$f":"Calculations!F31","v":0},{"$f":"Calculations!P31","v":""},{"$f":"Calculations!G31","v":0},{"$f":"Calculations!Q31","v":""},{"$f":"Calculations!H31","v":0},{"$f":"Calculations!R31","v":""}]
[null,"Other",null,{"$f":"Calculations!D32","v":0},null,{"$f":"Calculations!E32","v":0},null,{"$f":"Calculations!F32","v":0},null,{"$f":"Calculations!G32","v":0},null,{"$f":"Calculations!H32","v":0}]
[null,"Reporting Risk Add-on",null,{"$f":"Calculations!D33","v":0},null,{"$f":"Calculations!E33","v":0},null,{"$f":"Calculations!F33","v":0},null,{"$f":"Calculations!G33","v":0},null,{"$f":"Calculations!H33","v":0}]
[null,"Undiversified target capital",{"$f":"Calculations!M34","v":0},{"$f":"Calculations!D34","v":0},{"$f":"Calculations!N34","v":""},{"$f":"Calculations!E34","v":0},{"$f":"Calculations!O34","v":""},{"$f":"Calculations!F34","v":0},{"$f":"Calculations!P34","v":""},{"$f":"Calculations!G34","v":0},{"$f":"Calculations!Q34","v":""},{"$f":"Calculations!H34","v":0},{"$f":"Calculations!R34","v":""}]
[null,"Diversification benefit",null,{"$f":"Calculations!D35","v":0},{"$f":"Calculations!N35","v":""},{"$f":"Calculations!E35","v":0},{"$f":"Calculations!O35","v":""},{"$f":"Calculations!F35","v":0},{"$f":"Calculations!P35","v":""},{"$f":"Calculations!G35","v":0},{"$f":"Calculations!Q35","v":""},{"$f":"Calculations!H35","v":0},{"$f":"Calculations!R35","v":""}]
[null,"Total target capital",{"$f":"Calculations!M36","v":0},{"$f":"Calculations!D36","v":0},{"$f":"Calculations!N36","v":""},{"$f":"Calculations!E36","v":0},{"$f":"Calculations!O36","v":""},{"$f":"Calculations!F36","v":0},{"$f":"Calculations!P36","v":""},{"$f":"Calculations!G36","v":0},{"$f":"Calculations!Q36","v":""},{"$f":"Calculations!H36","v":0},{"$f":"Calculations!R36","v":""}]
[null,"Base available capital",{"$f":"Calculations!M37","v":0}]
[null,"Available Capital / Target Capital:",null,{"$f":"Calculations!N38","v":""},null,{"$f":"Calculations!O38","v":""},null,{"$f":"Calculations!P38","v":""},null,{"$f":"Calculations!Q38","v":""},null,{"$f":"Calculations!R38","v":""}]

{"sheet":"Guidance On Input Data","index":3,"n_rows":221,"n_cols":5,"rows_kept":221,"cut":false,"hidden":true,"merged":[]}
[{"$f":"Input!A1","v":"Insurance | Prism Factor-Based Capital Model"}]
["Guidance on Input Data",null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[]
[]
[]
[]
["ç Back"]
[]
["Ref.","Company Data",null,"Definition","Comments / Examples"]
[null,"Company Name:  ",null,"Name of company","Insurance Ltd"]
[null,"Type of Company:",null,"Business written","Life, Non-life, Reinsurance"]
[null,"Corporation Tax Rate",null,"Rate of tax applied to items going through P&L","e.g. 20%"]
[]
[null,"Reporting Basis"]
[null,"Valuation Year:  ",null,"Year end which the data relates to","2011"]
[null,"Reporting Standard:",null,"Reporting standard used","IFRS, GAAP"]
[null,"Consolidated Reporting?:",null,"How numbers are processed","Yes, No"]
[null,"Reporting Jurisdiction:",null,"Country where accounts are submitted","UK, FR, DE, RUS"]
[null,"Reporting Risk Add-On:",null,"Add-on to reflect risk due to concentration, lower than average reporting standards, or other risk not reflected in the model found typically in emerging markets","High, Medium, Low, None"]
[null,"Currency:",null,"Currency inputs made to model (abbreviated version)","GBP, EUR, USD"]
[null,"Units",null,"Units entered into model","Trillions, Billions, Millions, Thousands or standard Units"]
[]
["Ref.","Available Capital Data",null,"Definition","Comments / Examples"]
["ç Back","Capital breakdown"]
["AC1",{"$f":"Input!B26","v":"Equity excluding minority interests"},null,"Total equity","Excluding minority interests"]
["AC2","Equity assumed to support banking entities",null,"Usually an estimate","If not possible leave in a charge as mortgages"]
["AC3","Minority interests",null,"Equity attributable to minority interests"]
["AC30","Contractual Service Margin (CSM)",null,"This represents the unearned profit that an entity expects to earn as it provides services.","The CSM represents the profit that a company expects to earn over the contract duration, and therefore we view it as having the characteristics of loss-absorbing capital"]
["C_AC30","CSM Haircut",null,"Haircut on CSM.","In case not a 100% credit given to CSM"]
["AC4","Life deferred acquisition costs",null,"Life deferred acquisition costs"]
["AC5","Value of business acquired",null,"Value of business acquired"]
["AC6","Goodwill",null,"Goodwill"]
["AC7","Intangible assets (excluding DAC and goodwill)",null,"Other intangible assets"]
["AC9","Subordinated debt - 0% equity credit",null,"Subordinated debt categorised using Fitch criteria"]
["AC10","Subordinated debt - 50% equity credit",null,"Subordinated debt categorised using Fitch criteria"]
["AC11","Subordinated debt - 100% equity credit",null,"Subordinated debt categorised using Fitch criteria"]
["AC12","Preference shares",null,"Preference shares"]
["AC13","Equalisation reserve (if not in SH equity)",null,"Equalisation reserve if not included in shareholders' equity"]
["AC14","Off balance sheet unrealised gain (loss) bonds",null,"Estimate URG (L) bonds not already on the balance sheet or in free surplus (excluding those due to interest rates not reflected in the reserves)","Account for economic URG/L that would be accounted for in shareholders' equity if assets and liabilities were both at market value, that are not already included in shareholders' equity"]
["C_AC14","% allocated allowing for tax effect",null,"% Credit of above item to include in AC, allow for tax"]
["AC15","Off balance sheet unrealised gain (loss) property",null,"Estimate URG (L) property business not already on the balance sheet or in free surplus","See AC14"]
["C_AC15","% allocated allowing for tax effect",null,"% Credit of above item to include in AC, allow for tax"]
["AC16","Off balance sheet unrealised gain (loss) shares / affiliates",null,"Estimate URG (L) shares / affiliates not already on the balance sheet","See AC14"]
["C_AC16","% allocated allowing for tax effect",null,"% Credit of above item to include in AC, allow for tax"]
["AC17","Off balance sheet unrealised gain (loss) other",null,"Estimate URG (L) other not already on the balance sheet","See AC14"]
["C_AC17","% allocated allowing for tax effect",null,"% Credit of above item to include in AC, allow for tax"]
["AC18","On balance sheet unrealised gain (loss) bonds",null,"Estimate URG (L) due to interest rates on bonds on the balance sheet not reflected in the reserves - ie for interest rates","Eliminate URG/L due to interest rate movements not reflected in reserves"]
["C_AC18","% reduction allowing for tax effect (enter as negative)",null,"% Credit of above item to include in AC, allow for tax"]
["AC19","Life - other technical provisions 0% (buffers) ",null,"Life buffers not receiving credit","See user documentation for more detail"]
["AC20","Life - other technical provisions 50% (buffers) ",null,"Life buffers receiving credit of 50%","See user documentation for more detail"]
["AC21","Life - other technical provisions 100% (buffers) ",null,"Life buffers receiving credit of 100%","FFA, PPB, Free RFB - see user documentation for more detail"]
["AC22","Non-life reserve redundancies - 0% credit",null,"Not reviewed externally"]
["AC23","Non-life reserve redundancies - 50% credit",null,"Externally reviewed and signed off"]
["AC24","Non-life reserve redundancies - 100% credit",null,"Externally reviewed and signed off by independent and reliable auditor"]
["AC26","VIF",null,"Exclude any element of VIF already accounted for in shareholders’ equity other than those deducted in FBM like VOBA AVIF DAC ","If no VIF is disclosed, input DAC (plus VOBA) net of tax here. If no VIF or DAC disclosed, input estimated DAC (net of tax), based on adding the past 5 years' acquisition costs (as they appeared in historical income statements)."]
["ACI_26","Type of VIF",null,"Select the type that best fits the type of VIF published by the insurer","MCEV = market consistent embedded value, EV with COG = embedded value with allowance for cost of options and guarantees, EV no COG = embedded value with no allowance for cost of options and guarantees, "]
["AC27","Dividend to be paid not on balance sheet (enter as negative number)",null,"Dividend to be paid not on balance sheet","Not for dividends paid. Just for dividends that have been announced but which have not yet had a corresponding liability set up on the balance sheet"]
["ACI_30","Hybrids capped at 20% AC?",null,"Yes if cap used, no if not","See main insurance criteria for guidance"]
["AC28","Additional items counting for Fitch Core Capital available capital",null,"Any items not captured in the standard calculation","Eg central funds at Lloyd's - net this down for tax."]
["AC29","Additional items counting for total available capital",null,"Any items not captured in the standard calculation","Do not repeat items from the above line \"additional items counting for Fitch Core Capital available capital\", as these will feed through into AC from there\nAdd in LOCs at Lloyds here (shareholders equity should be net of this)"]
[]
["Ref.","Non Life Premium Data",null,"Definition","Comments / Examples"]
["ç Back","Non Life Net Written Premium"]
["NLP","Non Life Net Written Premium",null,"Net written premium"]
["NLP_E","Non Life Net Written Premium Exposed to Cat",null,"Net written premium Exposed to Cat","Where analysts use a cat risk charge, there may be double counting of cat exposed premium. Where possible and material, users will enter the cat exposed premium here, which will reduce the premium changed in the model, to allow for that."]
[null,"NL Premium Split (%) (net of reinsurance)",null,"Definition","Comments / Examples"]
["NLP1","Motor premium",null,"Motor (including liability)"]
["NLP2","Property premium",null,"Property","Fire, farm (eg crop, livestock)"]
["NLP3","Liability premium",null,"Other liability","Workers' comp (employers liability), public liability, product liability, directors and officers, errors and omissions, medical malpractice, legal expenses"]
["NLP4","Marine, aviation and transport premium",null,"Marine, aviation and transport","Hull, cargo"]
["NLP5","Credit Insurance premium",null,"Credit insurance","Credit insurance, factoring"]
["NLP6","Accident and health premium",null,"A&H (short tail - up to one 1 year)"]
["NLP7","Financial risks premium",null,"Other financial risks","Pecuniary loss"]
["NLP8","Non-proportional reinsurance premium",null,"Non-life only"]
["NLP9","Other high risk premium",null,"Business not fitting into the categories above, with high volatility in combined ratio","Should not be used greatly"]
["NLP10","Other low risk premium",null,"Business not fitting into the categories above, with low volatility in combined ratio","Should not be used greatly"]
[]
[null,"Non Life Premium - Additional Loading or Credit",null,"Definition","Comments / Examples"]
["NLP11","Concentration / underperformance / overperformance (%)",null,"Add in an extra percentage charge or relief","Use only for exceptional cases based on very high or volatile combined ratios"]
[]
["Ref.","Non Life CAT Risk Data",null,"Definition","Comments / Examples"]
["ç Back","Shareholder's Equity - Exposure to CAT",null,"Definition","Comments / Examples"]
["CAT1","Cat risk – low",null,"PML 1/200 VaR","EU flood with government reinsurance protection"]
["CAT2","Cat risk – med",null,"PML 1/200 VaR","EU wind with low government reinsurance"]
["CAT3","Cat risk – high",null,"PML 1/200 VaR","US risk"]
["CAT4","Cat risk – very high",null,"PML 1/200 VaR","Particularly high US risk"]
["CAT5,1","Cat risk - full curve extremely strong",null,"PML 1/1000 T-VaR","Specific curve provided by company"]
["CAT5,2","Cat risk - full curve very strong",null,"PML 1/500 T-VaR","Specific curve provided by company"]
["CAT5,3","Cat risk - full curve strong",null,"PML 1/250 T-VaR","Specific curve provided by company"]
["CAT5,4","Cat risk - full curve adequate",null,"PML 1/100 T-VaR","Specific curve provided by company"]
["CAT5,5","Cat risk - full curve somewhat weak",null,"PML 1/50 T-VaR","Specific curve provided by company"]
[]
["Ref.","Non Life Reserve Data",null,"Definition","Comments / Examples"]
["ç Back","Non Life Reserves (net of reinsurance, excluding unearned premium reserve)"]
["NLR","Non Life Reserves (net of reinsurance, excluding unearned premium reserve)",null,"Net reserve excluding unearned premium reserve","Adjust to remove discounting"]
[]
[null,"NL Reserve Split (%) (net of reinsurance)",null,"Definition","Comments / Examples"]
["NLR1","Motor reserves",null,"Motor (including liability)"]
["NLR2","Property reserves",null,"Property","Fire, farm (eg crop, livestock)"]
["NLR3","Liability reserves",null,"Other liability","Workers' comp (employers liability), public liability, product liability, directors and officers, errors and omissions, medical malpractice, legal expenses"]
["NLR4","Marine, aviation and transport reserves",null,"Marine, aviation and transport","Hull, cargo"]
["NLR5","Credit insurance reserves",null,"Credit insurance","Credit insurance, factoring"]
["NLR6","Accident and health reserves",null,"A&H (short tail - up to one 1 year)"]
["NLR7","Financial risks reserves",null,"Other financial risks","Pecuniary loss"]
["NLR8","Non-proportional reinsurance reserves",null,"Non-life only"]
["NLR9","Other high risk reserves",null,"Business not fitting into the categories above, with high uncertainty in reserve adequacy","Should not be used greatly"]
["NLR10","Other low risk reserves",null,"Business not fitting into the categories above, with low uncertainty in reserve adequacy","Should not be used greatly"]
[]
[null,"Non Life Reserves - Additional Loading or Credit",null,"Definition","Comments / Examples"]
["NLR11","Concentration / underperformance / overperformance (%)",null,"Add in an extra percentage charge or relief","Base on analyst judgement - see Model Definition Document for more details"]
[]
["Ref.","Life Reserve and Asset Management Data",null,"Definition","Comments / Examples"]
["ç Back","Life Reserves (net of reinsurance)"]
["LR","Life Reserves (net of reinsurance)"]
[]
[null,"Life reserve split",null,"Definition","Comments / Examples"]
["LR1","Unit linked reserves",null,"Assets with close to no guarantees but held on the balance sheet","Allowance for operational risk"]
["LR2","Variable annuity reserves - high",null,"Unit-linked reserves with high moneyness, guarantees, or equity backing, and lack of effective hedging"]
["LR3","Variable annuity reserves - med",null,"Unit-linked reserves with medium moneyness, guarantees, or equity backing, or only moderately effective hedging"]
["LR4","Variable annuity reserves - low",null,"Unit-linked reserves with low moneyness, guarantees, or equity backing, or highly effective hedging"]
["LR5","Participating product reserves (low guars) - high",null,"Flexible participating products with high weighting to investment guarantees  / low weighting to discretionary benefits, high moneyness, low asset share vs reserve for guaranteed benefits","Typically UK-style with-profits fund with low Peak 1 free asset ratio. Similar business exists in S Africa, Sweden, Ireland"]
["LR6","Participating product reserves (low guars) - med",null,"Flexible participating products with medium weighting to investment guarantees  / medium weighting to discretionary benefits, medium moneyness, medium asset share vs reserve for guaranteed benefits","Typically UK-style with-profits fund with medium Peak 1 free asset ratio. Similar business exists in S Africa, Sweden, Ireland."]
["LR7","Participating product reserves (low guars) - low",null,"Flexible participating products with low weighting to investment guarantees  / high weighting to discretionary benefits, low moneyness, high asset share vs reserve for guaranteed benefits","Typically UK-style with-profits fund with high Peak 1 free asset ratio. Similar business exists in S Africa, Sweden, Ireland."]
["LR8","Participating product reserves (high guars) - high",null,"Inflexible participating products with onerous guarantees and high risk of shortfall","Typically continental European participating business with low running yield relative to guarantee rate and limited non-investment earnings to support guarantees, high moneyness, long-duration guarantees, regular premiums that cannot be repriced, limited new business, or significant duration mismatch"]
["LR9","Participating product reserves (high guars) - med",null,"Inflexible participating products with onerous guarantees and medium risk of shortfall","Typically continental European participating business with moderate running yield relative to guarantee rate and limited non-investment earnings to support guarantees, moderate moneyness, or duration mismatch with limited new business"]
["LR10","Participating product reserves (high guars) - low",null,"Inflexible participating products with onerous guarantees and low risk of shortfall","Typically continental European participating business with high running yield relative to guarantee rate and/or material non-investment earnings to support guarantees, and close duration-matching"]
["LR11","Protection incl reinsurance",null,"Protection including term insurance, critical illness, permanent health insurance","Include long term health protection here and whole of life term insurance"]
["LR12","UK style annuities, NP bonds, etc",null,"Non-participating guaranteed products ","Excl protection"]
["LR13","Life non-proportional reinsurance",null,"Life non-proportional reinsurance","Includes longevity reinsurance"]
[]
["Ref.","Asset Information",null,"Definition","Comments / Examples"]
["ç Back","Total Asset Split (including URG/L)"]
["TA","Total Invested Assets",null,"From balance sheet","The other items should add up to this"]
["NLA","Non-Life Invested Assets",null,"Assets backing non-life business","Include non-life surplus"]
["TLA","Life Invested Assets",null,"Assets backing life business","Include surplus"]
["TLB","Assets assumed to belong to banking entity",null,"Assets assumed to belong to banking entity","Include surplus (not charged)"]
[]
[null,"Life Asset Split (including URG/L)"]
["ULA","Unit Linked Assets",null,"Assets backing unit-linked life business","Include surplus"]
["VAA","Variable Annuity Assets",null,"Assets backing VA life business","Include surplus"]
["WPA","UK WP Assets",null,"Assets backing UK WP life business","Include assets backing surplus, eg FFA"]
["LA","Other Life Assets",null,"Assets backing other life business","Include asset backing surplus, eg PPB (France), free RfB (Germany) and similar"]
[]
[null,"Emerging market add-on ",null,"Definition","Comments / Examples"]
["EMA23","Add-on",null,"Asset adjuster for extra uncertainty over valuation and liquidity","Base on analyst judgement - see Model Definition Document for more details"]
[]
[null,"Non-Life Asset Split (including surplus assets and URG/L)"]
["NLA1","Bond AAA Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Market value\nInclude covered bonds in relevant bucket "]
["NLA2","Bond AA+, AA, AA- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Assume NL under 5 years if no other info"]
["NLA3","Bond A+, A, A- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Assume L over 5 years if no other info"]
["NLA4","Bond BBB+, BBB, BBB- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","If average duration is 5.1 years (say), spread the exposure between \"under 5 years\" and \"over 5 years\" to ensure representative average charge is applied"]
["NLA5","Bond Non-invest (< BBB-) & NR Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Non-rated instruments may be bucketed in the most relevant rating category if sufficient supporting information is available."]
["NLA23","Bond BB+, BB, BB- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["NLA24","Bond B+, B, B- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["NLA25","Bond below B- & NR Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket, including non-rated"]
["NLA6","Bond AAA Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include government bonds in relevant bucket"]
["NLA7","Bond AA+, AA, AA- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Affiliates can be entered as bonds in relevant bucket if appropriate to the risk and if noted in analyst notes"]
["NLA8","Bond A+, A, A- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Loans excluding mortgages, will be accounted for as bonds."]
["NLA9","Bond BBB+, BBB, BBB- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["NLA10","Bond Non-invest (< BBB-) & NR Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket, including non-rated"]
["NLA26","Bond BB+, BB, BB- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["NLA27","Bond B+, B, B- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["NLA28","Bond below B- & NR Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket, including non-rated"]
["NLA11","Equity low ",null,"Equity - \"developed\" markets","As defined by Fitch  - see Model Definition Document for more details"]
["NLA12","Equity high ",null,"Equity - \"emerging markets\" and \"high frontier\" markets","As defined by Fitch  - see Model Definition Document for more details"]
["NLA13","Property low ",null,"Property - value could be realised in near-term with reasonable certainty"]
["NLA14","Property high ",null,"Property - high uncertainty over value that could be realised in near-term"]
["NLA15","Structured/ABS BBB- and above ",null,"Any instrument containing a structured vehicle","CMBS / RMBS / credit card securitisations"]
["NLA16","Structured/ABS Below BBB- ",null,"Any instrument containing a structured vehicle","With adequate justification, these instruments can be included in the bond buckets "]
["NLA17","Mortgages",null,"Secured loans"]
["NLA18","Cash/Deposits AA- and above and deposits with cedents",null,"Cash and deposits with cedents"]
["NLA19","Cash/Deposits between A+ and BBB-",null,"Cash and deposits with cedents"]
["NLA20","Cash/Deposits Below BBB-",null,"Cash and deposits with cedents"]
["NLA21","Other low",null,"Items not fitting above - value could be realised in near-term with reasonable certainty"," Derivatives will be classified here unless there is a more appropriate bucket."]
["NLA22","Other high",null,"Items not fitting above - high uncertainty over value that could be realised in near-term","Hedge funds will be classified in other on the relevant bucket above eg equity or bonds"]
[]
[null,"Life Asset Split (excluding UKWP / VA / UL ; including surplus assets; including URG/L)"]
["LA1","Bond AAA Under 5 years",null,"Fixed and indexed linked bond securities","Market value"]
["LA2","Bond AA+, AA, AA- Under 5 years",null,"Fixed and indexed linked bond securities","Assume NL under 5 years if no other info"]
["LA3","Bond A+, A, A- Under 5 years",null,"Fixed and indexed linked bond securities","Assume L over 5 years if no other info"]
["LA4","Bond BBB+, BBB, BBB- Under 5 years",null,"Fixed and indexed linked bond securities","If average duration is 5.1 years (say), spread the exposure between \"under 5 years\" and \"over 5 years\" to ensure representative average charge is applied"]
["LA5","Bond Non-invest (< BBB-) & NR Under 5 years",null,"Fixed and indexed linked bond securities","Include covered bonds in relevant bucket, including non-rated"]
["LA23","Bond BB+, BB, BB- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["LA24","Bond B+, B, B- Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["LA25","Bond below B- & NR Under 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket, including non-rated"]
["LA6","Bond AAA Over 5 years",null,"Fixed and indexed linked bond securities","Include government bonds"]
["LA7","Bond AA+, AA, AA- Over 5 years",null,"Fixed and indexed linked bond securities","Affiliates can be entered as bonds if noted in analyst notes"]
["LA8","Bond A+, A, A- Over 5 years",null,"Fixed and indexed linked bond securities","Include covered bonds in relevant bucket"]
["LA9","Bond BBB+, BBB, BBB- Over 5 years",null,"Fixed and indexed linked bond securities","Include covered bonds in relevant bucket"]
["LA10","Bond Non-invest (< BBB-) & NR Over 5 years",null,"Fixed and indexed linked bond securities"," Include covered bonds in relevant bucket, including non-rated"]
["LA26","Bond BB+, BB, BB- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["LA27","Bond B+, B, B- Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket"]
["LA28","Bond below B- & NR Over 5 years",null,"Fixed and indexed linked bond securities and loans excluding mortgages","Include covered bonds in relevant bucket, including non-rated"]
["LA11","Equity low ",null,"Equity - \"developed\" markets","As defined by Fitch  - see Model Definition Document for more details"]
["LA12","Equity high ",null,"Equity - \"emerging markets\" and \"high frontier\" markets","As defined by Fitch  - see Model Definition Document for more details"]
["LA13","Property low ",null,"Property - value could be realised in near-term with reasonable certainty"]
["LA14","Property high ",null,"Property - high uncertainty over value that could be realised in near-term"]
["LA15","Structured/ABS BBB- and above ",null,"Any instrument containing a structured vehicle","CMBS / RMBS / credit card securitisations"]
["LA16","Structured/ABS Below BBB- ",null,"Any instrument containing a structured vehicle"]
["LA17","Mortgages",null,"Secured loans"]
["LA18","Cash/Deposits AA- and above and deposits with cedents",null,"Cash and deposits with cedents"]
["LA19","Cash/Deposits between A+ and BBB-",null,"Cash and deposits with cedents"]
["LA20","Cash/Deposits Below BBB-",null,"Cash and deposits with cedents"]
["LA21","Other low",null,"Items not fitting above - value could be realised in near-term with reasonable certainty"]
["LA22","Other high",null,"Items not fitting above - high uncertainty over value that could be realised in near-term"]
[]
[null,"Other Assets"]
["A1","Counterparty credit risk AA- and above",null,"All items owed to the company subject to credit risk","Including but not limited to reinsurance receivables and reinsurance share of reserves where risk resides with the insurer"]
["A2","Counterparty credit risk between A+ and BBB-",null,"All items owed to the company subject to credit risk","Including but not limited to reinsurance receivables and reinsurance share of reserves where risk resides with the insurer"]
["A3","Counterparty credit risk Below  BBB-",null,"All items owed to the company subject to credit risk","Including but not limited to reinsurance receivables and reinsurance share of reserves where risk resides with the insurer"]
["A4","Tangible assets",null,"Buildings, materials etc"]
["A5","Asset management assets (off balance sheet)",null,"Amount of assets to be charged"]
["C_A6","Charge for off balance sheet assets (excluding asset management assets) (%)",null,"Analyst picks charge based on asset characteristics"]
["A6","Off balance sheet assets (excluding asset management assets)",null,"Analyst picks charge based on banking capital requirements if equity not removed or risk not adequately accounted for through charges on assets"]
["C_A7","Charge on all banking assets - set by analyst (%)",null,"Exposure for the charge above","Can be 0% if bank equity was identified/estimated and excluded from AC or if the assets are charged in the asset charge"]
["A7","Banking assets charged in model",null,"Amount of assets to be charged"]
["A8","Assets exposed to currency risk",null,"Net asset value in foreign currency(ies)"]
["C_A8","Charge for currency risk",null,"Analyst picks charge based on risk and currency","Based on volatility of the relevant exchange rate(s)"]
[]
["ç Back"]

{"sheet":"Calculations","index":4,"n_rows":259,"n_cols":19,"rows_kept":259,"cut":false,"hidden":true,"merged":[[6,13,6,17]]}
[{"$f":"Input!A1","v":"Insurance | Prism Factor-Based Capital Model"}]
[null,"Calculations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[]
[]
[]
[null,1,{"$f":"MIN(IF($N$38:$S$38>$B$7,$N$39:$S$39))","v":1},5,{"$f":"MIN($C$7:$D$7)","v":1},null,null,null,null,null,null,null,null,"Risk charge"]
[null,"Capital Model Result",{"$f":"INDEX($D8:$I8,$C$7)","v":"Extremely Strong"},"Extremely Strong","Very Strong","Strong","Adequate","Somewhat weak","Weak",null,null,null,"Net Reserves / Premium / MV","Extremely Strong","Very Strong","Strong","Adequate","Somewhat weak"]
[null,{"$f":"\"Life Capital\"  & \" (\" & Currency&\" \"& TEXT(C9,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"SUM(C10:C17)","v":0},{"$f":"SUM(D10:D17)","v":0},{"$f":"SUM(E10:E17)","v":0},0,0,0,null,null,null,"Life"]
[null,{"$f":"\"Unit linked\"  & \"(\" & Currency&\" \"& TEXT(C10,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"INDEX($D10:$H10,$E$7)","v":0},{"$f":"Calculations!$M10*'Model Factors'!D82","v":0},{"$f":"Calculations!$M10*'Model Factors'!E82","v":0},{"$f":"Calculations!$M10*'Model Factors'!F82","v":0},{"$f":"Calculations!$M10*'Model Factors'!G82","v":0},{"$f":"Calculations!$M10*'Model Factors'!H82","v":0},null,null,null,"Unit linked ",{"$f":"Input!D120","v":0},{"$f":"IF($S10,\"\",D10/Calculations!$M10)","v":""},{"$f":"IF($S10,\"\",E10/Calculations!$M10)","v":""},{"$f":"IF($S10,\"\",F10/Calculations!$M10)","v":""},{"$f":"IF($S10,\"\",G10/Calculations!$M10)","v":""},{"$f":"IF($S10,\"\",H10/Calculations!$M10)","v":""},{"$f":"Calculations!$M10=0","v":true}]
[null,{"$f":"\"Variable annuities\"  & \"\n(\" & Currency&\" \"&  TEXT(C11,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D121*'Model Factors'!D83+Input!$D122*'Model Factors'!D84+Input!$D123*'Model Factors'!D85","v":0},{"$f":"Input!$D121*'Model Factors'!E83+Input!$D122*'Model Factors'!E84+Input!$D123*'Model Factors'!E85","v":0},{"$f":"Input!$D121*'Model Factors'!F83+Input!$D122*'Model Factors'!F84+Input!$D123*'Model Factors'!F85","v":0},{"$f":"Input!$D121*'Model Factors'!G83+Input!$D122*'Model Factors'!G84+Input!$D123*'Model Factors'!G85","v":0},{"$f":"Input!$D121*'Model Factors'!H83+Input!$D122*'Model Factors'!H84+Input!$D123*'Model Factors'!H85","v":0},null,null,null,"Variable annuities",{"$f":"SUM(Input!D121:D123)","v":0},{"$f":"IF($S11,\"\",D11/Calculations!$M11)","v":""},{"$f":"IF($S11,\"\",E11/Calculations!$M11)","v":""},{"$f":"IF($S11,\"\",F11/Calculations!$M11)","v":""},{"$f":"IF($S11,\"\",G11/Calculations!$M11)","v":""},{"$f":"IF($S11,\"\",H11/Calculations!$M11)","v":""},{"$f":"Calculations!$M11=0","v":true}]
[null,{"$f":"\"Participating product reserves (UK)\"  & \"\n(\" & Currency&\" \"&  TEXT(C12,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D124*'Model Factors'!D86+Input!$D125*'Model Factors'!D87+Input!$D126*'Model Factors'!D88","v":0},{"$f":"Input!$D124*'Model Factors'!E86+Input!$D125*'Model Factors'!E87+Input!$D126*'Model Factors'!E88","v":0},{"$f":"Input!$D124*'Model Factors'!F86+Input!$D125*'Model Factors'!F87+Input!$D126*'Model Factors'!F88","v":0},{"$f":"Input!$D124*'Model Factors'!G86+Input!$D125*'Model Factors'!G87+Input!$D126*'Model Factors'!G88","v":0},{"$f":"Input!$D124*'Model Factors'!H86+Input!$D125*'Model Factors'!H87+Input!$D126*'Model Factors'!H88","v":0},null,null,null,"Participating product reserves (LG)",{"$f":"SUM(Input!D124:D126)","v":0},{"$f":"IF($S12,\"\",D12/Calculations!$M12)","v":""},{"$f":"IF($S12,\"\",E12/Calculations!$M12)","v":""},{"$f":"IF($S12,\"\",F12/Calculations!$M12)","v":""},{"$f":"IF($S12,\"\",G12/Calculations!$M12)","v":""},{"$f":"IF($S12,\"\",H12/Calculations!$M12)","v":""},{"$f":"Calculations!$M12=0","v":true}]
[null,{"$f":"\"Participating product reserves (EU)\"  & \"\n(\" & Currency&\" \"&  TEXT(C13,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D127*'Model Factors'!D89+Input!$D128*'Model Factors'!D90+Input!$D129*'Model Factors'!D91","v":0},{"$f":"Input!$D127*'Model Factors'!E89+Input!$D128*'Model Factors'!E90+Input!$D129*'Model Factors'!E91","v":0},{"$f":"Input!$D127*'Model Factors'!F89+Input!$D128*'Model Factors'!F90+Input!$D129*'Model Factors'!F91","v":0},{"$f":"Input!$D127*'Model Factors'!G89+Input!$D128*'Model Factors'!G90+Input!$D129*'Model Factors'!G91","v":0},{"$f":"Input!$D127*'Model Factors'!H89+Input!$D128*'Model Factors'!H90+Input!$D129*'Model Factors'!H91","v":0},null,null,null,"Participating product reserves (HG)",{"$f":"SUM(Input!D127:D129)","v":0},{"$f":"IF($S13,\"\",D13/Calculations!$M13)","v":""},{"$f":"IF($S13,\"\",E13/Calculations!$M13)","v":""},{"$f":"IF($S13,\"\",F13/Calculations!$M13)","v":""},{"$f":"IF($S13,\"\",G13/Calculations!$M13)","v":""},{"$f":"IF($S13,\"\",H13/Calculations!$M13)","v":""},{"$f":"Calculations!$M13=0","v":true}]
[null,{"$f":"\"Protection (inc reinsurance)\"  & \"\n(\" & Currency&\" \"&  TEXT(C14,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!$M14*'Model Factors'!D92","v":0},{"$f":"Calculations!$M14*'Model Factors'!E92","v":0},{"$f":"Calculations!$M14*'Model Factors'!F92","v":0},{"$f":"Calculations!$M14*'Model Factors'!G92","v":0},{"$f":"Calculations!$M14*'Model Factors'!H92","v":0},null,null,null,"Protection ",{"$f":"Input!D130","v":0},{"$f":"IF($S14,\"\",D14/Calculations!$M14)","v":""},{"$f":"IF($S14,\"\",E14/Calculations!$M14)","v":""},{"$f":"IF($S14,\"\",F14/Calculations!$M14)","v":""},{"$f":"IF($S14,\"\",G14/Calculations!$M14)","v":""},{"$f":"IF($S14,\"\",H14/Calculations!$M14)","v":""},{"$f":"Calculations!$M14=0","v":true}]
[null,{"$f":"\"UK style annuities NP bonds etc\"  & \"\n(\" & Currency&\" \"&  TEXT(C15,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!$M15*'Model Factors'!D93","v":0},{"$f":"Calculations!$M15*'Model Factors'!E93","v":0},{"$f":"Calculations!$M15*'Model Factors'!F93","v":0},{"$f":"Calculations!$M15*'Model Factors'!G93","v":0},{"$f":"Calculations!$M15*'Model Factors'!H93","v":0},null,null,null,"UK style annuities NP bonds etc",{"$f":"Input!D131","v":0},{"$f":"IF($S15,\"\",D15/Calculations!$M15)","v":""},{"$f":"IF($S15,\"\",E15/Calculations!$M15)","v":""},{"$f":"IF($S15,\"\",F15/Calculations!$M15)","v":""},{"$f":"IF($S15,\"\",G15/Calculations!$M15)","v":""},{"$f":"IF($S15,\"\",H15/Calculations!$M15)","v":""},{"$f":"Calculations!$M15=0","v":true}]
[null,{"$f":"\"Non-proportional reinsurance \"  & \"\n(\" & Currency&\" \"&  TEXT(C16,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!$M16*'Model Factors'!D94","v":0},{"$f":"Calculations!$M16*'Model Factors'!E94","v":0},{"$f":"Calculations!$M16*'Model Factors'!F94","v":0},{"$f":"Calculations!$M16*'Model Factors'!G94","v":0},{"$f":"Calculations!$M16*'Model Factors'!H94","v":0},null,null,null,"Life non-prop reinsurance",{"$f":"Input!D132","v":0},{"$f":"IF($S16,\"\",D16/Calculations!$M16)","v":""},{"$f":"IF($S16,\"\",E16/Calculations!$M16)","v":""},{"$f":"IF($S16,\"\",F16/Calculations!$M16)","v":""},{"$f":"IF($S16,\"\",G16/Calculations!$M16)","v":""},{"$f":"IF($S16,\"\",H16/Calculations!$M16)","v":""},{"$f":"Calculations!$M16=0","v":true}]
[null,{"$f":"\"Life Asset Risk \"  & \"\n(\" & Currency&\" \"&  TEXT(C17,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!E107","v":0},{"$f":"Calculations!E129","v":0},{"$f":"Calculations!E151","v":0},{"$f":"Calculations!E173","v":0},{"$f":"Calculations!E195","v":0},null,null,null,"Life Asset Risk",{"$f":"Input!D145","v":0},{"$f":"IF($S17,\"\",D17/Calculations!$M17)","v":""},{"$f":"IF($S17,\"\",E17/Calculations!$M17)","v":""},{"$f":"IF($S17,\"\",F17/Calculations!$M17)","v":""},{"$f":"IF($S17,\"\",G17/Calculations!$M17)","v":""},{"$f":"IF($S17,\"\",H17/Calculations!$M17)","v":""},{"$f":"Calculations!$M17=0","v":true}]
[null,{"$f":"\"Non-Life Capital\"  & \" (\" & Currency&\" \"& TEXT(C18,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"SUM(C19:C31)","v":0},{"$f":"SUM(D19:D31)","v":0},0,0,0,0,null,null,null,"Non-life"]
[null,{"$f":"\"Motor\"  & \"\n(\" & Currency&\" \"&  TEXT(C19,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"INDEX($D19:$H19,$E$7)","v":0},{"$f":"Input!$D69*(Input!$D$65-Input!$D$66)*'Model Factors'!D48+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D101*'Model Factors'!D70","v":0},{"$f":"Input!$D69*(Input!$D$65-Input!$D$66)*'Model Factors'!E48+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D101*'Model Factors'!E70","v":0},{"$f":"Input!$D69*(Input!$D$65-Input!$D$66)*'Model Factors'!F48+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D101*'Model Factors'!F70","v":0},{"$f":"Input!$D69*(Input!$D$65-Input!$D$66)*'Model Factors'!G48+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D101*'Model Factors'!G70","v":0},{"$f":"Input!$D69*(Input!$D$65-Input!$D$66)*'Model Factors'!H48+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D101*'Model Factors'!H70","v":0},null,null,null,"Motor",{"$f":"Input!D69*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S19,\"\",D19/Calculations!$M19)","v":""},{"$f":"IF($S19,\"\",E19/Calculations!$M19)","v":""},{"$f":"IF($S19,\"\",F19/Calculations!$M19)","v":""},{"$f":"IF($S19,\"\",G19/Calculations!$M19)","v":""},{"$f":"IF($S19,\"\",H19/Calculations!$M19)","v":""},{"$f":"Calculations!$M19=0","v":true}]
[null,{"$f":"\"Property\"  & \"\n(\" & Currency&\" \"&  TEXT(C20,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D70*(Input!$D$65-Input!$D$66)*'Model Factors'!D49+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D102*'Model Factors'!D71","v":0},{"$f":"Input!$D70*(Input!$D$65-Input!$D$66)*'Model Factors'!E49+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D102*'Model Factors'!E71","v":0},{"$f":"Input!$D70*(Input!$D$65-Input!$D$66)*'Model Factors'!F49+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D102*'Model Factors'!F71","v":0},{"$f":"Input!$D70*(Input!$D$65-Input!$D$66)*'Model Factors'!G49+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D102*'Model Factors'!G71","v":0},{"$f":"Input!$D70*(Input!$D$65-Input!$D$66)*'Model Factors'!H49+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D102*'Model Factors'!H71","v":0},null,null,null,"Property",{"$f":"Input!D70*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S20,\"\",D20/Calculations!$M20)","v":""},{"$f":"IF($S20,\"\",E20/Calculations!$M20)","v":""},{"$f":"IF($S20,\"\",F20/Calculations!$M20)","v":""},{"$f":"IF($S20,\"\",G20/Calculations!$M20)","v":""},{"$f":"IF($S20,\"\",H20/Calculations!$M20)","v":""},{"$f":"Calculations!$M20=0","v":true}]
[null,{"$f":"\"Liability\"  & \"\n(\" & Currency&\" \"&  TEXT(C21,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D71*(Input!$D$65-Input!$D$66)*'Model Factors'!D50+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D103*'Model Factors'!D72","v":0},{"$f":"Input!$D71*(Input!$D$65-Input!$D$66)*'Model Factors'!E50+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D103*'Model Factors'!E72","v":0},{"$f":"Input!$D71*(Input!$D$65-Input!$D$66)*'Model Factors'!F50+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D103*'Model Factors'!F72","v":0},{"$f":"Input!$D71*(Input!$D$65-Input!$D$66)*'Model Factors'!G50+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D103*'Model Factors'!G72","v":0},{"$f":"Input!$D71*(Input!$D$65-Input!$D$66)*'Model Factors'!H50+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D103*'Model Factors'!H72","v":0},null,null,null,"Liability",{"$f":"Input!D71*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S21,\"\",D21/Calculations!$M21)","v":""},{"$f":"IF($S21,\"\",E21/Calculations!$M21)","v":""},{"$f":"IF($S21,\"\",F21/Calculations!$M21)","v":""},{"$f":"IF($S21,\"\",G21/Calculations!$M21)","v":""},{"$f":"IF($S21,\"\",H21/Calculations!$M21)","v":""},{"$f":"Calculations!$M21=0","v":true}]
[null,{"$f":"\"Marine, aviation and transport\"  & \"\n(\" & Currency&\" \"&  TEXT(C22,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D72*(Input!$D$65-Input!$D$66)*'Model Factors'!D51+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D104*'Model Factors'!D73","v":0},{"$f":"Input!$D72*(Input!$D$65-Input!$D$66)*'Model Factors'!E51+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D104*'Model Factors'!E73","v":0},{"$f":"Input!$D72*(Input!$D$65-Input!$D$66)*'Model Factors'!F51+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D104*'Model Factors'!F73","v":0},{"$f":"Input!$D72*(Input!$D$65-Input!$D$66)*'Model Factors'!G51+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D104*'Model Factors'!G73","v":0},{"$f":"Input!$D72*(Input!$D$65-Input!$D$66)*'Model Factors'!H51+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D104*'Model Factors'!H73","v":0},null,null,null,"Marine, aviation and transport",{"$f":"Input!D72*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S22,\"\",D22/Calculations!$M22)","v":""},{"$f":"IF($S22,\"\",E22/Calculations!$M22)","v":""},{"$f":"IF($S22,\"\",F22/Calculations!$M22)","v":""},{"$f":"IF($S22,\"\",G22/Calculations!$M22)","v":""},{"$f":"IF($S22,\"\",H22/Calculations!$M22)","v":""},{"$f":"Calculations!$M22=0","v":true}]
[null,{"$f":"\"Credit Insurance \"  & \"\n(\" & Currency&\" \"&  TEXT(C23,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D73*(Input!$D$65-Input!$D$66)*'Model Factors'!D52+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D105*'Model Factors'!D74","v":0},{"$f":"Input!$D73*(Input!$D$65-Input!$D$66)*'Model Factors'!E52+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D105*'Model Factors'!E74","v":0},{"$f":"Input!$D73*(Input!$D$65-Input!$D$66)*'Model Factors'!F52+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D105*'Model Factors'!F74","v":0},{"$f":"Input!$D73*(Input!$D$65-Input!$D$66)*'Model Factors'!G52+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D105*'Model Factors'!G74","v":0},{"$f":"Input!$D73*(Input!$D$65-Input!$D$66)*'Model Factors'!H52+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D105*'Model Factors'!H74","v":0},null,null,null,"Credit Insurance ",{"$f":"Input!D73*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S23,\"\",D23/Calculations!$M23)","v":""},{"$f":"IF($S23,\"\",E23/Calculations!$M23)","v":""},{"$f":"IF($S23,\"\",F23/Calculations!$M23)","v":""},{"$f":"IF($S23,\"\",G23/Calculations!$M23)","v":""},{"$f":"IF($S23,\"\",H23/Calculations!$M23)","v":""},{"$f":"Calculations!$M23=0","v":true}]
[null,{"$f":"\"Accident and health \"  & \"\n(\" & Currency&\" \"&  TEXT(C24,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D74*(Input!$D$65-Input!$D$66)*'Model Factors'!D53+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D106*'Model Factors'!D75","v":0},{"$f":"Input!$D74*(Input!$D$65-Input!$D$66)*'Model Factors'!E53+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D106*'Model Factors'!E75","v":0},{"$f":"Input!$D74*(Input!$D$65-Input!$D$66)*'Model Factors'!F53+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D106*'Model Factors'!F75","v":0},{"$f":"Input!$D74*(Input!$D$65-Input!$D$66)*'Model Factors'!G53+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D106*'Model Factors'!G75","v":0},{"$f":"Input!$D74*(Input!$D$65-Input!$D$66)*'Model Factors'!H53+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D106*'Model Factors'!H75","v":0},null,null,null,"Accident and health ",{"$f":"Input!D74*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S24,\"\",D24/Calculations!$M24)","v":""},{"$f":"IF($S24,\"\",E24/Calculations!$M24)","v":""},{"$f":"IF($S24,\"\",F24/Calculations!$M24)","v":""},{"$f":"IF($S24,\"\",G24/Calculations!$M24)","v":""},{"$f":"IF($S24,\"\",H24/Calculations!$M24)","v":""},{"$f":"Calculations!$M24=0","v":true}]
[null,{"$f":"\"Financial risks \"  & \"\n(\" & Currency&\" \"&  TEXT(C25,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D75*(Input!$D$65-Input!$D$66)*'Model Factors'!D54+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D107*'Model Factors'!D76","v":0},{"$f":"Input!$D75*(Input!$D$65-Input!$D$66)*'Model Factors'!E54+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D107*'Model Factors'!E76","v":0},{"$f":"Input!$D75*(Input!$D$65-Input!$D$66)*'Model Factors'!F54+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D107*'Model Factors'!F76","v":0},{"$f":"Input!$D75*(Input!$D$65-Input!$D$66)*'Model Factors'!G54+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D107*'Model Factors'!G76","v":0},{"$f":"Input!$D75*(Input!$D$65-Input!$D$66)*'Model Factors'!H54+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D107*'Model Factors'!H76","v":0},null,null,null,"Financial risks ",{"$f":"Input!D75*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S25,\"\",D25/Calculations!$M25)","v":""},{"$f":"IF($S25,\"\",E25/Calculations!$M25)","v":""},{"$f":"IF($S25,\"\",F25/Calculations!$M25)","v":""},{"$f":"IF($S25,\"\",G25/Calculations!$M25)","v":""},{"$f":"IF($S25,\"\",H25/Calculations!$M25)","v":""},{"$f":"Calculations!$M25=0","v":true}]
[null,{"$f":"\"Non-proportional reinsurance \"  & \"\n(\" & Currency&\" \"&  TEXT(C26,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D76*(Input!$D$65-Input!$D$66)*'Model Factors'!D55+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D108*'Model Factors'!D77","v":0},{"$f":"Input!$D76*(Input!$D$65-Input!$D$66)*'Model Factors'!E55+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D108*'Model Factors'!E77","v":0},{"$f":"Input!$D76*(Input!$D$65-Input!$D$66)*'Model Factors'!F55+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D108*'Model Factors'!F77","v":0},{"$f":"Input!$D76*(Input!$D$65-Input!$D$66)*'Model Factors'!G55+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D108*'Model Factors'!G77","v":0},{"$f":"Input!$D76*(Input!$D$65-Input!$D$66)*'Model Factors'!H55+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D108*'Model Factors'!H77","v":0},null,null,null,"Non-proportional reinsurance ",{"$f":"Input!D76*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S26,\"\",D26/Calculations!$M26)","v":""},{"$f":"IF($S26,\"\",E26/Calculations!$M26)","v":""},{"$f":"IF($S26,\"\",F26/Calculations!$M26)","v":""},{"$f":"IF($S26,\"\",G26/Calculations!$M26)","v":""},{"$f":"IF($S26,\"\",H26/Calculations!$M26)","v":""},{"$f":"Calculations!$M26=0","v":true}]
[null,{"$f":"\"Other high\"  & \"\n(\" & Currency&\" \"&  TEXT(C27,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D77*(Input!$D$65-Input!$D$66)*'Model Factors'!D56+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D109*'Model Factors'!D78","v":0},{"$f":"Input!$D77*(Input!$D$65-Input!$D$66)*'Model Factors'!E56+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D109*'Model Factors'!E78","v":0},{"$f":"Input!$D77*(Input!$D$65-Input!$D$66)*'Model Factors'!F56+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D109*'Model Factors'!F78","v":0},{"$f":"Input!$D77*(Input!$D$65-Input!$D$66)*'Model Factors'!G56+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D109*'Model Factors'!G78","v":0},{"$f":"Input!$D77*(Input!$D$65-Input!$D$66)*'Model Factors'!H56+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D109*'Model Factors'!H78","v":0},null,null,null,"Other high",{"$f":"Input!D77*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S27,\"\",D27/Calculations!$M27)","v":""},{"$f":"IF($S27,\"\",E27/Calculations!$M27)","v":""},{"$f":"IF($S27,\"\",F27/Calculations!$M27)","v":""},{"$f":"IF($S27,\"\",G27/Calculations!$M27)","v":""},{"$f":"IF($S27,\"\",H27/Calculations!$M27)","v":""},{"$f":"Calculations!$M27=0","v":true}]
[null,{"$f":"\"Other low\"  & \"\n(\" & Currency&\" \"&  TEXT(C28,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!$D78*(Input!$D$65-Input!$D$66)*'Model Factors'!D57+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D110*'Model Factors'!D79","v":0},{"$f":"Input!$D78*(Input!$D$65-Input!$D$66)*'Model Factors'!E57+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D110*'Model Factors'!E79","v":0},{"$f":"Input!$D78*(Input!$D$65-Input!$D$66)*'Model Factors'!F57+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D110*'Model Factors'!F79","v":0},{"$f":"Input!$D78*(Input!$D$65-Input!$D$66)*'Model Factors'!G57+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D110*'Model Factors'!G79","v":0},{"$f":"Input!$D78*(Input!$D$65-Input!$D$66)*'Model Factors'!H57+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D110*'Model Factors'!H79","v":0},null,null,null,"Other low",{"$f":"Input!D78*(Input!D$65-Input!D66)","v":0},{"$f":"IF($S28,\"\",D28/Calculations!$M28)","v":""},{"$f":"IF($S28,\"\",E28/Calculations!$M28)","v":""},{"$f":"IF($S28,\"\",F28/Calculations!$M28)","v":""},{"$f":"IF($S28,\"\",G28/Calculations!$M28)","v":""},{"$f":"IF($S28,\"\",H28/Calculations!$M28)","v":""},{"$f":"Calculations!$M28=0","v":true}]
[null,{"$f":"\"Analyst adjustment\"  & \"\n(\" & Currency&\" \"&  TEXT(C29,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Input!D81*(Input!D$65-Input!D66)+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D113","v":0},{"$f":"(Input!$D$65-Input!$D$66)*Input!$D$81+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D$113","v":0},{"$f":"(Input!$D$65-Input!$D$66)*Input!$D$81+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D$113","v":0},{"$f":"(Input!$D$65-Input!$D$66)*Input!$D$81+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D$113","v":0},{"$f":"(Input!$D$65-Input!$D$66)*Input!$D$81+(Input!$D$98-SUM(Calculations!$E$70:$E$72))*Input!$D$113","v":0},null,null,null,"Analyst adjustment",{"$f":"IF((Input!D81+Input!D113)=0,0,SUM(M19:M28))","v":0},{"$f":"IF($S29,\"\",D29/Calculations!$M29)","v":""},{"$f":"IF($S29,\"\",E29/Calculations!$M29)","v":""},{"$f":"IF($S29,\"\",F29/Calculations!$M29)","v":""},{"$f":"IF($S29,\"\",G29/Calculations!$M29)","v":""},{"$f":"IF($S29,\"\",H29/Calculations!$M29)","v":""},{"$f":"Calculations!$M29=0","v":true}]
[null,{"$f":"\"Cat risk\"  & \"\n(\" & Currency&\" \"&  TEXT(C30,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!E99","v":0},{"$f":"Calculations!E121","v":0},{"$f":"Calculations!E143","v":0},{"$f":"Calculations!E165","v":0},{"$f":"Calculations!E187","v":0},null,null,null,"Cat risk",{"$f":"Input!D66","v":0},{"$f":"IF($S30,\"\",D30/Calculations!$M30)","v":""},{"$f":"IF($S30,\"\",E30/Calculations!$M30)","v":""},{"$f":"IF($S30,\"\",F30/Calculations!$M30)","v":""},{"$f":"IF($S30,\"\",G30/Calculations!$M30)","v":""},{"$f":"IF($S30,\"\",H30/Calculations!$M30)","v":""},{"$f":"Calculations!$M30=0","v":true}]
[null,{"$f":"\"Non Life Asset Risk\"  & \"\n(\" & Currency&\" \"&  TEXT(C31,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},0,{"$f":"Calculations!E101","v":0},{"$f":"Calculations!E123","v":0},{"$f":"Calculations!E145","v":0},{"$f":"Calculations!E167","v":0},{"$f":"Calculations!E189","v":0},null,null,null,"Non-Life Asset Risk",{"$f":"Input!D137","v":0},{"$f":"IF($S31,\"\",D31/Calculations!$M31)","v":""},{"$f":"IF($S31,\"\",E31/Calculations!$M31)","v":""},{"$f":"IF($S31,\"\",F31/Calculations!$M31)","v":""},{"$f":"IF($S31,\"\",G31/Calculations!$M31)","v":""},{"$f":"IF($S31,\"\",H31/Calculations!$M31)","v":""},{"$f":"Calculations!$M31=0","v":true}]
[null,"Other",0,{"$f":"SUM(Calculations!E102:'Calculations'!E105)","v":0},{"$f":"SUM(Calculations!E124:'Calculations'!E127)","v":0},{"$f":"SUM(Calculations!E146:'Calculations'!E149)","v":0},{"$f":"SUM(Calculations!E168:'Calculations'!E171)","v":0},{"$f":"SUM(Calculations!E190:'Calculations'!E193)","v":0}]
[null,"Reporting Risk Add-on",null,{"$f":"Calculations!E108","v":0},{"$f":"Calculations!E130","v":0},{"$f":"Calculations!E152","v":0},{"$f":"Calculations!E174","v":0},{"$f":"Calculations!E196","v":0}]
[null,"Undiversified target capital",null,{"$f":"D9+D18+SUM(D32:D33)","v":0},0,0,0,0,null,null,null,"Undiversified target capital",{"$f":"SUM($M$10:$M$17)+SUM($M$19:$M$31)-$M$29","v":0},{"$f":"IF($S$34,\"\",D$34/$M$34)","v":""},{"$f":"IF($S$34,\"\",E$34/$M$34)","v":""},{"$f":"IF($S$34,\"\",F$34/$M$34)","v":""},{"$f":"IF($S$34,\"\",G$34/$M$34)","v":""},{"$f":"IF($S$34,\"\",H$34/$M$34)","v":""},{"$f":"$M$34=0","v":true}]
[null,"Diversification benefit",null,{"$f":"SUM(Calculations!E112:E115)","v":0},{"$f":"$D$35","v":0},0,0,0,null,null,null,"Diversification benefit",null,{"$f":"IF(D34=0,\"\",D35/D34)","v":""},"","","",""]
[null,"Total target capital",null,{"$f":"SUM(D34:D35)","v":0},0,0,0,0,null,null,null,"Total target capital",{"$f":"M34","v":0},{"$f":"IF($S$36,\"\",D$36/$M$36)","v":""},{"$f":"IF($S$36,\"\",E$36/$M$36)","v":""},{"$f":"IF($S$36,\"\",F$36/$M$36)","v":""},{"$f":"IF($S$36,\"\",G$36/$M$36)","v":""},{"$f":"IF($S$36,\"\",H$36/$M$36)","v":""},{"$f":"$M$36=0","v":true}]
[null,"Base available capital",null,null,null,null,null,null,null,null,null,"Base available capital",{"$f":"Calculations!E80","v":0}]
[null,"Available Capital / Target Capital",null,null,null,null,null,null,null,null,null,"Available Capital / Target Capital",null,{"$f":"IF(D$36=0,\"\",$M$37/D$36)","v":""},"","","","",1.0001]
[null,"Life",{"$f":"SUM(C10:C16)","v":0},0,0,0,0,0,null,null,null,null,null,1,2,3,4,5,6]
[null,"Non-Life",{"$f":"SUM(C19:C30)","v":0},0,0,0,0,0]
[null,"Asset",{"$f":"SUM(C17,C31)","v":0},{"$f":"D17+D31","v":0},{"$f":"E17+E31","v":0},{"$f":"F17+F31","v":0},{"$f":"G17+G31","v":0},{"$f":"H17+H31","v":0}]
[null,"Other",{"$f":"INDEX($D42:$H42,$E$7)","v":0},{"$f":"D29+D32+Calculations!E108","v":0},{"$f":"E29+E32+Calculations!E130","v":0},{"$f":"F29+F32+Calculations!E152","v":0},{"$f":"G29+G32+Calculations!E174","v":0},{"$f":"H29+H32+Calculations!E196","v":0}]
[null,"Div ben",{"$f":"SUM(Calculations!E112:E115)","v":0},{"$f":"$C$43","v":0},{"$f":"$C$43","v":0},{"$f":"$C$43","v":0},{"$f":"$C$43","v":0},{"$f":"$C$43","v":0}]
[null,"Div cap",{"$f":"SUM(C39:C43)","v":0},0,0,0,0,0]
[]
[null,"Available Capital"]
[]
[]
[null,"Total Available Capital","Exposure","Credit","AC"]
[null,"Equity",{"$f":"Input!D26","v":0},{"$f":"'Model Factors'!D9","v":1},{"$f":"D50*C50","v":0}]
[null,"Equity assumed to support banking entities",{"$f":"Input!D27","v":0},{"$f":"'Model Factors'!D10","v":-1},{"$f":"D51*C51","v":0}]
[null,"Minority interests",{"$f":"Input!D28","v":0},{"$f":"'Model Factors'!D11","v":1},0]
[null,"Life deferred acquisition costs (adjusted for tax)",{"$f":"Input!D31","v":0},{"$f":"'Model Factors'!D12","v":-1},{"$f":"D53*C53","v":0}]
[null,"Value of business acquired",{"$f":"Input!D32","v":0},{"$f":"'Model Factors'!D13","v":-1},{"$f":"D54*C54","v":0}]
[null,"Goodwill",{"$f":"Input!D33","v":0},{"$f":"'Model Factors'!D14","v":-1},0]
[null,"Other intangible assets",{"$f":"Input!D34","v":0},{"$f":"'Model Factors'!D15","v":-1},0]
[null,"Subordinated debt - 0% equity credit",{"$f":"Input!D35","v":0},{"$f":"'Model Factors'!D16","v":0},0]
[null,"Subordinated debt - 50% equity credit",{"$f":"Input!D36","v":0},{"$f":"'Model Factors'!D17","v":0.5},0]
[null,"Subordinated debt - 100% equity credit",{"$f":"Input!D37","v":0},{"$f":"'Model Factors'!D18","v":1},0,{"$f":"SUM($E$57:$E$59)","v":0}]
[null,"Preference shares",{"$f":"Input!D38","v":0},{"$f":"'Model Factors'!D19","v":1},0]
[null,"Equalisation reserve (if not in SH equity)",{"$f":"Input!D39","v":0},{"$f":"'Model Factors'!D20","v":1},{"$f":"D61*C61","v":0}]
[null,"Off balance sheet unrealised gain (loss) bonds",{"$f":"Input!D40","v":0},{"$f":"'Model Factors'!D21","v":0},0]
[null,"Off balance sheet unrealised gain (loss) property",{"$f":"Input!D42","v":0},{"$f":"'Model Factors'!D22","v":0},0]
[null,"Off balance sheet unrealised gain (loss) shares / affiliates",{"$f":"Input!D44","v":0},{"$f":"'Model Factors'!D23","v":0},0]
[null,"Off balance sheet unrealised gain (loss) other",{"$f":"Input!D46","v":0},{"$f":"'Model Factors'!D24","v":0},0]
[null,"On balance sheet unrealised gain (loss) bonds",{"$f":"Input!D48","v":0},{"$f":"'Model Factors'!D25","v":0},{"$f":"D66*C66","v":0}]
[null,"Life - other technical provisions 0% (buffers) ",{"$f":"Input!D50","v":0},{"$f":"'Model Factors'!D26","v":0},0]
[null,"Life - other technical provisions 50% (buffers) ",{"$f":"Input!D51","v":0},{"$f":"'Model Factors'!D27","v":0.5},0]
[null,"Life - other technical provisions 100% (buffers) ",{"$f":"Input!D52","v":0},{"$f":"'Model Factors'!D28","v":1},0]
[null,"Non-life reserve redundancies - 0% credit",{"$f":"Input!D53","v":0},{"$f":"'Model Factors'!D29","v":0},0]
[null,"Non-life reserve redundancies - 50% credit",{"$f":"Input!D54","v":0},{"$f":"'Model Factors'!D30","v":0.5},0]
[null,"Non-life reserve redundancies - 100% credit",{"$f":"Input!D55","v":0},{"$f":"'Model Factors'!D31","v":1},0]
[null,"VIF",{"$f":"Input!D56","v":0},{"$f":"'Model Factors'!D32","v":0},{"$f":"D73*C73","v":0}]
[null,"Dividend to be paid not on balance sheet (enter as negative number)",{"$f":"Input!D58","v":0},{"$f":"'Model Factors'!D33","v":1},0]
[null,"Additional items counting for Fitch Core Capital",{"$f":"Input!D60","v":0},{"$f":"'Model Factors'!D34","v":1},0]
[null,"Additional items counting for total available capital",{"$f":"Input!D61","v":0},{"$f":"'Model Factors'!D35","v":1},{"$f":"D76*C76","v":0}]
[null,"Contractual Service Margin (CSM)",{"$f":"Input!D29","v":0},{"$f":"1-Input!D30","v":1},0,{"$f":"SUM($E$50:$E$77)","v":0}]
[null,"Cap on hybrids @ 20% TAC",null,null,{"$f":"IF(Input!$D$59<>'Output Generation'!$L$23,0,IF($F$77<>0,IF($F$59/$F$77>HybridCap,-1*($F$59-HybridCap*$F$77),0),0))","v":0}]
[]
[null,"Total available capital",null,null,{"$f":"SUM(E50:E78)","v":0}]
[]
[]
[null,"\"Fitch Core Capital\" ","Exposure","Credit","AC"]
[null,"Total Available Capital",{"$f":"E80","v":0},{"$f":"'Model Factors'!D38","v":1},{"$f":"C84*D84","v":0}]
[null,"VIF - Market consistent (MCEV)",{"$f":"Input!D56","v":0},{"$f":"'Model Factors'!D39","v":0},{"$f":"D85*C85","v":0}]
[null,"Subordinated debt - 0% equity credit",{"$f":"Input!D35","v":0},{"$f":"'Model Factors'!D40","v":0},0]
[null,"Subordinated debt - 50% equity credit",{"$f":"Input!D36","v":0},{"$f":"'Model Factors'!D41","v":-0.5},0]
[null,"Subordinated debt - 100% equity credit",{"$f":"Input!D37","v":0},{"$f":"'Model Factors'!D42","v":-1},0]
[null,"Additional items counting for total available capital",{"$f":"C76","v":0},{"$f":"'Model Factors'!D43","v":-1},{"$f":"D89*C89","v":0}]
[null,"Contractual Service Margin (CSM)",{"$f":"+C77","v":0},{"$f":"-D77","v":-1},0]
[null,"Remove cap",null,null,{"$f":"-E78","v":0}]
[]
[null,"\"Fitch Core Capital\" ",null,null,{"$f":"SUM(E84:E91)","v":0}]
[]
[null,"Target Capital"]
[]
[null,"Target Capital - Extremely Strong","Exposure","Charge","TC","AC / TC"]
[null,"Non-life Premium risk",{"$f":"Input!D$65-Input!D66","v":0},{"$f":"SUMPRODUCT(Input!D$69:D$78,'Model Factors'!$D$48:$D$57)+Input!D$81","v":0},{"$f":"D98*C98","v":0}]
[null,"Non-life Property Cat risk",{"$f":"SUM(Input!$D$85:$D$88)","v":0},{"$f":"IF($G$99<>0,$H$99/$G$99,0)","v":0},{"$f":"D99*C99+Input!D90*'Model Factors'!D67","v":0},null,{"$f":"SUM(Input!D$85:D$88)","v":0},{"$f":"SUMPRODUCT(Input!D$85:D$88,'Model Factors'!$D$60:$D$63)","v":0}]
[null,"Non-life Reserve risk",{"$f":"Input!D$98-SUM(E70:E72)","v":0},{"$f":"SUMPRODUCT(Input!D$101:D$110,'Model Factors'!$D$70:$D$79)+Input!D$113","v":0},0]
[null,"Non-life asset risk",{"$f":"Input!D$137","v":0},{"$f":"SUMPRODUCT(Input!D$151:D$178,'Model Factors'!$D$97:$D$124)+Input!D148","v":0},0]
[null,"Banking capital",{"$f":"Input!D$219","v":0},{"$f":"Input!D$218","v":0},0]
[null,"Off balance sheet assets",{"$f":"Input!D$217+Input!$D$215","v":0},{"$f":"IF(C103=0,0,(Input!$D$216*Input!$D$217+Input!$D$215*'Model Factors'!D$161)/$C$103)","v":0},0]
[null,"Other assets",{"$f":"SUM(Input!D$211:$D$214)","v":0},{"$f":"IF($G$104<>0,$H$104/$G$104,0)","v":0},0,null,{"$f":"SUM(Input!D$211:D$214)","v":0},{"$f":"SUMPRODUCT(Input!D$211:D$214,'Model Factors'!$D$157:$D$160)","v":0}]
[null,"Currency risk",{"$f":"Input!$D$220","v":0},{"$f":"Input!$D$221","v":0},0]
[null,"Life insurance risk",{"$f":"Input!D$117","v":0},{"$f":"IF($G$106<>0,$H$106/$G$106,0)","v":0},0,null,{"$f":"SUM(Input!D$120:D$132)","v":0},{"$f":"SUMPRODUCT(Input!D$120:D$132,'Model Factors'!$D$82:$D$94)","v":0}]
[null,"Life asset risk",{"$f":"Input!D$145","v":0},{"$f":"SUMPRODUCT(Input!D$181:D$208,'Model Factors'!$D$127:$D$154)+Input!D148","v":0},0]
[null,"Reporting Risk Add-on",{"$f":"SUM(E98:E107)","v":0},{"$f":"IF(COUNTIF('Model Factors'!$C$167:$C$169,Input!$D$20),INDEX('Model Factors'!$D$167:$D$169,MATCH(Input!$D$20,'Model Factors'!$C$167:$C$169,0)),'Model Factors'!$D$170)","v":0},{"$f":"D108*C108","v":0}]
[]
[null,"Gross Target capital",null,null,{"$f":"SUM(E98:E108)","v":0}]
[]
[null,"Asset diversification",null,{"$f":"IF($G$112,E112/$E$110,0)","v":0},{"$f":"-E$220","v":0},null,{"$f":"$E$110<>0","v":false}]
[null,"Non-Life diversification",null,{"$f":"IF($G$112,E113/$E$110,0)","v":0},{"$f":"-E$236","v":0}]
[null,"Life diversification",null,{"$f":"IF($G$112,E114/$E$110,0)","v":0},{"$f":"-E$248","v":0}]
[null,"Overall diversification",null,{"$f":"IF($G$112,E115/$E$110,0)","v":0},{"$f":"-E$257","v":0}]
[]
[null,"Net Target capital",null,null,{"$f":"SUM(E110:E115)","v":0},{"$f":"IF($E117<>0,$E$80/$E117,0)","v":0}]
[]
[null,"Target Capital - Very Strong","Exposure","Charge","TC"]
[null,"Non-life Premium risk",{"$f":"Input!D$65-Input!D66","v":0},{"$f":"SUMPRODUCT(Input!D$69:D$78,'Model Factors'!$E$48:$E$57)+Input!D$81","v":0},{"$f":"D120*C120","v":0}]
[null,"Non-life Property Cat risk",{"$f":"SUM(Input!$D$85:$D$88)","v":0},{"$f":"IF($G$121<>0,$H$121/$G$121,0)","v":0},{"$f":"D121*C121+Input!D91*'Model Factors'!E67","v":0},null,{"$f":"SUM(Input!D$85:D$88)","v":0},{"$f":"SUMPRODUCT(Input!D$85:D$88,'Model Factors'!$E$60:$E$63)","v":0}]
[null,"Non-life Reserve risk",{"$f":"Input!D$98-SUM(E70:E72)","v":0},{"$f":"SUMPRODUCT(Input!D$101:D$110,'Model Factors'!$E$70:$E$79)+Input!D$113","v":0},0]
[null,"Non-life asset risk",{"$f":"Input!D$137","v":0},{"$f":"SUMPRODUCT(Input!D$151:D$178,'Model Factors'!$E$97:$E$124)+Input!D148","v":0},0]
[null,"Banking capital",{"$f":"Input!D$219","v":0},{"$f":"Input!D$218","v":0},0]
[null,"Off balance sheet assets",{"$f":"Input!D$217+Input!$D$215","v":0},{"$f":"IF(C125=0,0,(Input!$D$216*Input!$D$217+Input!$D$215*'Model Factors'!E$161)/C125)","v":0},0]
[null,"Other assets",{"$f":"SUM(Input!D$211:$D$214)","v":0},{"$f":"IF($G$126<>0,$H$126/$G$126,0)","v":0},0,null,{"$f":"SUM(Input!D$211:D$214)","v":0},{"$f":"SUMPRODUCT(Input!D$211:D$214,'Model Factors'!$E$157:$E$160)","v":0}]
[null,"Currency risk",{"$f":"Input!$D$220","v":0},{"$f":"Input!$D$221","v":0},0]
[null,"Life insurance risk",{"$f":"Input!D$117","v":0},{"$f":"IF($G$128<>0,$H$128/$G$128,0)","v":0},0,null,{"$f":"SUM(Input!D$120:D$132)","v":0},{"$f":"SUMPRODUCT(Input!D$120:D$132,'Model Factors'!$E$82:$E$94)","v":0}]
[null,"Life asset risk",{"$f":"Input!D$145","v":0},{"$f":"SUMPRODUCT(Input!D$181:D$208,'Model Factors'!$E$127:$E$154)+Input!D148","v":0},0]
[null,"Reporting Risk Add-on",{"$f":"SUM(E120:E129)","v":0},{"$f":"D108","v":0},{"$f":"D130*C130","v":0}]
[]
[null,"Gross Target capital",null,null,{"$f":"SUM(E120:E130)","v":0},null,{"$f":"$E$132<>0","v":false}]
[]
[null,"Asset diversification",null,{"$f":"IF($G$132,E134/$E$132,0)","v":0},{"$f":"-E$220","v":0}]
[null,"Non-Life diversification",null,{"$f":"IF($G$132,E135/$E$132,0)","v":0},{"$f":"-E$236","v":0}]
[null,"Life diversification",null,{"$f":"IF($G$132,E136/$E$132,0)","v":0},{"$f":"-E$248","v":0}]
[null,"Overall diversification",null,{"$f":"IF($G$132,E137/$E$132,0)","v":0},{"$f":"-E$257","v":0}]
[]
[null,"Net Target capital",null,null,{"$f":"SUM(E132:E137)","v":0},{"$f":"IF($E139<>0,$E$80/$E139,0)","v":0}]
[]
[null,"Target Capital - Strong","Exposure","Charge","TC"]
[null,"Non-life Premium risk",{"$f":"Input!D$65-Input!D66","v":0},{"$f":"SUMPRODUCT(Input!D$69:D$78,'Model Factors'!$F$48:$F$57)+Input!D$81","v":0},{"$f":"D142*C142","v":0}]
[null,"Non-life Property Cat risk",{"$f":"SUM(Input!$D$85:$D$88)","v":0},{"$f":"IF($G$143<>0,$H$143/$G$143,0)","v":0},{"$f":"D143*C143+Input!D92*'Model Factors'!F67","v":0},null,{"$f":"SUM(Input!D$85:D$88)","v":0},{"$f":"SUMPRODUCT(Input!D$85:D$88,'Model Factors'!$F$60:$F$63)","v":0}]
[null,"Non-life Reserve risk",{"$f":"Input!D$98-SUM(E70:E72)","v":0},{"$f":"SUMPRODUCT(Input!D$101:D$110,'Model Factors'!$F$70:$F$79)+Input!D$113","v":0},0]
[null,"Non-life asset risk",{"$f":"Input!D$137","v":0},{"$f":"SUMPRODUCT(Input!D$151:D$178,'Model Factors'!$F$97:$F$124)+Input!D148","v":0},0]
[null,"Banking capital",{"$f":"Input!D$219","v":0},{"$f":"Input!D$218","v":0},0]
[null,"Off balance sheet assets",{"$f":"Input!D$217+Input!$D$215","v":0},{"$f":"IF(C147=0,0,(Input!$D$216*Input!$D$217+Input!$D$215*'Model Factors'!F$161)/C147)","v":0},0]
[null,"Other assets",{"$f":"SUM(Input!D$211:$D$214)","v":0},{"$f":"IF($G$148<>0,$H$148/$G$148,0)","v":0},0,null,{"$f":"SUM(Input!D$211:D$214)","v":0},{"$f":"SUMPRODUCT(Input!D$211:D$214,'Model Factors'!$F$157:$F$160)","v":0}]
[null,"Currency risk",{"$f":"Input!$D$220","v":0},{"$f":"Input!$D$221","v":0},0]
[null,"Life insurance risk",{"$f":"Input!D$117","v":0},{"$f":"IF($G$150<>0,$H$150/$G$150,0)","v":0},0,null,{"$f":"SUM(Input!D$120:D$132)","v":0},{"$f":"SUMPRODUCT(Input!D$120:D$132,'Model Factors'!$F$82:$F$94)","v":0}]
[null,"Life asset risk",{"$f":"Input!D$145","v":0},{"$f":"SUMPRODUCT(Input!D$181:D$208,'Model Factors'!$F$127:$F$154)+Input!D148","v":0},0]
[null,"Reporting Risk Add-on",{"$f":"SUM(E142:E151)","v":0},{"$f":"D130","v":0},{"$f":"D152*C152","v":0}]
[]
[null,"Gross Target capital",null,null,{"$f":"SUM(E142:E152)","v":0}]
[]
[null,"Asset diversification",null,{"$f":"IF($G$156,E156/$E$154,0)","v":0},{"$f":"-E$220","v":0},null,{"$f":"$E$154<>0","v":false}]
[null,"Non-Life diversification",null,{"$f":"IF($G$156,E157/$E$154,0)","v":0},{"$f":"-E$236","v":0}]
[null,"Life diversification",null,{"$f":"IF($G$156,E158/$E$154,0)","v":0},{"$f":"-E$248","v":0}]
[null,"Overall diversification",null,{"$f":"IF($G$156,E159/$E$154,0)","v":0},{"$f":"-E$257","v":0}]
[]
[null,"Net Target capital",null,null,{"$f":"SUM(E154:E159)","v":0},{"$f":"IF($E161<>0,$E$80/$E161,0)","v":0}]
[]
[null,"Target Capital - Adequate","Exposure","Charge","TC"]
[null,"Non-life Premium risk",{"$f":"Input!D$65-Input!D66","v":0},{"$f":"SUMPRODUCT(Input!D$69:D$78,'Model Factors'!$G$48:$G$57)+Input!D$81","v":0},{"$f":"D164*C164","v":0}]
[null,"Non-life Property Cat risk",{"$f":"SUM(Input!$D$85:$D$88)","v":0},{"$f":"IF($G$165<>0,$H$165/$G$165,0)","v":0},{"$f":"D165*C165+Input!D93*'Model Factors'!G67","v":0},null,{"$f":"SUM(Input!D$85:D$88)","v":0},{"$f":"SUMPRODUCT(Input!D$85:D$88,'Model Factors'!$G$60:$G$63)","v":0}]
[null,"Non-life Reserve risk",{"$f":"Input!D$98-SUM(E70:E72)","v":0},{"$f":"SUMPRODUCT(Input!D$101:D$110,'Model Factors'!$G$70:$G$79)+Input!D$113","v":0},0]
[null,"Non-life asset risk",{"$f":"Input!D$137","v":0},{"$f":"SUMPRODUCT(Input!D$151:D$178,'Model Factors'!$G$97:$G$124)+Input!D148","v":0},0]
[null,"Banking capital",{"$f":"Input!D$219","v":0},{"$f":"Input!D$218","v":0},{"$f":"D168*C168","v":0}]
[null,"Off balance sheet assets",{"$f":"Input!D$217+Input!$D$215","v":0},{"$f":"IF(C169=0,0,(Input!$D$216*Input!$D$217+Input!$D$215*'Model Factors'!G$161)/C169)","v":0},0]
[null,"Other assets",{"$f":"SUM(Input!D$211:$D$214)","v":0},{"$f":"IF($G$170<>0,$H$170/$G$170,0)","v":0},0,null,{"$f":"SUM(Input!D$211:D$214)","v":0},{"$f":"SUMPRODUCT(Input!D$211:D$214,'Model Factors'!$G$157:$G$160)","v":0}]
[null,"Currency risk",{"$f":"Input!$D$220","v":0},{"$f":"Input!$D$221","v":0},0]
[null,"Life insurance risk",{"$f":"Input!D$117","v":0},{"$f":"IF($G$172<>0,$H$172/$G$172,0)","v":0},0,null,{"$f":"SUM(Input!D$120:D$132)","v":0},{"$f":"SUMPRODUCT(Input!D$120:D$132,'Model Factors'!$G$82:$G$94)","v":0}]
[null,"Life asset risk",{"$f":"Input!D$145","v":0},{"$f":"SUMPRODUCT(Input!D$181:D$208,'Model Factors'!$G$127:$G$154)+Input!D148","v":0},0]
[null,"Reporting Risk Add-on",{"$f":"SUM(E164:E173)","v":0},{"$f":"D152","v":0},{"$f":"D174*C174","v":0}]
[]
[null,"Gross Target capital",null,null,{"$f":"SUM(E164:E174)","v":0}]
[]
[null,"Asset diversification",null,{"$f":"IF($G$178,E178/$E$176,0)","v":0},{"$f":"-E$220","v":0},null,{"$f":"$E$176<>0","v":false}]
[null,"Non-Life diversification",null,{"$f":"IF($G$178,E179/$E$176,0)","v":0},{"$f":"-E$236","v":0}]
[null,"Life diversification",null,{"$f":"IF($G$178,E180/$E$176,0)","v":0},{"$f":"-E$248","v":0}]
[null,"Overall diversification",null,{"$f":"IF($G$178,E181/$E$176,0)","v":0},{"$f":"-E$257","v":0}]
[]
[null,"Net Target capital",null,null,{"$f":"SUM(E176:E181)","v":0},{"$f":"IF($E183<>0,$E$80/$E183,0)","v":0}]
[]
[null,"Target Capital - Somewhat Weak","Exposure","Charge","TC"]
[null,"Non-life Premium risk",{"$f":"Input!D$65-Input!D66","v":0},{"$f":"SUMPRODUCT(Input!D$69:D$78,'Model Factors'!$H$48:$H$57)+Input!D$81","v":0},{"$f":"D186*C186","v":0}]
[null,"Non-life Property Cat risk",{"$f":"SUM(Input!$D$85:$D$88)","v":0},{"$f":"IF($G$187<>0,$H$187/$G$187,0)","v":0},{"$f":"D187*C187+Input!D94*'Model Factors'!H67","v":0},null,{"$f":"SUM(Input!D$85:D$88)","v":0},{"$f":"SUMPRODUCT(Input!D$85:D$88,'Model Factors'!$H$60:$H$63)","v":0}]
[null,"Non-life Reserve risk",{"$f":"Input!D$98-SUM(E70:E72)","v":0},{"$f":"SUMPRODUCT(Input!D$101:D$110,'Model Factors'!$H$70:$H$79)+Input!D$113","v":0},0]
[null,"Non-life asset risk",{"$f":"Input!D$137","v":0},{"$f":"SUMPRODUCT(Input!D$151:D$178,'Model Factors'!$H$97:$H$124)+Input!D148","v":0},0]
[null,"Banking capital",{"$f":"Input!D$219","v":0},{"$f":"Input!D$218","v":0},0]
[null,"Off balance sheet assets",{"$f":"Input!D$217+Input!$D$215","v":0},{"$f":"IF(C191=0,0,(Input!$D$216*Input!$D$217+Input!$D$215*'Model Factors'!H$161)/$C$191)","v":0},0]
[null,"Other assets",{"$f":"SUM(Input!D$211:$D$214)","v":0},{"$f":"IF($G$192<>0,$H$192/$G$192,0)","v":0},0,null,{"$f":"SUM(Input!D$211:D$214)","v":0},{"$f":"SUMPRODUCT(Input!D$211:D$214,'Model Factors'!$H$157:$H$160)","v":0}]
[null,"Currency risk",{"$f":"Input!$D$220","v":0},{"$f":"Input!$D$221","v":0},0]
[null,"Life insurance risk",{"$f":"Input!D$117","v":0},{"$f":"IF($G$194<>0,$H$194/$G$194,0)","v":0},0,null,{"$f":"SUM(Input!D$120:D$132)","v":0},{"$f":"SUMPRODUCT(Input!D$120:D$132,'Model Factors'!$H$82:$H$94)","v":0}]
[null,"Life asset risk",{"$f":"Input!D$145","v":0},{"$f":"SUMPRODUCT(Input!D$181:D$208,'Model Factors'!$H$127:$H$154)+Input!D148","v":0},0]
[null,"Reporting Risk Add-on",{"$f":"SUM(E186:E195)","v":0},{"$f":"D174","v":0},{"$f":"D196*C196","v":0}]
[]
[null,"Gross Target capital",null,null,{"$f":"SUM(E186:E196)","v":0},null,{"$f":"$E$198<>0","v":false}]
[]
[null,"Asset diversification",null,{"$f":"IF($G$198,E200/$E$198,0)","v":0},{"$f":"-E$220","v":0}]
[null,"Non-Life diversification",null,{"$f":"IF($G$198,E201/$E$198,0)","v":0},{"$f":"-E$236","v":0}]
[null,"Life diversification",null,{"$f":"IF($G$198,E202/$E$198,0)","v":0},{"$f":"-E$248","v":0}]
[null,"Overall diversification",null,{"$f":"IF($G$198,E203/$E$198,0)","v":0},{"$f":"-E$257","v":0}]
[]
[null,"Net Target capital",null,null,{"$f":"SUM(E198:E203)","v":0},{"$f":"IF($E205<>0,$E$80/$E205,0)","v":0}]
[]
[null,"Diversification"]
[]
[null,"Diversification - Asset"]
[null,"Bonds",null,null,{"$f":"SUMPRODUCT(Input!D151:D166,'Model Factors'!G97:G112)*Input!D137+SUMPRODUCT(Input!D181:D196,'Model Factors'!G127:G142)*Input!D145","v":0}]
[null,"Equity",null,null,{"$f":"SUMPRODUCT(Input!D167:D168,'Model Factors'!G113:G114)*Input!D137+SUMPRODUCT(Input!D197:D198,'Model Factors'!G143:G144)*Input!D145","v":0}]
[null,"Property",null,null,{"$f":"SUMPRODUCT(Input!D169:D170,'Model Factors'!G115:G116)*Input!D137+SUMPRODUCT(Input!D199:D200,'Model Factors'!G145:G146)*Input!D145","v":0}]
[null,"ABS",null,null,{"$f":"SUMPRODUCT(Input!D171:D172,'Model Factors'!G117:G118)*Input!D137+SUMPRODUCT(Input!D201:D202,'Model Factors'!G147:G148)*Input!D145","v":0}]
[null,"Morts",null,null,{"$f":"Input!D173*'Model Factors'!G119*Input!D137+Input!D203*'Model Factors'!G149*Input!D145","v":0}]
[null,"Cash",null,null,{"$f":"SUMPRODUCT(Input!D174:D176,'Model Factors'!G120:G122)*Input!D137+SUMPRODUCT(Input!D204:D206,'Model Factors'!G150:G152)*Input!D145","v":0}]
[null,"Other",null,null,{"$f":"SUMPRODUCT(Input!D177:D178,'Model Factors'!G123:G124)*Input!D137+SUMPRODUCT(Input!D207:D208,'Model Factors'!G153:G154)*Input!D145+SUM(E168:E171)","v":0}]
[]
[null,"Undiversified Capital",null,null,{"$f":"SUM(E210:E216)","v":0}]
[null,"Diversified Capital",null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(E210:E216),'Model Factors'!$D$195:$J$201),E210:E216))","v":0}]
[null,"Diversification Benefit",null,{"$f":"IF($E$218<>0,$E$220/$E$218,0)","v":0},{"$f":"E218-E219","v":0}]
[]
[null,"Diversification - Non-Life"]
[null,"Motor",null,null,{"$f":"Input!D69*'Model Factors'!$G48*(Input!D$65-Input!D66)+Input!D101*'Model Factors'!$G70*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Property",null,null,{"$f":"Input!D70*'Model Factors'!$G49*(Input!D$65-Input!D66)+Input!D102*'Model Factors'!$G71*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Liability",null,null,{"$f":"Input!D71*'Model Factors'!$G50*(Input!D$65-Input!D66)+Input!D103*'Model Factors'!$G72*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Marine, aviation and transport",null,null,{"$f":"Input!D72*'Model Factors'!$G51*(Input!D$65-Input!D66)+Input!D104*'Model Factors'!$G73*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Credit Insurance ",null,null,{"$f":"Input!D73*'Model Factors'!$G52*(Input!D$65-Input!D66)+Input!D105*'Model Factors'!$G74*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Accident and health ",null,null,{"$f":"Input!D74*'Model Factors'!$G53*(Input!D$65-Input!D66)+Input!D106*'Model Factors'!$G75*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Financial risks ",null,null,{"$f":"Input!D75*'Model Factors'!$G54*(Input!D$65-Input!D66)+Input!D107*'Model Factors'!$G76*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Non-proportional reinsurance ",null,null,{"$f":"Input!D76*'Model Factors'!$G55*(Input!D$65-Input!D66)+Input!D108*'Model Factors'!$G77*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Other",null,null,{"$f":"Input!D77*'Model Factors'!$G56*(Input!D$65-Input!D66)+Input!D109*'Model Factors'!$G78*(Input!D$98-SUM(E70:E72))+Input!D78*'Model Factors'!$G57*(Input!D$65-Input!D66)+Input!D110*'Model Factors'!$G79*(Input!D$98-SUM(E70:E72))","v":0}]
[null,"Cat risk",null,null,{"$f":"E165","v":0}]
[]
[null,"Undiversified Capital",null,null,{"$f":"SUM(E223:E232)","v":0}]
[null,"Diversified Capital",null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(E223:E232),'Model Factors'!$D$175:$M$184),E223:E232))","v":0}]
[null,"Diversification Benefit",null,{"$f":"IF($E$234<>0,$E$236/$E$234,0)","v":0},{"$f":"E234-E235","v":0}]
[]
[null,"Diversification - Life"]
[null,"Unit Linked / Variable Annuities",null,null,{"$f":"SUMPRODUCT(Input!D120:D123,'Model Factors'!$G$82:$G$85)","v":0}]
[null,"Participating product reserves (low guars)",null,null,{"$f":"SUMPRODUCT(Input!D124:D126,'Model Factors'!$G$86:$G$88)","v":0}]
[null,"Participating product reserves (high guars)",null,null,{"$f":"SUMPRODUCT(Input!D127:D129,'Model Factors'!$G$89:$G$91)","v":0}]
[null,"Protection ",null,null,{"$f":"Input!D130*'Model Factors'!$G92","v":0}]
[null,"UK style annuities NP bonds etc",null,null,{"$f":"Input!D131*'Model Factors'!$G93","v":0}]
[null,"Life non-proportional reinsurance",null,null,{"$f":"Input!D132*'Model Factors'!$G94","v":0}]
[]
[null,"Undiversified Capital",null,null,{"$f":"SUM(E239:E244)","v":0}]
[null,"Diversified Capital",null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(E239:E244),'Model Factors'!$D$187:$I$192),E239:E244))","v":0}]
[null,"Diversification Benefit",null,{"$f":"IF($E$246<>0,$E$248/$E$246,0)","v":0},{"$f":"E246-E247","v":0}]
[]
[null,"Diversification - Overall"]
[null,"Asset",null,null,{"$f":"E219","v":0}]
[null,"Non-Life ",null,null,{"$f":"E235","v":0}]
[null,"Life",null,null,{"$f":"E247","v":0}]
[]
[null,"Undiversified Capital",null,null,{"$f":"SUM(E251:E253)","v":0}]
[null,"Diversified Capital",null,null,{"$f":"SQRT(MMULT(MMULT(TRANSPOSE(E251:E253),'Model Factors'!$D$204:$F$206),E251:E253))","v":0}]
[null,"Diversification Benefit",null,{"$f":"IF($E$255<>0,$E$257/$E$255,0)","v":0},{"$f":"E255-E256","v":0}]
[]
[null,"Total Benefit",null,{"$f":"IF($G$259,$E$259/$G$259,0)","v":0},{"$f":"SUM(E257,E248,E236,E220)","v":0},null,{"$f":"SUM(E218,E234,E246)","v":0}]

{"sheet":"Model Factors","index":5,"n_rows":206,"n_cols":14,"rows_kept":206,"cut":false,"hidden":true,"merged":[[8,6,8,7]]}
[{"$f":"Input!A1","v":"Insurance | Prism Factor-Based Capital Model"}]
[null,"Model Factors",null,null,null,null,null,null,null,null,"PFBM1.8.0",null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[]
[]
[null,"Available Capital Credits"]
[]
[null,"Ref","Total Available Capital","Credit"]
[null,"C_AC1","Equity",1,null,null,"based on inputs"]
[null,"C_AC2","Equity assumed to support banking entities",-1]
[null,"C_AC3","Minority interests",1]
[null,"C_AC4","Life deferred acquisition costs (adjusted for tax)",{"$f":"-100%+Input!D13","v":-1}]
[null,"C_AC5","Value of business acquired  (adjusted for tax)",{"$f":"-100%+Input!D13","v":-1}]
[null,"C_AC6","Goodwill  (adjusted for tax)",-1]
[null,"C_AC7","Other intangible assets  (adjusted for tax)",{"$f":"-100%+Input!D13","v":-1}]
[null,"C_AC9","Subordinated debt - 0% equity credit",0]
[null,"C_AC10","Subordinated debt - 50% equity credit",0.5]
[null,"C_AC11","Subordinated debt - 100% equity credit",1]
[null,"C_AC12","Preference shares",1]
[null,"C_AC13","Equalisation reserve (if not in SH equity)",1]
[null,"C_AC14",{"$f":"Input!B40","v":"Off balance sheet unrealised gain (loss) bonds"},{"$f":"Input!D41","v":0}]
[null,"C_AC15",{"$f":"Input!B42","v":"Off balance sheet unrealised gain (loss) property"},{"$f":"Input!D43","v":0}]
[null,"C_AC16",{"$f":"Input!B44","v":"Off balance sheet unrealised gain (loss) shares / affiliates"},{"$f":"Input!D45","v":0}]
[null,"C_AC17",{"$f":"Input!B46","v":"Off balance sheet unrealised gain (loss) other"},{"$f":"Input!D47","v":0}]
[null,"C_AC18","On balance sheet unrealised gain (loss) bonds",{"$f":"Input!D49","v":0}]
[null,"C_AC19","Life - other technical provisions 0% (buffers) ",0]
[null,"C_AC20","Life - other technical provisions 50% (buffers) ",0.5]
[null,"C_AC21","Life - other technical provisions 100% (buffers) ",1]
[null,"C_AC22","Non-life reserve redundancies - 0% credit",0]
[null,"C_AC23","Non-life reserve redundancies - 50% credit",0.5]
[null,"C_AC24","Non-life reserve redundancies - 100% credit",1]
[null,"C_AC26","VIF - between 40 and 60% credit",{"$f":"INDEX('Output Generation'!$J$23:$J$27,MATCH(IF(ISBLANK(Input!$D$57),'Output Generation'!$I$27,Input!$D$57),'Output Generation'!$I$23:$I$27,0))","v":0}]
[null,"C_AC27","Dividend to be paid not on balance sheet (enter as negative number)",1]
[null,"C_AC28","Additional items counting for Fitch Core Capital",1]
[null,"C_AC29","Additional items counting for Total Available Capital",1]
[]
[null,"Ref","\"Fitch Core Capital\" Available Capital","Credit"]
[null,"TAC","Total Available Capital",1]
[null,{"$f":"B32","v":"C_AC26"},"VIF - Market consistent (MCEV)",{"$f":"-D32","v":0}]
[null,{"$f":"B16","v":"C_AC9"},"Subordinated debt - 0% equity credit",0]
[null,{"$f":"B17","v":"C_AC10"},"Subordinated debt - 50% equity credit",-0.5]
[null,{"$f":"B18","v":"C_AC11"},"Subordinated debt - 100% equity credit",-1]
[null,{"$f":"B35","v":"C_AC29"},"Additional items counting for Total Available Capital",-1]
[]
[null,"Target Capital Charges"]
[]
[null,"Ref","Non-Life Premium Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_NLP1","Motor",0.32683049653920904,0.30747057296372426,0.28967924892424468,0.24909427061938394,0.22290730677872117]
[null,"C_NLP2","Property",0.33197396033372151,0.30565037835020137,0.28155186563146661,0.22691729544738881,0.19192083756115763]
[null,"C_NLP3","Liability",0.48510828269675588,0.43973986704101631,0.39867150288787412,0.30722606191062818,0.24987481236429487]
[null,"C_NLP4","MAT",0.45327598160191629,0.41062351230092209,0.37194564918986606,0.28558327853816956,0.23124501682127874]
[null,"C_NLP5","Credit Insurance",0.541550037132974,0.47409754457200015,0.41380885750536867,0.28226872498971001,0.20173262968747663]
[null,"C_NLP6","A&H",0.22121304541931208,0.20664108202153497,0.19319973973961135,0.16235449262438806,0.1423134119240127]
[null,"C_NLP7","Financial Risks",0.27688059536626053,0.25865325515257309,0.24187631313441837,0.20350964104987201,0.17868267842489671]
[null,"C_NLP8","Non-Proportional Reinsurance",0.46407222410589455,0.4075325754786463,0.35676058788582288,0.24514811450065932,0.17619850640446555]
[null,"C_NLP9","Other high",0.541550037132974,0.47409754457200015,0.41380885750536867,0.28226872498971001,0.20173262968747663]
[null,"C_NLP10","Other low",0.27688059536626053,0.25865325515257309,0.24187631313441837,0.20350964104987201,0.17868267842489671]
[]
[null,"Ref","Non-Life Cat Risk Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_CAT1","Cat risk - low",1.3,1.2,1.1000000000000001,1,0.7]
[null,"C_CAT2","Cat risk - med",1.9503336284589681,1.6585806995336585,1.4723249263734637,1,0.8]
[null,"C_CAT3","Cat risk - high",2.7012258314077457,2.1965367253610704,1.8429220825332218,1,0.9]
[null,"C_CAT4","Cat risk - very high",4.118356027421795,3.0831804493651198,2.3765702017955115,1,0.95]
[]
[null,null,"Non-Life Full Curve Cat Scalars","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,null,"Ref","CATS1","CATS2","CATS3","CATS4","CATS5"]
[null,null,null,1,1,1,1,1]
[]
[null,"Ref","Non-Life Reserve Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_NLR1","Motor",{"$f":"D48/3","v":0.10894349884640302},{"$f":"E48/3","v":0.10249019098790808},9.6559749641414894E-2,8.3031423539794647E-2,7.4302435592907057E-2]
[null,"C_NLR2","Property",0.1327895841334886,0.12226015134008054,0.11262074625258664,9.0766918178955519E-2,7.676833502446305E-2]
[null,"C_NLR3","Liability",{"$f":"D50/3","v":0.16170276089891863},{"$f":"E50/3","v":0.14657995568033877},0.1328905009626247,0.10240868730354273,8.329160412143162E-2]
[null,"C_NLR4","MAT",0.18131039264076651,0.16424940492036882,0.14877825967594643,0.11423331141526782,9.2498006728511495E-2]
[null,"C_NLR5","Credit Insurance",0.36103335808864934,0.31606502971466677,0.27587257167024576,0.18817914999314,0.13448841979165108]
[null,"C_NLR6","A&H",{"$f":"D53/2","v":0.11060652270965604},{"$f":"E53/2","v":0.10332054101076749},9.6599869869805677E-2,8.1177246312194029E-2,7.115670596200635E-2]
[null,"C_NLR7","Financial Risks",0.18458706357750701,0.17243550343504874,0.16125087542294558,0.13567309403324801,0.11912178561659781]
[null,"C_NLR8","Non-Proportional Reinsurance",{"$f":"D55/2.5","v":0.18562888964235782},{"$f":"E55/2.5","v":0.16301303019145852},0.14270423515432915,9.8059245800263733E-2,7.0479402561786225E-2]
[null,"C_NLR9","Other high",0.2166200148531896,0.18963901782880005,0.16552354300214747,0.112907489995884,8.0693051874990651E-2]
[null,"C_NLR10","Other low",0.11075223814650421,0.10346130206102924,9.6750525253767344E-2,8.1403856419948808E-2,7.1473071369958688E-2]
[]
[null,"Ref","Life Reserve Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_LR1","Unit linked reserves",7.3244444444444433E-3,6.1466666666666657E-3,5.0222222222222222E-3,3.1111111111111114E-3,2.0444444444444442E-3]
[null,"C_LR2","Variable annuity - high",0.1648,0.13830000000000001,0.113,7.0000000000000007E-2,4.5999999999999999E-2]
[null,"C_LR3","Variable annuity - med",0.111,8.9499999999999996E-2,6.9699999999999998E-2,3.6700000000000003E-2,1.9900000000000001E-2]
[null,"C_LR4","Variable annuity - low",6.2100000000000002E-2,4.99E-2,3.8399999999999997E-2,1.9599999999999999E-2,1.0999999999999999E-2]
[null,"C_LR5","Participating product reserves (low guars) - high",0.1497,0.1242,0.10009999999999999,5.8999999999999997E-2,3.6200000000000003E-2]
[null,"C_LR6","Participating product reserves (low guars) - med",9.9900000000000003E-2,8.0549999999999997E-2,6.2729999999999994E-2,3.3030000000000004E-2,1.7910000000000002E-2]
[null,"C_LR7","Participating product reserves (low guars) - low",6.2100000000000002E-2,4.99E-2,3.8399999999999997E-2,1.9599999999999999E-2,1.0999999999999999E-2]
[null,"C_LR8","Participating product reserves (high guars) - high",7.4132178499843313E-2,4.5420392164401045E-2,2.7E-2,0.02,1.6E-2]
[null,"C_LR9","Participating product reserves (high guars) - med",4.658294074344442E-2,3.062542885654863E-2,2.1600000000000001E-2,1.6E-2,8.0000000000000002E-3]
[null,"C_LR10","Participating product reserves (high guars) - low",1.967833062617461E-2,1.6225425480560572E-2,1.5814456911792025E-2,9.5693649259700163E-3,4.7666497401345626E-3]
[null,"C_LR11","Protection",7.0279752236337895E-2,5.7947948144859186E-2,4.5184162605120072E-2,1.9138729851940033E-2,9.5332994802691251E-3]
[null,"C_LR12","UK style annuities NP bonds etc",6.1494783206795654E-2,5.0704454626751785E-2,3.953614227948006E-2,1.594894154328336E-2,7.9444162335576048E-3]
[null,"C_LR13","Life non-proportional reinsurance",9.0457351858610993E-2,6.1563572141371599E-2,4.3693709917934302E-2,1.1763284886338404E-2,5.8594754490366545E-3]
[]
[null,"Ref","Non-Life Asset Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_NLA1","Bond, AAA under 5 years",2.8475E-2,2.6349999999999998E-2,2.3375E-2,1.5724999999999999E-2,1.1049999999999999E-2]
[null,"C_NLA2","Bond, AA- to AA, under 5 years",5.6950000000000001E-2,5.2699999999999997E-2,4.675E-2,3.1449999999999999E-2,2.2099999999999998E-2]
[null,"C_NLA3","Bond, A- to A+, under 5 years",7.5649999999999995E-2,6.9699999999999998E-2,6.3750000000000001E-2,4.675E-2,3.4849999999999999E-2]
[null,"C_NLA4","Bond, BBB- to BBB+, under 5 years",0.10199999999999999,9.0949999999999989E-2,8.3299999999999999E-2,6.2049999999999994E-2,4.9300000000000004E-2]
[null,"C_NLA5","Bond, Below BBB- & NR, under 5 years",0.2346,0.221,0.19295000000000001,0.14025000000000001,0.10795]
[null,"C_NLA23","Bond BB+, BB, BB- under 5 years",0.18534777012928763,0.17460297186092313,0.15244182543242138,0.11080573214250893,8.5286836255143231E-2]
[null,"C_NLA24","Bond B+, B, B- under 5 years",0.27802165519393152,0.26190445779138477,0.22866273814863208,0.16620859821376341,0.12793025438271485]
[null,"C_NLA25","Bond below B- & NR under 5 years",0.3398042452370274,0.32010544841169247,0.2794766799594392,0.20314384226126639,0.15635919980109594]
[null,"C_NLA6","Bond, AAA over 5 years",5.6100000000000004E-2,5.0149999999999993E-2,4.5474999999999995E-2,3.3575000000000001E-2,2.3799999999999998E-2]
[null,"C_NLA7","Bond, AA- to AA, over 5 years",0.11220000000000001,0.10029999999999999,9.0949999999999989E-2,6.7150000000000001E-2,4.7599999999999996E-2]
[null,"C_NLA8","Bond, A- to A+, over 5 years",0.1258,0.1139,0.10285,7.9899999999999999E-2,5.9500000000000004E-2]
[null,"C_NLA9","Bond, BBB- to BBB+, over 5 years",0.14280000000000001,0.13344999999999999,0.11984999999999998,9.35E-2,7.3099999999999998E-2]
[null,"C_NLA10","Bond Non-invest (< BBB-) & NR over 5 years",0.2346,0.221,0.19295000000000001,0.14025000000000001,0.10795]
[null,"C_NLA26","Bond BB+, BB, BB- over 5 years",0.19832622404796266,0.1868290516393851,0.16311613354669394,0.11856459046345594,9.1258805993084266E-2]
[null,"C_NLA27","Bond B+, B, B- over 5 years",0.28282861307871654,0.26643275145096484,0.23261628684372704,0.16908232303618925,0.13014215167027898]
[null,"C_NLA28","Bond below B- & NR over 5 years",0.34567941598509799,0.32564002955117927,0.28430879503122192,0.20665617259978686,0.15906262981922989]
[null,"C_NLA11","Equity, low",0.54144999999999999,0.48874999999999996,0.42669999999999997,0.26519999999999999,0.13514999999999999]
[null,"C_NLA12","Equity, high",0.72504999999999997,0.65874999999999995,0.58310000000000006,0.39269999999999999,0.2142]
[null,"C_NLA13","Property, low",0.29205999999999999,0.26384000000000002,0.23238999999999999,0.15401999999999999,8.9759999999999993E-2]
[null,"C_NLA14","Property, high",0.37569999999999998,0.34357000000000004,0.30515000000000003,0.21318000000000001,0.12953999999999999]
[null,"C_NLA15","Structured/ABS, BBB- and above",0.23205000000000001,0.1938,0.16405,9.35E-2,5.7800000000000004E-2]
[null,"C_NLA16","Structured/ABS, Below BBB- & NR",0.30940000000000001,0.25839999999999996,0.21845000000000001,0.12494999999999999,7.7350000000000002E-2]
[null,"C_NLA17","Mortgages",0.11220000000000001,0.10029999999999999,9.0949999999999989E-2,6.7150000000000001E-2,4.7599999999999996E-2]
[null,"C_NLA18","Cash/Deposits AA- and above and deposits with cedents",1.6176728067037415E-2,1.1482827624599392E-2,6.3522741877342203E-3,3.5236764447391451E-3,2.0926716206145172E-3]
[null,"C_NLA19","Cash/Deposits between A+ and BBB-",3.4700849160279455E-2,2.5855378286724909E-2,1.5487896371061207E-2,9.258830490620526E-3,5.8569315102378E-3]
[null,"C_NLA20","Cash/Deposits BB+ and Below  ",0.14539578867713926,0.12048322894265903,8.647166984005604E-2,6.1687544951682979E-2,4.5516608347469172E-2]
[null,"C_NLA21","Other, low",2.8475E-2,2.6349999999999998E-2,2.3375E-2,1.5724999999999999E-2,8.0000000000000002E-3]
[null,"C_NLA22","Other, high",4.2500000000000003E-2,3.4000000000000002E-2,2.5499999999999998E-2,1.7000000000000001E-2,8.5000000000000006E-3]
[]
[null,"Ref","Life Asset Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_LA1","Bond, AAA under 5 years",6.9582411221885921E-3,4.3194768069583691E-3,1.9973362726700915E-3,8.7227174125214775E-4,4.3803420585532352E-4]
[null,"C_LA2","Bond, AA- to AA, under 5 years",2.6203452041616653E-2,1.8600159545022605E-2,1.0581725016379457E-2,5.7077356030999981E-3,3.3897596734261699E-3]
[null,"C_LA3","Bond, A- to A+, under 5 years",4.7501622609743686E-2,3.5393151796815486E-2,2.1723606129184569E-2,1.2674314387570516E-2,8.0174911272457051E-3]
[null,"C_LA4","Bond, BBB- to BBB+, under 5 years",7.2625374061014186E-2,5.6160124747591175E-2,3.5788301228436577E-2,2.2698040492931636E-2,1.5102860191624028E-2]
[null,"C_LA5","Bond, Below BBB- & NR, under 5 years",0.13323696506995203,0.11040738691308863,7.9239726057360099E-2,5.6528070122438732E-2,4.1709441259929946E-2]
[null,"C_LA23","Bond BB+, BB, BB- under 5 years",9.6160128340882473E-2,7.9683505923225192E-2,5.7189100812763356E-2,4.0797585527276449E-2,3.0102646232414713E-2]
[null,"C_LA24","Bond B+, B, B- under 5 years",0.14424019251132375,0.11952525888483781,8.5783651219145052E-2,6.1196378290914684E-2,4.5153969348622078E-2]
[null,"C_LA25","Bond below B- & NR under 5 years",0.17629356862495124,0.14608642752591289,0.10484668482339951,7.4795573466673509E-2,5.5188184759426988E-2]
[null,"C_LA6","Bond, AAA over 5 years",2.4533643337435043E-2,1.5229783148547692E-2,6.7803460051847663E-3,3.0754904030219385E-3,1.5444384273753022E-3]
[null,"C_LA7","Bond, AA- to AA, over 5 years",6.3563151595521186E-2,4.511942773736196E-2,2.4959965049669807E-2,1.3845567478315167E-2,8.2227260611376571E-3]
[null,"C_LA8","Bond, A- to A+, over 5 years",9.746659055301897E-2,7.2234740590444338E-2,4.2889878521700495E-2,2.5426700644928676E-2,1.5970791456193498E-2]
[null,"C_LA9","Bond, BBB- to BBB+, over 5 years",0.12024591508088674,9.8454052502556622E-2,6.2740303800214337E-2,4.2002485975355747E-2,2.7947684452496738E-2]
[null,"C_LA10","Bond Non-invest (< BBB-) & NR over 5 years",0.13323696506995203,0.11040738691308863,7.9239726057360099E-2,5.6528070122438732E-2,4.1709441259929946E-2]
[null,"C_LA26","Bond BB+, BB, BB- over 5 years",0.11759885381915947,9.7448798442166182E-2,6.9939306681125135E-2,4.989333291641497E-2,3.6813976384332293E-2]
[null,"C_LA27","Bond B+, B, B- over 5 years",0.14797509485866675,0.1226202018560261,8.8004901445755013E-2,6.2780974740407683E-2,4.6323169577599764E-2]
[null,"C_LA28","Bond below B- & NR over 5 years",0.18085844927170383,0.14986913560180967,0.10756154621147834,7.6732302460498281E-2,5.6617207261510823E-2]
[null,"C_LA11","Equity, low",0.54144999999999999,0.48874999999999996,0.42669999999999997,0.26519999999999999,0.13514999999999999]
[null,"C_LA12","Equity, high",0.72504999999999997,0.65874999999999995,0.58310000000000006,0.39269999999999999,0.2142]
[null,"C_LA13","Property, low",0.29205999999999999,0.26384000000000002,0.23238999999999999,0.15401999999999999,8.9759999999999993E-2]
[null,"C_LA14","Property, high",0.37569999999999998,0.34357000000000004,0.30515000000000003,0.21318000000000001,0.12953999999999999]
[null,"C_LA15","Structured/ABS, BBB- and above",0.1547,0.12920000000000001,0.10936666666666667,6.2333333333333331E-2,3.8533333333333336E-2]
[null,"C_LA16","Structured/ABS, Below BBB- & NR",0.20626666666666668,0.17226666666666665,0.14563333333333334,8.3299999999999999E-2,5.156666666666667E-2]
[null,"C_LA17","Mortgages",7.9038824752162867E-2,7.2341195427317817E-2,6.3533842598551396E-2,4.5345459085499411E-2,2.9712900818566892E-2]
[null,"C_LA18","Cash/Deposits AA- and above and deposits with cedents",1.6176728067037415E-2,1.1482827624599392E-2,6.3522741877342203E-3,3.5236764447391451E-3,2.0926716206145172E-3]
[null,"C_LA19","Cash/Deposits between A+ and BBB-",3.4700849160279455E-2,2.5855378286724909E-2,1.5487896371061207E-2,9.258830490620526E-3,5.8569315102378E-3]
[null,"C_LA20","Cash/Deposits BB+ and Below  ",0.14539578867713926,0.12048322894265903,8.647166984005604E-2,6.1687544951682979E-2,4.5516608347469172E-2]
[null,"C_LA21","Other, low",2.8475E-2,2.6349999999999998E-2,2.3375E-2,1.5724999999999999E-2,8.0000000000000002E-3]
[null,"C_LA22","Other, high",4.2500000000000003E-2,3.4000000000000002E-2,2.5499999999999998E-2,1.7000000000000001E-2,8.5000000000000006E-3]
[]
[null,"Ref","Other Charges","Extremely Strong","Very Strong","Strong","Adequate","Somewhat Weak"]
[null,"C_A1","Counterparty credit risk AA_ and above",1.6176728067037415E-2,1.1482827624599392E-2,6.3522741877342203E-3,3.5236764447391451E-3,2.0926716206145172E-3]
[null,"C_A2","Counterparty credit risk between A+ and BBB-",3.4700849160279455E-2,2.5855378286724909E-2,1.5487896371061207E-2,9.258830490620526E-3,5.8569315102378E-3]
[null,"C_A3","Counterparty credit risk BB+ and Below  ",0.14539578867713926,0.12048322894265903,8.647166984005604E-2,6.1687544951682979E-2,4.5516608347469172E-2]
[null,"C_A4","Tangible assets",3.4700849160279455E-2,2.5855378286724909E-2,1.5487896371061207E-2,9.258830490620526E-3,5.8569315102378E-3]
[null,"C_A5","Asset management",1.831111111111111E-3,1.5366666666666666E-3,1.2555555555555555E-3,7.7777777777777784E-4,5.1111111111111105E-4]
[null,"C_A6","Off balance sheet asset (excluding asset management assets)",{"$f":"Input!$D$216","v":0},{"$f":"Input!$D$216","v":0},{"$f":"Input!$D$216","v":0},{"$f":"Input!$D$216","v":0},{"$f":"Input!$D$216","v":0}]
[null,"C_A7","Charge on all banking assets - set by analyst (%)",{"$f":"Input!$D$218","v":0},{"$f":"Input!$D$218","v":0},{"$f":"Input!$D$218","v":0},{"$f":"Input!$D$218","v":0},{"$f":"Input!$D$218","v":0}]
[null,"C_A8","Charge for currency risk - set by analyst (%)",{"$f":"Input!$D$221","v":0},{"$f":"Input!$D$221","v":0},{"$f":"Input!$D$221","v":0},{"$f":"Input!$D$221","v":0},{"$f":"Input!$D$221","v":0}]
[]
[null,"Ref","Reporting Risk Add-On","Scalar"]
[null,"ERAO1","High",0.5]
[null,"ERAO2","Medium",0.25]
[null,"ERAO3","Low",0.1]
[null,"ERAO4",null,0]
[]
[null,"Diversification - Correlation Matrices"]
[]
[null,null,"Non-life correlations (NL Matrix)","Motor","Property ","Liability ","MAT","Credit Insurance ","A&H","Financial risks ","Non-prop reins","Other  ","Cat risk"]
[null,null,"Motor",1.0000000000000002,0.76999996756403966,0.55199997606460927,0.56499997799201462,0.74699999396689576,0.59099999384202861,0.60099999893833056,0.42100001434705919,0.59199999532279612,0.56499999492953912]
[null,null,"Property ",0.76999996756403966,1,0.5740000069449861,0.58500000593998458,0.72799999248117075,0.58999999536573033,0.58999998911612928,0.74899994748612087,0.58599999383828705,0.74599999292908958]
[null,null,"Liability ",0.55199997606460927,0.57400000694498599,1,0.4100000074678633,0.40999999686148475,0.39299999826265314,0.57699999166763571,0.74099995449262068,0.58899999556826443,0.20999999878836287]
[null,null,"Marine, aviation and transport ",0.56499997799201462,0.58500000593998469,0.41000000746786325,1,0.40099999744602488,0.39499999864242452,0.38699999395200047,0.74399995759956561,0.59499999629172207,0.59699999679423754]
[null,null,"Credit Insurance ",0.74699999396689576,0.72799999248117075,0.40999999686148464,0.40099999744602488,1,0.77799999994895908,0.76599999964292798,0.35999999276695704,0.58500000000240771,0.21399999999399036]
[null,null,"Accident and health ",0.59099999384202861,0.58999999536573045,0.39299999826265308,0.39499999864242452,0.77799999994895908,1.0000000000000002,0.59899999934877568,0.38999998984587175,0.59899999995279296,0.19900000001100915]
[null,null,"Financial risks ",0.60099999893833056,0.58999998911612928,0.57699999166763583,0.38699999395200024,0.76599999964292798,0.59899999934877546,1.0000000000000002,0.40299999809194575,0.5979999997486013,0.19299999981758373]
[null,null,"Non-proportional reinsurance ",0.42100001434705897,0.74899994748612098,0.74099995449262068,0.74399995759956561,0.35999999276695699,0.38999998984587175,0.4029999980919457,1.0000000000000002,0.58499998802214526,0.56199998752532687]
[null,null,"Other  ",0.59199999532279624,0.58599999383828705,0.58899999556826443,0.59499999629172207,0.58500000000240759,0.59899999995279296,0.5979999997486013,0.58499998802214526,1,0.39299999999205665]
[null,null,"Cat risk",0.56499999492953912,0.74599999292908969,0.20999999878836281,0.59699999679423754,0.21399999999399039,0.19900000001100909,0.19299999981758378,0.56199998752532709,0.3929999999920567,1.0000000000000002]
[]
[null,null,"Life correlations (L Matrix)","Unit-linked / Variable Annuities","Particip. product reserves (low guars)","Particip. product reserves (high guars)","Protection","UK style annuities NP","Non-prop reins"]
[null,null,"Unit-linked / Variable Annuities",1,0.4,0.4,0.4,0.4,0.4]
[null,null,"Participating product reserves (low guars)",0.4,1,0.4,0.4,0.4,0.4]
[null,null,"Participating product reserves (high guars)",0.4,0.4,1,0.4,0.4,0.4]
[null,null,"Protection",0.4,0.4,0.4,1,0.4,0.4]
[null,null,"UK style annuities NP bonds etc",0.4,0.4,0.4,0.4,1,0.4]
[null,null,"Life non-proportional reinsurance",0.4,0.4,0.4,0.4,0.4,1]
[]
[null,null,"Asset correlations (A Matrix)","Bonds","Equity","Property","ABS","Mortgages","Cash","Other"]
[null,null,"Bonds",1,0.70149177294257103,0.70073834714305105,0.70073834714305061,0.70073834714305083,0.50305971151668838,0.83114110996517243]
[null,null,"Equity",0.70149177294257103,1,0.60097205789037311,0.60097205789037289,0.60097205789037289,0.50587038253876926,0.81965690233545307]
[null,null,"Property",0.70073834714305105,0.60097205789037311,1,0.90020279390386537,0.90020279390386537,0.50103055576877797,0.83808486972651663]
[null,null,"ABS",0.70073834714305061,0.60097205789037278,0.90020279390386504,1,0.90020279390386526,0.50103055576877775,0.83808486972651641]
[null,null,"Mortgages",0.70073834714305083,0.60097205789037289,0.90020279390386537,0.90020279390386526,1,0.50103055576877786,0.83808486972651663]
[null,null,"Cash",0.50305971151668838,0.50587038253876926,0.50103055576877797,0.50103055576877775,0.50103055576877786,1,0.80311890880211223]
[null,null,"Other",0.83114110996517243,0.81965690233545307,0.83808486972651663,0.83808486972651641,0.83808486972651663,0.80311890880211223,1]
[]
[null,null,"Global (O Matrix)","Asset","Non-life","Life"]
[null,null,"Asset",1,0.4,0.4]
[null,null,"Non-life",0.4,1,0.4]
[null,null,"Life",0.4,0.4,1]

{"sheet":"Output Generation","index":6,"n_rows":167,"n_cols":15,"rows_kept":167,"cut":false,"hidden":true,"merged":[[13,2,13,3],[13,4,13,5],[13,1,14,1]]}
[{"$f":"Input!A1","v":"Insurance | Prism Factor-Based Capital Model"}]
[null,"Output Generation",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TemplateID","v":"PFBM1.8.0"}]
[]
[null,"These are interim calculations required to generate the output",null,null,null,null,null,null,null,null,null,null,"Input List"]
[]
[null,"Chart Tables",null,null,null,null,null,null,"Reference Tables",null,null,null,{"$f":"IF($N6,\"\",$O6)","v":""},{"$f":"ISBLANK(Input!$D13)","v":true},{"$f":"Input!$D13","v":0}]
[null,"Capital Adequacy Chart","Extremely strong","Very strong","Strong","Adequate","Somewhat weak",null,"Currency & Units calculations","Value",null,null,"",{"$f":"ISBLANK(Year)","v":true},{"$f":"Year","v":0}]
[null,"Total Available Capital",{"$f":"Calculations!$E$80","v":0},{"$f":"Calculations!$E$80","v":0},{"$f":"Calculations!$E$80","v":0},{"$f":"Calculations!$E$80","v":0},{"$f":"Calculations!$E$80","v":0},null,"Units",{"$f":"Units","v":0},{"$f":"J8<>\"\"","v":true},null,"",{"$f":"ISBLANK(Input!$D26)","v":true},{"$f":"Input!$D26","v":0}]
[null,"Fitch Core Capital",{"$f":"Calculations!$E$93","v":0},{"$f":"Calculations!$E$93","v":0},{"$f":"Calculations!$E$93","v":0},{"$f":"Calculations!$E$93","v":0},{"$f":"Calculations!$E$93","v":0},null,"Units Abbrv",{"$f":"IF($K$8,INDEX($K$15:$K$19,MATCH($J$8,$I$15:$I$19,0)),\"\")","v":{"$error":"#N/A"}},null,null,"",{"$f":"ISBLANK(Input!$D27)","v":true},{"$f":"Input!$D27","v":0}]
[null,"Additional Capital",{"$f":"$H$10","v":0},0,0,0,0,{"$f":"$G$8-$G$9","v":0},"Scale",{"$f":"IF($K$8,INDEX($J$15:$J$19,MATCH($J$8,$I$15:$I$19,0)),\"\")","v":{"$error":"#N/A"}},null,null,"",{"$f":"ISBLANK(Input!$D28)","v":true},{"$f":"Input!$D28","v":0}]
[null,"Target Capital",{"$f":"Calculations!$E$117","v":0},{"$f":"Calculations!$E$139","v":0},{"$f":"Calculations!$E$161","v":0},{"$f":"Calculations!$E$183","v":0},{"$f":"Calculations!$E$205","v":0},null,"Currency",{"$f":"Currency","v":0},null,null,"",{"$f":"ISBLANK(Input!$D29)","v":true},{"$f":"Input!$D29","v":0}]
[null,null,null,null,null,null,null,null,"Currency Abbrv",{"$f":"Currency&UnitsAbbrv","v":{"$error":"#N/A"}},null,null,"",{"$f":"ISBLANK(Input!$D30)","v":true},{"$f":"Input!$D30","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D31)","v":true},{"$f":"Input!$D31","v":0}]
[null,"Capital Split Chart","Target Capital",null,"Total Available Capital",null,null,null,"Units Lookup","Value","Abbrv",null,"",{"$f":"ISBLANK(Input!$D32)","v":true},{"$f":"Input!$D32","v":0}]
[null,null,"Undiversified","Diversified ","Type","Core vs Non-Core",null,null,"Trillions",1000000000000,"trn",null,"",{"$f":"ISBLANK(Input!$D33)","v":true},{"$f":"Input!$D33","v":0}]
[null,"Available Capital ",null,null,null,null,null,null,"Billions",1000000000,"bn",null,"",{"$f":"ISBLANK(Input!$D34)","v":true},{"$f":"Input!$D34","v":0}]
[null,{"$f":"\"Equity less intangibles\"& \"\n(\" & Currency&\" \"&  TEXT(E17,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(Calculations!E50:E56,Calculations!E74:E74)+Calculations!E61","v":0},null,null,null,"Millions",1000000,"m",null,"",{"$f":"ISBLANK(Input!$D35)","v":true},{"$f":"Input!$D35","v":0}]
[null,{"$f":"\"Sub debt\"& \"\n(\" & Currency&\" \"& TEXT(E18,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(Calculations!E57:E60,Calculations!E78)","v":0},null,null,null,"Thousands",1000,"k",null,"",{"$f":"ISBLANK(Input!$D36)","v":true},{"$f":"Input!$D36","v":0}]
[null,{"$f":"\"Capital buffers\" & \"\n(\" & Currency&\" \"& TEXT(E19,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(Calculations!E62:E72)","v":0},null,null,null,"Units",1,null,null,"",{"$f":"ISBLANK(Input!$D37)","v":true},{"$f":"Input!$D37","v":0}]
[null,{"$f":"\"VIF\" & \"\n(\" & Currency&\" \"& TEXT(E20,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(Calculations!E73)","v":0},null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D38)","v":true},{"$f":"Input!$D38","v":0}]
[null,{"$f":"\"Adj\" & \"\n(\" & Currency&\" \"& TEXT(E21,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"SUM(Calculations!E75:E76)","v":0},null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D39)","v":true},{"$f":"Input!$D39","v":0}]
[null,{"$f":"\"CSM\" & \"\n(\" & Currency&\" \"& TEXT(E22,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,{"$f":"Calculations!E77","v":0},null,null,null,"VIF Type Lookup","Value",null,"Hybrid Cap","",{"$f":"ISBLANK(Input!$D40)","v":true},{"$f":"Input!$D40","v":0}]
[null,{"$f":"\"AC Core\" & \"\n(\" & Currency&\" \"& TEXT(F23,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,null,{"$f":"FCC","v":0},null,null,"MCEV",0.6,null,"Yes","",{"$f":"ISBLANK(Input!$D41)","v":true},{"$f":"Input!$D41","v":0}]
[null,{"$f":"\"AC Non-Core\"& \"\n(\" & Currency&\" \"& TEXT(F24,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,null,null,{"$f":"MAX(TAC-FCC,0)","v":0},null,null,"EV with CoG",0.5,null,"No","",{"$f":"ISBLANK(Input!$D42)","v":true},{"$f":"Input!$D42","v":0}]
[null,"Target Capital",null,null,null,null,null,null,"EV without CoG",0.4,null,0.2,"",{"$f":"ISBLANK(Input!$D43)","v":true},{"$f":"Input!$D43","v":0}]
[null,{"$f":"\"Life\" & \"\n(\" & Currency&\" \"& TEXT(C26,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"Calculations!C39","v":0},null,null,null,null,null,"DAC proxy",0.4,null,null,"",{"$f":"ISBLANK(Input!$D44)","v":true},{"$f":"Input!$D44","v":0}]
[null,{"$f":"\"Non-Life\" & \"\n(\" & Currency&\" \"& TEXT(C27,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"Calculations!C40","v":0},null,null,null,null,null,{"$f":"\"\"","v":""},0,null,null,"",{"$f":"ISBLANK(Input!$D45)","v":true},{"$f":"Input!$D45","v":0}]
[null,{"$f":"\"Asset \" & \"\n(\" & Currency&\" \"& TEXT(C28,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"Calculations!C41","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D46)","v":true},{"$f":"Input!$D46","v":0}]
[null,{"$f":"\"Other\" & \"\n(\" & Currency&\" \"& TEXT(C29,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"Calculations!C42","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D47)","v":true},{"$f":"Input!$D47","v":0}]
[null,{"$f":"\"Diversified (\"&CapitalModelResult&\")\" & \"\n(\" & Currency&\" \"& TEXT(D30,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},null,{"$f":"Calculations!C44","v":0},null,null,null,null,"Data Checks - Interim Calculations",null,null,null,"",{"$f":"ISBLANK(Input!$D48)","v":true},{"$f":"Input!$D48","v":0}]
[null,"Total",{"$f":"SUM(C26:C29)","v":0},{"$f":"D30","v":0},{"$f":"SUM(E17:E22)","v":0},null,null,null,"For numerical Input cells",null,null,null,"",{"$f":"ISBLANK(Input!$D49)","v":true},{"$f":"Input!$D49","v":0}]
[null,null,null,null,null,null,null,null,"Count cells",{"$f":"COUNTA($M$6:$M$174)","v":162},null,null,"",{"$f":"ISBLANK(Input!$D50)","v":true},{"$f":"Input!$D50","v":0}]
[null,"Capital Model Result",{"$f":"CapitalModelResult","v":"Extremely Strong"},null,null,null,null,null,"Count Blanks",{"$f":"J32-J34","v":162},null,null,"",{"$f":"ISBLANK(Input!$D51)","v":true},{"$f":"Input!$D51","v":0}]
[null,{"$f":"Calculations!B9","v":{"$error":"#N/A"}},{"$f":"Calculations!C9","v":0},null,null,null,null,null,"Count numerical",{"$f":"COUNT($M$6:$M$174)","v":0},null,null,"",{"$f":"ISBLANK(Input!$D52)","v":true},{"$f":"Input!$D52","v":0}]
[null,{"$f":"Calculations!B10","v":{"$error":"#N/A"}},{"$f":"Calculations!C10","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D53)","v":true},{"$f":"Input!$D53","v":0}]
[null,{"$f":"Calculations!B11","v":{"$error":"#N/A"}},{"$f":"Calculations!C11","v":0},null,null,null,null,null,"Reporting Risk Add-on:",null,null,null,"",{"$f":"ISBLANK(Input!$D54)","v":true},{"$f":"Input!$D54","v":0}]
[null,{"$f":"Calculations!B12","v":{"$error":"#N/A"}},{"$f":"Calculations!C12","v":0},null,null,null,null,null,{"$f":"'Model Factors'!C167","v":"High"},null,null,null,"",{"$f":"ISBLANK(Input!$D55)","v":true},{"$f":"Input!$D55","v":0}]
[null,{"$f":"Calculations!B13","v":{"$error":"#N/A"}},{"$f":"Calculations!C13","v":0},null,null,null,null,null,{"$f":"'Model Factors'!C168","v":"Medium"},null,null,null,{"$f":"IF($N38,\"\",$O38)","v":""},{"$f":"ISBLANK(Input!$D56)","v":true},{"$f":"Input!$D56","v":0}]
[null,{"$f":"Calculations!B14","v":{"$error":"#N/A"}},{"$f":"Calculations!C14","v":0},null,null,null,null,null,{"$f":"'Model Factors'!C169","v":"Low"},null,null,null,"",{"$f":"ISBLANK(Input!$D57)","v":true},{"$f":"Input!$D57","v":0}]
[null,{"$f":"Calculations!B15","v":{"$error":"#N/A"}},{"$f":"Calculations!C15","v":0},null,null,null,null,null,{"$f":"'Model Factors'!C170","v":0},null,null,null,"",{"$f":"ISBLANK(Input!$D58)","v":true},{"$f":"Input!$D58","v":0}]
[null,{"$f":"Calculations!B16","v":{"$error":"#N/A"}},{"$f":"Calculations!C16","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D59)","v":true},{"$f":"Input!$D59","v":0}]
[null,{"$f":"Calculations!B17","v":{"$error":"#N/A"}},{"$f":"Calculations!C17","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D60)","v":true},{"$f":"Input!$D60","v":0}]
[null,{"$f":"Calculations!B18","v":{"$error":"#N/A"}},{"$f":"Calculations!C18","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D61)","v":true},{"$f":"Input!$D61","v":0}]
[null,{"$f":"Calculations!B19","v":{"$error":"#N/A"}},{"$f":"Calculations!C19","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D65)","v":true},{"$f":"Input!$D65","v":0}]
[null,{"$f":"Calculations!B20","v":{"$error":"#N/A"}},{"$f":"Calculations!C20","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D66)","v":true},{"$f":"Input!$D66","v":0}]
[null,{"$f":"Calculations!B21","v":{"$error":"#N/A"}},{"$f":"Calculations!C21","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D69)","v":true},{"$f":"Input!$D69","v":0}]
[null,{"$f":"Calculations!B22","v":{"$error":"#N/A"}},{"$f":"Calculations!C22","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D70)","v":true},{"$f":"Input!$D70","v":0}]
[null,{"$f":"Calculations!B23","v":{"$error":"#N/A"}},{"$f":"Calculations!C23","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D71)","v":true},{"$f":"Input!$D71","v":0}]
[null,{"$f":"Calculations!B24","v":{"$error":"#N/A"}},{"$f":"Calculations!C24","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D72)","v":true},{"$f":"Input!$D72","v":0}]
[null,{"$f":"Calculations!B25","v":{"$error":"#N/A"}},{"$f":"Calculations!C25","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D73)","v":true},{"$f":"Input!$D73","v":0}]
[null,{"$f":"Calculations!B26","v":{"$error":"#N/A"}},{"$f":"Calculations!C26","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D74)","v":true},{"$f":"Input!$D74","v":0}]
[null,{"$f":"\"Other Non-Life\"  & \"\n(\" & Currency&\" \"&  TEXT(C52,\"#,##0\") & UnitsAbbrv &\")\"","v":{"$error":"#N/A"}},{"$f":"Calculations!C27+Calculations!C28","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D75)","v":true},{"$f":"Input!$D75","v":0}]
[null,{"$f":"Calculations!B30","v":{"$error":"#N/A"}},{"$f":"Calculations!C30","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D76)","v":true},{"$f":"Input!$D76","v":0}]
[null,{"$f":"Calculations!B31","v":{"$error":"#N/A"}},{"$f":"Calculations!C31","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D77)","v":true},{"$f":"Input!$D77","v":0}]
[null,{"$f":"Calculations!B39","v":"Life"},{"$f":"Calculations!C39","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D78)","v":true},{"$f":"Input!$D78","v":0}]
[null,{"$f":"Calculations!B40","v":"Non-Life"},{"$f":"Calculations!C40","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D81)","v":true},{"$f":"Input!$D81","v":0}]
[null,{"$f":"Calculations!B41","v":"Asset"},{"$f":"Calculations!C41","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D85)","v":true},{"$f":"Input!$D85","v":0}]
[null,{"$f":"Calculations!B42","v":"Other"},{"$f":"Calculations!C42","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D86)","v":true},{"$f":"Input!$D86","v":0}]
[null,{"$f":"Calculations!B43","v":"Div ben"},{"$f":"Calculations!C43","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D87)","v":true},{"$f":"Input!$D87","v":0}]
[null,{"$f":"Calculations!B44","v":"Div cap"},{"$f":"Calculations!C44","v":0},null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D88)","v":true},{"$f":"Input!$D88","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D90)","v":true},{"$f":"Input!$D90","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D91)","v":true},{"$f":"Input!$D91","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D92)","v":true},{"$f":"Input!$D92","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D93)","v":true},{"$f":"Input!$D93","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D94)","v":true},{"$f":"Input!$D94","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D98)","v":true},{"$f":"Input!$D98","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D101)","v":true},{"$f":"Input!$D101","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D102)","v":true},{"$f":"Input!$D102","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D103)","v":true},{"$f":"Input!$D103","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D104)","v":true},{"$f":"Input!$D104","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D105)","v":true},{"$f":"Input!$D105","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D106)","v":true},{"$f":"Input!$D106","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D107)","v":true},{"$f":"Input!$D107","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D108)","v":true},{"$f":"Input!$D108","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D109)","v":true},{"$f":"Input!$D109","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D110)","v":true},{"$f":"Input!$D110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D113)","v":true},{"$f":"Input!$D113","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D117)","v":true},{"$f":"Input!$D117","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D120)","v":true},{"$f":"Input!$D120","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D121)","v":true},{"$f":"Input!$D121","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D122)","v":true},{"$f":"Input!$D122","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D123)","v":true},{"$f":"Input!$D123","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D124)","v":true},{"$f":"Input!$D124","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D125)","v":true},{"$f":"Input!$D125","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D126)","v":true},{"$f":"Input!$D126","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D127)","v":true},{"$f":"Input!$D127","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D128)","v":true},{"$f":"Input!$D128","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D129)","v":true},{"$f":"Input!$D129","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N89,\"\",$O89)","v":""},{"$f":"ISBLANK(Input!$D130)","v":true},{"$f":"Input!$D130","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D131)","v":true},{"$f":"Input!$D131","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D132)","v":true},{"$f":"Input!$D132","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D136)","v":true},{"$f":"Input!$D136","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D137)","v":true},{"$f":"Input!$D137","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D138)","v":true},{"$f":"Input!$D138","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D139)","v":true},{"$f":"Input!$D139","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D142)","v":true},{"$f":"Input!$D142","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D143)","v":true},{"$f":"Input!$D143","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D144)","v":true},{"$f":"Input!$D144","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D145)","v":true},{"$f":"Input!$D145","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D148)","v":true},{"$f":"Input!$D148","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D151)","v":true},{"$f":"Input!$D151","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N102,\"\",$O102)","v":""},{"$f":"ISBLANK(Input!$D152)","v":true},{"$f":"Input!$D152","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D153)","v":true},{"$f":"Input!$D153","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D154)","v":true},{"$f":"Input!$D154","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D155)","v":true},{"$f":"Input!$D155","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D156)","v":true},{"$f":"Input!$D156","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D157)","v":true},{"$f":"Input!$D157","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D158)","v":true},{"$f":"Input!$D158","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D159)","v":true},{"$f":"Input!$D159","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D160)","v":true},{"$f":"Input!$D160","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D161)","v":true},{"$f":"Input!$D161","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D162)","v":true},{"$f":"Input!$D162","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D163)","v":true},{"$f":"Input!$D163","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D164)","v":true},{"$f":"Input!$D164","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D165)","v":true},{"$f":"Input!$D165","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D166)","v":true},{"$f":"Input!$D166","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D167)","v":true},{"$f":"Input!$D167","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D168)","v":true},{"$f":"Input!$D168","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D169)","v":true},{"$f":"Input!$D169","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D170)","v":true},{"$f":"Input!$D170","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D171)","v":true},{"$f":"Input!$D171","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D172)","v":true},{"$f":"Input!$D172","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D173)","v":true},{"$f":"Input!$D173","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D174)","v":true},{"$f":"Input!$D174","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D175)","v":true},{"$f":"Input!$D175","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D176)","v":true},{"$f":"Input!$D176","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D177)","v":true},{"$f":"Input!$D177","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D178)","v":true},{"$f":"Input!$D178","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D181)","v":true},{"$f":"Input!$D181","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D182)","v":true},{"$f":"Input!$D182","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D183)","v":true},{"$f":"Input!$D183","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D184)","v":true},{"$f":"Input!$D184","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D185)","v":true},{"$f":"Input!$D185","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($N134,\"\",$O134)","v":""},{"$f":"ISBLANK(Input!$D186)","v":true},{"$f":"Input!$D186","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D187)","v":true},{"$f":"Input!$D187","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D188)","v":true},{"$f":"Input!$D188","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D189)","v":true},{"$f":"Input!$D189","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D190)","v":true},{"$f":"Input!$D190","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D191)","v":true},{"$f":"Input!$D191","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D192)","v":true},{"$f":"Input!$D192","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D193)","v":true},{"$f":"Input!$D193","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D194)","v":true},{"$f":"Input!$D194","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D195)","v":true},{"$f":"Input!$D195","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D196)","v":true},{"$f":"Input!$D196","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D197)","v":true},{"$f":"Input!$D197","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D198)","v":true},{"$f":"Input!$D198","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D199)","v":true},{"$f":"Input!$D199","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D200)","v":true},{"$f":"Input!$D200","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D201)","v":true},{"$f":"Input!$D201","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D202)","v":true},{"$f":"Input!$D202","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D203)","v":true},{"$f":"Input!$D203","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D204)","v":true},{"$f":"Input!$D204","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D205)","v":true},{"$f":"Input!$D205","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D206)","v":true},{"$f":"Input!$D206","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D207)","v":true},{"$f":"Input!$D207","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D208)","v":true},{"$f":"Input!$D208","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D211)","v":true},{"$f":"Input!$D211","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D212)","v":true},{"$f":"Input!$D212","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D213)","v":true},{"$f":"Input!$D213","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D214)","v":true},{"$f":"Input!$D214","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D215)","v":true},{"$f":"Input!$D215","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D216)","v":true},{"$f":"Input!$D216","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D217)","v":true},{"$f":"Input!$D217","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D218)","v":true},{"$f":"Input!$D218","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D219)","v":true},{"$f":"Input!$D219","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D220)","v":true},{"$f":"Input!$D220","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"",{"$f":"ISBLANK(Input!$D221)","v":true},{"$f":"Input!$D221","v":0}]

{"sheet":"Disclaimer ","index":7,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}