jagomart
digital resources
picture1_Inventory Excel Sheet 42131 | 2022 Gcc Template March 14  2022 Version (blank)


 181x       Filetype XLSX       File size 1.35 MB       Source: content.naic.org


File: Inventory Excel Sheet 42131 | 2022 Gcc Template March 14 2022 Version (blank)
tab template rcells various various read me schedule 1 row 5 schedule 1 e4 inventory table d arat capital instruments calc 1 scaling ins row 41 to 52 calc 1 ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
            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.
The words contained in this file might help you see if this file matches what you are looking for:

...Tab template rcells various read me schedule row e inventory table d arat capital instruments calc scaling ins to col k and summary input analytics stress inputs description of change updated dates from added new zealand list regimes keep number rows constant replaces regime removed deleted tabs reference prior names field testing cells version check comparing equity on carrying value in other debt calculation for use sensitivity test note that can still be entered main changed factor nonrisk based column indicate whether risk or entities where exclusion has been requested lead state does not agree label excluded ninf dto add back as opposed remove without material moved formulas fixed error allocation formula pointed blank gcc the following set colors are used identify parameters data worksheets local calculations results propagated sheet content readme this attestation entity descriptions financials adjustments legal available limited an abbreviated filers information resources analy...

no reviews yet
Please Login to review.