{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Cuota Máxima 30-365","Resumen","Simulador de TNA máxima 30-365"," 12 meses diferencias en CFT"," 24 meses diferencias en CFT"," 36 meses diferencias en CF "," 48 meses diferencias en CF "," 60 meses diferencias en CF "],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":196,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cuota Máxima 30-365","index":0,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Simulador de cuota máxima - Decreto 988/21"]
[null,"SEPTIEMBRE 2024"]
[]
[null,"Días desde el desembolso a la 1º cuota",45]
[null,"Monto del préstamo ",10000]
[null,"Cantidad de cuotas",1]
[null,"Gastos a cargo del deudor en el momento inicial",0]
[null,"CFTEA Máximo",0.75]
[]
[null,"Monto del préstamo inicialmente disponible para el deudor",{"$f":"+C6-C8","v":10000}]
[null,"Cuota Máxima (*)",{"$f":"+C11/C17","v":10714.294883497761}]
[]
[null,"TEM",{"$f":"+C15/(365/30)","v":4.7070032296157249E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C9)^(30/365)-1)*(365/30)","v":0.57268539293657983}]
[null,"ani",{"$f":"+((1+C14)^C7-1)/(C14*(1+C14)^C7)","v":0.95504595600646147}]
[null,"ani difereido",{"$f":"+C16*1/(1+C14)^C19","v":0.93333253459376742}]
[]
[null,"diferimiento",{"$f":"+(C5-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",0.88513116688418114]
[null,"TEM máxima a incluir en el préstamo",{"$f":"+C21/(12.1666666666667)","v":7.2750506867192977E-2}]
[]
[null,"ani objetivo",{"$f":"+C6/C12","v":0.93333253459376742}]
[null,"ani resultante",{"$f":"+(((1+C22)^C7-1)/(C22*(1+C22)^C7))*1/(1+C22)^C19","v":0.90001947583613529}]
[null,"diferencia",{"$f":"+C24-C25","v":3.331305875763213E-2}]
[]
[null,"(*) Se considera para el cálculo que el pago de la primera cuota se efectúa a los 45 días"]
[null,"No se consideran para el cálculo impuestos nacionales, provinciales y municipales a "]
[null,"excepción del IVA en los casos que corresponda"]

{"sheet":"Resumen","index":1,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Diferencias entre CFT que efectivamente van a tener las mutuales y el límite de CFTEA publicado"]
[]
[null,"Plazos de financiación","Diferencias Promedio 30/365","Diferencias Promedio 30/360"]
[null,12,{"$f":"+' 12 meses diferencias en CFT'!E47","v":7.5514057223002154E-2},{"$f":"+'[1] 12 meses diferencias en CFT'!$E$47","v":-2.0914525349934507E-3}]
[null,24,{"$f":"+' 24 meses diferencias en CFT'!E47","v":3.6284143670400039E-2},{"$f":"+'[1] 24 meses diferencias en CFT'!$E$47","v":-1.9684444427489254E-3}]
[null,36,{"$f":"+' 36 meses diferencias en CF '!E47","v":2.3637917582194173E-2},{"$f":"+'[1] 36 meses diferencias en CF '!$E$47","v":-1.6834507942199244E-3}]
[null,48,{"$f":"+' 48 meses diferencias en CF '!E47","v":1.7754786157608171E-2},{"$f":"+'[1] 48 meses diferencias en CF '!$E$47","v":-1.5038679599761462E-3}]
[null,60,{"$f":"+' 60 meses diferencias en CF '!E47","v":1.4552608076731458E-2},{"$f":"+'[1] 60 meses diferencias en CF '!$E$47","v":-1.4279574712116605E-3}]
[]
[]
[null,"Diferencia en cuota 30/365 y 30/360 por cada $100.000 (con costos iniciales de 10.000 pagados por el deudor y dos meses para el cobro primera cuota)"]
[]
[null,"Plazos de financiación","Diferencias Promedio 30/365","Diferencias Promedio 30/360","Diferencia en Cuota"]
[null,12,{"$f":"+' 12 meses diferencias en CFT'!C15","v":10429.526273816678},{"$f":"+'[1] 12 meses diferencias en CFT'!$C$15","v":10739.612859733648},{"$f":"+C16-D16","v":-310.08658591696985}]
[null,24,{"$f":"+' 24 meses diferencias en CFT'!C15","v":6709.692825582877},{"$f":"+'[1] 24 meses diferencias en CFT'!$C$15","v":6929.3478843083849},{"$f":"+C17-D17","v":-219.65505872550784}]
[null,36,{"$f":"+' 36 meses diferencias en CF '!C15","v":5601.9924801824554},{"$f":"+'[1] 36 meses diferencias en CF '!$C$15","v":5798.1930919308061},-196.20061174835064]
[null,48,{"$f":"+' 48 meses diferencias en CF '!C15","v":5132.2614186721185},{"$f":"+'[1] 48 meses diferencias en CF '!$C$15","v":5320.6049836047687},-188.34356493265022]
[null,60,{"$f":"+' 60 meses diferencias en CF '!C15","v":4904.2782842777187},{"$f":"+'[1] 60 meses diferencias en CF '!$C$15","v":5090.0646373999098},-185.78635312219103]

{"sheet":"Simulador de TNA máxima 30-365","index":2,"n_rows":25,"n_cols":6,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[null,"Simulador de TNA máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+'Cuota Máxima 30-365'!C5","v":45}]
[null,"Monto del préstamo ",15000]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C25","v":15000}]
[null,"Cuota",{"$f":"+C9/C14","v":1738.2543789694464}]
[null,"TEM",{"$f":"+C12/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+F15)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C11)^C15-1)/(C11*(1+C11)^C15)","v":8.8440676901573152}]
[null,"ani difereido",{"$f":"+C13*1/(1+C11)^C16","v":8.6293468789608365}]
[null,"cantidad de cuotas",12,null,"CFTEA",0.81859999999999999]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C19*365/30","v":0.61301016594986679}]
[null,"TEM máxima a incluir en el préstamo",5.0384397201358913E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C10","v":8.6293468789608365}]
[null,"ani resultante",{"$f":"+((((1+C19)^C15-1)/(C19*(1+C19)^C15)))*1/(1+C19)^C16","v":8.6293468746782604}]
[null,"diferencia",{"$f":"+C21-C22","v":4.2825760715459182E-9}]
[]
[null,"Gastos a cargo del deudor en el momento inicial",0]

{"sheet":" 12 meses diferencias en CFT","index":3,"n_rows":61,"n_cols":19,"rows_kept":61,"cut":false,"hidden":true,"merged":[[44,5,60,5],[42,7,42,18]]}
[]
[]
[]
[]
[null,"Simulador de cuota máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+'Simulador de TNA máxima 30-365'!C7","v":45}]
[null,"Monto del préstamo ",100000]
[null,"cantidad de cuotas",12]
[null,"Gastos a cargo del deudor en el momento inicial",10000]
[null,"CFTEA",0.81859999999999999]
[]
[]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C10","v":90000}]
[null,"Cuota",{"$f":"+C14/C22","v":10429.526273816678}]
[]
[]
[]
[null,"TEM",{"$f":"+C20/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C11)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C19)^C9-1)/(C19*(1+C19)^C9)","v":8.8440676901573152}]
[null,"ani difereido",{"$f":"+C21*1/(1+C19)^C24","v":8.6293468789608365}]
[]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C27*365/30","v":0.67542765037777952}]
[null,"TEM máxima a incluir en el préstamo",5.551460140091339E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C15","v":9.5881631988453737}]
[null,"ani resultante",{"$f":"+(((1+C27)^C9-1)/(C27*(1+C27)^C9))","v":8.5939095470843618}]
[null,"diferencia",{"$f":"+C29-C30","v":0.99425365176101188}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CFT",{"$f":"+XIRR(C45:C57,B45:B57)","v":0.90201281309127834}]
[null,null,"Diferencia",{"$f":"+D40-C11","v":8.3412813091278348E-2}]
[]
[null,null,null,null,null,null,null,"Fecha inicial"]
[null,"Fechas","Flujo",null,null,null,{"$f":"+D41","v":8.3412813091278348E-2},"2019-01-01",{"$f":"+EDATE(H44,1)","v":"2019-02-01"},{"$f":"+EDATE(I44,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01",{"$f":"+EDATE(N44,1)","v":"2019-08-01"},"2019-09-01",{"$f":"+EDATE(P44,1)","v":"2019-10-01"},"2019-11-01","2019-12-01"]
[0,"2019-01-01",{"$f":"+C14","v":90000},null,null,"CFT límite",0.9,9.4560277462005682E-2,9.9805772304534801E-2,8.0200135707855114E-2,8.3990848064422585E-2,7.9934608936309659E-2,8.370674848556503E-2,7.9637229442596325E-2,8.338853120803813E-2,8.7392795085906916E-2,8.3508455753326216E-2,8.7521159648895286E-2,8.3642971515655584E-2]
[1,{"$f":"+EDATE(B45,C7/30)","v":"2019-02-01"},{"$f":"+C15*-1","v":-10429.526273816678},null,null,null,0.85,8.7656962871551669E-2,9.2488014698028587E-2,7.4335253238677956E-2,7.7847874164581499E-2,7.4098551273345969E-2,7.759524583816535E-2,7.3834693431854226E-2,7.7313625812530762E-2,8.101774454116828E-2,7.742108106613188E-2,8.1132471561431996E-2,7.7541029453277788E-2]
[2,{"$f":"+EDATE(B46,1)","v":"2019-03-01"},{"$f":"+C46","v":-10429.526273816678},null,{"$f":"+AVERAGE(H47:S47)","v":7.5514057223002154E-2},null,0.81859999999999999,8.3412813091278348E-2,8.7990855121612421E-2,7.0729993724822915E-2,7.4071763896942144E-2,7.051055326461797E-2,7.3837946796417198E-2,7.0266698741912936E-2,7.3578070545196494E-2,7.7098106288910007E-2,7.3678015613555914E-2,7.7204631710052762E-2,7.3789237880706793E-2]
[3,"2019-04-01",{"$f":"+C47","v":-10429.526273816678},null,null,null,0.75,7.4388372898101851E-2,7.843326330184941E-2,6.3065421581268266E-2,6.6044270992279053E-2,6.2881433963775546E-2,6.5848934650421187E-2,6.2678372859954923E-2,6.5633332729339688E-2,6.8763029575348078E-2,6.5717732906341642E-2,6.8852651119232444E-2,6.5811002254486217E-2]
[4,"2019-05-01",-10429.526273816678,null,null,null,0.7,6.8028056621551647E-2,7.1701276302337691E-2,5.7664692401885986E-2,6.0388004779815541E-2,5.7504594326019509E-2,6.0218513011932151E-2,5.7328808307647749E-2,6.0032355785369695E-2,6.2887942790984974E-2,6.0106194019317716E-2,6.2966144084930509E-2,6.0187351703643754E-2]
[5,"2019-06-01",-10429.526273816678,null,null,null,0.65,6.1853849887848145E-2,6.5169775485992454E-2,5.2423036098480424E-2,5.4898512363433682E-2,5.2285158634185591E-2,5.4752957820892401E-2,5.2134573459625133E-2,5.4593932628631658E-2,5.7184278964996449E-2,5.4657852649688698E-2,5.7251799106597834E-2,5.4727780818939364E-2]
[6,"2019-07-01",-10429.526273816678,null,null,null,0.6,5.5868548154831221E-2,5.884158015251173E-2,4.7342783212661943E-2,4.9578183889389282E-2,4.7225469350814953E-2,4.9454694986343473E-2,4.7098034620285278E-2,4.932052493095429E-2,5.165458321571359E-2,4.9375218153000278E-2,5.1712173223495528E-2,4.9434703588485895E-2]
[7,"2019-08-01",-10429.526273816678,null,null,null,0.55000000000000004,5.0075012445449985E-2,5.2719599008560381E-2,4.2426377534866222E-2,4.4429582357406683E-2,4.2327970266342274E-2,4.432628750801082E-2,4.222165942192091E-2,4.4214695692062489E-2,4.6301525831222712E-2,4.4260841608047552E-2,4.6349972486496083E-2,4.4310742616653576E-2]
[8,"2019-09-01",-10429.526273816678,null,null,null,0.5,4.4476300477981678E-2,4.680692553520216E-2,3.7676388025283836E-2,3.9455336332321234E-2,3.7595206499099865E-2,3.9370387792587169E-2,3.7508016824722379E-2,3.9279156923293979E-2,4.1127926111221291E-2,3.9317435026168912E-2,4.1167992353439375E-2,3.9358597993850775E-2]
[9,"2019-10-01",-10429.526273816678,null,null,null,0.45,3.9075583219528143E-2,4.1106790304183904E-2,3.3095484972000044E-2,3.46582472324371E-2,3.3029872179031361E-2,3.458980917930593E-2,3.2959824800491255E-2,3.4516733884811301E-2,3.6136728525161754E-2,3.4547871351241988E-2,3.6169201135635431E-2,3.4581130743026767E-2]
[10,"2019-11-01",-10429.526273816678,null,null,null,0.4,3.3876210451126099E-2,3.5622590780258201E-2,2.8686517477035545E-2,3.0041259527206376E-2,2.8634792566299527E-2,2.9987484216690063E-2,2.8579920530319325E-2,2.9930430650711104E-2,3.1331032514572255E-2,2.9955118894577026E-2,3.1356698274612405E-2,2.9981333017349177E-2]
[11,"2019-12-01",-10429.526273816678,null,null,null,0.35,2.8881710767746038E-2,3.0357915163040206E-2,2.4452441930770896E-2,2.5607436895370483E-2,2.4412947893142745E-2,2.5566524267196744E-2,2.4371320009231479E-2,2.5523382425308272E-2,2.6714116334915161E-2,2.5542348623275757E-2,2.6733773946762129E-2,2.5562351942062467E-2]
[12,"2020-01-01",-10429.526273816678,null,null,null,0.29999999999999899,2.4095803499222856E-2,2.5316542387009699E-2,2.0396393537522484E-2,2.1360057592392956E-2,2.0367473363877397E-2,2.1330195665360596E-2,2.0337182283402588E-2,2.1298927068711337E-2,2.228943705558889E-2,2.1312898397446822E-2,2.2303861379624534E-2,2.1327549219132658E-2]
[null,null,null,null,null,null,0.249999999999999,1.9522434473038808E-2,2.0502465963364691E-2,1.6521710157395342E-2,1.7302578687668824E-2,1.6501694917679721E-2,1.7281979322434471E-2,1.6480880975724199E-2,1.7260569334031195E-2,1.8060630559922242E-2,1.7270296812058605E-2,1.8070656061173529E-2,1.7280429601670311E-2]
[null,null,null,null,null,null,0.19999999999999901,1.5165799856186907E-2,1.5919929742814115E-2,1.2831908464432829E-2,1.3438624143601419E-2,1.2819141149521901E-2,1.3425546884537731E-2,1.2805968523026512E-2,1.3412052392960588E-2,1.4031606912613931E-2,1.3418298959733094E-2,1.4038008451462775E-2,1.3424748182297747E-2]
[null,null,null,null,null,null,0.149999999999999,1.1030322313309776E-2,1.1573439836503135E-2,9.3307077884684508E-3,9.7721159458170892E-3,9.3235671520243424E-3,9.7648203372965869E-3,9.3162357807170249E-3,9.7573459148417307E-3,1.0206466913224355E-2,9.7608625888835343E-3,1.0210067033768755E-2,9.764474630356873E-3]
[null,null,null,null,null,null,9.9999999999999006E-2,7.1207582950602033E-3,7.4678122997293706E-3,6.0221135616312649E-3,6.3071668148050875E-3,6.018942594529203E-3,6.3039481639872164E-3,6.0157358646402981E-3,6.3006818294535083E-3,6.5896213054666974E-3,6.3022553920755731E-3,6.5912187099466946E-3,6.3038527965555702E-3]

{"sheet":" 24 meses diferencias en CFT","index":4,"n_rows":69,"n_cols":19,"rows_kept":69,"cut":false,"hidden":true,"merged":[[42,7,42,18],[44,5,60,5]]}
[]
[]
[]
[]
[null,"Simulador de cuota máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+' 12 meses diferencias en CFT'!C7","v":45}]
[null,"Monto del préstamo ",100000]
[null,"cantidad de cuotas",24]
[null,"Gastos a cargo del deudor en el momento inicial",10000]
[null,"CFTEA",0.81859999999999999]
[]
[]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C10","v":90000}]
[null,"Cuota",{"$f":"+C14/C22","v":6709.692825582877}]
[]
[]
[]
[null,"TEM",{"$f":"+C20/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C11)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C19)^C9-1)/(C19*(1+C19)^C9)","v":13.747192120362973}]
[null,"ani difereido",{"$f":"+C21*1/(1+C19)^C24","v":13.413430739607907}]
[]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C27*365/30","v":0.67542765037777952}]
[null,"TEM máxima a incluir en el préstamo",5.551460140091339E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C15","v":14.903811932897675}]
[null,"ani resultante",{"$f":"+(((1+C27)^C9-1)/(C27*(1+C27)^C9))","v":13.087772591254382}]
[null,"diferencia",{"$f":"+C29-C30","v":1.8160393416432932}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CFT",{"$f":"+XIRR(C45:C69,B45:B69)","v":0.85892223119735722}]
[null,null,"Diferencia",{"$f":"+D40-C11","v":4.0322231197357228E-2}]
[]
[null,null,null,null,null,null,null,"Fecha inicial"]
[null,"Fechas","Flujo",null,null,null,{"$f":"+D41","v":4.0322231197357228E-2},"2019-01-01",{"$f":"+EDATE(H44,1)","v":"2019-02-01"},{"$f":"+EDATE(I44,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01",{"$f":"+EDATE(N44,1)","v":"2019-08-01"},"2019-09-01",{"$f":"+EDATE(P44,1)","v":"2019-10-01"},"2019-11-01","2019-12-01"]
[0,"2019-01-01",{"$f":"+C14","v":90000},null,null,"CFT límite",0.9,4.6340835094451749E-2,4.904795885086044E-2,3.8302910327911222E-2,4.0504038333892711E-2,3.8348114490509011E-2,4.055155515670783E-2,3.8398563861846813E-2,4.0604627132415971E-2,4.2948091030120872E-2,4.0919721126556508E-2,4.3282830715179466E-2,4.1271960735321023E-2]
[1,{"$f":"+EDATE(B45,C7/30)","v":"2019-02-01"},{"$f":"+C15*-1","v":-6709.692825582877},null,null,null,0.85,4.2601382732391335E-2,4.5081532001495561E-2,3.5182058811187633E-2,3.7214648723602362E-2,3.5233938694000266E-2,3.7269175052642711E-2,3.529158830642698E-2,3.7329828739166016E-2,3.9489734172820978E-2,3.7622463703155584E-2,3.9799845218658647E-2,3.7948048114776589E-2]
[2,{"$f":"+EDATE(B46,1)","v":"2019-03-01"},{"$f":"+C46","v":-6709.692825582877},null,{"$f":"+AVERAGE(H47:S47)","v":3.6284143670400039E-2},null,0.81859999999999999,4.0322231197357228E-2,4.2664622211456393E-2,3.3281349086761614E-2,3.5210846805572515E-2,3.3336829090118592E-2,3.5269163990020891E-2,3.3398317241668751E-2,3.5333775424957414E-2,3.7381600284576377E-2,3.5612582111358648E-2,3.7676571750640875E-2,3.5921834850311196E-2]
[3,"2019-04-01",{"$f":"+C47","v":-6709.692825582877},null,null,null,0.75,3.5529243946075706E-2,3.758348226547259E-2,2.9288113117218018E-2,3.0999815464019642E-2,2.9349911212921187E-2,3.1064641475677668E-2,2.941795587539664E-2,3.1136000156402499E-2,3.2947432994842485E-2,3.138521909713754E-2,3.3210194110870228E-2,3.1659829616546453E-2]
[4,"2019-05-01",-6709.692825582877,null,null,null,0.7,3.2197320461273327E-2,3.4052503108978449E-2,2.6515614986419855E-2,2.8074944019317982E-2,2.6580655574798717E-2,2.8143060207367121E-2,2.665189504623422E-2,2.821768522262591E-2,2.9864203929901301E-2,2.8445947170257835E-2,3.0104267597198531E-2,2.8696238994598611E-2]
[5,"2019-06-01",-6709.692825582877,null,null,null,0.65,2.9001981019973755E-2,3.0667275190353283E-2,2.3859709501266479E-2,2.5272101163864247E-2,2.3926883935928345E-2,2.5342303514480524E-2,2.4000090360641546E-2,2.5418812036514193E-2,2.6906663179397494E-2,2.5626701116561845E-2,2.7124696969985984E-2,2.5853449106216453E-2]
[6,"2019-07-01",-6709.692825582877,null,null,null,0.6,2.5943535566330334E-2,2.7428084611892944E-2,2.1320670843124612E-2,2.2591537237167447E-2,2.1388858556747659E-2,2.2662633657455689E-2,2.1462780237198054E-2,2.2739726305008201E-2,2.4075156450271584E-2,2.2927767038345537E-2,2.4271827936172441E-2,2.3131781816482566E-2]
[7,"2019-08-01",-6709.692825582877,null,null,null,0.55000000000000004,2.3022311925888217E-2,2.4335163831710749E-2,1.8898683786392256E-2,2.0033448934555165E-2,1.8966776132583574E-2,2.010428309440615E-2,1.9040197134018055E-2,2.0180660486221247E-2,2.1369951963424838E-2,2.0349436998367443E-2,2.1545964479446678E-2,2.0531541109085061E-2]
[8,"2019-09-01",-6709.692825582877,null,null,null,0.5,2.0238572359085105E-2,2.1388727426528975E-2,1.6593903303146362E-2,1.7598015069961392E-2,1.6660815477371194E-2,1.7667442560196034E-2,1.6732555627822943E-2,1.7741888761520497E-2,1.8791323900222756E-2,1.7891985177993841E-2,1.894738078117375E-2,1.8052989244461304E-2]
[9,"2019-10-01",-6709.692825582877,null,null,null,0.45,1.7592602968215909E-2,1.858896613121036E-2,1.4406448602676425E-2,1.5285366773605313E-2,1.4471119642257613E-2,1.5352278947830145E-2,1.4540058374405029E-2,1.5423613786697377E-2,1.6339486837387118E-2,1.5555626153945956E-2,1.6476327180862393E-2,1.5696412324905318E-2]
[10,"2019-11-01",-6709.692825582877,null,null,null,0.4,1.5084594488143921E-2,1.5936011075973422E-2,1.2336450815200739E-2,1.3095623254775979E-2,1.239781975746157E-2,1.3158947229385376E-2,1.24628365039825E-2,1.3226038217544533E-2,1.4014655351638705E-2,1.3340574502945013E-2,1.413301825523372E-2,1.3462001085281394E-2]
[11,"2019-12-01",-6709.692825582877,null,null,null,0.35,1.2714749574661233E-2,1.3429981470108099E-2,1.0383933782577626E-2,1.1028856039047241E-2,1.0440963506698653E-2,1.1087518930435136E-2,1.0501009225845404E-2,1.1149293184280373E-2,1.1816996335983321E-2,1.1247020959854082E-2,1.1917644739151023E-2,1.1349970102310092E-2]
[12,"2020-01-01",-6709.692825582877,null,null,null,0.29999999999999899,1.0483199357987527E-2,1.1070924997330811E-2,8.5489213466654612E-3,9.0850770473491216E-3,8.6005985736857249E-3,9.1380774974833545E-3,8.6546719074259149E-3,9.1935336589824002E-3,9.7466409206402038E-3,9.2750966548929559E-3,9.830373525620606E-3,9.3604624271403369E-3]
[13,"2020-02-01",-6709.692825582877,null,null,null,0.249999999999999,8.390063047410079E-3,8.8588774204264586E-3,6.8313777446756818E-3,7.2642743587503222E-3,6.8767249584208434E-3,7.3106348514566655E-3,6.923848390580245E-3,7.3587954044351811E-3,7.8037083148966291E-3,7.4248969554912003E-3,7.8713238239297434E-3,7.493609189988315E-3]
[14,"2020-03-01",-6709.692825582877,null,null,null,0.19999999999999901,6.435364484788042E-3,6.7937791347513488E-3,5.2311956882487021E-3,5.5663764476786282E-3,5.2692472934733336E-3,5.6051433086405367E-3,5.3085267543803161E-3,5.64514994621379E-3,5.9882223606119722E-3,5.6964933872233059E-3,6.040543317795799E-3,5.7494819164286004E-3]
[15,"2020-04-01",-6709.692825582877,null,null,null,0.149999999999999,4.6191155910502157E-3,4.8755347728739462E-3,3.7482321262370111E-3,3.9912402629862231E-3,3.7780702114115494E-3,4.0215194225321493E-3,3.8086354732523864E-3,4.0525376796732293E-3,4.3001830577860389E-3,4.0898621082316178E-3,4.3380796909342489E-3,4.1281163692484246E-3]
[16,"2020-05-01",-6709.692825582877,null,null,null,9.9999999999999006E-2,2.9412329196940035E-3,3.1040012836466568E-3,2.3822605609903902E-3,2.5386631488810152E-3,2.4029910564432599E-3,2.5596082210550819E-3,2.4240553379068774E-3,2.5809228420267671E-3,2.7395665645609524E-3,2.6049911975870588E-3,2.7639091014872164E-3,2.6294767856608059E-3]
[17,"2020-06-01",-6709.692825582877]
[18,"2020-07-01",-6709.692825582877]
[19,"2020-08-01",-6709.692825582877]
[20,"2020-09-01",-6709.692825582877]
[21,"2020-10-01",-6709.692825582877]
[22,"2020-11-01",-6709.692825582877]
[23,"2020-12-01",-6709.692825582877]
[24,"2021-01-01",-6709.692825582877]

{"sheet":" 36 meses diferencias en CF ","index":5,"n_rows":81,"n_cols":19,"rows_kept":81,"cut":false,"hidden":true,"merged":[[42,7,42,18],[44,5,60,5]]}
[]
[]
[]
[]
[null,"Simulador de cuota máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+' 24 meses diferencias en CFT'!C7","v":45}]
[null,"Monto del préstamo ",100000]
[null,"cantidad de cuotas",36]
[null,"Gastos a cargo del deudor en el momento inicial",10000]
[null,"CFTEA",0.81859999999999999]
[]
[]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C10","v":90000}]
[null,"Cuota",{"$f":"+C14/C22","v":5601.9924801824554}]
[]
[]
[]
[null,"TEM",{"$f":"+C20/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C11)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C19)^C9-1)/(C19*(1+C19)^C9)","v":16.465469503612166}]
[null,"ani difereido",{"$f":"+C21*1/(1+C19)^C24","v":16.065712390436612}]
[]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C27*365/30","v":0.67542765037777952}]
[null,"TEM máxima a incluir en el préstamo",5.551460140091339E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C15","v":17.850791544929567}]
[null,"ani resultante",{"$f":"+(((1+C27)^C9-1)/(C27*(1+C27)^C9))","v":15.437669916693242}]
[null,"diferencia",{"$f":"+C29-C30","v":2.4131216282363255}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CFT",{"$f":"+XIRR(C45:C81,B45:B81)","v":0.84513512849807748}]
[null,null,"Diferencia",{"$f":"+D40-C11","v":2.6535128498077487E-2}]
[]
[null,null,null,null,null,null,null,"Fecha inicial"]
[null,"Fechas","Flujo",null,null,null,{"$f":"+D41","v":2.6535128498077487E-2},"2019-01-01",{"$f":"+EDATE(H44,1)","v":"2019-02-01"},{"$f":"+EDATE(I44,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01",{"$f":"+EDATE(N44,1)","v":"2019-08-01"},"2019-09-01",{"$f":"+EDATE(P44,1)","v":"2019-10-01"},"2019-11-01","2019-12-01"]
[0,"2019-01-01",{"$f":"+C14","v":90000},null,null,"CFT límite",0.9,3.1043183803558416E-2,3.3090126514434881E-2,2.5030148029327459E-2,2.6709640026092552E-2,2.5107944011688255E-2,2.6791822910308682E-2,2.5194752216339045E-2,2.6883518695831277E-2,2.8674638271331987E-2,2.7176272869110174E-2,2.8985083103180043E-2,2.7503097057342774E-2]
[1,{"$f":"+EDATE(B45,C7/30)","v":"2019-02-01"},{"$f":"+C15*-1","v":-5601.9924801824554},null,null,null,0.85,2.8232133388519487E-2,3.0098116397857422E-2,2.271403074264533E-2,2.425717115402215E-2,2.2794568538665794E-2,2.434207201004035E-2,2.288397550582888E-2,2.4436342716216974E-2,2.6078832149505682E-2,2.4707806110382147E-2,2.6366007328033514E-2,2.5009453296661488E-2]
[2,{"$f":"+EDATE(B46,1)","v":"2019-03-01"},{"$f":"+C46","v":-5601.9924801824554},null,{"$f":"+AVERAGE(H47:S47)","v":2.3637917582194173E-2},null,0.81859999999999999,2.6535128498077487E-2,2.8291844272613442E-2,2.1317981624603632E-2,2.2778152370452887E-2,2.1399735355377647E-2,2.2864221477508773E-2,2.1490215206146468E-2,2.2959517383575712E-2,2.451169385910057E-2,2.3217843914032033E-2,2.4784587764740129E-2,2.350408926010128E-2]
[3,"2019-04-01",{"$f":"+C47","v":-5601.9924801824554},null,null,null,0.75,2.3010170459747403E-2,2.453988790512085E-2,1.8424165248871027E-2,1.9710218906402677E-2,1.8507230281829878E-2,1.9797432422638206E-2,1.8598568439483598E-2,1.9893372058868541E-2,2.1256434917450218E-2,2.0123755931854337E-2,2.1498954296111927E-2,2.0377337932586892E-2]
[4,"2019-05-01",-5601.9924801824554,null,null,null,0.7,2.0597946643829523E-2,2.1972143650055065E-2,1.6449129581451505E-2,1.7614424228668213E-2,1.6532051563263206E-2,1.7701303958892911E-2,1.6622793674469172E-2,1.779638528823857E-2,1.9028651714325218E-2,1.8007051944732622E-2,1.924983263015756E-2,1.823776960372947E-2]
[5,"2019-06-01",-5601.9924801824554,null,null,null,0.65,1.8317145109176813E-2,1.9544094800949319E-2,1.4586359262466542E-2,1.5636068582534968E-2,1.4668244123458907E-2,1.5721648931503518E-2,1.475740075111398E-2,1.5814846754074185E-2,1.6922181844711393E-2,1.6006332635879694E-2,1.7122691869735807E-2,1.6214972734451272E-2]
[6,"2019-07-01",-5601.9924801824554,null,null,null,0.6,1.6166871786117643E-2,1.7254680395126565E-2,1.2834995985031128E-2,1.3774234056472934E-2,1.2914949655532859E-2,1.3857597112655773E-2,1.3001567125320523E-2,1.3947898149490379E-2,1.4936155080795488E-2,1.4120775461197166E-2,1.5116685628891124E-2,1.4308148622512729E-2]
[7,"2019-08-01",-5601.9924801824554,null,null,null,0.55000000000000004,1.4146047830581598E-2,1.5102714300155751E-2,1.1194032430648648E-2,1.2027901411056474E-2,1.1271208524703979E-2,1.2108153104782193E-2,1.1354357004165538E-2,1.2194627523422263E-2,1.3069623708724887E-2,1.2349468469619596E-2,1.323086619377134E-2,1.2516385316848622E-2]
[8,"2019-09-01",-5601.9924801824554,null,null,null,0.5,1.2253481149673506E-2,1.3086873292922796E-2,9.662348031997503E-3,1.0395914316177146E-2,9.7359240055082674E-3,1.0472208261489757E-2,9.8147332668304665E-3,1.055395007133475E-2,1.1321467161178544E-2,1.0691362619400069E-2,1.1464136838913008E-2,1.0838657617568859E-2]
[9,"2019-10-01",-5601.9924801824554,null,null,null,0.45,1.0487824678420965E-2,1.1205667257308927E-2,8.2386910915375755E-3,8.876985311508212E-3,8.3078682422638717E-3,8.9485108852385697E-3,8.3815395832061435E-3,9.0247094631195623E-3,9.6904814243316539E-3,9.1453015804290883E-3,9.8153173923492543E-3,9.2737972736359198E-3]
[10,"2019-11-01",-5601.9924801824554,null,null,null,0.4,8.8476002216338889E-3,9.4574749469756858E-3,6.9216787815093994E-3,7.4696838855743408E-3,6.9856822490692583E-3,7.5356781482697199E-3,7.0534527301787664E-3,7.6055467128753884E-3,8.175283670425415E-3,7.7099502086638294E-3,8.2830131053924783E-3,7.8205287456513117E-3]
[11,"2019-12-01",-5601.9924801824554,null,null,null,0.35,7.3311388492585117E-3,7.8404724597931352E-3,5.7097494602204035E-3,6.1724126338958962E-3,5.7678520679474987E-3,6.2321484088898593E-3,5.8290064334870495E-3,6.2950074672699641E-3,6.7743360996247448E-3,6.3838541507722502E-3,6.865733861923351E-3,6.4773976802826594E-3]
[12,"2020-01-01",-5601.9924801824554,null,null,null,0.29999999999999899,5.9365808963786626E-3,6.3526570796977322E-3,4.6011865139017893E-3,4.9834311008462584E-3,4.6527087688456592E-3,5.0362169742593221E-3,4.7065794467935906E-3,5.0914227962503555E-3,5.4859578609476878E-3,5.1653921604167263E-3,5.561798810959806E-3,5.242770910264094E-3]
[13,"2020-02-01",-5601.9924801824554,null,null,null,0.249999999999999,4.6619117259989462E-3,4.991835355759644E-3,3.5940945148478232E-3,3.9007723331461186E-3,3.6383807659159384E-3,3.9460003376017294E-3,3.6843836307535183E-3,3.9929687976847372E-3,4.3082535266886213E-3,4.0527641773233647E-3,4.369336366654486E-3,4.1148841381082324E-3]
[14,"2020-03-01",-5601.9924801824554,null,null,null,0.19999999999999901,3.5048663616190079E-3,3.7555992603312272E-3,2.6863873004923378E-3,2.9223024845133339E-3,2.7228295803079505E-3,2.9594004154215592E-3,2.7604281902323113E-3,2.9976546764383938E-3,3.2391607761393104E-3,3.0439674854288445E-3,3.2863080501565889E-3,3.0917584896097139E-3]
[15,"2020-04-01",-5601.9924801824554,null,null,null,0.149999999999999,2.4629890918741737E-3,2.6413142681131763E-3,1.8757641315470808E-3,2.0456969738016917E-3,1.9038021564493912E-3,2.074128389359553E-3,1.9325315952311017E-3,2.1032512187967589E-3,2.2764027118693242E-3,2.13682055473427E-3,2.3104488849649829E-3,2.171200513840732E-3]
[16,"2020-05-01",-5601.9924801824554,null,null,null,9.9999999999999006E-2,1.5335738658915077E-3,1.6460835933695406E-3,1.1596977710733869E-3,1.2683570384988962E-3,1.1788308620462595E-3,1.2876808643351167E-3,1.1982858181009692E-3,1.3073265552530633E-3,1.4174878597269513E-3,1.3289034366617825E-3,1.4392912387857781E-3,1.3508498668680646E-3]
[17,"2020-06-01",-5601.9924801824554]
[18,"2020-07-01",-5601.9924801824554]
[19,"2020-08-01",-5601.9924801824554]
[20,"2020-09-01",-5601.9924801824554]
[21,"2020-10-01",-5601.9924801824554]
[22,"2020-11-01",-5601.9924801824554]
[23,"2020-12-01",-5601.9924801824554]
[24,"2021-01-01",-5601.9924801824554]
[25,{"$f":"+EDATE(B69,1)","v":"2021-02-01"},{"$f":"+C69","v":-5601.9924801824554}]
[26,"2021-03-01",-5601.9924801824554]
[27,"2021-04-01",-5601.9924801824554]
[28,"2021-05-01",-5601.9924801824554]
[29,"2021-06-01",-5601.9924801824554]
[30,"2021-07-01",-5601.9924801824554]
[31,"2021-08-01",-5601.9924801824554]
[32,"2021-09-01",-5601.9924801824554]
[33,"2021-10-01",-5601.9924801824554]
[34,"2021-11-01",-5601.9924801824554]
[35,"2021-12-01",-5601.9924801824554]
[36,"2022-01-01",-5601.9924801824554]

{"sheet":" 48 meses diferencias en CF ","index":6,"n_rows":93,"n_cols":19,"rows_kept":93,"cut":false,"hidden":true,"merged":[[42,7,42,18],[44,5,60,5]]}
[]
[]
[]
[]
[null,"Simulador de cuota máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+' 36 meses diferencias en CF '!C7","v":45}]
[null,"Monto del préstamo ",100000]
[null,"cantidad de cuotas",48]
[null,"Gastos a cargo del deudor en el momento inicial",10000]
[null,"CFTEA",0.81859999999999999]
[]
[]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C10","v":90000}]
[null,"Cuota",{"$f":"+C14/C22","v":5132.2614186721185}]
[]
[]
[]
[null,"TEM",{"$f":"+C20/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C11)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C19)^C9-1)/(C19*(1+C19)^C9)","v":17.972474279335174}]
[null,"ani difereido",{"$f":"+C21*1/(1+C19)^C24","v":17.536129331324261}]
[]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C27*365/30","v":0.67542765037777952}]
[null,"TEM máxima a incluir en el préstamo",5.551460140091339E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C15","v":19.484588145915847}]
[null,"ani resultante",{"$f":"+(((1+C27)^C9-1)/(C27*(1+C27)^C9))","v":16.66646068887054}]
[null,"diferencia",{"$f":"+C29-C30","v":2.818127457045307}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CFT",{"$f":"+XIRR(C45:C93,B45:B93)","v":0.83875800371170084}]
[null,null,"Diferencia",{"$f":"+D40-C11","v":2.0158003711700845E-2}]
[]
[null,null,null,null,null,null,null,"Fecha inicial"]
[null,"Fechas","Flujo",null,null,null,{"$f":"+D41","v":2.0158003711700845E-2},"2019-01-01",{"$f":"+EDATE(H44,1)","v":"2019-02-01"},{"$f":"+EDATE(I44,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01",{"$f":"+EDATE(N44,1)","v":"2019-08-01"},"2019-09-01",{"$f":"+EDATE(P44,1)","v":"2019-10-01"},"2019-11-01","2019-12-01"]
[0,"2019-01-01",{"$f":"+C14","v":90000},null,null,"CFT límite",0.9,2.4060952663421564E-2,2.5806868076324263E-2,1.8954575061798207E-2,2.0392596721649281E-2,1.9036471843719371E-2,2.0479118824005327E-2,1.9127762317657448E-2,2.057558298110973E-2,2.2110068798064986E-2,2.0844471454620206E-2,2.2395002841949396E-2,2.114447355270388E-2]
[1,{"$f":"+EDATE(B45,C7/30)","v":"2019-02-01"},{"$f":"+C15*-1","v":-5132.2614186721185},null,null,null,0.85,2.1619355678558327E-2,2.320262193679834E-2,1.6959631443023704E-2,1.8274056911468439E-2,1.7042839527130149E-2,1.8361794948577814E-2,1.7135179042816362E-2,1.8459165096283203E-2,1.9859015941619762E-2,1.870771646499636E-2,2.0121753215789906E-2,1.8983733654022061E-2]
[2,{"$f":"+EDATE(B46,1)","v":"2019-03-01"},{"$f":"+C46","v":-5132.2614186721185},null,{"$f":"+AVERAGE(H47:S47)","v":1.7754786157608171E-2},null,0.81859999999999999,2.0158003711700845E-2,2.1643566036224637E-2,1.5768431568145891E-2,1.70080412864686E-2,1.585202112197881E-2,1.7096065425872942E-2,1.5944503688812395E-2,1.7193459415435708E-2,1.8511914157867571E-2,1.7429493808746477E-2,1.8761061573028703E-2,1.7690872097015475E-2]
[3,"2019-04-01",{"$f":"+C47","v":-5132.2614186721185},null,null,null,0.75,1.7156994342804044E-2,1.8440830707550093E-2,1.3330113887786821E-2,1.4413702487945601E-2,1.3413321971893266E-2,1.4501035213470459E-2,1.3504779338836759E-2,1.4597070217132746E-2,1.5746152400970548E-2,1.4806616306304976E-2,1.596657037734972E-2,1.5037095546722501E-2]
[4,"2019-05-01",-5132.2614186721185,null,null,null,0.7,1.5133774280548407E-2,1.6280496120453014E-2,1.1693346500396995E-2,1.2669575214386164E-2,1.1775267124176203E-2,1.2755382061004905E-2,1.1864912509918391E-2,1.2849271297455056E-2,1.3882124423980846E-2,1.3040173053741499E-2,1.408241987228398E-2,1.3249123096466198E-2]
[5,"2019-06-01",-5132.2614186721185,null,null,null,0.65,1.3247221708297841E-2,1.4265018701553389E-2,1.0173410177230835E-2,1.1047607660293668E-2,1.0253280401229858E-2,1.1131066083908014E-2,1.0340219736099221E-2,1.1221903562545932E-2,1.2144547700882025E-2,1.1394792795181297E-2,1.2325435876846091E-2,1.1583048105239913E-2]
[6,"2019-07-01",-5132.2614186721185,null,null,null,0.6,1.1495596170425393E-2,1.2392503023147539E-2,8.7687551975251798E-3,9.5462024211885321E-3,8.8458120822907382E-3,9.6265137195586936E-3,8.9292347431181307E-3,9.7134649753569668E-3,1.0531860589981124E-2,9.8689258098603183E-3,1.0694080591201915E-2,1.0037344694137529E-2]
[7,"2019-08-01",-5132.2614186721185,null,null,null,0.55000000000000004,9.8769247531890203E-3,1.0660797357559093E-2,7.4775874614716464E-3,8.1634938716889094E-3,7.5511038303375244E-3,8.2399070262908491E-3,7.6302707195282649E-3,8.3222091197966419E-3,9.0422451496124934E-3,8.4608852863310435E-3,9.186547994613492E-3,8.6103022098539261E-3]
[8,"2019-09-01",-5132.2614186721185,null,null,null,0.5,8.3889901638029007E-3,9.0674817562103049E-3,6.2979042530060259E-3,6.8974196910858154E-3,6.3672006130217618E-3,6.9692432880401611E-3,6.4414083957671231E-3,7.0461809635161687E-3,7.6736629009246382E-3,7.1687161922454612E-3,7.8008115291595681E-3,7.3000013828278254E-3]
[9,"2019-10-01",-5132.2614186721185,null,null,null,0.45,7.029300928115878E-3,7.6098978519441585E-3,5.2274644374847301E-3,5.7456552982330655E-3,5.2918970584869274E-3,5.8122456073761986E-3,5.360502004623513E-3,5.8831751346589134E-3,6.4238488674163707E-3,5.9902250766754039E-3,6.5345942974090465E-3,6.1042726039886586E-3]
[10,"2019-11-01",-5132.2614186721185,null,null,null,0.4,5.7950913906097412E-3,6.2850654125213845E-3,4.2637526988982266E-3,4.705613851547108E-3,4.3227255344390203E-3,4.7663986682892068E-3,4.3851554393768977E-3,4.8307359218596746E-3,5.2902519702910933E-3,4.9229919910430686E-3,5.3853929042816384E-3,5.0206720829009122E-3]
[11,"2019-12-01",-5132.2614186721185,null,null,null,0.35,4.6832978725434016E-3,5.0897061824799472E-3,3.4039914608001709E-3,3.7744700908661777E-3,3.4569680690765825E-3,3.8288891315459983E-3,3.5126984119415727E-3,3.8861453533173274E-3,4.2700469493867077E-3,3.9642870426178645E-3,4.3503582477569802E-3,4.0465056896210605E-3]
[12,"2020-01-01",-5132.2614186721185,null,null,null,0.29999999999999899,3.690522909165439E-3,4.0202081203471463E-3,2.6451408863076842E-3,2.9490411281595796E-3,2.6916205883035782E-3,2.9966413974772954E-3,2.7401983737955216E-3,3.0463874340068142E-3,3.3600986003887168E-3,3.1111061573038667E-3,3.4264147281656832E-3,3.1787812709819785E-3]
[13,"2020-02-01",-5132.2614186721185,null,null,null,0.249999999999999,2.8130590915690368E-3,3.0726492404947736E-3,1.9838392734538024E-3,2.2258937358866637E-3,2.0233571529398864E-3,2.2662341594705815E-3,2.0644009113321982E-3,2.3081243038186594E-3,2.556985616684937E-3,2.3601591587075754E-3,2.6101171970376313E-3,2.414208650589944E-3]
[14,"2020-03-01",-5132.2614186721185,null,null,null,0.19999999999999901,2.0468294620523964E-3,2.2427022457132961E-3,1.4164030551920281E-3,1.6012489795694806E-3,1.4485776424418007E-3,1.6339719295511423E-3,1.4817535877237886E-3,1.6677320003519458E-3,1.856940984726968E-3,1.7078101634989129E-3,1.8977224826822736E-3,1.7491638660441233E-3]
[15,"2020-04-01",-5132.2614186721185,null,null,null,0.149999999999999,1.3874113559733114E-3,1.5257179737101223E-3,9.3882679939369384E-4,1.0709822177897288E-3,9.6331238746746872E-4,1.0958015918741959E-3,9.88394021988942E-4,1.1212170124064169E-3,1.2558639049539966E-3,1.150101423264549E-3,1.2851417064677073E-3,1.1796891689310751E-3]
[16,"2020-05-01",-5132.2614186721185,null,null,null,9.9999999999999006E-2,8.2998871803383056E-4,9.1663002967934393E-4,5.4675936699014049E-4,6.3062310218908735E-4,5.6328177452186212E-4,6.4731240272619672E-4,5.8007836341958385E-4,6.6427588462927845E-4,7.4928402900797941E-4,6.8274140358071111E-4,7.6792836189368274E-4,7.0150494575602074E-4]
[17,"2020-06-01",-5132.2614186721185]
[18,"2020-07-01",-5132.2614186721185]
[19,"2020-08-01",-5132.2614186721185]
[20,"2020-09-01",-5132.2614186721185]
[21,"2020-10-01",-5132.2614186721185]
[22,"2020-11-01",-5132.2614186721185]
[23,"2020-12-01",-5132.2614186721185]
[24,"2021-01-01",-5132.2614186721185]
[25,"2021-02-01",-5132.2614186721185]
[26,"2021-03-01",-5132.2614186721185]
[27,"2021-04-01",-5132.2614186721185]
[28,"2021-05-01",-5132.2614186721185]
[29,"2021-06-01",-5132.2614186721185]
[30,"2021-07-01",-5132.2614186721185]
[31,"2021-08-01",-5132.2614186721185]
[32,"2021-09-01",-5132.2614186721185]
[33,"2021-10-01",-5132.2614186721185]
[34,"2021-11-01",-5132.2614186721185]
[35,"2021-12-01",-5132.2614186721185]
[36,"2022-01-01",-5132.2614186721185]
[37,{"$f":"+EDATE(B81,1)","v":"2022-02-01"},{"$f":"+C81","v":-5132.2614186721185}]
[38,"2022-03-01",-5132.2614186721185]
[39,"2022-04-01",-5132.2614186721185]
[40,"2022-05-01",-5132.2614186721185]
[41,"2022-06-01",-5132.2614186721185]
[42,"2022-07-01",-5132.2614186721185]
[43,"2022-08-01",-5132.2614186721185]
[44,"2022-09-01",-5132.2614186721185]
[45,"2022-10-01",-5132.2614186721185]
[46,"2022-11-01",-5132.2614186721185]
[47,"2022-12-01",-5132.2614186721185]
[48,"2023-01-01",-5132.2614186721185]

{"sheet":" 60 meses diferencias en CF ","index":7,"n_rows":105,"n_cols":19,"rows_kept":105,"cut":false,"hidden":true,"merged":[[42,7,42,18],[44,5,60,5]]}
[]
[]
[]
[]
[null,"Simulador de cuota máxima que puede incluir la Mutual en los préstamos"]
[]
[null,"A los cuntos días se cobra 1º cuota",{"$f":"+' 48 meses diferencias en CF '!C7","v":45}]
[null,"Monto del préstamo ",100000]
[null,"cantidad de cuotas",60]
[null,"Gastos a cargo del deudor en el momento inicial",10000]
[null,"CFTEA",0.81859999999999999]
[]
[]
[null,"Monto del préstamo inicalmente disponible para el deudor",{"$f":"+C8-C10","v":90000}]
[null,"Cuota",{"$f":"+C14/C22","v":4904.2782842777187}]
[]
[]
[]
[null,"TEM",{"$f":"+C20/(365/30)","v":5.0384397120131652E-2}]
[null,"TNA Límite del mes",{"$f":"+((1+C11)^(30/365)-1)*(365/30)","v":0.61301016496160177}]
[null,"ani",{"$f":"+((1+C19)^C9-1)/(C19*(1+C19)^C9)","v":18.80795317786367}]
[null,"ani difereido",{"$f":"+C21*1/(1+C19)^C24","v":18.3513240446662}]
[]
[null,"diferimiento",{"$f":"+(C7-30)/30","v":0.5}]
[]
[null,"TNA máxima a incluir en el préstamo",{"$f":"+C27*365/30","v":0.67542765037777952}]
[null,"TEM máxima a incluir en el préstamo",5.551460140091339E-2]
[]
[null,"ani objetivo",{"$f":"+C8/C15","v":20.390360049629113}]
[null,"ani resultante",{"$f":"+(((1+C27)^C9-1)/(C27*(1+C27)^C9))","v":17.309010789014213}]
[null,"diferencia",{"$f":"+C29-C30","v":3.0813492606148998}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"CFT",{"$f":"+XIRR(C45:C105,B45:B105)","v":0.83532954454422015}]
[null,null,"Diferencia",{"$f":"+D40-C11","v":1.6729544544220154E-2}]
[]
[null,null,null,null,null,null,null,"Fecha inicial"]
[null,"Fechas","Flujo",null,null,null,{"$f":"+D41","v":1.6729544544220154E-2},"2019-01-01",{"$f":"+EDATE(H44,1)","v":"2019-02-01"},{"$f":"+EDATE(I44,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01",{"$f":"+EDATE(N44,1)","v":"2019-08-01"},"2019-09-01",{"$f":"+EDATE(P44,1)","v":"2019-10-01"},"2019-11-01","2019-12-01"]
[0,"2019-01-01",{"$f":"+C14","v":90000},null,null,"CFT límite",0.9,2.0376574993133612E-2,2.1963846683502264E-2,1.5737926959991433E-2,1.70418620109557E-2,1.5807044506073065E-2,1.7114865779876864E-2,1.5884077548980691E-2,1.7196285724640048E-2,1.8586552143096902E-2,1.7433154582977228E-2,1.8837511539459117E-2,1.7697370052337624E-2]
[1,{"$f":"+EDATE(B45,C7/30)","v":"2019-02-01"},{"$f":"+C15*-1","v":-4904.2782842777187},null,null,null,0.85,1.8089401721954279E-2,1.9521868228912331E-2,1.3877403736114791E-2,1.5063059329986639E-2,1.394718885421764E-2,1.5136611461639471E-2,1.4024603366851962E-2,1.5218245983123935E-2,1.6479861736297674E-2,1.5435421466827415E-2,1.6709363460540971E-2,1.5676534175872781E-2]
[2,{"$f":"+EDATE(B46,1)","v":"2019-03-01"},{"$f":"+C46","v":-4904.2782842777187},null,{"$f":"+AVERAGE(H47:S47)","v":1.4552608076731458E-2},null,0.81859999999999999,1.6729544544220154E-2,1.8069409275055071E-2,1.2774633312225392E-2,1.3888930225372409E-2,1.2844394588470642E-2,1.3962386989593734E-2,1.292157068252564E-2,1.4043663883209323E-2,1.5227793598175055E-2,1.4248799228668174E-2,1.5444277667999495E-2,1.4475892925262412E-2]
[3,"2019-04-01",{"$f":"+C47","v":-4904.2782842777187},null,null,null,0.75,1.3962352275848522E-2,1.5111863613128662E-2,1.0539925098419278E-2,1.1506283283233554E-2,1.060861349105835E-2,1.1578381061553955E-2,1.0684096813201815E-2,1.165760755538936E-2,1.2681376934051469E-2,1.1837375164031938E-2,1.2870442867279008E-2,1.2035071849822998E-2]
[4,"2019-05-01",-4904.2782842777187,null,null,null,0.7,1.2119686603546231E-2,1.3140738010406494E-2,9.0604424476625756E-3,9.9257111549377885E-3,9.127461910247936E-3,9.995877742767334E-3,9.200751781463623E-3,1.0072648525238037E-2,1.0987150669098167E-2,1.0234773159027322E-2,1.1157190799713224E-2,1.0412180423736705E-2]
[5,"2019-06-01",-4904.2782842777187,null,null,null,0.65,1.0421925783157371E-2,1.1322897672653154E-2,7.705003023147583E-3,8.4748208522796853E-3,7.7696859836580145E-3,8.5423886775972679E-3,7.8400552272798185E-3,8.6159169673920566E-3,9.427505731582686E-3,8.7611138820649082E-3,9.579390287399514E-3,8.9191854000092441E-3]
[6,"2019-07-01",-4904.2782842777187,null,null,null,0.6,8.8669121265412265E-3,9.6560418605804443E-3,6.4716994762420432E-3,7.1516454219819892E-3,6.5334141254425049E-3,7.215946912765614E-3,6.6002190113069181E-3,7.2855651378633812E-3,8.0004990100862594E-3,7.4145972728730802E-3,8.1350982189178911E-3,7.5543224811553955E-3]
[7,"2019-08-01",-4904.2782842777187,null,null,null,0.55000000000000004,7.4521243572235329E-3,8.1374466419219527E-3,5.3582847118376353E-3,5.9538543224334495E-3,5.4164707660674383E-3,6.014317274093739E-3,5.4791152477263738E-3,6.0794293880462869E-3,6.703883409500011E-3,6.193047761916981E-3,6.8220794200897217E-3,6.315416097640969E-3]
[8,"2019-09-01",-4904.2782842777187,null,null,null,0.5,6.1747014522551824E-3,6.7640006542204478E-3,4.3621718883514182E-3,4.8788011074066828E-3,4.4163167476652943E-3,4.9349129199980357E-3,4.4742763042450173E-3,4.9949824810027188E-3,5.5350482463837336E-3,5.0939857959746426E-3,5.63773512840271E-3,5.2000224590300625E-3]
[9,"2019-10-01",-4904.2782842777187,null,null,null,0.45,5.0313413143157626E-3,5.532163381576638E-3,3.4804284572600985E-3,3.9234459400177557E-3,3.5300672054290883E-3,3.9747416973113237E-3,3.5829246044159491E-3,4.0293633937835138E-3,4.4910132884979359E-3,4.1145503520965687E-3,4.5790970325470526E-3,4.2052686214447133E-3]
[10,"2019-11-01",-4904.2782842777187,null,null,null,0.4,4.018300771713279E-3,4.4379770755766934E-3,2.7097165584564209E-3,3.0843555927275723E-3,2.7544796466826282E-3,3.1304657459259033E-3,2.8018534183502641E-3,3.1792819499970593E-3,3.5683572292328769E-3,3.2514870166777676E-3,3.6427915096283181E-3,3.3279120922088401E-3]
[11,"2019-12-01",-4904.2782842777187,null,null,null,0.35,3.1314194202424206E-3,3.4769952297211137E-3,2.0463049411773016E-3,2.3576796054840532E-3,2.0858705043793613E-3,2.3983061313629372E-3,2.1274745464325839E-3,2.441054582595803E-3,2.7632772922516757E-3,2.5011122226715754E-3,2.8249919414521374E-3,2.5643050670624001E-3]
[12,"2020-01-01",-4904.2782842777187,null,null,null,0.29999999999999899,2.3660123348246409E-3,2.6442706584940967E-3,1.4860332012187061E-3,1.739138364792947E-3,1.5201389789591402E-3,1.7740547657023042E-3,1.5557825565349348E-3,1.810544729233865E-3,2.0714819431315035E-3,1.8593370914469776E-3,2.1214544773111021E-3,1.9103467464456902E-3]
[13,"2020-02-01",-4904.2782842777187,null,null,null,0.249999999999999,1.7169415950785138E-3,1.9343674182902282E-3,1.0242879390726101E-3,1.223987340928212E-3,1.0527551174174254E-3,1.253026723862849E-3,1.0822951793680868E-3,1.2831866741191966E-3,1.4882266521464294E-3,1.3215839862833478E-3,1.527422666550704E-3,1.3614594936381952E-3]
[14,"2020-03-01",-4904.2782842777187,null,null,null,0.19999999999999901,1.1785089969645057E-3,1.3413131237039744E-3,6.5600275993446533E-4,8.0701708793740057E-4,6.7871212959394467E-4,8.301079273234091E-4,7.0212483406167925E-4,8.5391402244669457E-4,1.0082900524149563E-3,8.8281035423376508E-4,1.0376751422892239E-3,9.1261267662148815E-4]
[15,"2020-04-01",-4904.2782842777187,null,null,null,0.149999999999999,7.4455142021279119E-4,8.5862278938395042E-4,3.7564635276893243E-4,4.8251748085126334E-4,3.925621509562327E-4,4.9965977668864348E-4,4.0988326072799453E-4,5.1720738411051292E-4,6.2595009803878554E-4,5.374968051920781E-4,6.4652562141523373E-4,5.58286905289751E-4]
[16,"2020-05-01",-4904.2782842777187,null,null,null,9.9999999999999006E-2,4.0835738182168346E-4,4.7926306724646595E-4,1.7723441124062322E-4,2.4434924125771307E-4,1.883924007425597E-4,2.5560259819129572E-4,1.9971728324991167E-4,2.6704668998817072E-4,3.3499598503211603E-4,2.7965903282267668E-4,3.4772753715617277E-4,2.9247403144938566E-4]
[17,"2020-06-01",-4904.2782842777187]
[18,"2020-07-01",-4904.2782842777187]
[19,"2020-08-01",-4904.2782842777187]
[20,"2020-09-01",-4904.2782842777187]
[21,"2020-10-01",-4904.2782842777187]
[22,"2020-11-01",-4904.2782842777187]
[23,"2020-12-01",-4904.2782842777187]
[24,"2021-01-01",-4904.2782842777187]
[25,"2021-02-01",-4904.2782842777187]
[26,"2021-03-01",-4904.2782842777187]
[27,"2021-04-01",-4904.2782842777187]
[28,"2021-05-01",-4904.2782842777187]
[29,"2021-06-01",-4904.2782842777187]
[30,"2021-07-01",-4904.2782842777187]
[31,"2021-08-01",-4904.2782842777187]
[32,"2021-09-01",-4904.2782842777187]
[33,"2021-10-01",-4904.2782842777187]
[34,"2021-11-01",-4904.2782842777187]
[35,"2021-12-01",-4904.2782842777187]
[36,"2022-01-01",-4904.2782842777187]
[37,"2022-02-01",-4904.2782842777187]
[38,"2022-03-01",-4904.2782842777187]
[39,"2022-04-01",-4904.2782842777187]
[40,"2022-05-01",-4904.2782842777187]
[41,"2022-06-01",-4904.2782842777187]
[42,"2022-07-01",-4904.2782842777187]
[43,"2022-08-01",-4904.2782842777187]
[44,"2022-09-01",-4904.2782842777187]
[45,"2022-10-01",-4904.2782842777187]
[46,"2022-11-01",-4904.2782842777187]
[47,"2022-12-01",-4904.2782842777187]
[48,"2023-01-01",-4904.2782842777187]
[49,"2023-02-01",-4904.2782842777187]
[50,"2023-03-01",-4904.2782842777187]
[51,"2023-04-01",-4904.2782842777187]
[52,"2023-05-01",-4904.2782842777187]
[53,"2023-06-01",-4904.2782842777187]
[54,"2023-07-01",-4904.2782842777187]
[55,"2023-08-01",-4904.2782842777187]
[56,"2023-09-01",-4904.2782842777187]
[57,"2023-10-01",-4904.2782842777187]
[58,"2023-11-01",-4904.2782842777187]
[59,"2023-12-01",-4904.2782842777187]
[60,"2024-01-01",-4904.2782842777187]