{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Interés al Vencimiento","Interés Mensual","Interés Adelantado","Interés y Capital Mensual","Cuota mixta 5años","Cuota mixta"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Interés al Vencimiento","index":0,"n_rows":17,"n_cols":2,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
[]
["Pago de Interés al Vencimiento"]
["Capital",5000]
["Moneda","Soles"]
["Plazo en días",1080]
["TREA",7.0000000000000007E-2]
["Tasa del plazo",{"$f":"((1+$B$7)^(B6/360)-1)","v":0.2250430000000001}]
["Interés al Vencimiento",{"$f":"B8*B4","v":1125.2150000000006}]
[]
["Pre-cancelación:"]
["TEA de Penalidad",{"$f":"+IF($B$5=\"Soles\",1.25%,0.2%)","v":1.2500000000000001E-2}]
["Días transcurridos",90]
["Tasa del plazo penalidad",{"$f":"((1+$B$12)^(B13/360)-1)","v":3.1104574646330096E-3}]
["Interés al Vencimiento por Pre-cancelación",{"$f":"B4*B14","v":15.552287323165048}]
[]
[null,"Datos variables"]

{"sheet":"Interés Mensual","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
[]
["Pago de Interés Mensual"]
["Capital",5000]
["Moneda","Soles"]
["Plazo en días",180]
["TEA",4.4999999999999998E-2]
["Tasa del plazo",{"$f":"((1+$B$7)^(30/360)-1)","v":3.6748094004368514E-3}]
["TREA",{"$f":"+(B4+B10*12)/B4-1","v":4.4097712805242217E-2}]
["Interés Mensual",{"$f":"B8*B4","v":18.374047002184255}]
["Interés total Abonado",{"$f":"+B6/30*B10","v":110.24428201310553}]
[]
["Pre-cancelación:"]
["TEA penalidad",{"$f":"+IF($B$5=\"Soles\",1.25%,0.2%)","v":1.2500000000000001E-2}]
["Días transcurridos",90]
["Tasa del plazo penalidad",{"$f":"((1+$B$14)^(30/360)-1)","v":1.0357460146983577E-3}]
["Interés total por Pre-cancelación",{"$f":"B4*B16*B15/30","v":15.536190220475365}]
[]
[null,"Datos variables"]

{"sheet":"Interés Adelantado","index":2,"n_rows":20,"n_cols":2,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,0,1,5]]}
[]
[]
["Pago de Interés Adelantado"]
["Capital",800000]
["Moneda","Soles"]
["Plazo en días",1080]
["TEA",0.02]
["Tasa del plazo",{"$f":"((1+$B$7)^(B6/360)-1)","v":6.1207999999999929E-2}]
["Tasa del plazo de interés adelantado",{"$f":"B8/(1+B8)","v":5.767766545295544E-2}]
["TREA",{"$f":"+B7/(1+B7)","v":1.9607843137254902E-2}]
["Interés Adelantado",{"$f":"+B9*B4","v":46142.132362364355}]
[]
["Pre-cancelación:"]
["TEA penalidad",{"$f":"+IF($B$5=\"Soles\",1.25%,0.2%)","v":1.2500000000000001E-2}]
["Días transcurridos",101]
["Tasa del plazo penalidad",{"$f":"((1+$B$14)^(B15/360)-1)","v":3.4912873952706036E-3}]
["Tasa del plazo de interés penalidad",{"$f":"B16/(1+B16)","v":3.4791407151454437E-3}]
["Descuento del Capital por Pre-cancelación",{"$f":"B11-(B17*B4)","v":43358.819790248002}]
[]
[null,"Datos variables"]

