{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["CRONOGRAMA","ARCHIVO DE TRABAJO","DO_OCULTO"],"not_rendered":{"images":1,"macros":1,"defined_names":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"CRONOGRAMA","index":0,"n_rows":22,"n_cols":16,"rows_kept":22,"merged":[[5,2,5,3],[5,5,5,9],[5,11,5,15]]}
[null,"Taller de Excel Financiero | Cronograma de pago • Cuota Fija"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[]
[null,null,"DATOS",null,null,"CRONOGRAMA DE PAGOS • CUOTA FIJA",{"$nulls":5},"RESUMEN DE CRONOGRAMA"]
[]
[null,null,{"$f":"lista01.01","v":"Año"},2020,null,{"$f":"lista01.02","v":"CUOTA"},"INTERES","AMORTIZACION","CUOTA","SALDO FINAL",null,{"$f":"lista01.03","v":"AÑO"},"INICIO","FINAL","INTERESES","AMORTIZACION"]
[null,null,"Deuda",{"v":350000,"d":"$350,000"},null,49,{"v":1454.1394448915248,"d":"$1,454.14"},{"v":7433.560154596654,"d":"$7,433.56"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":89509.06950483841,"d":"$89,509.07"},null,2020,1,12,{"v":59212.38559530903,"d":"$59,212.39"},{"v":47440.00959854913,"d":"$47,440.01"}]
[null,null,"Tasa",{"v":0.015,"d":"1.50%"},null,50,{"v":1342.636042572575,"d":"$1,342.64"},{"v":7545.063556915605,"d":"$7,545.06"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":81964.00594792276,"d":"$81,964.01"},null,2021,13,24,{"v":49932.25766352318,"d":"$49,932.26"},{"v":56720.13753033498,"d":"$56,720.14"}]
[null,null,"Periodos",60,null,51,{"v":1229.4600892188407,"d":"$1,229.46"},{"v":7658.239510269339,"d":"$7,658.24"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":74305.76643765351,"d":"$74,305.77"},null,2022,25,36,{"v":38836.76807479224,"d":"$38,836.77"},{"v":67815.62711906592,"d":"$67,815.63"}]
[null,null,"Cuota",{"v":8887.69959948818,"d":"$8,887.70"},null,52,{"v":1114.5864965648009,"d":"$1,114.59"},{"v":7773.113102923379,"d":"$7,773.11"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":66532.65333473007,"d":"$66,532.65"},null,2023,37,48,{"v":25570.799101243247,"d":"$25,570.80"},{"v":81081.59609261491,"d":"$81,081.60"}]
[{"$nulls":5},53,{"v":997.9898000209502,"d":"$997.99"},{"v":7889.70979946723,"d":"$7,889.71"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":58642.943535262835,"d":"$58,642.94"},null,2024,49,60,{"v":9709.765534423175,"d":"$9,709.77"},{"v":96942.62965943498,"d":"$96,942.63"}]
[{"$nulls":5},54,{"v":879.6441530289418,"d":"$879.64"},{"v":8008.055446459237,"d":"$8,008.06"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":50634.88808880362,"d":"$50,634.89"},null,"TOTALES","","",{"v":183261.97596929088,"d":"$183,261.98"},{"v":349999.9999999999,"d":"$350,000.00"}]
[{"$nulls":5},55,{"v":759.5233213320531,"d":"$759.52"},{"v":8128.1762781561265,"d":"$8,128.18"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":42506.71181064757,"d":"$42,506.71"}]
[{"$nulls":5},56,{"v":637.6006771597112,"d":"$637.60"},{"v":8250.098922328469,"d":"$8,250.10"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":34256.61288831907,"d":"$34,256.61"}]
[{"$nulls":5},57,{"v":513.8491933247842,"d":"$513.85"},{"v":8373.850406163396,"d":"$8,373.85"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":25882.76248215564,"d":"$25,882.76"}]
[{"$nulls":5},58,{"v":388.24143723233334,"d":"$388.24"},{"v":8499.458162255845,"d":"$8,499.46"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":17383.304319899762,"d":"$17,383.30"}]
[{"$nulls":5},59,{"v":260.7495647984957,"d":"$260.75"},{"v":8626.950034689682,"d":"$8,626.95"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":8756.354285210138,"d":"$8,756.35"}]
[{"$nulls":5},60,{"v":131.34531427815043,"d":"$131.35"},{"v":8756.354285210029,"d":"$8,756.35"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":0,"d":"$0.00"},null,"@ MOS Expert CPC Martín Cruz"]
[]
[null,null,"https://excelnoconvencional.com/excel-financiero-entrenamiento-para-contadores/"]

{"sheet":"ARCHIVO DE TRABAJO","index":1,"n_rows":14,"n_cols":16,"rows_kept":14,"merged":[[5,2,5,3],[5,5,5,9],[5,11,5,15]]}
[null,"Taller de Excel Financiero | Cronograma de pago • Cuota Fija"]
[null,"MOS Expert CPC Martín Cruz • +51 998401784 | Excel No Convencional"]
[]
[]
[]
[null,null,"DATOS",null,null,"CRONOGRAMA DE PAGOS • CUOTA FIJA",{"$nulls":5},"RESUMEN DE CRONOGRAMA"]
[]
[null,null,"Año",null,null,"CUOTA","INTERES","AMORTIZACION","CUOTA","SALDO FINAL",null,"AÑO","INICIO","FINAL","INTERESES","AMORTIZACION"]
[null,null,"Deuda"]
[null,null,"Tasa"]
[null,null,"Periodos"]
[null,null,"Cuota"]
[]
[{"$nulls":11},"TOTALES",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"SUM(O9:O13)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(P9:P13)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"DO_OCULTO","index":2,"n_rows":20,"n_cols":20,"rows_kept":20,"hidden":true}
{"$rows_empty":7}
[null,null,"Año",{"$f":"YEAR(TODAY())","v":2020},null,"CUOTA","INTERES","AMORTIZACION","CUOTA","SALDO FINAL",null,"AÑO","INICIO","FINAL","INTERESES","AMORTIZACION",null,null,"CUOTAS","Etiquetas de fila"]
[null,null,"Deuda",{"v":350000,"d":"$350,000"},null,{"$f":"ROWS(F$9:F9)+(DO_OCULTO!$T$9-12)","v":49},{"$f":"IPMT($D$10,F9,$D$11,-$D$9,,0)","v":{"v":1454.1394448915248,"d":"$1,454.14"}},{"$f":"PPMT($D$10,F9,$D$11,-$D$9,,0)","v":{"v":7433.560154596654,"d":"$7,433.56"}},{"$f":"PMT($D$10,$D$11,-$D$9,,0)","v":{"v":8887.69959948818,"d":"$8,887.70"}},{"$f":"$D$9+CUMPRINC($D$10,$D$11,$D$9,1,F9,0)","v":{"v":89509.06950483841,"d":"$89,509.07"}},null,{"$f":"$D$8+(ROWS(L$9:L9)-1)","v":2020},1,{"$f":"M9+11","v":12},{"$f":"-CUMIPMT($D$10,$D$11,$D$9,M9,N9,0)","v":{"v":59212.38559530903,"d":"$59,212.39"}},{"$f":"-CUMPRINC($D$10,$D$11,$D$9,M9,N9,0)","v":{"v":47440.00959854913,"d":"$47,440.01"}},null,null,12,60]
[null,null,"Tasa",{"v":0.015,"d":"1.50%"},null,{"$f":"ROWS(F$9:F10)+(DO_OCULTO!$T$9-12)","v":50},{"v":1342.636042572575,"d":"$1,342.64"},{"v":7545.063556915605,"d":"$7,545.06"},{"$f":"PMT($D$10,$D$11,-$D$9,,0)","v":{"v":8887.69959948818,"d":"$8,887.70"}},{"v":81964.00594792276,"d":"$81,964.01"},null,{"$f":"$D$8+(ROWS(L$9:L10)-1)","v":2021},{"$f":"N9+1","v":13},{"$f":"M10+11","v":24},{"$f":"-CUMIPMT($D$10,$D$11,$D$9,M10,N10,0)","v":{"v":49932.25766352318,"d":"$49,932.26"}},{"v":56720.13753033498,"d":"$56,720.14"},null,null,24]
[null,null,"Periodos",60,null,{"$f":"ROWS(F$9:F11)+(DO_OCULTO!$T$9-12)","v":51},{"v":1229.4600892188407,"d":"$1,229.46"},{"v":7658.239510269339,"d":"$7,658.24"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":74305.76643765351,"d":"$74,305.77"},null,{"$f":"$D$8+(ROWS(L$9:L11)-1)","v":2022},{"$f":"N10+1","v":25},{"$f":"M11+11","v":36},{"$f":"-CUMIPMT($D$10,$D$11,$D$9,M11,N11,0)","v":{"v":38836.76807479224,"d":"$38,836.77"}},{"v":67815.62711906592,"d":"$67,815.63"},null,null,36]
[null,null,"Cuota",{"$f":"PMT(D10,D11,-D9,,0)","v":{"v":8887.69959948818,"d":"$8,887.70"}},null,{"$f":"ROWS(F$9:F12)+(DO_OCULTO!$T$9-12)","v":52},{"v":1114.5864965648009,"d":"$1,114.59"},{"v":7773.113102923379,"d":"$7,773.11"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":66532.65333473007,"d":"$66,532.65"},null,{"$f":"$D$8+(ROWS(L$9:L12)-1)","v":2023},37,48,{"v":25570.799101243247,"d":"$25,570.80"},{"v":81081.59609261491,"d":"$81,081.60"},null,null,48]
[{"$nulls":5},{"$f":"ROWS(F$9:F13)+(DO_OCULTO!$T$9-12)","v":53},{"v":997.9898000209502,"d":"$997.99"},{"v":7889.70979946723,"d":"$7,889.71"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":58642.943535262835,"d":"$58,642.94"},null,{"$f":"$D$8+(ROWS(L$9:L13)-1)","v":2024},49,60,{"v":9709.765534423175,"d":"$9,709.77"},{"v":96942.62965943498,"d":"$96,942.63"},null,null,60]
[{"$nulls":5},{"$f":"ROWS(F$9:F14)+(DO_OCULTO!$T$9-12)","v":54},{"v":879.6441530289418,"d":"$879.64"},{"v":8008.055446459237,"d":"$8,008.06"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":50634.88808880362,"d":"$50,634.89"},null,"TOTALES",{"$f":"\"\"","v":""},{"$f":"\"\"","v":""},{"$f":"SUM(O9:O13)","v":{"v":183261.97596929088,"d":"$183,261.98"}},{"$f":"SUM(P9:P13)","v":{"v":349999.9999999999,"d":"$350,000.00"}}]
[{"$nulls":5},{"$f":"ROWS(F$9:F15)+(DO_OCULTO!$T$9-12)","v":55},{"v":759.5233213320531,"d":"$759.52"},{"v":8128.1762781561265,"d":"$8,128.18"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":42506.71181064757,"d":"$42,506.71"}]
[{"$nulls":5},{"$f":"ROWS(F$9:F16)+(DO_OCULTO!$T$9-12)","v":56},{"v":637.6006771597112,"d":"$637.60"},{"v":8250.098922328469,"d":"$8,250.10"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":34256.61288831907,"d":"$34,256.61"}]
[{"$nulls":5},{"$f":"ROWS(F$9:F17)+(DO_OCULTO!$T$9-12)","v":57},{"v":513.8491933247842,"d":"$513.85"},{"v":8373.850406163396,"d":"$8,373.85"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":25882.76248215564,"d":"$25,882.76"}]
[{"$nulls":5},{"$f":"ROWS(F$9:F18)+(DO_OCULTO!$T$9-12)","v":58},{"v":388.24143723233334,"d":"$388.24"},{"v":8499.458162255845,"d":"$8,499.46"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":17383.304319899762,"d":"$17,383.30"}]
[{"$nulls":5},{"$f":"ROWS(F$9:F19)+(DO_OCULTO!$T$9-12)","v":59},{"v":260.7495647984957,"d":"$260.75"},{"v":8626.950034689682,"d":"$8,626.95"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":8756.354285210138,"d":"$8,756.35"}]
[{"$nulls":5},{"$f":"ROWS(F$9:F20)+(DO_OCULTO!$T$9-12)","v":60},{"v":131.34531427815043,"d":"$131.35"},{"v":8756.354285210029,"d":"$8,756.35"},{"v":8887.69959948818,"d":"$8,887.70"},{"v":0,"d":"$0.00"}]