{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Расчет 1-10 лет"],"not_rendered":{"images":1,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Расчет 1-10 лет","index":0,"n_rows":137,"n_cols":13,"rows_kept":137,"merged":[[0,0,1,9],[1,11,2,12],[2,0,2,7],[2,8,2,9],[3,0,3,7],[3,8,3,9],[4,0,4,7],[4,8,4,9],[5,0,5,7],[5,8,5,9],[5,12,5,14],[6,0,6,7],[6,8,6,9],[6,12,6,14],[7,0,7,7],[7,8,7,9],[7,12,7,14],[8,0,8,7],[8,8,8,9],[8,12,8,14],[9,0,9,7],[9,8,9,9],[10,0,10,9],[11,0,12,0],[11,1,12,1],[11,2,11,4],[11,5,12,5],[11,6,11,8],[11,9,12,9],[137,0,137,9],[138,0,138,2],[138,3,139,3],[138,8,139,8],[139,0,139,2]]}
["Расчет лизинговых платежей"]
[{"$nulls":11}," - ячейки для внесения данных"]
["Стоимость объекта лизинга без НДС, руб.",{"$nulls":7},{"v":160000000,"d":"160,000,000"}]
["Ставка НДС, %",{"$nulls":7},"20",{"$nulls":3},10]
["Стоимость объекта лизинга с НДС, руб.",{"$nulls":7},{"$f":"I3*(I4+100)/100","v":{"v":192000000,"d":"192,000,000"}},{"$nulls":3},20]
["Ставка по лизингу, % годовых",{"$nulls":7},15,null,"Выкупная стоимость -",null,{"$f":"J137","v":{"v":28800000,"d":"28,800,000"}}]
["Срок лизинга, месяцев",{"$nulls":7},24,null,"Итого выплат  -",null,{"$f":"J136+E137+E14","v":{"v":248568000,"d":"248,568,000"}}]
["Авансовый платеж, %",{"$nulls":7},10,null,"Удорожание за весь срок -",null,{"$f":"I136/I5","v":{"v":0.194625,"d":"19.46%"}}]
["Выкупная стоимость, %",{"$nulls":7},15,null,"Амортизационные отчисления - ",null,{"$f":"I10/I7","v":{"v":5666666.666666667,"d":"5,666,667"}}]
["Амортизационная стоимость, руб.",{"$nulls":7},{"$f":"$I$3*(100-$I$9)/100","v":{"v":136000000,"d":"136,000,000"}}]
[]
["Номер платежа","Контрактная стоимость на начало периода без НДС","Возмещение стоимости",null,null,"Остаток контрактной стоимости с НДС","Ставка по лизингу",null,null,"Всего - лизинговый платеж с НДС"]
[null,null,"cумма без НДС","cумма НДС","cумма с НДС",null,"cумма без НДС","cумма НДС","cумма с НДС"]
["Зачет аванса",{"$f":"I3","v":{"v":160000000,"d":"160,000,000"}},{"$f":"I3*I8/100","v":{"v":16000000,"d":"16,000,000"}},{"$f":"C14*$I$4/100","v":{"v":3200000,"d":"3,200,000"}},{"$f":"C14+D14","v":{"v":19200000,"d":"19,200,000"}},{"$f":"I5-(C14+D14)","v":{"v":172800000,"d":"172,800,000"}},{"$nulls":3},{"$f":"E14","v":{"v":19200000,"d":"19,200,000"}}]
[]
[{"$f":"IF(A15>=$I$7,\"\",A15+1)","v":1},{"$f":"I3-C14","v":{"v":144000000,"d":"144,000,000"}},{"$f":"IF(A16=\"\",\"\",($I$3*(100-$I$8-$I$9)/100)/($I$7))","v":{"v":5000000,"d":"5,000,000"}},{"$f":"IF(A16=\"\",\"\",C16*$I$4/100)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF(A16=\"\",\"\",D16+C16)","v":{"v":6000000,"d":"6,000,000"}},{"$f":"IF(A16=\"\",\"\",F14-E16)","v":{"v":166800000,"d":"166,800,000"}},{"$f":"IF(A16=\"\",\"\",F14*$I$6/100/12)","v":{"v":2160000,"d":"2,160,000"}},{"$f":"IF(A16=\"\",\"\",G16*$I$4/100)","v":{"v":432000,"d":"432,000"}},{"$f":"IF(A16=\"\",\"\",G16+H16)","v":{"v":2592000,"d":"2,592,000"}},{"$f":"IF(A16=\"\",\"\",E16+I16)","v":{"v":8592000,"d":"8,592,000"}}]
[{"$f":"IF(A16>=$I$7,\"\",A16+1)","v":2},{"$f":"IF(A17=\"\",\"\",B16-C16)","v":{"v":139000000,"d":"139,000,000"}},{"$f":"IF(A17=\"\",\"\",($I$3*(100-$I$8-$I$9)/100)/($I$7))","v":{"v":5000000,"d":"5,000,000"}},{"$f":"IF(A17=\"\",\"\",C17*$I$4/100)","v":{"v":1000000,"d":"1,000,000"}},{"$f":"IF(A17=\"\",\"\",D17+C17)","v":{"v":6000000,"d":"6,000,000"}},{"$f":"IF(A17=\"\",\"\",F16-E17)","v":{"v":160800000,"d":"160,800,000"}},{"$f":"IF(A17=\"\",\"\",F16*$I$6/100/12)","v":{"v":2085000,"d":"2,085,000"}},{"$f":"IF(A17=\"\",\"\",G17*$I$4/100)","v":{"v":417000,"d":"417,000"}},{"$f":"IF(A17=\"\",\"\",G17+H17)","v":{"v":2502000,"d":"2,502,000"}},{"$f":"IF(A17=\"\",\"\",E17+I17)","v":{"v":8502000,"d":"8,502,000"}}]
[{"$f":"IF(A17>=$I$7,\"\",A17+1)","v":3},{"$f":"IF(A18=\"\",\"\",B17-C17)","v":{"v":134000000,"d":"134,000,000"}},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"$f":"IF(A18=\"\",\"\",F17-E18)","v":{"v":154800000,"d":"154,800,000"}},{"$f":"IF(A18=\"\",\"\",F17*$I$6/100/12)","v":{"v":2010000,"d":"2,010,000"}},{"v":402000,"d":"402,000"},{"v":2412000,"d":"2,412,000"},{"$f":"IF(A18=\"\",\"\",E18+I18)","v":{"v":8412000,"d":"8,412,000"}}]
[4,{"v":129000000,"d":"129,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":148800000,"d":"148,800,000"},{"v":1935000,"d":"1,935,000"},{"v":387000,"d":"387,000"},{"v":2322000,"d":"2,322,000"},{"v":8322000,"d":"8,322,000"}]
[5,{"v":124000000,"d":"124,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":142800000,"d":"142,800,000"},{"v":1860000,"d":"1,860,000"},{"v":372000,"d":"372,000"},{"v":2232000,"d":"2,232,000"},{"v":8232000,"d":"8,232,000"}]
[6,{"v":119000000,"d":"119,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":136800000,"d":"136,800,000"},{"v":1785000,"d":"1,785,000"},{"v":357000,"d":"357,000"},{"v":2142000,"d":"2,142,000"},{"v":8142000,"d":"8,142,000"}]
[7,{"v":114000000,"d":"114,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":130800000,"d":"130,800,000"},{"v":1710000,"d":"1,710,000"},{"v":342000,"d":"342,000"},{"v":2052000,"d":"2,052,000"},{"v":8052000,"d":"8,052,000"}]
[8,{"v":109000000,"d":"109,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":124800000,"d":"124,800,000"},{"v":1635000,"d":"1,635,000"},{"v":327000,"d":"327,000"},{"v":1962000,"d":"1,962,000"},{"v":7962000,"d":"7,962,000"}]
[9,{"v":104000000,"d":"104,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":118800000,"d":"118,800,000"},{"v":1560000,"d":"1,560,000"},{"v":312000,"d":"312,000"},{"v":1872000,"d":"1,872,000"},{"v":7872000,"d":"7,872,000"}]
[10,{"v":99000000,"d":"99,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":112800000,"d":"112,800,000"},{"v":1485000,"d":"1,485,000"},{"v":297000,"d":"297,000"},{"v":1782000,"d":"1,782,000"},{"v":7782000,"d":"7,782,000"}]
[11,{"v":94000000,"d":"94,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":106800000,"d":"106,800,000"},{"v":1410000,"d":"1,410,000"},{"v":282000,"d":"282,000"},{"v":1692000,"d":"1,692,000"},{"v":7692000,"d":"7,692,000"}]
[12,{"v":89000000,"d":"89,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":100800000,"d":"100,800,000"},{"v":1335000,"d":"1,335,000"},{"v":267000,"d":"267,000"},{"v":1602000,"d":"1,602,000"},{"v":7602000,"d":"7,602,000"}]
[13,{"v":84000000,"d":"84,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":94800000,"d":"94,800,000"},{"v":1260000,"d":"1,260,000"},{"v":252000,"d":"252,000"},{"v":1512000,"d":"1,512,000"},{"v":7512000,"d":"7,512,000"}]
[14,{"v":79000000,"d":"79,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":88800000,"d":"88,800,000"},{"v":1185000,"d":"1,185,000"},{"v":237000,"d":"237,000"},{"v":1422000,"d":"1,422,000"},{"v":7422000,"d":"7,422,000"}]
[15,{"v":74000000,"d":"74,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":82800000,"d":"82,800,000"},{"v":1110000,"d":"1,110,000"},{"v":222000,"d":"222,000"},{"v":1332000,"d":"1,332,000"},{"v":7332000,"d":"7,332,000"}]
[16,{"v":69000000,"d":"69,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":76800000,"d":"76,800,000"},{"v":1035000,"d":"1,035,000"},{"v":207000,"d":"207,000"},{"v":1242000,"d":"1,242,000"},{"v":7242000,"d":"7,242,000"}]
[17,{"v":64000000,"d":"64,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":70800000,"d":"70,800,000"},{"v":960000,"d":"960,000"},{"v":192000,"d":"192,000"},{"v":1152000,"d":"1,152,000"},{"v":7152000,"d":"7,152,000"}]
[18,{"v":59000000,"d":"59,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":64800000,"d":"64,800,000"},{"v":885000,"d":"885,000"},{"v":177000,"d":"177,000"},{"v":1062000,"d":"1,062,000"},{"v":7062000,"d":"7,062,000"}]
[19,{"v":54000000,"d":"54,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":58800000,"d":"58,800,000"},{"v":810000,"d":"810,000"},{"v":162000,"d":"162,000"},{"v":972000,"d":"972,000"},{"v":6972000,"d":"6,972,000"}]
[20,{"v":49000000,"d":"49,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":52800000,"d":"52,800,000"},{"v":735000,"d":"735,000"},{"v":147000,"d":"147,000"},{"v":882000,"d":"882,000"},{"v":6882000,"d":"6,882,000"}]
[21,{"v":44000000,"d":"44,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":46800000,"d":"46,800,000"},{"v":660000,"d":"660,000"},{"v":132000,"d":"132,000"},{"v":792000,"d":"792,000"},{"v":6792000,"d":"6,792,000"}]
[22,{"v":39000000,"d":"39,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":40800000,"d":"40,800,000"},{"v":585000,"d":"585,000"},{"v":117000,"d":"117,000"},{"v":702000,"d":"702,000"},{"v":6702000,"d":"6,702,000"}]
[23,{"v":34000000,"d":"34,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":34800000,"d":"34,800,000"},{"v":510000,"d":"510,000"},{"v":102000,"d":"102,000"},{"v":612000,"d":"612,000"},{"v":6612000,"d":"6,612,000"}]
[24,{"v":29000000,"d":"29,000,000"},{"v":5000000,"d":"5,000,000"},{"v":1000000,"d":"1,000,000"},{"v":6000000,"d":"6,000,000"},{"v":28800000,"d":"28,800,000"},{"v":435000,"d":"435,000"},{"v":87000,"d":"87,000"},{"v":522000,"d":"522,000"},{"v":6522000,"d":"6,522,000"}]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
[{"$f":"IF(A81>=$I$7,\"\",A81+1)","v":""},{"$f":"IF(A82=\"\",\"\",B81-C81)","v":""},"","","",{"$f":"IF(A82=\"\",\"\",F81-E82)","v":""},{"$f":"IF(A82=\"\",\"\",F81*$I$6/100/12)","v":""},"","",{"$f":"IF(A82=\"\",\"\",E82+I82)","v":""}]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",{"$f":"IF(A103=\"\",\"\",E103+I103)","v":""}]
["","","","","","","","","",{"$f":"IF(A104=\"\",\"\",E104+I104)","v":""}]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","",{"$f":"IF(A123=\"\",\"\",($I$3*(100-$I$8-$I$9)/100)/($I$7))","v":""},{"$f":"IF(A123=\"\",\"\",C123*$I$4/100)","v":""},{"$f":"IF(A123=\"\",\"\",D123+C123)","v":""},"","",{"$f":"IF(A123=\"\",\"\",G123*$I$4/100)","v":""},{"$f":"IF(A123=\"\",\"\",G123+H123)","v":""},""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["","","","","","","","","",""]
["Итого",null,{"$f":"SUM(C14:C135)","v":{"v":136000000,"d":"136,000,000"}},{"$f":"SUM(D14:D135)","v":{"v":27200000,"d":"27,200,000"}},{"$f":"SUM(E14:E135)","v":{"v":163200000,"d":"163,200,000"}},null,{"$f":"SUM(G16:G135)","v":{"v":31140000,"d":"31,140,000"}},null,{"$f":"SUM(I16:I135)","v":{"v":37368000,"d":"37,368,000"}},{"$f":"SUM(J14:J135)","v":{"v":200568000,"d":"200,568,000"}}]
["Выкупная стоимость",null,{"$f":"I3*I9/100","v":{"v":24000000,"d":"24,000,000"}},{"$f":"C137*I4/100","v":{"v":4800000,"d":"4,800,000"}},{"$f":"C137+D137","v":{"v":28800000,"d":"28,800,000"}},{"$nulls":4},{"$f":"C137+D137","v":{"v":28800000,"d":"28,800,000"}}]