{"text_format":"2","workbook":"xls","n_sheets":11,"sheets":["Scoring","Scoring 2","FeuilVBA","Frais - dates valeur","Activité ret collective","Activité retArt83","Gestion Fi","Gestion Fi (UC)","Gestion adm","Conditions sortie et transfert","Fonds de Rentes"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":1,"defined_names":57,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Scoring","index":0,"n_rows":61,"n_cols":20,"rows_kept":61,"cut":false,"hidden":false,"merged":[[5,5,6,8]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[null,"Pondération","A","B","C",4,{"$nulls":4},3,"A","B","C","Coef","Code"]
["Total global (Max = 280)",56,144,181.7,209.55,{"$nulls":5},"Synthèse des frais"]
[{"$nulls":10},"Frais sur cotisations",3,2.5,5,1,1,null,1,2,3]
["Frais directs et indirects",{"$nulls":9},"Frais sur encours gérés (phase épargne)",5,5,4,1,2,null,1,2,3]
["- Frais sur cotisations",4.5,3,4,5,1,0,0,0,null,"Frais sur arrérages",3,5,4,2,3,null,1,2,3]
["- Encours - Phase épargne",null,3,4,5,2,0,0,0,null,"Frais sur encours gérés (phase rente) ",4.444444444444445,4.444444444444445,5,3,4,null,1,2,3]
["- Encours - Phase de rente",null,3,4,4,4,0,0,0,null,"Participation aux bénéfices au titre de la phase d'épargne",5,4,4,1,5,null,1,2,3]
["- Frais sur rentes",4.5,3,4,5,3,0,0,0,null,"Participation aux bénéfices au titre de la phase de rente",5,4,4,1,6,null,1,2,3]
["- Transfert",8,3,4,5,40,0,0,0,null,"Frais sur arbitrages (changement support financier)",0,0,0,1,7,null,1,2,3]
["- Participation aux bénéfices",3,4,5,5,5,6,0,0,null,"Dates de valeur",0,0,0,1,8,null,1,2,3]
["Total",20,63,83,100,{"$nulls":5},"Frais directs et indirects",0,0,0,1,9,null,1,2,3]
[{"$nulls":10},"Synthèse activité retraite collective"]
[{"$nulls":10},"Encours gérés - Phase Epargne Exp retraite entreprise",5,1.6222863514133927,2.942233028186438,2,10,null,1,2,3]
["Gestion financière : Fonds en Euros",{"$nulls":9},"Encours gérés - Phase Rente Exp retraite entreprise",3,5,4,2,11,null,1,2,3]
["- Historique des rendements",4,3,5,4,26,0,0,0,null,"Cotisations (CA) Exp retraite entreprise",3,4,5,1,12,null,1,2,3]
["- Exposition PIGS",4,3,3,5,31,0,0,0,null,"Rentes en cours = rubrique encours gérés ",0,0,0,1,13,null,1,2,3]
["- Marge de solvabilité",2,3,5,4,30,0,0,0,null,"Marge de solvabilité = rubrique rating actionnariat",0,0,0,1,14,null,1,2,3]
["- Point d'équilibre de la partie actions",2,0,0,0,32,0,0,0,null,"Nbre de bénéficiaires - Phase Epargne Exp retraite entreprise ",3,4,5,2,15,null,1,2,3]
["Total",12,30,42,44,{"$nulls":5},"Nbre de bénéficiaires - Phase Rente Exp retraite entreprise",5,4,3,2,16,null,1,2,3]
[{"$nulls":10},"Rating actionnariat",0,0,0,2,17,null,1,2,3]
[{"$nulls":10},"Synthèse activité retraite"]
["Gestion financière : Fonds en UC",{"$nulls":9},"Encours gérés - Phase Epargne",3,5,4,2,18,null,1,2,3]
["- Coherence offre de fonds",3,3,4.4,4.6,10,12,15,0,null,"Encours gérés - Phase Rente",3,5,4,2,19,null,1,2,3]
["- Performances versus benchmark",1,3,4,4.25,18,20,22,0,null,"Cotisations (CA)",3,5,4,1,20,null,1,2,3]
["- Frais",2,4,3.75,3.75,11,16,19,23,null,"Rentes en cours",0,0,0,2,21,null,1,2,3]
["Total",6,20,24.700000000000003,25.549999999999997,{"$nulls":5},"Nbre de bénéficiaires - Phase Epargne",3,1,5,1,22,null,1,2,3]
[{"$nulls":10},"Nbre de bénéficiaires - Phase Rente",5,1,4,2,23,null,1,2,3]
[{"$nulls":10},"Gestion financière - fonds en euros"]
["Profil assureur",{"$nulls":9},"Encours gérés",5,4,5,1,24,null,1,2,3]
["- Expérience en retraite collective",4,0,0,0,0,0,0,0,null,"Composition =  rubrique importance de la poche actions",0,0,0,3,25,null,1,2,3]
["- Expérience en retraite à cotisations définies",4,0,0,0,0,0,0,0,null,"Historique des rendements (5 ans)",3,5,4,1,26,null,1,2,3]
["- Fonds de rente",2,0,0,0,0,0,0,0,null,"Réserve de capitalisation =  rubrique niveau des + values latentes",0,0,0,1,27,null,1,2,3]
["Total",10,0,0,0,{"$nulls":5},"Plus ou moins value latente en % de l'actif = rubrique niveau des + values latentes",0,0,0,1,28,null,1,2,3]
[{"$nulls":10},"Fonds communs avec l'assurance vie",0,0,0,1,29,null,1,2,3]
[{"$nulls":10},"Taux de couverture de la marge de solvabilité",3,5,4,1,30,null,1,2,3]
["Gestion administrative",{"$nulls":9},"Composition Géographique ",3,3,5,1,31,null,1,2,3]
["- Reporting annuel (etreprise + salariés)",2,3.5,4.5,5,33,34,0,0,null,"Point mort partie actions (indice CAC 40)",0,0,0,1,32,null,1,2,3]
["- Actes de gestion",2,4,4,5,35,0,0,0,null,"Gestion administrative"]
["- Accompagnement à la mise en place",null,0,0,0,36,0,0,0,null,"Dates de transmission",3,4,5,1,33,null,1,2,3]
["- Reporting rentiers",2,4,3,5,37,0,0,0,null,"Comité de suivi pour faire le point",4,5,5,1,34,null,1,2,3]
["Total",6,23,23,30,{"$nulls":5},"Délai moyen des actes de gestion",4,4,5,2,35,null,1,2,3]
[{"$nulls":10},"Communication aux salariés",0,0,0,1,36,null,1,2,3]
[{"$nulls":10},"Reporting rentiers descriptif",4,3,5,2,37,null,1,2,3]
["Qualité des réponses",{"$nulls":9},"Conditions de sortie et transfert"]
["- Aspect global",2,4,4.5,5,{"$nulls":5},"Conditions de sortie possible",3,5,5,1,38,null,1,2,3]
["Total",2,8,9,10,{"$nulls":5},"Transfert fonds de rente",0,0,0,1,39,null,1,2,3]
[{"$nulls":8},"FIN",null,"Frais",3,4,5,4,40,null,1,2,3]
[{"$nulls":10},"% Intérets Fonds en € transférés",4,4,5,1,41,null,1,2,3]
[{"$nulls":10},"Valeur de transfert des fonds (épargne)",0,0,0,4,42,null,1,2,3]
[{"$nulls":10},"Fonds de rentes"]
[{"$nulls":10},"Résultats techniques (moyenne 5 ans)",0,0,0,1,43,null,1,2,3]
[{"$nulls":10},"Fonds en Euros commun avec celui de la phase d'épargne",0,0,0,1,44,null,1,2,3]
[{"$nulls":10},"Rendement net",3,4,5,2,45,null,1,2,3]
[{"$nulls":10},"Pertes techniques",4,3,5,2,46,null,1,2,3]
[{"$nulls":10},"Encours gérés",4,3,5,1,47,null,1,2,3]
[{"$nulls":10},"Taux de participation aux bénéfices (techniques et financiers)",4,5,5,1,48,null,1,2,3]

{"sheet":"Scoring 2","index":1,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[14,0,14,1],[15,0,15,1],[16,0,16,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,1]],"flags":["formulas_cached_only"]}
["Régime de retraite\nNotation /5","Poids","A","B","C"]
["Frais directs et indirects",0.35714285714285715,3.15,4.15,5]
["Gestion financière : Fonds en Euros",0.21428571428571427,2.5,3.5,3.6666666666666665]
["Gestion financière : Fonds en UC",0.10714285714285714,3.3333333333333335,4.116666666666667,4.258333333333333]
["Profil assureur",0.17857142857142858,0,0,0]
["Gestion administrative",0.10714285714285714,3.8333333333333335,3.8333333333333335,5]
["Qualité des réponses",0.03571428571428571,4,4.5,5]
["GLOBAL (avec pondération)",0.9999999999999999,2.571428571428571,3.244642857142857,3.741964285714285]
[]
[]
["Nombres de points cumulés par poste",null,"A","B","C"]
["Frais directs et indirects",null,63,83,100]
["Gestion financière : Fonds en Euros",null,30,42,44]
["Gestion financière : Fonds en UC",null,20,24.700000000000003,25.549999999999997]
["Profil assureur",null,0,0,0]
["Gestion administrative",null,23,23,30]
["Qualité des réponses",null,8,9,10]

{"sheet":"FeuilVBA","index":2,"n_rows":19,"n_cols":6,"rows_kept":19,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Valeurs","Points Rang (plafond)","Points Rang (plancher)","Points\nPar proportion (plafond)","Points\nPar proportion (plancher)"]
[0.0045,5,4,5,3.8888888888888897]
[0.0045,5,4,5,3.8888888888888897]
[0.0035,4,5,3.8888888888888897,5]
[null,{"$error":"#N/A"},{"$error":"#N/A"},0,{"$error":"#DIV/0!"}]
[null,{"$error":"#N/A"},{"$error":"#N/A"},0,{"$error":"#DIV/0!"}]
[]
["Nbr candidats",3]
[1,1,"Toutes les réponses ont une valeur strictement positive"]
[0,2,"Toutes les réponses ont une valeur positive avec au moins une valeur nulle"]
[0,3,"Toutes les réponses ont une valeur strictement négative"]
[0,4,"Toutes les réponses ont une valeur négative avec au moins une valeur nulle"]
[0,5,"Les réponses présentent à la fois des valeurs négatives et positives"]
[1]
[]
["Tri des valeurs par ordre décroissant et Points associés selon méthode de rang"]
["Valeurs",0.0045,0.0045,0.0035]
["Points Rang (plafond)",5,5,4,3,3]
["Points Rang (plancher)",4,4,5,0,0]

{"sheet":"Frais - dates valeur","index":3,"n_rows":28,"n_cols":9,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Synthèse des frais","A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Frais sur cotisations",0.005,0.006,0.003,3,2.5,5,"Par proportion (plancher)",1]
[]
["Frais sur encours gérés"]
["-au titre de la phase d'épargne",0.0045,0.0045,0.0035,5,5,4,"Rang (plafond)",2]
["en UC",null,0.002,0.0025]
["-au titre de la phase de rente",0.0045,0.0045,0.004,4.444444444444445,4.444444444444445,5,"Appréciation",4]
[]
["Participation aux bénéfices"]
["-au titre de la phase d'épargne",0.9,1,1,5,4,4,"Rang (plancher)",5]
["-au titre de la phase de rente",0.9,1,1,5,4,4,"Rang (plancher)",6]
[]
["Frais sur arbitrages (changement support financier)",0,"gratuit (max 3 par an)","1 gratuit puis 0,20%",null,null,null,"Appréciation",7]
[null,"entre gestion libre et pilotée"]
["Frais de service des rentes",0.03,0.01,0.02,3,5,4,"Rang (plancher)",3]
["assiete (si frais plafonnés)",null,null,"(max 1/2 PASS)"]
[]
["Dates de valeur entre",{"$nulls":7},8]
["-la reception des fonds et le credit du compte","1er jour du mois qui suit la date de reception","J+1"]
["-le débit du compte et le credit du fonds de rentes","1e jour du mois encours","NA"]
["-le débit du fonds de rentes et le paiement des rentes","1e jour du trimestre encours","NA"]
[]
["Indiquez ci-dessous d'autres frais directs ou pas","transfert : 1% et 0% après 10 ans ",{"$nulls":6},9]
[null,"Vif : 0,5%"]
[{"$nulls":8},"FIN"]

{"sheet":"Activité ret collective","index":4,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Synthèse activité retraite collective","A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Encours gérés (M €) - Phase Epargne",4947,15247,8406.88,5,1.6222863514133927,2.942233028186438,"Par proportion (plancher)",10]
["dont (M €) Fonds en Euros",4254,5492,5953]
["dont (M €) UC",693,9755,2453.88]
[]
["Encours gérés (M €) - Phase Rente",2763,4513,4082.88,3,5,4,"Rang (plafond)",11]
[]
["Cotisations (CA - M €)",273,969,1106.2,3,4,5,"Rang (plafond)",12]
[]
["Nbre de bénéficiaires - Phase Epargne",305701,550000,1181452,3,4,5,"Rang (plafond)",15]
[]
["Nbre de bénéficiaires - Phase Rente",85080,75000,69766,5,4,3,"Rang (plafond)",16]
[{"$nulls":8},"FIN"]

{"sheet":"Activité retArt83","index":5,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Synthèse activité retraite cotisations définies","A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Encours gérés (M €) - Phase Epargne",3731,null,null,3,5,4,"Rang (plafond)",18]
["dont (M €) Fonds en Euros",3675]
["dont (M €) UC",56]
[]
["Encours gérés (M €) - Phase Rente",2169,null,null,3,5,4,"Rang (plafond)",19]
[]
["Chiffre d'Affaires (M €)",133,null,null,3,5,4,"Rang (plafond)",20]
[]
["Nbre de bénéficiaires - Phase Epargne",305701,null,null,3,1,5,"Appréciation",22]
[]
["Nombre de bénéficiaires - Phase Rente",67666,null,null,5,1,4,"Appréciation",23]
[{"$nulls":8},"FIN"]

{"sheet":"Gestion Fi","index":6,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Gestion financière - fonds en euros","A","B","C","Scores",null,null,"Méthode","Code"]
["Encours gérés",37049,9200,35285,5,4,5,"Appréciation",24]
[]
["Composition",{"$nulls":6},"Appréciation",25]
["- produits de taux",0.7931107452292909,0.822,0.82]
["- partie action et immobilier",0.18807282247833948,0.178,0.18]
["- autres précisez",0.01880860482064293]
[]
["Historique des rendements (5 ans)","rendements bruts"]
[2010,0.0325,0.0434,0.042]
[2009,0.0395,0.044,0.044]
[2008,0.0413,0.046,0.047]
[2007,0.057,0.051,0.051]
[2006,0.0509,0.0508,0.049]
[]
["Moyenne ",0.04424,0.047040000000000005,0.046599999999999996,3,5,4,"Rang (plafond)",26]
[]
["Plus ou moins value latente en % de l'actif",-0.0366,0,0.0174,null,null,null,"Appréciation",28]
[null,"au 31/12/2010"]
["Taux de couverture de la marge de solvabilité",1.3,2.03,1.61,3,5,4,"Rang (plafond)",30]
[null,"au 31/12/2010"]
["Fonds commun avec l'assurance vie ou pas","Oui","Non",0.2844,null,null,null,"Appréciation",29]
["- Si commun avec l'assurance vie, indiquez","-"]
["le % du Fonds dédié à la retraite collective"]
[]
["Composition Géographique ",0.28,0.25,0.12,3,3,5,"Appréciation",31]
["Grece",null,0.01]
["- produits de taux",1767.8411630200003,null,12,0.0003400878560294743]
["- partie action et immobilier",0.0103376,null,0]
["- autres précisez",null,null,0]
["Italie",null,0.11]
["- produits de taux",4720.620960569999,null,1621,0.04594020121864815]
["- partie action et immobilier",235.97838528,null,56,0.00158707666147088]
["- autres précisez",null,null,0]
["Espagne",null,0.13]
["- produits de taux",3099.9958183700014,null,1925,0.054555760238061496]
["- partie action et immobilier",null,null,139,0.003939350999008077]
["- autres précisez",null,null,0]
["Portugal",null,0]
["- produits de taux",633.3927083500001,null,331,0.009380756695479666]
["- partie action et immobilier",null,null,0]
["- autres précisez"]
["Plus ou moins values latentes au 30/09/2011",-0.0786,"Sur-performance de 3% par rapport au benchmark à fin septembre 2011, le portefeuille bénéficiant notamment de sa sous-pondération en valeurs financières",360]
[null,"en % de l'actif"]
["Point mort partie actions (indice CAC 40)",4006,0,3000,null,null,null,"Appréciation",32]
[{"$nulls":8},"FIN"]

{"sheet":"Gestion Fi (UC)","index":7,"n_rows":82,"n_cols":17,"rows_kept":82,"cut":false,"hidden":false,"merged":[[77,1,77,3],[3,1,3,6],[3,7,3,16],[4,1,4,2],[4,3,4,4],[4,5,4,6],[4,7,4,8],[4,9,4,10],[4,11,4,12],[4,13,4,14],[4,15,4,16],[5,1,5,2],[5,3,5,4],[5,5,5,6],[5,7,5,8],[5,9,5,10],[5,11,5,12],[5,13,5,14],[5,15,5,16],[20,1,20,2],[20,3,20,4],[20,5,20,6],[20,7,20,8],[20,9,20,10],[20,11,20,12],[20,13,20,14],[20,15,20,16],[27,7,29,7],[27,8,29,8],[27,1,29,1],[27,2,29,2],[27,3,29,3],[27,4,29,4],[27,11,29,11],[30,0,31,0],[30,1,31,1],[30,2,31,2],[30,3,31,3],[30,4,31,4],[30,5,31,5],[30,6,31,6],[27,5,29,5],[27,6,29,6],[30,9,31,9],[30,10,31,10],[27,9,29,9],[27,10,29,10],[30,11,31,11],[32,0,37,0],[32,1,37,1],[32,2,37,2],[32,4,37,4],[32,6,37,6],[32,8,37,8],[32,10,37,10],[30,7,31,7],[30,8,31,8],[39,1,43,1],[42,2,43,2],[59,0,61,0],[64,0,65,0],[64,1,65,1],[64,2,65,2]],"flags":["formulas_cached_only"]}
["GAN EUROCOURTAGE"]
["Gestion Financière UC reprendre les éléments du cahier des charges sous forme de tableau similaire"]
[{"$nulls":6},0.75,null,null,null,1,null,0.75]
[null,"Supports de la gestion pilotée",{"$nulls":5},"Supports de la gestion libre "]
[null,"1 - Composition Retraite Pérennité (FR0007076591)",null,"2- Composition Retraite Harmonie (FR0007076583 - profil de gestion équilibré) ",null,"3- Composition Retraite Plénitude (FR0007076575  - profil de gestion dynamique) ",null,"4- Composition Groupama Index Inflation Euro (FR0010271486) ",null,"5- Composition Groupama Croissance (FR0010722405) ",null,"6- Composition  Euro Capital Durable (FR0010271528) ",null,"7- Composition  Groupama FP Actions Émergentes (FR0010636720) ",null,"8- Composition  Groupama FP Flexible Allocation (FR0010646299) "]
["Encours total géré par fonds au 30/09/2011 en EUR",9422028.7,null,41160636.29,null,45076205.17,null,268755450.98,null,186280570.85,null,224830603.36,null,37393456.47,null,197585399.06]
["Composition ","Actions (31/08/11)",0.215,"Actions (31/08/11)",0.383,"Actions (31/08/11)",0.6985,"Obligations Etat",0.891,"Actions",0.9582,"Actions",0.9523,"Actions",0.946,"Expo Stratégie Actions (31/08/11)",0.0074]
[null,"Obligations (31/08/11)",0.559,"Obligations (31/08/11)",0.384,"Obligations (31/08/11)",0.0675,"obligations publiques",0.042,"Liquidités et OPCVM monétaires",0.0418,"Liquidités et OPCVM monétaires",0.0477,"Cash",0.054,"Expo Stratégie Crédit (31/08/11)",0.4789]
[null,"Trésorerie (31/08/11)",0.027,"Obligations convertibles (31/08/11)",0.0003,"Trésorerie (31/08/11)",0.082,"Obligations Financières",0.039,{"$nulls":6},"Expo Stratégie obligations convertibles (31/08/11)",0.1085]
[null,"OPCVM Actions (31/08/11)",0.017,"Trésorerie (31/08/11)",0.083,"OPCVM Actions (31/08/11)",0.037,"Titrisation",0.0195,{"$nulls":6},"Expo stratégie devises (31/08/11)",0.0938]
[null,"OPCVM Taux (31/08/11)",0.1,"OPCVM Actions (31/08/11)",0.016,"OPCVM Taux (31/08/11)",0.03,"Liquidités",0.0085,{"$nulls":6},"Expo stratégies diversification (31/08/11)",-0.016]
[null,"OPCVM monétaires (31/08/11)",0.083,"OPCVM Taux (31/08/11)",0.053,"OPCVM monétaires (31/08/11)",0.085,{"$nulls":8},"Expo monétaire et divers (31/08/11)",0.3274]
[null,null,null,"OPCVM monétaires (31/08/11)",0.081]
["Historique des rendements en corrélation avec ceux du marché de référence (Benchmark)","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark","rendements nets","Benchmark"]
[2010,0.0268,0.0051,0.0264,0.0004,0.0328,-0.0115,-0.0048,0.0106,0.0352,0.0041,0.0136,-0.0044,0.3178,0.2746,0.0886,0.0044]
[2009,0.1158,0.1093,0.1397,0.1441,0.2097,0.2013,0.0734,0.0802,0.3092,0.239,0.1953,0.2306,0.8374,0.7379,0.1185,0.0073]
[2008,-0.0848,-0.1001,-0.1819,-0.2174,-0.3247,-0.3936,-0.0017,0.0398,null,-0.4309,-0.3699,-0.4658,-0.5623,-0.5018,-0.0775,0.04]
[2007,0.0238,0.0406,0.0297,0.0498,0.0448,0.0647,0.0122,0.0193,null,0.0041,0.1052,0.0532,0.1964,0.233,0.0174,0.0402]
[2006,0.0492,0.0481,0.0927,0.0818,0.1542,0.1418,0.0175,0.03,null,0.1937,0.0721,0.0721,0.1775,0.196,-0.0033,0.029]
["Moyenne ",0.02616,0.0206,0.02132,0.01174,0.023360000000000002,0.0005400000000000016,0.019320000000000004,0.03598,0.1722,0.001999999999999996,0.003259999999999999,-0.02286,0.19336,0.18794,0.028739999999999998,0.02418]
["Frais de gestion réels des supports",0.008,null,0.012,null,0.015,null,0.012,null,0.0175,null,0.015,null,"0,9% + 20% surperformance",null,"1,15%+20% surperformance >7%"]
[]
[]
[]
["AXA"]
["Gestion Financière UC reprendre les éléments du cahier des charges sous forme de tableau similaire"]
[null,null,null,0.5,1,null,null,null,0.5]
[null,"AXA Protect","AXA WF Framlington Human Capital A","50% STOXX Europe Small 200 Total Return + 50% STOXX Europe Mid 200 Total Return depuis le 29/10/07","AXA WF Framlington Europe A","100% MSCI EUROPE NET RETURN depuis le 15/10/08","AXA WF Euro Credit Short Duration A","100% Merrill lynch EMU Corporates 1-3 Years Euro depuis le 03/08/09","AXA WF Euro Inflation Bonds A","100% Barclays Euro Govt Inflation-Linked Bond Index All Maturities TR depuis le 31/05/03","AXA WF Euro 5-7 A","100% Citigroup EuroBIG 5-7 YR. - RETURN IND. depuis le 17/04/06"]
[]
[]
["Encours gérés au 30/09/11","7.95 M€","119.13 M€",null,"235.50 M€",null,"575.70 M€",null,"186.48 M€",null,"616.77 M€"]
[]
["Composition",null,"actions europe petites et moyennes capitalisations",null,"actions de sociétés cotées ou domiciliées en Europe",null,"Titres investment grade et de haute qualité de maturité comprise entre 1 et 3 ans",null,"obligations indexées sur l’inflation de la zone euro et investissements sur opportunités dans des obligations à taux fixes",null,"titres\nobligataires de maturité moyenne à longue émis en euros"]
[]
[]
[]
[]
[]
["Historique des rendements"]
[2010,"fonds créé en juin 2011",0.2133,0.2363,0.1247,0.111,0.0229,0.0337,-0.001,0.0097,0.0373,0.0279]
[2009,null,0.4073,0.4924,"ND",null,0.0899,0.0725,0.0669,0.0813,0.0971,0.087]
[2008,null,-0.4383,-0.4762,"ND",null,-0.0072,0.0627,0.0427,0.0385,0.0533,0.0688]
[2007,null,"fonds créé en 2008",null,"ND",null,0.0218,0.0374,0.0134,0.0191,0.0157,0.0219]
[2006,null,null,null,"ND",null,"ND",null,"ND",null,"ND"]
["Frais de gestion réels (2010)","1.35%*",0.0189,null,0.0164,null,0.0078,null,0.0063,null,0.0072]
["(TER)","(frais max notice)"]
[]
[]
[null,"= Benchmark"]
[]
[null,"= Fonds Actions"]
[]
[null,"= Fonds Obligations"]
[]
[]
[]
["ARIAL"]
["Gestion Financière UC reprendre les éléments du cahier des charges sous forme de tableau similaire"]
[]
["Arial"]
[]
[]
[2453.88]
[]
["Années Calendaires","Arial - Composite Actions ","Arial - Composite Taux "]
[]
[2010,17.57271576,2.02906082374739]
[2009,32.3352013634277,8.529046629844306]
[2008,-44.9829939795898,-3.3701961624707066]
[2007,0.00385070394182801,-0.4828233071997423]
[2006,12.1245013283325,-1.2479169347236252]
[null,3.41,1.09]
[]
[]
[]
[]
[null,"Gan","Axa","Arial"]
["Gestion financière - fonds en UC","Scores",null,null,"Méthode","Code"]
["Coherence offre de fonds",0.3125,0.3333333333333333,0.4166666666666667]
["Performances versus benchmark",0.6666666666666666,0.3333333333333333,0.5]
["Frais ",0.8333333333333334,0.6666666666666666,0.6666666666666666]
["Total ",3.0208333333333335,2.222222222222222,2.6388888888888893,null,"Nouveau champs de note"]

{"sheet":"Gestion adm","index":8,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
["Gestion administrative",null,null,null,3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
[null,"A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Reporting date de transmission des",null,null,null,3,4,5,"Appréciation",33]
["- relevés de compte entreprise","-","février","2è trim n+1"]
["- situations individuelles de retraite","mai-juin année N+1","avant le 31 mars","février/mars n+1"]
["- accès Internet pour situations de compte individuelles","à la régularisation du contrat","en temps réel","oui"]
["- accès Internet pour situations de compte entreprises","à la régularisation du contrat","en temps réel","oui"]
["- prise en charge par l'assureur des notices individuelles","avec l'envoi du contrat à régulariser","version électronique","oui"]
["- nombre de gestionnaires article 83",13,"Organisation non basée sur le type de contrat","27 (polyvalents)"]
["- nombre de gestionnaires retraite collective",17,"110 personnes",27]
[]
["Comité de suivi pour faire le point sur",null,null,null,4,5,5,"Appréciation",34]
["- le déroulé de la gestion administrative","sur demande de l'entreprise","oui","oui"]
["- les informations (supports financiers, juridiques…)","sur demande de l'entreprise","oui","oui"]
[]
["Délai moyen des actes de gestion",null,null,null,4,4,5,"Appréciation",35]
["- liquidation retraite","j + 15","30 jours ouvrés","10 jours"]
["- avenants aux contrats","j +1","dépend de la nature de l'avenant","10 jours"]
["- affectation des cotisations","En € :date de valeur = 11ème jour ouvré qui suit l'encaissement des cotisations","1 jour ouvré","€ : jour encaissement\nUC : 1er vendredi "]
[null,"En UC: date de référence = j+6 jours ouvrés après le jour de l'encaissement, date de valeur : 1er jour de cotation qui suit la date de référence"]
["Communication aux salariés",{"$nulls":6},"Appréciation",36]
["- promouvoir les versements volontaires","à la souscription et chaque fin d'année","au moins une fois par an","oui"]
["- reunions annuelles d'information","sur demande de l'entreprise","à convenir avec Nike","oui"]
[]
["Reporting rentiers descriptif",null,null,null,4,3,5,"Appréciation",37]
["- de la plate forme telephonique et durée moyenne","prise en charge immédiatement","27 secondes d'attente","oui 15 secondes"]
["- promouvoir les versements volontaires","ne concerne pas les rentiers","Non pertinent pour des rentiers","oui "]
[{"$nulls":8},"FIN"]

{"sheet":"Conditions sortie et transfert","index":9,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Conditions de sortie et transfert","A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Conditions de sortie possible si oui :","oui ",null,null,3,5,5,"Appréciation",38]
["- au titre de la phase d'épargne","A titre individuel","oui","oui"]
[]
["Conséquence du transfert indiquer"]
["- les frais éventuels","transfert : 1% et 0% après 10 ans ","aucun ","néant",3,4,5,"Rang (plancher)",40]
["- la date de transfert effectif","maxi 3 mois après la demande","maximum 3 mois","2 mois maxi",null,null,null,"Appréciation",39]
["- l'écart entre la date de transfert et la dernière revalorisation","= écart entre le dernier relevé et la date de transfert","aucun ","€ / revalo au taux\nminimum garanti\nUC/ dernière valor."]
["- l'incidence sur la participation aux bénéfices","pas de PB l'année de transfert","au prorata temporis","néant"]
[]
[]
[]
["% Intérets Fonds en € transférés","intérêt au prorata depuis le début de l'année jusqu'au 1er jour du mois de la date du transfert","Prorata temporis",1,4,4,5,"Appréciation",41]
[{"$nulls":8},"FIN"]

{"sheet":"Fonds de Rentes","index":10,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,4,0,6],[2,4,2,6]],"flags":["formulas_cached_only"]}
[{"$nulls":4},3,null,null,3]
[{"$nulls":4},"Oui","Oui","Oui"]
["Fonds de rentes ","A","B","C","Scores",null,null,"Méthode","Code"]
[]
["Fonds en Euros commun avec celui de la phase d'épargne","oui","oui","oui",null,null,null,"Appréciation",44]
[]
["Rendement net avec base taux technique = 0%",0.03753,0.04054,0.04129999999999999,3,4,5,"Appréciation",45]
["détail des 5 dernières années"]
[2010,0.0345,0.0369,0.037]
[2009,0.037,0.0375,0.0375]
[2008,0.045,0.0395,0.042]
[2007,0.046,0.0445,0.047]
[2006,0.046,0.0443,0.043]
[]
["Moyenne des pertes techniques des 5 derniers exercices","-",-0.0026,0.0413,4,3,5,"Appréciation",46]
[]
["Encours gérés (M €)",2763,1200,4082.88,4,3,5,"Rang (plafond)",47]
[]
["Taux de participation aux bénéfices (techniques et financiers)",0.9,1,1,4,5,5,"Rang (plafond)",48]
[{"$nulls":8},"FIN"]