{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["F.3000-32"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"comments":0,"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":"F.3000-32","index":0,"n_rows":154,"n_cols":44,"rows_kept":154,"cut":false,"hidden":false,"merged":[[153,0,153,1],[136,1,140,1],[1,0,1,42],[3,0,3,41],[4,0,4,41],[5,0,5,41]]}
[]
["SUPERINTENDENCIA FINANCIERA DE COLOMBIA"]
[]
["RESULTADO TECNICO Y ESTADISTICO "]
["FORMATO 290"]
["Circular Externa  036 de  2013"]
[]
["ENTIDAD",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FECHA DE REPORTE"]
[null,"               TIPO                    CODIGO",null,null,null,null,"NOMBRE",null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DDMMAAA",null,null,null,null,null,null,null," "]
[]
[]
["SUB CUENTA","CONCEPTO"," 1   TOTAL"," 2   SUBTOTAL - RAMOS"," 3   AUTOMOVILES"," 4   SOAT"," 5   CUMPLIMIENTO"," 6   RESPONSABILIDAD CIVIL"," 7   INCENDIO"," 8   TERREMOTO"," 9   SUSTRACCION"," 10  TRANSPORTE"," 11  CORRIENTE DÉBIL"," 12  TODO RIESGO CONTRATISTA"," 13  MANEJO"," 14  LUCRO CESANTE"," 15   MONTAJE Y ROTURA DE MAQUINARIA"," 16  AVIACIÓN"," 17  NAVEGACIÓN Y CASCO"," 18  MINAS Y PETRÓLEOS"," 19  VIDRIOS"," 20  CRÉDITO COMERCIAL"," 21  CRÉDITO A LA EXPORTACIÓN"," 22  AGRÍCOLA"," 23  SEMOVIENTES"," 24  DESEMPLEO"," 25  HOGAR"," 26  EXEQUIAS"," 27  ACCIDENTES PERSONALES"," 28  COLECTIVO VIDA"," 29  EDUCATIVO"," 30  VIDA GRUPO"," 31  SALUD"," 32  ENFERMEDADES DE ALTO COSTO"," 33  VIDA INDIVIDUAL"," 34  PREVISIONAL DE  INVALIDEZ.Y SOBREVIVENCIA"," 35  RIESGOS LABORALES"," 36  PENSIONES LEY 100"," 37  PENSIONES VOLUNTARIAS"," 38  PENSIONES CON CONMUTACIÓN PENSIONAL"," 39  PATRIM. AUTÓNOMO - FDO. PENS. VOLUNTARIAS","40 RENTAS VOLUNTARIAS",null,"UNIDAD DE CAPTURA"]
[]
[null,"PRIMAS RETENIDAS"]
[" 005","Primas Emitidas Directas"]
[" 010","Primas aceptadas en coaseguro"]
[" 015","Cancelaciones y/o anulaciones primas emitidas directas y coaseguro (resta)"]
[" 020","Aceptadas Reaseguro interior"]
[" 025","Aceptadas Reaseguro exterior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"01"]
[" 030","Cancelaciones y/o anulaciones primas de reaseguro aceptado (resta)"]
[" 035","Cedidas Reaseguro interior (resta)"]
[" 040","Cedidas Reaseguro exterior (resta)"]
[" 045","Cancelaciones y/o anulaciones primas de reaseguro cedido "]
[" 050","Primas aceptadas y/o cedidas por Cámara de Compensación SOAT"]
[" 999","Subtotal"]
[null,"RESERVAS TECNICAS Y MATEMATICAS"]
[" 005","Liberación Reserva Técnica de riesgo en curso"]
[" 010","Liberación Reserva Matemática"]
[" 015","Liberación Reserva Matemática Riesgos Laborales (resta)"]
["020","Liberación Reserva Seguro de Vida Ahorro con Participa.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02"]
["025","Constitución Reserva Técnica de riesgo en curso (resta)"]
["030","Constitución Reserva matemática (resta)"]
["035","Constitución Reserva matemática Riesgos Laborales"]
["040","Constitución Reserva Seguro de Vida Ahorro con Participa.(resta)"]
[" 999","Subtotal"]
[null,"PRIMAS DEVENGADAS"]
[" 999","Primas Devengadas (UC1 más UC2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03"]
[null,"LIBERACIÓN Y CONSTITUCION DE RESERVAS SINIESTROS"]
[" 005","Liberación Reserva Matemática Riesgos Laborales"]
[" 010","Liberación Reserva para Siniestros Avisados"]
[" 015","Liberación Reserva para Siniestros No Avisados"]
[" 020","Liberación Reservas desviación de siniestralidad"]
[" 025","Liberación Reservas especiales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"04"]
[" 030","Constitución Reserva matemática Riesgos Laborales (resta)"]
[" 035","Constitución Reserva Siniestros Avisados  (resta)"]
[" 040","Constitución Reserva Siniestros No Avisados  (resta)"]
["045","Constitución Reserva desviación siniestralidad (resta)"]
["050","Constitución Reservas especiales (resta)"]
[" 999","Subtotal"]
[null,"SINIESTROS LIQUIDADOS"]
[" 005","Siniestros liquidados"]
[" 010","Siniestros de aceptaciones reaseguro interior"]
[" 015","Siniestros de aceptaciones contratos no proporcionales reaseguros interior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05"]
[" 020","Siniestros de aceptaciones reaseguro exterior"]
[" 025","Siniestros de aceptaciones contratos no proporcionales reaseguros exterior"]
[" 999","Subtotal"]
[null,"REEMBOLSO DE SINIESTROS"]
[" 005","Reembolso de siniestros sobre cesiones reaseguro interior"]
[" 010","Reembolso siniestros contratos no proporcionales reaseguro interior"]
[" 015","Reembolso de siniestros sobre cesiones reaseguro exterior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"06"]
[" 020","Reembolso de siniestros contratos no proporcionales reaseguro exterior"]
[" 025","Reembolso stros. garantiz. por la Nación rgos. polít y extraor."]
["030","Reembolsos por enfermedad profesional"]
[" 999","Subtotal"]
[null,"SALVAMENTOS Y RECOBROS"]
[" 005","Salvamentos de aceptaciones reaseguro interior"]
[" 010","Salvamentos de aceptaciones reaseguro exterior"]
[" 015","Salvamentos liquidados y realizados",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07"]
[" 020","Recobros"]
[" 025","Gastos Salvamentos parte reasegurada interior (resta)"]
["030","Gastos Salvamentos parte reasegurada exterior (resta)"]
[" 999","Subtotal"]
[null,"SINIESTROS CUENTA COMPAÑÍA"]
[" 999","Siniestros cuenta compañía (UC4 - UC5 + UC6 + UC7)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08"]
[null,"OTROS INGRESOS Y/O GASTOS NETOS DE REASEGURO"]
[" 005","Comisiones de Reaseguro Cedido"]
[" 010","Ingresos Exceso de Pérdida"]
[" 015","Participación Utilidades Reaseguro Cedido"]
[" 020","Intereses y Gastos Reconocidos por Reaseguradores",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09"]
[" 025","Intereses Reconocidos a Reaseguradores (resta)"]
[" 030","Participación de Utilidades y Otros (resta)"]
[" 035","Costo Exceso de Pérdida (resta)"]
[" 999","Subtotal"]
[null,"OTROS INGRESOS Y/O GASTOS NETOS DE SEGUROS"]
[" 005","Otros productos de seguros"]
[" 010","Remuneración de administración de coaseguro"]
[" 015","Gastos de Administración de Coaseguro Aceptado (resta)"]
[" 020","Provisión cuentas por cobrar actividad aseguradora (resta)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10"]
[" 025","Costos Riesgos Profesionales (resta)"]
[" 030","Contribuciones de Seguros (resta)"]
[" 035","Otros Egresos (resta)"]
[" 999","Subtotal"]
[null,"GASTOS ADMINISTRATIVOS Y DE PERSONAL"]
[" 005","Gastos administrativos"]
[" 010","Gastos de personal",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11"]
[" 999","Subtotal"]
[null,"GASTOS POR COMISIONES"]
[" 005","Remuneración a favor de intermediarios"]
[" 010","Comisiones AFP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12"]
[" 015","Comisiones por uso de red de oficinas"]
[" 999"," Subtotal"]
[null," INGRESOS Y/O GASTOS NETOS REASEGUROS, SEGUROS, ADM/TIVOS Y DE PERSONAL"]
[null,"Ingresos y/o Gastos Netos Seguros, Reaseguro, Administrativos y de Personal "]
[" 999"," (UC9 + UC10 - UC11 - UC12)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13"]
[null,"RESULTADO TECNICO"]
[" 999","Resultado técnico (UC3 + UC8 + UC13)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14"]
[null,"OTROS INGRESOS Y/O EGRESOS"]
[" 005","Ingresos y Egresos Portafolio de Inversiones"]
[" 010","Otras Provisiones (resta)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[" 015","Ingresos y/o Egresos reportes programas especiales"]
[" 020","Otros ingresos y Egresos"]
[" 999","Subtotal"]
[null,"UTILIDAD ANTES DE IMPUESTOS"]
[" 999","Utilidad antes de impuestos (UC14 + UC15)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"]
[null,"IMPUESTOS DE RENTA Y COMPLEMENTARIOS"]
["999","Impuesto de renta y complementarios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17"]
[null,"RESULTADOS DEL EJERCICIO"]
[" 999","Resultados del ejercicio (UC16  -  UC17)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18"]
[null,"VALORES ASEGURADOS (Millones de pesos)"]
[" 005","Directos"]
[" 010","Aceptados en reaseguro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19"]
[" 015","Parte reaseguro al interior (resta)"]
[" 020","Parte reaseguro al exterior (resta)"]
[999,"Retención neta de la compañía"]
[null,"NUMERO DE POLIZAS VIGENTES"]
[" 005","Pólizas vigentes al final del año anterior"]
[" 010","Pólizas emitidas nuevas",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[" 015","Pólizas rehabilitadas"]
[" 020","Pólizas canceladas y/o vencidas (resta)"]
[" 999","Total pólizas vigentes final del ejercicio"]
[null,"INFORMACION DE REASEGUROS"]
[" 005","Primas cedidas contratos automáticos interior"]
[" 010","Primas cedidas contratos facultativos interior",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[" 015","Primas cedidas contratos automáticos exterior"]
[" 020","Primas cedidas contratos facultativos exterior"]
[" 999","Subtotal"]
[null,"ELIMINADA"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[]
[]
[null,"INFORMACION ESPECIAL DE TERREMOTO"]
[" 005","Primas emitidas ramo de terremoto"]
[" 010","Primas emitidas (coberturas) de terremoto incluidas en otros ramos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
["015","Primas cedidas interior y exterior terremoto"]
["020","Primas cedidas interior y exterior (coberturas) de terremoto incluidas en otros ramos"]
[" 999","Total primas retenidas riesgo de terremoto"]
[null,"INFORMACIÓN ESPECIAL FONDO NACIONAL DE BOMBEROS     "]
[" 005","Primas emitidas pólizas de seguros sujetas a aporte         "]
[" 010","Ajustes o compensaciones períodos anteriores (resta)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[999,"Subtotal base de cálculo del aporte sobre las pólizas de seguros"]
[]
["COLUMNAS",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40]
["DICIEMBRE 2013",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F 3000-32"]