{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Vista Principal","Cronograma","Proceso Prima de Seguro","TarifarioBD","CostoCapBD"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Vista Principal","index":0,"n_rows":395,"n_cols":21,"rows_kept":395,"cut":false,"hidden":false,"merged":[[1,1,3,9],[6,1,6,2],[33,1,33,2]]}
[]
[null,"Simulador de Préstamos Personales - Scotiabank"]
[]
[]
[]
[]
[null,"Por favor ingrese los siguientes datos:"]
[]
[null,"Producto","Préstamos Personales (DXP)"]
[null,"Tipo de Seguro","Seguro de Vida","Seleccionar"]
[null,"Tarifa","TARIFA TITULAR","Seleccionar"]
[null,"Monto inicial",75000,"Digitar"]
[null,"Seguro Desempleo (en caso aplique, ingresar la tasa)¹",null,"Digitar en caso aplique"]
[null,"Monto adicional desempleo",{"$f":"+H17","v":0}]
[null,"Prima de Seguro de Desgravamen/Vida",{"$f":"IF(C10=\"EXONERADO\",0%,IF(C10=\"Sin Seguro\",0%,IF(C10=\"Seguro de vida\",'Proceso Prima de Seguro'!D13,IF(AND(C10=\"Sin Seguro (Solo LD Garantía Liquida)\",C9=\"Préstamos Personales (LD Garantía Liquida)\"),0%,'Proceso Prima de Seguro'!H16))))","v":4.2000000000000003E-2}]
[null,"Monto adicional del Seguro",{"$f":"+C15*C12","v":3150},null,null,null,"MAF SIN SEGURO","MONTO SEGURO DESEMNPLEO","MAF CON DESEMBPLEP"]
[null,"Monto Total a Financiar",{"$f":"+I17","v":78150},null,null,null,{"$f":"+C12+C16","v":78150},{"$f":"+G17*C13","v":0},{"$f":"+H17+G17","v":78150}]
[null,"Empleado","NO"]
[null,"Moneda","Soles","Seleccionar"]
[null,"Plazo (cuotas)",60,"Digitar"]
[null,"Fecha de Desembolso","2025-09-02"]
[null,"Fecha de 1er Pago","2025-11-10","Digitar"]
[null,"Cuota Julio (Digitar 2 en caso de cuota doble)",1,"Digitar 2 en caso de cuota doble"]
[null,"Cuota Diciembre (Digitar 2 en caso de cuota doble)",1,"Digitar 2 en caso de cuota doble"]
[null,"TEA fija",0.15,"Digitar"]
[null,"TEA TOTAL",{"$f":"+C25","v":0.15}]
[null,"Monto del Bien",0]
[null,"Seguro del Bien",0]
[null,"Envío de Estado de Cuenta (Digital: S/0 - Físico S/11)",0,"Digitar"]
[null,"Cuota a pagar",{"$f":"(C17+(C28*C27+C29)*P34)/O34","v":1856.3024399417536}]
[null,"2) Calcular TCEA presionando el botón "]
[null,"TCEA",0.17014719859672053]
[null,null,"Para volver a calcular,debes borrar la TCEA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C17-U34-C14-C16","v":2.9103830456733704E-11}]
[null,"Importante: \nLa tasa efectiva anual (TEA) debe registrarse de acuerdo al tarifario vigente.\n¹ De acuerdo al tarifario vigente de Seguros Optativos (Tarifario N°46 de Agencias y en Otras Tarifas en Medios Virtuales). \nLas cuotas son referenciales, sujetas a calificación y a la fecha de desembolso del crédito y no incluyen ITF.\nEl crédito está sujeto a evaluación crediticia. Tener en cuenta que toda la información de este simulador tiene carácter referencial y depende de la evaluación mencionada.   \nEndoso de seguro: El cliente puede endosar su póliza de seguro a favor del banco, siempre que cumpla con los requisitos establecidos por la entidad financiera.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O36:O395)","v":42.099820761132094},{"$f":"SUM(P36:P395)","v":42.099820761132094},null,null,null,null,{"$f":"SUM(U36:U395)","v":74999.999999999971}]
[null,"N° Cuota","Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA"]
[null,1,{"$f":"C22","v":"2025-11-10"},{"$f":"IF(B36<=$C$20,WEEKDAY(C36,2),\"\")","v":1},{"$f":"IF(D36=7,C36+1,C36)","v":"2025-11-10"},{"$f":"E36-C21","v":69},{"$f":"F36","v":69},{"$f":"C17","v":78150},{"$f":"IF(B36>C$20,\"\",M36-L36-K36-J36)","v":-265.44829561609458},{"$f":"IF(B36>C$20,\"\",((1+C$25)^(F36/360)-1)*H36)","v":2121.7507355578482},{"$f":"IF(B36>C$20,\"\",C$27*C$28)","v":0},{"$f":"IF(B36>C$20,\"\",C$29)","v":0},{"$f":"IF(B36>C$20,\"\",IF(B36=C$20,H36+J36+K36+L36,IF(AND(C$23=2,MONTH(C36)=7),2*C$30,IF(AND(C$24=2,MONTH(C36)=12),2*C$30,C$30))))","v":1856.3024399417536},{"$f":"IF(B36>C$20,\"\",H36-I36)","v":78415.448295616094},{"$f":"IFERROR(IF(AND(MONTH(C36)=7,C$23=2),2/(1+C$26)^(G36/360),IF(AND(MONTH(C36)=12,C$24=2),2/(1+C$26)^(G36/360),1/(1+C$26)^(G36/360))),\"\")","v":0.97356790257948145},{"$f":"IFERROR(1/(1+C$26)^(G36/360),\"\")","v":0.97356790257948145},null,{"$f":"IFERROR(I36+J36+K36+L36,\"\")","v":1856.3024399417536},{"$f":"G36","v":69},{"$f":"IFERROR((1+C$32)^(S36/360),\"\")","v":1.0305745862223492},{"$f":"IFERROR(ROUND(R36/T36,2),\"\")","v":1801.23}]
[null,2,{"$f":"IF(B37>$C$20,\"\",EDATE(C36,1))","v":"2025-12-10"},3,{"$f":"IF(D37=7,C37+1,C37)","v":"2025-12-10"},{"$f":"IF(B37>C$20,\"\",E37-E36)","v":30},{"$f":"IFERROR(F37+G36,\"\")","v":99},{"$f":"IF(B37>C$20,\"\",N36)","v":78415.448295616094},{"$f":"IF(B37>C$20,\"\",M37-L37-K37-J37)","v":937.67197792555282},918.6304620162008,0,0,{"$f":"IF(B37>C$20,\"\",IF(B37=C$20,H37+J37+K37+L37,IF(AND(C$23=2,MONTH(C37)=7),2*C$30,IF(AND(C$24=2,MONTH(C37)=12),2*C$30,C$30))))","v":1856.3024399417536},77477.776317690543,{"$f":"IFERROR(IF(AND(MONTH(C37)=7,C$23=2),2/(1+C$26)^(G37/360),IF(AND(MONTH(C37)=12,C$24=2),2/(1+C$26)^(G37/360),1/(1+C$26)^(G37/360))),\"\")","v":0.96229470011521667},0.96229470011521667,null,{"$f":"IFERROR(I37+J37+K37+L37,\"\")","v":1856.3024399417536},99,1.0441577992099893,1777.8]
[null,3,"2026-01-10",6,"2026-01-10",31,130,77477.776317690543,918.21943367038773,938.08300627136589,0,0,1856.3024399417536,76559.556884020159,0.95078284125164558,0.95078284125164558,null,1856.3024399417536,130,1.0583818942866892,1753.91]
[null,4,"2026-02-10",{"$f":"IF(B39<=$C$20,WEEKDAY(C39,2),\"\")","v":2},{"$f":"IF(D39=7,C39+1,C39)","v":"2026-02-10"},31,{"$f":"IFERROR(F39+G38,\"\")","v":161},76559.556884020159,929.33702232216262,926.96541761959099,0,0,1856.3024399417536,75630.219861698002,0.93940869788674564,0.93940869788674564,null,1856.3024399417536,161,1.0727997578540369,1730.33]
[null,5,"2026-03-10",2,"2026-03-10",28,189,75630.219861698002,1029.6890593046719,826.6133806370816,0,0,1856.3024399417536,74600.530802393332,0.92925227671901578,0.92925227671901578,null,1856.3024399417536,189,1.0859910873552399,1709.32]
[null,6,"2026-04-10",5,"2026-04-10",31,220,74600.530802393332,953.05645727962792,903.2459826621257,0,0,1856.3024399417536,73647.474345113704,0.9181357018724946,0.9181357018724946,null,1856.3024399417536,220,1.1007850586215342,1686.34]
[null,7,"2026-05-10",7,"2026-05-11",31,251,73647.474345113704,964.59584456050777,891.70659538124585,0,0,1856.3024399417536,72682.878500553197,0.90715211377178462,0.90715211377178462,null,1856.3024399417536,251,1.1157805615471361,1663.68]
[null,8,"2026-06-10",3,"2026-06-10",30,281,72682.878500553197,1004.8285568119755,851.47388312977807,0,0,1856.3024399417536,71678.049943741222,0.89664795744397241,0.89664795744397241,null,1856.3024399417536,281,1.130486809127448,1642.04]
[null,9,"2026-07-10",5,"2026-07-10",30,311,71678.049943741222,1016.600039873724,839.70240006802965,0,0,1856.3024399417536,70661.449903867499,0.88626543154449078,0.88626543154449078,null,1856.3024399417536,311,1.145386888474818,1620.68]
[null,10,"2026-08-10",1,"2026-08-10",31,342,70661.449903867499,1000.7499382603347,855.5525016814189,0,0,1856.3024399417536,69660.699965607157,0.87566310508214984,0.87566310508214984,null,1856.3024399417536,342,1.1609899821964738,1598.9]
[null,11,"2026-09-10",4,"2026-09-10",31,373,69660.699965607157,1012.8667871843376,843.43565275741605,0,0,1856.3024399417536,68647.833178422821,0.86518761345101525,0.86518761345101525,null,1856.3024399417536,373,1.1768056298910592,1577.41]
[null,12,"2026-10-10",6,"2026-10-10",30,403,68647.833178422821,1052.0987775285757,804.20366241317777,0,0,1856.3024399417536,67595.734400894245,0.85516937526735537,0.85516937526735537,null,1856.3024399417536,403,1.1923162020801694,1556.89]
[null,13,"2026-11-10",2,"2026-11-10",31,434,67595.734400894245,1037.8689129145573,818.43352702719631,0,0,1856.3024399417536,66557.865487979681,0.8449390485791306,0.8449390485791306,null,1856.3024399417536,434,1.2085585928689082,1535.96]
[null,14,"2026-12-10",4,"2026-12-10",30,464,66557.865487979681,1076.582575387295,779.71986455445847,0,0,1856.3024399417536,65481.282912592389,0.83515527392986488,0.83515527392986488,null,1856.3024399417536,464,1.2244876765028794,1515.98]
[null,15,"2027-01-10",7,"2027-01-11",32,496,65481.282912592389,1037.7357658419726,818.56667409978104,0,0,1856.3024399417536,64443.547146750418,0.82484408500259954,0.82484408500259954,null,1856.3024399417536,496,1.2417101771045953,1494.96]
[null,16,"2027-02-10",3,"2027-02-10",30,526,64443.547146750418,1101.351639096918,754.9508008448355,0,0,1856.3024399417536,63342.195507653501,0.81529299529735266,0.81529299529735266,null,1856.3024399417536,526,1.2580762063372366,1475.51]
[null,17,"2027-03-10",3,"2027-03-10",28,554,63342.195507653501,1163.9931162176631,692.30932372409052,0,0,1856.3024399417536,62178.202391435836,0.80647845158068576,0.80647845158068576,null,1856.3024399417536,554,1.2735457267709611,1457.59]
[null,18,"2027-04-10",6,"2027-04-10",31,585,62178.202391435836,1103.4631381949193,752.83930174683428,0,0,1856.3024399417536,61074.739253240914,0.79683061073733852,0.79683061073733852,null,1856.3024399417536,585,1.2908946710740359,1438]
[null,19,"2027-05-10",1,"2027-05-10",30,615,61074.739253240914,1140.8169436883281,715.48549625342537,0,0,1856.3024399417536,59933.922309552589,0.78760389652380947,0.78760389652380947,null,1856.3024399417536,615,1.3079089633884642,1419.29]
[null,20,"2027-06-10",4,"2027-06-10",31,646,59933.922309552589,1130.6363626495722,725.66607729218151,0,0,1856.3024399417536,58803.285946903015,0.77818185055795808,0.77818185055795808,null,1856.3024399417536,646,1.3257260227074497,1400.22]
[null,21,"2027-07-10",6,"2027-07-10",30,676,58803.285946903015,1167.4268304594029,688.87560948235057,0,0,1856.3024399417536,57635.859116443615,0.76917107531350615,0.76917107531350615,null,1856.3024399417536,676,1.3431994003459384,1382]
[null,22,"2027-08-10",2,"2027-08-10",31,707,57635.859116443615,1158.4607805827054,697.84165935904821,0,0,1856.3024399417536,56477.398335860911,0.75996953979648629,0.75996953979648629,null,1856.3024399417536,707,1.3614972055167109,1363.43]
[null,23,"2027-09-10",5,"2027-09-10",31,738,56477.398335860911,1172.4871559298817,683.81528401187188,0,0,1856.3024399417536,55304.911179931027,0.75087808155432545,0.75087808155432545,null,1856.3024399417536,738,1.3800442735102492,1345.1]
[null,24,"2027-10-10",7,"2027-10-11",31,769,55304.911179931027,1186.6833593874935,669.61908055426011,0,0,1856.3024399417536,54118.227820543536,0.74189538374089326,0.74189538374089326,null,1856.3024399417536,769,1.3988439999225952,1327.03]
[null,25,"2027-11-10",3,"2027-11-10",30,799,54118.227820543536,1222.3118971743884,633.99054276736535,0,0,1856.3024399417536,52895.915923369146,0.73330477917591597,0.73330477917591597,null,1856.3024399417536,799,1.4172810895243093,1309.76]
[null,26,"2027-12-10",5,"2027-12-10",30,829,52895.915923369146,1236.6311794999347,619.67126044181907,0,0,1856.3024399417536,51659.284743869212,0.72481364751292621,0.72481364751292621,null,1856.3024399417536,829,1.4359611842595486,1292.72]
[null,27,"2028-01-10",1,"2028-01-10",31,860,51659.284743869212,1230.8237615701819,625.47867837157162,0,0,1856.3024399417536,50428.460982299031,0.71614275655659043,0.71614275655659043,null,1856.3024399417536,860,1.4555226417584173,1275.3499999999999]
[null,28,"2028-02-10",4,"2028-02-10",31,891,50428.460982299031,1245.7262911640823,610.57614877767116,0,0,1856.3024399417536,49182.734691134952,0.70757559481428733,0.70757559481428733,null,1856.3024399417536,891,1.475350576251006,1258.21]
[null,29,"2028-03-10",5,"2028-03-10",29,920,49182.734691134952,1299.4448214498857,556.85761849186804,0,0,1856.3024399417536,47883.289869685068,0.6996539605118085,0.6996539605118085,null,1856.3024399417536,920,1.4941437476170731,1242.3900000000001]
[null,30,"2028-04-10",1,"2028-04-10",31,951,47883.289869685068,1276.542634666326,579.75980527542765,0,0,1856.3024399417536,46606.747235018745,0.69128405299201645,0.69128405299201645,null,1856.3024399417536,951,1.5144978001754528,1225.69]
[null,31,"2028-05-10",3,"2028-05-10",30,981,46606.747235018745,1310.3082681789028,545.99417176285078,0,0,1856.3024399417536,45296.438966839843,0.68327949052744774,0.68327949052744774,null,1856.3024399417536,981,1.5344592337913379,1209.74]
[null,32,"2028-06-10",6,"2028-06-10",31,1012,45296.438966839843,1307.8636274341934,548.4388125075601,0,0,1856.3024399417536,43988.575339405652,0.67510546955613526,0.67510546955613526,null,1856.3024399417536,1012,1.5553624862013489,1193.49]
[null,33,"2028-07-10",1,"2028-07-10",30,1042,43988.575339405652,1340.9799344179053,515.32250552384835,0,0,1856.3024399417536,42647.595404987747,0.66728824322515767,0.66728824322515767,null,1856.3024399417536,1042,1.5758625258932846,1177.96]
[null,34,"2028-08-10",4,"2028-08-10",31,1073,42647.595404987747,1339.9352129873969,516.36722695435674,0,0,1856.3024399417536,41307.660192000352,0.65930552433830469,0.65930552433830469,null,1856.3024399417536,1073,1.5973297968489524,1162.1300000000001]
[null,35,"2028-09-10",7,"2028-09-11",32,1105,41307.660192000352,1339.9247436870087,516.37769625474493,0,0,1856.3024399417536,39967.735448313346,0.65116545262415182,0.65116545262415182,null,1856.3024399417536,1105,1.6197963466683336,1146.01]
[null,36,"2028-10-10",2,"2028-10-10",29,1134,39967.735448313346,1403.7790469659576,452.52339297579613,0,0,1856.3024399417536,38563.956401347386,0.64387535581484845,0.64387535581484845,null,1856.3024399417536,1134,1.6404294835044753,1131.5999999999999]
[null,37,"2028-11-10",5,"2028-11-10",31,1165,38563.956401347386,1389.378970089487,466.92346985226663,0,0,1856.3024399417536,37174.577431257901,0.63617272353288257,0.63617272353288257,null,1856.3024399417536,1165,1.6627763212694604,1116.3900000000001]
[null,38,"2028-12-10",7,"2028-12-11",31,1196,37174.577431257901,1406.2012494972939,450.10119044445969,0,0,1856.3024399417536,35768.376181760606,0.62856223725951199,0.62856223725951199,null,1856.3024399417536,1196,1.6854275800187768,1101.3800000000001]
[null,39,"2029-01-10",3,"2029-01-10",30,1226,35768.376181760606,1437.2788846143658,419.02355532738795,0,0,1856.3024399417536,34331.09729714624,0.62128394743171111,0.62128394743171111,null,1856.3024399417536,1226,1.7076419079293417,1087.06]
[null,40,"2029-02-10",6,"2029-02-10",31,1257,34331.09729714624,1440.6294496761795,415.67299026557407,0,0,1856.3024399417536,32890.467847470063,0.6138515744630354,0.6138515744630354,null,1856.3024399417536,1257,1.7309043505158184,1072.45]
[null,41,"2029-03-10",6,"2029-03-10",28,1285,32890.467847470063,1496.8204647756158,359.48197516613783,0,0,1856.3024399417536,31393.647382694446,0.60721491553200191,0.60721491553200191,null,1856.3024399417536,1285,1.7521878467652896,1059.42]
[null,42,"2029-04-10",2,"2029-04-10",31,1316,31393.647382694446,1476.1954142338295,380.10702570792421,0,0,1856.3024399417536,29917.451968460617,0.59995084933001341,0.59995084933001341,null,1856.3024399417536,1316,1.7760571187694678,1045.18]
[null,43,"2029-05-10",4,"2029-05-10",30,1346,29917.451968460617,1505.8219756775336,350.48046426422007,0,0,1856.3024399417536,28411.629992783084,0.59300385839575476,0.59300385839575476,null,1856.3024399417536,1346,1.7994659651013869,1031.5899999999999]
[null,44,"2029-06-10",7,"2029-06-11",32,1378,28411.629992783084,1501.1350938775299,355.16734606422364,0,0,1856.3024399417536,26910.494898905556,0.58568237578121818,0.58568237578121818,null,1856.3024399417536,1378,1.8247755735698339,1017.28]
[null,45,"2029-07-10",2,"2029-07-10",29,1407,26910.494898905556,1551.615964170345,304.68647577140865,0,0,1856.3024399417536,25358.87893473521,0.57912539214251102,0.57912539214251102,null,1856.3024399417536,1407,1.8480197574341559,1004.48]
[null,46,"2029-08-10",5,"2029-08-10",31,1438,25358.87893473521,1549.262995634208,307.03944430754558,0,0,1856.3024399417536,23809.615939101001,0.57219735878863665,0.57219735878863665,null,1856.3024399417536,1438,1.8731945047312137,990.98]
[null,47,"2029-09-10",1,"2029-09-10",31,1469,23809.615939101001,1568.0211138653024,288.28132607645119,0,0,1856.3024399417536,22241.594825235697,0.56535220497484728,0.56535220497484728,null,1856.3024399417536,1469,1.8987121963603983,977.66]
[null,48,"2029-10-10",3,"2029-10-10",30,1499,22241.594825235697,1595.7440043990766,260.55843554267705,0,0,1856.3024399417536,20645.850820836622,0.55880584097351382,0.55880584097351382,null,1856.3024399417536,1499,1.923737665171861,964.95]
[null,49,"2029-11-10",6,"2029-11-10",31,1530,20645.850820836622,1606.3272505968012,249.97518934495244,0,0,1856.3024399417536,19039.52357023982,0.55212088887655653,0.55212088887655653,null,1856.3024399417536,1530,1.9499438836885798,951.98]
[null,50,"2029-12-10",1,"2029-12-10",30,1560,19039.52357023982,1633.256003122804,223.0464368189497,0,0,1856.3024399417536,17406.267567117015,0.54572773381406503,0.54572773381406503,null,1856.3024399417536,1560,1.975644598066931,939.59]
[null,51,"2030-01-10",4,"2030-01-10",31,1591,17406.267567117015,1645.5513757866431,210.75106415511053,0,0,1856.3024399417536,15760.716191330372,0.53919923412592186,0.53919923412592186,null,1856.3024399417536,1591,2.0025579215338767,926.97]
[null,52,"2030-02-10",7,"2030-02-11",32,1623,15760.716191330372,1659.2812995436796,197.02114039807404,0,0,1856.3024399417536,14101.434891786692,0.53254204671890548,0.53254204671890548,null,1856.3024399417536,1623,2.0307240318757049,914.11]
[null,53,"2030-03-10",7,"2030-03-11",28,1651,14101.434891786692,1702.1784034250127,154.12403651674106,0,0,1856.3024399417536,12399.25648836168,0.52678446609593566,0.52678446609593566,null,1856.3024399417536,1651,2.0556941622605853,903.01]
[null,54,"2030-04-10",3,"2030-04-10",30,1681,12399.25648836168,1711.0461803126436,145.25625962911005,0,0,1856.3024399417536,10688.210308049036,0.52068468823185965,0.52068468823185965,null,1856.3024399417536,1681,2.0827886899315886,891.26]
[null,55,"2030-05-10",5,"2030-05-10",30,1711,10688.210308049036,1731.0909441610386,125.21149578071496,0,0,1856.3024399417536,8957.1193638879977,0.51465554132291946,0.51465554132291946,null,1856.3024399417536,1711,2.1102403297855186,879.66]
[null,56,"2030-06-10",1,"2030-06-10",31,1742,8957.1193638879977,1747.8517091676315,108.45073077412219,0,0,1856.3024399417536,7209.2676547203664,0.50849875592822202,0.50849875592822202,null,1856.3024399417536,1742,2.1389871907564042,867.84]
[null,57,"2030-07-10",3,"2030-07-10",30,1772,7209.2676547203664,1771.8464683137183,84.455971628035314,0,0,1856.3024399417536,5437.4211864066483,0.50261071318028672,0.50261071318028672,null,1856.3024399417536,1772,2.1671795399354958,856.55]
[null,58,"2030-08-10",6,"2030-08-10",31,1803,5437.4211864066483,1790.4674011043869,65.835038837366682,0,0,1856.3024399417536,3646.9537853022612,0.49659801915551721,0.49659801915551721,null,1856.3024399417536,1803,2.1967020583207866,845.04]
[null,59,"2030-09-10",2,"2030-09-10",31,1834,3646.9537853022612,1812.1459665212853,44.156473420468195,0,0,1856.3024399417536,1834.8078187809758,0.49065725453552839,0.49065725453552839,null,1856.3024399417536,1834,2.2266267487807707,833.68]
[null,60,"2030-10-10",4,"2030-10-10",30,1864,1834.8078187809758,1834.8078187809758,21.494621160916527,0,0,1856.3024399418923,0,0.48497580329182555,0.48497580329182555,null,1856.3024399418923,1864,2.2559742077391078,822.84]
[null,61,"","","","","","","","","","","","","","",null,"","","",""]
[null,62,"","","","","","","","","","","","","","",null,"","","",""]
[null,63,"","","","","","","","","","","","","","",null,"","","",""]
[null,64,"","","","","","","","","","","","","","",null,"","","",""]
[null,65,"",{"$f":"IF(B100<=$C$20,WEEKDAY(C100,2),\"\")","v":""},"","","","","",{"$f":"IF(B100>C$20,\"\",((1+C$25)^(F100/360)-1)*H100)","v":""},{"$f":"IF(B100>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B100>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B100>C$20,\"\",H100-I100)","v":""},"",{"$f":"IFERROR(1/(1+C$26)^(G100/360),\"\")","v":""},null,"",{"$f":"G100","v":""},{"$f":"IFERROR((1+C$32)^(S100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R100/T100,2),\"\")","v":""}]
[null,66,{"$f":"IF(B101>$C$20,\"\",EDATE(C100,1))","v":""},"",{"$f":"IF(D101=7,C101+1,C101)","v":""},{"$f":"IF(B101>C$20,\"\",E101-E100)","v":""},{"$f":"IFERROR(F101+G100,\"\")","v":""},{"$f":"IF(B101>C$20,\"\",N100)","v":""},{"$f":"IF(B101>C$20,\"\",M101-L101-K101-J101)","v":""},"","","",{"$f":"IF(B101>C$20,\"\",IF(B101=C$20,H101+J101+K101+L101,IF(AND(C$23=2,MONTH(C101)=7),2*C$30,IF(AND(C$24=2,MONTH(C101)=12),2*C$30,C$30))))","v":""},"",{"$f":"IFERROR(IF(AND(MONTH(C101)=7,C$23=2),2/(1+C$26)^(G101/360),IF(AND(MONTH(C101)=12,C$24=2),2/(1+C$26)^(G101/360),1/(1+C$26)^(G101/360))),\"\")","v":""},"",null,{"$f":"IFERROR(I101+J101+K101+L101,\"\")","v":""},"","",""]
[null,67,"","","","","","","","","","","","","","",null,"","","",""]
[null,68,"","","","","","","","","","","","","","",null,"","","",""]
[null,69,"","","","","","","","","","","","","","",null,"","","",""]
[null,70,"","","","","","","","","","","","","","",null,"","","",""]
[null,71,"","","","","","","","","","","","","","",null,"","","",""]
[null,72,"","","","","","","","","","","","","","",null,"","","",""]
[null,73,"","","","","","","","","","","","","","",null,"","","",""]
[null,74,"","","","","","","","","","","","","","",null,"","","",""]
[null,75,"","","","","","","","","","","","","","",null,"","","",""]
[null,76,"","","","","","","","","","","","","","",null,"","","",""]
[null,77,"","","","","","","","","","","","","","",null,"","","",""]
[null,78,"","","","","","","","","","","","","","",null,"","","",""]
[null,79,"","","","","","","","","","","","","","",null,"","","",""]
[null,80,"","","","","","","","","","","","","","",null,"","","",""]
[null,81,"","","","","","","","","","","","","","",null,"","","",""]
[null,82,"","","","","","","","","","","","","","",null,"","","",""]
[null,83,"","","","","","","","","","","","","","",null,"","","",""]
[null,84,"","","","","","","","","","","","","","",null,"","","",""]
[null,85,"","","","","","","","","","","","","","",null,"","","",""]
[null,86,"","","","","","","","","","","","","","",null,"","","",""]
[null,87,"","","","","","","","","","","","","","",null,"","","",""]
[null,88,"","","","","","","","","","","","","","",null,"","","",""]
[null,89,"","","","","","","","","","","","","","",null,"","","",""]
[null,90,"","","","","","","","","","","","","","",null,"","","",""]
[null,91,"","","","","","","","","","","","","","",null,"","","",""]
[null,92,"","","","","","","","","","","","","","",null,"","","",""]
[null,93,"","","","","","","","","","","","","","",null,"","","",""]
[null,94,"","","","","","","","","","","","","","",null,"","","",""]
[null,95,"","","","","","","","","","","","","","",null,"","","",""]
[null,96,"","","","","","","","","","","","","","",null,"","","",""]
[null,97,"","","","","","","","","","","","","","",null,"","","",""]
[null,98,"","","","","","","","","","","","","","",null,"","","",""]
[null,99,"","","","","","","","","","","","","","",null,"","","",""]
[null,100,"","","","","","","","","","","","","","",null,"","","",""]
[null,101,"","","","","","","","","","","","","","",null,"","","",""]
[null,102,"","","","","","","","","","","","","","",null,"","","",""]
[null,103,"","","","","","","","","","","","","","",null,"","","",""]
[null,104,"","","","","","","","","","","","","","",null,"","","",""]
[null,105,"","","","","","","","","","","","","","",null,"","","",""]
[null,106,"","","","","","","","","","","","","","",null,"","","",""]
[null,107,"","","","","","","","","","","","","","",null,"","","",""]
[null,108,"","","","","","","","","","","","","","",null,"","","",""]
[null,109,"","","","","","","","","","","","","","",null,"","","",""]
[null,110,"","","","","","","","","","","","","","",null,"","","",""]
[null,111,"","","","","","","","","","","","","","",null,"","","",""]
[null,112,"","","","","","","","","","","","","","",null,"","","",""]
[null,113,"","","","","","","","","","","","","","",null,"","","",""]
[null,114,"","","","","","","","","","","","","","",null,"","","",""]
[null,115,"","","","","","","","","","","","","","",null,"","","",""]
[null,116,"","","","","","","","","","","","","","",null,"","","",""]
[null,117,"","","","","","","","","","","","","","",null,"","","",""]
[null,118,"","","","","","","","","","","","","","",null,"","","",""]
[null,119,"","","","","","","","","","","","","","",null,"","","",""]
[null,120,"","","","","","","","","","","","","","",null,"","","",""]
[null,121,"","","","","","","","","","","","","","",null,"","","",""]
[null,122,"","","","","","","","","","","","","","",null,"","","",""]
[null,123,"","","","","","","","","","","","","","",null,"","","",""]
[null,124,"","","","","","","","","","","","","","",null,"","","",""]
[null,125,"","","","","","","","","","","","","","",null,"","","",""]
[null,126,"","","","","","","","","","","","","","",null,"","","",""]
[null,127,"","","","","","","","","","","","","","",null,"","","",""]
[null,128,"","","","","","","","","","","","","","",null,"","","",""]
[null,129,"",{"$f":"IF(B164<=$C$20,WEEKDAY(C164,2),\"\")","v":""},"","","","","",{"$f":"IF(B164>C$20,\"\",((1+C$25)^(F164/360)-1)*H164)","v":""},{"$f":"IF(B164>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B164>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B164>C$20,\"\",H164-I164)","v":""},"",{"$f":"IFERROR(1/(1+C$26)^(G164/360),\"\")","v":""},null,"",{"$f":"G164","v":""},{"$f":"IFERROR((1+C$32)^(S164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R164/T164,2),\"\")","v":""}]
[null,130,{"$f":"IF(B165>$C$20,\"\",EDATE(C164,1))","v":""},"",{"$f":"IF(D165=7,C165+1,C165)","v":""},{"$f":"IF(B165>C$20,\"\",E165-E164)","v":""},{"$f":"IFERROR(F165+G164,\"\")","v":""},{"$f":"IF(B165>C$20,\"\",N164)","v":""},{"$f":"IF(B165>C$20,\"\",M165-L165-K165-J165)","v":""},"","","",{"$f":"IF(B165>C$20,\"\",IF(B165=C$20,H165+J165+K165+L165,IF(AND(C$23=2,MONTH(C165)=7),2*C$30,IF(AND(C$24=2,MONTH(C165)=12),2*C$30,C$30))))","v":""},"",{"$f":"IFERROR(IF(AND(MONTH(C165)=7,C$23=2),2/(1+C$26)^(G165/360),IF(AND(MONTH(C165)=12,C$24=2),2/(1+C$26)^(G165/360),1/(1+C$26)^(G165/360))),\"\")","v":""},"",null,{"$f":"IFERROR(I165+J165+K165+L165,\"\")","v":""},"","",""]
[null,131,"","","","","","","","","","","","","","",null,"","","",""]
[null,132,"","","","","","","","","","","","","","",null,"","","",""]
[null,133,"","","","","","","","","","","","","","",null,"","","",""]
[null,134,"","","","","","","","","","","","","","",null,"","","",""]
[null,135,"","","","","","","","","","","","","","",null,"","","",""]
[null,136,"","","","","","","","","","","","","","",null,"","","",""]
[null,137,"","","","","","","","","","","","","","",null,"","","",""]
[null,138,"","","","","","","","","","","","","","",null,"","","",""]
[null,139,"","","","","","","","","","","","","","",null,"","","",""]
[null,140,"","","","","","","","","","","","","","",null,"","","",""]
[null,141,"","","","","","","","","","","","","","",null,"","","",""]
[null,142,"","","","","","","","","","","","","","",null,"","","",""]
[null,143,"","","","","","","","","","","","","","",null,"","","",""]
[null,144,"","","","","","","","","","","","","","",null,"","","",""]
[null,145,"","","","","","","","","","","","","","",null,"","","",""]
[null,146,"","","","","","","","","","","","","","",null,"","","",""]
[null,147,"","","","","","","","","","","","","","",null,"","","",""]
[null,148,"","","","","","","","","","","","","","",null,"","","",""]
[null,149,"","","","","","","","","","","","","","",null,"","","",""]
[null,150,"","","","","","","","","","","","","","",null,"","","",""]
[null,151,"","","","","","","","","","","","","","",null,"","","",""]
[null,152,"","","","","","","","","","","","","","",null,"","","",""]
[null,153,"","","","","","","","","","","","","","",null,"","","",""]
[null,154,"","","","","","","","","","","","","","",null,"","","",""]
[null,155,"","","","","","","","","","","","","","",null,"","","",""]
[null,156,"","","","","","","","","","","","","","",null,"","","",""]
[null,157,"","","","","","","","","","","","","","",null,"","","",""]
[null,158,"","","","","","","","","","","","","","",null,"","","",""]
[null,159,"","","","","","","","","","","","","","",null,"","","",""]
[null,160,"","","","","","","","","","","","","","",null,"","","",""]
[null,161,"","","","","","","","","","","","","","",null,"","","",""]
[null,162,"","","","","","","","","","","","","","",null,"","","",""]
[null,163,"","","","","","","","","","","","","","",null,"","","",""]
[null,164,"","","","","","","","","","","","","","",null,"","","",""]
[null,165,"","","","","","","","","","","","","","",null,"","","",""]
[null,166,"","","","","","","","","","","","","","",null,"","","",""]
[null,167,"","","","","","","","","","","","","","",null,"","","",""]
[null,168,"","","","","","","","","","","","","","",null,"","","",""]
[null,169,"","","","","","","","","","","","","","",null,"","","",""]
[null,170,"","","","","","","","","","","","","","",null,"","","",""]
[null,171,"","","","","","","","","","","","","","",null,"","","",""]
[null,172,"","","","","","","","","","","","","","",null,"","","",""]
[null,173,"","","","","","","","","","","","","","",null,"","","",""]
[null,174,"","","","","","","","","","","","","","",null,"","","",""]
[null,175,"","","","","","","","","","","","","","",null,"","","",""]
[null,176,"","","","","","","","","","","","","","",null,"","","",""]
[null,177,"","","","","","","","","","","","","","",null,"","","",""]
[null,178,"","","","","","","","","","","","","","",null,"","","",""]
[null,179,"","","","","","","","","","","","","","",null,"","","",""]
[null,180,"","","","","","","","","","","","","","",null,"","","",""]
[null,181,"","","","","","","","","","","","","","",null,"","","",""]
[null,182,"","","","","","","","","","","","","","",null,"","","",""]
[null,183,"","","","","","","","","","","","","","",null,"","","",""]
[null,184,"","","","","","","","","","","","","","",null,"","","",""]
[null,185,"","","","","","","","","","","","","","",null,"","","",""]
[null,186,"","","","","","","","","","","","","","",null,"","","",""]
[null,187,"","","","","","","","","","","","","","",null,"","","",""]
[null,188,"","","","","","","","","","","","","","",null,"","","",""]
[null,189,"","","","","","","","","","","","","","",null,"","","",""]
[null,190,"","","","","","","","","","","","","","",null,"","","",""]
[null,191,"","","","","","","","","","","","","","",null,"","","",""]
[null,192,"","","","","","","","","","","","","","",null,"","","",""]
[null,193,"",{"$f":"IF(B228<=$C$20,WEEKDAY(C228,2),\"\")","v":""},"","","","","",{"$f":"IF(B228>C$20,\"\",((1+C$25)^(F228/360)-1)*H228)","v":""},{"$f":"IF(B228>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B228>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B228>C$20,\"\",H228-I228)","v":""},"",{"$f":"IFERROR(1/(1+C$26)^(G228/360),\"\")","v":""},null,"",{"$f":"G228","v":""},{"$f":"IFERROR((1+C$32)^(S228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R228/T228,2),\"\")","v":""}]
[null,194,{"$f":"IF(B229>$C$20,\"\",EDATE(C228,1))","v":""},"",{"$f":"IF(D229=7,C229+1,C229)","v":""},{"$f":"IF(B229>C$20,\"\",E229-E228)","v":""},{"$f":"IFERROR(F229+G228,\"\")","v":""},{"$f":"IF(B229>C$20,\"\",N228)","v":""},{"$f":"IF(B229>C$20,\"\",M229-L229-K229-J229)","v":""},"","","",{"$f":"IF(B229>C$20,\"\",IF(B229=C$20,H229+J229+K229+L229,IF(AND(C$23=2,MONTH(C229)=7),2*C$30,IF(AND(C$24=2,MONTH(C229)=12),2*C$30,C$30))))","v":""},"",{"$f":"IFERROR(IF(AND(MONTH(C229)=7,C$23=2),2/(1+C$26)^(G229/360),IF(AND(MONTH(C229)=12,C$24=2),2/(1+C$26)^(G229/360),1/(1+C$26)^(G229/360))),\"\")","v":""},"",null,{"$f":"IFERROR(I229+J229+K229+L229,\"\")","v":""},"","",""]
[null,195,"","","","","","","","","","","","","","",null,"","","",""]
[null,196,"","","","","","","","","","","","","","",null,"","","",""]
[null,197,"","","","","","","","","","","","","","",null,"","","",""]
[null,198,"","","","","","","","","","","","","","",null,"","","",""]
[null,199,"","","","","","","","","","","","","","",null,"","","",""]
[null,200,"","","","","","","","","","","","","","",null,"","","",""]
[null,201,"","","","","","","","","","","","","","",null,"","","",""]
[null,202,"","","","","","","","","","","","","","",null,"","","",""]
[null,203,"","","","","","","","","","","","","","",null,"","","",""]
[null,204,"","","","","","","","","","","","","","",null,"","","",""]
[null,205,"","","","","","","","","","","","","","",null,"","","",""]
[null,206,"","","","","","","","","","","","","","",null,"","","",""]
[null,207,"","","","","","","","","","","","","","",null,"","","",""]
[null,208,"","","","","","","","","","","","","","",null,"","","",""]
[null,209,"","","","","","","","","","","","","","",null,"","","",""]
[null,210,"","","","","","","","","","","","","","",null,"","","",""]
[null,211,"","","","","","","","","","","","","","",null,"","","",""]
[null,212,"","","","","","","","","","","","","","",null,"","","",""]
[null,213,"","","","","","","","","","","","","","",null,"","","",""]
[null,214,"","","","","","","","","","","","","","",null,"","","",""]
[null,215,"","","","","","","","","","","","","","",null,"","","",""]
[null,216,"","","","","","","","","","","","","","",null,"","","",""]
[null,217,"","","","","","","","","","","","","","",null,"","","",""]
[null,218,"","","","","","","","","","","","","","",null,"","","",""]
[null,219,"","","","","","","","","","","","","","",null,"","","",""]
[null,220,"","","","","","","","","","","","","","",null,"","","",""]
[null,221,"","","","","","","","","","","","","","",null,"","","",""]
[null,222,"","","","","","","","","","","","","","",null,"","","",""]
[null,223,"","","","","","","","","","","","","","",null,"","","",""]
[null,224,"","","","","","","","","","","","","","",null,"","","",""]
[null,225,"","","","","","","","","","","","","","",null,"","","",""]
[null,226,"","","","","","","","","","","","","","",null,"","","",""]
[null,227,"","","","","","","","","","","","","","",null,"","","",""]
[null,228,"","","","","","","","","","","","","","",null,"","","",""]
[null,229,"","","","","","","","","","","","","","",null,"","","",""]
[null,230,"","","","","","","","","","","","","","",null,"","","",""]
[null,231,"","","","","","","","","","","","","","",null,"","","",""]
[null,232,"","","","","","","","","","","","","","",null,"","","",""]
[null,233,"","","","","","","","","","","","","","",null,"","","",""]
[null,234,"","","","","","","","","","","","","","",null,"","","",""]
[null,235,"","","","","","","","","","","","","","",null,"","","",""]
[null,236,"","","","","","","","","","","","","","",null,"","","",""]
[null,237,"","","","","","","","","","","","","","",null,"","","",""]
[null,238,"","","","","","","","","","","","","","",null,"","","",""]
[null,239,"","","","","","","","","","","","","","",null,"","","",""]
[null,240,"","","","","","","","","","","","","","",null,"","","",""]
[null,241,"","","","","","","","","","","","","","",null,"","","",""]
[null,242,"","","","","","","","","","","","","","",null,"","","",""]
[null,243,"","","","","","","","","","","","","","",null,"","","",""]
[null,244,"","","","","","","","","","","","","","",null,"","","",""]
[null,245,"","","","","","","","","","","","","","",null,"","","",""]
[null,246,"","","","","","","","","","","","","","",null,"","","",""]
[null,247,"","","","","","","","","","","","","","",null,"","","",""]
[null,248,"","","","","","","","","","","","","","",null,"","","",""]
[null,249,"","","","","","","","","","","","","","",null,"","","",""]
[null,250,"","","","","","","","","","","","","","",null,"","","",""]
[null,251,"","","","","","","","","","","","","","",null,"","","",""]
[null,252,"","","","","","","","","","","","","","",null,"","","",""]
[null,253,"","","","","","","","","","","","","","",null,"","","",""]
[null,254,"","","","","","","","","","","","","","",null,"","","",""]
[null,255,"","","","","","","","","","","","","","",null,"","","",""]
[null,256,"","","","","","","","","","","","","","",null,"","","",""]
[null,257,"",{"$f":"IF(B292<=$C$20,WEEKDAY(C292,2),\"\")","v":""},"","","","","",{"$f":"IF(B292>C$20,\"\",((1+C$25)^(F292/360)-1)*H292)","v":""},{"$f":"IF(B292>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B292>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B292>C$20,\"\",H292-I292)","v":""},"",{"$f":"IFERROR(1/(1+C$26)^(G292/360),\"\")","v":""},null,"",{"$f":"G292","v":""},{"$f":"IFERROR((1+C$32)^(S292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R292/T292,2),\"\")","v":""}]
[null,258,{"$f":"IF(B293>$C$20,\"\",EDATE(C292,1))","v":""},"",{"$f":"IF(D293=7,C293+1,C293)","v":""},{"$f":"IF(B293>C$20,\"\",E293-E292)","v":""},{"$f":"IFERROR(F293+G292,\"\")","v":""},{"$f":"IF(B293>C$20,\"\",N292)","v":""},{"$f":"IF(B293>C$20,\"\",M293-L293-K293-J293)","v":""},"","","",{"$f":"IF(B293>C$20,\"\",IF(B293=C$20,H293+J293+K293+L293,IF(AND(C$23=2,MONTH(C293)=7),2*C$30,IF(AND(C$24=2,MONTH(C293)=12),2*C$30,C$30))))","v":""},"",{"$f":"IFERROR(IF(AND(MONTH(C293)=7,C$23=2),2/(1+C$26)^(G293/360),IF(AND(MONTH(C293)=12,C$24=2),2/(1+C$26)^(G293/360),1/(1+C$26)^(G293/360))),\"\")","v":""},"",null,{"$f":"IFERROR(I293+J293+K293+L293,\"\")","v":""},"","",""]
[null,259,"","","","","","","","","","","","","","",null,"","","",""]
[null,260,"","","","","","","","","","","","","","",null,"","","",""]
[null,261,"","","","","","","","","","","","","","",null,"","","",""]
[null,262,"","","","","","","","","","","","","","",null,"","","",""]
[null,263,"","","","","","","","","","","","","","",null,"","","",""]
[null,264,"","","","","","","","","","","","","","",null,"","","",""]
[null,265,"","","","","","","","","","","","","","",null,"","","",""]
[null,266,"","","","","","","","","","","","","","",null,"","","",""]
[null,267,"","","","","","","","","","","","","","",null,"","","",""]
[null,268,"","","","","","","","","","","","","","",null,"","","",""]
[null,269,"","","","","","","","","","","","","","",null,"","","",""]
[null,270,"","","","","","","","","","","","","","",null,"","","",""]
[null,271,"","","","","","","","","","","","","","",null,"","","",""]
[null,272,"","","","","","","","","","","","","","",null,"","","",""]
[null,273,"","","","","","","","","","","","","","",null,"","","",""]
[null,274,"","","","","","","","","","","","","","",null,"","","",""]
[null,275,"","","","","","","","","","","","","","",null,"","","",""]
[null,276,"","","","","","","","","","","","","","",null,"","","",""]
[null,277,"","","","","","","","","","","","","","",null,"","","",""]
[null,278,"","","","","","","","","","","","","","",null,"","","",""]
[null,279,"","","","","","","","","","","","","","",null,"","","",""]
[null,280,"","","","","","","","","","","","","","",null,"","","",""]
[null,281,"","","","","","","","","","","","","","",null,"","","",""]
[null,282,"","","","","","","","","","","","","","",null,"","","",""]
[null,283,"","","","","","","","","","","","","","",null,"","","",""]
[null,284,"","","","","","","","","","","","","","",null,"","","",""]
[null,285,"","","","","","","","","","","","","","",null,"","","",""]
[null,286,"","","","","","","","","","","","","","",null,"","","",""]
[null,287,"","","","","","","","","","","","","","",null,"","","",""]
[null,288,"","","","","","","","","","","","","","",null,"","","",""]
[null,289,"","","","","","","","","","","","","","",null,"","","",""]
[null,290,"","","","","","","","","","","","","","",null,"","","",""]
[null,291,"","","","","","","","","","","","","","",null,"","","",""]
[null,292,"","","","","","","","","","","","","","",null,"","","",""]
[null,293,"","","","","","","","","","","","","","",null,"","","",""]
[null,294,"","","","","","","","","","","","","","",null,"","","",""]
[null,295,"","","","","","","","","","","","","","",null,"","","",""]
[null,296,"","","","","","","","","","","","","","",null,"","","",""]
[null,297,"","","","","","","","","","","","","","",null,"","","",""]
[null,298,"","","","","","","","","","","","","","",null,"","","",""]
[null,299,"","","","","","","","","","","","","","",null,"","","",""]
[null,300,"","","","","","","","","","","","","","",null,"","","",""]
[null,301,"","","","","","","","","","","","","","",null,"","","",""]
[null,302,"","","","","","","","","","","","","","",null,"","","",""]
[null,303,"","","","","","","","","","","","","","",null,"","","",""]
[null,304,"","","","","","","","","","","","","","",null,"","","",""]
[null,305,"","","","","","","","","","","","","","",null,"","","",""]
[null,306,"","","","","","","","","","","","","","",null,"","","",""]
[null,307,"","","","","","","","","","","","","","",null,"","","",""]
[null,308,"","","","","","","","","","","","","","",null,"","","",""]
[null,309,"","","","","","","","","","","","","","",null,"","","",""]
[null,310,"","","","","","","","","","","","","","",null,"","","",""]
[null,311,"","","","","","","","","","","","","","",null,"","","",""]
[null,312,"","","","","","","","","","","","","","",null,"","","",""]
[null,313,"","","","","","","","","","","","","","",null,"","","",""]
[null,314,"","","","","","","","","","","","","","",null,"","","",""]
[null,315,"","","","","","","","","","","","","","",null,"","","",""]
[null,316,"","","","","","","","","","","","","","",null,"","","",""]
[null,317,"","","","","","","","","","","","","","",null,"","","",""]
[null,318,"","","","","","","","","","","","","","",null,"","","",""]
[null,319,"","","","","","","","","","","","","","",null,"","","",""]
[null,320,"","","","","","","","","","","","","","",null,"","","",""]
[null,321,"",{"$f":"IF(B356<=$C$20,WEEKDAY(C356,2),\"\")","v":""},"","","","","",{"$f":"IF(B356>C$20,\"\",((1+C$25)^(F356/360)-1)*H356)","v":""},{"$f":"IF(B356>C$20,\"\",C$27*C$28)","v":""},{"$f":"IF(B356>C$20,\"\",C$29)","v":""},"",{"$f":"IF(B356>C$20,\"\",H356-I356)","v":""},"",{"$f":"IFERROR(1/(1+C$26)^(G356/360),\"\")","v":""},null,"",{"$f":"G356","v":""},{"$f":"IFERROR((1+C$32)^(S356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(R356/T356,2),\"\")","v":""}]
[null,322,{"$f":"IF(B357>$C$20,\"\",EDATE(C356,1))","v":""},"",{"$f":"IF(D357=7,C357+1,C357)","v":""},{"$f":"IF(B357>C$20,\"\",E357-E356)","v":""},{"$f":"IFERROR(F357+G356,\"\")","v":""},{"$f":"IF(B357>C$20,\"\",N356)","v":""},{"$f":"IF(B357>C$20,\"\",M357-L357-K357-J357)","v":""},"","","",{"$f":"IF(B357>C$20,\"\",IF(B357=C$20,H357+J357+K357+L357,IF(AND(C$23=2,MONTH(C357)=7),2*C$30,IF(AND(C$24=2,MONTH(C357)=12),2*C$30,C$30))))","v":""},"",{"$f":"IFERROR(IF(AND(MONTH(C357)=7,C$23=2),2/(1+C$26)^(G357/360),IF(AND(MONTH(C357)=12,C$24=2),2/(1+C$26)^(G357/360),1/(1+C$26)^(G357/360))),\"\")","v":""},"",null,{"$f":"IFERROR(I357+J357+K357+L357,\"\")","v":""},"","",""]
[null,323,"","","","","","","","","","","","","","",null,"","","",""]
[null,324,"","","","","","","","","","","","","","",null,"","","",""]
[null,325,"","","","","","","","","","","","","","",null,"","","",""]
[null,326,"","","","","","","","","","","","","","",null,"","","",""]
[null,327,"","","","","","","","","","","","","","",null,"","","",""]
[null,328,"","","","","","","","","","","","","","",null,"","","",""]
[null,329,"","","","","","","","","","","","","","",null,"","","",""]
[null,330,"","","","","","","","","","","","","","",null,"","","",""]
[null,331,"","","","","","","","","","","","","","",null,"","","",""]
[null,332,"","","","","","","","","","","","","","",null,"","","",""]
[null,333,"","","","","","","","","","","","","","",null,"","","",""]
[null,334,"","","","","","","","","","","","","","",null,"","","",""]
[null,335,"","","","","","","","","","","","","","",null,"","","",""]
[null,336,"","","","","","","","","","","","","","",null,"","","",""]
[null,337,"","","","","","","","","","","","","","",null,"","","",""]
[null,338,"","","","","","","","","","","","","","",null,"","","",""]
[null,339,"","","","","","","","","","","","","","",null,"","","",""]
[null,340,"","","","","","","","","","","","","","",null,"","","",""]
[null,341,"","","","","","","","","","","","","","",null,"","","",""]
[null,342,"","","","","","","","","","","","","","",null,"","","",""]
[null,343,"","","","","","","","","","","","","","",null,"","","",""]
[null,344,"","","","","","","","","","","","","","",null,"","","",""]
[null,345,"","","","","","","","","","","","","","",null,"","","",""]
[null,346,"","","","","","","","","","","","","","",null,"","","",""]
[null,347,"","","","","","","","","","","","","","",null,"","","",""]
[null,348,"","","","","","","","","","","","","","",null,"","","",""]
[null,349,"","","","","","","","","","","","","","",null,"","","",""]
[null,350,"","","","","","","","","","","","","","",null,"","","",""]
[null,351,"","","","","","","","","","","","","","",null,"","","",""]
[null,352,"","","","","","","","","","","","","","",null,"","","",""]
[null,353,"","","","","","","","","","","","","","",null,"","","",""]
[null,354,"","","","","","","","","","","","","","",null,"","","",""]
[null,355,"","","","","","","","","","","","","","",null,"","","",""]
[null,356,"","","","","","","","","","","","","","",null,"","","",""]
[null,357,"","","","","","","","","","","","","","",null,"","","",""]
[null,358,"","","","","","","","","","","","","","",null,"","","",""]
[null,359,"","","","","","","","","","","","","","",null,"","","",""]
[null,360,"","","","","","","","","","","","","","",null,"","","",""]