{"sheet":"Interés y Capital Mensual","index":3,"n_rows":253,"n_cols":10,"rows_kept":253,"cut":false,"hidden":false,"merged":[[6,0,6,2],[7,0,7,2],[1,0,1,5],[3,0,3,2],[3,5,3,7],[4,0,4,2],[4,5,4,7],[5,0,5,2]]}
[]
[]
["Pago Interes y capital Mensual",null,null,null,null,"Pre-Cancelación:"]
["CAPITAL",null,null,1050000,null,"TEA penalidad",null,null,1.2500000000000001E-2]
["TEA",null,null,7.0000000000000007E-2,null,"Periodo de alerta",null,null,35]
["Meses",null,null,240]
["Cuota Mensual (Interés+Capital)",null,null,8000]
["CAPITAL remanente al final del periodo",null,null,2877.6731035091198]
[]
[]
[]
["MES","CAPITAL","Porción capital","Porción interés","Pago Mensual","Dscto.Capital Pre-cancelación \n(a periodo vencido)",null,"CAPITAL","Dscto.\nCapital","Interes mes"]
[1,1050000,2063.147343224462,5936.852656775538,8000,-359469.60967036599,null,1050000,-357406.46232714155,365406.46232714155]
[2,1047936.8526567755,2074.8126782586924,5925.1873217413076,8000,-843330.53325845161,null,1407406.4623271415,-481786.11090982688,489786.11090982688]
[3,1045862.0399785168,2086.5439707931992,5913.4560292068008,8000,-1494867.7199351783,null,1889192.5732369684,-649450.64270593331,657450.64270593331]
[4,1043775.4960077235,2098.3415937612781,5901.6584062387219,8000,-2372429.5250036949,null,2538643.2159429016,-875463.46347475564,883463.46347475564]
[5,1041677.1544139623,2110.2059222048438,5889.7940777951562,8000,-3554669.867814919,null,3414106.6794176572,-1180130.1368890195,1188130.1368890195]
[6,1039566.9484917574,2122.1373332863541,5877.8626667136459,8000,-5147614.6929003317,null,4594236.8163066767,-1590822.6877521263,1598822.6877521263]
[7,1037444.811158471,2134.1362063007955,5865.8637936992045,8000,-7294187.6030694824,null,6185059.5040588025,-2144438.7739628493,2152438.7739628493]
[8,1035310.6749521702,2146.2029226877457,5853.7970773122543,8000,-10187050.471451132,null,8329498.2780216523,-2890716.6654589614,2898716.6654589614]
[9,1033164.4720294825,2158.3378660434964,5841.6621339565036,8000,-14085912.665552776,null,11220214.943480615,-3896703.8562356001,3904703.8562356001]
[10,1031006.134163439,2170.5414221332485,5829.4585778667515,8000,-19340863.987823445,null,15116918.799716216,-5252780.7808485348,5260780.7808485348]
[11,1028835.5927413058,2182.8139789033748,5817.1860210966252,8000,-26423827.623136468,null,20369699.580564752,-7080780.8213341199,7088780.8213341199]
[12,1026652.7787624025,2195.155926493755,5804.844073506245,8000,-35970958.905575722,null,27450480.401898872,-9544936.1265127603,9552936.1265127603]
[13,1024457.6228359087,2207.5676572501752,5792.4323427498248,8000,-48839799.117010072,null,36995416.528411634,-12866632.6437771,12874632.6437771]
[14,1022250.0551786585,2220.0495657368019,5779.9504342631981,8000,-66186319.159329578,null,49862049.172188736,-17344299.992753774,17352299.992753774]
[15,1020030.0056129217,2232.6020487487231,5767.3979512512769,8000,-89568774.898791939,null,67206349.164942503,-23380223.137413606,23388223.137413606]
[16,1017797.4035641729,2245.2255053245681,5754.7744946754319,8000,-121087704.80938847,null,90586572.302356109,-31516684.685091212,31524684.685091212]
[17,1015552.1780588484,2257.9203367591836,5742.0796632408164,8000,-163574647.65772995,null,122103256.98744732,-42484684.928004719,42492684.928004719]
[18,1013294.2577220892,2270.6869466163989,5729.3130533836011,8000,-220846535.10375312,null,164587941.91545203,-57269616.759076558,57277616.759076558]
[19,1011023.5707754728,2283.5257407418512,5716.4742592581488,8000,-298048614.49215645,null,221857558.6745286,-77199795.862662598,77207795.862662598]
[20,1008740.0450347309,2296.4371272758881,5703.5628727241119,8000,-402116710.88580638,null,299057354.53719121,-104065799.95652264,104073799.95652264]
[21,1006443.6079074551,2309.4215166665408,5690.5784833334592,8000,-542400359.1318047,null,403123154.49371386,-140281338.82448164,140289338.82448164]
[22,1004134.1863907885,2322.4793216825756,5677.5206783174244,8000,-731502789.72167373,null,543404493.31819546,-189100108.11054727,189108108.11054727]
[23,1001811.7070691059,2335.6109574266111,5664.3890425733889,8000,-986413234.90065944,null,732504601.42874277,-254908109.56802833,254916109.56802833]
[24,999476.09611167933,2348.8168413483181,5651.1831586516819,8000,-1330033284.2719603,null,987412710.9967711,-343617700.55445939,343625700.55445939]
[25,997127.27927033103,2362.0973932576871,5637.9026067423129,8000,-1793234421.5453291,null,1331030411.5512304,-463198775.17597562,463206775.17597562]
[26,994765.18187707337,2375.453035338377,5624.546964661623,8000,-2417631596.7375002,null,1794229186.727206,-624394799.73913586,624402799.73913586]
[27,992389.72884173493,2388.8841921611338,5611.1158078388662,8000,-3259322018.5685821,null,2418623986.466342,-841688032.94688988,841696032.94688988]
[28,990000.84464957379,2402.3912906972873,5597.6087093027127,8000,-4393925069.6231565,null,3260312019.4132318,-1134600648.6632838,1134608648.6632838]
[29,987598.45335887652,2415.9747603323258,5584.0252396676742,8000,-5923376143.0060863,null,4394912668.0765152,-1529448657.40817,1529456657.40817]
[30,985182.47859854414,2429.635032879547,5570.364967120453,8000,-7985084775.9678755,null,5924361325.4846849,-2061706203.3267562,2061714203.3267562]
[31,982752.8435656646,2443.372542593781,5556.627457406219,8000,-10764279870.396271,null,7986067528.8114414,-2779192651.0558538,2779200651.0558538]
[32,980309.47102307086,2457.1877261851996,5542.8122738148004,8000,-14510651126.018812,null,10765260179.867294,-3746368798.4348149,3746376798.4348149]
[33,977852.28329688567,2471.0810228331984,5528.9189771668016,8000,-19560781794.781174,null,14511628978.302109,-5050128197.6813383,5050136197.6813383]
[34,975381.20227405243,2485.0528742003562,5514.9471257996438,8000,-26368388171.813751,null,19561757175.983448,-6807603891.979702,6807611891.979702]
[35,972896.14939985203,2499.1037244464742,5500.8962755535258,8000,-35545082615.366493,null,26369361067.96315,-9176691944.4490185,9176699944.4490185]
[36,970397.04567540553,2513.2340202427013,5486.7659797572987,8000,-47915322348.56105,null,35546053012.41217,-12370237219.960537,12370245219.960537]
[37,967883.81165516283,2527.4442107857267,5472.5557892142733,8000,-64590480782.340385,null,47916290232.372711,-16675155906.335125,16675163906.335125]
[38,965356.36744437716,2541.7347478120646,5458.2652521879354,8000,-87068696114.684021,null,64591446138.70784,-22478212790.608894,22478220790.608894]
[39,962814.63269656512,2556.1060856124132,5443.8939143875868,8000,-117369467856.87814,null,87069658929.316742,-30300769186.088043,30300777186.088043]
[40,960258.52661095269,2570.5586810460973,5429.4413189539027,8000,-158215093779.31506,null,117370428115.40479,-40845623351.878227,40845631351.878227]
[41,957687.96792990656,2585.0929935555887,5414.9070064444113,8000,-213275248031.1022,null,158216051467.28302,-55060151666.694138,55060159666.694138]
[42,955102.87493635097,2599.7094851811153,5400.2905148188847,8000,-287496673950.57495,null,213276203133.97717,-74221423319.76326,74221431319.76326]
[43,952503.16545116983,2614.4086205753456,5385.5913794246544,8000,-387547612002.99432,null,287497626453.74042,-100050935438.01077,100050943438.01077]
[44,949888.7568305945,2629.1908670181647,5370.8091329818353,8000,-522416891375.83862,null,387548561891.75122,-134869276743.65341,134869284743.65341]
[45,947259.56596357631,2644.0566944315233,5355.9433055684767,8000,-704221509136.42358,null,522417838635.40466,-181804615116.52829,181804623116.52829]
[46,944615.50926914474,2659.0065753943818,5340.9934246056182,8000,-949295251906.69958,null,704222453751.93298,-245073740111.26941,245073748111.26941]
[47,941956.50269375031,2674.0409851577278,5325.9590148422722,8000,-1279656164580.9055,null,949296193863.20239,-330360910000.16492,330360918000.16492]
[48,939282.4617085926,2689.1604016596903,5310.8395983403097,8000,-1724984707188.6455,null,1279657103863.3672,-445328539918.57959,445328547918.57959]
[49,936593.30130693293,2704.3653055407276,5295.6346944592724,8000,-2325290322521.0757,null,1724985643781.9468,-600305612628.0647,600305620628.0647]
[50,933888.9360013922,2719.6561801589096,5280.3438198410904,8000,-3134505985702.6523,null,2325291256410.0117,-809215660461.92065,809215668461.92065]
[51,931169.27982123324,2735.0335116052829,5264.9664883947171,8000,-4225333679136.856,null,3134506916871.9326,-1090827690699.17,1090827698699.17]
[52,928434.24630962801,2750.4977887193245,5249.5022112806755,8000,-5695776122554.9707,null,4225334607571.1025,-1470442440667.6167,1470442448667.6167]
[53,925683.74852090864,2766.0495031044811,5233.9504968955189,8000,-7677941585322.0098,null,5695777048238.7187,-1982165460000.9895,1982165468000.9895]
[54,922917.69901780412,2781.6891491437937,5218.3108508562063,8000,-10349912827615.176,null,7677942508239.708,-2671971239511.478,2671971247511.478]
[55,920136.00986866036,2797.4172240156204,5202.5827759843796,8000,-13951746506180.98,null,10349913747751.186,-3601833675768.3887,3601833683768.3887]
[56,917338.59264464478,2813.2342277094358,5186.7657722905642,8000,-18807040471765.738,null,13951747423519.574,-4855293962771.5234,4855293970771.5234]
[57,914525.35841693531,2829.1406630417305,5170.8593369582695,8000,-25352006618789.898,null,18807041386291.098,-6544966144195.0195,6544966152195.0195]
[58,911696.21775389358,2845.1370356719881,5154.8629643280119,8000,-34174661265640.734,null,25352007530486.117,-8822654644005.6992,8822654652005.6992]
[59,908851.08071822161,2861.2238541187689,5138.7761458812311,8000,-46067654028507.898,null,34174662174491.816,-11892992760005.937,11892992768005.937]
[60,905989.85686410288,2877.4016297758681,5122.5983702241319,8000,-62099481468454.164,null,46067654934497.75,-16031827437068.865,16031827445068.865]
[61,903112.455234327,2893.6708769285779,5106.3291230714221,8000,-83710483525958.172,null,62099482371566.617,-21611002054610.332,21611002062610.332]
[62,900218.7843573984,2910.0321127700327,5089.9678872299673,8000,-112842247305497.34,null,83710484426176.953,-29131763776629.145,29131763784629.145]
[63,897308.75224462838,2926.4858574176524,5073.5141425823476,8000,-152112044173593.94,null,112842248202806.09,-39269796865170.117,39269796873170.117]
[64,894382.26638721069,2943.032633929678,5056.967366070322,8000,-205047972040571.19,null,152112045067976.22,-52935927864034.203,52935927872034.203]
[65,891439.23375328106,2959.6729683217945,5040.3270316782055,8000,-276405928603566.5,null,205047972932010.44,-71357956560035.641,71357956568035.641]
[66,888479.56078495923,2976.4073895838592,5023.5926104161408,8000,-372596893228956.12,null,276405929492046.06,-96190964622413.219,96190964630413.219]
[67,885503.15339537535,2993.2364296967135,5006.7635703032865,8000,-502262905559611.37,null,372596894114459.25,-129666012327662.02,129666012335662.02]
[68,882509.91696567868,3010.160623649097,4989.839376350903,8000,-677053488222396.37,null,502262906442121.25,-174790582659774.87,174790582667774.87]
[69,879499.75634202955,3027.1805094546517,4972.8194905453483,8000,-912672269416444.25,null,677053489101896.12,-235618781191020.72,235618781199020.72]
[70,876472.57583257486,3044.2966281690278,4955.7033718309722,8000,-1230287836603693.7,null,912672270292916.87,-317615567184205.25,317615567192205.25]
[71,873428.27920440584,3061.5095239070833,4938.4904760929167,8000,-1658435575966969,null,1230287837477122,-428147739360213.75,428147739368213.75]
[72,870366.76968049875,3078.8197438601801,4921.1802561398199,8000,-2235581363704527,null,1658435576837335.7,-577145787734479.25,577145787742479.25]
[73,867287.94993663859,3096.227838313579,4903.772161686421,8000,-3013577437673595,null,2235581364571815,-777996073965972,777996073973972]
[74,864191.72209832503,3113.7343606639351,4886.2656393360649,8000,-4062320933635358,null,3013577438537787,-1048743495958649.2,1048743495966649.2]
[75,861077.98773766111,3131.3398674368882,4868.6601325631118,8000,-5476033620784614,null,4062320934496436,-1413712687146124.2,1413712687154124.2]
[76,857946.6478702242,3149.0449183047549,4850.9550816952451,8000,-7381727023892994,null,5476033621642560,-1905693403105231.2,1905693403113231.2]
[77,854797.60295191943,3166.8500761043197,4833.1499238956803,8000,-9950613460057444,null,7381727024747791,-2568886436161282.5,2568886436169282.5]
[78,851630.75287581515,3184.7559068547289,4815.2440931452711,8000,-1.3413488186467504E+16,null,9950613460909074,-3462874726406875.5,3462874726414875.5]
[79,848445.99696896039,3202.7629797754835,4797.2370202245165,8000,-1.808146463026654E+16,null,1.341348818731595E+16,-4667976443795832,4667976443803832]
[80,845243.23398918496,3220.8718673045332,4779.1281326954668,8000,-2.4373925606021656E+16,null,1.8081464631111784E+16,-6292460975751896,6292460975759896]
[81,842022.3621218804,3239.0831451164768,4760.9168548835232,8000,-3.285620172890164E+16,null,2.437392560686368E+16,-8482276122876747,8482276122884747]
[82,838783.27897676395,3257.3973921408588,4742.6026078591412,8000,-4.4290362147536288E+16,null,3.2856201729740428E+16,-1.143416041863139E+16,1.143416041863939E+16]
[83,835525.88158462313,3275.815190580578,4724.184809419422,8000,-5.9703680764507264E+16,null,4.4290362148371816E+16,-1.5413318616967698E+16,1.5413318616975698E+16]
[84,832250.06639404257,3294.3371259303913,4705.6628740696087,8000,-8.0480929122951808E+16,null,5.9703680765339512E+16,-2.0777248358441256E+16,2.0777248358449256E+16]
[85,828955.72926811222,3312.9637869955286,4687.0362130044714,8000,-1.0848878778573011E+17,null,8.0480929123780768E+16,-2.8007858662774996E+16,2.8007858662782996E+16]
[86,825642.76548111672,3331.69576591041,4668.30423408959,8000,-1.462435536402448E+17,null,1.0848878778655576E+17,-3.7754765854511376E+16,3.7754765854519376E+16]
[87,822311.06971520628,3350.5336581574702,4649.4663418425298,8000,-1.9713721037750864E+17,null,1.4624355364106714E+17,-5.089365673726048E+16,5.089365673726848E+16]
[88,818960.53605704883,3369.4780625860867,4630.5219374139133,8000,-2.6574217288930035E+17,null,1.9713721037832762E+17,-6.8604962511788336E+16,6.8604962511796336E+16]
[89,815591.05799446278,3388.5295814316214,4611.4704185683786,8000,-3.5822208459110995E+17,null,2.6574217289011597E+17,-9.2479911701806192E+16,9.2479911701814192E+16]
[90,812202.52841303113,3407.6888203345588,4592.3111796654412,8000,-4.828855747417609E+17,null,3.5822208459192218E+17,-1.2466349015064755E+17,1.2466349015065555E+17]
[91,808794.83959269663,3426.9563883597657,4573.0436116402343,8000,-6.5093272671841434E+17,null,4.8288557474256973E+17,-1.6804715197665002E+17,1.6804715197665802E+17]
[92,805367.88320433686,3446.3328980158494,4553.6671019841506,8000,-8.7746132184548608E+17,null,6.5093272671921971E+17,-2.2652859512706829E+17,2.2652859512707629E+17]
[93,801921.55030632101,3465.8189652746287,4534.1810347253713,8000,-1.1828232622690524E+18,null,8.77461321846288E+17,-3.0536194042356294E+17,3.0536194042357094E+17]
[94,798455.7313410464,3485.4152095907184,4514.5847904092816,8000,-1.594453037339786E+18,null,1.1828232622698509E+18,-4.1162977507073005E+17,4.1162977507073805E+17]
[95,794970.31613145571,3505.1222539212176,4494.8777460787824,8000,-2.1493325075506266E+18,null,1.5944530373405809E+18,-5.5487947021083712E+17,5.5487947021084512E+17]
[96,791465.19387753448,3524.9407247455174,4475.0592752544826,8000,-2.8973134484545152E+18,null,2.1493325075514179E+18,-7.4798094090388531E+17,7.4798094090389325E+17]
[97,787940.25315278897,3544.8712520852141,4455.1287479147859,8000,-3.9055963603144187E+18,null,2.8973134484553032E+18,-1.0082829118598999E+18,1.008282911859908E+18]
[98,784395.38190070377,3564.9144695241375,4435.0855304758625,8000,-5.2647679310768323E+18,null,3.9055963603152031E+18,-1.3591715707624097E+18,1.3591715707624177E+18]
[99,780830.4674311796,3585.0710142284915,4414.9289857715085,8000,-7.0969395736182129E+18,null,5.2647679310776125E+18,-1.8321716425413775E+18,1.8321716425413855E+18]
[100,777245.39641695109,3605.3415269671123,4394.6584730328877,8000,-9.5667182240425964E+18,null,7.0969395736189901E+18,-2.4697786504243799E+18,2.4697786504243881E+18]
[101,773640.05488998396,3625.7266521318343,4374.2733478681657,8000,-1.2895995045307623E+19,null,9.5667182240433705E+18,-3.329276821265023E+18,3.3292768212650312E+18]
[102,770014.32823785208,3646.227037757978,4353.772962242022,8000,-1.7383880690730938E+19,null,1.2895995045308393E+19,-4.4878856454233114E+18,4.4878856454233196E+18]
[103,766368.1012000941,3666.8433355449497,4333.1566644550503,8000,-2.3433578161890341E+19,null,1.7383880690731704E+19,-6.0496974711593994E+18,6.0496974711594076E+18]
[104,762701.25786454917,3687.5762008769589,4312.4237991230411,8000,-3.1588607586464801E+19,null,2.3433578161891103E+19,-8.1550294245744568E+18,8.155029424574465E+18]
[105,759013.68166367221,3708.4262928438529,4291.5737071561471,8000,-4.258163744171307E+19,null,3.1588607586465559E+19,-1.0993029855248263E+19,1.0993029855248271E+19]
[106,755305.25537082832,3729.3942742620684,4270.6057257379316,8000,-5.7400309344259359E+19,null,4.2581637441713824E+19,-1.481867190254628E+19,1.4818671902546289E+19]
[107,751575.86109656631,3750.4808116957029,4249.5191883042971,8000,-7.7375970271849497E+19,null,5.7400309344260104E+19,-1.9975660927590138E+19,1.9975660927590146E+19]
[108,747825.38028487063,3771.6865754777036,4228.3134245222964,8000,-1.0430328414438936E+20,null,7.7375970271850234E+19,-2.6927313872539865E+19,2.6927313872539873E+19]
[109,744053.69370939292,3793.0122397311798,4206.9877602688202,8000,-1.4060146897134576E+20,null,1.0430328414439009E+20,-3.6298184826956394E+19,3.6298184826956403E+19]
[110,740260.68146966177,3814.4584823908272,4185.5415176091728,8000,-1.8953164551879249E+20,null,1.4060146897134649E+20,-4.8930176547446743E+19,4.8930176547446751E+19]
[111,736446.22298727091,3836.0259852244862,4163.9740147755138,8000,-2.5548982465028207E+20,null,1.8953164551879324E+20,-6.5958179131489583E+19,6.5958179131489591E+19]
[112,732610.19700204639,3857.7154338548107,4142.2845661451893,8000,-3.4440185606555979E+20,null,2.5548982465028283E+20,-8.8912031415277699E+19,8.8912031415277699E+19]
[113,728752.48156819155,3879.5275177810627,4120.4724822189373,8000,-4.6425582163110062E+20,null,3.4440185606556051E+20,-1.1985396556554083E+20,1.1985396556554083E+20]
[114,724872.95405041054,3901.4629304010359,4098.5370695989641,8000,-6.2581970486633982E+20,null,4.6425582163110134E+20,-1.6156388323523923E+20,1.6156388323523923E+20]
[115,720971.49112000945,3923.5223690330963,4076.4776309669037,8000,-8.4360881382807831E+20,null,6.258197048663406E+20,-2.1778910896173842E+20,2.1778910896173842E+20]
[116,717047.96875097638,3945.7065349383461,4054.2934650616539,8000,-1.1371898731127589E+21,null,8.4360881382807909E+20,-2.9358105928468054E+20,2.9358105928468054E+20]
[117,713102.26221603807,3968.0161333429223,4031.9838666570777,8000,-1.5329389479016965E+21,null,1.1371898731127597E+21,-3.9574907478893763E+20,3.9574907478893763E+20]
[118,709134.2460826952,3990.4518734604126,4009.5481265395874,8000,-2.0664111363933628E+21,null,1.5329389479016973E+21,-5.3347218849166629E+20,5.3347218849166629E+20]
[119,705143.79420923477,4013.0144685144014,3986.9855314855986,8000,-2.785534929786608E+21,null,2.0664111363933636E+21,-7.1912379339324509E+20,7.1912379339324509E+20]
[120,701130.77974072041,4035.7046357611425,3964.2953642388575,8000,-3.7549182291980436E+21,null,2.7855349297866085E+21,-9.6938329941143559E+20,9.6938329941143559E+20]
[121,697095.07510495931,4058.5230965123615,3941.4769034876385,8000,-5.061652882968474E+21,null,3.7549182291980441E+21,-1.3067346537704307E+21,1.3067346537704307E+21]
[122,693036.552008447,4081.470576158184,3918.529423841816,8000,-6.8231392386765575E+21,null,5.0616528829684751E+21,-1.7614863557080834E+21,1.7614863557080834E+21]
[123,688955.08143228886,4104.5478041901988,3895.4521958098007,8000,-9.1976336874101832E+21,null,6.8231392386765585E+21,-2.3744944487336258E+21,2.3744944487336258E+21]
[124,684850.53362809867,4127.7555142246456,3872.2444857753544,8000,-1.2398466818360182E+22,null,9.1976336874101843E+21,-3.2008331309499978E+21,3.2008331309499978E+21]
[125,680722.77811387402,4151.0944440257354,3848.9055559742646,8000,-1.6713209578719652E+22,null,1.2398466818360182E+22,-4.3147427603594708E+21,4.3147427603594708E+21]
[126,676571.68366984825,4174.565335529107,3825.4346644708926,8000,-2.2529509375188268E+22,null,1.6713209578719652E+22,-5.8162997964686135E+21,5.8162997964686135E+21]
[127,672397.11833431909,4198.1689348654118,3801.8310651345882,8000,-3.0369917297810853E+22,null,2.2529509375188268E+22,-7.8404079226225856E+21,7.8404079226225856E+21]
[128,668198.9493994537,4221.9059923840287,3778.0940076159713,8000,-4.0938835432059351E+22,null,3.0369917297810853E+22,-1.0568918134248501E+22,1.0568918134248501E+22]
[129,663977.04340706964,4245.7772626769256,3754.2227373230739,8000,-5.5185802124461106E+22,null,4.0938835432059351E+22,-1.4246966692401757E+22,1.4246966692401757E+22]
[130,659731.26614439266,4269.7835046026412,3730.2164953973588,8000,-7.4390800910161092E+22,null,5.5185802124461106E+22,-1.9204998785699987E+22,1.9204998785699987E+22]
[131,655461.48263979005,4293.9254813104089,3706.0745186895911,8000,-1.0027925747231793E+23,null,7.4390800910161092E+22,-2.5888456562156826E+22,2.5888456562156826E+22]
[132,651167.55715847958,4318.2039602644227,3681.7960397355773,8000,-1.3517705625112961E+23,null,1.0027925747231793E+23,-3.4897798778811685E+22,3.4897798778811685E+22]
[133,646849.35319821513,4342.6197132682273,3657.3802867317727,8000,-1.8221950378686512E+23,null,1.3517705625112961E+23,-4.7042447535735516E+22,4.7042447535735516E+22]
[134,642506.73348494689,4367.173516489258,3632.826483510742,8000,-2.4563301259235614E+23,null,1.8221950378686512E+23,-6.3413508805491008E+22,6.3413508805491008E+22]
[135,638139.55996845767,4391.8661504835145,3608.133849516486,8000,-3.3111481274676668E+23,null,2.4563301259235614E+23,-8.5481800154410545E+22,8.5481800154410545E+22]
[136,633747.69381797418,4416.6984002203717,3583.3015997796283,8000,-4.463448054609666E+23,null,3.3111481274676668E+23,-1.1522999271419994E+23,1.1522999271419994E+23]
[137,629330.99541775382,4441.6710551075375,3558.3289448924625,8000,-6.0167554483390763E+23,null,4.463448054609666E+23,-1.5533073937294099E+23,1.5533073937294099E+23]
[138,624889.32436264632,4466.7849090161453,3533.2150909838547,8000,-8.1106233750677781E+23,null,6.0167554483390763E+23,-2.0938679267287015E+23,2.0938679267287015E+23]
[139,620422.53945363022,4492.0407603059903,3507.9592396940097,8000,-1.093317022721191E+24,null,8.1106233750677781E+23,-2.8225468521441315E+23,2.8225468521441315E+23]
[140,615930.49869332428,4517.4394118509099,3482.5605881490897,8000,-1.4737980755541371E+24,null,1.093317022721191E+24,-3.8048105283294615E+23,3.8048105283294615E+23]
[141,611413.0592814734,4542.9816710643099,3457.0183289356901,8000,-1.9866888764806005E+24,null,1.4737980755541371E+24,-5.128908009264634E+23,5.128908009264634E+23]
[142,606870.07761040912,4568.6683499248247,3431.3316500751753,8000,-2.6780688327658003E+24,null,1.9866888764806005E+24,-6.9137995628519978E+23,6.9137995628519978E+23]
[143,602301.40926048427,4594.500265002137,3405.499734997863,8000,-3.6100532690034466E+24,null,2.6780688327658003E+24,-9.3198443623764614E+23,9.3198443623764614E+23]
[144,597706.90899548214,4620.478237482931,3379.521762517069,8000,-4.866374025040668E+24,null,3.6100532690034466E+24,-1.2563207560372211E+24,1.2563207560372211E+24]
[145,593086.43075799919,4646.6030931970017,3353.3969068029983,8000,-6.5599021363271467E+24,null,4.866374025040668E+24,-1.6935281112864793E+24,1.6935281112864793E+24]
[146,588439.8276648022,4672.8756626435043,3327.1243373564957,8000,-8.8427884533248237E+24,null,6.5599021363271467E+24,-2.2828863169976773E+24,2.2828863169976773E+24]
[147,583766.95200215874,4699.2967810173577,3300.7032189826418,8000,-1.1920133258883604E+25,null,8.8427884533248237E+24,-3.0773448055587804E+24,3.0773448055587804E+24]
[148,579067.65522114141,4725.867288235796,3274.132711764204,8000,-1.6068412996594803E+25,null,1.1920133258883604E+25,-4.1482797377111987E+24,4.1482797377111987E+24]
[149,574341.7879329056,4752.588028965064,3247.411971034936,8000,-2.166031961402068E+25,null,1.6068412996594803E+25,-5.5919066174258766E+24,5.5919066174258766E+24]
[150,569589.19990394055,4779.4598526472746,3220.5401473527259,8000,-2.9198244150244008E+25,null,2.166031961402068E+25,-7.5379245362233273E+24,7.5379245362233273E+24]
[151,564809.74005129328,4806.4836135274081,3193.5163864725919,8000,-3.935941281796288E+25,null,2.9198244150244008E+25,-1.0161168667718875E+25,1.0161168667718875E+25]
[152,560003.2564377659,4833.6601706804731,3166.3398293195269,8000,-5.3056730719948942E+25,null,3.935941281796288E+25,-1.3697317901986062E+25,1.3697317901986062E+25]
[153,555169.59626708541,4860.990388038811,3139.009611961189,8000,-7.1520799553301622E+25,null,5.3056730719948942E+25,-1.8464068833352684E+25,1.8464068833352684E+25]
[154,550308.6058790466,4888.475134419562,3111.524865580438,8000,-9.6410477979568817E+25,null,7.1520799553301622E+25,-2.4889678426267191E+25,2.4889678426267191E+25]
[155,545420.13074462709,4916.1152835522853,3083.8847164477147,8000,-1.2996191768412408E+26,null,9.6410477979568817E+25,-3.3551439704555262E+25,3.3551439704555262E+25]
[156,540504.01546107477,4943.9117141067354,3056.0882858932646,8000,-1.7518946490146406E+26,null,1.2996191768412408E+26,-4.5227547217339964E+25,4.5227547217339964E+25]
[157,535560.10374696809,4971.8653097207898,3028.1346902792097,8000,-2.3615647690777732E+26,null,1.7518946490146406E+26,-6.0967012006313252E+25,6.0967012006313252E+25]
[158,530588.23843724735,4999.9769590285487,3000.0230409714518,8000,-3.1834038431969371E+26,null,2.3615647690777732E+26,-8.218390741191639E+25,8.218390741191639E+25]
[159,525588.26147821883,5028.247555688572,2971.752444311428,8000,-4.2912479731980987E+26,null,3.1834038431969371E+26,-1.1078441300011613E+26,1.1078441300011613E+26]
[160,520560.01392253028,5056.6779984123004,2943.3220015876996,8000,-5.7846286787741311E+26,null,4.2912479731980987E+26,-1.4933807055760321E+26,1.4933807055760321E+26]
[161,515503.335924118,5085.2691909926161,2914.7308090073834,8000,-7.797715061047447E+26,null,5.7846286787741311E+26,-2.0130863822733163E+26,2.0130863822733163E+26]
[162,510418.06673312536,5114.0220423325818,2885.9779576674182,8000,-1.0511367894087845E+27,null,7.797715061047447E+26,-2.7136528330403985E+26,2.7136528330403985E+26]
[163,505304.0446907928,5142.9374664743254,2857.0625335256746,8000,-1.4169388614466641E+27,null,1.0511367894087845E+27,-3.6580207203787958E+26,3.6580207203787958E+26]
[164,500161.10722431849,5172.016382628105,2827.983617371895,8000,-1.9100423059181626E+27,null,1.4169388614466641E+27,-4.9310344447149841E+26,4.9310344447149841E+26]
[165,494989.09084169037,5201.259715201526,2798.7402847984736,8000,-2.5747487839188598E+27,null,1.9100423059181626E+27,-6.6470647800069683E+26,6.6470647800069683E+26]
[166,489787.83112648886,5230.6683938289298,2769.3316061710702,8000,-3.4707772072644789E+27,null,2.5747487839188598E+27,-8.9602842334561945E+26,8.9602842334561945E+26]
[167,484557.16273265996,5260.2433534009442,2739.7566465990558,8000,-4.678629036628469E+27,null,3.4707772072644789E+27,-1.20785182936399E+27,1.20785182936399E+27]
[168,479296.91937925899,5289.9855340942049,2710.0144659057946,8000,-6.3068207364527088E+27,null,4.678629036628469E+27,-1.6281916998242394E+27,1.6281916998242394E+27]
[169,474006.93384516478,5319.8958814012449,2680.1041185987551,8000,-8.5016331686799873E+27,null,6.3068207364527088E+27,-2.194812432227278E+27,2.194812432227278E+27]
[170,468687.03796376352,5349.975346160546,2650.024653839454,8000,-1.1460253835508979E+28,null,8.5016331686799873E+27,-2.9586206668289913E+27,2.9586206668289913E+27]
[171,463337.06261760299,5380.2248845867716,2619.7751154132284,8000,-1.5448492703513161E+28,null,1.1460253835508979E+28,-3.9882388680041821E+27,3.9882388680041821E+27]
[172,457956.83773301623,5410.6454583011609,2589.3545416988391,8000,-2.0824663243586878E+28,null,1.5448492703513161E+28,-5.3761705400737172E+27,5.3761705400737172E+27]
[173,452546.19227471505,5441.2380343620998,2558.7619656379002,8000,-2.8071774219770819E+28,null,2.0824663243586878E+28,-7.2471109761839407E+27,7.2471109761839407E+27]
[174,447104.95424035296,5472.0035852958626,2527.9964147041378,8000,-3.7840924418716257E+28,null,2.8071774219770819E+28,-9.7691501989454372E+27,9.7691501989454372E+27]
[175,441632.95065505709,5502.9430891275279,2497.0569108724721,8000,-5.1009799012079924E+28,null,3.7840924418716257E+28,-1.3168874593363669E+28,1.3168874593363669E+28]
[176,436130.00756592955,5534.0575294120717,2465.9424705879278,8000,-6.8761523013053875E+28,null,5.1009799012079924E+28,-1.7751724000973949E+28,1.7751724000973949E+28]
[177,430595.95003651746,5565.3478952656333,2434.6521047343667,8000,-9.2690956221078964E+28,null,6.8761523013053875E+28,-2.3929433208025094E+28,2.3929433208025094E+28]
[178,425030.60214125185,5596.8151813969544,2403.1848186030452,8000,-1.2494797946152126E+29,null,9.2690956221078964E+28,-3.2257023240442303E+28,3.2257023240442303E+28]
[179,419433.78695985489,5628.4603881390103,2371.5396118609897,8000,-1.684306453186249E+29,null,1.2494797946152126E+29,-4.3482665857103644E+28,4.3482665857103644E+28]
[180,413805.32657171588,5660.2845214808003,2339.7154785192001,8000,-2.2704554651229752E+29,null,1.684306453186249E+29,-5.8614901193672621E+28,5.8614901193672621E+28]
[181,408145.04205023509,5692.2885930993316,2307.7114069006684,8000,-3.0605879407247954E+29,null,2.2704554651229752E+29,-7.9013247560182011E+28,7.9013247560182011E+28]
[182,402452.75345713575,5724.4736203917837,2275.5263796082158,8000,-4.1256913807832322E+29,null,3.0605879407247954E+29,-1.0651034400584369E+29,1.0651034400584369E+29]
[183,396728.27983674395,5756.8406265078456,2243.1593734921544,8000,-5.5614573732647379E+29,null,4.1256913807832322E+29,-1.4357659924815055E+29,1.4357659924815055E+29]
[184,390971.43921023613,5789.3906403822421,2210.6093596177579,8000,-7.4968787676912762E+29,null,5.5614573732647379E+29,-1.9354213944265384E+29,1.9354213944265384E+29]
[185,385182.04856985388,5822.1246967674469,2177.8753032325535,8000,-1.0105838719117496E+30,null,7.4968787676912762E+29,-2.608959951426219E+29,2.608959951426219E+29]
[186,379359.92387308646,5855.0438362665718,2144.9561637334277,8000,-1.3622732790737855E+30,null,1.0105838719117496E+30,-3.5168940716203582E+29,3.5168940716203582E+29]
[187,373504.8800368199,5888.149105366454,2111.8508946335455,8000,-1.8363527644348777E+30,null,1.3622732790737855E+30,-4.7407948536109224E+29,4.7407948536109224E+29]
[188,367616.73093145347,5921.4415564709161,2078.5584435290834,8000,-2.4754148284699401E+30,null,1.8363527644348777E+30,-6.3906206403506231E+29,6.3906206403506231E+29]
[189,361695.28937498253,5954.922247934227,2045.0777520657732,8000,-3.3368744239588437E+30,null,2.4754148284699401E+30,-8.6145959548890357E+29,8.6145959548890357E+29]
[190,355740.36712704832,5988.5922440947415,2011.4077559052589,8000,-4.4981272606147669E+30,null,3.3368744239588437E+30,-1.1612528366559233E+30,1.1612528366559233E+30]
[191,349751.77488295356,6022.4526153087409,1977.5473846912596,8000,-6.0635032314704985E+30,null,4.4981272606147669E+30,-1.5653759708557316E+30,1.5653759708557316E+30]
[192,343729.32226764481,6056.5044379844549,1943.4955620155447,8000,-8.1736396744427142E+30,null,6.0635032314704985E+30,-2.1101364429722152E+30,2.1101364429722152E+30]
[193,337672.81782966037,6090.7487946162846,1909.2512053837156,8000,-1.1018116586609268E+31,null,8.1736396744427142E+30,-2.8444769121665536E+30,2.8444769121665536E+30]
[194,331582.06903504411,6125.1867738192086,1874.8132261807918,8000,-1.4852488970819643E+31,null,1.1018116586609268E+31,-3.8343723842103747E+30,3.8343723842103747E+30]
[195,325456.88226122491,6159.8194703633944,1840.180529636606,8000,-2.0021246543753066E+31,null,1.4852488970819643E+31,-5.1687575729334225E+30,5.1687575729334225E+30]
[196,319297.06279086153,6194.6479852089979,1805.3520147910017,8000,-2.6988763563688608E+31,null,2.0021246543753066E+31,-6.9675170199355413E+30,6.9675170199355413E+30]
[197,313102.41480565252,6229.6734255411666,1770.326574458833,8000,-3.6381019388823E+31,null,2.6988763563688608E+31,-9.3922558251343931E+30,9.3922558251343931E+30]
[198,306872.74138011137,6264.8969048052313,1735.1030951947682,8000,-4.9041838046656294E+31,null,3.6381019388823E+31,-1.2660818657833294E+31,1.2660818657833294E+31]
[199,300607.84447530616,6300.319542742106,1699.6804572578942,8000,-6.6108699519655624E+31,null,4.9041838046656294E+31,-1.7066861472999325E+31,1.7066861472999325E+31]
[200,294307.52493256406,6335.9424654238801,1664.0575345761197,8000,-8.9114933824917881E+31,null,6.6108699519655624E+31,-2.3006234305262253E+31,2.3006234305262253E+31]
[201,287971.58246714016,6371.7668052896224,1628.233194710378,8000,-1.2012747926251843E+32,null,8.9114933824917881E+31,-3.1012545437600544E+31,3.1012545437600544E+31]
[202,281599.81566185056,6407.7937011813719,1592.2062988186278,8000,-1.6193258138213169E+32,null,1.2012747926251843E+32,-4.1805102119613254E+31,4.1805102119613254E+31]
[203,275192.0219606692,6444.024298380351,1555.9757016196486,8000,-2.1828611633293806E+32,null,1.6193258138213169E+32,-5.635353495080637E+31,5.635353495080637E+31]
[204,268747.99766228884,6480.4597486433668,1519.5402513566337,8000,-2.9425102827993786E+32,null,2.1828611633293806E+32,-7.5964911946999784E+31,7.5964911946999784E+31]
[205,262267.53791364544,6517.1012102394234,1482.8987897605762,8000,-3.9665219711793385E+32,null,2.9425102827993786E+32,-1.0240116883799598E+32,1.0240116883799598E+32]
[206,255750.43670340601,6553.9498479865524,1446.0501520134476,8000,-5.3468960294950736E+32,null,3.9665219711793385E+32,-1.3803740583157354E+32,1.3803740583157354E+32]
[207,249196.48685541947,6591.0068332888313,1408.9931667111689,8000,-7.2076487557511061E+32,null,5.3468960294950736E+32,-1.8607527262560329E+32,1.8607527262560329E+32]
[208,242605.48002213065,6628.2733441736273,1371.7266558263723,8000,-9.7159548829279009E+32,null,7.2076487557511061E+32,-2.5083061271767954E+32,2.5083061271767954E+32]
[209,235977.20667795703,6665.7505653290482,1334.2494346709518,8000,-1.3097166979976284E+33,null,9.7159548829279009E+32,-3.3812120970483822E+32,3.3812120970483822E+32]
[210,229311.45611262799,6703.4396881415978,1296.5603118584024,8000,-1.7655061696796269E+33,null,1.3097166979976284E+33,-4.5578947168199869E+32,4.5578947168199869E+32]
[211,222608.01642448638,6741.3419107340524,1258.6580892659472,8000,-2.3799131827076027E+33,null,1.7655061696796269E+33,-6.1440701302797583E+32,6.1440701302797583E+32]
[212,215866.67451375234,6779.4584380035521,1220.5415619964483,8000,-3.2081376176970439E+33,null,2.3799131827076027E+33,-8.2822443498944118E+32,8.2822443498944118E+32]
[213,209087.21607574879,6817.7904816598948,1182.2095183401048,8000,-4.3245892534506634E+33,null,3.2081376176970439E+33,-1.1164516357536195E+33,1.1164516357536195E+33]
[214,202269.42559408888,6856.3392602640679,1143.6607397359319,8000,-5.8295729297567405E+33,null,4.3245892534506634E+33,-1.5049836763060771E+33,1.5049836763060771E+33]
[215,195413.08633382482,6895.1059992669761,1104.8940007330241,8000,-7.8583001879857703E+33,null,5.8295729297567405E+33,-2.0287272582290292E+33,2.0287272582290292E+33]
[216,188517.98033455783,6934.0919310484014,1065.9080689515984,8000,-1.0593037018077763E+34,null,7.8583001879857703E+33,-2.7347368300919924E+33,2.7347368300919924E+33]
[217,181583.88840350942,6973.2982949561829,1026.7017050438169,8000,-1.4279479096245617E+34,null,1.0593037018077763E+34,-3.6864420781678551E+33,3.6864420781678551E+33]
[218,174610.59010855324,7012.7263373456108,987.27366265438923,8000,-1.9248825706182264E+34,null,1.4279479096245617E+34,-4.9693466099366471E+33,4.9693466099366471E+33]
[219,167597.86377120763,7052.3773116190487,947.6226883809511,8000,-2.594753552070398E+34,null,1.9248825706182264E+34,-6.6987098145217184E+33,6.6987098145217184E+33]
[220,160545.48645958857,7092.2524782657811,907.74752173421859,8000,-3.4977437578540443E+34,null,2.594753552070398E+34,-9.0299020578364639E+33,9.0299020578364639E+33]
[221,153453.23398132279,7132.3531049020812,867.64689509791845,8000,-4.7149801127914622E+34,null,3.4977437578540443E+34,-1.2172363549374176E+34,1.2172363549374176E+34]
[222,146320.88087642071,7172.680466311509,827.31953368849065,8000,-6.3558222108466576E+34,null,4.7149801127914622E+34,-1.6408420980551955E+34,1.6408420980551955E+34]
[223,139148.20041010919,7213.2358444854362,786.76415551456353,8000,-8.5676874577473709E+34,null,6.3558222108466576E+34,-2.2118652469007133E+34,2.2118652469007133E+34]
[224,131934.96456562376,7254.0205286638002,745.97947133619982,8000,-1.1549295423709359E+35,null,8.5676874577473709E+34,-2.9816079659619886E+34,2.9816079659619886E+34]
[225,124680.94403695996,7295.0358153760881,704.96418462391227,8000,-1.556852131242239E+35,null,1.1549295423709359E+35,-4.019225888713031E+34,4.019225888713031E+34]
[226,117385.90822158387,7336.2830084825528,663.71699151744724,8000,-2.0986462547124268E+35,null,1.556852131242239E+35,-5.4179412347018786E+34,5.4179412347018786E+34]
[227,110049.62521310132,7377.7634192156638,622.23658078433596,8000,-2.8289880676748773E+35,null,2.0986462547124268E+35,-7.3034181296245062E+34,7.3034181296245062E+34]
[228,102671.86179388565,7419.4783662217897,580.52163377821034,8000,-3.8134933265079946E+35,null,2.8289880676748773E+35,-9.8450525883311727E+34,9.8450525883311727E+34]
[229,95252.383427663852,7461.4291756031162,538.57082439688406,8000,-5.1406124746484225E+35,null,3.8134933265079946E+35,-1.327119148140428E+35,1.327119148140428E+35]
[230,87790.954252060736,7503.6171809598036,496.38281904019664,8000,-6.9295772542256153E+35,null,5.1406124746484225E+35,-1.7889647795771932E+35,1.7889647795771932E+35]
[231,80287.337071100934,7546.0437234323817,453.95627656761781,8000,-9.341112787453434E+35,null,6.9295772542256153E+35,-2.4115355332278183E+35,2.4115355332278183E+35]
[232,72741.293347668558,7588.7101517443862,411.28984825561412,8000,-1.2591877528274561E+36,null,9.341112787453434E+35,-3.2507647408211273E+35,3.2507647408211273E+35]
[233,65152.58319592417,7631.6178222452272,368.38217775477301,8000,-1.6973928406049265E+36,null,1.2591877528274561E+36,-4.3820508777747039E+35,4.3820508777747039E+35]
[234,57520.965373678941,7674.7680989533146,325.23190104668527,8000,-2.2880959959047967E+36,null,1.6973928406049265E+36,-5.9070315529987036E+35,5.9070315529987036E+35]
[235,49846.197274725622,7718.1623535994167,281.8376464005832,8000,-3.0843674847890537E+36,null,2.2880959959047967E+36,-7.9627148888425678E+35,7.9627148888425678E+35]
[236,42128.034921126207,7761.8019656702663,238.19803432973404,8000,-4.1577463525353698E+36,null,3.0843674847890537E+36,-1.073378867746316E+36,1.073378867746316E+36]
[237,34366.23295545594,7805.6883224524136,194.31167754758633,8000,-5.6046676724720616E+36,null,4.1577463525353698E+36,-1.4469213199366912E+36,1.4469213199366912E+36]
[238,26560.544633003527,7849.8228190763311,150.1771809236688,8000,-7.5551265169647383E+36,null,5.6046676724720616E+36,-1.9504588444926767E+36,1.9504588444926767E+36]
[239,18710.721813927194,7894.2068585607603,105.79314143923968,8000,-1.0184357043629561E+37,null,7.5551265169647383E+36,-2.6292305266648229E+36,2.6292305266648229E+36]
[240,10816.514955366434,7938.8418518573144,61.158148142685285,8000,-1.3728575975428784E+37,null,1.0184357043629561E+37,-3.5442189317992231E+36,3.5442189317992231E+36]
[null,2877.6731035091198]

