{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Entradas","Llenado","Formatos"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":6,"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":"Entradas","index":0,"n_rows":6,"n_cols":5,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Valor del préstamo:"]
[null,null,"Plazo:"]
[null,null,"Tasa:"]
[]
["Cuota","Capital","Interés","Total","Saldo"]

{"sheet":"Llenado","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Valor del préstamo:",1000000]
[null,null,"Plazo:",12]
[null,null,"Tasa:",0.01]
[]
["Cuota","Capital","Interés","Total","Saldo"]
[1,{"$f":"PPMT($D$4,A7,$D$3,-$D$2)","v":78848.788678341691},{"$f":"IPMT($D$4,A7,$D$3,-$D$2)","v":10000.000000000002},{"$f":"B7+C7","v":88848.788678341691},{"$f":"$D$2-SUM($B$7:B7)","v":921151.21132165834}]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]

{"sheet":"Formatos","index":2,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Valor del préstamo:",2000000]
[null,null,"Plazo:",60]
[null,null,"Tasa:",0.01]
[]
["Cuota","Capital","Interés","Total","Saldo"]
[1,{"$f":"PPMT($D$4,A7,$D$3,-$D$2)","v":24488.895369803548},{"$f":"IPMT($D$4,A7,$D$3,-$D$2)","v":20000},{"$f":"B7+C7","v":44488.895369803548},{"$f":"$D$2-SUM($B$7:B7)","v":1975511.1046301965}]
[2,24733.784323501583,19755.111046301965,44488.895369803548,{"$f":"$D$2-SUM($B$7:B8)","v":1950777.3203066948}]
[3,24981.122166736597,19507.773203066943,44488.89536980354,{"$f":"$D$2-SUM($B$7:B9)","v":1925796.1981399583}]
[4,25230.933388403966,19257.961981399581,44488.895369803548,{"$f":"$D$2-SUM($B$7:B10)","v":1900565.2647515542}]
[5,25483.242722288003,19005.652647515537,44488.89536980354,{"$f":"$D$2-SUM($B$7:B11)","v":1875082.0220292662}]
[6,25738.075149510882,18750.820220292659,44488.89536980354,{"$f":"$D$2-SUM($B$7:B12)","v":1849343.9468797555}]
[7,25995.455901005997,18493.439468797555,44488.895369803548,{"$f":"$D$2-SUM($B$7:B13)","v":1823348.4909787495}]
[8,26255.410460016054,18233.48490978749,44488.895369803548,{"$f":"$D$2-SUM($B$7:B14)","v":1797093.0805187332}]
[9,26517.96456461621,17970.930805187334,44488.895369803548,{"$f":"$D$2-SUM($B$7:B15)","v":1770575.1159541172}]
[10,26783.144210262373,17705.751159541171,44488.895369803548,{"$f":"$D$2-SUM($B$7:B16)","v":1743791.9717438547}]
[11,27050.975652364996,17437.919717438548,44488.895369803548,{"$f":"$D$2-SUM($B$7:B17)","v":1716740.9960914897}]
[12,27321.485408888646,17167.409960914898,44488.895369803548,{"$f":"$D$2-SUM($B$7:B18)","v":1689419.510682601}]