{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Formulario","Hoja1","Hoja2"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Formulario","index":0,"n_rows":31,"n_cols":32,"rows_kept":31,"cut":false,"hidden":false,"merged":[[30,22,30,28],[30,29,30,36],[29,26,29,36],[18,1,18,5],[18,6,18,13],[19,1,19,13],[21,1,21,13],[20,16,20,24],[18,16,18,24],[20,1,20,3],[20,7,20,10],[20,4,20,6],[20,11,20,13],[18,31,18,36],[21,31,21,36],[22,31,22,36],[30,1,30,7],[29,0,29,1],[29,2,29,20],[29,22,29,25],[22,14,22,15],[23,31,23,36],[9,31,10,31],[9,32,10,36],[15,14,15,15],[16,14,16,15],[17,14,17,15],[3,0,4,0],[3,1,4,1],[3,2,4,2],[3,3,4,3],[3,4,4,4],[17,1,17,13],[14,4,14,13],[16,4,16,13],[13,0,14,0],[12,1,12,13],[11,0,12,0],[13,1,13,13],[11,1,11,13],[15,1,15,13],[9,1,9,19],[7,31,7,36],[3,25,3,35],[3,5,4,5],[7,0,8,0],[0,9,1,30],[0,31,1,32],[3,9,4,21],[7,30,8,30],[7,1,7,13],[7,16,7,29],[7,14,8,15],[8,16,8,29],[8,31,8,36],[4,24,4,35],[9,20,10,21],[9,22,9,29],[21,0,22,0],[13,14,13,15],[14,14,14,15],[19,14,19,15],[20,14,20,15],[21,14,21,15],[16,16,16,24],[10,22,10,29],[14,1,14,3],[21,25,21,30],[19,25,19,30],[13,16,13,24],[14,16,14,24],[15,16,15,24],[9,0,10,0],[9,30,10,30],[10,14,10,15],[18,14,18,15],[11,14,12,15],[15,0,16,0],[17,0,18,0],[22,25,22,30],[11,25,12,30],[11,31,12,36],[28,0,28,36],[17,31,17,36],[18,25,18,30],[19,31,19,36],[20,25,20,30],[20,31,20,36],[13,31,13,36],[14,25,14,30],[14,31,14,36],[15,25,15,30],[15,31,15,36],[16,25,16,30],[22,16,22,24],[11,16,12,24],[19,16,19,24],[13,25,13,30],[17,25,17,30],[22,1,22,13],[19,0,20,0],[17,16,17,24],[16,1,16,3],[16,31,16,36]]}
[null,null," ","FORMULARIO 101",null,null,null,null,null,"DECLARACIÓN DEL IMPUESTO SOBRE EL VALOR ESPECULATIVO DE SUELO EN LA TRANSFERENCIA DE BIENES INMUEBLES",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"   No."]
[null,null,"RESOLUCIÓN N° 044-DFM-GT-2017"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,104," Nº. DE FORMULARIO QUE SUSTITUYE"]
[]
[]
[" 200 IDENTIFICACIÓN DEL SUJETO PASIVO"]
[201," RUC",null,null,null,null,null,null,null,null,null,null,null,null,202,null," RAZÓN O DENOMINACIÓN SOCIAL",null,null,null,null,null,null,null,null,null,null,null,null,null,203,"NRO. TRAMITE DE TRANSFERENCIA"]
[null,null,null,null,null,null,null,null,null,null,null,0,0,1]
[201,"CLAVE CATASTRAL",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,202,null,"DIRECCION:",null,null,null,null,null,null,null,203,"NRO. "]
[]
[204,"TIPO DE TRANSFERENCIA DE DOMINIO",null,null,null,null,null,null,null,null,null,null,null,null,210,null,"Valor de la Transferencia"]
[null,"SELECCIONE"]
[205,"FECHA DE TRANSFERENCIA",null,null,null,null,null,null,null,null,null,null,null,null,211,null,"(-) Costo de Adquisición Ajustada",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(+Z18*Z19,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,212,null,"      Costo del Bien "]
[206,"FECHA DE  ADQUISICIÓN ",null,null,null,null,null,null,null,null,null,null,null,null,213,null,"       (+) Mejoras"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,214,null,"       (+) Valor CEM"]
[207,"NÚMERO DE MESES TRANSCURRIDOS ",null,null,null,null,null,null,null,null,null,null,null,null,215,null,"Valor Total Costo de Adquisición (211+212+212+214)",null,null,null,null,null,null,null,null,{"$f":"SUM(Z15:AE17)","v":0}]
[null,{"$f":"IF(B15=0,0,Hoja1!H15)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,216,null,"Factor de Ajuste*",null,null,null,null,null,null,null,null,{"$f":"TRUNC(ROUND(IF(B15=0,0,IFERROR((1+Hoja1!H16)^(Hoja1!H15/12),0)),5),5)","v":0}]
[208,"PRESTAMO HIPOTECARIO",null,null,null,null,null,null,null,null,null,null,null,null,217,null,"Base Imponible (210-215)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF12-AF14","v":0}]
[null,"CON PRESTAMO ",null,null,null,null,null,"SIN PRESTAMO ",null,null,null,null,null,null,218,null,"(-) Ganancia Adicional exenta  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"24*Hoja1!H1","v":9264}]
[209,"INSTITUCION FINANCIERA QUE OTORGA EL CRÉDITO",null,null,null,null,null,null,null,null,null,null,null,null,218,null,"Ganancia extraordinaria gravada ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+AF20-AF21","v":-9264}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,220,null,"Impuesto a IVES ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AF22<0,0,+AF22*75%)","v":0}]
[]
[]
[]
[]
[]
["FIRMA SUJETO PASIVO / REPRESENTANTE LEGAL"]
["NOMBRE :",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NOTARIA","Nombre del Notario:",null,null,null,"SELECCIONE"]
[198,"Cédula de Identidad o No. de Pasaporte:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,199,"Direccion de la Notaria y Nro. telefónico:",null,null,null,null,null,null,{"$f":"VLOOKUP(AA30,Hoja2!B$2:C$10,2,FALSE)","v":0}]

{"sheet":"Hoja1","index":1,"n_rows":22,"n_cols":14,"rows_kept":22,"cut":false,"hidden":true,"merged":[[10,6,10,8]]}
["Cálculo del IVES",null,null,null,null,null,"RBU",386,"TIPR",1,"enero",7.5399999999999995E-2,31]
[null,null,null,null,null,null,"Fecha 1","2017-02-10",null,2,"febrero ",{"$f":"+L1","v":7.5399999999999995E-2},28]
["REF","CONCEPTOS","TIPO DE DATOS","SUBTOTAL","VALOR",null,"Fecha 2","2017-09-15",null,3,"marzo",7.4999999999999997E-2,31]
["A","Valor de transferencia","Dato a ingresar",null,43480.06,null,null,{"$f":"+H3-H2","v":217},null,4,"abril",7.3800000000000004E-2,30]
["B","(-) Costo de Adquisición  ",null,null,{"$f":"+D9*D10","v":41693.465692908692},null,null,{"$f":"+H4/N16","v":6.5757575757575761},null,5,"mayo ",7.2099999999999997E-2,31]
["C","       Costo del Bien ","Dato a ingresar",38648.94,null,null,"n",{"$f":"+H5/12","v":0.54797979797979801},null,6,"junio ",7.1199999999999999E-2,30]
["D","       (+) Mejoras","Dato a ingresar",null,null,null,null,null,null,7,"julio",7.1499999999999994E-2,31]
["E","       (+) Valor CEM","Dato a ingresar",null,null,null,null,null,null,8,"agosto",7.1599999999999997E-2,31]
["F","Valor Total Costo de Adquisición (C+D+E)","Sumatoria",{"$f":"SUM(D6:D8)","v":38648.94},null,null,null,null,null,9,"septiembre",7.0999999999999994E-2,30]
["G","Factor de Ajuste*","                                  i: promedio de la tasa de interés pasiva referencial.     (n) número de meses transcurridos entre la fecha de adquisición y la fecha de transferencia /12",{"$f":"(1+H16)^(H15/12)","v":1.0787738471717125},null,null,null,null,null,10,"octubre",7.1499999999999994E-2,31]
["H","Base Imponible ","(A-B)",null,{"$f":"E4-E5","v":1786.5943070913054},null,"FORMULAS FACTOR AJUSTE",null,null,11,"noviembre",6.9699999999999998E-2,30]
["I","(-) Ganancia Adicional exenta  ","hasta 24 RBU",null,{"$f":"24*H1","v":9264},null,null,null,null,12,"diciembre",7.0499999999999993E-2,31]
["J","Ganancia extraordinaria gravada ","(H-I)",null,{"$f":"+E11-E12","v":-7477.4056929086946},null,"f1",{"$f":"MONTH(Formulario!B17)","v":1},{"$f":"MATCH(H13,J1:J14,0)","v":1},13,"enero",7.3800000000000004E-2,31]
["K","Impuesto a IVES ","Apliar Tabla",null,{"$f":"+E13*75%","v":-5608.054269681521},null,"f2",{"$f":"MONTH(Formulario!B15)","v":1},null,14,"febrero ",7.2700000000000001E-2]
["* Crear tabla para ingresar la tasa pasiva cada mes en el ejemplo son 12 meses transcurridos",null,null,null,null,null,"#meses",{"$f":"IF(H14<=H13,12-H13+H14+1,12+H14)","v":13},{"$f":"I13+H15-1","v":13}]
[null,null,null,null,null,null,"factor",{"$f":"SUM(INDIRECT(\"L\"&I13&\":L\"&I15))/H15","v":7.2499999999999995E-2},null,null,null,{"$f":"AVERAGE(L1:L14)","v":7.2514285714285712E-2},{"$f":"SUM(M1:M13)","v":396},{"$f":"+M16/12","v":33}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(INDIRECT(\"L\"&H22&\":L\"&H23))","v":0}]

{"sheet":"Hoja2","index":2,"n_rows":28,"n_cols":3,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["TIPO DE TRANSFERENCIA DE DOMINIO","NOTARIOS","DIRECCION"]
["SELECCIONE","SELECCIONE"]
["ACCIONES Y DERECHOS Y OTROS CANTONES","DR. MARCO NICOLALDE MONTALVO","Sucre 5-12 y García Moreno. Telf. 2601166"]
["ADJUDICACIONES","DRA. SANDRA CASTILLO PAGUAY","Rocafuerte 4-33 y Grijalva. Telf. 2601850"]
["CESION DE AREAS","AB. LEONARDO SUAREZ SERRANO","Sucre 6-24. Telf: 2950112"]
["CESION DE GANACIALES","DR. DIEGO ANDRADE ARMAS","García Moreno 4-26 y Rocafuerte. Telf. 2643801"]
["COMPRAVENTA","DR. ARTURO TERÁN ALMEIDA","Rocafuerte 4-74 y García Moreno. Telf. 2952185"]
["COMPRAVENTA DE INTEGRACION","DRA. MERCEDES KARINA TERAN FLORES","García Moreno 4-04 y Rocafuerte. Telf. 2601908"]
["COMPRAVENTA OTROS CANTONES","DR. MARIO BRICEÑO SANCHEZ VINUEZA ","Aurelio Mosquera y Rafael Troya. Telf. 5002724"]
["DONACIONES","DR. LUIS ABDON GARRIDO MERA","Olmedo 1-94 y Rafael Troya. Telf. 2605186"]
["DONACIONES OTROS CANTONES"]
["DONACIONES PADRE E HIJOS"]
["DONACIONES HERMANOS"]
["EXCEDENTES DE AREAS"]
["EXPROPIACIONES"]
["LEGALIZACION SOLO TERRENO"]
["LIQUIDACION SOCIEDAD CONYUGAL"]
["NUDA PROPIEDAD"]
["OTRAS TRANSFERENCIAS"]
["OTRAS TRANSFERENCIAS OTROS CANTONES"]
["PARTICIONES CON CUOTA"]
["PARTICIONES Y REFUNDICIONES"]
["PERMUTA"]
["PRESCRIPCION EXTRAORDINARIA"]
["REMATE PUBLICO"]
["USUFRUCTO"]
["USUFRUCTO OTROS CANTONES"]
["VENTA DE DERECHOS Y ACCIONES"]