{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Promocion 10+10","Hoja1","Valor UF"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":14,"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":"Promocion 10+10","index":0,"n_rows":28,"n_cols":16,"rows_kept":28,"cut":false,"hidden":false,"merged":[[9,6,9,11],[19,6,19,11],[1,1,1,2],[3,0,3,3]]}
[]
[{"$f":"+TODAY()","v":"2023-11-08"},36111.71]
[]
["Promoción 10+10 CON secundarios",null,null,null,null,null,"Tipo de Unidad","Unidad","Precio Lista","Dcto","Precio De Venta","Precio Promoción 10+10","% Sobre Precio Lista",null,null,1]
[null,null,"UF","$$",null,null,"Bien Principal","D309",2947,0.05,{"$f":"ROUND(I5*(1-$J$5),0)","v":2800},{"$f":"C11","v":3221},{"$f":"+L5/I5-1","v":9.297590770274855E-2}]
["Precio Bien Principal",null,{"$f":"+K5","v":2800},{"$f":"ValorUF*PrecioVta","v":101112788},null,null,"Bodega",65,99,null,{"$f":"ROUND(I6*(1-$J$6),0)","v":99},{"$f":"+K6","v":99}]
["Precio Secundarios",null,{"$f":"+K6+K7","v":409},{"$f":"+C7*ValorUF","v":14769689.389999999},null,null,"Estacionamiento",58,310,null,{"$f":"ROUND(I7*(1-$J$7),0)","v":310},{"$f":"+K7","v":310}]
["Compra Total",null,{"$f":"+PrecioVta+C7","v":3209},{"$f":"+C8*ValorUF","v":115882477.39},null,null,"Total",null,{"$f":"SUM(I5:I7)","v":3356},null,{"$f":"SUM(K5:K7)","v":3209},{"$f":"+SUM(L5:L7)","v":3630}]
["Factor División",null,{"$f":"IF(SUM(B17:B19)=1,(Financiamiento+Pie)-(PorcentajeBonoPie*19%/1.19),\"Revisar %%\")","v":0.88403361344537812}]
["Precio unidad con BP",null,{"$f":"ROUND(C8/C9,0)","v":3630},{"$f":"ValorUF*C10","v":131085507.3},null,null,"Simulación CON Promoción 10+10"]
["Precio Dpto + Promocion",null,{"$f":"+C10-C12","v":3221},null,null,null,"Tasa",4.4999999999999998E-2,null,"Crédito Hip.",null,{"$f":"+CreditoHip","v":2904}]
["Precio Secundarios",null,{"$f":"+C7","v":409},null,null,null,null,"Dividendo",null,null,"Renta",null,null,{"$f":"ROUND(+C16-L11/Financiamiento,2)","v":0}]
["IVA Sobreprecio",null,{"$f":"(TotalCompra*PorcentajeBonoPie*0.19)/(1.19*$C$9)","v":57.957224334600781},null,null,null,"Plazo","UF","$$",null,"UF","$$"]
[null,null,null,null,null,null,12,{"$f":"PMT(Tasa/12,G14*12,-$L$11)","v":26.13623698358867},{"$f":"ROUND(H14*ValorUF,0)","v":943824},null,{"$f":"ROUND(H14/0.25,2)","v":104.54},{"$f":"I14/0.25","v":3775296}]
["Resumen Promoción 10+10",null,null,null,null,null,15,{"$f":"PMT(Tasa/12,G15*12,-$L$11)","v":22.21540510714264},{"$f":"ROUND(H15*ValorUF,0)","v":802236},null,{"$f":"ROUND(H15/0.25,2)","v":88.86},{"$f":"I15/0.25","v":3208944}]
["Precio Total Promoción 10+10",null,{"$f":"C10","v":3630},{"$f":"C16*ValorUF","v":131085507.3},"IVA",null,20,{"$f":"PMT(Tasa/12,G16*12,-$L$11)","v":18.372137885427712},{"$f":"ROUND(H16*ValorUF,0)","v":663449},null,73.489999999999995,2653796]
["Crédito Hip.",{"$f":"1-Pie-PorcentajeBonoPie","v":0.8},{"$f":"C16*B17","v":2904},{"$f":"C17*ValorUF","v":104868405.84},{"$f":"C17/1.19*19%","v":463.66386554621852},null,25,{"$f":"PMT(Tasa/12,G17*12,-$L$11)","v":16.14137516001616},{"$f":"ROUND(H17*ValorUF,0)","v":582893},null,64.569999999999993,2331572]
["Pie",0.1,{"$f":"+C16*B18","v":363},{"$f":"C18*ValorUF","v":13108550.73},{"$f":"C18/1.19*19%","v":57.957983193277315},null,30,{"$f":"PMT(Tasa/12,G18*12,-$L$11)","v":14.714141397343575},{"$f":"ROUND(H18*ValorUF,0)","v":531353},null,58.86,2125412]
["Promoción 10+10",0.1,{"$f":"+C16*B19","v":363},{"$f":"C19*ValorUF","v":13108550.73},{"$f":"C19/1.19*19%","v":57.957983193277315}]
["Recaudación Inmob Bruto",null,{"$f":"C17+C18","v":3267},null,null,null,"Simulación SIN Promoción 10+10"]
["IVA BP",null,{"$f":"C13","v":57.957224334600781},null,null,null,"Tasa",{"$f":"+Tasa","v":4.4999999999999998E-2},null,"Crédito Hip.",null,{"$f":"+TotalCompra*Financiamiento","v":2567.2000000000003}]
["Recaudación Inmob Neto",null,{"$f":"C20-C21","v":3209.0427756653994},null,null,null,null,"Dividendo",null,null,"Renta",null,null,{"$f":"+K8-L21/Financiamiento","v":0}]
["Factura",null,null,null,null,null,"Plazo","UF","$$",null,"UF","$$"]
["Neto",null,{"$f":"C16/1.19","v":3050.4201680672272},{"$f":"+C24*ValorUF","v":110155888.48739497},null,null,12,{"$f":"PMT(Tasa/12,G24*12,-$L$21)","v":23.10500949871517},{"$f":"ROUND(H24*ValorUF,0)","v":834361},null,{"$f":"ROUND(H24/0.25,2)","v":92.42},{"$f":"I24/0.25","v":3337444}]
["Iva",null,{"$f":"C24*19%","v":579.57983193277323},{"$f":"+C25*ValorUF","v":20929618.812605046},{"$f":"IF(ROUND(C25-SUM(E17:E19),0)=0,\"IVA OK\",\"Revisar IVA\")","v":"IVA OK"},null,15,{"$f":"PMT(Tasa/12,G25*12,-$L$21)","v":19.638907710418934},{"$f":"ROUND(H25*ValorUF,0)","v":709195},null,{"$f":"ROUND(H25/0.25,2)","v":78.56},{"$f":"I25/0.25","v":2836780}]
["Total",null,{"$f":"+C24+C25","v":3630.0000000000005},{"$f":"+C26*ValorUF","v":131085507.30000001},null,null,20,{"$f":"PMT(Tasa/12,G26*12,-$L$21)","v":16.241374786318879},{"$f":"ROUND(H26*ValorUF,0)","v":586504},null,64.97,2346016]
[null,null,null,null,null,null,25,{"$f":"PMT(Tasa/12,G27*12,-$L$21)","v":14.269331374240181},{"$f":"ROUND(H27*ValorUF,0)","v":515290},null,57.08,2061160]
[null,null,null,null,null,null,30,{"$f":"PMT(Tasa/12,G28*12,-$L$21)","v":13.00762527385001},{"$f":"ROUND(H28*ValorUF,0)","v":469728},null,52.03,1878912]