{"sheet":"Cronograma","index":1,"n_rows":84,"n_cols":9,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Cronograma"]
[]
[null,"Nota: Todo crédito se encuentra sujeto a la evaluación crediticia del Banco, quien determina el monto y plazo a otorgar."]
[null,"Este documento ha sido emitido en base a la información por el cliente y tiene caracter referencial."]
[]
[null,"Tasa de Interés Efectiva Anual (en base a 360 días)",null,null,null,null,{"$f":"+'Vista Principal'!C25","v":0.15}]
[null,"Tasa de Costo Efectiva Anual (en base a 360 días)",null,null,null,null,{"$f":"+'Vista Principal'!C32","v":0.17014719859672053}]
[]
[]
[null,"N° Cuota","Fecha de pago","Saldo Inicial","Amortización","Interés","Envío físico de estado de cuenta","Cuota","Saldo Final"]
[null,{"$f":"+'Vista Principal'!B36","v":1},{"$f":"+'Vista Principal'!C36","v":"2025-11-10"},{"$f":"+'Vista Principal'!H36","v":78150},{"$f":"+'Vista Principal'!I36","v":-265.44829561609458},{"$f":"+'Vista Principal'!J36","v":2121.7507355578482},{"$f":"+'Vista Principal'!L36","v":0},{"$f":"+'Vista Principal'!M36","v":1856.3024399417536},{"$f":"+'Vista Principal'!N36","v":78415.448295616094}]
[null,{"$f":"+'Vista Principal'!B37","v":2},{"$f":"+'Vista Principal'!C37","v":"2025-12-10"},{"$f":"+'Vista Principal'!H37","v":78415.448295616094},{"$f":"+'Vista Principal'!I37","v":937.67197792555282},{"$f":"+'Vista Principal'!J37","v":918.6304620162008},{"$f":"+'Vista Principal'!L37","v":0},{"$f":"+'Vista Principal'!M37","v":1856.3024399417536},{"$f":"+'Vista Principal'!N37","v":77477.776317690543}]
[null,{"$f":"+'Vista Principal'!B38","v":3},{"$f":"+'Vista Principal'!C38","v":"2026-01-10"},{"$f":"+'Vista Principal'!H38","v":77477.776317690543},{"$f":"+'Vista Principal'!I38","v":918.21943367038773},{"$f":"+'Vista Principal'!J38","v":938.08300627136589},{"$f":"+'Vista Principal'!L38","v":0},{"$f":"+'Vista Principal'!M38","v":1856.3024399417536},{"$f":"+'Vista Principal'!N38","v":76559.556884020159}]
[null,{"$f":"+'Vista Principal'!B39","v":4},{"$f":"+'Vista Principal'!C39","v":"2026-02-10"},{"$f":"+'Vista Principal'!H39","v":76559.556884020159},{"$f":"+'Vista Principal'!I39","v":929.33702232216262},{"$f":"+'Vista Principal'!J39","v":926.96541761959099},{"$f":"+'Vista Principal'!L39","v":0},{"$f":"+'Vista Principal'!M39","v":1856.3024399417536},{"$f":"+'Vista Principal'!N39","v":75630.219861698002}]
[null,{"$f":"+'Vista Principal'!B40","v":5},{"$f":"+'Vista Principal'!C40","v":"2026-03-10"},{"$f":"+'Vista Principal'!H40","v":75630.219861698002},{"$f":"+'Vista Principal'!I40","v":1029.6890593046719},{"$f":"+'Vista Principal'!J40","v":826.6133806370816},{"$f":"+'Vista Principal'!L40","v":0},{"$f":"+'Vista Principal'!M40","v":1856.3024399417536},{"$f":"+'Vista Principal'!N40","v":74600.530802393332}]
[null,{"$f":"+'Vista Principal'!B41","v":6},{"$f":"+'Vista Principal'!C41","v":"2026-04-10"},{"$f":"+'Vista Principal'!H41","v":74600.530802393332},{"$f":"+'Vista Principal'!I41","v":953.05645727962792},{"$f":"+'Vista Principal'!J41","v":903.2459826621257},{"$f":"+'Vista Principal'!L41","v":0},{"$f":"+'Vista Principal'!M41","v":1856.3024399417536},{"$f":"+'Vista Principal'!N41","v":73647.474345113704}]
[null,{"$f":"+'Vista Principal'!B42","v":7},{"$f":"+'Vista Principal'!C42","v":"2026-05-10"},{"$f":"+'Vista Principal'!H42","v":73647.474345113704},{"$f":"+'Vista Principal'!I42","v":964.59584456050777},{"$f":"+'Vista Principal'!J42","v":891.70659538124585},{"$f":"+'Vista Principal'!L42","v":0},{"$f":"+'Vista Principal'!M42","v":1856.3024399417536},{"$f":"+'Vista Principal'!N42","v":72682.878500553197}]
[null,{"$f":"+'Vista Principal'!B43","v":8},{"$f":"+'Vista Principal'!C43","v":"2026-06-10"},{"$f":"+'Vista Principal'!H43","v":72682.878500553197},{"$f":"+'Vista Principal'!I43","v":1004.8285568119755},{"$f":"+'Vista Principal'!J43","v":851.47388312977807},{"$f":"+'Vista Principal'!L43","v":0},{"$f":"+'Vista Principal'!M43","v":1856.3024399417536},{"$f":"+'Vista Principal'!N43","v":71678.049943741222}]
[null,{"$f":"+'Vista Principal'!B44","v":9},{"$f":"+'Vista Principal'!C44","v":"2026-07-10"},{"$f":"+'Vista Principal'!H44","v":71678.049943741222},{"$f":"+'Vista Principal'!I44","v":1016.600039873724},{"$f":"+'Vista Principal'!J44","v":839.70240006802965},{"$f":"+'Vista Principal'!L44","v":0},{"$f":"+'Vista Principal'!M44","v":1856.3024399417536},{"$f":"+'Vista Principal'!N44","v":70661.449903867499}]
[null,{"$f":"+'Vista Principal'!B45","v":10},{"$f":"+'Vista Principal'!C45","v":"2026-08-10"},{"$f":"+'Vista Principal'!H45","v":70661.449903867499},{"$f":"+'Vista Principal'!I45","v":1000.7499382603347},{"$f":"+'Vista Principal'!J45","v":855.5525016814189},{"$f":"+'Vista Principal'!L45","v":0},{"$f":"+'Vista Principal'!M45","v":1856.3024399417536},{"$f":"+'Vista Principal'!N45","v":69660.699965607157}]
[null,{"$f":"+'Vista Principal'!B46","v":11},{"$f":"+'Vista Principal'!C46","v":"2026-09-10"},{"$f":"+'Vista Principal'!H46","v":69660.699965607157},{"$f":"+'Vista Principal'!I46","v":1012.8667871843376},{"$f":"+'Vista Principal'!J46","v":843.43565275741605},{"$f":"+'Vista Principal'!L46","v":0},{"$f":"+'Vista Principal'!M46","v":1856.3024399417536},{"$f":"+'Vista Principal'!N46","v":68647.833178422821}]
[null,{"$f":"+'Vista Principal'!B47","v":12},{"$f":"+'Vista Principal'!C47","v":"2026-10-10"},{"$f":"+'Vista Principal'!H47","v":68647.833178422821},{"$f":"+'Vista Principal'!I47","v":1052.0987775285757},{"$f":"+'Vista Principal'!J47","v":804.20366241317777},{"$f":"+'Vista Principal'!L47","v":0},{"$f":"+'Vista Principal'!M47","v":1856.3024399417536},{"$f":"+'Vista Principal'!N47","v":67595.734400894245}]
[null,{"$f":"+'Vista Principal'!B48","v":13},{"$f":"+'Vista Principal'!C48","v":"2026-11-10"},{"$f":"+'Vista Principal'!H48","v":67595.734400894245},{"$f":"+'Vista Principal'!I48","v":1037.8689129145573},{"$f":"+'Vista Principal'!J48","v":818.43352702719631},{"$f":"+'Vista Principal'!L48","v":0},{"$f":"+'Vista Principal'!M48","v":1856.3024399417536},{"$f":"+'Vista Principal'!N48","v":66557.865487979681}]
[null,{"$f":"+'Vista Principal'!B49","v":14},{"$f":"+'Vista Principal'!C49","v":"2026-12-10"},{"$f":"+'Vista Principal'!H49","v":66557.865487979681},{"$f":"+'Vista Principal'!I49","v":1076.582575387295},{"$f":"+'Vista Principal'!J49","v":779.71986455445847},{"$f":"+'Vista Principal'!L49","v":0},{"$f":"+'Vista Principal'!M49","v":1856.3024399417536},{"$f":"+'Vista Principal'!N49","v":65481.282912592389}]
[null,{"$f":"+'Vista Principal'!B50","v":15},{"$f":"+'Vista Principal'!C50","v":"2027-01-10"},{"$f":"+'Vista Principal'!H50","v":65481.282912592389},{"$f":"+'Vista Principal'!I50","v":1037.7357658419726},{"$f":"+'Vista Principal'!J50","v":818.56667409978104},{"$f":"+'Vista Principal'!L50","v":0},{"$f":"+'Vista Principal'!M50","v":1856.3024399417536},{"$f":"+'Vista Principal'!N50","v":64443.547146750418}]
[null,{"$f":"+'Vista Principal'!B51","v":16},{"$f":"+'Vista Principal'!C51","v":"2027-02-10"},{"$f":"+'Vista Principal'!H51","v":64443.547146750418},{"$f":"+'Vista Principal'!I51","v":1101.351639096918},{"$f":"+'Vista Principal'!J51","v":754.9508008448355},{"$f":"+'Vista Principal'!L51","v":0},{"$f":"+'Vista Principal'!M51","v":1856.3024399417536},{"$f":"+'Vista Principal'!N51","v":63342.195507653501}]
[null,{"$f":"+'Vista Principal'!B52","v":17},{"$f":"+'Vista Principal'!C52","v":"2027-03-10"},{"$f":"+'Vista Principal'!H52","v":63342.195507653501},{"$f":"+'Vista Principal'!I52","v":1163.9931162176631},{"$f":"+'Vista Principal'!J52","v":692.30932372409052},{"$f":"+'Vista Principal'!L52","v":0},{"$f":"+'Vista Principal'!M52","v":1856.3024399417536},{"$f":"+'Vista Principal'!N52","v":62178.202391435836}]
[null,{"$f":"+'Vista Principal'!B53","v":18},{"$f":"+'Vista Principal'!C53","v":"2027-04-10"},{"$f":"+'Vista Principal'!H53","v":62178.202391435836},{"$f":"+'Vista Principal'!I53","v":1103.4631381949193},{"$f":"+'Vista Principal'!J53","v":752.83930174683428},{"$f":"+'Vista Principal'!L53","v":0},{"$f":"+'Vista Principal'!M53","v":1856.3024399417536},{"$f":"+'Vista Principal'!N53","v":61074.739253240914}]
[null,{"$f":"+'Vista Principal'!B54","v":19},{"$f":"+'Vista Principal'!C54","v":"2027-05-10"},{"$f":"+'Vista Principal'!H54","v":61074.739253240914},{"$f":"+'Vista Principal'!I54","v":1140.8169436883281},{"$f":"+'Vista Principal'!J54","v":715.48549625342537},{"$f":"+'Vista Principal'!L54","v":0},{"$f":"+'Vista Principal'!M54","v":1856.3024399417536},{"$f":"+'Vista Principal'!N54","v":59933.922309552589}]
[null,{"$f":"+'Vista Principal'!B55","v":20},{"$f":"+'Vista Principal'!C55","v":"2027-06-10"},{"$f":"+'Vista Principal'!H55","v":59933.922309552589},{"$f":"+'Vista Principal'!I55","v":1130.6363626495722},{"$f":"+'Vista Principal'!J55","v":725.66607729218151},{"$f":"+'Vista Principal'!L55","v":0},{"$f":"+'Vista Principal'!M55","v":1856.3024399417536},{"$f":"+'Vista Principal'!N55","v":58803.285946903015}]
[null,{"$f":"+'Vista Principal'!B56","v":21},{"$f":"+'Vista Principal'!C56","v":"2027-07-10"},{"$f":"+'Vista Principal'!H56","v":58803.285946903015},{"$f":"+'Vista Principal'!I56","v":1167.4268304594029},{"$f":"+'Vista Principal'!J56","v":688.87560948235057},{"$f":"+'Vista Principal'!L56","v":0},{"$f":"+'Vista Principal'!M56","v":1856.3024399417536},{"$f":"+'Vista Principal'!N56","v":57635.859116443615}]
[null,{"$f":"+'Vista Principal'!B57","v":22},{"$f":"+'Vista Principal'!C57","v":"2027-08-10"},{"$f":"+'Vista Principal'!H57","v":57635.859116443615},{"$f":"+'Vista Principal'!I57","v":1158.4607805827054},{"$f":"+'Vista Principal'!J57","v":697.84165935904821},{"$f":"+'Vista Principal'!L57","v":0},{"$f":"+'Vista Principal'!M57","v":1856.3024399417536},{"$f":"+'Vista Principal'!N57","v":56477.398335860911}]
[null,{"$f":"+'Vista Principal'!B58","v":23},{"$f":"+'Vista Principal'!C58","v":"2027-09-10"},{"$f":"+'Vista Principal'!H58","v":56477.398335860911},{"$f":"+'Vista Principal'!I58","v":1172.4871559298817},{"$f":"+'Vista Principal'!J58","v":683.81528401187188},{"$f":"+'Vista Principal'!L58","v":0},{"$f":"+'Vista Principal'!M58","v":1856.3024399417536},{"$f":"+'Vista Principal'!N58","v":55304.911179931027}]
[null,{"$f":"+'Vista Principal'!B59","v":24},{"$f":"+'Vista Principal'!C59","v":"2027-10-10"},{"$f":"+'Vista Principal'!H59","v":55304.911179931027},{"$f":"+'Vista Principal'!I59","v":1186.6833593874935},{"$f":"+'Vista Principal'!J59","v":669.61908055426011},{"$f":"+'Vista Principal'!L59","v":0},{"$f":"+'Vista Principal'!M59","v":1856.3024399417536},{"$f":"+'Vista Principal'!N59","v":54118.227820543536}]
[null,{"$f":"+'Vista Principal'!B60","v":25},{"$f":"+'Vista Principal'!C60","v":"2027-11-10"},{"$f":"+'Vista Principal'!H60","v":54118.227820543536},{"$f":"+'Vista Principal'!I60","v":1222.3118971743884},{"$f":"+'Vista Principal'!J60","v":633.99054276736535},{"$f":"+'Vista Principal'!L60","v":0},{"$f":"+'Vista Principal'!M60","v":1856.3024399417536},{"$f":"+'Vista Principal'!N60","v":52895.915923369146}]
[null,{"$f":"+'Vista Principal'!B61","v":26},{"$f":"+'Vista Principal'!C61","v":"2027-12-10"},{"$f":"+'Vista Principal'!H61","v":52895.915923369146},{"$f":"+'Vista Principal'!I61","v":1236.6311794999347},{"$f":"+'Vista Principal'!J61","v":619.67126044181907},{"$f":"+'Vista Principal'!L61","v":0},{"$f":"+'Vista Principal'!M61","v":1856.3024399417536},{"$f":"+'Vista Principal'!N61","v":51659.284743869212}]
[null,{"$f":"+'Vista Principal'!B62","v":27},{"$f":"+'Vista Principal'!C62","v":"2028-01-10"},{"$f":"+'Vista Principal'!H62","v":51659.284743869212},{"$f":"+'Vista Principal'!I62","v":1230.8237615701819},{"$f":"+'Vista Principal'!J62","v":625.47867837157162},{"$f":"+'Vista Principal'!L62","v":0},{"$f":"+'Vista Principal'!M62","v":1856.3024399417536},{"$f":"+'Vista Principal'!N62","v":50428.460982299031}]
[null,{"$f":"+'Vista Principal'!B63","v":28},{"$f":"+'Vista Principal'!C63","v":"2028-02-10"},{"$f":"+'Vista Principal'!H63","v":50428.460982299031},{"$f":"+'Vista Principal'!I63","v":1245.7262911640823},{"$f":"+'Vista Principal'!J63","v":610.57614877767116},{"$f":"+'Vista Principal'!L63","v":0},{"$f":"+'Vista Principal'!M63","v":1856.3024399417536},{"$f":"+'Vista Principal'!N63","v":49182.734691134952}]
[null,{"$f":"+'Vista Principal'!B64","v":29},{"$f":"+'Vista Principal'!C64","v":"2028-03-10"},{"$f":"+'Vista Principal'!H64","v":49182.734691134952},{"$f":"+'Vista Principal'!I64","v":1299.4448214498857},{"$f":"+'Vista Principal'!J64","v":556.85761849186804},{"$f":"+'Vista Principal'!L64","v":0},{"$f":"+'Vista Principal'!M64","v":1856.3024399417536},{"$f":"+'Vista Principal'!N64","v":47883.289869685068}]
[null,{"$f":"+'Vista Principal'!B65","v":30},{"$f":"+'Vista Principal'!C65","v":"2028-04-10"},{"$f":"+'Vista Principal'!H65","v":47883.289869685068},{"$f":"+'Vista Principal'!I65","v":1276.542634666326},{"$f":"+'Vista Principal'!J65","v":579.75980527542765},{"$f":"+'Vista Principal'!L65","v":0},{"$f":"+'Vista Principal'!M65","v":1856.3024399417536},{"$f":"+'Vista Principal'!N65","v":46606.747235018745}]
[null,{"$f":"+'Vista Principal'!B66","v":31},{"$f":"+'Vista Principal'!C66","v":"2028-05-10"},{"$f":"+'Vista Principal'!H66","v":46606.747235018745},{"$f":"+'Vista Principal'!I66","v":1310.3082681789028},{"$f":"+'Vista Principal'!J66","v":545.99417176285078},{"$f":"+'Vista Principal'!L66","v":0},{"$f":"+'Vista Principal'!M66","v":1856.3024399417536},{"$f":"+'Vista Principal'!N66","v":45296.438966839843}]
[null,{"$f":"+'Vista Principal'!B67","v":32},{"$f":"+'Vista Principal'!C67","v":"2028-06-10"},{"$f":"+'Vista Principal'!H67","v":45296.438966839843},{"$f":"+'Vista Principal'!I67","v":1307.8636274341934},{"$f":"+'Vista Principal'!J67","v":548.4388125075601},{"$f":"+'Vista Principal'!L67","v":0},{"$f":"+'Vista Principal'!M67","v":1856.3024399417536},{"$f":"+'Vista Principal'!N67","v":43988.575339405652}]
[null,{"$f":"+'Vista Principal'!B68","v":33},{"$f":"+'Vista Principal'!C68","v":"2028-07-10"},{"$f":"+'Vista Principal'!H68","v":43988.575339405652},{"$f":"+'Vista Principal'!I68","v":1340.9799344179053},{"$f":"+'Vista Principal'!J68","v":515.32250552384835},{"$f":"+'Vista Principal'!L68","v":0},{"$f":"+'Vista Principal'!M68","v":1856.3024399417536},{"$f":"+'Vista Principal'!N68","v":42647.595404987747}]
[null,{"$f":"+'Vista Principal'!B69","v":34},{"$f":"+'Vista Principal'!C69","v":"2028-08-10"},{"$f":"+'Vista Principal'!H69","v":42647.595404987747},{"$f":"+'Vista Principal'!I69","v":1339.9352129873969},{"$f":"+'Vista Principal'!J69","v":516.36722695435674},{"$f":"+'Vista Principal'!L69","v":0},{"$f":"+'Vista Principal'!M69","v":1856.3024399417536},{"$f":"+'Vista Principal'!N69","v":41307.660192000352}]
[null,{"$f":"+'Vista Principal'!B70","v":35},{"$f":"+'Vista Principal'!C70","v":"2028-09-10"},{"$f":"+'Vista Principal'!H70","v":41307.660192000352},{"$f":"+'Vista Principal'!I70","v":1339.9247436870087},{"$f":"+'Vista Principal'!J70","v":516.37769625474493},{"$f":"+'Vista Principal'!L70","v":0},{"$f":"+'Vista Principal'!M70","v":1856.3024399417536},{"$f":"+'Vista Principal'!N70","v":39967.735448313346}]
[null,{"$f":"+'Vista Principal'!B71","v":36},{"$f":"+'Vista Principal'!C71","v":"2028-10-10"},{"$f":"+'Vista Principal'!H71","v":39967.735448313346},{"$f":"+'Vista Principal'!I71","v":1403.7790469659576},{"$f":"+'Vista Principal'!J71","v":452.52339297579613},{"$f":"+'Vista Principal'!L71","v":0},{"$f":"+'Vista Principal'!M71","v":1856.3024399417536},{"$f":"+'Vista Principal'!N71","v":38563.956401347386}]
[null,{"$f":"+'Vista Principal'!B72","v":37},{"$f":"+'Vista Principal'!C72","v":"2028-11-10"},{"$f":"+'Vista Principal'!H72","v":38563.956401347386},{"$f":"+'Vista Principal'!I72","v":1389.378970089487},{"$f":"+'Vista Principal'!J72","v":466.92346985226663},{"$f":"+'Vista Principal'!L72","v":0},{"$f":"+'Vista Principal'!M72","v":1856.3024399417536},{"$f":"+'Vista Principal'!N72","v":37174.577431257901}]
[null,{"$f":"+'Vista Principal'!B73","v":38},{"$f":"+'Vista Principal'!C73","v":"2028-12-10"},{"$f":"+'Vista Principal'!H73","v":37174.577431257901},{"$f":"+'Vista Principal'!I73","v":1406.2012494972939},{"$f":"+'Vista Principal'!J73","v":450.10119044445969},{"$f":"+'Vista Principal'!L73","v":0},{"$f":"+'Vista Principal'!M73","v":1856.3024399417536},{"$f":"+'Vista Principal'!N73","v":35768.376181760606}]
[null,{"$f":"+'Vista Principal'!B74","v":39},{"$f":"+'Vista Principal'!C74","v":"2029-01-10"},{"$f":"+'Vista Principal'!H74","v":35768.376181760606},{"$f":"+'Vista Principal'!I74","v":1437.2788846143658},{"$f":"+'Vista Principal'!J74","v":419.02355532738795},{"$f":"+'Vista Principal'!L74","v":0},{"$f":"+'Vista Principal'!M74","v":1856.3024399417536},{"$f":"+'Vista Principal'!N74","v":34331.09729714624}]
[null,{"$f":"+'Vista Principal'!B75","v":40},{"$f":"+'Vista Principal'!C75","v":"2029-02-10"},{"$f":"+'Vista Principal'!H75","v":34331.09729714624},{"$f":"+'Vista Principal'!I75","v":1440.6294496761795},{"$f":"+'Vista Principal'!J75","v":415.67299026557407},{"$f":"+'Vista Principal'!L75","v":0},{"$f":"+'Vista Principal'!M75","v":1856.3024399417536},{"$f":"+'Vista Principal'!N75","v":32890.467847470063}]
[null,{"$f":"+'Vista Principal'!B76","v":41},{"$f":"+'Vista Principal'!C76","v":"2029-03-10"},{"$f":"+'Vista Principal'!H76","v":32890.467847470063},{"$f":"+'Vista Principal'!I76","v":1496.8204647756158},{"$f":"+'Vista Principal'!J76","v":359.48197516613783},{"$f":"+'Vista Principal'!L76","v":0},{"$f":"+'Vista Principal'!M76","v":1856.3024399417536},{"$f":"+'Vista Principal'!N76","v":31393.647382694446}]
[null,{"$f":"+'Vista Principal'!B77","v":42},{"$f":"+'Vista Principal'!C77","v":"2029-04-10"},{"$f":"+'Vista Principal'!H77","v":31393.647382694446},{"$f":"+'Vista Principal'!I77","v":1476.1954142338295},{"$f":"+'Vista Principal'!J77","v":380.10702570792421},{"$f":"+'Vista Principal'!L77","v":0},{"$f":"+'Vista Principal'!M77","v":1856.3024399417536},{"$f":"+'Vista Principal'!N77","v":29917.451968460617}]
[null,{"$f":"+'Vista Principal'!B78","v":43},{"$f":"+'Vista Principal'!C78","v":"2029-05-10"},{"$f":"+'Vista Principal'!H78","v":29917.451968460617},{"$f":"+'Vista Principal'!I78","v":1505.8219756775336},{"$f":"+'Vista Principal'!J78","v":350.48046426422007},{"$f":"+'Vista Principal'!L78","v":0},{"$f":"+'Vista Principal'!M78","v":1856.3024399417536},{"$f":"+'Vista Principal'!N78","v":28411.629992783084}]
[null,{"$f":"+'Vista Principal'!B79","v":44},{"$f":"+'Vista Principal'!C79","v":"2029-06-10"},{"$f":"+'Vista Principal'!H79","v":28411.629992783084},{"$f":"+'Vista Principal'!I79","v":1501.1350938775299},{"$f":"+'Vista Principal'!J79","v":355.16734606422364},{"$f":"+'Vista Principal'!L79","v":0},{"$f":"+'Vista Principal'!M79","v":1856.3024399417536},{"$f":"+'Vista Principal'!N79","v":26910.494898905556}]
[null,{"$f":"+'Vista Principal'!B80","v":45},{"$f":"+'Vista Principal'!C80","v":"2029-07-10"},{"$f":"+'Vista Principal'!H80","v":26910.494898905556},{"$f":"+'Vista Principal'!I80","v":1551.615964170345},{"$f":"+'Vista Principal'!J80","v":304.68647577140865},{"$f":"+'Vista Principal'!L80","v":0},{"$f":"+'Vista Principal'!M80","v":1856.3024399417536},{"$f":"+'Vista Principal'!N80","v":25358.87893473521}]
[null,{"$f":"+'Vista Principal'!B81","v":46},{"$f":"+'Vista Principal'!C81","v":"2029-08-10"},{"$f":"+'Vista Principal'!H81","v":25358.87893473521},{"$f":"+'Vista Principal'!I81","v":1549.262995634208},{"$f":"+'Vista Principal'!J81","v":307.03944430754558},{"$f":"+'Vista Principal'!L81","v":0},{"$f":"+'Vista Principal'!M81","v":1856.3024399417536},{"$f":"+'Vista Principal'!N81","v":23809.615939101001}]
[null,{"$f":"+'Vista Principal'!B82","v":47},{"$f":"+'Vista Principal'!C82","v":"2029-09-10"},{"$f":"+'Vista Principal'!H82","v":23809.615939101001},{"$f":"+'Vista Principal'!I82","v":1568.0211138653024},{"$f":"+'Vista Principal'!J82","v":288.28132607645119},{"$f":"+'Vista Principal'!L82","v":0},{"$f":"+'Vista Principal'!M82","v":1856.3024399417536},{"$f":"+'Vista Principal'!N82","v":22241.594825235697}]
[null,{"$f":"+'Vista Principal'!B83","v":48},{"$f":"+'Vista Principal'!C83","v":"2029-10-10"},{"$f":"+'Vista Principal'!H83","v":22241.594825235697},{"$f":"+'Vista Principal'!I83","v":1595.7440043990766},{"$f":"+'Vista Principal'!J83","v":260.55843554267705},{"$f":"+'Vista Principal'!L83","v":0},{"$f":"+'Vista Principal'!M83","v":1856.3024399417536},{"$f":"+'Vista Principal'!N83","v":20645.850820836622}]
[null,{"$f":"+'Vista Principal'!B84","v":49},{"$f":"+'Vista Principal'!C84","v":"2029-11-10"},{"$f":"+'Vista Principal'!H84","v":20645.850820836622},{"$f":"+'Vista Principal'!I84","v":1606.3272505968012},{"$f":"+'Vista Principal'!J84","v":249.97518934495244},{"$f":"+'Vista Principal'!L84","v":0},{"$f":"+'Vista Principal'!M84","v":1856.3024399417536},{"$f":"+'Vista Principal'!N84","v":19039.52357023982}]
[null,{"$f":"+'Vista Principal'!B85","v":50},{"$f":"+'Vista Principal'!C85","v":"2029-12-10"},{"$f":"+'Vista Principal'!H85","v":19039.52357023982},{"$f":"+'Vista Principal'!I85","v":1633.256003122804},{"$f":"+'Vista Principal'!J85","v":223.0464368189497},{"$f":"+'Vista Principal'!L85","v":0},{"$f":"+'Vista Principal'!M85","v":1856.3024399417536},{"$f":"+'Vista Principal'!N85","v":17406.267567117015}]
[null,{"$f":"+'Vista Principal'!B86","v":51},{"$f":"+'Vista Principal'!C86","v":"2030-01-10"},{"$f":"+'Vista Principal'!H86","v":17406.267567117015},{"$f":"+'Vista Principal'!I86","v":1645.5513757866431},{"$f":"+'Vista Principal'!J86","v":210.75106415511053},{"$f":"+'Vista Principal'!L86","v":0},{"$f":"+'Vista Principal'!M86","v":1856.3024399417536},{"$f":"+'Vista Principal'!N86","v":15760.716191330372}]
[null,{"$f":"+'Vista Principal'!B87","v":52},{"$f":"+'Vista Principal'!C87","v":"2030-02-10"},{"$f":"+'Vista Principal'!H87","v":15760.716191330372},{"$f":"+'Vista Principal'!I87","v":1659.2812995436796},{"$f":"+'Vista Principal'!J87","v":197.02114039807404},{"$f":"+'Vista Principal'!L87","v":0},{"$f":"+'Vista Principal'!M87","v":1856.3024399417536},{"$f":"+'Vista Principal'!N87","v":14101.434891786692}]
[null,{"$f":"+'Vista Principal'!B88","v":53},{"$f":"+'Vista Principal'!C88","v":"2030-03-10"},{"$f":"+'Vista Principal'!H88","v":14101.434891786692},{"$f":"+'Vista Principal'!I88","v":1702.1784034250127},{"$f":"+'Vista Principal'!J88","v":154.12403651674106},{"$f":"+'Vista Principal'!L88","v":0},{"$f":"+'Vista Principal'!M88","v":1856.3024399417536},{"$f":"+'Vista Principal'!N88","v":12399.25648836168}]
[null,{"$f":"+'Vista Principal'!B89","v":54},{"$f":"+'Vista Principal'!C89","v":"2030-04-10"},{"$f":"+'Vista Principal'!H89","v":12399.25648836168},{"$f":"+'Vista Principal'!I89","v":1711.0461803126436},{"$f":"+'Vista Principal'!J89","v":145.25625962911005},{"$f":"+'Vista Principal'!L89","v":0},{"$f":"+'Vista Principal'!M89","v":1856.3024399417536},{"$f":"+'Vista Principal'!N89","v":10688.210308049036}]
[null,{"$f":"+'Vista Principal'!B90","v":55},{"$f":"+'Vista Principal'!C90","v":"2030-05-10"},{"$f":"+'Vista Principal'!H90","v":10688.210308049036},{"$f":"+'Vista Principal'!I90","v":1731.0909441610386},{"$f":"+'Vista Principal'!J90","v":125.21149578071496},{"$f":"+'Vista Principal'!L90","v":0},{"$f":"+'Vista Principal'!M90","v":1856.3024399417536},{"$f":"+'Vista Principal'!N90","v":8957.1193638879977}]
[null,{"$f":"+'Vista Principal'!B91","v":56},{"$f":"+'Vista Principal'!C91","v":"2030-06-10"},{"$f":"+'Vista Principal'!H91","v":8957.1193638879977},{"$f":"+'Vista Principal'!I91","v":1747.8517091676315},{"$f":"+'Vista Principal'!J91","v":108.45073077412219},{"$f":"+'Vista Principal'!L91","v":0},{"$f":"+'Vista Principal'!M91","v":1856.3024399417536},{"$f":"+'Vista Principal'!N91","v":7209.2676547203664}]
[null,{"$f":"+'Vista Principal'!B92","v":57},{"$f":"+'Vista Principal'!C92","v":"2030-07-10"},{"$f":"+'Vista Principal'!H92","v":7209.2676547203664},{"$f":"+'Vista Principal'!I92","v":1771.8464683137183},{"$f":"+'Vista Principal'!J92","v":84.455971628035314},{"$f":"+'Vista Principal'!L92","v":0},{"$f":"+'Vista Principal'!M92","v":1856.3024399417536},{"$f":"+'Vista Principal'!N92","v":5437.4211864066483}]
[null,{"$f":"+'Vista Principal'!B93","v":58},{"$f":"+'Vista Principal'!C93","v":"2030-08-10"},{"$f":"+'Vista Principal'!H93","v":5437.4211864066483},{"$f":"+'Vista Principal'!I93","v":1790.4674011043869},{"$f":"+'Vista Principal'!J93","v":65.835038837366682},{"$f":"+'Vista Principal'!L93","v":0},{"$f":"+'Vista Principal'!M93","v":1856.3024399417536},{"$f":"+'Vista Principal'!N93","v":3646.9537853022612}]
[null,{"$f":"+'Vista Principal'!B94","v":59},{"$f":"+'Vista Principal'!C94","v":"2030-09-10"},{"$f":"+'Vista Principal'!H94","v":3646.9537853022612},{"$f":"+'Vista Principal'!I94","v":1812.1459665212853},{"$f":"+'Vista Principal'!J94","v":44.156473420468195},{"$f":"+'Vista Principal'!L94","v":0},{"$f":"+'Vista Principal'!M94","v":1856.3024399417536},{"$f":"+'Vista Principal'!N94","v":1834.8078187809758}]
[null,{"$f":"+'Vista Principal'!B95","v":60},{"$f":"+'Vista Principal'!C95","v":"2030-10-10"},{"$f":"+'Vista Principal'!H95","v":1834.8078187809758},{"$f":"+'Vista Principal'!I95","v":1834.8078187809758},{"$f":"+'Vista Principal'!J95","v":21.494621160916527},{"$f":"+'Vista Principal'!L95","v":0},{"$f":"+'Vista Principal'!M95","v":1856.3024399418923},{"$f":"+'Vista Principal'!N95","v":0}]
[null,{"$f":"+'Vista Principal'!B96","v":61},{"$f":"+'Vista Principal'!C96","v":""},{"$f":"+'Vista Principal'!H96","v":""},{"$f":"+'Vista Principal'!I96","v":""},{"$f":"+'Vista Principal'!J96","v":""},{"$f":"+'Vista Principal'!L96","v":""},{"$f":"+'Vista Principal'!M96","v":""},{"$f":"+'Vista Principal'!N96","v":""}]
[null,{"$f":"+'Vista Principal'!B97","v":62},{"$f":"+'Vista Principal'!C97","v":""},{"$f":"+'Vista Principal'!H97","v":""},{"$f":"+'Vista Principal'!I97","v":""},{"$f":"+'Vista Principal'!J97","v":""},{"$f":"+'Vista Principal'!L97","v":""},{"$f":"+'Vista Principal'!M97","v":""},{"$f":"+'Vista Principal'!N97","v":""}]
[null,{"$f":"+'Vista Principal'!B98","v":63},{"$f":"+'Vista Principal'!C98","v":""},{"$f":"+'Vista Principal'!H98","v":""},{"$f":"+'Vista Principal'!I98","v":""},{"$f":"+'Vista Principal'!J98","v":""},{"$f":"+'Vista Principal'!L98","v":""},{"$f":"+'Vista Principal'!M98","v":""},{"$f":"+'Vista Principal'!N98","v":""}]
[null,{"$f":"+'Vista Principal'!B99","v":64},{"$f":"+'Vista Principal'!C99","v":""},{"$f":"+'Vista Principal'!H99","v":""},{"$f":"+'Vista Principal'!I99","v":""},{"$f":"+'Vista Principal'!J99","v":""},{"$f":"+'Vista Principal'!L99","v":""},{"$f":"+'Vista Principal'!M99","v":""},{"$f":"+'Vista Principal'!N99","v":""}]
[null,{"$f":"+'Vista Principal'!B100","v":65},{"$f":"+'Vista Principal'!C100","v":""},{"$f":"+'Vista Principal'!H100","v":""},{"$f":"+'Vista Principal'!I100","v":""},{"$f":"+'Vista Principal'!J100","v":""},{"$f":"+'Vista Principal'!L100","v":""},{"$f":"+'Vista Principal'!M100","v":""},{"$f":"+'Vista Principal'!N100","v":""}]
[null,{"$f":"+'Vista Principal'!B101","v":66},{"$f":"+'Vista Principal'!C101","v":""},{"$f":"+'Vista Principal'!H101","v":""},{"$f":"+'Vista Principal'!I101","v":""},{"$f":"+'Vista Principal'!J101","v":""},{"$f":"+'Vista Principal'!L101","v":""},{"$f":"+'Vista Principal'!M101","v":""},{"$f":"+'Vista Principal'!N101","v":""}]
[null,{"$f":"+'Vista Principal'!B102","v":67},{"$f":"+'Vista Principal'!C102","v":""},{"$f":"+'Vista Principal'!H102","v":""},{"$f":"+'Vista Principal'!I102","v":""},{"$f":"+'Vista Principal'!J102","v":""},{"$f":"+'Vista Principal'!L102","v":""},{"$f":"+'Vista Principal'!M102","v":""},{"$f":"+'Vista Principal'!N102","v":""}]
[null,{"$f":"+'Vista Principal'!B103","v":68},{"$f":"+'Vista Principal'!C103","v":""},{"$f":"+'Vista Principal'!H103","v":""},{"$f":"+'Vista Principal'!I103","v":""},{"$f":"+'Vista Principal'!J103","v":""},{"$f":"+'Vista Principal'!L103","v":""},{"$f":"+'Vista Principal'!M103","v":""},{"$f":"+'Vista Principal'!N103","v":""}]
[null,{"$f":"+'Vista Principal'!B104","v":69},{"$f":"+'Vista Principal'!C104","v":""},{"$f":"+'Vista Principal'!H104","v":""},{"$f":"+'Vista Principal'!I104","v":""},{"$f":"+'Vista Principal'!J104","v":""},{"$f":"+'Vista Principal'!L104","v":""},{"$f":"+'Vista Principal'!M104","v":""},{"$f":"+'Vista Principal'!N104","v":""}]
[null,{"$f":"+'Vista Principal'!B105","v":70},{"$f":"+'Vista Principal'!C105","v":""},{"$f":"+'Vista Principal'!H105","v":""},{"$f":"+'Vista Principal'!I105","v":""},{"$f":"+'Vista Principal'!J105","v":""},{"$f":"+'Vista Principal'!L105","v":""},{"$f":"+'Vista Principal'!M105","v":""},{"$f":"+'Vista Principal'!N105","v":""}]
[null,{"$f":"+'Vista Principal'!B106","v":71},{"$f":"+'Vista Principal'!C106","v":""},{"$f":"+'Vista Principal'!H106","v":""},{"$f":"+'Vista Principal'!I106","v":""},{"$f":"+'Vista Principal'!J106","v":""},{"$f":"+'Vista Principal'!L106","v":""},{"$f":"+'Vista Principal'!M106","v":""},{"$f":"+'Vista Principal'!N106","v":""}]
[null,{"$f":"+'Vista Principal'!B107","v":72},{"$f":"+'Vista Principal'!C107","v":""},{"$f":"+'Vista Principal'!H107","v":""},{"$f":"+'Vista Principal'!I107","v":""},{"$f":"+'Vista Principal'!J107","v":""},{"$f":"+'Vista Principal'!L107","v":""},{"$f":"+'Vista Principal'!M107","v":""},{"$f":"+'Vista Principal'!N107","v":""}]
[null,"Total",null,null,{"$f":"SUM(E12:E83)","v":78150},33228.146396505334,0,111378.14639650528]

{"sheet":"Proceso Prima de Seguro","index":2,"n_rows":395,"n_cols":25,"rows_kept":395,"cut":false,"hidden":true,"merged":[[1,3,3,9]]}
[]
[null,null,null,"Proceso de Cálculo de la Prima de Seguros"]
[]
[]
[]
[]
[null,"1) Datos esenciales del préstamo",null,null,null,null,"3) Calculo del valor presente del Seguro"]
[]
[null,"Producto",null,{"$f":"+'Vista Principal'!C9","v":"Préstamos Personales (DXP)"},null,null,"Suma de Prima Mensual",{"$f":"SUM(L36:L395)","v":153055.00776596199}]
[null,"Tipo de Seguro",null,{"$f":"'Vista Principal'!C10","v":"Seguro de Vida"},null,null,"VPN - Valor Presente",{"$f":"NPV(D16,L36:L395)","v":143047.9426926937}]
[null,"Tarifa",null,{"$f":"'Vista Principal'!C11","v":"TARIFA TITULAR"}]
[null,"Monto inicial",null,{"$f":"'Vista Principal'!C12","v":75000},null,null,"4) Calculo del Monto Adicional del Seguro y MAF"]
[null,{"$f":"D10","v":"Seguro de Vida"},{"$f":"+CONCATENATE(D9,D10,D11)","v":"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR"},{"$f":"VLOOKUP(C13,CAPUCCI,2,0)","v":4.2000000000000003E-2}]
[null,"Monto adicional Seguro de Desgravamen/ Vida",null,null,null,null,"Monto inicial",{"$f":"D12","v":75000}]
[null,"MAF Inicial",null,{"$f":"D12+D14","v":75000},null,null,"Monto adicional de Desgravamen / Vida",{"$f":"H10","v":143047.9426926937}]
[null,"Costo Capital",null,{"$f":"INDEX(_xlfn._xlws.FILTER(Tabla2[],Tabla2[TARIFA]=D11),0,2)","v":2.8709999999999999E-3},null,null,"Prima de Seguro de Desgravamen / Vida",{"$f":"H15/H14","v":1.9073059025692494}]
[null,"Moneda",null,{"$f":"'Vista Principal'!C19","v":"Soles"},null,null,"MAF Inicial",{"$f":"H14+H15","v":218047.9426926937}]
[null,"Plazo Remanente Meses",null,{"$f":"'Vista Principal'!C20","v":60}]
[null,"Fecha de Desembolso",null,{"$f":"'Vista Principal'!C21","v":"2025-09-02"}]
[null,"Fecha de 1er Pago",null,{"$f":"'Vista Principal'!C22","v":"2025-11-10"}]
[null,"Cuota Julio",null,{"$f":"'Vista Principal'!C23","v":1}]
[null,"Cuota Diciembre",null,{"$f":"'Vista Principal'!C24","v":1}]
[null,"TEA",null,{"$f":"'Vista Principal'!C25","v":0.15}]
[null,"TEA TOTAL",null,{"$f":"(1+(((1+D23)^(30/360)-1)+D13))^12-1","v":0.8736028495117385}]
[null,"Monto del Bien",null,0]
[null,"Seguro del Bien",null,0]
[null,"Portes",null,0]
[null,"Cuota",null,{"$f":"(D15+(D26*D25+D27)*R34)/Q34","v":4557.3558023684673}]
[]
[null,"TCEA",null,0.23730675268258045]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D15-W34-D14","v":-86099.070000000036}]
[]
[null,"2) Creación de Cronograma de prima mensual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q36:Q395)","v":16.456911255650116},{"$f":"SUM(R36:R395)","v":16.456911255650116},null,null,null,null,{"$f":"SUM(W36:W395)","v":161099.07000000004}]
[null,"N° Cuota",null,"Fecha de pago","Día","Fecha de pago","Días","Dias Acumulados","Saldo Inicial","Amortización","Interés","Seguro Desgravamen","Seguro del Bien","Portes","Cuota Constante","Saldo Final","Factor Cronograma","Factor Cronograma 2",null,"Vector i,1\nCuota","Vector i,2\nDías Acum","Vector i,3 Factor","Vector i,4\nCalculo VA","VPN - Valor Presente","VPN - Valor Presente"]
[null,1,null,{"$f":"D20","v":"2025-11-10"},{"$f":"IF(B36<=$D$18,WEEKDAY(D36,2),\"\")","v":1},{"$f":"IF(E36=7,D36+1,D36)","v":"2025-11-10"},{"$f":"F36-D19","v":69},{"$f":"G36","v":69},{"$f":"D15","v":75000},{"$f":"IF(B36>D$18,\"\",O36-N36-M36-L36-K36)","v":-4922.4865019976369},{"$f":"IF(B36>D$18,\"\",((1+D$23)^(G36/360)-1)*I36)","v":2036.229112819432},{"$f":"IF(B36>D$18,\"\",((1+D$13)^(G36/30)-1)*I36)","v":7443.6131915466722},{"$f":"IF(B36>D$18,\"\",D$25*D$26)","v":0},{"$f":"IF(B36>D$18,\"\",D$27)","v":0},{"$f":"IF(B36>D$18,\"\",IF(B36=D$18,I36+K36+L36+M36+N36,IF(AND(D$21=2,MONTH(F36)=7),2*D$28,IF(AND(D$22=2,MONTH(F36)=12),2*D$28,D$28))))","v":4557.3558023684673},{"$f":"IF(B36>D$18,\"\",I36-J36)","v":79922.486501997642},{"$f":"IFERROR(IF(AND(MONTH(F36)=7,D$21=2),2/(1+D$24)^(H36/360),IF(AND(MONTH(F36)=12,D$22=2),2/(1+D$24)^(H36/360),1/(1+D$24)^(H36/360))),\"\")","v":0.88661853310107197},{"$f":"IFERROR(1/(1+D$24)^(H36/360),\"\")","v":0.88661853310107197},null,{"$f":"IFERROR(J36+K36+L36+M36+N36,\"\")","v":4557.3558023684673},{"$f":"H36","v":69},{"$f":"IFERROR((1+D$30)^(U36/360),\"\")","v":1.0416572280409084},{"$f":"IFERROR(ROUND(T36/V36,2),\"\")","v":4375.1000000000004},{"$f":"L36/(1+$I$9)","v":7443.6131915466722},{"$f":"L36/(1+$Q$28)","v":7443.6131915466722}]
[null,2,null,{"$f":"IF(B37>$D$18,\"\",EDATE(D36,1))","v":"2025-12-10"},3,{"$f":"IF(E37=7,D37+1,D37)","v":"2025-12-10"},{"$f":"IF(B37>D$18,\"\",F37-F36)","v":30},{"$f":"IFERROR(G37+H36,\"\")","v":99},{"$f":"IF(B37>D$18,\"\",P36)","v":79922.486501997642},264.32607988555776,936.28528939900559,{"$f":"IF(B37>D$18,\"\",((1+D$13)^(G37/30)-1)*I37)","v":3356.7444330839039},0,0,4557.3558023684673,79658.16042211208,0.84142163963358707,0.84142163963358707,null,4557.3558023684673,99,1.0603061498642581,4298.1499999999996,{"$f":"IF(O37=\"\",0,L37/((1+$I$9)^B37))","v":3356.7444330839039},{"$f":"IF(O37=\"\",0,L37/((1+$Q$28)^B37))","v":3356.7444330839039}]
[null,3,null,"2026-01-10",6,"2026-01-10",31,130,79658.16042211208,133.32112309653428,964.48259300079337,3459.5520862711396,0,0,4557.3558023684673,79524.839299015541,0.79713726308573907,0.79713726308573907,null,4557.3558023684673,130,1.0799275250939266,4220.0600000000004,3459.5520862711396,3459.5520862711396]
[null,4,null,"2026-02-10",2,"2026-02-10",31,161,79524.839299015541,140.72547776569945,962.86837166019814,3453.7619529425697,0,0,4557.3558023684673,79384.113821249848,0.75518359199382112,0.75518359199382112,null,4557.3558023684673,161,1.0999120014580672,4143.38,3453.7619529425697,3453.7619529425697]
[null,5,null,"2026-03-10",2,"2026-03-10",28,189,79384.113821249848,582.14925399477022,867.64220459306955,3107.5643437806275,0,0,4557.3558023684673,78801.964567255083,0.71919108024108702,0.71919108024108702,null,4557.3558023684673,189,1.118280176018507,4075.33,3107.5643437806275,3107.5643437806275]
[null,6,null,"2026-04-10",5,"2026-04-10",31,220,78801.964567255083,180.87231099824214,954.11597150422438,3422.3675198660007,0,0,4557.3558023684673,78621.092256256845,0.68133974969874556,0.68133974969874556,null,4557.3558023684673,220,1.1389743830155785,4001.28,3422.3675198660007,3422.3675198660007]
[null,7,null,"2026-05-10",7,"2026-05-11",31,251,78621.092256256845,190.91755146244645,951.92601137221504,3414.5122395338058,0,0,4557.3558023684673,78430.174704794394,0.64548055068193033,0.64548055068193033,null,4557.3558023684673,251,1.1600515443137469,3928.58,3414.5122395338058,3414.5122395338058]
[null,8,null,"2026-06-10",3,"2026-06-10",30,281,78430.174704794394,344.48548409084742,918.80298067625245,3294.0673376013674,0,0,4557.3558023684673,78085.689220703542,0.61257607756826149,0.61257607756826149,null,4557.3558023684673,281,1.1808200946377827,3859.48,3294.0673376013674,3294.0673376013674]
[null,9,null,"2026-07-10",5,"2026-07-10",30,311,78085.689220703542,362.98949324888326,914.76736185003256,3279.5989472695514,0,0,4557.3558023684673,77722.699727454659,0.58134896615006793,0.58134896615006793,null,4557.3558023684673,311,1.2019604669594497,3791.6,3279.5989472695514,3279.5989472695514]
[null,10,null,"2026-08-10",1,"2026-08-10",31,342,77722.699727454659,240.81224752319565,941.04848230149412,3375.4950725437775,0,0,4557.3558023684673,77481.887479931465,0.55075232433574184,0.55075232433574184,null,4557.3558023684673,342,1.2242032100921367,3722.71,3375.4950725437775,3375.4950725437775]
[null,11,null,"2026-09-10",4,"2026-09-10",31,373,77481.887479931465,254.18641695656697,938.13278327346279,3365.0366021384375,0,0,4557.3558023684673,77227.701062974898,0.52176599671275903,0.52176599671275903,null,4557.3558023684673,373,1.2468575637857917,3655.07,3365.0366021384375,3365.0366021384375]
[null,12,null,"2026-10-10",6,"2026-10-10",30,403,77227.701062974898,409.07625585949529,904.71610186402347,3243.5634446449485,0,0,4557.3558023684673,76818.624807115397,0.49516808420815506,0.49516808420815506,null,4557.3558023684673,403,1.2691802133157388,3590.79,3243.5634446449485,3243.5634446449485]
[null,13,null,"2026-11-10",2,"2026-11-10",31,434,{"$f":"IF(B48>D$18,\"\",P47)","v":76818.624807115397},{"$f":"IF(B48>D$18,\"\",O48-N48-M48-L48-K48)","v":291.02253080172636},{"$f":"IF(B48>D$18,\"\",((1+D$23)^(G48/360)-1)*I48)","v":930.10215214755613},3336.2311194191848,0,0,4557.3558023684673,{"$f":"IF(B48>D$18,\"\",I48-J48)","v":76527.602276313672},0.46910717863755491,0.46910717863755491,null,{"$f":"IFERROR(J48+K48+L48+M48+N48,\"\")","v":4557.3558023684673},434,1.2926668838426683,3525.55,3336.2311194191848,{"$f":"IF(O48=\"\",0,L48/((1+$Q$28)^B48))","v":3336.2311194191848}]
[null,14,null,"2026-12-10",4,"2026-12-10",30,464,76527.602276313672,446.68200402069294,896.51450274259707,3214.1592956051772,0,0,4557.3558023684673,76080.920272292977,0.44519363928985323,0.44519363928985323,null,4557.3558023684673,464,1.3158096634552612,3463.54,3214.1592956051772,3214.1592956051772]
[null,15,null,"2027-01-10",7,"2027-01-11",32,496,76080.920272292977,193.14955696802065,951.0703379601199,3413.1359074403267,0,0,4557.3558023684673,75887.77071532495,0.42102796922107433,0.42102796922107433,null,4557.3558023684673,496,1.3409521576461434,3398.6,3413.1359074403267,3413.1359074403267]
[null,16,null,"2027-02-10",3,"2027-02-10",30,526,75887.77071532495,481.05050316190261,889.01892916291411,3187.2863700436505,0,0,4557.3558023684673,75406.720212163054,0.39956534966003354,0.39956534966003354,null,4557.3558023684673,526,1.3649593946561793,3338.82,3187.2863700436505,3187.2863700436505]
[null,17,null,"2027-03-10",3,"2027-03-10",28,554,75406.720212163054,781.31959626127525,824.1706031175778,2951.8656029896142,0,0,4557.3558023684673,74625.400615901774,0.38052182078031471,0.38052182078031471,null,4557.3558023684673,554,1.3877537749299844,3283.98,2951.8656029896142,2951.8656029896142]
[null,18,null,"2027-04-10",6,"2027-04-10",31,585,74625.400615901774,412.82925882470772,903.54710061530159,3240.979442928458,0,0,4557.3558023684673,74212.57135707706,0.36049479651285432,0.36049479651285432,null,4557.3558023684673,585,1.4134346950564742,3224.31,3240.979442928458,3240.979442928458]
[null,19,null,"2027-05-10",1,"2027-05-10",30,615,74212.57135707706,571.03369751437947,869.39410785684834,3116.9279969972395,0,0,4557.3558023684673,73641.537659562688,0.3421179587801868,0.3421179587801868,null,4557.3558023684673,615,1.4387395961515235,3167.6,3116.9279969972395,3116.9279969972395]
[null,20,null,"2027-06-10",4,"2027-06-10",31,646,73641.537659562688,467.47078977935519,891.6347153648893,3198.2502972242228,0,0,4557.3558023684673,73174.066869783332,0.32411214600242122,0.32411214600242122,null,4557.3558023684673,646,1.4653640286114171,3110.05,3198.2502972242228,3198.2502972242228]
[null,21,null,"2027-07-10",6,"2027-07-10",30,676,73174.066869783332,626.81687977025717,857.22811406730739,3073.3108085309027,0,0,4557.3558023684673,72547.249990013079,0.30758997599639509,0.30758997599639509,null,4557.3558023684673,676,1.4915986271690627,3055.35,3073.3108085309027,3073.3108085309027]
[null,22,null,"2027-08-10",2,"2027-08-10",31,707,72547.249990013079,528.24506040691642,878.38533321215971,3150.7254087493911,0,0,4557.3558023684673,72019.004929606162,0.29140138554690348,0.29140138554690348,null,4557.3558023684673,707,1.519201236433839,2999.84,3150.7254087493911,3150.7254087493911]
[null,23,null,"2027-09-10",5,"2027-09-10",31,738,72019.004929606162,557.58260039039794,871.98946412729322,3127.7837378507761,0,0,4557.3558023684673,71461.422329215769,0.27606480745539724,0.27606480745539724,null,4557.3558023684673,738,1.5473146426545432,2945.33,3127.7837378507761,3127.7837378507761]
[null,24,null,"2027-10-10",7,"2027-10-11",31,769,71461.422329215769,588.54948121734913,865.23838288982881,3103.5679382612893,0,0,4557.3558023684673,70872.872847998427,0.26153539995134523,0.26153539995134523,null,4557.3558023684673,769,1.5759482983263242,2891.82,3103.5679382612893,3103.5679382612893]
[null,25,null,"2027-11-10",3,"2027-11-10",30,799,70872.872847998427,750.42532546689654,830.26981728563396,2976.6606596159368,0,0,4557.3558023684673,70122.447522531525,0.24820318641388073,0.24820318641388073,null,4557.3558023684673,799,1.6041627011279094,2840.96,2976.6606596159368,2976.6606596159368]
[null,26,null,"2027-12-10",5,"2027-12-10",30,829,70122.447522531525,790.73435947890528,821.47864694323528,2945.1427959463267,0,0,4557.3558023684673,69331.713163052627,0.23555060522385998,0.23555060522385998,null,4557.3558023684673,829,1.632882229970936,2790.99,2945.1427959463267,2945.1427959463267]
[null,27,null,"2028-01-10",1,"2028-01-10",31,860,69331.713163052627,706.82872791275304,839.45235659906348,3011.0747178566508,0,0,4557.3558023684673,68624.884435139873,0.22315347730788501,0.22315347730788501,null,4557.3558023684673,860,1.6630993469274107,2740.28,3011.0747178566508,3011.0747178566508]
[null,28,null,"2028-02-10",4,"2028-02-10",31,891,68624.884435139873,746.08440225950415,830.89423774856198,2980.3771623604011,0,0,4557.3558023684673,67878.800032880376,0.21140881547417295,0.21140881547417295,null,4557.3558023684673,891,1.6938756433154463,2690.49,2980.3771623604011,2980.3771623604011]
[null,29,null,"2028-03-10",5,"2028-03-10",29,920,67878.800032880376,1034.8397733935744,768.53853633333301,2753.9774926415598,0,0,4557.3558023684673,66843.960259486805,0.20098211044263972,0.20098211044263972,null,4557.3558023684673,920,1.7231817650097307,2644.73,2753.9774926415598,2753.9774926415598]
[null,30,null,"2028-04-10",1,"2028-04-10",31,951,66843.960259486805,844.99291674807,809.3312194994628,2903.0316661209345,0,0,4557.3558023684673,65998.967342738732,0.19040433701848711,0.19040433701848711,null,4557.3558023684673,951,1.7550699097729268,2596.6799999999998,2903.0316661209345,2903.0316661209345]
[null,31,null,"2028-05-10",3,"2028-05-10",30,981,65998.967342738732,1012.2267547571373,773.17241921630057,2771.9566283950294,0,0,4557.3558023684673,64986.740587981592,0.18069815085759999,0.18069815085759999,null,4557.3558023684673,981,1.7864911495635112,2551.0100000000002,2771.9566283950294,2771.9566283950294]
[null,32,null,"2028-06-10",6,"2028-06-10",31,1012,64986.740587981592,948.13871110518301,786.84443302267903,2822.3726582406052,0,0,4557.3558023684673,64038.601876876412,0.17118793080007635,0.17118793080007635,null,4557.3558023684673,1012,1.8195508589640035,2504.66,2822.3726582406052,2822.3726582406052]
[null,33,null,"2028-07-10",1,"2028-07-10",30,1042,64038.601876876412,1117.5276228884818,750.2069006511739,2689.6212788288117,0,0,4557.3558023684673,62921.074253987928,0.16246133375475127,0.16246133375475127,null,4557.3558023684673,1042,1.8521265093881334,2460.61,2689.6212788288117,2689.6212788288117]
[null,34,null,"2028-08-10",4,"2028-08-10",31,1073,62921.074253987928,1062.8611632553047,761.83382253999434,2732.6608165731682,0,0,4557.3558023684673,61858.213090732621,0.15391092508972812,0.15391092508972812,null,4557.3558023684673,1073,1.886400826497558,2415.9,2732.6608165731682,2732.6608165731682]
[null,35,null,"2028-09-10",7,"2028-09-11",32,1105,61858.213090732621,1009.002300154046,773.27549955040899,2775.0780026640123,0,0,4557.3558023684673,60849.210790578574,0.14555644670672194,0.14555644670672194,null,4557.3558023684673,1105,1.9224461779941753,2370.6,2775.0780026640123,2775.0780026640123]
[null,36,null,"2028-10-10",2,"2028-10-10",29,1134,60849.210790578574,1399.6346838976342,688.94799812867711,2468.7731203421558,0,0,4557.3558023684673,59449.576106680943,0.13837758743425002,0.13837758743425002,null,4557.3558023684673,1134,1.9557068496765047,2330.29,2468.7731203421558,2468.7731203421558]
[null,37,null,"2028-11-10",5,"2028-11-10",31,1165,59449.576106680943,1255.6603455529062,719.80172542690718,2581.893731388654,0,0,4557.3558023684673,58193.915761128039,0.13109471651784521,0.13109471651784521,null,4557.3558023684673,1165,1.9918979610283045,2287.9499999999998,2581.893731388654,2581.893731388654]
[null,38,null,"2028-12-10",7,"2028-12-11",31,1196,58193.915761128039,1325.3968908694937,704.59848021524692,2527.3604312837265,0,0,4557.3558023684673,56868.518870258544,0.12419514617611054,0.12419514617611054,null,4557.3558023684673,1196,2.0287588028875652,2246.38,2527.3604312837265,2527.3604312837265]
[null,39,null,"2029-01-10",3,"2029-01-10",30,1226,56868.518870258544,1502.6680358974131,666.20997392019308,2388.4777925508611,0,0,4557.3558023684673,55365.850834361132,0.11786408655877169,0.11786408655877169,null,4557.3558023684673,1226,2.0650799297371711,2206.87,2388.4777925508611,2388.4777925508611]
[null,40,null,"2029-02-10",6,"2029-02-10",31,1257,55365.850834361132,1482.4612424054903,670.35692380358785,2404.537636159389,0,0,4557.3558023684673,53883.389591955638,0.1116608498641346,0.1116608498641346,null,4557.3558023684673,1257,2.1032950322203718,2166.77,2404.537636159389,2404.537636159389]
[null,41,null,"2029-03-10",6,"2029-03-10",28,1285,53883.389591955638,1859.1131333525425,588.92769202894374,2109.314976986981,0,0,4557.3558023684673,52024.276458603097,0.10633902548439091,0.10633902548439091,null,4557.3558023684673,1285,2.1384193787614736,2131.1799999999998,2109.314976986981,2109.314976986981]
[null,42,null,"2029-04-10",2,"2029-04-10",31,1316,52024.276458603097,1668.0447512812036,629.89791368387273,2259.4131374033909,0,0,4557.3558023684673,50356.231707321895,0.10074235762553635,0.10074235762553635,null,4557.3558023684673,1316,2.1779916561027348,2092.46,2259.4131374033909,2259.4131374033909]
[null,43,null,"2029-05-10",4,"2029-05-10",30,1346,50356.231707321895,1852.4749998127836,589.91907084816251,2114.9617317075213,0,0,4557.3558023684673,48503.756707509114,9.5606843946007186E-2,9.5606843946007186E-2,null,4557.3558023684673,1346,2.2169845177017069,2055.66,2114.9617317075213,2114.9617317075213]
[null,44,null,"2029-06-10",7,"2029-06-11",32,1378,48503.756707509114,1775.04984194248,606.33446755172668,2175.9714928742605,0,0,4557.3558023684673,46728.706865566637,9.0417184339005918E-2,9.0417184339005918E-2,null,4557.3558023684673,1378,2.2593466631591426,2017.11,2175.9714928742605,2175.9714928742605]
[null,45,null,"2029-07-10",2,"2029-07-10",29,1407,46728.706865566637,2132.4069395792844,529.07258174593323,1895.8762810432495,0,0,4557.3558023684673,44596.299925987354,8.5957799290326375E-2,8.5957799290326375E-2,null,4557.3558023684673,1407,2.2984361255535122,1982.81,1895.8762810432495,1895.8762810432495]
[null,46,null,"2029-08-10",5,"2029-08-10",31,1438,44596.299925987354,2080.577825143002,539.96169084162898,1936.8162863838365,0,0,4557.3558023684673,42515.722100844352,8.1433803980846556E-2,8.1433803980846556E-2,null,4557.3558023684673,1438,2.3409695746584562,1946.78,1936.8162863838365,1936.8162863838365]
[null,47,null,"2029-09-10",1,"2029-09-10",31,1469,42515.722100844352,2196.1284279008546,514.77053547097546,1846.4568389966369,0,0,4557.3558023684673,40319.593672943498,7.714790845671686E-2,7.714790845671686E-2,null,4557.3558023684673,1469,2.3842901216830032,1911.41,1846.4568389966369,1846.4568389966369]
[null,48,null,"2029-10-10",3,"2029-10-10",30,1499,40319.593672943498,2391.5921779840601,472.34069012077907,1693.4229342636283,0,0,4557.3558023684673,37928.001494959441,7.3215162106872636E-2,7.3215162106872636E-2,null,4557.3558023684673,1499,2.426976370946667,1877.79,1693.4229342636283,1693.4229342636283]
[null,49,null,"2029-11-10",6,"2029-11-10",31,1530,37928.001494959441,2450.9200895673389,459.22347484994219,1647.2122379511861,0,0,4557.3558023684673,35477.081405392099,6.9361817178443627E-2,6.9361817178443627E-2,null,4557.3558023684673,1530,2.4718885069877343,1843.67,1647.2122379511861,1647.2122379511861]
[null,50,null,"2029-12-10",1,"2029-12-10",30,1560,35477.081405392099,2651.7073221189544,415.61106122304363,1490.0374190264695,0,0,4557.3558023684673,32825.374083273142,6.5825980124868441E-2,6.5825980124868441E-2,null,4557.3558023684673,1560,2.5161430412835788,1811.25,1490.0374190264695,1490.0374190264695]
[null,51,null,"2030-01-10",4,"2030-01-10",31,1591,32825.374083273142,2734.3085146211201,397.4420416476006,1425.6052460997466,0,0,4557.3558023684673,30091.065568652022,6.2361530967427865E-2,6.2361530967427865E-2,null,4557.3558023684673,1591,2.5627052410320807,1778.34,1425.6052460997466,1425.6052460997466]
[null,52,null,"2030-02-10",7,"2030-02-11",32,1623,30091.065568652022,2831.2513360257972,376.16158949618182,1349.9428768464882,0,0,4557.3558023684673,27259.814232626224,5.8976468717332142E-2,5.8976468717332142E-2,null,4557.3558023684673,1623,2.6116734188963435,1744.99,1349.9428768464882,1349.9428768464882]
[null,53,null,"2030-03-10",7,"2030-03-11",28,1651,27259.814232626224,3192.3044485297205,297.94078662703618,1067.1105672117105,0,0,4557.3558023684673,24067.509784096503,5.6165614157000672E-2,5.6165614157000672E-2,null,4557.3558023684673,1651,2.6552875200149391,1716.33,1067.1105672117105,1067.1105672117105]
[null,54,null,"2030-04-10",3,"2030-04-10",30,1681,24067.509784096503,3264.5715138479645,281.94887758844891,1010.8354109320541,0,0,4557.3558023684673,20802.938270248538,5.3302476082601295E-2,5.3302476082601295E-2,null,4557.3558023684673,1681,2.7028254701642469,1686.15,1010.8354109320541,1010.8354109320541]
[null,55,null,"2030-05-10",5,"2030-05-10",30,1711,20802.938270248538,3439.9277014932277,243.70469352480001,873.7234073504394,0,0,4557.3558023684673,17363.010568755311,5.0585291359840842E-2,5.0585291359840842E-2,null,4557.3558023684673,1711,2.7512144982805786,1656.49,873.7234073504394,873.7234073504394]
[null,56,null,"2030-06-10",1,"2030-06-10",31,1742,17363.010568755311,3593.0533318407161,210.22731841802286,754.07515210972804,0,0,4557.3558023684673,13769.957236914595,4.7922966094071248E-2,4.7922966094071248E-2,null,4557.3558023684673,1742,2.8021267862221113,1626.39,754.07515210972804,754.07515210972804]
[null,57,null,"2030-07-10",3,"2030-07-10",30,1772,13769.957236914595,3817.7036933976656,161.31390502038829,578.33820395041357,0,0,4557.3558023684673,9952.2535435169302,4.5480011077527825E-2,4.5480011077527825E-2,null,4557.3558023684673,1772,2.8522936184281833,1597.79,578.33820395041357,578.33820395041357]
[null,58,null,"2030-08-10",6,"2030-08-10",31,1803,9952.2535435169302,4004.6300730757789,120.49958539072723,432.22614390196134,0,0,4557.3558023684673,5947.6234704411509,4.3086378870927332E-2,4.3086378870927332E-2,null,4557.3558023684673,1803,2.9050764145663868,1568.76,432.22614390196134,432.22614390196134]
[null,59,null,"2030-09-10",2,"2030-09-10",31,1834,5947.6234704411509,4227.0382008439992,72.012450156595804,258.30515136787182,0,0,4557.3558023684673,1720.5852695971516,4.0818724539105913E-2,4.0818724539105913E-2,null,4557.3558023684673,1834,2.9588359767535573,1540.25,258.30515136787182,258.30515136787182]
[null,60,null,"2030-10-10",4,"2030-10-10",30,1864,1720.5852695971516,1720.5852695971516,20.156513486854159,72.264581323080435,0,0,1813.0063644070863,0,3.8737920365049396E-2,3.8737920365049396E-2,null,1813.0063644070863,1864,3.0118083935267501,601.97,72.264581323080435,72.264581323080435]
[null,61,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,62,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,63,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,64,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,65,null,"",{"$f":"IF(B100<=$D$18,WEEKDAY(D100,2),\"\")","v":""},"","","","",{"$f":"IF(B100>D$18,\"\",O100-N100-M100-L100-K100)","v":""},{"$f":"IF(B100>D$18,\"\",((1+D$23)^(G100/360)-1)*I100)","v":""},"",{"$f":"IF(B100>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B100>D$18,\"\",D$27)","v":""},{"$f":"IF(B100>D$18,\"\",IF(B100=D$18,I100+K100+L100+M100+N100,IF(AND(D$21=2,MONTH(F100)=7),2*D$28,IF(AND(D$22=2,MONTH(F100)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B100>D$18,\"\",I100-J100)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F100)=7,D$21=2),2/(1+D$24)^(H100/360),IF(AND(MONTH(F100)=12,D$22=2),2/(1+D$24)^(H100/360),1/(1+D$24)^(H100/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H100/360),\"\")","v":""},null,"",{"$f":"H100","v":""},{"$f":"IFERROR((1+D$30)^(U100/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T100/V100,2),\"\")","v":""},0,0]
[null,66,null,{"$f":"IF(B101>$D$18,\"\",EDATE(D100,1))","v":""},"",{"$f":"IF(E101=7,D101+1,D101)","v":""},{"$f":"IF(B101>D$18,\"\",F101-F100)","v":""},{"$f":"IFERROR(G101+H100,\"\")","v":""},{"$f":"IF(B101>D$18,\"\",P100)","v":""},"","",{"$f":"IF(B101>D$18,\"\",((1+D$13)^(G101/30)-1)*I101)","v":""},"","","","","","",null,{"$f":"IFERROR(J101+K101+L101+M101+N101,\"\")","v":""},"","","",{"$f":"IF(O101=\"\",0,L101/((1+$I$9)^B101))","v":0},0]
[null,67,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O102=\"\",0,L102/((1+$Q$28)^B102))","v":0}]
[null,68,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,69,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,70,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,71,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,72,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,73,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,74,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,75,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,76,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,77,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,78,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,79,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,80,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,81,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,82,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,83,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,84,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,85,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,86,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,87,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,88,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,89,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,90,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,91,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,92,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,93,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,94,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,95,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,96,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,97,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,98,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,99,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,100,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,101,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,102,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,103,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,104,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,105,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,106,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,107,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,108,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,109,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,110,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,111,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,112,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,113,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,114,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,115,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,116,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,117,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,118,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,119,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,120,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,121,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,122,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,123,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,124,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,125,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,126,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,127,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,128,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,129,null,"",{"$f":"IF(B164<=$D$18,WEEKDAY(D164,2),\"\")","v":""},"","","","",{"$f":"IF(B164>D$18,\"\",O164-N164-M164-L164-K164)","v":""},{"$f":"IF(B164>D$18,\"\",((1+D$23)^(G164/360)-1)*I164)","v":""},"",{"$f":"IF(B164>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B164>D$18,\"\",D$27)","v":""},{"$f":"IF(B164>D$18,\"\",IF(B164=D$18,I164+K164+L164+M164+N164,IF(AND(D$21=2,MONTH(F164)=7),2*D$28,IF(AND(D$22=2,MONTH(F164)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B164>D$18,\"\",I164-J164)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F164)=7,D$21=2),2/(1+D$24)^(H164/360),IF(AND(MONTH(F164)=12,D$22=2),2/(1+D$24)^(H164/360),1/(1+D$24)^(H164/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H164/360),\"\")","v":""},null,"",{"$f":"H164","v":""},{"$f":"IFERROR((1+D$30)^(U164/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T164/V164,2),\"\")","v":""},0,0]
[null,130,null,{"$f":"IF(B165>$D$18,\"\",EDATE(D164,1))","v":""},"",{"$f":"IF(E165=7,D165+1,D165)","v":""},{"$f":"IF(B165>D$18,\"\",F165-F164)","v":""},{"$f":"IFERROR(G165+H164,\"\")","v":""},{"$f":"IF(B165>D$18,\"\",P164)","v":""},"","",{"$f":"IF(B165>D$18,\"\",((1+D$13)^(G165/30)-1)*I165)","v":""},"","","","","","",null,{"$f":"IFERROR(J165+K165+L165+M165+N165,\"\")","v":""},"","","",{"$f":"IF(O165=\"\",0,L165/((1+$I$9)^B165))","v":0},0]
[null,131,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O166=\"\",0,L166/((1+$Q$28)^B166))","v":0}]
[null,132,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,133,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,134,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,135,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,136,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,137,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,138,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,139,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,140,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,141,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,142,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,143,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,144,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,145,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,146,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,147,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,148,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,149,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,150,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,151,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,152,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,153,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,154,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,155,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,156,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,157,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,158,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,159,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,160,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,161,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,162,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,163,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,164,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,165,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,166,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,167,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,168,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,169,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,170,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,171,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,172,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,173,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,174,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,175,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,176,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,177,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,178,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,179,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,180,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,181,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,182,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,183,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,184,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,185,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,186,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,187,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,188,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,189,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,190,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,191,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,192,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,193,null,"",{"$f":"IF(B228<=$D$18,WEEKDAY(D228,2),\"\")","v":""},"","","","",{"$f":"IF(B228>D$18,\"\",O228-N228-M228-L228-K228)","v":""},{"$f":"IF(B228>D$18,\"\",((1+D$23)^(G228/360)-1)*I228)","v":""},"",{"$f":"IF(B228>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B228>D$18,\"\",D$27)","v":""},{"$f":"IF(B228>D$18,\"\",IF(B228=D$18,I228+K228+L228+M228+N228,IF(AND(D$21=2,MONTH(F228)=7),2*D$28,IF(AND(D$22=2,MONTH(F228)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B228>D$18,\"\",I228-J228)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F228)=7,D$21=2),2/(1+D$24)^(H228/360),IF(AND(MONTH(F228)=12,D$22=2),2/(1+D$24)^(H228/360),1/(1+D$24)^(H228/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H228/360),\"\")","v":""},null,"",{"$f":"H228","v":""},{"$f":"IFERROR((1+D$30)^(U228/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T228/V228,2),\"\")","v":""},0,0]
[null,194,null,{"$f":"IF(B229>$D$18,\"\",EDATE(D228,1))","v":""},"",{"$f":"IF(E229=7,D229+1,D229)","v":""},{"$f":"IF(B229>D$18,\"\",F229-F228)","v":""},{"$f":"IFERROR(G229+H228,\"\")","v":""},{"$f":"IF(B229>D$18,\"\",P228)","v":""},"","",{"$f":"IF(B229>D$18,\"\",((1+D$13)^(G229/30)-1)*I229)","v":""},"","","","","","",null,{"$f":"IFERROR(J229+K229+L229+M229+N229,\"\")","v":""},"","","",{"$f":"IF(O229=\"\",0,L229/((1+$I$9)^B229))","v":0},0]
[null,195,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O230=\"\",0,L230/((1+$Q$28)^B230))","v":0}]
[null,196,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,197,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,198,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,199,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,200,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,201,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,202,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,203,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,204,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,205,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,206,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,207,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,208,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,209,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,210,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,211,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,212,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,213,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,214,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,215,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,216,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,217,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,218,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,219,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,220,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,221,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,222,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,223,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,224,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,225,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,226,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,227,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,228,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,229,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,230,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,231,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,232,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,233,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,234,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,235,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,236,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,237,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,238,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,239,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,240,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,241,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,242,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,243,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,244,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,245,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,246,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,247,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,248,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,249,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,250,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,251,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,252,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,253,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,254,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,255,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,256,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,257,null,"",{"$f":"IF(B292<=$D$18,WEEKDAY(D292,2),\"\")","v":""},"","","","",{"$f":"IF(B292>D$18,\"\",O292-N292-M292-L292-K292)","v":""},{"$f":"IF(B292>D$18,\"\",((1+D$23)^(G292/360)-1)*I292)","v":""},"",{"$f":"IF(B292>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B292>D$18,\"\",D$27)","v":""},{"$f":"IF(B292>D$18,\"\",IF(B292=D$18,I292+K292+L292+M292+N292,IF(AND(D$21=2,MONTH(F292)=7),2*D$28,IF(AND(D$22=2,MONTH(F292)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B292>D$18,\"\",I292-J292)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F292)=7,D$21=2),2/(1+D$24)^(H292/360),IF(AND(MONTH(F292)=12,D$22=2),2/(1+D$24)^(H292/360),1/(1+D$24)^(H292/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H292/360),\"\")","v":""},null,"",{"$f":"H292","v":""},{"$f":"IFERROR((1+D$30)^(U292/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T292/V292,2),\"\")","v":""},0,0]
[null,258,null,{"$f":"IF(B293>$D$18,\"\",EDATE(D292,1))","v":""},"",{"$f":"IF(E293=7,D293+1,D293)","v":""},{"$f":"IF(B293>D$18,\"\",F293-F292)","v":""},{"$f":"IFERROR(G293+H292,\"\")","v":""},{"$f":"IF(B293>D$18,\"\",P292)","v":""},"","",{"$f":"IF(B293>D$18,\"\",((1+D$13)^(G293/30)-1)*I293)","v":""},"","","","","","",null,{"$f":"IFERROR(J293+K293+L293+M293+N293,\"\")","v":""},"","","",{"$f":"IF(O293=\"\",0,L293/((1+$I$9)^B293))","v":0},0]
[null,259,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O294=\"\",0,L294/((1+$Q$28)^B294))","v":0}]
[null,260,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,261,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,262,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,263,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,264,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,265,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,266,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,267,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,268,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,269,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,270,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,271,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,272,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,273,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,274,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,275,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,276,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,277,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,278,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,279,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,280,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,281,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,282,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,283,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,284,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,285,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,286,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,287,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,288,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,289,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,290,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,291,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,292,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,293,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,294,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,295,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,296,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,297,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,298,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,299,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,300,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,301,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,302,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,303,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,304,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,305,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,306,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,307,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,308,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,309,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,310,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,311,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,312,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,313,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,314,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,315,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,316,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,317,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,318,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,319,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,320,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,321,null,"",{"$f":"IF(B356<=$D$18,WEEKDAY(D356,2),\"\")","v":""},"","","","",{"$f":"IF(B356>D$18,\"\",O356-N356-M356-L356-K356)","v":""},{"$f":"IF(B356>D$18,\"\",((1+D$23)^(G356/360)-1)*I356)","v":""},"",{"$f":"IF(B356>D$18,\"\",D$25*D$26)","v":""},{"$f":"IF(B356>D$18,\"\",D$27)","v":""},{"$f":"IF(B356>D$18,\"\",IF(B356=D$18,I356+K356+L356+M356+N356,IF(AND(D$21=2,MONTH(F356)=7),2*D$28,IF(AND(D$22=2,MONTH(F356)=12),2*D$28,D$28))))","v":""},{"$f":"IF(B356>D$18,\"\",I356-J356)","v":""},{"$f":"IFERROR(IF(AND(MONTH(F356)=7,D$21=2),2/(1+D$24)^(H356/360),IF(AND(MONTH(F356)=12,D$22=2),2/(1+D$24)^(H356/360),1/(1+D$24)^(H356/360))),\"\")","v":""},{"$f":"IFERROR(1/(1+D$24)^(H356/360),\"\")","v":""},null,"",{"$f":"H356","v":""},{"$f":"IFERROR((1+D$30)^(U356/360),\"\")","v":""},{"$f":"IFERROR(ROUND(T356/V356,2),\"\")","v":""},0,0]
[null,322,null,{"$f":"IF(B357>$D$18,\"\",EDATE(D356,1))","v":""},"",{"$f":"IF(E357=7,D357+1,D357)","v":""},{"$f":"IF(B357>D$18,\"\",F357-F356)","v":""},{"$f":"IFERROR(G357+H356,\"\")","v":""},{"$f":"IF(B357>D$18,\"\",P356)","v":""},"","",{"$f":"IF(B357>D$18,\"\",((1+D$13)^(G357/30)-1)*I357)","v":""},"","","","","","",null,{"$f":"IFERROR(J357+K357+L357+M357+N357,\"\")","v":""},"","","",{"$f":"IF(O357=\"\",0,L357/((1+$I$9)^B357))","v":0},0]
[null,323,null,"","","","","","","","","","","","","","","",null,"","","","",0,{"$f":"IF(O358=\"\",0,L358/((1+$Q$28)^B358))","v":0}]
[null,324,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,325,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,326,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,327,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,328,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,329,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,330,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,331,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,332,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,333,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,334,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,335,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,336,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,337,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,338,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,339,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,340,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,341,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,342,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,343,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,344,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,345,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,346,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,347,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,348,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,349,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,350,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,351,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,352,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,353,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,354,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,355,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,356,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,357,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,358,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,359,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]
[null,360,null,"","","","","","","","","","","","","","","",null,"","","","",0,0]