{"sheet":"Cuota mixta 5años","index":4,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":true,"merged":[[4,0,4,2],[5,0,5,2],[1,0,1,2],[2,0,2,2],[3,0,3,2]]}
["Cálculo de abono mensual de Interés + Capital:"]
["CAPITAL INICIAL",null,null,280000]
["Tasa 12 meses (TEA)",null,null,6.5000000000000002E-2]
["Dscto.Capital mes1",null,null,1527]
["Abono Mensual Solicitado (Interés+Capital)",null,null,{"$f":"+E11","v":3000.2743975173698}]
["CAPITAL remanente al final del periodo",null,null,{"$f":"IF(B71>0,B71,\"CAPITAL INSUFICIENTE\")","v":172596.88889142172}]
[]
[null,null,null,"Datos variables"]
[]
["MES","CAPITAL","Dscto.K","Interes mes","Abono Mensual"]
[1,{"$f":"+D2","v":280000},{"$f":"+D4","v":1527},{"$f":"((1+$D$3)^(30/360)-1)*B11","v":1473.2743975173701},{"$f":"+D11+C11","v":3000.2743975173698}]
[2,{"$f":"+B11-C11","v":278473},{"$f":"(E11-D12)","v":1535.0346071607462},{"$f":"((1+$D$3)^(30/360)-1)*B12","v":1465.2397903566236},{"$f":"+D12+C12","v":3000.2743975173698}]
[3,{"$f":"+B12-C12","v":276937.96539283928},{"$f":"(E12-D13)","v":1543.1114899680069},1457.1629075493629,3000.2743975173698]
[4,275394.85390287125,1551.2308708633097,1449.0435266540601,3000.2743975173698]
[5,273843.62303200795,1559.3929734586009,1440.881424058769,3000.2743975173698]
[6,272284.23005854932,1567.5980225424046,1432.6763749749653,3000.2743975173698]
[7,270716.63203600689,1575.8462440860139,1424.4281534313559,3000.2743975173698]
[8,269140.78579192091,1584.1378652497133,1416.1365322676565,3000.2743975173698]
[9,267556.6479266712,1592.4731143890356,1407.8012831283343,3000.2743975173698]
[10,265964.17481228214,1600.8522210610502,1399.4221764563197,3000.2743975173698]
[11,264363.32259122108,1609.2754160306863,1390.9989814866835,3000.2743975173698]
[12,262754.04717519041,1617.7429312770867,1382.5314662402832,3000.2743975173698]
[13,261136.30424391333,1626.2549999999981,1374.0193975173718,3000.2743975173698]
[14,259510.04924391332,1634.8118566261933,1365.4625408911766,3000.2743975173698]
[15,257875.23738728714,1643.4137368159261,1356.8606607014437,3000.2743975173698]
[16,256231.82365047123,1652.0608774694233,1348.2135200479465,3000.2743975173698]
[17,254579.7627730018,1660.7535167334083,1339.5208807839615,3000.2743975173698]
[18,252919.00925626839,1669.4918940076593,1330.7825035097105,3000.2743975173698]
[19,251249.51736226073,1678.2762499516032,1321.9981475657667,3000.2743975173698]
[20,249571.24111230913,1687.1068264909429,1313.1675710264269,3000.2743975173698]
[21,247884.13428581817,1695.9838668243212,1304.2905306930486,3000.2743975173698]
[22,246188.15041899384,1704.9076154300169,1295.3667820873529,3000.2743975173698]
[23,244483.24280356383,1713.8783180726791,1286.3960794446907,3000.2743975173698]
[24,242769.36448549115,1722.8962218100955,1277.3781757072743,3000.2743975173698]
[25,241046.46826368105,1731.9615749999964,1268.3128225173734,3000.2743975173698]
[26,239314.50668868105,1741.0746273068942,1259.1997702104757,3000.2743975173698]
[27,237573.43206137416,1750.2356297089596,1250.0387678084103,3000.2743975173698]
[28,235823.19643166519,1759.4448345049343,1240.8295630124355,3000.2743975173698]
[29,234063.75159716024,1768.7024953210782,1231.5719021962916,3000.2743975173698]
[30,232295.04910183916,1778.0088671181556,1222.2655303992142,3000.2743975173698]
[31,230517.040234721,1787.3642061984558,1212.910191318914,3000.2743975173698]
[32,228729.67602852255,1796.7687702128526,1203.5056273045172,3000.2743975173698]
[33,226932.90725830969,1806.2228181679004,1194.0515793494694,3000.2743975173698]
[34,225126.68444014178,1815.7266104329663,1184.5477870844036,3000.2743975173698]
[35,223310.95782970882,1825.2804087474017,1174.9939887699682,3000.2743975173698]
[36,221485.67742096141,1834.8844762277502,1165.3899212896197,3000.2743975173698]
[37,219650.79294473366,1844.5390773749946,1155.7353201423753,3000.2743975173698]
[38,217806.25386735867,1854.2444780818405,1146.0299194355293,3000.2743975173698]
[39,215952.00938927682,1864.0009456400403,1136.2734518773295,3000.2743975173698]
[40,214088.00844363679,1873.8087487477533,1126.4656487696166,3000.2743975173698]
[41,212214.19969488904,1883.6681575169466,1116.6062400004232,3000.2743975173698]
[42,210330.5315373721,1893.5794434808338,1106.694954036536,3000.2743975173698]
[43,208436.95209389128,1903.5428796013534,1096.7315179160164,3000.2743975173698]
[44,206533.40921428992,1913.5587402766862,1086.7156572406836,3000.2743975173698]
[45,204619.85047401322,1923.6273013488121,1076.6470961685577,3000.2743975173698]
[46,202696.22317266441,1933.7488401111073,1066.5255574062626,3000.2743975173698]
[47,200762.47433255331,1943.9236353159806,1056.3507622013892,3000.2743975173698]
[48,198818.55069723731,1954.151967182552,1046.1224303348179,3000.2743975173698]
[49,196864.39873005476,1964.4341174043673,1035.8402801130026,3000.2743975173698]
[50,194899.96461265039,1974.7703691571583,1025.5040283602116,3000.2743975173698]
[51,192925.19424349323,1985.1610071066409,1015.1133904107289,3000.2743975173698]
[52,190940.03323638657,1995.6063174163555,1004.6680801010144,3000.2743975173698]
[53,188944.42691897022,2006.1065877555461,994.16780976182361,3000.2743975173698]
[54,186938.32033121467,2016.6621073070862,983.61229021028362,3000.2743975173698]
[55,184921.65822390758,2027.2731667754397,973.00123074193027,3000.2743975173698]
[56,182894.38505713214,2037.940058394669,962.33433912270084,3000.2743975173698]
[57,180856.44499873748,2048.663075936483,951.61132158088697,3000.2743975173698]
[58,178807.78192280099,2059.4425147183274,940.83188279904266,3000.2743975173698]
[59,176748.33940808265,2070.2786716115179,929.99572590585217,3000.2743975173698]
[60,174678.06073647115,2081.1718450494159,919.10255246795396,3000.2743975173698]
[null,172596.88889142172]

{"sheet":"Cuota mixta","index":5,"n_rows":70,"n_cols":11,"rows_kept":70,"cut":false,"hidden":true,"merged":[[6,6,6,8],[5,6,5,8],[7,6,7,8],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,2],[1,6,1,8],[2,6,2,8],[3,6,3,8],[4,6,4,8]]}
["Cálculo de abono mensual de Interés + Capital:",null,null,null,null,null,"Pre-Cancelación de abono mensual de Interés + Capital:"]
["CAPITAL",null,null,600000,null,null,"CAPITAL",null,null,{"$f":"+D2","v":600000}]
["Tasa 12 meses (TEA)",null,null,7.0000000000000007E-2,null,null,"Tasa 12 meses (TEA) penalidad",null,null,1.2500000000000001E-2]
["Dscto.Capital mes1",null,null,6607.5127675568365,null,null,"Dscto.Capital mes1",null,null,9378.5523911809851]
["Abono Mensual Solicitado (Interés+Capital)",null,null,{"$f":"+E11","v":10000},null,null,"Abono Mensual Solicitado (Interés+Capital)",null,null,{"$f":"+K11","v":10000}]
["CAPITAL remanente al final del periodo",null,null,{"$f":"+B47","v":337011.62706895394},null,null,"CAPITAL remanente sin penalidad",null,null,{"$f":"+H23","v":486814.04202756856}]
[null,null,null,null,null,null,"Dscto. del Capital por Penalidad",null,null,{"$f":"+B23-H23","v":31382.986517317477}]
[null,null,null,null,null,null,"CAPITAL neto",null,null,{"$f":"+J6-J7","v":455431.05551025108}]
[]
["MES","CAPITAL","Dscto.K","Interes mes","Abono Mensual",null,"MES","CAPITAL","Dscto.K","Interes mes","Abono Mensual"]
[1,{"$f":"+D2","v":600000},{"$f":"+D4","v":6607.5127675568365},{"$f":"((1+$D$3)^(30/360)-1)*B11","v":3392.4872324431644},{"$f":"+D11+C11","v":10000},null,1,{"$f":"+J2","v":600000},{"$f":"+J4","v":9378.5523911809851},{"$f":"((1+$J$3)^(30/360)-1)*H11","v":621.44760881901459},{"$f":"+J11+I11","v":10000}]
[2,{"$f":"+B11-C11","v":593392.48723244318},{"$f":"(E11-D12)","v":6644.8726053937389},{"$f":"((1+$D$3)^(30/360)-1)*B12","v":3355.1273946062615},{"$f":"+D12+C12","v":10000},null,2,{"$f":"+H11-I11","v":590621.447608819},{"$f":"(K11-J12)","v":9388.2661894437915},{"$f":"((1+$J$3)^(30/360)-1)*H12","v":611.73381055620916},{"$f":"+J12+I12","v":10000}]
[3,{"$f":"+B12-C12","v":586747.61462704942},{"$f":"(E12-D13)","v":6682.4436811854212},3317.5563188145788,10000,null,3,{"$f":"+H12-I12","v":581233.18141937524},{"$f":"(K12-J13)","v":9397.9900487344348},{"$f":"((1+$J$3)^(30/360)-1)*H13","v":602.00995126556541},{"$f":"+J13+I13","v":10000}]
[4,580065.17094586405,6720.2271893019915,3279.7728106980089,10000,null,4,{"$f":"+H13-I13","v":571835.19137064076},{"$f":"(K13-J14)","v":9407.723979473587},{"$f":"((1+$J$3)^(30/360)-1)*H14","v":592.27602052641384},{"$f":"+J14+I14","v":10000}]
[5,573344.94375656208,6758.2243308666984,3241.7756691333016,10000,null,5,{"$f":"+H14-I14","v":562427.46739116719},{"$f":"(K14-J15)","v":9417.4679920927083},{"$f":"((1+$J$3)^(30/360)-1)*H15","v":582.53200790729193},{"$f":"+J15+I15","v":10000}]
[6,566586.71942569537,6796.4363137941182,3203.5636862058814,10000,null,6,{"$f":"+H15-I15","v":553009.99939907447},{"$f":"(K15-J16)","v":9427.2220970340677},{"$f":"((1+$J$3)^(30/360)-1)*H16","v":572.77790296593253},{"$f":"+J16+I16","v":10000}]
[7,559790.28311190126,6834.8643528285511,3165.1356471714489,10000,null,7,543582.77730204037,9436.9863047507461,563.01369524925326,10000]
[8,552955.41875907267,6873.5096695826378,3126.4903304173622,10000,null,8,534145.79099728959,9446.7606257066545,553.23937429334455,10000]
[9,546081.90908949007,6912.3734925761937,3087.6265074238063,10000,null,9,524699.03037158295,9456.54507037654,543.45492962345963,10000]
[10,539169.53559691389,6951.4570572752655,3048.5429427247341,10000,null,10,515242.48530120641,9466.3396492459979,533.66035075400168,10000]
[11,532218.07853963866,6990.7616061314038,3009.2383938685957,10000,null,11,505776.1456519604,9476.1443728114864,523.85562718851406,10000]
[12,525227.31693350722,7030.2883886211621,2969.7116113788379,10000,null,12,496300.00127914891,9485.9592515803324,514.04074841966826,10000]
[13,{"$f":"+B22-C22","v":518197.02854488604},7070.0386612858138,2929.9613387141862,10000,null,13,486814.04202756856,9495.7842960707476,504.21570392925292,10000]
[14,511126.98988360021,7110.0136877712994,2889.9863122287002,10000,null,14,477318.25773149781,9505.6195168118375,494.38048318816243,10000]
[15,504016.97619582893,7150.2147388684007,2849.7852611315998,10000,null,15,467812.63821468595,9515.4649243436143,484.53507565638563,10000]
[16,496866.76145696052,7190.6430925531304,2809.3569074468696,10000,null,16,458297.17329034233,9525.320529217006,474.67947078299471,10000]
[17,489676.11836440739,7231.3000340273666,2768.699965972633,10000,null,17,448771.85276112531,9535.1863419938654,464.81365800613372,10000]
[18,482444.81833038002,7272.1868557597063,2727.8131442402937,10000,null,18,439236.66641913145,9545.0623732469921,454.93762675300735,10000]
[19,475172.63147462031,7313.3048575265493,2686.6951424734507,10000,null,19,429691.60404588445,9554.9486335601305,445.05136643986953,10000]
[20,467859.32661709376,7354.6553464534218,2645.3446535465782,10000,null,20,420136.6554123243,9564.8451335279879,435.15486647201209,10000]
[21,460504.67127064033,7396.2396370565275,2603.760362943473,10000,null,21,410571.8102787963,9574.7518837562457,425.24811624375349,10000]
[22,453108.43163358379,7438.0590512845338,2561.9409487154658,10000,null,22,400997.05839504005,9584.668894861572,415.33110513842735,10000]
[23,445670.37258229929,7480.1149185606027,2519.8850814393973,10000,null,23,391412.38950017845,9594.5961774716288,405.40382252837117,10000]
[24,438190.25766373868,7522.4085758246438,2477.5914241753567,10000,null,24,381817.79332270683,9604.533742225085,395.46625777491482,10000]
[25,430667.84908791404,7564.9413675758205,2435.0586324241799,10000,null,25,372213.25958048174,9614.4815997716305,385.51840022836927,10000]
[26,423102.9077203382,7607.71464591529,2392.2853540847095,10000,null,26,362598.77798071009,9624.4397607719857,375.56023922801506,10000]
[27,415495.19307442289,7650.7297705891888,2349.2702294108117,10000,null,27,352974.3382199381,9634.4082358979085,365.59176410209108,10000]
[28,407844.46330383368,7693.9881090318495,2306.0118909681505,10000,null,28,343339.92998404021,9644.3870358322165,355.61296416778282,10000]
[29,400150.47519480181,7737.491036409283,2262.508963590717,10000,null,29,333695.54294820799,9654.3761712687883,345.62382873121106,10000]
[30,392412.98415839253,7781.2399356628866,2218.7600643371138,10000,null,30,324041.16677693918,9664.3756529125785,335.62434708742063,10000]
[31,384631.74422272964,7825.2361975534077,2174.7638024465919,10000,null,31,314376.79112402658,9674.385491479632,325.61450852036859,10000]
[32,376806.50802517624,7869.4812207051618,2130.5187792948386,10000,null,32,304702.40563254693,9684.4056976970878,315.59430230291292,10000]
[33,368937.0268044711,7913.9764116504839,2086.0235883495161,10000,null,33,295017.99993484985,9694.4362823031988,305.56371769680106,10000]
[34,361023.05039282062,7958.7231848744514,2041.2768151255484,10000,null,34,285323.56365254667,9704.4772560473411,295.5227439526584,10000]
[35,353064.32720794616,8003.7229628598452,1996.277037140155,10000,null,35,275619.0863964993,9714.5286296900231,285.47137030997646,10000]
[36,345060.60424508632,8048.9771761323682,1951.0228238676314,10000,null,36,265904.5577668093,9724.5904140028979,275.409585997102,10000]
[37,{"$f":"+B46-C46","v":337011.62706895394},{"$f":"(E46-D47)","v":8094.4872633061277},{"$f":"((1+$D$3)^(30/360)-1)*B47","v":1905.5127366938723},{"$f":"+D47+C47","v":10000},null,37,256179.96735280642,9734.6626197687747,265.33738023122464,10000]
[38,328917.13980564784,8140.2546711293608,1859.7453288706392,10000,null,38,246445.30473303763,9744.7452577816348,255.25474221836603,10000]
[39,320776.8851345185,8186.2808545304306,1813.7191454695692,10000,null,39,236700.55947525598,9754.8383388466318,245.16166115336799,10000]
[40,312590.60427998804,8232.5672766640782,1767.4327233359215,10000,null,40,226945.72113640935,9764.9418737801188,235.05812621988082,10000]
[41,304358.03700332396,8279.1154089579322,1720.8845910420678,10000,null,41,217180.77926262922,9775.0558734096485,224.94412659035194,10000]
[42,296078.92159436602,8325.9267311592885,1674.0732688407124,10000,null,42,207405.72338921958,9785.1803485739856,214.81965142601413,10000]
[43,287752.99486320675,8373.0027313821465,1626.9972686178539,10000,null,43,197620.5430406456,9795.3153101231255,204.68468987687396,10000]
[44,279379.99213182461,8420.3449061545216,1579.6550938454777,10000,null,44,187825.22773052249,9805.4607689182994,194.53923108170014,10000]
[45,270959.64722567011,8467.9547604660165,1532.0452395339828,10000,null,45,178019.76696160418,9815.616735831989,184.38326416801189,10000]
[46,262491.69246520411,8515.833807815663,1484.1661921843374,10000,null,46,168204.1502257722,9825.7832217479317,174.21677825206743,10000]
[47,253975.85865738845,8563.983570260034,1436.0164297399667,10000,null,47,158378.36700402427,9835.9602375611485,164.03976243885202,10000]
[48,245411.87508712843,8612.4055784616339,1387.5944215383665,10000,null,48,148542.40676646313,9846.147794177934,153.85220582206654,10000]
[49,236799.46950866681,8661.1013717375554,1338.8986282624442,10000,null,49,138696.2589722852,9856.3459025158845,143.65409748411574,10000]
[50,228138.36813692926,8710.0724981084149,1289.9275018915848,10000,null,50,128839.91306976932,9866.5545735039032,133.44542649609642,10000]
[51,219428.29563882085,8759.3205143475607,1240.6794856524398,10000,null,51,118973.35849626541,9876.7738180822143,123.22618191778589,10000]
[52,210668.97512447331,8808.8469860305631,1191.1530139694371,10000,null,52,109096.58467818319,9887.0036472023694,112.99635279763015,10000]
[53,201860.12813844276,8858.6534875849866,1141.3465124150136,10000,null,53,99209.581030980829,9897.2440718272683,102.75592817273218,10000]
[54,193001.47465085777,8908.7416023404367,1091.2583976595633,10000,null,54,89312.336959153559,9907.4951029311596,92.504897068840137,10000]
[55,184092.73304851732,8959.1129225788954,1040.8870774211046,10000,null,55,79404.841856222396,9917.7567514996645,82.243248500335696,10000]
[56,175133.62012593841,9009.7690495853385,990.23095041466206,10000,null,56,69487.085104722733,9928.0290285297779,71.970971470222182,10000]
[57,166123.85107635308,9060.7115936986374,939.28840630136244,10000,null,57,59559.056076192952,9938.3119450298873,61.688054970112859,10000]
[58,157063.13948265446,9111.9421743627572,888.05782563724188,10000,null,58,49620.744131163068,9948.6055120197816,51.394487980219068,10000]
[59,147951.19730829171,9163.4624201782353,836.53757982176512,10000,null,59,39672.138619143283,9958.909740530662,41.090259469338463,10000]
[60,138787.73488811348,9215.2739689539467,784.72603104605287,10000,null,60,29713.228878612623,9969.2246416051566,30.775358394843177,10000]