{"sheet":"Hoja1","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
["Valor Lista ",3765]
["Valor con dscto 3% ",3652]
["Estacionamiento ",250]
[]
["Valor Total",3902]
["Pie 10%",390]
["Chip ",3512]
["Pie"]
["5% contado ",195]
["5% Pagaré ",195]

{"sheet":"Valor UF","index":2,"n_rows":253,"n_cols":2,"rows_kept":253,"cut":false,"hidden":true,"merged":[]}
["Fecha","Valor"]
["2023-09-09",36172.21]
["2023-09-08",36167.550000000003]
["2023-09-07",36162.9]
["2023-09-06",36158.239999999998]
["2023-09-05",36153.58]
["2023-09-04",36148.93]
["2023-09-03",36144.269999999997]
["2023-09-02",36139.620000000003]
["2023-09-01",36134.97]
["2023-08-31",36130.31]
["2023-08-30",36125.660000000003]
["2023-08-29",36121.01]
["2023-08-28",36116.36]
["2023-08-27",36111.71]
["2023-08-26",36107.06]
["2023-08-25",36102.410000000003]
["2023-08-24",36097.760000000002]
["2023-08-23",36093.11]
["2023-08-22",36088.46]
["2023-08-21",36083.82]
["2023-08-20",36079.17]
["2023-08-19",36074.53]
["2023-08-18",36069.879999999997]
["2023-08-17",36065.24]
["2023-08-16",36060.589999999997]
["2023-08-15",36055.949999999997]
["2023-08-14",36051.31]
["2023-08-13",36046.660000000003]
["2023-08-12",36042.019999999997]
["2023-08-11",36037.379999999997]
["2023-08-10",36032.74]
["2023-08-09",36028.1]
["2023-08-08",36030.43]
["2023-08-07",36032.75]
["2023-08-06",36035.08]
["2023-08-05",36037.410000000003]
["2023-08-04",36039.730000000003]
["2023-08-03",36042.06]
["2023-08-02",36044.39]
["2023-08-01",36046.720000000001]
["2023-07-31",36049.050000000003]
["2023-07-30",36051.370000000003]
["2023-07-29",36053.699999999997]
["2023-07-28",36056.03]
["2023-07-27",36058.36]
["2023-07-26",36060.69]
["2023-07-25",36063.019999999997]
["2023-07-24",36065.35]
["2023-07-23",36067.68]
["2023-07-22",36070]
["2023-07-21",36072.33]
["2023-07-20",36074.660000000003]
["2023-07-19",36076.99]
["2023-07-18",36079.32]
["2023-07-17",36081.65]
["2023-07-16",36083.980000000003]
["2023-07-15",36086.31]
["2023-07-14",36088.639999999999]
["2023-07-13",36090.980000000003]
["2023-07-12",36093.31]
["2023-07-11",36095.64]
["2023-07-10",36097.97]
["2023-07-09",36100.300000000003]
["2023-07-08",36099.1]
["2023-07-07",36097.9]
["2023-07-06",36096.699999999997]
["2023-07-05",36095.49]
["2023-07-04",36094.29]
["2023-07-03",36093.089999999997]
["2023-07-02",36091.89]
["2023-07-01",36090.68]
["2023-06-30",36089.480000000003]
["2023-06-29",36088.28]
["2023-06-28",36087.08]
["2023-06-27",36085.870000000003]
["2023-06-26",36084.67]
["2023-06-25",36083.47]
["2023-06-24",36082.269999999997]
["2023-06-23",36081.07]
["2023-06-22",36079.86]
["2023-06-21",36078.660000000003]
["2023-06-20",36077.46]
["2023-06-19",36076.26]
["2023-06-18",36075.06]
["2023-06-17",36073.85]
["2023-06-16",36072.65]
["2023-06-15",36071.449999999997]
["2023-06-14",36070.25]
["2023-06-13",36069.050000000003]
["2023-06-12",36067.839999999997]
["2023-06-11",36066.639999999999]
["2023-06-10",36065.440000000002]
["2023-06-09",36064.239999999998]
["2023-06-08",36060.75]
["2023-06-07",36057.269999999997]
["2023-06-06",36053.79]
["2023-06-05",36050.300000000003]
["2023-06-04",36046.82]
["2023-06-03",36043.339999999997]
["2023-06-02",36039.85]
["2023-06-01",36036.370000000003]
["2023-05-31",36032.89]
["2023-05-30",36029.410000000003]
["2023-05-29",36025.93]
["2023-05-28",36022.44]
["2023-05-27",36018.959999999999]
["2023-05-26",36015.480000000003]
["2023-05-25",36012]
["2023-05-24",36008.519999999997]
["2023-05-23",36005.050000000003]
["2023-05-22",36001.57]
["2023-05-21",35998.089999999997]
["2023-05-20",35994.61]
["2023-05-19",35991.129999999997]
["2023-05-18",35987.65]
["2023-05-17",35984.18]
["2023-05-16",35980.699999999997]
["2023-05-15",35977.22]
["2023-05-14",35973.75]
["2023-05-13",35970.269999999997]
["2023-05-12",35966.79]
["2023-05-11",35963.32]
["2023-05-10",35959.839999999997]
["2023-05-09",35956.370000000003]
["2023-05-08",35943.26]
["2023-05-07",35930.15]
["2023-05-06",35917.050000000003]
["2023-05-05",35903.96]
["2023-05-04",35890.870000000003]
["2023-05-03",35877.78]
["2023-05-02",35864.699999999997]
["2023-05-01",35851.620000000003]
["2023-04-30",35838.550000000003]
["2023-04-29",35825.49]
["2023-04-28",35812.42]
["2023-04-27",35799.370000000003]
["2023-04-26",35786.31]
["2023-04-25",35773.269999999997]
["2023-04-24",35760.22]
["2023-04-23",35747.19]
["2023-04-22",35734.15]
["2023-04-21",35721.120000000003]
["2023-04-20",35708.1]
["2023-04-19",35695.08]
["2023-04-18",35682.07]
["2023-04-17",35669.06]
["2023-04-16",35656.050000000003]
["2023-04-15",35643.050000000003]
["2023-04-14",35630.06]
["2023-04-13",35617.07]
["2023-04-12",35604.080000000002]
["2023-04-11",35591.1]
["2023-04-10",35578.120000000003]
["2023-04-09",35565.15]
["2023-04-08",35566.300000000003]
["2023-04-07",35567.440000000002]
["2023-04-06",35568.589999999997]
["2023-04-05",35569.74]
["2023-04-04",35570.89]
["2023-04-03",35572.04]
["2023-04-02",35573.19]
["2023-04-01",35574.33]
["2023-03-31",35575.480000000003]
["2023-03-30",35576.629999999997]
["2023-03-29",35577.78]
["2023-03-28",35578.93]
["2023-03-27",35580.07]
["2023-03-26",35581.22]
["2023-03-25",35582.370000000003]
["2023-03-24",35583.519999999997]
["2023-03-23",35584.67]
["2023-03-22",35585.82]
["2023-03-21",35586.959999999999]
["2023-03-20",35588.11]
["2023-03-19",35589.26]
["2023-03-18",35590.410000000003]
["2023-03-17",35591.56]
["2023-03-16",35592.71]
["2023-03-15",35593.86]
["2023-03-14",35595.01]
["2023-03-13",35596.15]
["2023-03-12",35597.300000000003]
["2023-03-11",35598.449999999997]
["2023-03-10",35599.599999999999]
["2023-03-09",35600.75]
["2023-03-08",35590.620000000003]
["2023-03-07",35580.49]
["2023-03-06",35570.370000000003]
["2023-03-05",35560.239999999998]
["2023-03-04",35550.129999999997]
["2023-03-03",35540.01]
["2023-03-02",35529.9]
["2023-03-01",35519.79]
["2023-02-28",35509.68]
["2023-02-27",35499.58]
["2023-02-26",35489.480000000003]
["2023-02-25",35479.379999999997]
["2023-02-24",35469.279999999999]
["2023-02-23",35459.19]
["2023-02-22",35449.1]
["2023-02-21",35439.019999999997]
["2023-02-20",35428.93]
["2023-02-19",35418.85]
["2023-02-18",35408.769999999997]
["2023-02-17",35398.699999999997]
["2023-02-16",35388.629999999997]
["2023-02-15",35378.559999999998]
["2023-02-14",35368.49]
["2023-02-13",35358.43]
["2023-02-12",35348.370000000003]
["2023-02-11",35338.31]
["2023-02-10",35328.25]
["2023-02-09",35318.199999999997]
["2023-02-08",35314.79]
["2023-02-07",35311.370000000003]
["2023-02-06",35307.96]
["2023-02-05",35304.550000000003]
["2023-02-04",35301.14]
["2023-02-03",35297.730000000003]
["2023-02-02",35294.32]
["2023-02-01",35290.910000000003]
["2023-01-31",35287.5]
["2023-01-30",35284.089999999997]
["2023-01-29",35280.68]
["2023-01-28",35277.269999999997]
["2023-01-27",35273.86]
["2023-01-26",35270.449999999997]
["2023-01-25",35267.040000000001]
["2023-01-24",35263.64]
["2023-01-23",35260.230000000003]
["2023-01-22",35256.82]
["2023-01-21",35253.410000000003]
["2023-01-20",35250.01]
["2023-01-19",35246.6]
["2023-01-18",35243.199999999997]
["2023-01-17",35239.79]
["2023-01-16",35236.39]
["2023-01-15",35232.980000000003]
["2023-01-14",35229.58]
["2023-01-13",35226.17]
["2023-01-12",35222.769999999997]
["2023-01-11",35219.370000000003]
["2023-01-10",35215.96]
["2023-01-09",35212.559999999998]
["2023-01-08",35201.26]
["2023-01-07",35189.96]
["2023-01-06",35178.67]
["2023-01-05",35167.379999999997]
["2023-01-04",35156.089999999997]
["2023-01-03",35144.81]
["2023-01-02",35133.53]
["2023-01-01",35122.26]