{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Калькулятор","Переплата без страховки"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,2],[2,0,2,2],[3,0,3,2],[4,0,4,2],[5,0,5,3],[6,0,6,3],[15,0,15,3],[16,0,16,2],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,1],[22,0,22,1],[23,0,23,3],[8,0,8,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[13,0,13,3],[14,0,14,3]]}
["Параметры кредита"]
["Сумма кредита",null,null,1.6E7]
["Срок в годах",null,null,25.0]
["Ставка без страховок",null,null,0.05]
["Ежемесячный платеж",null,null,{"$f":"PMT(D4/12,D3*12,-D2)","v":93534.40664}]
[]
["Если берете первичку"]
["Страхование жизни и здоровья",null,null,0.0]
["Ставка со страховкой",null,null,0.01]
["Ежемесячный платеж",null,null,{"$f":"PMT(D9/12,D3*12,-D2)","v":60299.59268}]
["Переплата за год при повышенной ставке",null,null,{"$f":"'Переплата без страховки'!D13","v":93534.40664}]
["Переплата за год при пониженной ставке",null,null,{"$f":"'Переплата без страховки'!H15","v":157409.6669}]
["Заплатите за страховку",null,null,{"$f":"D8","v":0}]
[{"$f":"if(D11>=D13+D12,\"Страховка выгоднее\",\"Страховка невыгодна\")","v":"Страховка невыгодна"}]
[]
["Если берете вторичку"]
["Страхование жизни и здоровья",null,null,210000.0]
["Страхование титула",null,null,59000.0]
["Ставка со страховкой",null,null,0.01]
["Ежемесячный платеж",null,null,{"$f":"PMT(D19/12,D3*12,-D2)","v":60299.59268}]
["Переплата за год при повышенной ставке",null,null,{"$f":"'Переплата без страховки'!B15","v":792507.7832}]
["Переплата за год при пониженной ставке",null,null,{"$f":"'Переплата без страховки'!N15","v":157409.6669}]
["Заплатите за страховки",null,null,{"$f":"D17+D18","v":269000}]
[{"$f":"if(D21>=D23+D22,\"Страховка выгоднее\",\"Страховка невыгодна\")","v":"Страховка выгоднее"}]

{"sheet":"Переплата без страховки","index":1,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,4],[0,6,0,10],[0,12,0,16]]}
["Повышенная ставка",{"$nulls":5},"Новостройка",{"$nulls":5},"Вторичка"]
["Месяцы","Проценты","Долг","Платеж","Остаток",null,"Месяцы","Проценты","Долг","Платеж","Остаток",null,"Месяцы","Проценты","Долг","Платеж","Остаток"]
[1.0,{"$f":"'Калькулятор'!D2*'Калькулятор'!D4/12","v":66666.66667},{"$f":"D3-B3","v":26867.73997},{"$f":"'Калькулятор'!D5","v":93534.40664},{"$f":"'Калькулятор'!D2-C3","v":15973132.26},null,1.0,{"$f":"'Калькулятор'!D2*'Калькулятор'!D9/12","v":13333.33333},{"$f":"J3-H3","v":46966.25934},{"$f":"'Калькулятор'!D10","v":60299.59268},{"$f":"'Калькулятор'!D2-I3","v":15953033.74},null,1.0,{"$f":"'Калькулятор'!D2*'Калькулятор'!D19/12","v":13333.33333},{"$f":"P3-N3","v":46966.25934},{"$f":"'Калькулятор'!D20","v":60299.59268},{"$f":"'Калькулятор'!D2-O3","v":15953033.74}]
[{"$f":"A3+1","v":2},{"$f":"E3*'Калькулятор'!$D$4/12","v":66554.71775},26979.68889,{"$f":"D3","v":93534.40664},{"$f":"E3-C4","v":15946152.57},null,{"$f":"G3+1","v":2},{"$f":"K3*'Калькулятор'!$D$9/12","v":13294.19478},47005.39789,{"$f":"J3","v":60299.59268},{"$f":"K3-I4","v":15906028.34},null,{"$f":"M3+1","v":2},{"$f":"Q3*'Калькулятор'!$D$19/12","v":13294.19478},47005.39789,{"$f":"P3","v":60299.59268},{"$f":"Q3-O4","v":15906028.34}]
[3,{"$f":"E4*'Калькулятор'!$D$4/12","v":66442.30238},27092.10426,93534.40664,15919060.47,null,3,{"$f":"K4*'Калькулятор'!$D$9/12","v":13255.02362},47044.56906,60299.59268,15858983.77,null,3,{"$f":"Q4*'Калькулятор'!$D$19/12","v":13255.02362},47044.56906,60299.59268,15858983.77]
[4,{"$f":"E5*'Калькулятор'!$D$4/12","v":66329.41861},27204.98803,93534.40664,15891855.48,null,4,{"$f":"K5*'Калькулятор'!$D$9/12","v":13215.81981},47083.77287,60299.59268,15811900,null,4,{"$f":"Q5*'Калькулятор'!$D$19/12","v":13215.81981},47083.77287,60299.59268,15811900]
[5,{"$f":"E6*'Калькулятор'!$D$4/12","v":66216.0645},27318.34215,93534.40664,15864537.14,null,5,{"$f":"K6*'Калькулятор'!$D$9/12","v":13176.58333},47123.00934,60299.59268,15764776.99,null,5,{"$f":"Q6*'Калькулятор'!$D$19/12","v":13176.58333},47123.00934,60299.59268,15764776.99]
[6,{"$f":"E7*'Калькулятор'!$D$4/12","v":66102.23807},27432.16857,93534.40664,15837104.97,null,6,{"$f":"K7*'Калькулятор'!$D$9/12","v":13137.31416},47162.27852,60299.59268,15717614.71,null,6,{"$f":"Q7*'Калькулятор'!$D$19/12","v":13137.31416},47162.27852,60299.59268,15717614.71]
[7,{"$f":"E8*'Калькулятор'!$D$4/12","v":65987.93737},27546.46927,93534.40664,15809558.5,null,7,{"$f":"K8*'Калькулятор'!$D$9/12","v":13098.01226},47201.58042,60299.59268,15670413.13,null,7,{"$f":"Q8*'Калькулятор'!$D$19/12","v":13098.01226},47201.58042,60299.59268,15670413.13]
[8,{"$f":"E9*'Калькулятор'!$D$4/12","v":65873.16041},27661.24623,93534.40664,15781897.25,null,8,{"$f":"K9*'Калькулятор'!$D$9/12","v":13058.67761},47240.91507,60299.59268,15623172.22,null,8,{"$f":"Q9*'Калькулятор'!$D$19/12","v":13058.67761},47240.91507,60299.59268,15623172.22]
[9,{"$f":"E10*'Калькулятор'!$D$4/12","v":65757.90522},27776.50142,93534.40664,15754120.75,null,9,{"$f":"K10*'Калькулятор'!$D$9/12","v":13019.31018},47280.2825,60299.59268,15575891.94,null,9,{"$f":"Q10*'Калькулятор'!$D$19/12","v":13019.31018},47280.2825,60299.59268,15575891.94]
[10,{"$f":"E11*'Калькулятор'!$D$4/12","v":65642.1698},27892.23684,93534.40664,15726228.51,null,10,{"$f":"K11*'Калькулятор'!$D$9/12","v":12979.90995},47319.68273,60299.59268,15528572.25,null,10,{"$f":"Q11*'Калькулятор'!$D$19/12","v":12979.90995},47319.68273,60299.59268,15528572.25]
[11,{"$f":"E12*'Калькулятор'!$D$4/12","v":65525.95214},28008.4545,93534.40664,15698220.06,null,11,{"$f":"K12*'Калькулятор'!$D$9/12","v":12940.47688},47359.1158,60299.59268,15481213.14,null,11,{"$f":"Q12*'Калькулятор'!$D$19/12","v":12940.47688},47359.1158,60299.59268,15481213.14]
[12,{"$f":"E13*'Калькулятор'!$D$4/12","v":65409.25025},28125.15639,93534.40664,15670094.9,null,12,{"$f":"K13*'Калькулятор'!$D$9/12","v":12901.01095},47398.58173,60299.59268,15433814.55,null,12,{"$f":"Q13*'Калькулятор'!$D$19/12","v":12901.01095},47398.58173,60299.59268,15433814.55]
[null,{"$f":"SUM(B3:B14)","v":792507.7832},{"$nulls":5},{"$f":"SUM(H3:H14)","v":157409.6669},{"$nulls":5},{"$f":"SUM(N3:N14)","v":157409.6669}]