{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Калькулятор"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Калькулятор","index":0,"n_rows":186,"n_cols":18,"rows_kept":186,"cut":false,"hidden":false,"merged":[[33,2,33,3],[13,2,13,3],[11,2,11,3],[10,2,10,3],[12,2,12,3],[20,1,20,5],[4,1,5,3],[25,2,25,3],[15,2,15,3],[19,2,19,3],[18,2,18,3],[17,2,17,3],[7,2,7,3],[23,2,23,3],[22,1,23,1],[1,11,2,16],[17,8,17,9],[1,5,1,9],[2,5,2,9],[4,8,5,9],[4,5,5,6]]}
[]
[null,null,null,null,null,"Дата розрахунку",null,null,null,null,null,"Орієнтовний графік"]
[null,null,null,null,null,{"$f":"TODAY()","v":"2022-02-18"}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"PMT($M$4,$C$14,-C12)","v":38382.430809345358},1.1012404724422083E-2,{"$f":"INDIRECT(\"Калькулятор!Q\"&6+C14)","v":-3.5310222301632166E-8}]
[null,"Параметри кредиту*",null,null,null,"Супровідні послуги третіх осіб",null,null,"Результат розрахунків: **",null,null,"Період","Дата платежу","Погашення по тілу кредита","Проценти по кредиту","Щомісячний платіж","Залишок тіла кредиту"]
[null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"TODAY()","v":"2022-02-18"},{"$f":"SUM(N7:N366)","v":3000000.0000000359},{"$f":"SUM(O7:O366)","v":3908837.5456821332},{"$f":"-C12+(C8-C10)*C23+G8+G10+G12+G14+G16","v":-2902085.71423},{"$f":"C12","v":3000000}]
[null,null,null,null,null,null,null,null,null,null,1,{"$f":"IF(K7>$C$14,\"\",K7)","v":1},{"$f":"IF(L7<=$C$14,EDATE($M$6,L7),\"\")","v":"2022-03-18"},{"$f":"IF(M7=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P7-O7))","v":4657.4308093453583},{"$f":"IF(L7<=$C$14,Q6*R7/12,\"\")","v":33725},{"$f":"IF(M7=\"\",\"\",\nIF($C$26=\"Стандарт\",N7+O7,$L$4\n))","v":38382.430809345358},{"$f":"IF(M7=\"\",\"\",Q6-N7)","v":2995342.5691906544},{"$f":"IF(L7>$C$14,\"\",\nIF(L7>$C$34,$C$18,$C$16))","v":0.13489999999999999}]
[null,"Вартість нерухомості, грн",4285714.29,null,null,"Страхування майна (предмету іпотеки), щорічно, грн",{"$f":"0.3%*C8","v":12857.14287},null,"Платіж в першому місяці, грн",{"$f":"P7","v":38382.430809345358},2,2,"2022-04-18",{"$f":"IF(M8=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P8-IF(MOD(L8,12)=1,$G$8+$G$10,0)-O8))","v":4709.7880940270843},33672.642715318274,{"$f":"IF(M8=\"\",\"\",\nIF($C$26=\"Стандарт\",N8+O8+IF(MOD(L8,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L8,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},2990632.7810966275,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,3,3,"2022-05-18",4762.7339618507758,33619.696847494582,38382.430809345358,2985870.0471347766,0.13489999999999999]
[null,"Авансовий платіж (перший внесок)",1285714.29,{"$f":"C10/C8","v":0.30000000069999999},null,"Страхування від нещасного випадку Позичальника, грн",{"$f":"0%*C12","v":0},null,"Загальні витрати по кредиту, грн",{"$f":"O6+C23*(C8-C10)+G8*C14/12+G10+G12+G14","v":4143894.6887321332},4,4,"2022-06-18",4816.2750294719153,33566.155779873443,38382.430809345358,2981053.7721053045,0.13489999999999999]
[null,{"$f":"IF(C11=\"\",\"\",\"Помилка:\")","v":""},{"$f":"IF(D10<30%,\"Некоректний мінімальний аванс\",\"\")","v":""},null,null,null,null,null,null,null,5,5,"2022-07-18",4870.4179879282237,33512.012821417135,38382.430809345358,2976183.3541173763,0.13489999999999999]
[null,"Сума кредиту, грн",{"$f":"C8-C10+IF(D23=\"В кредит\",C23*(C8-C10),0)","v":3000000},null,null,"Послуги оцінювача, грн.",2500,null,"Загальна вартість кредиту, грн",{"$f":"C12+G8*C14/12+G10+G12+G14+O6+IF(D23=\"В кредит\",0,C23*(C8-C10))","v":7143894.6887321332},6,6,"2022-08-18",4925.169603475857,33457.261205869501,38382.430809345358,2971258.1845139004,0.13489999999999999]
[null,{"$f":"IF(C13=\"\",\"\",\"Помилка:\")","v":""},{"$f":"IF(OR(C12<300000,C12>3000000),\"Сума кредиту від 300 000 до 3 000 000 грн\",\"\")","v":""},null,null,null,null,null,null,null,7,7,"2022-09-18",4980.5367184349307,33401.894090910428,38382.430809345358,2966277.6477954653,0.13489999999999999]
[null,"Строк кредиту, міс",180,null,null,"Послуги нотаріуса, разово, грн",10000,null,"Реальна річна процентна ставка",{"$f":"XIRR(P6:OFFSET(P6,C14,0),M6:OFFSET(M6,C14,0))","v":0.15345804095268253},8,8,"2022-10-18",5036.5262520446704,33345.904557300688,38382.430809345358,2961241.1215434205,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,9,9,"2022-11-18",5093.1452013280723,33289.285608017286,38382.430809345358,2956147.9763420923,0.13489999999999999]
[null,"Процентна ставка, перші 3 роки, % річних",0.13489999999999999,null,null,"Збори на обов’язкове пенсійне страхування, грн",{"$f":"1%*C8","v":42857.142899999999},null,null,null,10,10,"2022-12-18",5150.4006419663419,33232.030167379016,38382.430809345358,2950997.5757001261,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,11,11,"2023-01-18",5208.2997291831052,33174.131080162253,38382.430809345358,2945789.2759709428,0.13489999999999999]
[null,"Процентна ставка, з 4-го року, % річних :",{"$f":"C19+C20","v":0.1298},null,null,null,null,null,"Для розрахунку нажміть клавішу \"Розрахунок графіку\"",null,12,12,"2023-02-18",5266.8496986386817,33115.581110706677,38382.430809345358,2940522.4262723043,0.13489999999999999]
[null,"UIRD 12M (змінювана)",8.9800000000000005E-2,null,null,null,null,null,null,null,13,13,"2023-03-18",5326.0578673342025,33056.372942011156,{"$f":"IF(M19=\"\",\"\",\nIF($C$26=\"Стандарт\",N19+O19+IF(MOD(L19,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L19,12)=1,$G$8+$G$10,0)\n))","v":51239.573679345354},2935196.36840497,0.13489999999999999]
[null,"Маржа (фіксована)",0.04,null,null,null,null,null,null,null,14,14,"2023-04-18",5385.9316345261541,32996.499174819204,38382.430809345358,2929810.4367704438,0.13489999999999999]
[null,"Актуальне значення UIRD 12M UAH (12 місяців) можна переглянути за посиланням та використати для розрахунку",null,null,null,null,null,null,null,null,15,15,"2023-05-18",5446.4784826509567,32935.952326694402,38382.430809345358,2924363.9582877927,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,16,16,"2023-06-18",5507.7059782600918,32874.724831085266,38382.430809345358,2918856.2523095328,0.13489999999999999]
[null,"Разова комісія",9.9000000000000008E-3,"Оплата самостійно",null,null,null,null,null,null,17,17,"2023-07-18",5569.6217729657001,32812.809036379658,38382.430809345358,2913286.630536567,0.13489999999999999]
[null,null,{"$f":"C23*(C8-C10)","v":29700.000000000004},null,null,null,null,null,null,null,18,18,"2023-08-18",5632.2336043967844,32750.197204948574,38382.430809345358,2907654.3969321703,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,19,19,"2023-09-18",5695.5492971662134,32686.881512179145,38382.430809345358,2901958.8476350042,0.13489999999999999]
[null,"Схема погашення (ануїтет / стандарт)","Ануїтет",null,null,null,null,null,null,null,20,20,"2023-10-18",5759.5767638485231,32622.854045496835,38382.430809345358,2896199.2708711559,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,21,21,"2023-11-18",5824.3240059687814,32558.106803376577,38382.430809345358,2890374.946865187,0.13489999999999999]
[null,"*Комірки залиті даним кольором доступні до редагування",null,null,null,null,null,null,null,null,22,22,"2023-12-18",5889.7991150025482,32492.63169434281,38382.430809345358,2884485.1477501844,0.13489999999999999]
[null,"У файлі присутні макроси, для коректного розрахунку прохання перевірити їх доступність:",null,null,null,null,null,null,null,null,23,23,"2024-01-18",5956.0102733870335,32426.420535958325,38382.430809345358,2878529.1374767972,0.13489999999999999]
[null,"\"Файл\" - \"Параметры\" - \"Центр управления безопасностью\" - \"Параметры центра управления безопасностью\" - \"Параметры макросов\" - \"Включить все макросы\"",null,null,null,null,null,null,null,null,24,24,"2024-02-18",6022.965755543697,32359.465053801661,38382.430809345358,2872506.1717212535,0.13489999999999999]
[null,"Перезапустіть Excel (повністю його закривши, і відкривши знову), щоб зміни вступили в силу.",null,null,null,null,null,null,null,null,25,25,"2024-03-18",6090.673928912267,32291.756880433091,{"$f":"IF(M31=\"\",\"\",\nIF($C$26=\"Стандарт\",N31+O31+IF(MOD(L31,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L31,12)=1,$G$8+$G$10,0)\n))","v":51239.573679345354},2866415.4977923413,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,26,26,"2024-04-18",6159.1432549964557,32223.287554348903,38382.430809345358,2860256.354537345,0.13489999999999999]
[null,"**Сума розрахунків є орієнтовною, конкретні умови кредитування будуть вказані в паспорті споживчого кредиту",null,null,null,null,null,null,null,null,27,27,"2024-05-18",6228.3822904213739,32154.048518923984,38382.430809345358,2854027.9722469235,0.13489999999999999]
[null,"Строк пільгового періода, міс",{"$f":"IF(C14>36,36,C14)","v":36},null,null,null,null,null,null,null,28,28,"2024-06-18",6298.3996880028608,32084.031121342497,38382.430809345358,2847729.5725589208,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,29,29,"2024-07-18",6369.2041978288216,32013.226611516537,38382.430809345358,2841360.3683610922,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,30,30,"2024-08-18",6440.80466835275,31941.626140992608,38382.430809345358,2834919.5636927392,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,31,31,"2024-09-18",6513.2100474994841,31869.220761845874,38382.430809345358,2828406.35364524,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,32,32,"2024-10-18",6586.4293837834557,31796.001425561903,38382.430809345358,2821819.9242614564,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,33,{"$f":"IF(K39>$C$14,\"\",K39)","v":33},{"$f":"IF(L39<=$C$14,EDATE($M$6,L39),\"\")","v":"2024-11-18"},6660.4718274394872,{"$f":"IF(L39<=$C$14,Q38*R39/12,\"\")","v":31721.958981905871},38382.430809345358,{"$f":"IF(M39=\"\",\"\",Q38-N39)","v":2815159.4524340169},{"$f":"IF(L39>$C$14,\"\",\nIF(L39>$C$34,$C$18,$C$16))","v":0.13489999999999999}]
[null,null,null,null,null,null,null,null,null,null,34,34,"2024-12-18",{"$f":"IF(M40=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P40-IF(MOD(L40,12)=1,$G$8+$G$10,0)-O40))","v":6735.3466315662845},31647.084177779074,{"$f":"IF(M40=\"\",\"\",\nIF($C$26=\"Стандарт\",N40+O40+IF(MOD(L40,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L40,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},2808424.1058024508,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,35,35,"2025-01-18",6811.0631532828083,31571.36765606255,38382.430809345358,2801613.0426491681,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,36,36,"2025-02-18",6887.6308548976267,31494.799954447732,38382.430809345358,2794725.4117942704,0.13489999999999999]
[null,null,null,null,null,null,null,null,null,null,37,37,"2025-03-18",8152.8176051040027,30229.613204241356,51239.573679345354,2786572.5941891666,0.1298]
[null,null,null,null,null,null,null,null,null,null,38,38,"2025-04-18",8241.0039155325394,30141.426893812819,38382.430809345358,2778331.5902736341,0.1298]
[null,null,null,null,null,null,null,null,null,null,39,39,"2025-05-18",8330.1441078855532,30052.286701459805,38382.430809345358,2770001.4461657484,0.1298]
[null,null,null,null,null,null,null,null,null,null,40,40,"2025-06-18",8420.2484999858461,29962.182309359512,38382.430809345358,2761581.1976657626,0.1298]
[null,null,null,null,null,null,null,null,null,null,41,41,"2025-07-18",8511.3275212606932,29871.103288084665,38382.430809345358,2753069.8701445018,0.1298]
[null,null,null,null,null,null,null,null,null,null,42,42,"2025-08-18",8603.3917139489968,29779.039095396362,38382.430809345358,2744466.4784305529,0.1298]
[null,null,null,null,null,null,null,null,null,null,43,43,"2025-09-18",8696.4517343215448,29685.979075023813,38382.430809345358,2735770.0266962312,0.1298]
[null,null,null,null,null,null,null,null,null,null,44,44,"2025-10-18",8790.51835391446,29591.912455430898,38382.430809345358,2726979.5083423168,0.1298]
[null,null,null,null,null,null,null,null,null,null,45,45,"2025-11-18",8885.6024607759646,29496.828348569394,38382.430809345358,2718093.9058815408,0.1298]
[null,null,null,null,null,null,null,null,null,null,46,46,"2025-12-18",8981.7150607266922,29400.715748618666,38382.430809345358,2709112.1908208141,0.1298]
[null,null,null,null,null,null,null,null,null,null,47,47,"2026-01-18",9078.8672786335519,29303.563530711806,38382.430809345358,2700033.3235421805,0.1298]
[null,null,null,null,null,null,null,null,null,null,48,48,"2026-02-18",9177.0703596974381,29205.36044964792,38382.430809345358,2690856.2531824829,0.1298]
[null,null,null,null,null,null,null,null,null,null,49,49,"2026-03-18",9276.3356707548373,29106.095138590521,51239.573679345354,2681579.9175117281,0.1298]
[null,null,null,null,null,null,null,null,null,null,50,50,"2026-04-18",9376.6747015934998,29005.756107751859,38382.430809345358,2672203.2428101348,0.1298]
[null,null,null,null,null,null,null,null,null,null,51,51,"2026-05-18",9478.0990662824006,28904.331743062958,38382.430809345358,2662725.1437438522,0.1298]
[null,null,null,null,null,null,null,null,null,null,52,52,"2026-06-18",9580.6205045160277,28801.810304829331,38382.430809345358,2653144.523239336,0.1298]
[null,null,null,null,null,null,null,null,null,null,53,53,"2026-07-18",9684.2508829732069,28698.179926372151,38382.430809345358,2643460.2723563625,0.1298]
[null,null,null,null,null,null,null,null,null,null,54,54,"2026-08-18",9789.0021966907043,28593.428612654654,38382.430809345358,2633671.270159672,0.1298]
[null,null,null,null,null,null,null,null,null,null,55,55,"2026-09-18",9894.8865704515738,28487.544238893784,38382.430809345358,2623776.3835892202,0.1298]
[null,null,null,null,null,null,null,null,null,null,56,56,"2026-10-18",10001.916260188624,28380.514549156735,38382.430809345358,2613774.4673290318,0.1298]
[null,null,null,null,null,null,null,null,null,null,57,57,"2026-11-18",10110.103654402996,28272.327154942363,38382.430809345358,2603664.363674629,0.1298]
[null,null,null,null,null,null,null,null,null,null,58,58,"2026-12-18",10219.461275598122,28162.969533747237,38382.430809345358,2593444.902399031,0.1298]
[null,null,null,null,null,null,null,null,null,null,59,59,"2027-01-18",10330.00178172917,28052.429027616188,38382.430809345358,2583114.9006173019,0.1298]
[null,null,null,null,null,null,null,null,null,null,60,60,"2027-02-18",10441.737967668207,27940.692841677152,38382.430809345358,2572673.1626496338,0.1298]
[null,null,null,null,null,null,null,null,null,null,61,61,"2027-03-18",10554.68276668515,27827.748042660209,51239.573679345354,2562118.4798829486,0.1298]
[null,null,null,null,null,null,null,null,null,null,62,62,"2027-04-18",10668.849251944801,27713.581557400557,38382.430809345358,2551449.630631004,0.1298]
[null,null,null,null,null,null,null,null,null,null,63,63,"2027-05-18",10784.250638019996,27598.180171325363,38382.430809345358,2540665.3799929838,0.1298]
[null,null,null,null,null,null,null,null,null,null,64,64,"2027-06-18",10900.900282421251,27481.530526924107,38382.430809345358,2529764.4797105626,0.1298]
[null,null,null,null,null,null,null,null,null,null,65,{"$f":"IF(K71>$C$14,\"\",K71)","v":65},{"$f":"IF(L71<=$C$14,EDATE($M$6,L71),\"\")","v":"2027-07-18"},11018.811687142774,{"$f":"IF(L71<=$C$14,Q70*R71/12,\"\")","v":27363.619122202585},38382.430809345358,{"$f":"IF(M71=\"\",\"\",Q70-N71)","v":2518745.66802342},{"$f":"IF(L71>$C$14,\"\",\nIF(L71>$C$34,$C$18,$C$16))","v":0.1298}]
[null,null,null,null,null,null,null,null,null,null,66,66,"2027-08-18",{"$f":"IF(M72=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P72-IF(MOD(L72,12)=1,$G$8+$G$10,0)-O72))","v":11137.998500225367},27244.432309119991,{"$f":"IF(M72=\"\",\"\",\nIF($C$26=\"Стандарт\",N72+O72+IF(MOD(L72,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L72,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},2507607.6695231944,0.1298]
[null,null,null,null,null,null,null,null,null,null,67,67,"2027-09-18",11258.474517336141,27123.956292009218,38382.430809345358,2496349.1950058583,0.1298]
[null,null,null,null,null,null,null,null,null,null,68,68,"2027-10-18",11380.253683365325,27002.177125980033,38382.430809345358,2484968.9413224929,0.1298]
[null,null,null,null,null,null,null,null,null,null,69,69,"2027-11-18",11503.350094040394,26879.080715304965,38382.430809345358,2473465.5912284525,0.1298]
[null,null,null,null,null,null,null,null,null,null,70,70,"2027-12-18",11627.777997557598,26754.652811787761,38382.430809345358,2461837.813230895,0.1298]
[null,null,null,null,null,null,null,null,null,null,71,71,"2028-01-18",11753.551796231175,26628.879013114183,38382.430809345358,2450084.261434664,0.1298]
[null,null,null,null,null,null,null,null,null,null,72,72,"2028-02-18",11880.686048160409,26501.744761184949,38382.430809345358,2438203.5753865037,0.1298]
[null,null,null,null,null,null,null,null,null,null,73,73,"2028-03-18",12009.195468914677,26373.235340430681,51239.573679345354,2426194.379917589,0.1298]
[null,null,null,null,null,null,null,null,null,null,74,74,"2028-04-18",12139.094933236771,26243.335876108587,38382.430809345358,2414055.2849843521,0.1298]
[null,null,null,null,null,null,null,null,null,null,75,75,"2028-05-18",12270.399476764618,26112.03133258074,38382.430809345358,2401784.8855075873,0.1298]
[null,null,null,null,null,null,null,null,null,null,76,76,"2028-06-18",12403.124297771621,25979.306511573737,38382.430809345358,2389381.7612098157,0.1298]
[null,null,null,null,null,null,null,null,null,null,77,77,"2028-07-18",12537.284758925849,25845.146050419509,38382.430809345358,2376844.4764508898,0.1298]
[null,null,null,null,null,null,null,null,null,null,78,78,"2028-08-18",12672.896389068235,25709.534420277123,38382.430809345358,2364171.5800618217,0.1298]
[null,null,null,null,null,null,null,null,null,null,79,79,"2028-09-18",12809.974885009986,25572.455924335372,38382.430809345358,2351361.6051768116,0.1298]
[null,null,null,null,null,null,null,null,null,null,80,80,"2028-10-18",12948.536113349513,25433.894695995845,38382.430809345358,2338413.0690634619,0.1298]
[null,null,null,null,null,null,null,null,null,null,81,81,"2028-11-18",13088.596112308911,25293.834697036447,38382.430809345358,2325324.4729511528,0.1298]
[null,null,null,null,null,null,null,null,null,null,82,82,"2028-12-18",13230.171093590387,25152.259715754972,38382.430809345358,2312094.3018575623,0.1298]
[null,null,null,null,null,null,null,null,null,null,83,83,"2029-01-18",13373.277444252726,25009.153365092632,38382.430809345358,2298721.0244133095,0.1298]
[null,null,null,null,null,null,null,null,null,null,84,84,"2029-02-18",13517.931728608062,24864.499080737296,38382.430809345358,2285203.0926847016,0.1298]
[null,null,null,null,null,null,null,null,null,null,85,85,"2029-03-18",13664.150690139169,24718.280119206189,51239.573679345354,2271538.9419945623,0.1298]
[null,null,null,null,null,null,null,null,null,null,86,86,"2029-04-18",13811.95125343751,24570.479555907848,38382.430809345358,2257726.9907411248,0.1298]
[null,null,null,null,null,null,null,null,null,null,87,87,"2029-05-18",13961.35052616219,24421.080283183168,38382.430809345358,2243765.6402149629,0.1298]
[null,null,null,null,null,null,null,null,null,null,88,88,"2029-06-18",14112.365801020176,24270.065008325182,38382.430809345358,2229653.2744139428,0.1298]
[null,null,null,null,null,null,null,null,null,null,89,89,"2029-07-18",14265.014557767878,24117.416251577481,38382.430809345358,2215388.2598561752,0.1298]
[null,null,null,null,null,null,null,null,null,null,90,90,"2029-08-18",14419.314465234394,23963.116344110964,38382.430809345358,2200968.9453909406,0.1298]
[null,null,null,null,null,null,null,null,null,null,91,91,"2029-09-18",14575.283383366685,23807.147425978674,38382.430809345358,2186393.662007574,0.1298]
[null,null,null,null,null,null,null,null,null,null,92,92,"2029-10-18",14732.939365296766,23649.491444048592,38382.430809345358,2171660.7226422774,0.1298]
[null,null,null,null,null,null,null,null,null,null,93,93,"2029-11-18",14892.300659431392,23490.130149913966,38382.430809345358,2156768.4219828458,0.1298]
[null,null,null,null,null,null,null,null,null,null,94,94,"2029-12-18",15053.385711564246,23329.045097781112,38382.430809345358,2141715.0362712815,0.1298]
[null,null,null,null,null,null,null,null,null,null,95,95,"2030-01-18",15216.213167010996,23166.217642334363,38382.430809345358,2126498.8231042707,0.1298]
[null,null,null,null,null,null,null,null,null,null,96,96,"2030-02-18",15380.801872767497,23001.628936577861,38382.430809345358,2111118.0212315032,0.1298]
[null,null,null,null,null,null,null,null,null,null,97,{"$f":"IF(K103>$C$14,\"\",K103)","v":97},{"$f":"IF(L103<=$C$14,EDATE($M$6,L103),\"\")","v":"2030-03-18"},15547.170879691268,{"$f":"IF(L103<=$C$14,Q102*R103/12,\"\")","v":22835.25992965409},51239.573679345354,{"$f":"IF(M103=\"\",\"\",Q102-N103)","v":2095570.8503518119},{"$f":"IF(L103>$C$14,\"\",\nIF(L103>$C$34,$C$18,$C$16))","v":0.1298}]
[null,null,null,null,null,null,null,null,null,null,98,98,"2030-04-18",{"$f":"IF(M104=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P104-IF(MOD(L104,12)=1,$G$8+$G$10,0)-O104))","v":15715.339444706595},22667.091364638763,{"$f":"IF(M104=\"\",\"\",\nIF($C$26=\"Стандарт\",N104+O104+IF(MOD(L104,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L104,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},2079855.5109071052,0.1298]
[null,null,null,null,null,null,null,null,null,null,99,99,"2030-05-18",15885.327033033504,22497.103776311855,38382.430809345358,2063970.1838740716,0.1298]
[null,null,null,null,null,null,null,null,null,null,100,100,"2030-06-18",16057.153320440819,22325.277488904539,38382.430809345358,2047913.0305536308,0.1298]
[null,null,null,null,null,null,null,null,null,null,101,101,"2030-07-18",16230.838195523585,22151.592613821773,38382.430809345358,2031682.1923581073,0.1298]
[null,null,null,null,null,null,null,null,null,null,102,102,"2030-08-18",16406.401762005164,21976.029047340195,38382.430809345358,2015275.7905961021,0.1298]
[null,null,null,null,null,null,null,null,null,null,103,103,"2030-09-18",16583.864341064185,21798.566468281173,38382.430809345358,1998691.926255038,0.1298]
[null,null,null,null,null,null,null,null,null,null,104,104,"2030-10-18",16763.246473686697,21619.184335658661,38382.430809345358,1981928.6797813512,0.1298]
[null,null,null,null,null,null,null,null,null,null,105,105,"2030-11-18",16944.568923043742,21437.861886301616,38382.430809345358,1964984.1108583075,0.1298]
[null,null,null,null,null,null,null,null,null,null,106,106,"2030-12-18",17127.852676894665,21254.578132450693,38382.430809345358,1947856.2581814127,0.1298]
[null,null,null,null,null,null,null,null,null,null,107,107,"2031-01-18",17313.118950016411,21069.311859328947,38382.430809345358,1930543.1392313964,0.1298]
[null,null,null,null,null,null,null,null,null,null,108,108,"2031-02-18",17500.389186659089,20882.041622686269,38382.430809345358,1913042.7500447372,0.1298]
[null,null,null,null,null,null,null,null,null,null,109,109,"2031-03-18",17689.685063028115,20692.745746317243,51239.573679345354,1895353.0649817092,0.1298]
[null,null,null,null,null,null,null,null,null,null,110,110,"2031-04-18",17881.028489793203,20501.402319552155,38382.430809345358,1877472.036491916,0.1298]
[null,null,null,null,null,null,null,null,null,null,111,111,"2031-05-18",18074.441614624466,20307.989194720893,38382.430809345358,1859397.5948772915,0.1298]
[null,null,null,null,null,null,null,null,null,null,112,112,"2031-06-18",18269.946824755989,20112.483984589369,38382.430809345358,1841127.6480525355,0.1298]
[null,null,null,null,null,null,null,null,null,null,113,113,"2031-07-18",18467.566749577101,19914.864059768257,38382.430809345358,1822660.0813029583,0.1298]
[null,null,null,null,null,null,null,null,null,null,114,114,"2031-08-18",18667.324263251692,19715.106546093666,38382.430809345358,1803992.7570397067,0.1298]
[null,null,null,null,null,null,null,null,null,null,115,115,"2031-09-18",18869.242487365864,19513.188321979495,38382.430809345358,1785123.5145523408,0.1298]
[null,null,null,null,null,null,null,null,null,null,116,116,"2031-10-18",19073.344793604203,19309.086015741155,38382.430809345358,1766050.1697587366,0.1298]
[null,null,null,null,null,null,null,null,null,null,117,117,"2031-11-18",19279.654806455026,19102.776002890332,38382.430809345358,1746770.5149522815,0.1298]
[null,null,null,null,null,null,null,null,null,null,118,118,"2031-12-18",19488.196405944847,18894.234403400511,38382.430809345358,1727282.3185463366,0.1298]
[null,null,null,null,null,null,null,null,null,null,119,119,"2032-01-18",19698.993730402482,18683.437078942876,38382.430809345358,1707583.3248159341,0.1298]
[null,null,null,null,null,null,null,null,null,null,120,120,"2032-02-18",19912.071179253006,18470.359630092353,38382.430809345358,1687671.253636681,0.1298]
[null,null,null,null,null,null,null,null,null,null,121,121,"2032-03-18",20127.453415841926,18254.977393503432,51239.573679345354,1667543.800220839,0.1298]
[null,null,null,null,null,null,null,null,null,null,122,122,"2032-04-18",20345.165370289949,18037.265439055409,38382.430809345358,1647198.634850549,0.1298]
[null,null,null,null,null,null,null,null,null,null,123,123,"2032-05-18",20565.232242378584,17817.198566966774,38382.430809345358,1626633.4026081704,0.1298]
[null,null,null,null,null,null,null,null,null,null,124,124,"2032-06-18",20787.679504466982,17594.751304878377,38382.430809345358,1605845.7231037035,0.1298]
[null,null,null,null,null,null,null,null,null,null,125,125,"2032-07-18",21012.532904440301,17369.897904905058,38382.430809345358,1584833.1901992632,0.1298]
[null,null,null,null,null,null,null,null,null,null,126,126,"2032-08-18",21239.818468689995,17142.612340655363,38382.430809345358,1563593.3717305732,0.1298]
[null,null,null,null,null,null,null,null,null,null,127,127,"2032-09-18",21469.562505126323,16912.868304219035,38382.430809345358,1542123.809225447,0.1298]
[null,null,null,null,null,null,null,null,null,null,128,128,"2032-10-18",21701.79160622344,16680.639203121918,38382.430809345358,1520422.0176192236,0.1298]
[null,null,null,null,null,null,null,null,null,null,129,{"$f":"IF(K135>$C$14,\"\",K135)","v":129},{"$f":"IF(L135<=$C$14,EDATE($M$6,L135),\"\")","v":"2032-11-18"},21936.532652097423,{"$f":"IF(L135<=$C$14,Q134*R135/12,\"\")","v":16445.898157247935},38382.430809345358,{"$f":"IF(M135=\"\",\"\",Q134-N135)","v":1498485.484967126},{"$f":"IF(L135>$C$14,\"\",\nIF(L135>$C$34,$C$18,$C$16))","v":0.1298}]
[null,null,null,null,null,null,null,null,null,null,130,130,"2032-12-18",{"$f":"IF(M136=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P136-IF(MOD(L136,12)=1,$G$8+$G$10,0)-O136))","v":22173.812813617609},16208.617995727747,{"$f":"IF(M136=\"\",\"\",\nIF($C$26=\"Стандарт\",N136+O136+IF(MOD(L136,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L136,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},1476311.6721535085,0.1298]
[null,null,null,null,null,null,null,null,null,null,131,131,"2033-01-18",22413.659555551574,15968.771253793784,38382.430809345358,1453898.0125979569,0.1298]
[null,null,null,null,null,null,null,null,null,null,132,132,"2033-02-18",22656.100639744123,15726.330169601235,38382.430809345358,1431241.9119582127,0.1298]
[null,null,null,null,null,null,null,null,null,null,133,133,"2033-03-18",22901.164128330689,15481.266681014667,51239.573679345354,1408340.747829882,0.1298]
[null,null,null,null,null,null,null,null,null,null,134,134,"2033-04-18",23148.878386985467,15233.55242235989,38382.430809345358,1385191.8694428965,0.1298]
[null,null,null,null,null,null,null,null,null,null,135,135,"2033-05-18",23399.272088204692,14983.158721140664,38382.430809345358,1361792.5973546917,0.1298]
[null,null,null,null,null,null,null,null,null,null,136,136,"2033-06-18",23652.374214625444,14730.056594719916,38382.430809345358,1338140.2231400663,0.1298]
[null,null,null,null,null,null,null,null,null,null,137,137,"2033-07-18",23908.214062380306,14474.21674696505,38382.430809345358,1314232.0090776859,0.1298]
[null,null,null,null,null,null,null,null,null,null,138,138,"2033-08-18",24166.82124448839,14215.609564856968,38382.430809345358,1290065.1878331974,0.1298]
[null,null,null,null,null,null,null,null,null,null,139,139,"2033-09-18",24428.225694282941,13954.205115062417,38382.430809345358,1265636.9621389145,0.1298]
[null,null,null,null,null,null,null,null,null,null,140,140,"2033-10-18",24692.457668876101,13689.973140469257,38382.430809345358,1240944.5044700385,0.1298]
[null,null,null,null,null,null,null,null,null,null,141,141,"2033-11-18",24959.547752661107,13422.88305668425,38382.430809345358,1215984.9567173773,0.1298]
[null,null,null,null,null,null,null,null,null,null,142,142,"2033-12-18",25229.526860852391,13152.903948492965,38382.430809345358,1190755.4298565248,0.1298]
[null,null,null,null,null,null,null,null,null,null,143,143,"2034-01-18",25502.42624306395,12880.00456628141,38382.430809345358,1165253.0036134608,0.1298]
[null,null,null,null,null,null,null,null,null,null,144,144,"2034-02-18",25778.277486926425,12604.153322418933,38382.430809345358,1139474.7261265344,0.1298]
[null,null,null,null,null,null,null,null,null,null,145,145,"2034-03-18",26057.112521743344,12325.318287602015,51239.573679345354,1113417.613604791,0.1298]
[null,null,null,null,null,null,null,null,null,null,146,146,"2034-04-18",26338.963622186871,12043.467187158489,38382.430809345358,1087078.6499826042,0.1298]
[null,null,null,null,null,null,null,null,null,null,147,147,"2034-05-18",26623.863412033526,11758.567397311834,38382.430809345358,1060454.7865705707,0.1298]
[null,null,null,null,null,null,null,null,null,null,148,148,"2034-06-18",26911.844867940352,11470.585941405006,38382.430809345358,1033542.9417026304,0.1298]
[null,null,null,null,null,null,null,null,null,null,149,149,"2034-07-18",27202.941323261904,11179.489486083452,38382.430809345358,1006340.0003793684,0.1298]
[null,null,null,null,null,null,null,null,null,null,150,150,"2034-08-18",27497.186471908521,10885.244337436836,38382.430809345358,978842.81390745996,0.1298]
[null,null,null,null,null,null,null,null,null,null,151,151,"2034-09-18",27794.614372246331,10587.816437099025,38382.430809345358,951048.19953521364,0.1298]
[null,null,null,null,null,null,null,null,null,null,152,152,"2034-10-18",28095.259451039463,10287.171358305894,38382.430809345358,922952.94008417416,0.1298]
[null,null,null,null,null,null,null,null,null,null,153,153,"2034-11-18",28399.156507434876,9983.2743019104837,38382.430809345358,894553.78357673925,0.1298]
[null,null,null,null,null,null,null,null,null,null,154,154,"2034-12-18",28706.340716990293,9676.0900923550635,38382.430809345358,865847.44285974896,0.1298]
[null,null,null,null,null,null,null,null,null,null,155,155,"2035-01-18",29016.84763574574,9365.583173599618,38382.430809345358,836830.59522400319,0.1298]
[null,null,null,null,null,null,null,null,null,null,156,156,"2035-02-18",29330.713204339059,9051.7176050063008,38382.430809345358,807499.88201966416,0.1298]
[null,null,null,null,null,null,null,null,null,null,157,157,"2035-03-18",29647.973752165992,8734.4570571793683,51239.573679345354,777851.90826749813,0.1298]
[null,null,null,null,null,null,null,null,null,null,158,158,"2035-04-18",29968.666001585254,8413.7648077601043,38382.430809345358,747883.24226591294,0.1298]
[null,null,null,null,null,null,null,null,null,null,159,159,"2035-05-18",30292.827072169068,8089.6037371762914,38382.430809345358,717590.41519374389,0.1298]
[null,null,null,null,null,null,null,null,null,null,160,160,"2035-06-18",30620.494484999694,7761.9363243456637,38382.430809345358,686969.9207087442,0.1298]
[null,null,null,null,null,null,null,null,null,null,161,{"$f":"IF(K167>$C$14,\"\",K167)","v":161},{"$f":"IF(L167<=$C$14,EDATE($M$6,L167),\"\")","v":"2035-07-18"},30951.706167012442,{"$f":"IF(L167<=$C$14,Q166*R167/12,\"\")","v":7430.7246423329161},38382.430809345358,{"$f":"IF(M167=\"\",\"\",Q166-N167)","v":656018.21454173175},{"$f":"IF(L167>$C$14,\"\",\nIF(L167>$C$34,$C$18,$C$16))","v":0.1298}]
[null,null,null,null,null,null,null,null,null,null,162,162,"2035-08-18",{"$f":"IF(M168=\"\",\"\",\nIF($C$26=\"Стандарт\",$C$12/$C$14,P168-IF(MOD(L168,12)=1,$G$8+$G$10,0)-O168))","v":31286.500455385627},7095.9303539597313,{"$f":"IF(M168=\"\",\"\",\nIF($C$26=\"Стандарт\",N168+O168+IF(MOD(L168,12)=1,$G$8+$G$10,0),$L$4+IF(MOD(L168,12)=1,$G$8+$G$10,0)\n))","v":38382.430809345358},624731.7140863461,0.1298]
[null,null,null,null,null,null,null,null,null,null,163,163,"2035-09-18",31624.916101978048,6757.5147073673106,38382.430809345358,593106.79798436805,0.1298]
[null,null,null,null,null,null,null,null,null,null,164,164,"2035-10-18",31966.992277814443,6415.4385315309146,38382.430809345358,561139.80570655363,0.1298]
[null,null,null,null,null,null,null,null,null,null,165,165,"2035-11-18",32312.76857761947,6069.662231725888,38382.430809345358,528827.03712893417,0.1298]
[null,null,null,null,null,null,null,null,null,null,166,166,"2035-12-18",32662.28502440072,5720.1457849446379,38382.430809345358,496164.75210453343,0.1298]
[null,null,null,null,null,null,null,null,null,null,167,167,"2036-01-18",33015.582074081321,5366.8487352640368,38382.430809345358,463149.17003045208,0.1298]
[null,null,null,null,null,null,null,null,null,null,168,168,"2036-02-18",33372.700620182637,5009.730189162723,38382.430809345358,429776.46941026946,0.1298]
[null,null,null,null,null,null,null,null,null,null,169,169,"2036-03-18",33733.681998557608,4648.748810787748,51239.573679345354,396042.78741171188,0.1298]
[null,null,null,null,null,null,null,null,null,null,170,170,"2036-04-18",34098.56799217534,4283.8628171700166,38382.430809345358,361944.21941953653,0.1298]
[null,null,null,null,null,null,null,null,null,null,171,171,"2036-05-18",34467.400835957371,3915.029973387987,38382.430809345358,327476.81858357915,0.1298]
[null,null,null,null,null,null,null,null,null,null,172,172,"2036-06-18",34840.223221666311,3542.2075876790477,38382.430809345358,292636.59536191286,0.1298]
[null,null,null,null,null,null,null,null,null,null,173,173,"2036-07-18",35217.078302847338,3165.352506498024,38382.430809345358,257419.51705906552,0.1298]
[null,null,null,null,null,null,null,null,null,null,174,174,"2036-08-18",35598.009699823131,2784.4211095222254,38382.430809345358,221821.50735924239,0.1298]
[null,null,null,null,null,null,null,null,null,null,175,175,"2036-09-18",35983.061504742887,2399.3693046024719,38382.430809345358,185838.4458544995,0.1298]
[null,null,null,null,null,null,null,null,null,null,176,176,"2036-10-18",36372.278286685854,2010.1525226595029,38382.430809345358,149466.16756781365,0.1298]
[null,null,null,null,null,null,null,null,null,null,177,177,"2036-11-18",36765.705096820173,1616.7257125251845,38382.430809345358,112700.46247099349,0.1298]
[null,null,null,null,null,null,null,null,null,null,178,178,"2036-12-18",37163.387473617448,1219.0433357279128,38382.430809345358,75537.074997376039,0.1298]
[null,null,null,null,null,null,null,null,null,null,179,179,"2037-01-18",37565.37144812374,817.05936122161745,38382.430809345358,37971.703549252299,0.1298]
[null,null,null,null,null,null,null,null,null,null,180,180,"2037-02-18",37971.703549287609,410.7272600577457,38382.430809345358,-3.5310222301632166E-8,0.1298]