{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tx - Incidence arro,dis","Feuil2","Feuil3"],"not_rendered":{"charts":0,"images":0,"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":"Tx - Incidence arro,dis","index":0,"n_rows":156,"n_cols":47,"rows_kept":156,"cut":false,"hidden":false,"merged":[[148,24,148,26],[10,11,10,12],[11,11,11,12],[12,11,12,12],[13,11,13,12],[17,17,18,17],[17,20,18,20],[17,21,18,21],[15,1,15,32],[148,2,148,4],[148,13,148,15],[17,10,18,10],[17,8,18,8],[17,7,18,7],[17,6,18,6],[17,31,18,31],[17,32,18,32],[16,1,16,10],[16,12,16,21],[16,23,16,32],[17,18,18,18],[17,19,18,19],[17,28,18,28],[17,29,18,29],[17,30,18,30],[3,9,4,9],[17,9,18,9],[1,1,1,13],[4,1,4,7],[3,1,3,8],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[6,1,9,5],[6,6,6,21],[7,6,7,10],[7,11,7,16],[7,17,7,21],[8,11,8,12],[9,11,9,12]]}
[]
[null,"Quelle est la bonne méthode de calcul pour vérifier que le taux nominal proportionnel contractuel est bien respecté ?"]
[]
[null,"Sélectionner, ci_dessous, la méthode d'arrondis souhaitée puis cliquer sur le bouton \"Calculs\"      =>       =>       =>       =>       =>  "]
[null,"Arrondis monétaires 2 décimales au plus proche sur échéances seulement",null,null,null,null,null,null,{"$f":"IF(B5=B153,1,IF(B5=B154,2,IF(B5=B155,3,4)))","v":3}]
[]
[null,"Simulations avec un prêt à échéances constantes, un second en deux paliers d'échéances progressifs et un troisième en deux paliers d'échéances dégressifs.\n\nPériodicité régulière mensuelle.\nQuatre méthodes d'arrondis différentes",null,null,null,null,{"$f":"B5","v":"Arrondis monétaires 2 décimales au plus proche sur échéances seulement"}]
[null,null,null,null,null,null,"Prêt à échéances constantes et périodicité régulière (= mensuelle)",null,null,null,null,"Prêt en deux paliers progressifs d'échéances - Périodicité régulière (= mensuelle)",null,null,null,null,null,"Prêt en deux paliers dégressifs d'échéances - Périodicité régulière (= mensuelle)"]
[null,null,null,null,null,null,"Moyenne taux proportionnel simple","Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel","Moyenne taux proportionnel simple",null,"Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel","Moyenne taux proportionnel simple","Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel"]
[null,null,null,null,null,null,"Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%",null,"Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"]
[null,"Simulation témoin N° 1 - Sans aucun arrondi",null,null,null,1,1.0000000000000007E-2,9.9999999999999967E-3,9.9999999999988987E-3,1.0045960887181063E-2,9.9999999999988987E-3,1.0000000000000007E-2,null,9.9999999999999967E-3,9.9999999999988987E-3,1.004596088718171E-2,9.9999999999988987E-3,1.0000000000000007E-2,1.0000000000000007E-2,9.9999999999988987E-3,1.0045960887180572E-2,9.9999999999988987E-3]
[null,"Simulation N° 2 - Arrondi monétaire 2 décimales au plus proche sur les échéances, les intérêts, les amortissements et les soldes dus.",null,null,null,2,1.0000152919763812E-2,9.9999766501876579E-3,9.9999760582676345E-3,1.004593672506488E-2,9.9999760582649699E-3,1.0000180180104918E-2,null,1.0000027913709108E-2,1.0000028628026847E-2,1.0045989778728335E-2,1.0000028628026847E-2,9.9997553780864987E-3,1.0000085733608265E-2,1.0000084144639487E-2,1.0046045806371223E-2,1.0000084144639499E-2]
[null,"Simulation N° 3 - Arrondi monétaire 2 décimales au plus proche sur l'échéance seulement",null,null,null,3,1.0000000000000007E-2,9.9999999999999985E-3,9.9999943228308297E-3,1.0045955157756617E-2,9.9999943228334942E-3,1.0000000000000007E-2,null,9.9999999999999985E-3,9.9999987310486205E-3,1.0045959606549772E-2,9.9999987310486205E-3,1.0000000000000007E-2,9.999999999999995E-3,9.9999888678450333E-3,1.004594965255667E-2,9.9999888678450333E-3]
[null,"Simulation N° 4 - Arrondi monétaire 2 décimales au plus proche sur l'échéance et à l'inférieur sur les intérêts",null,null,null,4,9.9963705289572956E-3,9.9988253479760363E-3,9.998843646439326E-3,1.0044793890054589E-2,9.998843646439326E-3,9.9974813267042877E-3,null,9.9989997577344877E-3,9.9990121244335484E-3,1.0044963918716518E-2,9.9990121244362129E-3,9.9939873648030864E-3,9.9983548045058952E-3,9.9983929622666778E-3,1.0044339057931747E-2,9.9983929622693424E-3]
[]
[null,{"$f":"B2","v":"Quelle est la bonne méthode de calcul pour vérifier que le taux nominal proportionnel contractuel est bien respecté ?"}]
[null,"Prêt à échéances constantes",null,null,null,null,null,null,null,null,null,null,"Prêt en deux paliers d'échéances progressifs",null,null,null,null,null,null,null,null,null,null,"Prêt en deux paliers d'échéances dégressifs"]
[null,"Durée","Montant","Taux contractuel",null,null,"Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%",null,"Durée","Montant","Taux contractuel",null,null,"Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%",null,"Durée\nmaxi","Montant","Taux contractuel",null,null,"Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"," Décret N° 2016-607 du 13 mai 2016","Taux à comparer avec le taux nominal proportionnel contractuel de 1,00%"]
[null,120,100000,0.01,null,null,null,null,null,null,null,null,{"$f":"B19","v":120},{"$f":"C19","v":100000},{"$f":"D19","v":0.01},null,null,null,null,null,null,null,null,{"$f":"$M$19","v":120},{"$f":"N19","v":100000},{"$f":"O19","v":0.01}]
[null,"Rang","Échéance","Intérêts","Amortissement","Capital dû","Moyenne taux proportionnel simple","Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel",null,"Rang","Échéance","Intérêts","Amortissement","Capital dû","Moyenne taux proportionnel simple","Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel",null,"Rang","Échéance","Intérêts","Amortissement","Capital dû","Moyenne taux proportionnel simple","Moyenne taux proportionnel pondérée par montant et durée","TRI/TEG proportionnel","Taux débiteur/TAEG actuariel","Conversion Taux débiteur/TAEG actuariel en TRI/TEG proportionnel"]
[null,null,null,null,null,null,{"$f":"(SUM(G26:G145))/B19","v":1.0000000000000007E-2},{"$f":"(SUM(H26:H145))/F146","v":9.9999999999999985E-3},{"$f":"I146*12","v":9.9999943228308297E-3},1.0045955157756728E-2,{"$f":"(((1+J21)^(1/12))-1)*12","v":9.9999943228334942E-3},null,null,null,null,null,null,{"$f":"(SUM(R26:R145))/M19","v":1.0000000000000007E-2},{"$f":"(SUM(S26:S145))/Q146","v":9.9999999999999985E-3},{"$f":"T146*12","v":9.9999987310486205E-3},1.0045959606549604E-2,{"$f":"(((1+U21)^(1/12))-1)*12","v":9.9999987310486205E-3},null,null,{"$f":"-PMT($Z$19/12,60,$Q$85,0,0)","v":1271.3542415108543},null,null,null,{"$f":"(SUM(AC26:AC145))/X19","v":1.0000000000000007E-2},{"$f":"(SUM(AD26:AD145))/AB146","v":9.999999999999995E-3},{"$f":"AE146*12","v":9.9999888678450333E-3},1.0045949652556636E-2,{"$f":"(((1+AF21)^(1/12))-1)*12","v":9.9999888678450333E-3}]
[null,null,null,null,null,null,{"$f":"G149","v":120},{"$f":"H149","v":"Inférieurs au taux contractuel"},null,null,null,null,null,null,null,null,null,{"$f":"R149","v":120},{"$f":"S149","v":"Inférieurs au taux contractuel"},null,null,null,null,null,null,null,null,null,{"$f":"AC149","v":120},{"$f":"AD149","v":"Inférieurs au taux contractuel"}]
[null,null,null,null,null,null,{"$f":"G150","v":0},"Supérieurs au taux contractuel",null,null,null,null,null,null,null,null,null,{"$f":"R150","v":0},"Supérieurs au taux contractuel",null,null,null,null,null,null,null,null,null,{"$f":"AC150","v":0},"Supérieurs au taux contractuel"]
[null,null,null,null,null,null,{"$f":"G151","v":120},"Total",null,null,null,null,null,null,null,null,null,{"$f":"R151","v":120},"Total",null,null,null,null,null,null,null,null,null,{"$f":"AC151","v":120},"Total"]
[null,0,null,null,null,{"$f":"C19","v":100000},"Contrôle taux",null,{"$f":"F25","v":100000},null,null,null,0,null,null,null,{"$f":"N19","v":100000},"Contrôle taux",null,{"$f":"Q25","v":100000},null,null,null,0,null,null,null,{"$f":"Y19","v":100000},"Contrôle taux",null,{"$f":"AB25","v":100000}]
[null,1,{"$f":"IF($I$5=1,-PMT($D$19/12,$B$19,$C$19,0,0),ROUND(-PMT($D$19/12,$B$19,$C$19,0,0),2))","v":876.04},{"$f":"IF(OR($I$5=1,$I$5=3),F25*$D$19/12,IF($I$5=2,ROUND(F25*$D$19/12,2),ROUNDDOWN(F25*$D$19/12,2)))","v":83.333333333333329},{"$f":"IF($I$5<>2,C26-D26,ROUND(C26-D26,2))","v":792.70666666666659},{"$f":"IF($I$5<>2,F25-E26,ROUND(F25-E26,2))","v":99207.293333333335},{"$f":"D26*12/F25","v":0.01},{"$f":"G26*F25","v":1000},{"$f":"-C26","v":-876.04},{"$f":"C26*(1+$J$21)^(-B26/12)","v":875.31057493499452},{"$f":"J26+K27","v":99999.999999999956},null,1,{"$f":"IF($I$5=1,500,ROUND(500,2))","v":500},{"$f":"IF(OR($I$5=1,$I$5=3),Q25*$O$19/12,IF($I$5=2,ROUND(Q25*$O$19/12,2),ROUNDDOWN(Q25*$O$19/12,2)))","v":83.333333333333329},{"$f":"IF($I$5<>2,N26-O26,ROUND(N26-O26,2))","v":416.66666666666669},{"$f":"IF($I$5<>2,Q25-P26,ROUND(Q25-P26,2))","v":99583.333333333328},{"$f":"O26*12/Q25","v":0.01},{"$f":"R26*Q25","v":1000},{"$f":"-N26","v":-500},{"$f":"N26*(1+$U$21)^(-M26/12)","v":499.58368031922964},{"$f":"V27+U26","v":99999.999999999913},null,1,{"$f":"IF($I$5=1,$Y$21,ROUND($Y$21,2))","v":1271.3499999999999},{"$f":"IF(OR($I$5=1,$I$5=3),AB25*$O$19/12,IF($I$5=2,ROUND(AB25*$O$19/12,2),ROUNDDOWN(AB25*$O$19/12,2)))","v":83.333333333333329},{"$f":"IF($I$5<>2,Y26-Z26,ROUND(Y26-Z26,2))","v":1188.0166666666667},{"$f":"IF($I$5<>2,AB25-AA26,ROUND(AB25-AA26,2))","v":98811.983333333337},{"$f":"Z26*12/AB25","v":0.01},{"$f":"AC26*AB25","v":1000},{"$f":"-Y26","v":-1271.3499999999999},{"$f":"Y26*(1+$AF$21)^(-X26/12)","v":1270.2914249909309},{"$f":"AG27+AF26","v":100000.00000000001}]
[null,2,{"$f":"IF($I$5=1,-PMT($D$19/12,$B$19,$C$19,0,0),ROUND(-PMT($D$19/12,$B$19,$C$19,0,0),2))","v":876.04},{"$f":"IF(OR($I$5=1,$I$5=3),F26*$D$19/12,IF($I$5=2,ROUND(F26*$D$19/12,2),ROUNDDOWN(F26*$D$19/12,2)))","v":82.672744444444447},{"$f":"IF($I$5<>2,C27-D27,ROUND(C27-D27,2))","v":793.36725555555552},{"$f":"IF($I$5<>2,F26-E27,ROUND(F26-E27,2))","v":98413.926077777782},{"$f":"D27*12/F26","v":0.01},{"$f":"G27*F26","v":992.07293333333337},{"$f":"-C27","v":-876.04},{"$f":"C27*(1+$J$21)^(-B27/12)","v":874.58175721774194},99124.689425064964,null,2,{"$f":"IF($I$5=1,500,ROUND(500,2))","v":500},{"$f":"IF(OR($I$5=1,$I$5=3),Q26*$O$19/12,IF($I$5=2,ROUND(Q26*$O$19/12,2),ROUNDDOWN(Q26*$O$19/12,2)))","v":82.9861111111111},{"$f":"IF($I$5<>2,N27-O27,ROUND(N27-O27,2))","v":417.01388888888891},{"$f":"IF($I$5<>2,Q26-P27,ROUND(Q26-P27,2))","v":99166.319444444438},{"$f":"O27*12/Q26","v":0.01},{"$f":"R27*Q26","v":995.83333333333326},{"$f":"-N27","v":-500},{"$f":"N27*(1+$U$21)^(-M27/12)","v":499.16770728261247},99500.416319680677,null,2,{"$f":"IF($I$5=1,$Y$21,ROUND($Y$21,2))","v":1271.3499999999999},{"$f":"IF(OR($I$5=1,$I$5=3),AB26*$O$19/12,IF($I$5=2,ROUND(AB26*$O$19/12,2),ROUNDDOWN(AB26*$O$19/12,2)))","v":82.343319444444447},{"$f":"IF($I$5<>2,Y27-Z27,ROUND(Y27-Z27,2))","v":1189.0066805555555},{"$f":"IF($I$5<>2,AB26-AA27,ROUND(AB26-AA27,2))","v":97622.976652777783},{"$f":"Z27*12/AB26","v":0.01},{"$f":"AC27*AB26","v":988.11983333333342},{"$f":"-Y27","v":-1271.3499999999999},{"$f":"Y27*(1+$AF$21)^(-X27/12)","v":1269.233731392213},98729.708575009077]
[null,3,876.04,82.011605064814816,794.02839493518513,97619.897682842595,9.9999999999999985E-3,984.13926077777762,-876.04,873.85354634254088,98250.107667847216,null,3,500,82.638599537037038,417.36140046296293,98748.958043981474,0.01,991.66319444444446,-500,498.7520806015188,99001.248612398063,null,3,1271.3499999999999,81.352480543981486,1189.9975194560184,96432.979133321758,0.01,976.22976652777788,-1271.3499999999999,1268.1769184699497,97460.474843616859]
[null,4,876.04,81.349914735702171,794.69008526429775,96825.207597578294,1.0000000000000002E-2,976.19897682842611,-876.04,873.12594180411099,97376.25412150468,null,4,500,82.290798369984557,417.70920163001546,98331.248842351459,0.01,987.48958043981474,-500,498.33679998755957,98502.49653179654,null,4,1271.3499999999999,80.360815944434805,1190.9891840555651,95241.989949266193,0.01,964.3297913332176,-1271.3499999999999,1267.1209854908564,96192.297925146908]
[null,5,876.04,80.68767299798192,795.352327002018,96029.85527057627,1.0000000000000002E-2,968.2520759757831,-876.04,872.39894309759256,96503.128179700565,null,5,500,81.942707368626216,418.0572926313738,97913.191549720083,0.01,983.31248842351465,-500,497.92186515258578,98004.159731808977,null,5,1271.3499999999999,79.368324957721825,1191.9816750422781,94050.008274223917,0.01,952.4198994926619,-1271.3499999999999,1266.0659317222576,94925.176939656056]
[null,6,876.04,80.0248793921469,796.01512060785308,95233.840149968411,1.0000000000000002E-2,960.29855270576286,-876.04,871.67254971854629,95630.729236602972,null,6,500,81.594326291433404,418.40567370856661,97494.78587601152,0.01,979.13191549720079,-500,497.50727580868784,97506.237866656389,null,6,1271.3499999999999,78.375006895186601,1192.9749931048134,92857.033281119104,0.01,940.50008274223921,-1271.3499999999999,1265.0117564320897,93659.111007933796]
[null,7,876.04,79.361533458307008,796.67846654169296,94437.161683426719,0.01,952.3384014996841,-876.04,870.94676116295307,94759.056686884433,null,7,500,81.245654896676271,418.75434510332371,97076.031530908193,0.01,974.9478587601152,-500,497.0930316681966,97008.730590847699,null,7,1271.3499999999999,77.380861067599255,1193.9691389324007,91663.064142186704,0.01,928.57033281119107,-1271.3499999999999,1263.9584588888974,92394.099251501713]
[null,8,876.04,78.697634736188931,797.34236526381108,93639.819318162903,9.9999999999999985E-3,944.371616834267,-876.04,870.22157692721316,93888.109925721481,null,8,500,80.896692942423499,419.1033070575765,96656.928223850613,0.01,970.76031530908199,-500,496.67913244368208,96511.637559179508,null,8,1271.3499999999999,76.385886785155591,1194.9641132148442,90468.100028971865,0.01,916.63064142186704,-1271.3499999999999,1262.9060383618346,91130.140792612816]
[null,9,876.04,78.033182765135749,798.00681723486423,92841.812500928034,0.01,936.39819318162904,-876.04,869.49699650814648,93017.888348794266,null,9,500,80.547440186542175,419.45255981345781,96237.475664037149,9.9999999999999985E-3,966.56928223850593,-500,496.26557784795352,96014.95842673583,null,9,1271.3499999999999,75.390083357476556,1195.9599166425232,89272.140112329347,0.01,904.68100028971867,-1271.3499999999999,1261.8544941206642,89867.234754250981]
[null,10,876.04,77.368177084106705,798.67182291589324,92043.140678012147,0.01,928.4181250092804,-876.04,868.77301940299139,92148.391352286126,null,10,500,80.197896386697622,419.80210361330239,95817.673560423849,0.01,962.37475664037152,-500,495.85236759405956,95518.692848887877,null,10,1271.3499999999999,74.393450093607797,1196.9565499063922,88075.183562422957,1.0000000000000002E-2,892.72140112329362,-1271.3499999999999,1260.8038254357562,88605.380260130318]
[null,11,876.04,76.702617231676797,799.33738276832321,91243.803295243823,0.01,920.43140678012151,-876.04,868.04964510940545,91279.618332883139,null,11,500,79.848061300353208,420.15193869964679,95397.521621724198,0.01,958.1767356042385,-500,495.43950139528755,95022.840481293824,null,11,1271.3499999999999,73.395986302019125,1197.9540136979808,86877.229548724979,9.9999999999999985E-3,880.75183562422944,-1271.3499999999999,1259.7540315780891,87344.576434694565]
[null,12,876.04,76.036502746036518,800.00349725396347,90443.799797989865,0.01,912.43803295243822,-876.04,867.3268731254642,90411.568687773732,null,12,500,79.497934684770158,420.50206531522986,94977.019556408966,0.01,953.97521621724195,-500,495.02697896516366,94527.400979898535,null,12,1271.3499999999999,72.397691290604158,1198.9523087093958,85678.277240015581,1.0000000000000002E-2,868.77229548724995,-1271.3499999999999,1258.705111819248,86084.822403116472]
[null,13,876.04,75.369833164991562,800.67016683500844,89643.12963115485,0.01,904.43799797989868,-876.04,866.60470294966115,89544.241814648267,null,13,500,79.147516297007471,420.85248370299252,94556.167072705968,9.9999999999999985E-3,949.77019556408948,-500,494.61480001745275,94032.374000933371,null,13,1271.3499999999999,71.398564366679651,1199.9514356333202,84478.325804382257,0.01,856.78277240015586,-1271.3499999999999,1257.6570654314246,84826.117291297225]
[null,14,876.04,74.702608025962377,801.33739197403759,88841.79223918081,0.01,896.43129631154852,-876.04,865.88313408090721,88677.637111698612,null,14,500,78.796805893921643,421.20319410607834,94134.963878599883,0.01,945.56167072705966,-500,494.20296426615744,93537.759200915913,null,14,1271.3499999999999,70.398604836985214,1200.9513951630147,83277.374409219236,0.01,844.78325804382257,-1271.3499999999999,1256.6098916874162,83568.460225865798]
[null,15,876.04,74.034826865984016,802.00517313401599,88039.787066046789,0.01,888.41792239180813,-876.04,865.16216601853102,87811.7539776177,null,15,500,78.445803232166568,421.55419676783345,93713.409681832054,0.01,941.34963878599888,-500,493.79147142551938,93043.556236649762,null,15,1271.3499999999999,69.397812007682703,1201.9521879923172,82075.422221226923,0.01,832.77374409219237,-1271.3499999999999,1255.5635898606265,82311.85033417838]
[null,16,876.04,73.366489221705663,802.67351077829426,87237.113555268501,1.0000000000000002E-2,880.39787066046802,-876.04,864.44179826227753,86946.591811599166,null,16,500,78.094508068193377,421.90549193180664,93291.504189900254,0.01,937.13409681832059,-500,493.38032121001737,92549.764765224245,null,16,1271.3499999999999,68.396185184355772,1202.9538148156441,80872.468406411281,0.01,820.75422221226927,-1271.3499999999999,1254.5181592250631,81056.286744317753]
[null,17,876.04,72.697594629390423,803.34240537060953,86433.77114989789,0.01,872.37113555268502,-876.04,863.72203031230845,86082.150013336883,null,17,500,77.742920158250215,422.25707984174977,92869.24711005851,0.01,932.91504189900252,-500,492.96951333436829,92056.384444014227,null,17,1271.3499999999999,67.393723672009401,1203.9562763279905,79668.512130083283,0.01,808.72468406411281,-1271.3499999999999,1253.4735990553388,79801.768585092694]
[null,18,876.04,72.028142624914906,804.01185737508501,85629.759292522809,0.01,864.33771149897893,-876.04,863.00286166920171,85218.42798302458,null,18,500,77.391039258382094,422.60896074161792,92446.638149316888,0.01,928.69247110058507,-500,492.55904751352648,91563.414930679864,null,18,1271.3499999999999,66.3904267750694,1204.9595732249304,78463.552556858354,0.01,796.68512130083286,-1271.3499999999999,1252.4299086266701,78548.294986037348]
[null,19,876.04,71.358132743769005,804.68186725623093,84825.077425266572,0.01,856.29759292522806,-876.04,862.2842918339511,84355.42512135538,null,19,500,77.038865124430743,422.96113487556926,92023.677014441317,0.01,924.46638149316891,-500,492.14892346268357,91070.855883166339,null,19,1271.3499999999999,65.386293797381967,1205.9637062026179,77257.588850655738,0.01,784.6355255685836,-1271.3499999999999,1251.3870872148771,77295.865077410679]
[null,20,876.04,70.687564521055478,805.35243547894447,84019.724989787632,0.01,848.25077425266579,-876.04,861.56632030796584,83493.140829521435,null,20,500,76.686397512034432,423.31360248796557,91600.363411953353,0.01,920.23677014441319,-500,491.73914089726867,90578.706959703661,null,20,1271.3499999999999,64.381324042213109,1206.9686759577869,76050.62017469795,9.9999999999999985E-3,772.57588850655725,-1271.3499999999999,1250.3451340963832,76044.477990195795]
[null,21,876.04,70.016437491489697,806.02356250851028,83213.701427279128,1.0000000000000002E-2,840.19724989787653,-876.04,860.8489465930702,82631.574509213475,null,21,500,76.333636176627792,423.66636382337219,91176.69704812998,9.9999999999999985E-3,916.00363411953333,-500,491.3296995329473,90086.967818806399,null,21,1271.3499999999999,63.375516812248293,1207.9744831877515,74842.645691510203,0.01,760.50620174697951,-1271.3499999999999,1249.3040485482134,74794.132856099415]
[null,22,876.04,69.344751189399275,806.69524881060067,82407.006178468524,0.01,832.13701427279125,-876.04,860.13217019150341,81770.725562620399,null,22,500,75.980580873441653,424.01941912655832,90752.677629003418,0.01,911.76697048129984,-500,490.92059908562226,89595.638119273455,null,22,1271.3499999999999,62.368871409591833,1208.9811285904082,73633.664562919788,0.01,748.42645691510199,-1271.3499999999999,1248.2638298479956,73544.828807551195]
[null,23,876.04,68.672505148723772,807.36749485127621,81599.638683617246,0.01,824.07006178468521,-876.04,859.41599060591932,80910.593392428898,null,23,500,75.627231357502851,424.37276864249714,90328.30486036092,0.01,907.52677629003415,-500,490.51183927143234,89104.717520187827,null,23,1271.3499999999999,61.361387135766485,1209.9886128642333,72423.675950055549,0.01,736.33664562919785,-1271.3499999999999,1247.2244772739584,72296.564977703194]
[null,24,876.04,67.999698903014377,808.04030109698556,80791.598382520257,0.01,815.99638683617252,-876.04,858.70040733938527,80051.177401822977,null,24,500,75.273587383634109,424.72641261636591,89903.578447744556,1.0000000000000002E-2,903.28304860360936,-500,490.10341980675315,88614.205680916391,null,24,1271.3499999999999,60.353063291712964,1210.996936708287,71212.679013347268,0.01,724.23675950055554,-1271.3499999999999,1246.1859901049324,71049.340500429229]
[null,25,876.04,67.326331985433555,808.71366801456645,79982.884714505693,0.01,807.9159838252026,-876.04,857.98541989538296,79192.476994483586,null,25,500,74.919648706453799,425.08035129354619,89478.498096451003,0.01,899.03578447744553,-500,489.69534040819627,88124.102261109641,null,25,1271.3499999999999,59.343899177789389,1212.0061008222106,70000.672912525057,0.01,712.1267901334727,-1271.3499999999999,1245.1483676203472,69803.154510324297]
[null,26,876.04,66.652403928754737,809.38759607124518,79173.497118434447,0.01,799.8288471450569,-876.04,857.27102777780738,78334.491574588203,null,26,500,74.565415080375843,425.43458491962417,89053.063511531378,1.0000000000000002E-2,894.78498096451017,-500,489.28760079260934,87634.40692070144,null,26,1271.3499999999999,58.33389409377088,1213.0161059062291,68787.656806618834,0.01,700.00672912525056,-1271.3499999999999,1244.1116091002341,68558.006142703947]
[null,27,876.04,65.977914265362031,810.06208573463789,78363.43503269981,0.01,791.73497118434443,-876.04,856.5572304909665,77477.220546810393,null,27,500,74.210886259609481,425.78911374039052,88627.274397790985,0.01,890.53063511531377,-500,488.88020067707561,87145.11931990883,null,27,1271.3499999999999,57.32304733884903,1214.026952661151,67573.629853957682,0.01,687.87656806618838,-1271.3499999999999,1243.0757138252225,67313.894533603714]
[null,28,876.04,65.302862527249843,810.73713747275008,77552.697895227058,0.01,783.63435032699817,-876.04,855.84402753958091,76620.66331631942,null,28,500,73.856061998159149,426.14393800184087,88201.130459789143,0.01,886.27274397790984,-500,488.47313977891389,86656.239119231759,null,28,1271.3499999999999,56.311358211631408,1215.0386417883685,66358.591212169311,0.01,675.73629853957686,-1271.3499999999999,1242.0406810765407,66070.818819778491]
[null,29,876.04,64.627248246022546,811.41275175397743,76741.285143473084,0.01,775.52697895227061,-876.04,855.13141842878395,75764.819288779836,null,29,500,73.500942049824289,426.49905795017571,87774.631401838968,0.01,882.01130459789147,-500,488.06641781567856,86167.765979452844,null,29,1271.3499999999999,55.298826010141092,1216.0511739898589,65142.540038179453,0.01,663.58591212169313,-1271.3499999999999,1241.0065101360174,64828.77813870195]
[null,30,876.04,63.951070952894241,812.08892904710569,75929.196214425974,0.01,767.4128514347309,-876.04,854.41940266412075,74909.687870351059,null,30,500,73.14552616819914,426.85447383180087,87347.776928007166,0.01,877.74631401838974,-500,487.66003450515899,85679.699561637171,null,30,1271.3499999999999,54.285450031816218,1217.0645499681837,63925.475488211268,0.01,651.42540038179459,-1271.3499999999999,1239.9732002860767,63587.771628565933]
[null,31,876.04,63.274330178688309,812.76566982131169,75116.430544604664,0.01,759.29196214425974,-876.04,853.70797975154801,74055.268467686939,null,31,500,72.789814106672637,427.21018589332738,86920.566742113835,0.01,873.4777692800717,-500,487.25398956537964,85192.039527132016,null,31,1271.3499999999999,53.271229573509395,1218.0787704264906,62707.396717784781,0.01,639.25475488211271,-1271.3499999999999,1238.9407508097418,62347.798428279857]
[null,32,876.04,62.597025453837226,813.44297454616276,74302.987570058496,0.01,751.16430544604668,-876.04,852.99714919743406,73201.560487935392,null,32,500,72.433805618428195,427.56619438157179,86493.00054773227,9.9999999999999985E-3,869.20566742113817,-500,486.8482827145998,84704.78553756664,null,32,1271.3499999999999,52.256163931487322,1219.0938360685127,61488.30288171627,0.01,627.07396717784786,-1271.3499999999999,1237.9091609906327,61108.857677470114]
[null,33,876.04,61.919156308382078,814.12084369161789,73488.866726366876,0.01,743.02987570058497,-876.04,852.28691050855821,72348.563338737964,null,33,500,72.077500456443559,427.92249954355646,86065.07804818872,0.01,864.93000547732277,-500,486.44291367131308,84217.937254852048,null,33,1271.3499999999999,51.240252401430233,1220.1097475985696,60268.193134117704,0.01,614.88302881716277,-1271.3499999999999,1236.8784301129654,59870.948516479482]
[null,34,876.04,61.240722271972402,814.79927772802762,72674.067448638845,0.01,734.88866726366882,-876.04,851.57726319211031,71496.276428229408,null,34,500,71.720898373490598,428.27910162650937,85636.798946562209,0.01,860.65078048188718,-500,486.03788215424777,83731.494341180733,null,34,1271.3499999999999,50.223494278431417,1221.1265057215685,59047.066628396133,0.01,602.68193134117701,-1271.3499999999999,1235.8485574615522,58634.070086366519]
[null,35,876.04,60.561722873865705,815.47827712613423,71858.589171512707,0.01,726.74067448638846,-876.04,850.86820675569072,70644.699165037295,null,35,500,71.363999122135183,428.63600087786483,85208.162945684337,1.0000000000000002E-2,856.36798946562226,-500,485.63318788236614,83245.456459026478,null,35,1271.3499999999999,49.205888856996779,1222.1441111430031,57824.92251725313,0.01,590.47066628396135,-1271.3499999999999,1234.8195423218008,57398.221528904964]
[null,36,876.04,59.882157642927261,816.1578423570727,71042.431329155632,0.01,718.5858917151271,-876.04,850.15974070730954,69793.8309582816,null,36,500,71.006802454736956,428.99319754526306,84779.169748139073,1.0000000000000002E-2,852.08162945684353,-500,485.22883057486479,82759.823271144109,null,36,1271.3499999999999,48.187435431044271,1223.1625645689555,56601.759952684173,0.01,578.24922517253128,-1271.3499999999999,1233.7913839797138,56163.401986583165]
[null,37,876.04,59.202026107629699,816.83797389237031,70225.593355263263,0.01,710.42431329155636,-876.04,849.45186455538681,68943.671217574287,null,37,500,70.649308123449231,429.35069187655074,84349.819056262524,0.01,847.79169748139077,-500,484.82480995117379,82274.594440569243,null,37,1271.3499999999999,47.16813329390348,1224.1818667060963,55377.578085978079,0.01,566.01759952684176,-1271.3499999999999,1232.7640817218892,54929.610602603454]
[null,38,876.04,58.521327796052724,817.51867220394729,69408.074683059313,0.01,702.25593355263265,-876.04,848.74457780875139,68094.219353018896,null,38,500,70.291515880218768,429.70848411978125,83920.110572142745,0.01,843.49819056262527,-500,484.42112573095687,81789.769630618073,null,38,1271.3499999999999,46.14798173831506,1225.2020182616848,54152.376067716395,0.01,553.77578085978075,-1271.3499999999999,1231.7376348355172,53696.846520881561]
[null,39,876.04,57.840062235882762,818.19993776411718,68589.874745295194,0.01,694.08074683059317,-876.04,848.03787997664199,67245.474775210139,null,39,500,69.933425476785615,430.0665745232144,83490.043997619534,0.01,839.20110572142744,-500,484.01777763411144,81305.348504887123,null,39,1271.3499999999999,45.126980056430334,1226.2230199435696,52926.153047772823,0.01,541.52376067716398,-1271.3499999999999,1230.7120426083834,52465.108886046044]
[null,40,876.04,57.158228954412664,818.88177104558736,67770.992974249602,0.01,685.89874745295197,-876.04,847.33177056870522,66397.436895233492,null,40,500,69.575036664682941,430.42496333531705,83059.619034284216,9.9999999999999985E-3,834.90043997619523,-500,483.61476538076772,80821.330727253007,null,40,1271.3499999999999,44.105127539810688,1227.2448724601893,51698.90817531263,0.01,529.26153047772823,-1271.3499999999999,1229.6873043288651,51234.396843437658]
[null,41,876.04,56.475827478541333,819.56417252145866,66951.428801728151,0.01,677.709929742496,-876.04,846.62624909499584,65550.105124664784,null,41,500,69.216349195236845,430.78365080476317,82628.835383479454,0.01,830.59619034284219,-500,483.21208869128941,80337.715961872236,null,41,1271.3499999999999,43.082423479427199,1228.2675765205727,50470.640598792059,0.01,516.98908175312636,-1271.3499999999999,1228.6634192859326,50004.709539108793]
[null,42,876.04,55.792857334773458,820.24714266522653,66131.181659062917,0.01,669.5142880172815,-876.04,845.9213150659773,64703.478875569788,null,42,500,68.857362819566205,431.14263718043378,82197.692746299013,9.9999999999999985E-3,826.28835383479441,-500,482.80974728627268,79854.503873180947,null,42,1271.3499999999999,42.058867165660054,1229.2911328343398,49241.349465957719,1.0000000000000002E-2,504.70640598792068,-1271.3499999999999,1227.6403867691486,48776.046119822859]
[null,43,876.04,55.109318049219098,820.93068195078081,65310.250977112133,0.01,661.31181659062918,-876.04,845.21696799252004,63857.55756050381,null,43,500,68.498077288582508,431.50192271141748,81766.190823587589,9.9999999999999985E-3,821.97692746299003,-500,482.40774088654661,79371.694125894675,null,43,1271.3499999999999,41.0344578882981,1230.3155421117019,48011.033923846015,0.01,492.41349465957722,-1271.3499999999999,1226.6182060686665,47548.405733053711]
[null,44,876.04,54.425209147593449,821.61479085240649,64488.636186259726,0.01,653.10250977112139,-876.04,844.51320738590209,63012.340592511289,null,44,500,68.138492352989658,431.86150764701034,81334.329315940573,0.01,817.6619082358759,-500,482.00606921317245,78889.286385008134,null,44,1271.3499999999999,40.009194936538343,1231.3408050634616,46779.693118782554,0.01,480.11033923846014,-1271.3499999999999,1225.5968764752317,46321.787526985041]
[null,45,876.04,53.74053015521644,822.29946984478352,63666.336716414946,0.01,644.88636186259725,-876.04,843.81003275780802,62167.827385125391,null,45,500,67.778607763283816,432.22139223671616,80902.10792370385,0.01,813.34329315940579,-500,481.60473198744404,78407.280315794967,null,45,1271.3499999999999,38.98307759898546,1232.3669224010146,45547.326196381538,0.01,467.79693118782552,-1271.3499999999999,1224.5763972801794,45096.190650509809]
[null,46,876.04,53.055280597012455,822.98471940298748,62843.35199701196,0.01,636.66336716414946,-876.04,843.10744362032949,61324.017352367584,null,46,500,67.418423269753205,432.58157673024681,80469.526346973609,0.01,809.02107923703852,-500,481.203728930887,77925.675583807519,null,46,1271.3499999999999,37.95610516365128,1233.3938948363486,44313.932301545188,0.01,455.47326196381539,-1271.3499999999999,1223.556767775435,43871.614253229629]
[null,47,876.04,52.369459997509971,823.67054000249004,62019.681457009472,0.01,628.43351997011962,-876.04,842.40543948596428,60480.909908747257,null,47,500,67.057938622478005,432.94206137752201,80036.58428559608,0.01,804.69526346973612,-500,480.80305976525887,77444.471854876625,null,47,1271.3499999999999,36.928276917954328,1234.4217230820457,43079.510578463145,1.0000000000000002E-2,443.13932301545196,-1271.3499999999999,1222.5379872535138,42648.057485454192,null,47,{"$f":"AJ71+10","v":10},{"$f":"AM71*$D$19/12","v":0},{"$f":"AJ72-AK72","v":10},{"$f":"AM71-AL72","v":-10},{"$f":"-AJ72","v":-10},null,47,{"$f":"AQ71-10","v":-10},{"$f":"AT71*$D$19/12","v":0},{"$f":"AQ72-AR72","v":-10},{"$f":"AT71-AS72","v":10},{"$f":"-AQ72","v":10}]
[null,48,876.04,51.683067880841229,824.35693211915873,61195.324524890311,0.01,620.19681457009472,-876.04,841.70401986761613,59638.504469261294,null,48,500,66.697153571330077,433.30284642866991,79603.281439167404,0.01,800.36584285596086,-500,480.402724212549,76963.668795111371,null,48,1271.3499999999999,35.899592148719286,1235.4504078512807,41844.060170611861,0.01,430.79510578463146,-1271.3499999999999,1221.5200550075203,41425.51949820068,null,48,20,-8.3333333333333332E-3,20.008333333333333,-30.008333333333333,-20,null,48,-20,8.3333333333333332E-3,-20.008333333333333,30.008333333333333,20]
[null,49,876.04,50.996103770741932,825.04389622925805,60370.28062866105,0.01,611.95324524890316,-876.04,841.00318427859327,58796.800449393675,null,49,500,66.336067865972836,433.66393213402716,79169.61750703337,0.01,796.03281439167404,-500,480.00272199497834,76483.266070898826,null,49,1271.3499999999999,34.870050142176552,1236.4799498578234,40607.58022075404,0.01,418.44060170611863,-1271.3499999999999,1220.5029703311466,40203.999443193163,null,49,30,-2.5006944444444443E-2,30.025006944444446,-60.033340277777782,-30,null,49,-30,2.5006944444444443E-2,-30.025006944444446,60.033340277777782,30]
[null,50,876.04,50.308567190550882,825.73143280944907,59544.5491958516,0.01,603.70280628661055,-876.04,840.30293223261128,57955.797265115085,null,50,500,65.974681255861142,434.02531874413887,78735.592188289229,0.01,791.69617507033377,-500,479.60305283499855,76003.263348903842,null,50,1271.3499999999999,33.839650183961702,1237.5103498160381,39370.069870938001,0.01,406.07580220754039,-1271.3499999999999,1219.4867325186738,38983.496472862018,null,50,40,-5.0027783564814819E-2,40.050027783564815,-100.0833680613426,-40,null,50,-40,5.0027783564814819E-2,-40.050027783564815,100.0833680613426,40]
[null,51,876.04,49.620457663209663,826.4195423367903,58718.129653514807,0.01,595.44549195851596,-876.04,839.60326324378866,57115.494332882474,null,51,500,65.612993490241024,434.38700650975898,78301.205181779471,0.01,787.35592188289229,-500,479.20371645529309,75523.660296068847,null,51,1271.3499999999999,32.808391559115002,1238.5416084408848,38131.528262497115,0.01,393.70069870938005,-1271.3499999999999,1218.4713408649704,37764.009740343346,null,51,50,-8.3402806717785494E-2,50.083402806717785,-150.16677086806038,-50,null,51,-50,8.3402806717785494E-2,-50.083402806717785,150.16677086806038,50]
[null,52,876.04,48.931774711262342,827.10822528873757,57891.021428226071,1.0000000000000002E-2,587.18129653514814,-876.04,838.90417682664986,56275.891069638688,null,52,500,65.251004318149555,434.74899568185043,77866.456186097625,9.9999999999999985E-3,783.0120518177946,-500,478.80471257877576,75044.456579613558,null,52,1271.3499999999999,31.776273552080927,1239.5737264479189,36891.954536049197,0.01,381.31528262497113,-1271.3499999999999,1217.4567946654925,36545.538399478377,null,52,60,-0.12513897572338364,60.125138975723381,-210.29190984378377,-60,null,52,-60,0.12513897572338364,-60.125138975723381,210.29190984378377,60]
[null,53,876.04,48.242517856855066,827.79748214314486,57063.22394608293,0.01,578.91021428226077,-876.04,838.20567249612259,55436.986892812041,null,53,500,64.888713488414695,435.11128651158532,77431.344899586038,1.0000000000000002E-2,778.66456186097639,-500,478.40604092859138,74565.651867034787,null,53,1271.3499999999999,30.743295446707666,1240.6067045532923,35651.347831495907,0.01,368.91954536049201,-1271.3499999999999,1216.4430932162816,35328.081604812884,null,53,70,-0.17524325820315315,70.175243258203153,-280.46715310198692,-70,null,53,-70,0.17524325820315315,-70.175243258203153,280.46715310198692,70]
[null,54,876.04,47.552686621735774,828.48731337826416,56234.736632704662,0.01,570.63223946082928,-876.04,837.50774976753883,54598.781220315919,null,54,500,64.526120749655036,435.47387925034496,76995.87102033569,0.01,774.31344899586043,-500,478.00770122811542,74087.245826106198,null,54,1271.3499999999999,29.709456526246587,1241.6405434737533,34409.707288022153,0.01,356.51347831495906,-1271.3499999999999,1215.4302358139664,34111.638511596604,null,54,80,-0.2337226275849891,80.233722627584996,-360.70087572957192,-80,null,54,-80,0.2337226275849891,-80.233722627584996,360.70087572957192,80]
[null,55,876.04,46.862280527253887,829.17771947274605,55405.558913231915,0.01,562.34736632704664,-876.04,836.81040815663437,53761.273470548382,null,55,500,64.163225850279744,435.83677414972027,76560.034246185969,1.0000000000000002E-2,769.9587102033571,-500,477.60969320095319,73609.238124878088,null,55,1271.3499999999999,28.674756073351798,1242.6752439266481,33167.032044095504,0.01,344.09707288022156,-1271.3499999999999,1214.4182217557607,32896.208275782636,null,55,90,-0.30058406310797664,90.300584063107976,-451.0014597926799,-90,null,55,-90,0.30058406310797664,-90.300584063107976,451.0014597926799,90]
[null,56,876.04,46.171299094359931,829.86870090564003,54575.690212326277,0.01,554.05558913231914,-876.04,836.1136471795478,52924.463062391747,null,56,500,63.800028538488306,436.19997146151172,76123.834274724461,0.01,765.60034246185967,-500,477.2120165709407,73131.628431677134,null,56,1271.3499999999999,27.639193370079585,1243.7108066299204,31923.321237465585,0.01,331.67032044095504,-1271.3499999999999,1213.4070503394639,31681.790054026878,null,56,100,-0.37583454982723324,100.37583454982723,-551.37729434250718,-100,null,56,-100,0.37583454982723324,-100.37583454982723,551.37729434250718,100]
[null,57,876.04,45.479741843605233,830.56025815639475,53745.129954169883,0.01,545.75690212326276,-876.04,835.41746635282095,52088.3494152122,null,57,500,63.436528562270382,436.56347143772962,75687.270803286738,0.01,761.23834274724459,-500,476.81467106214342,72654.4164151062,null,57,1271.3499999999999,26.602767697887987,1244.747232302112,30678.574005163471,0.01,319.23321237465586,-1271.3499999999999,1212.3967208634601,30468.383003687413,null,57,110,-0.45948107861875598,110.45948107861875,-661.83677542112594,-110,null,57,-110,0.45948107861875598,-110.45948107861875,661.83677542112594,110]
[null,58,876.04,44.787608295141574,831.25239170485838,52913.877562465022,0.01,537.45129954169886,-876.04,834.72186519339755,51252.931948859383,null,58,500,63.072725669405621,436.9272743305944,75250.343528956146,0.01,756.87270803286742,-500,476.41765639885699,72177.601744044063,null,58,1271.3499999999999,25.565478337636225,1245.7845216623637,29432.789483501107,0.01,306.78574005163472,-1271.3499999999999,1211.3872326267169,29255.986282823953,null,58,120,-0.55153064618427161,120.55153064618428,-782.38830606731017,-120,null,58,-120,0.55153064618427161,-120.55153064618428,782.38830606731017,120]
[null,59,{"$f":"IF($I$5=1,-PMT($D$19/12,$B$19,$C$19,0,0),ROUND(-PMT($D$19/12,$B$19,$C$19,0,0),2))","v":876.04},44.094897968720851,{"$f":"IF($I$5<>2,C84-D84,ROUND(C84-D84,2))","v":831.94510203127913},52081.932460433745,9.9999999999999985E-3,529.13877562465018,-876.04,834.02684321862455,50418.210083665988,null,59,500,62.708619607463454,437.29138039253655,74813.052148563613,0.01,752.50343528956148,-500,476.02097230560628,71701.184087645204,null,59,1271.3499999999999,24.527324569584255,1246.8226754304158,28185.966808070691,0.01,294.32789483501108,-1271.3499999999999,1210.3785849287865,28044.599050197237,null,59,130,-0.65199025505609176,130.65199025505609,-913.0402963223662,-130,null,59,-130,0.65199025505609176,-130.65199025505609,913.0402963223662,130]
[null,60,{"$f":"IF($I$5=1,-PMT($D$19/12,$B$19,$C$19,0,0),ROUND(-PMT($D$19/12,$B$19,$C$19,0,0),2))","v":876.04},{"$f":"IF(OR($I$5=1,$I$5=3),F84*$D$19/12,IF($I$5=2,ROUND(F84*$D$19/12,2),ROUNDDOWN(F84*$D$19/12,2)))","v":43.401610383694788},{"$f":"IF($I$5<>2,C85-D85,ROUND(C85-D85,2))","v":832.63838961630518},{"$f":"IF($I$5<>2,F84-E85,ROUND(F84-E85,2))","v":51249.294070817443},{"$f":"D85*12/F84","v":0.01},{"$f":"G85*F84","v":520.81932460433745},{"$f":"-C85","v":-876.04},{"$f":"C85*(1+$J$21)^(-B85/12)","v":833.33239994625023},49584.183240447361,null,60,500,{"$f":"IF(OR($I$5=1,$I$5=3),Q84*$O$19/12,IF($I$5=2,ROUND(Q84*$O$19/12,2),ROUNDDOWN(Q84*$O$19/12,2)))","v":62.344210123803009},{"$f":"IF($I$5<>2,N85-O85,ROUND(N85-O85,2))","v":437.65578987619699},74375.396358687416,0.01,748.13052148563611,-500,475.62461850714567,71225.163115339601,null,60,1271.3499999999999,{"$f":"IF(OR($I$5=1,$I$5=3),AB84*$O$19/12,IF($I$5=2,ROUND(AB84*$O$19/12,2),ROUNDDOWN(AB84*$O$19/12,2)))","v":23.488305673392244},{"$f":"IF($I$5<>2,Y85-Z85,ROUND(Y85-Z85,2))","v":1247.8616943266077},26938.105113744085,0.01,281.85966808070691,-1271.3499999999999,1209.3707770698038,26834.220465268452,null,60,140,-0.76086691360197189,140.76086691360197,-1053.8011632359683,-140,null,60,-140,0.76086691360197189,-140.76086691360197,1053.8011632359683,140]
[null,61,876.04,42.707745059014535,833.33225494098542,50415.961815876457,{"$f":"D86*12/F85","v":9.9999999999999985E-3},{"$f":"G86*F85","v":512.49294070817439},{"$f":"-C86","v":-876.04},{"$f":"C86*(1+$J$21)^(-B86/12)","v":832.63853489442363},48750.850840501109,null,61,{"$f":"IF($I$5=1,-PMT($O$19/12,$M$19-$M$85,$Q$85,0,0),ROUND(-PMT($O$19/12,$M$19-$M$85,$Q$85,0,0),2))","v":1271.3499999999999},{"$f":"IF(OR($I$5=1,$I$5=3),Q85*$O$19/12,IF($I$5=2,ROUND(Q85*$O$19/12,2),ROUNDDOWN(Q85*$O$19/12,2)))","v":61.979496965572849},{"$f":"IF($I$5<>2,N86-O86,ROUND(N86-O86,2))","v":1209.370503034427},{"$f":"IF($I$5<>2,Q85-P86,ROUND(Q85-P86,2))","v":73166.025855652988},{"$f":"O86*12/Q85","v":0.01},743.75396358687419,{"$f":"-N86","v":-1271.3499999999999},1208.3637478160524,70749.538496832451,null,61,{"$f":"IF($I$5=1,-PMT($O$19/12,$M$19-$M$85,$AB$85,0,0),ROUND(-PMT($O$19/12,$M$19-$M$85,$AB$85,0,0),2))","v":460.47},{"$f":"IF(OR($I$5=1,$I$5=3),AB85*$O$19/12,IF($I$5=2,ROUND(AB85*$O$19/12,2),ROUNDDOWN(AB85*$O$19/12,2)))","v":22.448420928120072},{"$f":"IF($I$5<>2,Y86-Z86,ROUND(Y86-Z86,2))","v":438.02157907187996},{"$f":"IF($I$5<>2,AB85-AA86,ROUND(AB85-AA86,2))","v":26500.083534672205},0.01,269.38105113744086,-460.47,437.65704395418129,25624.84968819865,null,61,150,-0.8781676360299735,150.87816763602999,-1204.6793308719982,-150,null,61,-150,0.8781676360299735,-150.87816763602999,1204.6793308719982,150]
[null,62,876.04,42.013301513230381,834.02669848676953,49581.935117389687,0.01,504.1596181587646,-876.04,831.94524758169666,47918.212305606685,null,62,{"$f":"IF($I$5=1,-PMT($O$19/12,$M$19-$M$85,$Q$85,0,0),ROUND(-PMT($O$19/12,$M$19-$M$85,$Q$85,0,0),2))","v":1271.3499999999999},60.97168821304416,1210.3783117869557,71955.647543866027,0.01,731.66025855652993,-1271.3499999999999,1207.3576165965617,69541.174749016398,null,62,{"$f":"IF($I$5=1,-PMT($O$19/12,$M$19-$M$85,$AB$85,0,0),ROUND(-PMT($O$19/12,$M$19-$M$85,$AB$85,0,0),2))","v":460.47},{"$f":"IF(OR($I$5=1,$I$5=3),AB86*$O$19/12,IF($I$5=2,ROUND(AB86*$O$19/12,2),ROUNDDOWN(AB86*$O$19/12,2)))","v":22.08340294556017},{"$f":"IF($I$5<>2,Y87-Z87,ROUND(Y87-Z87,2))","v":438.38659705443985},{"$f":"IF($I$5<>2,AB86-AA87,ROUND(AB86-AA87,2))","v":26061.696937617766},0.01,265.00083534672206,-460.47,437.29263383165556,25187.192644244467,null,62,160,-1.0038994423933318,161.00389944239333,-1365.6832303143915,-160,null,62,-160,1.0038994423933318,-161.00389944239333,1365.6832303143915,160]
[null,63,876.04,41.318279264491409,834.7217207355086,48747.213396654181,0.01,495.81935117389691,-876.04,831.25253752702076,47086.267058024991,null,63,1271.3499999999999,59.963039619888356,1211.3869603801115,70744.260583485913,0.01,719.5564754386603,-1271.3499999999999,1206.3523231215274,68333.817132419834,null,63,460.47,21.718080781348139,438.75191921865189,25622.945018399114,0.01,260.61696937617768,-460.47,436.9285271310427,24749.900010412814,null,63,170,-1.1380693585953263,171.13806935859532,-1536.8212996729867,-170,null,63,-170,1.1380693585953263,-171.13806935859532,1536.8212996729867,170]
[null,64,876.04,40.62267783054515,835.41732216945479,47911.796074484722,0.01,487.47213396654183,-876.04,830.56040424974844,46255.014520497971,null,64,1271.3499999999999,58.953550486238264,1212.3964495137616,69531.864133972151,0.01,707.44260583485914,-1271.3499999999999,1205.3478666934102,67127.464809298312,null,64,460.47,21.352454181999263,439.11754581800074,25183.827472581113,0.01,256.22945018399116,-460.47,436.56472359970178,24312.97148328177,null,64,180,-1.2806844163941555,181.28068441639417,-1718.1019840893809,-180,null,64,-180,1.2806844163941555,-181.28068441639417,1718.1019840893809,180]
[null,65,876.04,39.92649672873727,836.11350327126274,47075.68257121346,0.01,479.11796074484721,-876.04,829.8688472696324,{"$f":"J90+K91","v":45424.45411624822},null,65,1271.3499999999999,57.943220111643456,1213.4067798883564,68318.457354083788,0.01,695.31864133972147,-1271.3499999999999,1204.3442466152519,{"$f":"V91+U90","v":65922.116942604902},null,65,460.47,20.986522893817597,439.48347710618242,24744.34399547493,1.0000000000000002E-2,251.83827472581117,-460.47,436.20122298520238,{"$f":"AG91+AF90","v":23876.406759682068},null,65,190,-1.4317516534078176,191.43175165340782,-1909.5337357427888,-190,null,65,-190,1.4317516534078176,-191.43175165340782,1909.5337357427888,190]
[null,66,876.04,39.229735476011221,836.81026452398874,46238.872306689474,0.01,470.75682571213463,-876.04,829.17786610682526,44594.58526897859,null,66,1271.3499999999999,{"$f":"IF(OR($I$5=1,$I$5=3),Q90*$O$19/12,IF($I$5=2,ROUND(Q90*$O$19/12,2),ROUNDDOWN(Q90*$O$19/12,2)))","v":56.93204779506982},{"$f":"IF($I$5<>2,N91-O91,ROUND(N91-O91,2))","v":1214.4179522049301},{"$f":"IF($I$5<>2,Q90-P91,ROUND(Q90-P91,2))","v":67104.039401878865},0.01,{"$f":"R91*Q90","v":683.18457354083785},-1271.3499999999999,{"$f":"N91*(1+$U$21)^(-M91/12)","v":1203.3414621906752},64717.772695989654,null,66,460.47,20.620286662895776,439.84971333710428,24304.494282137824,{"$f":"Z91*12/AB90","v":0.01},{"$f":"AC91*AB90","v":247.44343995474929},{"$f":"-Y91","v":-460.47},{"$f":"Y91*(1+$AF$21)^(-X91/12)","v":435.83802503532434},23440.205536696867,null,66,200,-1.5912781131189908,201.59127811311899,-2111.125013855908,-200,null,66,-200,1.5912781131189908,-201.59127811311899,2111.125013855908,200]
[null,67,876.04,38.532393588907894,837.50760641109207,45401.364700278384,0.01,462.38872306689473,-876.04,828.48746028187884,43765.407402871766,null,67,1271.3499999999999,55.920032834899054,1215.4299671651008,65888.60943471377,0.01,671.04039401878867,-1271.3499999999999,1202.3395127238809,63514.431233798976,null,67,460.47,20.253745235114852,440.21625476488515,23864.27802737294,0.01,243.04494282137824,-460.47,435.4751294980573,23004.367511661541,null,67,210,-1.7592708448799235,211.75927084487992,-2322.8842847007882,-210,null,67,{"$f":"AQ91-10","v":-210},1.7592708448799235,-211.75927084487992,2322.8842847007882,210]
[null,68,876.04,37.83447058356532,838.20552941643462,44563.159170861953,0.01,454.01364700278384,-876.04,827.79762931574442,42936.919942589884,null,68,1271.3499999999999,54.907174528928145,1216.4428254710717,64672.166609242697,0.01,658.88609434713771,-1271.3499999999999,1201.3383975196514,62312.091721075092,null,68,460.47,19.886898356144119,440.58310164385591,23423.694925729083,1.0000000000000002E-2,238.64278027372944,-460.47,435.11253612160095,22568.892382163485,null,68,220,-1.9357369039173236,221.93573690391733,-2544.8200216047053,-220,null,68,-220,1.9357369039173236,-221.93573690391733,2544.8200216047053,220]
[null,69,876.04,37.135965975718292,838.90403402428171,43724.255136837673,0.01,445.63159170861951,-876.04,827.10837272977233,42109.122313274136,null,69,1271.3499999999999,53.893472174368917,1217.4565278256309,63454.710081417063,0.01,646.72166609242697,-1271.3499999999999,1200.3381158833463,61110.753323555444,null,69,460.47,19.519745771440903,440.95025422855912,22982.744671500524,0.01,234.23694925729083,-460.47,434.75024465436456,22133.779846041885,null,69,230,-2.1206833513372545,232.12068335133725,-2776.9407049560427,-230,null,69,-230,2.1206833513372545,-232.12068335133725,2776.9407049560427,230]
[null,70,876.04,36.436879280698058,839.60312071930196,42884.652016118373,9.9999999999999985E-3,437.24255136837667,-876.04,826.41969004571115,41282.013940544362,null,70,1271.3499999999999,52.878925067847554,1218.4710749321523,62236.23900648491,0.01,634.54710081417068,-1271.3499999999999,1199.3386671209039,59910.4152076721,null,70,460.47,19.152287226250436,441.31771277374958,22541.426958726774,0.01,229.82744671500524,-460.47,434.38825484496692,21699.02960138752,null,70,240,-2.3141172541300357,242.31411725413003,-3019.2548222101727,-240,null,70,-240,2.3141172541300357,-242.31411725413003,3019.2548222101727,240]
[null,71,876.04,35.737210013431977,840.30278998656797,42044.349226131802,0.01,428.84652016118372,-876.04,825.73158078570782,40455.594250498652,null,71,1271.3499999999999,51.863532505404095,1219.4864674945959,61016.752538990317,0.01,622.36239006484914,-1271.3499999999999,1198.3400505388411,58711.076540551199,null,71,460.47,18.784522465605644,441.68547753439441,22099.741481192381,9.9999999999999985E-3,225.41426958726771,-460.47,434.02656644223583,21264.641346542554,null,71,250,-2.5160456851751438,252.51604568517516,-3271.7708678953477,-250,null,71,-250,2.5160456851751438,-252.51604568517516,3271.7708678953477,250]
[null,72,876.04,35.036957688443174,841.00304231155678,41203.346183820249,0.01,420.44349226131806,-876.04,825.04404447230729,39629.862669712944,null,72,1271.3499999999999,50.847293782491931,1220.5027062175079,59796.24983277281,0.01,610.16752538990318,-1271.3499999999999,1197.3422654442513,57512.736490012358,null,72,460.47,18.416451234326985,442.05354876567304,21657.687932426707,0.01,220.99741481192382,-460.47,433.66517919520891,20830.614780100317,null,72,260,-2.7264757232461232,262.7264757232461,-3534.4973436185937,-260,null,72,-260,2.7264757232461232,-262.7264757232461,3534.4973436185937,260]
[null,73,876.04,34.336121819850213,841.70387818014979,40361.642305640096,1.0000000000000002E-2,412.03346183820258,-876.04,824.35708062845094,38804.818625240638,null,73,1271.3499999999999,49.830208193977342,1221.5197918060226,58574.730040966788,0.01,597.9624983277281,-1271.3499999999999,1196.3453111448066,56315.394224568103,null,73,460.47,18.048073277022258,442.42192672297779,21215.266005703728,1.0000000000000002E-2,216.57687932426711,-460.47,433.30409285313192,20396.949600905107,null,73,270,-2.9454144530154949,272.94541445301547,-3807.4427580716092,-270,null,73,-270,2.9454144530154949,-272.94541445301547,3807.4427580716092,270]
[null,74,876.04,33.634701921366748,842.40529807863322,39519.23700756146,0.01,403.61642305640095,-876.04,823.67068877747931,37980.46154461219,null,74,1271.3499999999999,48.812275034138992,1222.5377249658609,57352.192316000925,0.01,585.7473004096679,-1271.3499999999999,1195.3491869487527,55119.048913423299,null,74,460.47,17.67938833808644,442.7906116619136,20772.475394041816,0.01,212.15266005703728,-460.47,432.94330716546006,19963.645508051974,null,74,280,-3.1728689650596742,283.17286896505965,-4090.6156270366687,-280,null,74,-280,3.1728689650596742,-283.17286896505965,4090.6156270366687,280]
[null,75,876.04,32.932697506301217,843.10730249369874,38676.12970506776,0.01,395.19237007561463,-876.04,822.98486844312879,37156.790855834712,null,75,1271.3499999999999,47.793493596667439,1223.5565064033324,56128.635809597596,0.01,573.52192316000924,-1271.3499999999999,1194.3538921649133,53923.699726474544,null,75,460.47,17.310396161701515,443.15960383829849,20329.315790203516,0.01,207.72475394041817,-460.47,432.58282188185672,19530.702200886513,null,75,290,-3.4088463558638904,293.40884635586389,-4384.0244733925329,-290,null,75,-290,3.4088463558638904,-293.40884635586389,4384.0244733925329,290]
[null,76,876.04,32.230108087556467,843.8098919124435,37832.319813155314,0.01,386.76129705067763,-876.04,822.29961914953185,36333.805987391584,null,76,1271.3499999999999,46.773863174664662,1224.5761368253352,54904.059672772259,0.01,561.28635809597597,-1271.3499999999999,1193.3594261026872,52729.345834309628,null,76,460.47,16.941096491836266,443.52890350816375,19885.786886695354,1.0000000000000002E-2,203.2931579020352,-460.47,432.22263675219398,19098.119379004656,null,76,300,-3.6533537278271111,303.6533537278271,-4687.6778271203602,-300,null,76,-300,3.6533537278271111,-303.6533537278271,4687.6778271203602,300]
[null,77,876.04,31.526933177629431,844.51306682237055,36987.806746332943,0.01,378.32319813155317,-876.04,821.61494042121797,35511.506368242051,null,77,1271.3499999999999,45.75338306064355,1225.5966169393564,53678.463055832901,0.01,549.04059672772257,-1271.3499999999999,1192.3657880720484,51535.98640820694,null,77,460.47,16.571489072246127,443.89851092775388,19441.888375767601,0.01,198.85786886695354,-460.47,431.86275152655202,18665.896742252462,null,77,310,-3.9063981892669672,313.90639818926695,-5001.5842253096271,-310,null,77,-310,3.9063981892669672,-313.90639818926695,5001.5842253096271,310]
[null,78,876.04,30.823172288610788,845.21682771138921,36142.589918621554,0.01,369.87806746332944,-876.04,820.93083178311213,34689.891427820832,null,78,1271.3499999999999,44.73205254652742,1226.6179474534724,52451.845108379428,0.01,536.78463055832901,-1271.3499999999999,1191.372977383545,50343.62062013489,null,78,460.47,16.201573646473001,444.26842635352705,18997.619949414075,0.01,194.41888375767601,-460.47,431.5031659552194,18234.033990725911,null,78,320,-4.1679868544246892,324.16798685442467,-5325.7522121640513,-320,null,78,-320,4.1679868544246892,-324.16798685442467,5325.7522121640513,320]
[null,79,876.04,30.118824932184626,845.92117506781528,35296.668743553739,0.01,361.42589918621553,-876.04,820.24729276053517,33868.960596037723,null,79,1271.3499999999999,43.709870923649525,1227.6401290763504,51224.204979303075,0.01,524.51845108379428,-1271.3499999999999,1190.3809933482994,49152.247642751347,null,79,460.47,15.831349957845063,444.63865004215495,18552.981299371921,0.01,189.97619949414076,-460.47,431.14387978869217,17802.530824770693,null,79,{"$f":"AJ103+10","v":330},{"$f":"AM103*$D$19/12","v":-4.4381268434700427},{"$f":"AJ104-AK104","v":334.43812684347006},{"$f":"AM103-AL104","v":-5660.1903390075213},{"$f":"-AJ104","v":-330},null,79,-330,{"$f":"AT103*$D$19/12","v":4.4381268434700427},{"$f":"AQ104-AR104","v":-334.43812684347006},{"$f":"AT103-AS104","v":5660.1903390075213},{"$f":"-AQ104","v":330}]
[null,80,876.04,29.413890619628116,846.62610938037187,34450.042634173369,0.01,352.96668743553738,-876.04,819.56432287920279,33048.713303277189,null,80,1271.3499999999999,42.686837482752566,1228.6631625172474,49995.54181678583,0.01,512.24204979303079,-1271.3499999999999,1189.3898352780077,47961.866649403048,null,80,460.47,15.460817749476602,445.00918225052345,18107.972117121397,0.01,185.52981299371922,-460.47,430.78489277767437,17371.386944982001,null,80,340,-4.7168252825062682,344.71682528250625,-6004.9071642900271,-340,null,80,-340,4.7168252825062682,-344.71682528250625,6004.9071642900271,340]
[null,81,876.04,28.708368861811142,847.33163113818887,33602.711003035183,0.01,344.50042634173371,-876.04,818.88192166522572,32229.148980397986,null,81,1271.3499999999999,41.66295151398819,1229.6870484860117,48765.854768299818,0.01,499.95541816785828,-1271.3499999999999,1188.3995024849387,46772.476814125039,null,81,460.47,15.089976764267831,445.38002323573221,17662.592093885665,0.01,181.07972117121398,-460.47,430.42620467307779,16940.602052204325,null,81,350,-5.0040893035750225,355.00408930357503,-6359.9112535936019,-350,null,81,-350,5.0040893035750225,-355.00408930357503,6359.9112535936019,350]
[null,82,876.04,28.002259169195984,848.03774083080395,32754.673262204378,0.01,336.02711003035182,-876.04,818.20008864510987,31410.267058732759,null,82,1271.3499999999999,40.638212306916515,1230.7117876930834,47535.142980606732,0.01,487.65854768299818,-1271.3499999999999,1187.4099942819341,45584.077311640103,null,82,460.47,14.718826744904723,445.7511732550953,17216.84092063057,0.01,176.62592093885667,-460.47,430.06781522602125,16510.175847531249,null,82,360,-5.2999260446613352,365.29992604466133,-6725.2111796382633,-360,null,82,-360,5.2999260446613352,-365.29992604466133,6725.2111796382633,360]
[null,83,876.04,27.295561051836984,848.74443894816295,31905.928823256214,0.01,327.54673262204381,-876.04,817.5188233457543,30592.06697008765,null,83,1271.3499999999999,39.612619150505608,1231.7373808494942,46303.405599757236,0.01,475.3514298060673,-1271.3499999999999,1186.4213099824083,44396.667317358166,null,83,460.47,14.347367433858809,446.12263256614119,16770.718288064429,0.01,172.16840920630571,-460.47,429.70972418783089,16080.108032305227,null,83,370,-5.6043426496985527,375.60434264969854,-7100.8155222879614,-370,null,83,-370,5.6043426496985527,-375.60434264969854,7100.8155222879614,370]
[null,84,876.04,26.588274019380179,849.45172598061981,31056.477097275594,0.01,319.05928823256215,-876.04,816.83812529445299,29774.548146741894,null,84,1271.3499999999999,38.586171333131027,1232.7638286668689,45070.64177109037,9.9999999999999985E-3,463.0340559975723,-1271.3499999999999,1185.4334489003459,43210.246007375761,null,84,460.47,13.975598573387025,446.49440142661302,16324.223886637816,0.01,167.7071828806443,-460.47,429.35193131004024,15650.398308117396,null,84,380,-5.9173462685733007,385.91734626857328,-7486.7328685565344,-380,null,84,-380,5.9173462685733007,-385.91734626857328,7486.7328685565344,380]
[null,85,876.04,25.880397581062994,850.15960241893697,30206.317494856656,0.01,310.56477097275592,-876.04,816.15799401889251,28957.710021447441,null,85,1271.3499999999999,37.558868142575307,1233.7911318574247,43836.850639232944,0.01,450.70641771090368,-1271.3499999999999,1184.4464103503046,42024.812558475416,null,85,460.47,13.603519905531513,446.8664800944685,15877.357406543348,0.01,163.24223886637816,-460.47,428.99443634438927,15221.046376807355,null,85,390,-6.2389440571304453,396.23894405713042,-7882.971812613665,-390,null,85,-390,6.2389440571304453,-396.23894405713042,7882.971812613665,390]
[null,86,876.04,25.171931245713878,850.86806875428613,29355.449426102368,0.01,302.06317494856654,-876.04,815.47842904715378,28141.552027428548,null,86,1271.3499999999999,36.530708866027453,1234.8192911339725,42602.031348098972,0.01,438.36850639232944,-1271.3499999999999,1183.4601936474112,40840.366148125111,null,86,460.47,13.231131172119456,447.23886882788059,15430.118537715467,0.01,158.77357406543348,-460.47,428.63723904282489,14792.051940462965,null,86,400,-6.5691431771780548,406.56914317717803,-8289.5409557908424,-400,null,86,-400,6.5691431771780548,-406.56914317717803,8289.5409557908424,400]
[null,87,876.04,24.462874521751974,851.57712547824804,28503.87230062412,0.01,293.55449426102371,-876.04,814.79942990771019,27326.073598381394,null,87,1271.3499999999999,35.50169279008248,1235.8483072099175,41366.183040889053,1.0000000000000002E-2,426.02031348098978,-1271.3499999999999,1182.4747981073638,39656.905954477697,null,87,460.47,12.858432114762889,447.61156788523715,14982.50696983023,0.01,154.30118537715467,-460.47,428.28033915750052,14363.414701420141,null,87,410,-6.9079507964923685,416.90795079649234,-8706.4489065873349,-410,null,87,-410,6.9079507964923685,-416.90795079649234,8706.4489065873349,410]
[null,88,876.04,23.753226917186765,852.28677308281317,27651.585527541305,0.01,285.03872300624118,-876.04,814.12099612942734,26511.274168473683,null,88,1271.3499999999999,34.471819200740875,1236.8781807992591,40129.304860089796,0.01,413.66183040889052,-1271.3499999999999,1181.4902230464295,38474.43115637033,null,88,460.47,12.485422474858526,447.9845775251415,14534.522392305089,0.01,149.82506969830231,-460.47,427.923736440776,13935.134362262641,null,88,420,-7.2553740888227791,427.2553740888228,-9133.7042806761583,-420,null,88,-420,7.2553740888227791,-427.2553740888228,9133.7042806761583,420]
[null,89,876.04,23.042987939617756,852.99701206038219,26798.588515480922,0.01,276.51585527541306,-876.04,813.44312724156373,25697.153172344257,null,89,1271.3499999999999,33.441087383408167,1237.9089126165918,38891.395947473204,1.0000000000000002E-2,401.29304860089803,-1271.3499999999999,1180.5064677814455,37292.940933323902,null,89,460.47,12.112101993587574,448.35789800641243,14086.164494298677,0.01,145.3452239230509,-460.47,427.56743064521714,13507.210625821865,null,89,430,-7.6114202338967987,437.61142023389681,-9571.315700910056,-430,null,89,-430,7.6114202338967987,-437.61142023389681,9571.315700910056,430]
[null,90,876.04,22.332157096234102,853.70784290376582,25944.880672577157,0.01,267.98588515480924,-876.04,812.76582277376951,24883.710045102693,null,90,1271.3499999999999,32.409496622894338,1238.9405033771056,37652.4554440961,0.01,388.91395947473205,-1271.3499999999999,1179.5235316298172,36112.434465542457,null,90,460.47,11.738470411915564,448.73152958808447,13637.432964710591,0.01,140.86164494298677,-460.47,427.21142152359619,13079.643195176648,null,90,440,-7.9760964174250466,447.97609641742503,-10019.291797327482,-440,null,90,-440,7.9760964174250466,-447.97609641742503,10019.291797327482,440]
[null,91,876.04,21.6207338938143,854.41926610618566,25090.461406470971,0.01,259.44880672577159,-876.04,812.0890822560865,24070.944222328922,null,91,1271.3499999999999,31.377046203413418,1239.9729537965866,36412.482490299517,0.01,376.52455444096103,-1271.3499999999999,1178.5414139095187,34932.910933912637,null,91,460.47,11.36452747059216,449.10547252940785,13188.327492181184,0.01,136.37432964710592,-460.47,426.85570882889073,12652.431773653052,null,91,450,-8.3494098311062341,458.34940983110624,-10477.641207158587,-450,null,91,-450,8.3494098311062341,-458.34940983110624,10477.641207158587,450]
[null,92,876.04,20.90871783872581,855.13128216127416,24235.330124309698,0.01,250.9046140647097,-876.04,811.41290521894803,23258.855140072836,null,92,1271.3499999999999,30.34373540858293,1241.006264591417,35171.476225708102,0.01,364.12482490299516,-1271.3499999999999,1177.5601139390917,33754.369520003122,null,92,460.47,10.990272910150987,449.47972708984906,12738.847765091336,0.01,131.88327492181185,-460.47,426.50029231428437,12225.576064824161,null,92,460,-8.7313676726321567,468.73136767263213,-10946.372574831219,-460,null,92,-460,8.7313676726321567,-468.73136767263213,10946.372574831219,460]
[null,93,876.04,20.196108436924749,855.8438915630752,23379.486232746622,1.0000000000000002E-2,242.35330124309704,-876.04,810.73729119317795,22447.442234853886,null,93,1271.3499999999999,29.309563521423417,1242.0404364785766,33929.435789229523,0.01,351.71476225708102,-1271.3499999999999,1176.5796310376456,32576.809406064032,null,93,460.47,10.615706470909446,449.85429352909057,12288.993471562246,0.01,127.38847765091336,-460.47,426.14517173316625,11799.075772509877,null,93,470,-9.1219771456926821,479.12197714569265,-11425.494551976912,-470,null,93,-470,9.1219771456926821,-479.12197714569265,11425.494551976912,470]
[null,94,876.04,19.482905193955521,856.55709480604446,22522.929137940577,1.0000000000000002E-2,233.79486232746626,-876.04,810.06223970999122,21636.704943660709,null,94,1271.3499999999999,28.274529824357938,1243.0754701756421,32686.360319053882,0.01,339.29435789229524,-1271.3499999999999,1175.5999645248562,31400.229775026386,null,94,460.47,10.240827892968538,450.2291721070315,11838.764299455213,9.9999999999999985E-3,122.88993471562245,-460.47,425.79034683913068,11372.930600776712,null,94,480,-9.5212454599807597,489.52124545998078,-11915.015797436892,-480,null,94,-480,9.5212454599807597,-489.52124545998078,11915.015797436892,480]
[null,95,876.04,18.769107614950482,857.27089238504948,21665.658245555529,0.01,225.22929137940577,-876.04,809.38775030099293,20826.642703950718,null,95,1271.3499999999999,27.238633599211568,1244.1113664007883,31442.248952653092,0.01,326.86360319053881,-1271.3499999999999,1174.6211137209671,30224.62981050153,null,95,460.47,9.8656369162126776,450.60436308378735,11388.159936371427,9.9999999999999985E-3,118.38764299455211,-460.47,425.43581738597715,10947.140253937581,null,95,490,-9.9291798311974109,499.92917983119742,-12414.944977268089,-490,null,95,-490,9.9291798311974109,-499.92917983119742,12414.944977268089,490]
[null,96,876.04,18.054715204629606,857.98528479537038,20807.672960760159,0.01,216.65658245555528,-876.04,808.71382249817839,20017.254953649724,null,96,1271.3499999999999,26.20187412721091,1245.148125872789,30197.100826780304,0.01,314.42248952653091,-1271.3499999999999,1173.6430779467855,29050.008696780562,null,96,460.47,9.4901332803095233,450.97986671969051,10937.180069651737,1.0000000000000002E-2,113.88159936371429,-460.47,425.08158312771036,10521.704436551605,null,96,500,-10.345787481056741,510.34578748105673,-12925.290764749147,-500,null,96,-500,10.345787481056741,-510.34578748105673,12925.290764749147,500]
[null,97,876.04,17.339727467300133,858.70027253269984,19948.972688227459,0.01,208.07672960760161,-876.04,808.04045583393156,19208.541131151545,null,97,1271.3499999999999,25.164250688983586,1246.1857493110163,28950.91507746929,0.01,301.97100826780303,-1271.3499999999999,1172.6658565236878,27876.365618833777,null,97,460.47,9.1143167247097807,451.35568327529023,10485.824386376446,0.01,109.37180069651737,-460.47,424.72764381853926,10096.622853423894,null,97,510,-10.771075637290956,520.77107563729101,-13446.061840386437,-510,null,97,-510,10.771075637290956,-520.77107563729101,13446.061840386437,510]
[null,98,876.04,16.624143906856215,859.4158560931437,19089.556832134316,9.9999999999999985E-3,199.48972688227457,-876.04,807.3676498410274,18400.500675317613,null,98,1271.3499999999999,24.125762564557743,1247.2242374354421,27703.690840033847,0.01,289.5091507746929,-1271.3499999999999,1171.6894487736113,26703.699762310091,null,98,460.47,8.7381869886470387,451.73181301135298,10034.092573365093,1.0000000000000002E-2,104.85824386376447,-460.47,424.37399921287818,9671.8952096053545,null,98,520,-11.205051533655364,531.20505153365536,-13977.266891920093,-520,null,98,-520,11.205051533655364,-531.20505153365536,13977.266891920093,520]
[null,99,876.04,15.907964026778599,860.13203597322138,18229.424796161096,0.01,190.89556832134318,-876.04,806.69540405262887,17593.133025476585,null,99,1271.3499999999999,23.086409033361537,1248.2635909666383,26455.427249067208,0.01,277.03690840033846,-1271.3499999999999,1170.7138540190601,25532.010313536481,null,99,460.47,8.3617438111375773,452.10825618886247,9581.9843171762295,9.9999999999999985E-3,100.34092573365092,-460.47,424.02064906534565,9247.5212103924769,null,99,530,-11.64772240993341,541.64772240993341,-14518.914614330026,-530,null,99,-530,11.64772240993341,-541.64772240993341,14518.914614330026,530]
[null,100,876.04,15.191187330134248,860.84881266986577,17368.575983491231,0.01,182.29424796161098,-876.04,806.02371800228798,16786.437621423956,null,100,1271.3499999999999,22.046189374222674,1249.3038106257773,25206.123438441431,0.01,264.55427249067208,-1271.3499999999999,1169.7390715831029,24361.29645951742,null,100,460.47,7.9849869309801917,452.48501306901983,9129.4993041072103,0.01,95.819843171762301,-460.47,423.66759313076449,8823.5005613271314,null,100,540,-12.099095511941689,552.09909551194164,-15071.013709841967,-540,null,100,-540,12.099095511941689,-552.09909551194164,15071.013709841967,540]
[null,101,876.04,14.473813319576026,861.56618668042393,16507.009796810809,0.01,173.68575983491232,-876.04,805.35259122394473,15980.413903421668,null,101,1271.3499999999999,21.00510286536786,1250.344897134632,23955.778541306798,0.01,252.06123438441432,-1271.3499999999999,1168.7651007893708,23191.557387934317,null,101,460.47,7.6079160867560089,452.86208391324402,8676.6372201939666,0.01,91.294993041072104,-460.47,423.31483116416155,8399.8329681963678,null,101,550,-12.559178091534973,562.55917809153493,-15633.572887933502,-550,null,101,-550,12.559178091534973,-562.55917809153493,15633.572887933502,550]
[null,102,876.04,13.75584149734234,862.28415850265765,15644.725638308151,0.01,165.07009796810809,-876.04,804.68202325192772,15175.061312197722,null,102,1271.3499999999999,19.963148784422334,1251.3868512155775,22704.391690091219,1.0000000000000002E-2,239.55778541306802,-1271.3499999999999,1167.7919409620583,22022.792287144948,null,102,460.47,7.2305310168283059,453.23946898317172,8223.3977512107958,0.01,86.766372201939674,-460.47,422.9623629207677,7976.5181370322061,null,102,560,-13.027977406611251,573.02797740661129,-16206.600865340113,-560,null,102,-560,13.027977406611251,-573.02797740661129,16206.600865340113,560]
[null,103,876.04,13.037271365256792,863.00272863474322,14781.722909673408,0.01,156.44725638308151,-876.04,804.01201362095287,14370.379288945795,null,103,1271.3499999999999,18.920326408409348,1252.4296735915905,21451.96201649963,9.9999999999999985E-3,227.04391690091217,-1271.3499999999999,1166.8195914259229,20855.000346182889,null,103,460.47,6.8528314593423296,453.6171685406577,7769.7805826701378,0.01,82.233977512107955,-460.47,422.61018815601784,7553.555774111438,null,103,570,-13.505500721116761,583.50550072111673,-16790.106366061231,-570,null,103,-570,13.505500721116761,-583.50550072111673,16790.106366061231,570]
[null,104,876.04,12.31810242472784,863.72189757527212,13918.001012098135,0.01,147.81722909673408,-876.04,803.34256186612356,13566.367275324841,null,104,1271.3499999999999,17.876635013749691,1253.4733649862503,20198.48865151338,0.01,214.5196201649963,-1271.3499999999999,1165.8480515062849,19688.180754756966,null,104,460.47,6.474817152225115,453.99518284777491,7315.7853998223627,0.01,77.697805826701384,-460.47,422.25830662555029,7130.94558595542,null,104,580,-13.991755305051027,593.99175530505102,-17384.098121366282,-580,null,104,-580,13.991755305051027,-593.99175530505102,17384.098121366282,580]
[null,105,876.04,11.598334176748446,864.44166582325147,13053.559346274884,0.01,139.18001012098136,-876.04,802.67366752293049,12763.024713458717,null,105,1271.3499999999999,16.832073876261152,1254.5179261237388,18943.970725389641,1.0000000000000002E-2,201.98488651513384,-1271.3499999999999,1164.8773205290252,18522.332703250682,null,105,460.47,6.0964878331853027,454.37351216681475,6861.4118876555476,0.01,73.157853998223629,-460.47,421.90671808520682,6708.6872793298699,null,105,590,-14.486748434471901,604.48674843447191,-17988.584869800754,-590,null,105,-590,14.486748434471901,-604.48674843447191,17988.584869800754,590]
[null,106,876.04,10.877966121895737,865.16203387810424,12188.397312396779,0.01,130.53559346274884,-876.04,802.00533012725089,11960.351045935786,null,106,1271.3499999999999,15.786642271158035,1255.5633577288418,17688.407367660799,0.01,189.43970725389642,-1271.3499999999999,1163.9073978205865,17357.455382721659,null,106,460.47,5.7178432397129564,454.75215676028705,6406.6597308952605,0.01,68.61411887655548,-460.47,421.55542229103264,6286.7805612446627,null,106,600,-14.990487391500629,614.99048739150066,-18603.575357192254,-600,null,106,-600,14.990487391500629,-614.99048739150066,18603.575357192254,600]
[null,107,876.04,10.156997760330649,865.88300223966928,11322.51431015711,0.01,121.88397312396779,-876.04,801.33754921534876,11158.345715808535,null,107,1271.3499999999999,14.740339473050666,1256.6096605269493,16431.79770713385,0.01,176.88407367660798,-1271.3499999999999,1162.9382827079726,16193.547984901074,null,107,460.47,5.3388831090793838,455.13111689092062,5951.5286140043399,0.01,64.066597308952609,-460.47,421.20441899927602,5865.2251389536304,null,107,610,-15.502979464326879,625.50297946432693,-19229.078336656581,-610,null,107,-610,15.502979464326879,-625.50297946432693,19229.078336656581,610]
[null,108,876.04,9.4354285917975922,866.60457140820233,10455.909738748907,0.01,113.22514310157111,-876.04,800.6703243238743,10357.008166593187,null,108,1271.3499999999999,13.693164755944876,1257.6568352440549,15174.140871889795,0.01,164.3179770713385,-1271.3499999999999,1161.9699745187468,15030.6097021931,null,108,460.47,4.9596071783369498,455.51039282166306,5496.0182211826768,0.01,59.515286140043401,-460.47,420.85370796638824,5444.0207199543547,null,108,620,-16.024231947213817,636.02423194721382,-19865.102568603794,-620,null,108,-620,16.024231947213817,-636.02423194721382,19865.102568603794,620]
[null,109,876.04,8.7132581156240896,867.32674188437591,9588.5829968645321,0.01,104.55909738748908,-876.04,800.00365498986184,9556.3378422693131,null,109,1271.3499999999999,12.645117393241497,1258.7048826067585,13915.435989283036,0.01,151.74140871889796,-1271.3499999999999,1161.0024725810345,13868.639727674354,null,109,460.47,4.5800151843188974,455.88998481568115,5040.1282363669961,0.01,54.960182211826769,-460.47,420.50328894902282,5023.1670119879664,null,109,630,-16.554252140503163,646.55425214050319,-20511.656820744298,-630,null,109,-630,16.554252140503163,-646.55425214050319,20511.656820744298,630]
[null,110,876.04,7.990485830720444,868.04951416927952,8720.533482695253,0.01,95.885829968645325,-876.04,799.33754075073398,8756.3341872794517,null,110,1271.3499999999999,11.596196657735865,1259.7538033422641,12655.682185940772,0.01,139.15435989283037,-1271.3499999999999,1160.0357762235171,12707.637255093319,null,110,460.47,4.2001068636391636,456.26989313636085,4583.858343230635,0.01,50.401282363669964,-460.47,420.1531617040369,4602.6637230389433,null,110,640,-17.09304735062025,657.09304735062028,-21168.749868094917,-640,null,110,-640,17.09304735062025,-657.09304735062028,21168.749868094917,640]
[null,111,876.04,7.2671112355793781,868.7728887644206,7851.7605939308323,0.01,87.205334826952537,-876.04,798.67198114429664,7956.996646528718,null,111,1271.3499999999999,10.546401821617311,1260.8035981783826,11394.878587762389,1.0000000000000002E-2,126.55682185940775,-1271.3499999999999,1159.0698847754379,11547.601478869801,null,111,460.47,3.8198819526921959,456.65011804730784,4127.2082251833272,0.01,45.838583432306351,-460.47,419.80332598848946,4182.510561334906,null,111,{"$f":"AJ135+10","v":650},{"$f":"AM135*$D$19/12","v":-17.640624890079099},{"$f":"AJ136-AK136","v":667.64062489007915},{"$f":"AM135-AL136","v":-21836.390492984996},{"$f":"-AJ136","v":-650},null,111,-650,{"$f":"AT135*$D$19/12","v":17.640624890079099},{"$f":"AQ136-AR136","v":-667.64062489007915},{"$f":"AT135-AS136","v":21836.390492984996},{"$f":"-AQ136","v":650}]
[null,112,876.04,6.5431338282756935,869.49686617172426,6982.2637277591084,0.01,78.517605939308325,-876.04,798.00697570874092,7158.3246653844217,null,112,1271.3499999999999,9.495732156468657,1261.8542678435313,10133.024319918857,0.01,113.94878587762389,-1271.3499999999999,1158.1047975665977,10388.531594094364,null,112,460.47,3.4393401876527729,457.03065981234727,3670.1775653709801,0.01,41.272082251833275,-460.47,419.45378155964187,3762.7072353464164,null,112,660,-18.196992077487497,678.19699207748749,-22514.587485062482,-660,null,112,-660,18.196992077487497,-678.19699207748749,22514.587485062482,660]
[null,113,876.04,5.8185531064659237,870.22144689353399,6112.0422808655749,0.01,69.822637277591085,-876.04,797.34252398264266,6360.3176896756804,null,113,1271.3499999999999,8.4441869332657138,1262.9058130667343,8870.1185068521227,0.01,101.33024319918857,-1271.3499999999999,1157.1405139273543,9230.4267965277668,null,113,460.47,3.058481304475817,457.41151869552419,3212.766046675456,0.01,36.701775653709802,-460.47,419.10452817495735,3343.2534537867746,null,113,670,-18.76215623755207,688.76215623755206,-23203.349641300036,-670,null,113,-670,18.76215623755207,-688.76215623755206,23203.349641300036,670]
[null,114,876.04,5.0933685673879792,870.94663143261198,5241.095649432963,0.01,61.120422808655746,-876.04,796.6786255049617,5562.9751656930375,null,114,1271.3499999999999,7.3917654223767686,1263.9582345776232,7606.1602722744992,0.01,88.701185068521227,-1271.3499999999999,1156.1770331886248,8073.2862826004121,null,114,460.47,2.6773050388962134,457.79269496110379,2754.9733517143522,0.01,32.127660466754563,-460.47,418.75556559210156,2924.148925611817,null,114,680,-19.336124701083364,699.33612470108335,-23902.685766001119,-680,null,114,-680,19.336124701083364,-699.33612470108335,23902.685766001119,680]
[null,115,876.04,4.367579707860803,871.67242029213912,4369.4232291408243,1.0000000000000002E-2,52.410956494329639,-876.04,796.01527981504182,4766.2965401880756,null,115,1271.3499999999999,6.3384668935620825,1265.0115331064378,6341.1487391680612,0.01,76.061602722744993,-1271.3499999999999,1155.2143546818825,6917.1092494117875,null,115,460.47,2.2958111264286267,458.17418887357138,2296.7991628407808,0.01,27.549733517143522,-460.47,418.40689356894165,2505.3933600197156,null,115,690,-19.918904805000931,709.91890480500092,-24612.604670806119,-690,null,115,-690,19.918904805000931,-709.91890480500092,24612.604670806119,690]
[null,116,876.04,3.6411860242840199,872.39881397571594,3497.0244151651086,0.01,43.694232291408241,-876.04,795.35248645261038,3970.2812603730335,null,116,1271.3499999999999,5.2842906159733847,1266.0657093840266,5075.0830297840348,0.01,63.411487391680616,-1271.3499999999999,1154.2524777391575,5761.894894729905,null,116,460.47,1.9139993023673174,458.55600069763273,1838.2431621431481,0.01,22.967991628407809,-460.47,418.05851186354636,2086.9864664507741,null,116,700,-20.510503892338431,720.51050389233842,-25333.115174698458,-700,null,116,-700,20.510503892338431,-720.51050389233842,25333.115174698458,700]
[null,117,876.04,2.9141870126375906,873.12581298736234,2623.8986021777464,0.01,34.970244151651087,-876.04,794.69024495777796,3174.9287739204233,null,117,1271.3499999999999,4.2292358581533627,1267.1207641418466,3807.962265642188,0.01,50.750830297840352,-1271.3499999999999,1153.2914016930358,4607.6424169907477,null,117,460.47,1.5318693017859568,458.93813069821408,1379.305031444934,0.01,18.382431621431483,-460.47,417.71042023418596,1668.9279545872275,null,117,710,-21.110929312248714,731.11092931224869,-26064.226104010708,-710,null,117,-710,21.110929312248714,-731.11092931224869,26064.226104010708,710]
[null,118,876.04,2.1865821684814555,873.85341783151853,1750.0451843462279,0.01,26.238986021777464,-876.04,794.02855487103818,2380.2385289626454,null,118,1271.3499999999999,3.1733018880351569,1268.1766981119647,2539.7855675302235,0.01,38.079622656421883,-1271.3499999999999,1152.3311258766598,3454.3510152977124,null,118,460.47,1.1494208595374451,459.3205791404626,919.98445230447146,1.0000000000000002E-2,13.793050314449342,-460.47,417.36261843933192,1251.2175343530416,null,118,720,-21.720188420008924,741.72018842000898,-26805.946292430715,-720,null,118,-720,21.720188420008924,-741.72018842000898,26805.946292430715,720]
[null,119,876.04,{"$f":"IF(OR($I$5=1,$I$5=3),F143*$D$19/12,IF($I$5=2,ROUND(F143*$D$19/12,2),ROUNDDOWN(F143*$D$19/12,2)))","v":1.45837098695519},874.58162901304479,{"$f":"IF($I$5<>2,F143-E144,ROUND(F143-E144,2))","v":875.46355533318308},0.01,17.50045184346228,-876.04,793.36741573326708,{"$f":"J144+K145","v":1586.2099740916071},null,119,1271.3499999999999,2.1164879729418531,1269.2335120270582,1270.5520555031653,1.0000000000000002E-2,25.397855675302239,-1271.3499999999999,1151.3716496237264,2302.0198894210525,null,119,460.47,0.76665371025372631,459.70334628974632,460.28110601472514,1.0000000000000002E-2,9.1998445230447157,-460.47,417.01510623765688,{"$f":"AG145+AF144","v":833.85491591370976},null,119,730,-22.338288577025597,752.33828857702565,-27558.284581007742,-730,null,119,-730,22.338288577025597,-752.33828857702565,27558.284581007742,730]
[null,120,{"$f":"IF($I$5=1,E145+D145,ROUND(E145+D145,2))","v":876.19},{"$f":"IF(OR($I$5=1,$I$5=3),F144*$D$19/12,IF($I$5=2,ROUND(F144*$D$19/12,2),ROUNDDOWN(F144*$D$19/12,2)))","v":0.72955296277765258},{"$f":"F144","v":875.46355533318308},{"$f":"IF($I$5<>2,F144-E145,ROUND(F144-E145,2))","v":0},{"$f":"D145*12/F144","v":0.01},{"$f":"G145*F144","v":8.7546355533318305},{"$f":"-C145","v":-876.19},{"$f":"C145*(1+$J$21)^(-B145/12)","v":792.84255835834006},{"$f":"J145","v":792.84255835834006},null,120,{"$f":"IF($I$5=1,P145+O145,ROUND(P145+O145,2))","v":1271.6099999999999},1.0587933795859712,{"$f":"IF($I$5<>2,Q144,ROUND(Q144,2))","v":1270.5520555031653},0,0.01,12.705520555031654,-1271.6099999999999,1150.6482397973259,{"$f":"U145","v":1150.6482397973259},null,120,{"$f":"IF($I$5=1,AA145+Z145,ROUND(AA145+Z145,2))","v":460.66},0.38356758834560428,{"$f":"IF($I$5<>2,AB144,ROUND(AB144,2))","v":460.28110601472514},0,0.01,4.6028110601472516,-460.66,416.83980967605288,{"$f":"AF145","v":416.83980967605288},null,120,{"$f":"AL145+AK145","v":-27581.24981815858},-22.965237150839783,{"$f":"AM144","v":-27558.284581007742},0,27581.24981815858,null,120,{"$f":"AS145+AR145","v":27581.24981815858},22.965237150839783,{"$f":"AT144","v":27558.284581007742},0,-27581.24981815858]
[null,null,{"$f":"SUM(C26:C145)","v":105124.94999999976},{"$f":"SUM(D26:D145)","v":5124.9531082959938},{"$f":"SUM(E26:E145)","v":99999.999999999956},{"$f":"SUM(F25:F145)","v":6149943.7299551908},null,null,{"$f":"IRR(I25:I145,1/1200)","v":8.3333286023590247E-4},null,null,null,null,{"$f":"SUM(N26:N145)","v":106281.26000000014},{"$f":"SUM(O26:O145)","v":6281.2608488828082},{"$f":"SUM(P26:P145)","v":99999.999999999927},{"$f":"SUM(Q25:Q145)","v":7537513.0186593672},null,null,{"$f":"IRR(T25:T145,1/1200)","v":8.3333322758738504E-4},null,null,null,null,{"$f":"SUM(Y26:Y145)","v":103909.39000000007},{"$f":"SUM(Z26:Z145)","v":3909.3946736030575},{"$f":"SUM(AA26:AA145)","v":100000.00000000003},{"$f":"SUM(AB25:AB145)","v":4691273.60832367},null,null,{"$f":"IRR(AE25:AE145,1/1200)","v":8.3333240565375277E-4},null,null,null,null,{"$f":"SUM(AJ26:AJ145)","v":-571.24981815857973},{"$f":"SUM(AK26:AK145)","v":-571.24981815858382},{"$f":"SUM(AL26:AL145)","v":0},null,{"$f":"IRR(AN25:AN145,1/1200)","v":8.3333333333324155E-4},null,null,{"$f":"SUM(AQ26:AQ145)","v":571.24981815857973},{"$f":"SUM(AR26:AR145)","v":571.24981815858382},{"$f":"SUM(AS26:AS145)","v":0},null,{"$f":"IRR(AU25:AU145,1/1200)","v":8.3333333333324155E-4}]
[null,null,{"$f":"E146+D146","v":105124.95310829594},null,null,null,null,null,null,null,null,null,null,{"$f":"P146+O146","v":106281.26084888274},null,null,null,null,null,null,null,null,null,null,{"$f":"AA146+Z146","v":103909.39467360309},null,null,null,null,null,null,null,null,null,null,{"$f":"AL146+AK146","v":-571.24981815858382},null,null,null,null,null,null,{"$f":"AS146+AR146","v":571.24981815858382}]
[null,"Abandon d'intérêts par la banque",null,null,null,null,null,null,null,null,null,null,"Abandon d'intérêts par la banque",null,null,null,null,null,null,null,null,null,null,"Abandon d'intérêts par la banque"]
[null,null,{"$f":"C146-C147","v":-3.1082961795618758E-3},null,null,null,{"$f":"COUNTIF(G26:G145,\"<=0,01\")","v":120},"Inférieurs au taux contractuel",null,null,null,null,null,{"$f":"N146-N147","v":-8.4888259880244732E-4},null,null,null,{"$f":"COUNTIF(R26:R145,\"<=0,01\")","v":120},"Inférieurs au taux contractuel",null,null,null,null,null,{"$f":"Y146-Y147","v":-4.6736030199099332E-3},null,null,null,{"$f":"COUNTIF(AC26:AC145,\"<=0,01\")","v":120},"Inférieurs au taux contractuel"]
[null,null,null,null,null,null,{"$f":"COUNTIF(G26:G145,\">0,01\")","v":0},"Supérieurs au taux contractuel",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(R26:R145,\">0,01\")","v":0},"Supérieurs au taux contractuel",null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(AC26:AC145,\">0,01\")","v":0},"Supérieurs au taux contractuel"]
[null,null,null,null,null,null,{"$f":"COUNT(G26:G145)","v":120},"Total",null,null,null,null,null,null,null,null,null,{"$f":"COUNT(R26:R145)","v":120},"Total",null,null,null,null,null,null,null,null,null,{"$f":"COUNT(AC26:AC145)","v":120},"Total"]
[]
[null,"Aucun arrondi (Cas d'école)"]
[null,"Arrondis monétaires 2 décimales au plus proche partout"]
[null,"Arrondis monétaires 2 décimales au plus proche sur échéances seulement"]
[null,"Arrondis monétaires 2 décimales au plus proche sur échéances et à l'inférieur sur intérêts"]

{"sheet":"Feuil2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Feuil3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}