181x Filetype XLSX File size 1.35 MB Source: content.naic.org
Tab Template RCells Various Various Read Me Schedule 1 row 5 Schedule 1 E4 Inventory Table D AR:AT Capital Instruments Calc 1 Scaling (Ins) Row 41 to 52 Calc 1 Scaling (Ins) col 9 col k Calc 2 and Summary 2 Input 4 Analytics Summary 3 Analytics Summary 3 Analytics Stress Inputs / Stress Summary Description of change Updated dates from 2021 to 2022 Added New Zealand to list of regimes. To keep number of rows constant, replaces Regime E Removed deleted tabs and reference to "prior" names of tabs from field testing Removed reference to "prior cells" from Field Testing updated version number Added calc check comparing equity on schedule 1 to carrying value in Inventory Removed 'other debt' calculation for use in sensitivity test. Note that 'other debt' can still be entered in main schedule. Changed factor from 100% to 50% of carrying value for non-risk based regimes Added column to indicate whether risk based or non-risk based Added row to calc 2 for entities where exclusion has been requested and lead state does not agree. Changed label of sensitivity test to "excluded NI/NF entities…". Updated cells D18 and D19to add excluded entities back in (as opposed to remove entities without material risk) Moved formulas to 2021, changed 2020 to input Added formulas for 2021 Fixed error in "Equity Allocation formula" that pointed to blank row. Deleted tabs 2022 GCC # # # The following set of colors are used to identify cells: # Parameters # Input cells # Data from other worksheets # Local calculations # Results propagated # # Sheet Content # Read-Me This sheet # Attestation # Input 1 - Schedule 1 Entity descriptions, financials, and inputs for calc capital # Input 2 - Inventory Adjustments to legal entity available and calc capital. # Input 2 - Inventory (limited) An abbreviated version of the Inventory for Limited Filers Input 3 - Capital Instruments Information on capital resources # Input 4 - Analytics Inputs for analytics # Input 5 - Sensitivity Analysis Inputs for on top adjustments due to XXX/AXXX and Permitted/Prescribed Practices # Input 6 - Questions Text boxes on how the template has been completed. # Calc 1 - Scaling (Ins) Calc of scaling options for ins entities. # Calc 2 - Other Calc Cap Calculated capital for non-insurance entities # Summary 1 - Entity Level Information on capital ratios at entity level # Summary 2 - Top Level Information on capital ratios at group level and under various sensitivity tests # Summary 3 - Analytics Summary of analytics # Summary 4 - Grouping Alternative Updated design based on discussion with Health Industry # GCC.Param Parameters and drop-down menus used in the template # # # # # # # GROUP INFORMATION PAGE (JURAT) Group Capital Calculation For the Year Ending December 31, 2022 (A) Group Name (B) NAIC Group Code (C) Lead State Contact Person for Group Capital Calculation: (D) First Name (E) Middle (G) Mail Address of Contact Person (H) City (I) State (K) Phone Number of GCC Contact Person Extension (L) E-mail Address of GCC Contact Person (M) Date Prepared (N) Preparer (if different than Contact) First Name (O) Is this filing an Original, Amended or Refiling? (Q1) If Amended, Amendment Number: Predominant Type of Business? Is Limited Filing? N Officers Name: Officers Title: Each says that they are the above described officers of the said insurance group, and that this Group Capital Calculation report is a true and fair representation of the group's affairs and has been completed in accordance with the NAIC Group Capital Calculation instructions according to the best of their information, knowledge and belief, respectively. (Signature) Denotes items that must be manually entered on the filing software.
no reviews yet
Please Login to review.