{"sheet":"TarifarioBD","index":3,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
["TARIFA","PRODUCTO","TIPO_SEGURO","Valor","<","Columna2",null,"TARIFA","PRODUCTO","TIPO_SEGURO"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Vida",4.2000000000000003E-2,"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR",4.2000000000000003E-2,null,"TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen",1.8320000000000001E-3,"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR",1.8320000000000001E-3,null,"TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen"]
["TARIFA TITULAR","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",2.3419999999999999E-3,"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",2.3419999999999999E-3,null,null,null,"Seguro de Desgravamen con Devolución"]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Vida",8.4000000000000005E-2,"Préstamos Personales (DXP)Seguro de VidaTARIFA TITULAR + CONYUGE",8.4000000000000005E-2,null,null,null,"Exonerado"]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen",3.6640000000000002E-3,"Préstamos Personales (DXP)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",3.6640000000000002E-3,null,null,null,"Sin Seguro"]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Seguro de Desgravamen con Devolución",4.6839999999999998E-3,"Préstamos Personales (DXP)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",4.6839999999999998E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",3.6999999999999998E-2,"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR",3.6999999999999998E-2]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",1.9949999999999998E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR",1.9949999999999998E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",2.594E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",2.594E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Vida",7.3999999999999996E-2,"Préstamos Personales (LD Y PA) (Clientes)Seguro de VidaTARIFA TITULAR + CONYUGE",7.3999999999999996E-2]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen",3.9899999999999996E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",3.9899999999999996E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Seguro de Desgravamen con Devolución",5.1879999999999999E-3,"Préstamos Personales (LD Y PA) (Clientes)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",5.1879999999999999E-3]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",1.5866000000000002E-2,"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR",1.5866000000000002E-2]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",8.5499999999999997E-4,"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR",8.5499999999999997E-4]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",1.1119999999999999E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR",1.1119999999999999E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Vida",3.1732000000000003E-2,"Préstamos Personales (LD Y PA) (Empleados)Seguro de VidaTARIFA TITULAR + CONYUGE",3.1732000000000003E-2]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen",1.7099999999999999E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de DesgravamenTARIFA TITULAR + CONYUGE",1.7099999999999999E-3]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Seguro de Desgravamen con Devolución",2.2239999999999998E-3,"Préstamos Personales (LD Y PA) (Empleados)Seguro de Desgravamen con DevoluciónTARIFA TITULAR + CONYUGE",2.2239999999999998E-3]
["TARIFA TITULAR","Préstamos Personales (DXP)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (DXP)ExoneradoTARIFA TITULAR"},0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (DXP)ExoneradoTARIFA TITULAR + CONYUGE"},0]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (LD Y PA) (Clientes)ExoneradoTARIFA TITULAR"},0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (LD Y PA) (Clientes)ExoneradoTARIFA TITULAR + CONYUGE"},0]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (LD Y PA) (Empleados)ExoneradoTARIFA TITULAR"},0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Exonerado",0,{"$f":"_xlfn.CONCAT(TarifarioPrincipal[[#This Row],[PRODUCTO]],TarifarioPrincipal[[#This Row],[TIPO_SEGURO]],TarifarioPrincipal[[#This Row],[TARIFA]])","v":"Préstamos Personales (LD Y PA) (Empleados)ExoneradoTARIFA TITULAR + CONYUGE"},0]
["TARIFA TITULAR","Préstamos Personales (DXP)","Sin Seguro",0,{"$f":"CONCATENATE(B26,C26,A26)","v":"Préstamos Personales (DXP)Sin SeguroTARIFA TITULAR"},0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (DXP)","Sin Seguro",0,{"$f":"CONCATENATE(B27,C27,A27)","v":"Préstamos Personales (DXP)Sin SeguroTARIFA TITULAR + CONYUGE"},0]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Clientes)","Sin Seguro",0,"Préstamos Personales (LD Y PA) (Clientes)Sin SeguroTARIFA TITULAR",0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Clientes)","Sin Seguro",0,"Préstamos Personales (LD Y PA) (Clientes)Sin SeguroTARIFA TITULAR + CONYUGE",0]
["TARIFA TITULAR","Préstamos Personales (LD Y PA) (Empleados)","Sin Seguro",0,"Préstamos Personales (LD Y PA) (Empleados)Sin SeguroTARIFA TITULAR",0]
["TARIFA TITULAR + CONYUGE","Préstamos Personales (LD Y PA) (Empleados)","Sin Seguro",0,"Préstamos Personales (LD Y PA) (Empleados)Sin SeguroTARIFA TITULAR + CONYUGE",0]

{"sheet":"CostoCapBD","index":4,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["TARIFA","CostoCapital"]
["TARIFA TITULAR",2.8709999999999999E-3]
["TARIFA TITULAR + CONYUGE",2.8709999999999999E-3]