{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["ЧПС и Анализ чувств."],"not_rendered":{"charts":7,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"ЧПС и Анализ чувств.","index":0,"n_rows":233,"n_cols":16,"rows_kept":233,"merged":[[16,0,16,7],[17,2,17,7]],"flags":["formulas_cached_only"]}
[{"v":0.11,"d":"11%"},"WACC"]
[{"v":0.03,"d":"3%"},"Рисковая премия проекта"]
[{"v":0.14,"d":"14%"},"Ставка дисконтирования","Стоимость капитала + рисковая премия проекта (рискованнее на 3%, чем риск компании)"]
[{"v":3,"d":"$3.0"},"Цена за единицу"]
[{"v":20000,"d":"20,000"},"Объем продаж первого года, тыс.ед. в год"]
[{"v":0.06,"d":"6%"},"Годовой рост продаж и переменных затрат, начиная со 2-го года   "]
[{"v":0.08,"d":"8%"},"Потребность в оборотном капитале от объема продаж "]
[{"v":2.1,"d":"$2.1"},"Переменные (прямые) затраты на единицу продукции"]
[{"v":6000,"d":"$6,000"},"Постоянные затраты в год, тыс. "]
[{"v":20000,"d":"$20,000"},"Капиталовложения (оборудование период амортизации 6 лет), тыс. "]
[{"v":3333.3333333333335,"d":"$3,333"},"Амортизация, тыс. "]
[{"v":0.4,"d":"40%"},"Ставка налога наприбыль"]
[{"v":0.03,"d":"3%"},"Инфляция на продажи"]
[{"v":0.03,"d":"3%"},"Инфляция на переменные затраты"]
[{"v":0.02,"d":"2%"},"Инфляция на постоянные затраты"]
[]
["План денежных потоков бизнес-проекта"]
[null,null,"Годы"]
[null,null,2011,2012,2013,2014,2015,2016]
[null,"Операционная деятельность"]
[null,"Производство товаров, тыс.ед.",null,{"v":20000,"d":"20,000"},{"v":21200,"d":"21,200"},{"v":22472,"d":"22,472"},{"v":23820.32,"d":"23,820"},{"v":25249.5392,"d":"25,250"}]
[null,"Цена за единицу с учетом инфляции",null,{"v":3,"d":"3.00"},3.09,{"v":3.1827,"d":"3.18"},{"v":3.278181,"d":"3.28"},{"v":3.37652643,"d":"3.38"}]
[null," Продажи",null,{"v":60000,"d":"60,000"},{"v":65508,"d":"65,508"},{"v":71521.6344,"d":"71,522"},{"v":78087.32043792,"d":"78,087"},{"v":85255.73645412106,"d":"85,256"}]
[null,"    Переменные затраты на единицу",null,{"v":2.1,"d":"2.10"},{"v":2.1630000000000003,"d":"2.16"},{"v":2.2278900000000004,"d":"2.23"},{"v":2.2947267000000005,"d":"2.29"},{"v":2.3635685010000005,"d":"2.36"}]
[null,"    Общие переменные затраты ",null,{"v":42000,"d":"42,000"},{"v":45855.600000000006,"d":"45,856"},{"v":50065.144080000005,"d":"50,065"},{"v":54661.12430654401,"d":"54,661"},{"v":59679.01551788475,"d":"59,679"}]
[null,"    Постоянные затраты",null,{"v":6000,"d":"6,000"},{"v":6120,"d":"6,120"},{"v":6242.400000000001,"d":"6,242"},{"v":6367.2480000000005,"d":"6,367"},{"v":6494.592960000001,"d":"6,495"}]
[null,"  EBITDA",null,{"v":12000,"d":"12,000"},{"v":13532.399999999994,"d":"13,532"},{"v":15214.090319999988,"d":"15,214"},{"v":17058.948131375997,"d":"17,059"},{"v":19082.127976236305,"d":"19,082"}]
[null,"     Амортизация ",null,{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"}]
[null,"  EBIT",null,{"v":8666.666666666666,"d":"8,667"},{"v":10199.06666666666,"d":"10,199"},{"v":11880.756986666654,"d":"11,881"},{"v":13725.614798042663,"d":"13,726"},{"v":15748.79464290297,"d":"15,749"}]
[null,"     Проценты по кредиту",null,{"v":1000,"d":"1,000"},600,600]
[null,"  Прибыль до налога",null,{"v":7666.666666666666,"d":"7,667"},{"v":9599.06666666666,"d":"9,599"},{"v":11280.756986666654,"d":"11,281"},{"v":13725.614798042663,"d":"13,726"},{"v":15748.79464290297,"d":"15,749"}]
[null,"     Налог на прибыль",null,{"v":3066.6666666666665,"d":"3,067"},{"v":3839.6266666666643,"d":"3,840"},{"v":4512.302794666662,"d":"4,512"},{"v":5490.245919217065,"d":"5,490"},{"v":6299.517857161189,"d":"6,300"}]
[null,"  Прибыль после налога",null,{"v":4600,"d":"4,600"},{"v":5759.439999999996,"d":"5,759"},{"v":6768.454191999993,"d":"6,768"},{"v":8235.368878825597,"d":"8,235"},{"v":9449.276785741782,"d":"9,449"}]
[null,"      Возврат амортизации",null,{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"},{"v":3333.3333333333335,"d":"3,333"}]
[null,"  Операционный денежный поток",null,{"v":7933.333333333334,"d":"7,933"},{"v":9092.773333333329,"d":"9,093"},{"v":10101.787525333326,"d":"10,102"},{"v":11568.70221215893,"d":"11,569"},{"v":12782.610119075116,"d":"12,783"}]
[null,"     Потребность в оборотном капитале",{"v":4800,"d":"4,800"},{"v":5240.64,"d":"5,241"},{"v":5721.7307519999995,"d":"5,722"},{"v":6246.9856350336,"d":"6,247"},{"v":6820.458916329684,"d":"6,820"},0]
[null,"     Приращение (инвестиции) оборотного капитала",{"v":-4800,"d":"-4,800"},{"v":-440.6400000000003,"d":"-441"},{"v":-481.09075199999916,"d":"-481"},{"v":-525.2548830336009,"d":"-525"},{"v":-573.4732812960838,"d":"-573"},{"v":6820.458916329684,"d":"6,820"}]
[null,"  Инвестиционная деятельность"]
[null,"    Оборудование",{"v":-20000,"d":"-20,000"}]
[null,"    Остаточная стоимость",{"$nulls":5},{"v":3333.333333333332,"d":"3,333"},{"v":149130.4513892097,"d":"149130"}]
[null,"Инвестиционный денежный поток",{"v":-24800,"d":"-24,800"},{"v":-440.6400000000003,"d":"-441"},{"v":-481.09075199999916,"d":"-481"},{"v":-525.2548830336009,"d":"-525"},{"v":-573.4732812960838,"d":"-573"},{"v":10153.792249663016,"d":"10,154"}]
[null,"Годы",0,1,2,3,4,5]
[null,"Чистый (полный) денежный поток",{"v":-24800,"d":"-24,800"},{"v":7492.693333333334,"d":"7,493"},{"v":8611.68258133333,"d":"8,612"},{"v":9576.532642299724,"d":"9,577"},{"v":10995.228930862846,"d":"10,995"},{"v":22936.402368738134,"d":"22,936"}]
[null,"Накопленный (нарастающим итогом) денежный поток",{"v":-24800,"d":"-24,800"},{"v":-17307.306666666667,"d":"-17,307"},{"v":-8695.624085333337,"d":"-8,696"},{"v":880.9085569663876,"d":"881"},{"v":11876.137487829234,"d":"11,876"},{"v":34812.53985656737,"d":"34,813"}]
[null,"Дисконтированный денежный поток",{"v":-24800,"d":"-24,800"},{"v":6572.538011695906,"d":"6,573"},{"v":6626.410111829277,"d":"6,626"},{"v":6463.886757531144,"d":"6,464"},{"v":6510.0581951340055,"d":"6,510"},{"v":11912.448663470828,"d":"11,912"},{"v":13285.341739661162,"d":"$13,285.3"}]
[null,"Накопленный дисконтированный денежный поток",{"v":-24800,"d":"-24,800"},{"v":-18227.461988304094,"d":"-18,227"},{"v":-11601.051876474816,"d":"-11,601"},{"v":-5137.165118943672,"d":"-5,137"},{"v":1372.8930761903339,"d":"1,373"},{"v":13285.341739661162,"d":"13,285"}]
[]
[null,"Интегральная эффективность капиталовложений"]
[null,"Капитальные затраты, $ тыс."]
[null,"Ставка дисконтирования",{"v":0.14,"d":"14%"}]
[null,"Чистая приведенная стоимость, NPV, $ тыс.",{"v":13285.341739661162,"d":"$13,285.3"},"Net Present Value"]
[null,"Период окупаемости без дисконтирования PbP, годы",{"v":2.9080138302797196,"d":"2.9"},"PayBackPeriod "]
[null,"Период окупаемости c дисконтированием DPbP, годы",{"v":3.789112011745684,"d":"3.8"},"Discounted PayBackPeriod "]
[null,"Рентабельность капиталовложений PI",{"v":1.5356992636960145,"d":"1.54"},"Profitability Index (относительный показатель по сравнению с ЧПС)"]
[null,"Внутренняя ставка доходности, IRR",{"v":0.30779654852835736,"d":"30.78%"},"Internal Rate of Return"]
[null,"MIRR",{"v":0.24212724151005394,"d":"24.21%"}]
[]
[null,"Годы",null,1,2,3,4,5]
[null,"Операционная рентабельность",{"v":0.0951038910894047,"d":"9.5%"},{"v":0.07666666666666666,"d":"7.7%"},{"v":0.08791964340233248,"d":"8.8%"},{"v":0.09463506040907803,"d":"9.5%"},{"v":0.10546358656746041,"d":"10.5%"},{"v":0.11083449840148589,"d":"11.1%"}]
[null,"Точка безубыточности (единиц продаж) BEP",null,{"v":6666.666666666667,"d":"6667"},{"v":6601.941747572819,"d":"6602"},{"v":6537.845225751723,"d":"6538"},{"v":6474.371000258989,"d":"6474"},{"v":6411.513029382687,"d":"6412"}]
[null,"Сколько нужно продать, чтобы не получить прибыли и убытка"]
[null,"Доля продаж безубыточности в общем объеме продаж",null,{"v":0.33333333333333337,"d":"33.3%"},{"v":0.31141234658362354,"d":"31.1%"},{"v":0.29093294881415643,"d":"29.1%"},{"v":0.271800336866129,"d":"27.2%"},{"v":0.25392594211710157,"d":"25.4%"}]
[null,"Анализ чувствительности по рентабельности"]
[null,"Цена",{"v":0.0951038910894047,"d":"9.5%"},"Ср.рентабельность"]
[{"v":0.4,"d":"40%"},4.199999999999999,{"v":0.23935992220671762,"d":"23.9%"}]
[{"v":0.2,"d":"20%"},3.5999999999999996,{"v":0.1792532425745039,"d":"17.9%"}]
[{"v":0,"d":"0%"},3,{"v":0.0951038910894047,"d":"9.5%"}]
[{"v":-0.2,"d":"-20%"},2.4000000000000004,{"v":-0.031120136138244013,"d":"-3.1%"}]
[{"v":-0.4,"d":"-40%"},1.7999999999999998,{"v":-0.24149351485099219,"d":"-24.1%"}]
[]
[]
[null,"Анализ чувствительности по NPV"]
[null,"Цена",{"v":13285.341739661162,"d":"$13,285.3"},"Продажи",{"v":13285.341739661162,"d":"$13,285.3"},"Темп роста продаж",{"v":13285.341739661162,"d":"$13,285.3"},"Прямые затраты",{"v":13285.341739661162,"d":"$13,285.3"},"Постоянные затраты",{"v":13285.341739661162,"d":"$13,285.3"},"Инвестиции",{"v":13285.341739661162,"d":"$13,285.3"},"Ставка",{"v":13285.341739661162,"d":"$13,285.3"}]
[{"v":0.4,"d":"40%"},4.199999999999999,{"v":70240.21165310757,"d":"70240"},28000,{"v":29613.436239304094,"d":"29613"},{"v":0.08399999999999999,"d":"8.4%"},{"v":15093.62415065615,"d":"15094"},{"v":2.94,"d":"2.940"},{"v":-27341.43367414234,"d":"-27341"},8400,{"v":8166.441404900717,"d":"8166"},28000,{"v":7808.809808865422,"d":"7809"},{"v":0.196,"d":"19.6%"},{"v":7829.541271040805,"d":"7830"}]
[{"v":0.3,"d":"30%"},3.9000000000000004,{"v":56001.494174745996,"d":"56001"},26000,{"v":25531.412614393368,"d":"25531"},{"v":0.078,"d":"7.8%"},{"v":14634.064836203339,"d":"14634"},{"v":2.7300000000000004,"d":"2.730"},{"v":-17184.739820691488,"d":"-17185"},7800,{"v":9446.166488590832,"d":"9446"},26000,{"v":9177.942791564361,"d":"9178"},{"v":0.18200000000000002,"d":"18.2%"},{"v":9076.00673359217,"d":"9076"}]
[{"v":0.2,"d":"20%"},3.5999999999999996,{"v":41762.77669638436,"d":"41763"},24000,{"v":21449.38898948262,"d":"21449"},{"v":0.072,"d":"7.2%"},{"v":14179.525622337758,"d":"14180"},{"v":2.52,"d":"2.520"},{"v":-7028.045967240589,"d":"-7028"},7200,{"v":10725.89157228094,"d":"10726"},24000,{"v":10547.075774263292,"d":"10547"},{"v":0.168,"d":"16.8%"},{"v":10396.885137486744,"d":"10397"}]
[{"v":0.1,"d":"10%"},3.3000000000000003,{"v":27524.059218022798,"d":"27524"},22000,{"v":17367.365364571902,"d":"17367"},{"v":0.066,"d":"6.6%"},{"v":13729.96502384587,"d":"13730"},{"v":2.3100000000000005,"d":"2.310"},{"v":3128.647886210256,"d":"3129"},{"v":6600.000000000001,"d":"6600"},{"v":12005.616655971047,"d":"12006"},22000,{"v":11916.208756962224,"d":"11916"},{"v":0.15400000000000003,"d":"15.4%"},{"v":11797.908511863017,"d":"11798"}]
[{"v":0,"d":"0%"},3,{"v":13285.341739661162,"d":"13285"},20000,{"v":13285.341739661162,"d":"13285"},{"v":0.06,"d":"6.0%"},{"v":13285.341739661162,"d":"13285"},{"v":2.1,"d":"2.100"},{"v":13285.341739661162,"d":"13285"},6000,{"v":13285.341739661162,"d":"13285"},20000,{"v":13285.341739661162,"d":"13285"},{"v":0.14,"d":"14.0%"},{"v":13285.341739661162,"d":"13285"}]
[{"v":-0.1,"d":"-10%"},2.7,{"v":-953.3757387004443,"d":"-953"},18000,{"v":9203.31811475043,"d":"9203"},{"v":0.054,"d":"5.4%"},{"v":12845.614652864067,"d":"12846"},{"v":1.8900000000000001,"d":"1.890"},{"v":23442.03559311205,"d":"23442"},5400,{"v":14565.066823351277,"d":"14565"},18000,{"v":14654.474722360093,"d":"14654"},{"v":0.12600000000000003,"d":"12.6%"},{"v":14866.040325003,"d":"14866"}]
[{"v":-0.2,"d":"-20%"},2.4000000000000004,{"v":-15192.09321706204,"d":"-15192"},16000,{"v":5121.294489839696,"d":"5121"},{"v":0.048,"d":"4.8%"},{"v":12410.742830682007,"d":"12411"},{"v":1.6800000000000002,"d":"1.680"},{"v":33598.729446562924,"d":"33599"},4800,{"v":15844.791907041385,"d":"15845"},16000,{"v":16023.607705059032,"d":"16024"},{"v":0.11200000000000002,"d":"11.2%"},{"v":16547.51531046997,"d":"16548"}]
[{"v":-0.3,"d":"-30%"},2.0999999999999996,{"v":-29430.810695423672,"d":"-29431"},14000,{"v":1039.2708649289634,"d":"1039"},{"v":0.041999999999999996,"d":"4.2%"},{"v":11980.685524489338,"d":"11981"},{"v":1.47,"d":"1.470"},{"v":43755.423300013805,"d":"43755"},4200,{"v":17124.5169907315,"d":"17125"},14000,{"v":17392.740687757963,"d":"17393"},{"v":0.098,"d":"9.8%"},{"v":18338.00633978204,"d":"18338"}]
[{"v":-0.4,"d":"-40%"},1.7999999999999998,{"v":-43669.528173785286,"d":"-43670"},12000,{"v":-3042.7527599817695,"d":"-3043"},{"v":0.036,"d":"3.6%"},{"v":11555.402169807407,"d":"11555"},{"v":1.26,"d":"1.260"},{"v":53912.11715346467,"d":"53912"},3600,{"v":18404.2420744216,"d":"18404"},12000,{"v":18761.873670456895,"d":"18762"},{"v":0.084,"d":"8.4%"},{"v":20246.564015592885,"d":"20247"}]
[]
[null,"Цена","Продажи","Темп роста продаж","Прямые затраты","Постоянные затраты","Инвестиции","Ставка"]
[0.4,{"v":70240.21165310757,"d":"70240.2"},{"v":29613.436239304094,"d":"29613.4"},{"v":15093.62415065615,"d":"15093.6"},{"v":-27341.43367414234,"d":"-27341.4"},{"v":8166.441404900717,"d":"8166.4"},{"v":7808.809808865422,"d":"7808.8"},{"v":7829.541271040805,"d":"7829.5"}]
[0.3,{"v":56001.494174745996,"d":"56001.5"},{"v":25531.412614393368,"d":"25531.4"},{"v":14634.064836203339,"d":"14634.1"},{"v":-17184.739820691488,"d":"-17184.7"},{"v":9446.166488590832,"d":"9446.2"},{"v":9177.942791564361,"d":"9177.9"},{"v":9076.006733592163,"d":"9076.0"}]
[0.2,{"v":41762.77669638436,"d":"41762.8"},{"v":21449.38898948262,"d":"21449.4"},{"v":14179.525622337758,"d":"14179.5"},{"v":-7028.045967240589,"d":"-7028.0"},{"v":10725.89157228094,"d":"10725.9"},{"v":10547.075774263292,"d":"10547.1"},{"v":10396.885137486737,"d":"10396.9"}]
[0.1,{"v":27524.059218022798,"d":"27524.1"},{"v":17367.365364571895,"d":"17367.4"},{"v":13729.96502384587,"d":"13730.0"},{"v":3128.647886210256,"d":"3128.6"},{"v":12005.616655971047,"d":"12005.6"},{"v":11916.208756962224,"d":"11916.2"},{"v":11797.908511863017,"d":"11797.9"}]
[0,{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"},{"v":13285.341739661162,"d":"13285.3"}]
[-0.1,{"v":-953.3757387004443,"d":"-953.4"},{"v":9203.31811475043,"d":"9203.3"},{"v":12845.614652864067,"d":"12845.6"},{"v":23442.03559311205,"d":"23442.0"},{"v":14565.066823351277,"d":"14565.1"},{"v":14654.474722360093,"d":"14654.5"},{"v":14866.040325003,"d":"14866.0"}]
[-0.2,{"v":-15192.093217062038,"d":"-15192.1"},{"v":5121.294489839696,"d":"5121.3"},{"v":12410.742830682007,"d":"12410.7"},{"v":33598.729446562924,"d":"33598.7"},{"v":15844.791907041385,"d":"15844.8"},{"v":16023.607705059032,"d":"16023.6"},{"v":16547.51531046997,"d":"16547.5"}]
[-0.3,{"v":-29430.810695423672,"d":"-29430.8"},{"v":1039.2708649289634,"d":"1039.3"},{"v":11980.685524489338,"d":"11980.7"},{"v":43755.423300013805,"d":"43755.4"},{"v":17124.5169907315,"d":"17124.5"},{"v":17392.740687757963,"d":"17392.7"},{"v":18338.00633978204,"d":"18338.0"}]
[-0.4,{"v":-43669.528173785286,"d":"-43669.5"},{"v":-3042.7527599817695,"d":"-3042.8"},{"v":11555.402169807407,"d":"11555.4"},{"v":53912.11715346467,"d":"53912.1"},{"v":18404.242074421607,"d":"18404.2"},{"v":18761.873670456895,"d":"18761.9"},{"v":20246.564015592885,"d":"20246.6"}]
{"$rows_empty":12}
[{"$nulls":12},0.5173913043478261]
{"$rows_empty":80}
[null,"Задача по данным Игоря"]
[{"v":0.011666666666666667,"d":"1%"}]
[{"v":0.14,"d":"14%"},"Ставка дисконтирования"]
[{"v":12.5,"d":"12.500"},"Цена за единицу, тыс.руб."]
[16,"Объем продаж в месяц ед. ",192]
[{"v":0.05,"d":"5%"},"Потребность в оборотном капитале от объема продаж "]
[4,"Переменные (прямые) затраты на единицу продукции, тыс.руб."]
[130,"Постоянные затраты в мес.(первые два), тыс. ",1060]
[80,"Постоянные затраты в мес.(с третьего), тыс. "]
[60,"Капиталовложения (оборудование период амортизации 4 лет), тыс. "]
[250,"Другие затраты инвест. периода"]
[1.25,"Амортизация в мес.,тыс. руб.",15]
[{"v":0.2,"d":"20%"},"Ставка налога на прибыль"]
[null,"Инфляция на продажи"]
[null,"Инфляция на переменные затраты"]
[null,"Инфляция на постоянные затраты"]
[]
[null,"Месяцы",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null," Продажи",null,200,200,200,200,200,200,200,200,200,200,200,200]
[null,"    Общие переменные затраты ",null,64,64,64,64,64,64,64,64,64,64,64,64]
[null,"    Постоянные затраты",null,130,130,80,80,80,80,80,80,80,80,80,80]
[null,"  EBITDA",null,6,6,56,56,56,56,56,56,56,56,56,56]
[null,"     Амортизация ",null,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25,1.25]
[null,"  EBIT",null,4.75,4.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75]
[null,"     Проценты по кредиту",null,0]
[null,"  Прибыль до налога",null,4.75,4.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75,54.75]
[null,"     Налог на прибыль",null,0.9500000000000001,0.9500000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001,10.950000000000001]
[null,"  Прибыль после налога",null,3.8,3.8,43.8,43.8,43.8,43.8,43.8,43.8,43.8,43.8,43.8,43.8]
[null,"      Возврат амортизации"]
[null,"  Операционный денежный поток",null,5.05,5.05,45.05,45.05,45.05,45.05,45.05,45.05,45.05,45.05,45.05,45.05]
[null,"     Потребность в оборотном капитале",10,10,10,10,10,10,10,10,10,10,10,10,0]
[null,"     Приращение (инвестиции) оборотного капитала",-10,0,0,0,0,0,0,0,0,0,0,0,10]
[null,"  Инвестиционная деятельность",-310,{"$nulls":11},45]
[null,"    Остаточная стоимость"]
[null,"Инвестиционный денежный поток",-320,0,0,0,0,0,0,0,0,0,0,0,55]
[null,"Годы",0,1,2,3,4,5,6,7,8,9,10,11,12]
[null,"Чистый (полный) денежный поток",-320,{"v":5.05,"d":"5.1"},{"v":5.05,"d":"5.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":45.05,"d":"45.1"},{"v":100.05,"d":"100.1"}]
[null,"Накопленный (нарастающим итогом) денежный поток",-320,{"v":-314.95,"d":"-315.0"},-309.9,{"v":-264.84999999999997,"d":"-264.9"},{"v":-219.79999999999995,"d":"-219.8"},{"v":-174.74999999999994,"d":"-174.8"},{"v":-129.69999999999993,"d":"-129.7"},{"v":-84.64999999999993,"d":"-84.6"},{"v":-39.59999999999994,"d":"-39.6"},{"v":5.45000000000006,"d":"5.5"},{"v":50.50000000000006,"d":"50.5"},{"v":95.55000000000005,"d":"95.6"},{"v":195.60000000000005,"d":"195.6"}]
[null,"Дисконтированный денежный поток",null,{"v":4.991762767710049,"d":"5.0"},{"v":4.934197134474513,"d":"4.9"},{"v":43.50933777377659,"d":"43.5"},{"v":43.00758264294226,"d":"43.0"},{"v":42.51161381509944,"d":"42.5"},{"v":42.021364561877526,"d":"42.0"},{"v":41.53676892442589,"d":"41.5"},{"v":41.057761704539594,"d":"41.1"},{"v":40.58427845588757,"d":"40.6"},{"v":40.116255475341916,"d":"40.1"},{"v":39.65362979440716,"d":"39.7"},{"v":87.04980541694518,"d":"87.0"}]
[null,"Накопленный дисконтированный денежный поток",-320,{"v":-315.00823723228996,"d":"-315.0"},{"v":-310.07404009781544,"d":"-310.1"},{"v":-266.5647023240389,"d":"-266.6"},{"v":-223.55711968109662,"d":"-223.6"},{"v":-181.0455058659972,"d":"-181.0"},{"v":-139.02414130411967,"d":"-139.0"},{"v":-97.48737237969377,"d":"-97.5"},{"v":-56.42961067515417,"d":"-56.4"},{"v":-15.845332219266602,"d":"-15.8"},{"v":24.270923256075314,"d":"24.3"},{"v":63.92455305048247,"d":"63.9"},{"v":150.97435846742763,"d":"151.0"},"NPV"]
[]
[]
[null,"Рентабельность продаж",null,{"v":0.019,"d":"1.9%"},{"v":0.019,"d":"1.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"},{"v":0.21899999999999997,"d":"21.9%"}]
[]
[]
[{"$nulls":11},8.879023307436182]
[{"$nulls":11},10.26565541709943]