{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["global grafico","Global"],"not_rendered":{"images":2,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"global grafico","index":0,"n_rows":25,"n_cols":15,"rows_kept":25,"hidden":true}
{"$rows_empty":11}
[{"$nulls":10},"hasta 50.000 UF",null,"hasta 75.000 UF"]
[{"$nulls":3},"DESDE","FACTOR","REBAJA","IMPUESTO",{"$nulls":3},"PROPYME TRANSP.",null,"PROPYME  GENERAL",null,"REGIMEN GENERAL"]
[{"$nulls":3},{"v":0,"d":"M$0."},{"v":0,"d":"0.0%"},{"v":0,"d":"M$0."}]
[{"$nulls":3},{"v":8.266699,"d":"M$8.3"},{"v":0.04,"d":"4.0%"},{"v":0.33066792000000006,"d":"M$0.3"},null,null,"ingresos",null,"$$$$$$$$$$",null,"$$$$$$$$$$",null,"$$$$$$$$$$"]
[{"$nulls":3},{"v":18.370441,"d":"M$18.4"},{"v":0.08,"d":"8.0%"},{"v":1.06548552,"d":"M$1.1"},null,null," - gastos",null,"$$$$$$",null,"$$$$$$",null,"$$$$$$"]
[{"$nulls":3},{"v":30.617401,"d":"M$30.6"},{"v":0.135,"d":"13.5%"},{"v":2.74944252,"d":"M$2.7"},null,null," = utilidad",null,{"v":100000000,"d":"100,000,000"},null,{"v":100000000,"d":"100,000,000"},null,{"v":100000000,"d":"100,000,000"}]
[{"$nulls":3},{"v":42.864361,"d":"M$42.9"},{"v":0.23,"d":"23.0%"},{"v":6.82155672,"d":"M$6.8"}]
[{"$nulls":3},{"v":55.111321,"d":"M$55.1"},{"v":0.304,"d":"30.4%"},{"v":10.899794400000001,"d":"M$10.9"}]
[{"$nulls":3},{"v":73.481761,"d":"M$73.5"},{"v":0.35,"d":"35.0%"},{"v":14.279955359999999,"d":"M$14.3"},null,null,"% impuesto",null,{"v":0,"d":"0%"},null,{"v":0.25,"d":"25%"},null,{"v":0.27,"d":"27%"}]
[{"$nulls":3},{"v":189.827881,"d":"M$189.8"},{"v":0.4,"d":"40.0%"},{"v":23.77134936,"d":"M$23.8"},null,null,"impuesto",null,{"$f":"+K17*K20","v":0},null,{"$f":"+M17*M20","v":{"v":25000000,"d":"25,000,000"}},null,{"$f":"+O17*O20","v":{"v":27000000,"d":"27,000,000"}}]
[{"$nulls":14},{"$f":"O21*0.65","v":{"v":17550000,"d":"17,550,000"}}]
[{"$nulls":5},"IMPUESTO","$$$$$$"]
[{"$nulls":5},"CRÉDITO","$$$$"]
[{"$nulls":5},"PAGO O DEV","$$$"]

{"sheet":"Global","index":1,"n_rows":26,"n_cols":18,"rows_kept":26,"merged":[[5,2,5,6]]}
[{"$nulls":11},"UF",{"v":38800,"d":"38,800.00"}]
[null,null,"2A CATEGORIA"]
[null,null,"UTM Dic 2024",{"v":67294,"d":"67,294"},null,"renta bruta",{"$f":"M15","v":{"v":288800000,"d":"$ 288,800,000"}},{"$f":"G3/M17","v":{"v":357.6346578694485,"d":" 358 UTA"}},null,null,"N° PROPIEDADES",null,0," + 2 DFL2"]
[null,null,"(*ajustar)",{"$nulls":3},{"$f":"IF(G3>M17*150,0,IF(P8>M17*8,M17*8*N17,P8))*-1","v":{"v":0,"d":"$ 0"}},"intereses",null,null,"VALOR PROPIEDAD",null,{"v":70000000,"d":"70,000,000"}]
[{"$nulls":5},"renta imponible",{"$f":"SUM(G3:G4)","v":{"v":288800000,"d":"$ 288,800,000"}},{"$nulls":3},"VALOR ARRIENDO",null,{"v":350000,"d":"350,000"}]
[null,null,"TABLA DE IMPUESTO GLOBAL COMPLEMENTARIO",{"$nulls":7},"CUOTA CRÉDITO",null,{"v":250000,"d":"250,000"}]
[null,null,"DESDE","HASTA","FACTOR","REBAJA","IMPUESTO",{"$nulls":3},{"$f":"\"ARRIENDOS ANUALES DE \"&IF(N3=\" + 1 DFL2\",M3+1,IF(N3=\" + 2 DFL2\",M3+2,M3)) &\" PROP\"","v":"ARRIENDOS ANUALES DE 2 PROP"},null,{"$f":"M5*12*IF(N3=\" + 1 DFL2\",M3+1,IF(N3=\" + 2 DFL2\",M3+2,M3))","v":{"v":8400000,"d":"8,400,000"}},null,"CAPITAL","INTERESES","SEGUROS"]
[null,1,0,{"$f":"162*D3","v":{"v":10901628,"d":"10,901,628"}},"EXENTO",null,{"$f":"IF(G5<=D8,0,0)","v":0},{"$nulls":3},{"$f":"\"DIVIDENDOS ANUALES DE \"&IF(N3=\" + 1 DFL2\",M3+1,IF(N3=\" + 2 DFL2\",M3+2,M3)) &\" PROP\"","v":"DIVIDENDOS ANUALES DE 2 PROP"},null,{"$f":"M6*12*IF(N3=\" + 1 DFL2\",M3+1,IF(N3=\" + 2 DFL2\",M3+2,M3))","v":{"v":6000000,"d":"6,000,000"}},null,{"$f":"M8*51%","v":{"v":3060000,"d":"3,060,000"}},{"$f":"M8*43%","v":{"v":2580000,"d":"2,580,000"}},{"$f":"M8*6%","v":{"v":360000,"d":"360,000"}},{"$f":"SUM(O8:Q8)","v":{"v":6000000,"d":"6,000,000"}}]
[null,2,{"$f":"+D8+1","v":{"v":10901629,"d":"10,901,629"}},{"$f":"360*D3","v":{"v":24225840,"d":"24,225,840"}},{"v":0.04,"d":"0.040"},{"$f":"6.48*D3","v":{"v":436065.12000000005,"d":"436,065.12"}},{"$f":"IF(AND($G$5>=C9,$G$5<=D9),($G$5*E9)-F9,0)","v":0},{"$nulls":3},{"$f":"\"CONTRIBUCIONES \"&M3&\" PROP\"","v":"CONTRIBUCIONES 0 PROP"},null,{"$f":"N9*M3","v":0},{"v":70000,"d":"70,000"}]
[null,3,{"v":24225841,"d":"24,225,841"},{"$f":"600*D3","v":{"v":40376400,"d":"40,376,400"}},{"v":0.08,"d":"0.080"},{"$f":"20.88*D3","v":{"v":1405098.72,"d":"1,405,098.72"}},0,{"$nulls":3},{"$f":"\"ARRIENDOS AFECTOS \"&M3&\" PROP\"","v":"ARRIENDOS AFECTOS 0 PROP"},null,{"$f":"M3*M5*12","v":0}]
[null,4,{"v":40376401,"d":"40,376,401"},{"$f":"840*D3","v":{"v":56526960,"d":"56,526,960"}},0.135,{"$f":"53.88*D3","v":{"v":3625800.72,"d":"3,625,800.72"}},0,{"$nulls":3},"VENTA PROPIEDAD",null,{"$f":"M25","v":{"v":38800000,"d":"38,800,000"}}," > 8,000 UF"]
[null,5,{"v":56526961,"d":"56,526,961"},{"$f":"1080*D3","v":{"v":72677520,"d":"72,677,520"}},{"v":0.23,"d":"0.230"},{"$f":"133.68*D3","v":{"v":8995861.92,"d":"8,995,861.92"}},0,{"$nulls":3},"INGRESOS X SUELDO",null,{"v":70000000,"d":"70,000,000"}]
[null,6,{"v":72677521,"d":"72,677,521"},{"$f":"1440*D3","v":{"v":96903360,"d":"96,903,360"}},0.304,{"$f":"213.6*D3","v":{"v":14373998.4,"d":"14,373,998.40"}},0,{"$nulls":3},"INGRESOS POR RETIROS 14A",null,{"v":150000000,"d":"150,000,000"},{"v":0.27,"d":"27.0%"},{"$f":"M13*N13","v":{"v":40500000,"d":"40,500,000"}},{"v":0.65,"d":"65.0%"},{"$f":"O13*P13","v":{"v":26325000,"d":"26,325,000"}}]
[null,7,{"v":96903361,"d":"96,903,361"},{"$f":"3720*D3","v":{"v":250333680,"d":"250,333,680"}},{"v":0.35,"d":"0.350"},{"$f":"279.84*D3","v":{"v":18831552.959999997,"d":"18,831,552.96"}},0,{"$nulls":3},"INGRESOS POR HONORARIOS",null,{"v":30000000,"d":"30,000,000"},{"v":0.145,"d":"14.50%"},{"$f":"M14*N14","v":{"v":4350000,"d":"4,350,000"}},"(ppm de honorarios)"]
[null,8,{"$f":"+D14+1","v":{"v":250333681,"d":"250,333,681"}},"y mas",{"v":0.4,"d":"0.400"},{"$f":"465.84*D3","v":{"v":31348236.959999997,"d":"31,348,236.96"}},{"$f":"IF($G$5>=C15,($G$5*E15)-F15,0)","v":{"v":84171763.04,"d":"84,171,763"}},{"$nulls":4},"renta bruta",{"$f":"SUM(M10:M14)","v":{"v":288800000,"d":"288,800,000"}}]
[]
[{"$nulls":5},"Impuesto global",{"$f":"SUM(G8:G15)","v":{"v":84171763.04,"d":"84,171,763"}},{"$nulls":3},"UTA 2024","https://www.sii.cl/valores_y_fechas/utm/utm2022.htm",{"v":807528,"d":"807,528"},{"$f":"IF(AND(H3>90,H3<=150),250-(1.667*H3),100)/100","v":{"v":1,"d":"1.00"}}]
[{"$nulls":5},"Contribuciones",{"$f":"IF(M9>G17,G17,M9)*-1","v":0}]
[{"$nulls":5},"Crédito Honorarios",{"$f":"O14*-1","v":{"v":-4350000,"d":"-4,350,000"}}]
[{"$nulls":5},"Crédito retiros",{"$f":"Q13*-1","v":{"v":-26325000,"d":"-26,325,000"}}]
[{"$nulls":11},"uf",{"v":1500,"d":"1,500"},"Adquisición (Compra, Posesion Efectiva, etc)"]
[null,null,"*sueldo más retiros aumentan tu capacidad de crédito",null,null,{"$f":"IF(G22<=0,\"Devolución\",\"Pago\")","v":"Pago"},{"$f":"SUM(G17:G20)","v":{"v":53496763.04000001,"d":"$ 53,496,763"}},{"$nulls":4},"uf",{"v":2500,"d":"2,500"},"venta antes de un año"]
[{"$nulls":11},"uf",{"$f":"M22-M21","v":{"v":1000,"d":"1,000"}},"utilidad"]
[null,null,"SIN DFL2"]
[null,null," + 1 DFL2",{"$nulls":9},{"$f":"M23*M1","v":{"v":38800000,"d":"38,800,000"}},"en CL$",{"$f":"8000*M1","v":{"v":310400000,"d":"310,400,000"}},"en CL$"]
[null,null," + 2 DFL2"]