{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Розрахунок Мій гаманець"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Розрахунок Мій гаманець","index":0,"n_rows":117,"n_cols":32,"rows_kept":117,"cut":false,"hidden":false,"merged":[[115,3,115,22],[6,3,6,5],[10,3,10,9],[11,3,11,9],[11,12,11,13],[114,3,114,22],[111,3,111,15],[28,10,30,10],[28,11,28,20],[29,11,29,14],[29,15,29,16],[29,17,29,20],[108,3,108,4],[116,3,116,22],[27,22,30,22],[28,9,30,9],[12,3,12,9],[13,3,13,9],[110,3,110,15],[112,3,112,15],[108,14,108,21],[27,3,30,3],[27,4,30,4],[27,5,30,5],[27,8,30,8],[27,9,27,20],[27,21,30,21],[25,3,25,22],[109,3,109,15]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Калькулятор"]
[null,null,null,null,null,null,null,null,null,null,null,"«МІЙ ГАМАНЕЦЬ» – на поточні потреби"]
[]
[null,null,null,null,"ячейки блакитногого кольору заповнюються Клієнтом виходячи з обраних умов кредитування"]
[null,null,null,"Умови кредитування, обрані споживачем:"]
[null,null,null,"Дата видачі кредиту: ",null,null,null,null,null,null,{"$f":"TODAY()","v":"2022-12-23"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(K11)","v":2025},{"$f":"YEAR(K7)","v":2022},{"$f":"MONTH(K11)","v":12},{"$f":"MONTH(K7)","v":12}]
[null,null,null,"Вартість предмету іпотеки, грн.:",null,null,null,null,null,null,0]
[null,null,null,"Сума кредиту*, грн.: ",null,null,null,null,null,null,100000," *від 10 000 до 100 000 грн."]
[null,null,null,"Срок кредитування, місяців",null,null,null,null,null,null,36]
[null,null,null,"Кінцева дата повернення кредиту:",null,null,null,null,null,null,{"$f":"K7+((K10/12)*365)","v":"2025-12-22"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AC7-AD7","v":3},null,{"$f":"AE7-AF7","v":0}]
[null,null,null,"Порядок погашення кредиту, грн.: ",null,null,null,null,null,null,"щомісяця по",{"$f":"CEILING(K9/K10,1)","v":2778},"останній платіж",null,{"$f":"K9-(L12*(K10-1))","v":2770}]
[null,null,null,"Дата погашення кредиту та процентів: ",null,null,null,null,null,null,"щомісяця",{"$f":"DAY(K7)","v":23},"числа",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"12+AE11","v":12}]
[null,null,null,"Процентна ставка (фіксована): ",null,null,null,null,null,null,0.35,"річних",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"24+AE11","v":24}]
[null,null,null,"разова комісія за видачу готівкових коштів:",null,null,null,null,null,null,0,"від суми наданого кредиту",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC11=0,AE11,IF(AC11=1,AE13,IF(AC11=2,AE14,#REF!)))","v":{"$error":"#REF!"}}]
[null,null,null,"Щомісячна комісія за проведення розрахунків:",null,null,null,null,null,null,0.01,"від суми наданого кредиту",null,null,{"$f":"K9*K16","v":1000}]
[null,null,null,"щорічна комісія за проведення розрахунків:",null,null,null,null,null,null,0,"від суми наданого кредиту"]
[null,null,null,"послуги нотаріуса",null,null,null,null,null,null,0,"грн."]
[null,null,null,"послуги оцінювача",null,null,null,null,null,null,0,"грн."]
[null,null,null,"Послуги страховика  (один раз на рік)**",null,null,null,null,null,null,0,"**для позичальників віком від 50 до 60 років – порука іншої фізичної особи або страхування від нещасних випадків"]
[null,null,null,"державне мито",null,null,null,null,null,null,0,"від вартості предмету іпотеки"]
[null,null,null,"пенсійний збір",null,null,null,null,null,null,0,"від вартості предмету іпотеки"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Дата розрахунку:",{"$f":"TEXT(K7,\"DD.MM.YYYY\")&\" р.\"","v":"DD.MM.YYYY р."}]
[null,null,null,"ТАБЛИЦЯ\nобчислення загальної вартості кредиту для споживача та реальної річної процентної ставки за договором про споживчий кредит"]
[]
[null,null,null," № з/п","Дата видачі кредиту/ дата платежу","Кількість днів у розрахун- ковому періоді",null,null,"Чиста сума кредиту/ сума платежу за розрахунковий період, грн.","Види платежів за кредитом",null,null,null,null,null,null,null,null,null,null,null,"Реальна річна процентна ставка, %","Загальна вартість кредиту, грн"]
[null,null,null,null,null,null,null,null,null,"сума кредиту за договором","проценти за користування кредитом","платежі за додаткові та супутні послуги"]
[null,null,null,null,null,null,null,null,null,null,null,"банку",null,null,null,"кредитного посередника (за наявності)",null,"третіх осіб"]
["фільтр",null,null,null,null,null,null,null,null,null,null,"щомісячна комісія за проведення розрахунків","розрахунково-касове обслуговування","комісія за видачу готівкових коштів","інші послуги банку","комісійний збір","інша плата за послуги кредитного посередника","послуги нотаріуса","послуги оцінювача","послуги страховика","інші послуги \nтретіх осіб"]
[null,null,null,1,2,3,4,5,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
[{"$f":"IF(B33<=$K$11,1,0)","v":1},null,null,1,{"$f":"K7","v":"2022-12-23"},"х",null,null,{"$f":"SUM(J33:U33)","v":-100000},{"$f":"-K9","v":-100000},"х",null,null,{"$f":"K9*K15","v":0},{"$f":"K9*K17","v":0},null,null,{"$f":"K18+(K21*K8)+(K22*K8)","v":0},{"$f":"K19","v":0},{"$f":"K9*K20","v":0},null,"х","х"]
[0,null,null,null,{"$f":"EOMONTH(K7,0)","v":"2022-12-31"},{"$f":"IF(A34=1,E34-E33,0)","v":0},null,null,{"$f":"SUM(J34:O34)","v":0}]
[{"$f":"IF(B35<=$K$10,1,0)","v":1},1,null,{"$f":"D33+1","v":2},{"$f":"MIN(DATE(YEAR(E33),MONTH(E33)+1,DAY($L$13)),$K$11)","v":"2023-01-23"},{"$f":"E35-E33","v":31},{"$f":"EOMONTH(E33,0)-E33","v":8},{"$f":"E35-EOMONTH(E33,0)","v":23},{"$f":"SUM(J35:U35)","v":6750.6},{"$f":"L12","v":2778},{"$f":"ROUND($K$9*(($K$14/(IF(ROUND(YEAR(E33)/4,0)-YEAR(E33)/4=0,366,365)))*G35)+$K$9*(($K$14/(IF(ROUND(YEAR(E35)/4,0)-YEAR(E35)/4=0,366,365)))*H35),2)","v":2972.6},{"$f":"IF(A35=1,IF(AND(YEAR($K$11)=YEAR(EDATE(E34,1)),MONTH($K$11)=MONTH(EDATE(E34,1))),$O$16-$O$38,$O$16),0)","v":1000},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B35+1","v":2},null,3,{"$f":"IF(AND(YEAR($K$11)=YEAR(EDATE(E35,1)),MONTH($K$11)=MONTH(EDATE(E35,1))),$K$11,EDATE(E35,1))","v":"2023-02-23"},{"$f":"IF(A36=1,E36-E35,0)","v":31},{"$f":"EOMONTH(E35,0)-E35","v":8},{"$f":"E36-EOMONTH(E35,0)","v":23},{"$f":"SUM(J36:U36)","v":6668.02},{"$f":"IF(B36<$K$10,$L$12,-$J$33-SUM($J$35:J35))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J35))*(($K$14/(IF(ROUND(YEAR(E35)/4,0)-YEAR(E35)/4=0,366,365)))*G36)+($K$9-SUM($J$35:J35))*(($K$14/(IF(ROUND(YEAR(E36)/4,0)-YEAR(E36)/4=0,366,365)))*H36),2)","v":2890.02},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,3,null,4,{"$f":"IF(AND(YEAR($K$11)=YEAR(EDATE(E36,1)),MONTH($K$11)=MONTH(EDATE(E36,1))),$K$11,EDATE(E36,1))","v":"2023-03-23"},28,{"$f":"EOMONTH(E36,0)-E36","v":5},{"$f":"E37-EOMONTH(E36,0)","v":23},6313.76,{"$f":"IF(B37<$K$10,$L$12,-$J$33-SUM($J$35:J36))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J36))*(($K$14/(IF(ROUND(YEAR(E36)/4,0)-YEAR(E36)/4=0,366,365)))*G37)+($K$9-SUM($J$35:J36))*(($K$14/(IF(ROUND(YEAR(E37)/4,0)-YEAR(E37)/4=0,366,365)))*H37),2)","v":2535.7600000000002},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,4,null,5,"2023-04-23",31,8,23,6502.87,{"$f":"IF(B38<$K$10,$L$12,-$J$33-SUM($J$35:J37))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J37))*(($K$14/(IF(ROUND(YEAR(E37)/4,0)-YEAR(E37)/4=0,366,365)))*G38)+($K$9-SUM($J$35:J37))*(($K$14/(IF(ROUND(YEAR(E38)/4,0)-YEAR(E38)/4=0,366,365)))*H38),2)","v":2724.87},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,5,null,6,"2023-05-23",30,7,23,6335.05,{"$f":"IF(B39<$K$10,$L$12,-$J$33-SUM($J$35:J38))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J38))*(($K$14/(IF(ROUND(YEAR(E38)/4,0)-YEAR(E38)/4=0,366,365)))*G39)+($K$9-SUM($J$35:J38))*(($K$14/(IF(ROUND(YEAR(E39)/4,0)-YEAR(E39)/4=0,366,365)))*H39),2)","v":2557.0500000000002},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,6,null,7,"2023-06-23",31,8,23,6337.71,{"$f":"IF(B40<$K$10,$L$12,-$J$33-SUM($J$35:J39))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J39))*(($K$14/(IF(ROUND(YEAR(E39)/4,0)-YEAR(E39)/4=0,366,365)))*G40)+($K$9-SUM($J$35:J39))*(($K$14/(IF(ROUND(YEAR(E40)/4,0)-YEAR(E40)/4=0,366,365)))*H40),2)","v":2559.71},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,7,null,8,"2023-07-23",30,7,23,6175.2199999999993,{"$f":"IF(B41<$K$10,$L$12,-$J$33-SUM($J$35:J40))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J40))*(($K$14/(IF(ROUND(YEAR(E40)/4,0)-YEAR(E40)/4=0,366,365)))*G41)+($K$9-SUM($J$35:J40))*(($K$14/(IF(ROUND(YEAR(E41)/4,0)-YEAR(E41)/4=0,366,365)))*H41),2)","v":2397.2199999999998},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,8,null,9,"2023-08-23",31,8,23,6172.55,{"$f":"IF(B42<$K$10,$L$12,-$J$33-SUM($J$35:J41))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J41))*(($K$14/(IF(ROUND(YEAR(E41)/4,0)-YEAR(E41)/4=0,366,365)))*G42)+($K$9-SUM($J$35:J41))*(($K$14/(IF(ROUND(YEAR(E42)/4,0)-YEAR(E42)/4=0,366,365)))*H42),2)","v":2394.5500000000002},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,9,null,10,"2023-09-23",31,8,23,6089.9699999999993,{"$f":"IF(B43<$K$10,$L$12,-$J$33-SUM($J$35:J42))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J42))*(($K$14/(IF(ROUND(YEAR(E42)/4,0)-YEAR(E42)/4=0,366,365)))*G43)+($K$9-SUM($J$35:J42))*(($K$14/(IF(ROUND(YEAR(E43)/4,0)-YEAR(E43)/4=0,366,365)))*H43),2)","v":2311.9699999999998},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,10,null,11,"2023-10-23",30,7,23,5935.48,{"$f":"IF(B44<$K$10,$L$12,-$J$33-SUM($J$35:J43))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J43))*(($K$14/(IF(ROUND(YEAR(E43)/4,0)-YEAR(E43)/4=0,366,365)))*G44)+($K$9-SUM($J$35:J43))*(($K$14/(IF(ROUND(YEAR(E44)/4,0)-YEAR(E44)/4=0,366,365)))*H44),2)","v":2157.48},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,11,null,12,"2023-11-23",31,8,23,5924.8099999999995,{"$f":"IF(B45<$K$10,$L$12,-$J$33-SUM($J$35:J44))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J44))*(($K$14/(IF(ROUND(YEAR(E44)/4,0)-YEAR(E44)/4=0,366,365)))*G45)+($K$9-SUM($J$35:J44))*(($K$14/(IF(ROUND(YEAR(E45)/4,0)-YEAR(E45)/4=0,366,365)))*H45),2)","v":2146.81},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,12,null,13,"2023-12-23",30,7,23,{"$f":"SUM(J46:U46)","v":5775.65},{"$f":"IF(B46<$K$10,$L$12,-$J$33-SUM($J$35:J45))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J45))*(($K$14/(IF(ROUND(YEAR(E45)/4,0)-YEAR(E45)/4=0,366,365)))*G46)+($K$9-SUM($J$35:J45))*(($K$14/(IF(ROUND(YEAR(E46)/4,0)-YEAR(E46)/4=0,366,365)))*H46),2)","v":1997.65},1000,null,0,{"$f":"IF(B46<$K$10,$K$9*$K$17,0)","v":0},null,null,null,null,{"$f":"IF(B46<$K$10,$K$9*$K$20,0)","v":0},null,"х","х"]
[1,13,null,14,"2024-01-23",31,8,23,{"$f":"SUM(J47:U47)","v":5755.64},{"$f":"IF(B47<$K$10,$L$12,-$J$33-SUM($J$35:J46))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J46))*(($K$14/(IF(ROUND(YEAR(E46)/4,0)-YEAR(E46)/4=0,366,365)))*G47)+($K$9-SUM($J$35:J46))*(($K$14/(IF(ROUND(YEAR(E47)/4,0)-YEAR(E47)/4=0,366,365)))*H47),2)","v":1977.64},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,14,null,15,"2024-02-23",31,8,23,5671.89,{"$f":"IF(B48<$K$10,$L$12,-$J$33-SUM($J$35:J47))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J47))*(($K$14/(IF(ROUND(YEAR(E47)/4,0)-YEAR(E47)/4=0,366,365)))*G48)+($K$9-SUM($J$35:J47))*(($K$14/(IF(ROUND(YEAR(E48)/4,0)-YEAR(E48)/4=0,366,365)))*H48),2)","v":1893.89},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,15,null,16,"2024-03-23",29,6,23,5472.66,{"$f":"IF(B49<$K$10,$L$12,-$J$33-SUM($J$35:J48))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J48))*(($K$14/(IF(ROUND(YEAR(E48)/4,0)-YEAR(E48)/4=0,366,365)))*G49)+($K$9-SUM($J$35:J48))*(($K$14/(IF(ROUND(YEAR(E49)/4,0)-YEAR(E49)/4=0,366,365)))*H49),2)","v":1694.66},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,16,null,17,"2024-04-23",31,8,23,5507.18,{"$f":"IF(B50<$K$10,$L$12,-$J$33-SUM($J$35:J49))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J49))*(($K$14/(IF(ROUND(YEAR(E49)/4,0)-YEAR(E49)/4=0,366,365)))*G50)+($K$9-SUM($J$35:J49))*(($K$14/(IF(ROUND(YEAR(E50)/4,0)-YEAR(E50)/4=0,366,365)))*H50),2)","v":1729.18},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,17,null,18,"2024-05-23",30,7,23,5371.7,{"$f":"IF(B51<$K$10,$L$12,-$J$33-SUM($J$35:J50))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J50))*(($K$14/(IF(ROUND(YEAR(E50)/4,0)-YEAR(E50)/4=0,366,365)))*G51)+($K$9-SUM($J$35:J50))*(($K$14/(IF(ROUND(YEAR(E51)/4,0)-YEAR(E51)/4=0,366,365)))*H51),2)","v":1593.7},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B51+1","v":18},null,19,"2024-06-23",31,8,23,5342.48,{"$f":"IF(B52<$K$10,$L$12,-$J$33-SUM($J$35:J51))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J51))*(($K$14/(IF(ROUND(YEAR(E51)/4,0)-YEAR(E51)/4=0,366,365)))*G52)+($K$9-SUM($J$35:J51))*(($K$14/(IF(ROUND(YEAR(E52)/4,0)-YEAR(E52)/4=0,366,365)))*H52),2)","v":1564.48},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,19,null,20,"2024-07-23",30,7,23,5212.3099999999995,{"$f":"IF(B53<$K$10,$L$12,-$J$33-SUM($J$35:J52))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J52))*(($K$14/(IF(ROUND(YEAR(E52)/4,0)-YEAR(E52)/4=0,366,365)))*G53)+($K$9-SUM($J$35:J52))*(($K$14/(IF(ROUND(YEAR(E53)/4,0)-YEAR(E53)/4=0,366,365)))*H53),2)","v":1434.31},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,20,null,21,"2024-08-23",31,8,23,5177.7700000000004,{"$f":"IF(B54<$K$10,$L$12,-$J$33-SUM($J$35:J53))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J53))*(($K$14/(IF(ROUND(YEAR(E53)/4,0)-YEAR(E53)/4=0,366,365)))*G54)+($K$9-SUM($J$35:J53))*(($K$14/(IF(ROUND(YEAR(E54)/4,0)-YEAR(E54)/4=0,366,365)))*H54),2)","v":1399.77},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,21,null,22,"2024-09-23",31,8,23,5095.42,{"$f":"IF(B55<$K$10,$L$12,-$J$33-SUM($J$35:J54))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J54))*(($K$14/(IF(ROUND(YEAR(E54)/4,0)-YEAR(E54)/4=0,366,365)))*G55)+($K$9-SUM($J$35:J54))*(($K$14/(IF(ROUND(YEAR(E55)/4,0)-YEAR(E55)/4=0,366,365)))*H55),2)","v":1317.42},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,22,null,23,"2024-10-23",30,7,23,4973.22,{"$f":"IF(B56<$K$10,$L$12,-$J$33-SUM($J$35:J55))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J55))*(($K$14/(IF(ROUND(YEAR(E55)/4,0)-YEAR(E55)/4=0,366,365)))*G56)+($K$9-SUM($J$35:J55))*(($K$14/(IF(ROUND(YEAR(E56)/4,0)-YEAR(E56)/4=0,366,365)))*H56),2)","v":1195.22},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,23,null,24,"2024-11-23",31,8,23,4930.71,{"$f":"IF(B57<$K$10,$L$12,-$J$33-SUM($J$35:J56))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J56))*(($K$14/(IF(ROUND(YEAR(E56)/4,0)-YEAR(E56)/4=0,366,365)))*G57)+($K$9-SUM($J$35:J56))*(($K$14/(IF(ROUND(YEAR(E57)/4,0)-YEAR(E57)/4=0,366,365)))*H57),2)","v":1152.71},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,24,null,25,"2024-12-23",30,7,23,{"$f":"SUM(J58:U58)","v":4813.83},{"$f":"IF(B58<$K$10,$L$12,-$J$33-SUM($J$35:J57))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J57))*(($K$14/(IF(ROUND(YEAR(E57)/4,0)-YEAR(E57)/4=0,366,365)))*G58)+($K$9-SUM($J$35:J57))*(($K$14/(IF(ROUND(YEAR(E58)/4,0)-YEAR(E58)/4=0,366,365)))*H58),2)","v":1035.83},1000,null,0,{"$f":"IF(B58<$K$10,$K$9*$K$17,0)","v":0},null,null,null,null,{"$f":"IF(B58<$K$10,$K$9*$K$20,0)","v":0},null,"х","х"]
[1,25,null,26,"2025-01-23",31,8,23,4768.01,{"$f":"IF(B59<$K$10,$L$12,-$J$33-SUM($J$35:J58))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J58))*(($K$14/(IF(ROUND(YEAR(E58)/4,0)-YEAR(E58)/4=0,366,365)))*G59)+($K$9-SUM($J$35:J58))*(($K$14/(IF(ROUND(YEAR(E59)/4,0)-YEAR(E59)/4=0,366,365)))*H59),2)","v":990.01},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,26,null,27,"2025-02-23",31,8,23,4686.13,{"$f":"IF(B60<$K$10,$L$12,-$J$33-SUM($J$35:J59))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J59))*(($K$14/(IF(ROUND(YEAR(E59)/4,0)-YEAR(E59)/4=0,366,365)))*G60)+($K$9-SUM($J$35:J59))*(($K$14/(IF(ROUND(YEAR(E60)/4,0)-YEAR(E60)/4=0,366,365)))*H60),2)","v":908.13},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,27,null,28,"2025-03-23",28,5,23,4523.66,{"$f":"IF(B61<$K$10,$L$12,-$J$33-SUM($J$35:J60))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J60))*(($K$14/(IF(ROUND(YEAR(E60)/4,0)-YEAR(E60)/4=0,366,365)))*G61)+($K$9-SUM($J$35:J60))*(($K$14/(IF(ROUND(YEAR(E61)/4,0)-YEAR(E61)/4=0,366,365)))*H61),2)","v":745.66},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,28,null,29,"2025-04-23",31,8,23,4520.97,{"$f":"IF(B62<$K$10,$L$12,-$J$33-SUM($J$35:J61))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J61))*(($K$14/(IF(ROUND(YEAR(E61)/4,0)-YEAR(E61)/4=0,366,365)))*G62)+($K$9-SUM($J$35:J61))*(($K$14/(IF(ROUND(YEAR(E62)/4,0)-YEAR(E62)/4=0,366,365)))*H62),2)","v":742.97},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,29,null,30,"2025-05-23",30,7,23,4417.09,{"$f":"IF(B63<$K$10,$L$12,-$J$33-SUM($J$35:J62))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J62))*(($K$14/(IF(ROUND(YEAR(E62)/4,0)-YEAR(E62)/4=0,366,365)))*G63)+($K$9-SUM($J$35:J62))*(($K$14/(IF(ROUND(YEAR(E63)/4,0)-YEAR(E63)/4=0,366,365)))*H63),2)","v":639.09},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,30,null,31,"2025-06-23",31,8,23,4355.8099999999995,{"$f":"IF(B64<$K$10,$L$12,-$J$33-SUM($J$35:J63))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J63))*(($K$14/(IF(ROUND(YEAR(E63)/4,0)-YEAR(E63)/4=0,366,365)))*G64)+($K$9-SUM($J$35:J63))*(($K$14/(IF(ROUND(YEAR(E64)/4,0)-YEAR(E64)/4=0,366,365)))*H64),2)","v":577.80999999999995},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,31,null,32,"2025-07-23",30,7,23,4257.26,{"$f":"IF(B65<$K$10,$L$12,-$J$33-SUM($J$35:J64))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J64))*(($K$14/(IF(ROUND(YEAR(E64)/4,0)-YEAR(E64)/4=0,366,365)))*G65)+($K$9-SUM($J$35:J64))*(($K$14/(IF(ROUND(YEAR(E65)/4,0)-YEAR(E65)/4=0,366,365)))*H65),2)","v":479.26},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,32,null,33,"2025-08-23",31,8,23,4190.66,{"$f":"IF(B66<$K$10,$L$12,-$J$33-SUM($J$35:J65))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J65))*(($K$14/(IF(ROUND(YEAR(E65)/4,0)-YEAR(E65)/4=0,366,365)))*G66)+($K$9-SUM($J$35:J65))*(($K$14/(IF(ROUND(YEAR(E66)/4,0)-YEAR(E66)/4=0,366,365)))*H66),2)","v":412.66},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[{"$f":"IF(B67<=$K$10,1,0)","v":1},33,null,34,"2025-09-23",31,8,23,4108.08,{"$f":"IF(B67<$K$10,$L$12,-$J$33-SUM($J$35:J66))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J66))*(($K$14/(IF(ROUND(YEAR(E66)/4,0)-YEAR(E66)/4=0,366,365)))*G67)+($K$9-SUM($J$35:J66))*(($K$14/(IF(ROUND(YEAR(E67)/4,0)-YEAR(E67)/4=0,366,365)))*H67),2)","v":330.08},{"$f":"IF(A67=1,IF(AND(YEAR($K$11)=YEAR(EDATE(E66,1)),MONTH($K$11)=MONTH(EDATE(E66,1))),$O$16-$O$38,$O$16),0)","v":1000},null,null,null,null,null,null,null,null,null,"х","х"]
[1,{"$f":"B67+1","v":34},null,35,"2025-10-23",{"$f":"IF(A68=1,E68-E67,0)","v":30},7,23,4017.52,{"$f":"IF(B68<$K$10,$L$12,-$J$33-SUM($J$35:J67))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J67))*(($K$14/(IF(ROUND(YEAR(E67)/4,0)-YEAR(E67)/4=0,366,365)))*G68)+($K$9-SUM($J$35:J67))*(($K$14/(IF(ROUND(YEAR(E68)/4,0)-YEAR(E68)/4=0,366,365)))*H68),2)","v":239.52},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,35,null,36,"2025-11-23",31,8,23,3942.92,{"$f":"IF(B69<$K$10,$L$12,-$J$33-SUM($J$35:J68))","v":2778},{"$f":"ROUND(($K$9-SUM($J$35:J68))*(($K$14/(IF(ROUND(YEAR(E68)/4,0)-YEAR(E68)/4=0,366,365)))*G69)+($K$9-SUM($J$35:J68))*(($K$14/(IF(ROUND(YEAR(E69)/4,0)-YEAR(E69)/4=0,366,365)))*H69),2)","v":164.92},1000,null,null,null,null,null,null,null,null,null,"х","х"]
[1,36,null,37,"2025-12-22",29,7,22,3847.03,{"$f":"IF(B70<$K$10,$L$12,-$J$33-SUM($J$35:J69))","v":2770},{"$f":"ROUND(($K$9-SUM($J$35:J69))*(($K$14/(IF(ROUND(YEAR(E69)/4,0)-YEAR(E69)/4=0,366,365)))*G70)+($K$9-SUM($J$35:J69))*(($K$14/(IF(ROUND(YEAR(E70)/4,0)-YEAR(E70)/4=0,366,365)))*H70),2)","v":77.03},1000,null,null,{"$f":"IF(B70<$K$10,$K$9*$K$17,0)","v":0},null,null,null,null,{"$f":"IF(B70<$K$10,$K$9*$K$20,0)","v":0},null,"х","х"]
[0,37,null,38,"2026-01-22",0,{"$f":"EOMONTH(E70,0)-E70","v":9},{"$f":"E71-EOMONTH(E70,0)","v":22},0,{"$f":"IF(B71<$K$10,$L$12,-$J$33-SUM($J$35:J70))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J70))*(($K$14/(IF(ROUND(YEAR(E70)/4,0)-YEAR(E70)/4=0,366,365)))*G71)+($K$9-SUM($J$35:J70))*(($K$14/(IF(ROUND(YEAR(E71)/4,0)-YEAR(E71)/4=0,366,365)))*H71),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,38,null,39,"2026-02-22",0,9,22,0,{"$f":"IF(B72<$K$10,$L$12,-$J$33-SUM($J$35:J71))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J71))*(($K$14/(IF(ROUND(YEAR(E71)/4,0)-YEAR(E71)/4=0,366,365)))*G72)+($K$9-SUM($J$35:J71))*(($K$14/(IF(ROUND(YEAR(E72)/4,0)-YEAR(E72)/4=0,366,365)))*H72),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,39,null,40,"2026-03-22",0,6,22,0,{"$f":"IF(B73<$K$10,$L$12,-$J$33-SUM($J$35:J72))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J72))*(($K$14/(IF(ROUND(YEAR(E72)/4,0)-YEAR(E72)/4=0,366,365)))*G73)+($K$9-SUM($J$35:J72))*(($K$14/(IF(ROUND(YEAR(E73)/4,0)-YEAR(E73)/4=0,366,365)))*H73),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,40,null,41,"2026-04-22",0,9,22,0,{"$f":"IF(B74<$K$10,$L$12,-$J$33-SUM($J$35:J73))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J73))*(($K$14/(IF(ROUND(YEAR(E73)/4,0)-YEAR(E73)/4=0,366,365)))*G74)+($K$9-SUM($J$35:J73))*(($K$14/(IF(ROUND(YEAR(E74)/4,0)-YEAR(E74)/4=0,366,365)))*H74),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,41,null,42,"2026-05-22",0,8,22,0,{"$f":"IF(B75<$K$10,$L$12,-$J$33-SUM($J$35:J74))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J74))*(($K$14/(IF(ROUND(YEAR(E74)/4,0)-YEAR(E74)/4=0,366,365)))*G75)+($K$9-SUM($J$35:J74))*(($K$14/(IF(ROUND(YEAR(E75)/4,0)-YEAR(E75)/4=0,366,365)))*H75),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,42,null,43,"2026-06-22",0,9,22,0,{"$f":"IF(B76<$K$10,$L$12,-$J$33-SUM($J$35:J75))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J75))*(($K$14/(IF(ROUND(YEAR(E75)/4,0)-YEAR(E75)/4=0,366,365)))*G76)+($K$9-SUM($J$35:J75))*(($K$14/(IF(ROUND(YEAR(E76)/4,0)-YEAR(E76)/4=0,366,365)))*H76),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,43,null,44,"2026-07-22",0,8,22,0,{"$f":"IF(B77<$K$10,$L$12,-$J$33-SUM($J$35:J76))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J76))*(($K$14/(IF(ROUND(YEAR(E76)/4,0)-YEAR(E76)/4=0,366,365)))*G77)+($K$9-SUM($J$35:J76))*(($K$14/(IF(ROUND(YEAR(E77)/4,0)-YEAR(E77)/4=0,366,365)))*H77),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,44,null,45,"2026-08-22",0,9,22,0,{"$f":"IF(B78<$K$10,$L$12,-$J$33-SUM($J$35:J77))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J77))*(($K$14/(IF(ROUND(YEAR(E77)/4,0)-YEAR(E77)/4=0,366,365)))*G78)+($K$9-SUM($J$35:J77))*(($K$14/(IF(ROUND(YEAR(E78)/4,0)-YEAR(E78)/4=0,366,365)))*H78),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,45,null,46,"2026-09-22",0,9,22,0,{"$f":"IF(B79<$K$10,$L$12,-$J$33-SUM($J$35:J78))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J78))*(($K$14/(IF(ROUND(YEAR(E78)/4,0)-YEAR(E78)/4=0,366,365)))*G79)+($K$9-SUM($J$35:J78))*(($K$14/(IF(ROUND(YEAR(E79)/4,0)-YEAR(E79)/4=0,366,365)))*H79),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,46,null,47,"2026-10-22",0,8,22,0,{"$f":"IF(B80<$K$10,$L$12,-$J$33-SUM($J$35:J79))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J79))*(($K$14/(IF(ROUND(YEAR(E79)/4,0)-YEAR(E79)/4=0,366,365)))*G80)+($K$9-SUM($J$35:J79))*(($K$14/(IF(ROUND(YEAR(E80)/4,0)-YEAR(E80)/4=0,366,365)))*H80),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,47,null,48,"2026-11-22",0,9,22,0,{"$f":"IF(B81<$K$10,$L$12,-$J$33-SUM($J$35:J80))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J80))*(($K$14/(IF(ROUND(YEAR(E80)/4,0)-YEAR(E80)/4=0,366,365)))*G81)+($K$9-SUM($J$35:J80))*(($K$14/(IF(ROUND(YEAR(E81)/4,0)-YEAR(E81)/4=0,366,365)))*H81),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,48,null,49,"2026-12-22",0,8,22,0,{"$f":"IF(B82<$K$10,$L$12,-$J$33-SUM($J$35:J81))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J81))*(($K$14/(IF(ROUND(YEAR(E81)/4,0)-YEAR(E81)/4=0,366,365)))*G82)+($K$9-SUM($J$35:J81))*(($K$14/(IF(ROUND(YEAR(E82)/4,0)-YEAR(E82)/4=0,366,365)))*H82),2)","v":0},0,null,null,{"$f":"IF(B82<$K$10,$K$9*$K$17,0)","v":0},null,null,null,null,{"$f":"IF(B82<$K$10,$K$8*$K$20,0)","v":0},null,"х","х"]
[0,49,null,50,"2027-01-22",0,9,22,0,{"$f":"IF(B83<$K$10,$L$12,-$J$33-SUM($J$35:J82))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J82))*(($K$14/(IF(ROUND(YEAR(E82)/4,0)-YEAR(E82)/4=0,366,365)))*G83)+($K$9-SUM($J$35:J82))*(($K$14/(IF(ROUND(YEAR(E83)/4,0)-YEAR(E83)/4=0,366,365)))*H83),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,{"$f":"B83+1","v":50},null,51,"2027-02-22",0,9,22,0,{"$f":"IF(B84<$K$10,$L$12,-$J$33-SUM($J$35:J83))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J83))*(($K$14/(IF(ROUND(YEAR(E83)/4,0)-YEAR(E83)/4=0,366,365)))*G84)+($K$9-SUM($J$35:J83))*(($K$14/(IF(ROUND(YEAR(E84)/4,0)-YEAR(E84)/4=0,366,365)))*H84),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,51,null,52,"2027-03-22",0,6,22,0,{"$f":"IF(B85<$K$10,$L$12,-$J$33-SUM($J$35:J84))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J84))*(($K$14/(IF(ROUND(YEAR(E84)/4,0)-YEAR(E84)/4=0,366,365)))*G85)+($K$9-SUM($J$35:J84))*(($K$14/(IF(ROUND(YEAR(E85)/4,0)-YEAR(E85)/4=0,366,365)))*H85),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,52,null,53,"2027-04-22",0,9,22,0,{"$f":"IF(B86<$K$10,$L$12,-$J$33-SUM($J$35:J85))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J85))*(($K$14/(IF(ROUND(YEAR(E85)/4,0)-YEAR(E85)/4=0,366,365)))*G86)+($K$9-SUM($J$35:J85))*(($K$14/(IF(ROUND(YEAR(E86)/4,0)-YEAR(E86)/4=0,366,365)))*H86),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,53,null,54,"2027-05-22",0,8,22,0,{"$f":"IF(B87<$K$10,$L$12,-$J$33-SUM($J$35:J86))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J86))*(($K$14/(IF(ROUND(YEAR(E86)/4,0)-YEAR(E86)/4=0,366,365)))*G87)+($K$9-SUM($J$35:J86))*(($K$14/(IF(ROUND(YEAR(E87)/4,0)-YEAR(E87)/4=0,366,365)))*H87),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,54,null,55,"2027-06-22",0,9,22,0,{"$f":"IF(B88<$K$10,$L$12,-$J$33-SUM($J$35:J87))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J87))*(($K$14/(IF(ROUND(YEAR(E87)/4,0)-YEAR(E87)/4=0,366,365)))*G88)+($K$9-SUM($J$35:J87))*(($K$14/(IF(ROUND(YEAR(E88)/4,0)-YEAR(E88)/4=0,366,365)))*H88),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,55,null,56,"2027-07-22",0,8,22,0,{"$f":"IF(B89<$K$10,$L$12,-$J$33-SUM($J$35:J88))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J88))*(($K$14/(IF(ROUND(YEAR(E88)/4,0)-YEAR(E88)/4=0,366,365)))*G89)+($K$9-SUM($J$35:J88))*(($K$14/(IF(ROUND(YEAR(E89)/4,0)-YEAR(E89)/4=0,366,365)))*H89),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,56,null,57,"2027-08-22",0,9,22,0,{"$f":"IF(B90<$K$10,$L$12,-$J$33-SUM($J$35:J89))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J89))*(($K$14/(IF(ROUND(YEAR(E89)/4,0)-YEAR(E89)/4=0,366,365)))*G90)+($K$9-SUM($J$35:J89))*(($K$14/(IF(ROUND(YEAR(E90)/4,0)-YEAR(E90)/4=0,366,365)))*H90),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,57,null,58,"2027-09-22",0,9,22,0,{"$f":"IF(B91<$K$10,$L$12,-$J$33-SUM($J$35:J90))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J90))*(($K$14/(IF(ROUND(YEAR(E90)/4,0)-YEAR(E90)/4=0,366,365)))*G91)+($K$9-SUM($J$35:J90))*(($K$14/(IF(ROUND(YEAR(E91)/4,0)-YEAR(E91)/4=0,366,365)))*H91),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,58,null,59,"2027-10-22",0,8,22,0,{"$f":"IF(B92<$K$10,$L$12,-$J$33-SUM($J$35:J91))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J91))*(($K$14/(IF(ROUND(YEAR(E91)/4,0)-YEAR(E91)/4=0,366,365)))*G92)+($K$9-SUM($J$35:J91))*(($K$14/(IF(ROUND(YEAR(E92)/4,0)-YEAR(E92)/4=0,366,365)))*H92),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,59,null,60,"2027-11-22",0,9,22,0,{"$f":"IF(B93<$K$10,$L$12,-$J$33-SUM($J$35:J92))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J92))*(($K$14/(IF(ROUND(YEAR(E92)/4,0)-YEAR(E92)/4=0,366,365)))*G93)+($K$9-SUM($J$35:J92))*(($K$14/(IF(ROUND(YEAR(E93)/4,0)-YEAR(E93)/4=0,366,365)))*H93),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,60,null,61,"2027-12-22",0,8,22,0,{"$f":"IF(B94<$K$10,$L$12,-$J$33-SUM($J$35:J93))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J93))*(($K$14/(IF(ROUND(YEAR(E93)/4,0)-YEAR(E93)/4=0,366,365)))*G94)+($K$9-SUM($J$35:J93))*(($K$14/(IF(ROUND(YEAR(E94)/4,0)-YEAR(E94)/4=0,366,365)))*H94),2)","v":0},0,null,null,{"$f":"IF(B94<$K$10,$K$9*$K$17,0)","v":0},null,null,null,null,{"$f":"IF(B94<$K$10,$K$8*$K$20,0)","v":0},null,"х","х"]
[0,61,null,62,"2028-01-22",0,9,22,0,{"$f":"IF(B95<$K$10,$L$12,-$J$33-SUM($J$35:J94))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J94))*(($K$14/(IF(ROUND(YEAR(E94)/4,0)-YEAR(E94)/4=0,366,365)))*G95)+($K$9-SUM($J$35:J94))*(($K$14/(IF(ROUND(YEAR(E95)/4,0)-YEAR(E95)/4=0,366,365)))*H95),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,62,null,63,"2028-02-22",0,9,22,0,{"$f":"IF(B96<$K$10,$L$12,-$J$33-SUM($J$35:J95))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J95))*(($K$14/(IF(ROUND(YEAR(E95)/4,0)-YEAR(E95)/4=0,366,365)))*G96)+($K$9-SUM($J$35:J95))*(($K$14/(IF(ROUND(YEAR(E96)/4,0)-YEAR(E96)/4=0,366,365)))*H96),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,63,null,64,"2028-03-22",0,7,22,0,{"$f":"IF(B97<$K$10,$L$12,-$J$33-SUM($J$35:J96))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J96))*(($K$14/(IF(ROUND(YEAR(E96)/4,0)-YEAR(E96)/4=0,366,365)))*G97)+($K$9-SUM($J$35:J96))*(($K$14/(IF(ROUND(YEAR(E97)/4,0)-YEAR(E97)/4=0,366,365)))*H97),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,64,null,65,"2028-04-22",0,9,22,0,{"$f":"IF(B98<$K$10,$L$12,-$J$33-SUM($J$35:J97))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J97))*(($K$14/(IF(ROUND(YEAR(E97)/4,0)-YEAR(E97)/4=0,366,365)))*G98)+($K$9-SUM($J$35:J97))*(($K$14/(IF(ROUND(YEAR(E98)/4,0)-YEAR(E98)/4=0,366,365)))*H98),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[{"$f":"IF(B99<=$K$10,1,0)","v":0},65,null,66,"2028-05-22",0,8,22,0,{"$f":"IF(B99<$K$10,$L$12,-$J$33-SUM($J$35:J98))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J98))*(($K$14/(IF(ROUND(YEAR(E98)/4,0)-YEAR(E98)/4=0,366,365)))*G99)+($K$9-SUM($J$35:J98))*(($K$14/(IF(ROUND(YEAR(E99)/4,0)-YEAR(E99)/4=0,366,365)))*H99),2)","v":0},{"$f":"IF(A99=1,IF(AND(YEAR($K$11)=YEAR(EDATE(E98,1)),MONTH($K$11)=MONTH(EDATE(E98,1))),$O$16-$O$38,$O$16),0)","v":0},null,null,null,null,null,null,null,null,null,"х","х"]
[0,{"$f":"B99+1","v":66},null,67,"2028-06-22",{"$f":"IF(A100=1,E100-E99,0)","v":0},9,22,0,{"$f":"IF(B100<$K$10,$L$12,-$J$33-SUM($J$35:J99))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J99))*(($K$14/(IF(ROUND(YEAR(E99)/4,0)-YEAR(E99)/4=0,366,365)))*G100)+($K$9-SUM($J$35:J99))*(($K$14/(IF(ROUND(YEAR(E100)/4,0)-YEAR(E100)/4=0,366,365)))*H100),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,67,null,68,{"$f":"IF(AND(YEAR($K$11)=YEAR(EDATE(E100,1)),MONTH($K$11)=MONTH(EDATE(E100,1))),$K$11,EDATE(E100,1))","v":"2028-07-22"},0,{"$f":"EOMONTH(E100,0)-E100","v":8},{"$f":"E101-EOMONTH(E100,0)","v":22},0,{"$f":"IF(B101<$K$10,$L$12,-$J$33-SUM($J$35:J100))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J100))*(($K$14/(IF(ROUND(YEAR(E100)/4,0)-YEAR(E100)/4=0,366,365)))*G101)+($K$9-SUM($J$35:J100))*(($K$14/(IF(ROUND(YEAR(E101)/4,0)-YEAR(E101)/4=0,366,365)))*H101),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,68,null,69,"2028-08-22",0,9,22,0,{"$f":"IF(B102<$K$10,$L$12,-$J$33-SUM($J$35:J101))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J101))*(($K$14/(IF(ROUND(YEAR(E101)/4,0)-YEAR(E101)/4=0,366,365)))*G102)+($K$9-SUM($J$35:J101))*(($K$14/(IF(ROUND(YEAR(E102)/4,0)-YEAR(E102)/4=0,366,365)))*H102),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,69,null,70,"2028-09-22",0,9,22,0,{"$f":"IF(B103<$K$10,$L$12,-$J$33-SUM($J$35:J102))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J102))*(($K$14/(IF(ROUND(YEAR(E102)/4,0)-YEAR(E102)/4=0,366,365)))*G103)+($K$9-SUM($J$35:J102))*(($K$14/(IF(ROUND(YEAR(E103)/4,0)-YEAR(E103)/4=0,366,365)))*H103),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,70,null,71,"2028-10-22",0,8,22,0,{"$f":"IF(B104<$K$10,$L$12,-$J$33-SUM($J$35:J103))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J103))*(($K$14/(IF(ROUND(YEAR(E103)/4,0)-YEAR(E103)/4=0,366,365)))*G104)+($K$9-SUM($J$35:J103))*(($K$14/(IF(ROUND(YEAR(E104)/4,0)-YEAR(E104)/4=0,366,365)))*H104),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,71,null,72,"2028-11-22",0,9,22,0,{"$f":"IF(B105<$K$10,$L$12,-$J$33-SUM($J$35:J104))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J104))*(($K$14/(IF(ROUND(YEAR(E104)/4,0)-YEAR(E104)/4=0,366,365)))*G105)+($K$9-SUM($J$35:J104))*(($K$14/(IF(ROUND(YEAR(E105)/4,0)-YEAR(E105)/4=0,366,365)))*H105),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[0,72,null,73,"2028-12-22",0,8,22,0,{"$f":"IF(B106<$K$10,$L$12,-$J$33-SUM($J$35:J105))","v":0},{"$f":"ROUND(($K$9-SUM($J$35:J105))*(($K$14/(IF(ROUND(YEAR(E105)/4,0)-YEAR(E105)/4=0,366,365)))*G106)+($K$9-SUM($J$35:J105))*(($K$14/(IF(ROUND(YEAR(E106)/4,0)-YEAR(E106)/4=0,366,365)))*H106),2)","v":0},0,null,null,null,null,null,null,null,null,null,"х","х"]
[1,null,null,"Усього","х",{"$f":"SUM(F35:F70)","v":1095},null,null,{"$f":"SUM(I35:I106)","v":189941.63999999998},{"$f":"SUM(J35:J106)","v":100000},{"$f":"SUM(K35:K106)","v":53941.64},{"$f":"SUM(L35:L106)","v":36000},{"$f":"SUM(M33:M106)","v":0},{"$f":"SUM(N33:N106)","v":0},0,0,0,0,0,0,0,{"$f":"XIRR(I33:I106,E33:E106)","v":0.69126212000846843},{"$f":"SUM(J107:U107)","v":189941.64}]
[1,0]
[1,0.01]
[1,null,null,"Загальні витрати за кредитом (проценти за користуваннґ кредитом, комісії та інші обов'язкові платежі за додаткові та супутні послуги кредитодавця,кредитного посередника (за наявності) та третії осіб, пов'язані з отриманням, обслуговуванням та поверненням кредиту), грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(9,K107:U107)","v":89941.64}]
[1,null,null,"Орієнтовна загальна вартість кредиту для споживача за весь строк користування кредитом (у т.ч. тіло кредиту, відсотки, комісії та інші платежі), грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"W107","v":189941.64}]
[1,null,null,"Сума платежу за розрахунковий період, грн.",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I35","v":6750.6}]
[1,null,null,"Орієнтовна реальна річна процентна ставка, % річних",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V107","v":0.69126212000846843}]
[1]
[1,null,null,"Застереження: наведені обчислення орієнтовної реальної річної процентної ставки та орієнтовної загальної вартості кредиту для споживача є репрезентативними та базуються на обраних споживачем умовах кредитування, викладених вище, і на припущенні, що договір про споживчий кредит залишатиметься дійсним протягом погодженого строку, а кредитодавець і споживач виконають свої обов’язки на умовах та у строки, визначені в договорі. "]
[1,null,null,"Орієнтовна реальна річна процентна ставка обчислена на основі припущення, що процентна ставка та інші платежі за послуги кредитодавця залишатимуться незмінними та застосовуватимуться протягом строку дії договору про споживчий кредит. \nОрієнтовна реальна річна процентна ставка обчислена з використанням фінансової функції ЧИСТВНДОХ програмного продукту Microsoft Excel."]
[1,null,null,"Застереження: використання інших способів надання кредиту та/або зміна інших вищезазначених умов кредитування можуть мати наслідком застосування іншої орієнтовної реальної річної процентної ставки та орієнтовної загальної вартості кредиту для споживача."]