{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Статистика","Ввод параметров","Основная Информация","Сравнение со средним","Подробный Финансовый расчёт"],"not_rendered":{"charts":8,"images":4,"macros":1,"external_links":0,"defined_names":0,"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":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Статистика"]

{"sheet":"Ввод параметров","index":1,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":false,"merged":[[21,9,21,14],[23,9,37,14],[22,9,22,14],[3,1,3,7],[62,1,74,7],[7,5,7,6],[22,1,22,7],[6,2,6,3],[21,1,21,7],[23,1,37,7],[3,9,3,12]]}
[]
[null,"Ввод параметров"]
[]
[null,"Магазин разливных напитков \"Разливнович\"",null,null,null,null,null,null,null,"Чтобы просмотреть видео, кликните по картинке"]
[]
[null,null,null,null,null,null,null,null,null,"Финансовая модель магазина разливных напитков \"Разливнович\"\nДля подсчета прибыли введите в салатовые ячейки следующие параметры:\n1. Введите площадь помещения\n2. Введите ставку квадратного метра помещения\n3. Введите ставку 1 рабочей смены продавца\n4. Введите процент продавца (От ежедневной выручки)\n5. Введите процент рояли согласно выбранному пакету\n6. Введите количество планируемых кранов\n7. Введите количество наименований закусок\n8. Введите количество посетителей в день\nПрограмма моментально будет изменять отображаемые прогнозы по среднему расходам/доходам/чистой прибыли"]
[null,"Старт проекта","2019-01-01"]
[null,"Коэффицинт трезвости региона",32,"ед",null,"Раскачка продаж"]
[null,"Кол-во квартир в радиусе 500 м",2000,"Шт",null,"1-й месяц",0.2]
[null,"Помещение",28,"м2",null,"2-й месяц",0.3]
[null,"Аренда",700,"рублей/м2",null,"3-й месяц",0.4]
[null,"Заработная плата (Фикс)",800,"рублей",null,"4-й месяц",0.5]
[null,"Заработная плата (%)",3,"%",null,"5-й месяц",0.6]
[null,"Количество кранов",25,"шт",null,"6-й месяц",0.7]
[null,"Наименований закусок",60,"шт",null,"7-й месяц",0.8]
[null,"Роялти",3,"%",null,"8-й месяц",0.9]
[null,"Налоговая ставка (УСН)",6,"%",null,"9-й месяц",1]
[null,"Минимальная стоимость литра",75,"рублей",null,"10-й месяц",1]
[null,"Максимальная стоимость литра",135,"рублей",null,"11-й месяц",1]
[null,"Доля рынка",6,"%",null,"12-й месяц",1]
[]
[null,"Чтобы отобразить, нажмите ниже",null,null,null,null,null,null,null,"Чтобы отобразить, нажмите ниже"]
[null,"Терминология\n\n\n",null,null,null,null,null,null,null,"ОПИСАНИЕ МОДЕЛИ МАГАЗИНА"]
[null,"1. Средний чек - сколько в среднем человек отдает денег за разовую покупку\n2. Выручка - сумма всех денег поступивших с покупок\n3. Рентабельность - показатель экономической эффективности\n4. Роялти - обязательный платеж в УК (Взимается с выручки)\n5. Товарный остаток - сумма, оплачиваемая поставщикам за продукты/товары\n6. ФОТ - фонд оплаты труда (Заработная плата)\n7. Аренда - ежемесячный платеж за помещение\n8. Налоги - обязательные отчисления государству\n9. Чистая прибыль - сумма денег, остающаяся на руках в свободное пользование у владельца бизнеса",null,null,null,null,null,null,null,"Финансовая модель магазина разливных напитков \"Разливнович\"\nДля подсчета прибыли введите в салатовые ячейки следующие параметры:\n1. Введите площадь помещения\n2. Введите ставку квадратного метра помещения\n3. Введите ставку 1 рабочей смены продавца\n4. Введите процент продавца (От ежедневной выручки)\n5. Введите процент рояли согласно выбранному пакету\n6. Введите количество планируемых кранов\n7. Введите количество наименований закусок\n8. Введите количество посетителей в день\nПрограмма моментально будет изменять отображаемые прогнозы по среднему расходам/доходам/чистой прибыли"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Терминология\n\n1. Средний чек - сколько в среднем человек отдает денег за разовую покупку\n2. Выручка - сумма всех денег поступивших с покупок\n3. Рентабельность - показатель экономической эффективности\n4. Роялти - обязательный платеж в УК (Взимается с выручки)\n5. Товарный остаток - сумма, оплачиваемая поставщикам за продукты/товары\n6. ФОТ - фонд оплаты труда (Заработная плата)\n7. Аренда - ежемесячный платеж за помещение\n8. Налоги - обязательные отчисления государству\n9. Чистая прибыль - сумма денег, остающаяся на руках в свободное пользование у владельца бизнеса\n"]

{"sheet":"Основная Информация","index":2,"n_rows":77,"n_cols":8,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Отчёт по основным финансовым показателям"]
[]
[null,"Окупаемость проекта",{"$f":"'Подробный Финансовый расчёт'!C34&\" месяцев\"","v":"9 месяцев"}]
[]
[null,"Период\\Показатель","Выручка","Закупка","Зарплата","Аренда","Чистая выручка","Денежный поток накопительно"]
[null,"1-й месяц",{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$11:$P$11)","v":95463.529411764714},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$18:$P$18)","v":-57278.117647058825},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$19:$P$19)","v":-38319.529411764706},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$20:$P$20)","v":-19600},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$30:$P$30)","v":-518250.07058823528},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$31:$P$31)","v":-518250.07058823528}]
[null,"2-й месяц",143195.29411764705,-85917.176470588223,-38319.529411764706,-19600,-302.92705882352129,-518552.9976470588]
[null,"3-й месяц",190927.05882352943,-114556.23529411765,-38319.529411764706,-19600,12260.073411764708,-506292.92423529411]
[null,"4-й месяц",238658.82352941178,-143195.29411764705,-38319.529411764706,-19600,28861.181176470618,-477431.74305882351]
[null,"5-й месяц",286390.5882352941,-171834.35294117645,-38319.529411764706,-19600,45462.28894117647,-431969.45411764702]
[null,"6-й месяц",334122.35294117645,-200473.41176470587,-38319.529411764706,-19600,62063.396705882355,-369906.05741176469]
[null,"7-й месяц",381854.11764705885,-229112.4705882353,-38319.529411764706,-19600,78664.504470588232,-291241.55294117646]
[null,"8-й месяц",429585.8823529412,-257751.5294117647,-38319.529411764706,-19600,95265.612235294175,-195975.94070588227]
[null,"9-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,-84109.220705882224]
[null,"10-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,27757.499294117821]
[null,"11-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,139624.21929411788]
[null,"12-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,251490.93929411791]
[null,"Итого 1-й год",{"$f":"SUM(C7:C18)","v":4009468.2352941181},{"$f":"SUM(D7:D18)","v":-2405680.9411764699},-459834.35294117645,-235200,251490.93929411791,{"$f":"$H$18","v":251490.93929411791}]
[null,"13-й месяц",{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$11:$AB$11)","v":477317.64705882355},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$18:$AB$18)","v":-286390.5882352941},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$19:$AB$19)","v":-38319.529411764706},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$20:$AB$20)","v":-19600},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$30:$AB$30)","v":111866.72000000004},{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$31:$AB$31)","v":363357.65929411794}]
[null,"14-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,475224.37929411797]
[null,"15-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,587091.099294118]
[null,"16-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,698957.81929411809]
[null,"17-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,810824.53929411818]
[null,"18-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,922691.25929411827]
[null,"19-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1034557.9792941184]
[null,"20-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1146424.6992941184]
[null,"21-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1258291.4192941184]
[null,"22-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1370158.1392941184]
[null,"23-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1482024.8592941184]
[null,"24-й месяц",477317.64705882355,-286390.5882352941,-38319.529411764706,-19600,111866.72000000004,1593891.5792941183]
[null,"Итого 2-й год",{"$f":"SUM(C20:C31)","v":5727811.7647058815},{"$f":"SUM(D20:D31)","v":-3436687.0588235282},{"$f":"SUM(E20:E31)","v":-459834.35294117645},{"$f":"SUM(F20:F31)","v":-235200},{"$f":"SUM(G20:G31)","v":1342400.6400000006},{"$f":"$H$31","v":1593891.5792941183}]
[null,"Итого за 2 года",{"$f":"C32+C19","v":9737280},{"$f":"D32+D19","v":-5842367.9999999981},-919668.70588235289,-470400,1593891.5792941186,{"$f":"H32","v":1593891.5792941183}]
[]
[]
[]
[null,"Период","Маржинальность"]
[null,"1-й месяц",{"$f":"$G$7:$G$18/$C$7:$C$18","v":-5.4287755102040807}]
[null,"2-й месяц",-2.1154819415688413E-3]
[null,"3-й месяц",6.421338854382333E-2]
[null,"4-й месяц",0.12093071083505878]
[null,"5-й месяц",0.15874225902921557]
[null,"6-й месяц",0.18575050773932764]
[null,"7-й месяц",0.20600669427191165]
[null,"8-й месяц",0.22176150601947714]
[null,"9-й месяц",0.23436535541752943]
[null,"10-й месяц",0.23436535541752943]
[null,"11-й месяц",0.23436535541752943]
[null,"12-й месяц",0.23436535541752943]
[]
[null,{"$f":"B37","v":"Период"},{"$f":"C6","v":"Выручка"}]
[null,"1-й месяц",95463.529411764714]
[null,"2-й месяц",143195.29411764705]
[null,"3-й месяц",190927.05882352943]
[null,"4-й месяц",238658.82352941178]
[null,"5-й месяц",286390.5882352941]
[null,"6-й месяц",334122.35294117645]
[null,"7-й месяц",381854.11764705885]
[null,"8-й месяц",429585.8823529412]
[null,"9-й месяц",477317.64705882355]
[null,"10-й месяц",477317.64705882355]
[null,"11-й месяц",477317.64705882355]
[null,"12-й месяц",477317.64705882355]
[]
[null,{"$f":"B51","v":"Период"},{"$f":"G6","v":"Чистая выручка"}]
[null,{"$f":"B7","v":"1-й месяц"},{"$f":"G7","v":-518250.07058823528}]
[null,"2-й месяц",-302.92705882352129]
[null,"3-й месяц",12260.073411764708]
[null,"4-й месяц",28861.181176470618]
[null,"5-й месяц",45462.28894117647]
[null,"6-й месяц",62063.396705882355]
[null,"7-й месяц",78664.504470588232]
[null,"8-й месяц",95265.612235294175]
[null,"9-й месяц",111866.72000000004]
[null,"10-й месяц",111866.72000000004]
[null,"11-й месяц",111866.72000000004]
[null,"12-й месяц",111866.72000000004]

{"sheet":"Сравнение со средним","index":3,"n_rows":95,"n_cols":8,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Сравнение со среднестатестической точкой"]
[]
[null,"Окупаемость проекта",{"$f":"'Подробный Финансовый расчёт'!C34&\" месяцев\"","v":"9 месяцев"}]
[null,"Средняя окупаемость","12 месяцев"]
[]
[null,"Проект","Текущий","Средний","Текущий","Средний","Текущий","Средний"]
[null,"Период\\Показатель","Выручка","Выручка","Чистая выручка","Чистая выручка","Денежный поток накопительно","Денежный поток накопительно"]
[null,"1-й месяц",{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$11:$P$11)","v":95463.529411764714},35798.823529411769,{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$30:$P$30)","v":-518250.07058823528},-537318.91058823525,{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$E$31:$P$31)","v":-518250.07058823528},-537318.91058823525]
[null,"2-й месяц",143195.29411764705,71597.647058823539,-302.92705882352129,-23858.552941176462,-518552.9976470588,-561177.4635294117]
[null,"3-й месяц",190927.05882352943,107396.47058823529,12260.073411764708,-13426.775764705879,-506292.92423529411,-574604.23929411755]
[null,"4-й месяц",238658.82352941178,143195.29411764708,28861.181176470618,-975.94494117646718,-477431.74305882351,-575580.184235294]
[null,"5-й месяц",286390.5882352941,178994.11764705883,45462.28894117647,11474.885882352957,-431969.45411764702,-564105.29835294106]
[null,"6-й месяц",334122.35294117645,214792.94117647057,62063.396705882355,23925.716705882354,-369906.05741176469,-540179.58164705872]
[null,"7-й месяц",381854.11764705885,286390.58823529416,78664.504470588232,48827.378352941203,-291241.55294117646,-491352.20329411753]
[null,"8-й месяц",429585.8823529412,322189.4117647059,95265.612235294175,61278.209176470627,-195975.94070588227,-430073.99411764689]
[null,"9-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,-84109.220705882224,-356344.95411764685]
[null,"10-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,27757.499294117821,-282615.91411764681]
[null,"11-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,139624.21929411788,-208886.87411764677]
[null,"12-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,251490.93929411791,-135157.83411764674]
[null,"Итого 1-й год",{"$f":"SUM(C9:C20)","v":4009468.2352941181},2792308.2352941176,{"$f":"SUM(E9:E20)","v":251490.93929411791},-135157.83411764674,{"$f":"$G$20","v":251490.93929411791},-135157.83411764674]
[null,"13-й месяц",{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$11:$AB$11)","v":477317.64705882355},357988.23529411765,{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$30:$AB$30)","v":111866.72000000004},73729.040000000052,{"$f":"TRANSPOSE('Подробный Финансовый расчёт'!$Q$31:$AB$31)","v":363357.65929411794},-61428.794117646685]
[null,"14-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,475224.37929411797,12300.245882353367]
[null,"15-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,587091.099294118,86029.285882353419]
[null,"16-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,698957.81929411809,159758.32588235347]
[null,"17-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,810824.53929411818,233487.36588235351]
[null,"18-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,922691.25929411827,307216.40588235355]
[null,"19-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1034557.9792941184,380945.44588235358]
[null,"20-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1146424.6992941184,454674.48588235362]
[null,"21-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1258291.4192941184,528403.52588235366]
[null,"22-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1370158.1392941184,602132.56588235369]
[null,"23-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1482024.8592941184,675861.60588235373]
[null,"24-й месяц",477317.64705882355,357988.23529411765,111866.72000000004,73729.040000000052,1593891.5792941183,749590.64588235377]
[null,"Итого 2-й год",{"$f":"SUM(C22:C33)","v":5727811.7647058815},4295858.823529412,{"$f":"SUM(E22:E33)","v":1342400.6400000006},884748.48000000056,{"$f":"$H$33","v":749590.64588235377},749590.64588235377]
[null,"Итого за 2 года",{"$f":"C34+C21","v":9737280},7088167.0588235296,{"$f":"E34+E21","v":1593891.5792941186},749590.64588235389,{"$f":"G34","v":749590.64588235377},749590.64588235377]
[]
[]
[null,"Маржинальность","Текущий проект","Средний проект"]
[null,"2-й месяц",{"$f":"$E$10:$E$20/$C$10:$C$20","v":-2.1154819415688413E-3},{"$f":"$F$10:$F$20/$D$10:$D$20","v":-0.33323096388313761}]
[null,"3-й месяц",6.421338854382333E-2,-0.1250206425887585]
[null,"4-й месяц",0.12093071083505878,-6.8154819415688732E-3]
[null,"5-й месяц",0.15874225902921557,6.4107614446744968E-2]
[null,"6-й месяц",0.18575050773932764,0.11138967870562075]
[null,"7-й месяц",0.20600669427191165,0.17049225902921561]
[null,"8-й месяц",0.22176150601947714,0.19019311913708059]
[null,"9-й месяц",0.23436535541752943,0.20595380722337259]
[null,"10-й месяц",0.23436535541752943,0.20595380722337259]
[null,"11-й месяц",0.23436535541752943,0.20595380722337259]
[null,"12-й месяц",0.23436535541752943,0.20595380722337259]
[]
[]
[null,"Выручка",{"$f":"C7","v":"Текущий"},"Средний"]
[null,{"$f":"B9","v":"1-й месяц"},95463.529411764714,35798.823529411769]
[null,"2-й месяц",143195.29411764705,71597.647058823539]
[null,"3-й месяц",190927.05882352943,107396.47058823529]
[null,"4-й месяц",238658.82352941178,143195.29411764708]
[null,"5-й месяц",286390.5882352941,178994.11764705883]
[null,"6-й месяц",334122.35294117645,214792.94117647057]
[null,"7-й месяц",381854.11764705885,286390.58823529416]
[null,"8-й месяц",429585.8823529412,322189.4117647059]
[null,"9-й месяц",477317.64705882355,357988.23529411765]
[null,"10-й месяц",477317.64705882355,357988.23529411765]
[null,"11-й месяц",477317.64705882355,357988.23529411765]
[null,"12-й месяц",477317.64705882355,357988.23529411765]
[]
[]
[]
[null,"Чистая выручка","Текущий","Средний"]
[null,"2-й месяц",{"$f":"E10","v":-302.92705882352129},{"$f":"F10","v":-23858.552941176462}]
[null,"3-й месяц",12260.073411764708,-13426.775764705879]
[null,"4-й месяц",28861.181176470618,-975.94494117646718]
[null,"5-й месяц",45462.28894117647,11474.885882352957]
[null,"6-й месяц",62063.396705882355,23925.716705882354]
[null,"7-й месяц",78664.504470588232,48827.378352941203]
[null,"8-й месяц",95265.612235294175,61278.209176470627]
[null,"9-й месяц",111866.72000000004,73729.040000000052]
[null,"10-й месяц",111866.72000000004,73729.040000000052]
[null,"11-й месяц",111866.72000000004,73729.040000000052]
[null,"12-й месяц",111866.72000000004,73729.040000000052]
[]
[]
[]
[null,"Денежный поток","Текущий","Средний"]
[null,"1-й месяц",-536197.21411764703,-537318.91058823525]
[null,"2-й месяц",-554447.28470588231,-561177.4635294117]
[null,"3-й месяц",-558788.31905882352,-574604.23929411755]
[null,"4-й месяц",-546528.24564705882,-575580.184235294]
[null,"5-й месяц",-517667.06447058823,-564105.29835294106]
[null,"6-й месяц",-472204.77552941174,-540179.58164705872]
[null,"7-й месяц",-393540.27105882351,-491352.20329411753]
[null,"8-й месяц",-298274.65882352932,-430073.99411764689]
[null,"9-й месяц",-186407.93882352929,-356344.95411764685]
[null,"10-й месяц",-74541.218823529241,-282615.91411764681]
[null,"11-й месяц",37325.501176470803,-208886.87411764677]
[null,"12-й месяц",149192.22117647086,-135157.83411764674]

{"sheet":"Подробный Финансовый расчёт","index":4,"n_rows":47,"n_cols":47,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
[null,null,{"$f":"MAX(2:2)","v":36},null,{"$f":"MONTH(E8)","v":1},{"$f":"MONTH(F8)","v":2},3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,10,11,12,1,2,3,4,5,6,7,8,9,{"$f":"MONTH(AL8)","v":10},11,12]
[null,null,null,null,1,{"$f":"E2+1","v":2},{"$f":"F2+1","v":3},4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,{"$f":"AK2+1","v":34},{"$f":"AL2+1","v":35},{"$f":"AM2+1","v":36}]
[null,null,null,null,{"$f":"\"Y\"&INT((E2-1)/12+1)","v":"Y1"},{"$f":"\"Y\"&INT((F2-1)/12+1)","v":"Y1"},"Y1","Y1","Y1","Y1","Y1","Y1","Y1","Y1","Y1","Y1","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y2","Y3","Y3","Y3","Y3","Y3","Y3","Y3","Y3","Y3",{"$f":"\"Y\"&INT((AL2-1)/12+1)","v":"Y3"},"Y3","Y3"]
[null,null,null,null,{"$f":"YEAR(E8)","v":2019},{"$f":"YEAR(F8)","v":2019},2019,2019,2019,2019,2019,2019,2019,2019,2019,2019,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2020,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,2021,null,null,null,{"$f":"AU4","v":36},{"$f":"OFFSET($E$2,0,MATCH(AT8,$E$3:$AN$3,0)-2,1,1)","v":12},{"$f":"AS4+12","v":24},{"$f":"AT4+12","v":36}]
[]
[null,"Подробный финансовый расчёт"]
[]
[null,"Старт проекта",null,null,{"$f":"'Ввод параметров'!C7","v":"2019-01-01"},{"$f":"EDATE(E8,1)","v":"2019-02-01"},{"$f":"EDATE(F8,1)","v":"2019-03-01"},"2019-04-01","2019-05-01","2019-06-01","2019-07-01","2019-08-01","2019-09-01","2019-10-01","2019-11-01","2019-12-01","2020-01-01","2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","2020-11-01","2020-12-01","2021-01-01","2021-02-01","2021-03-01","2021-04-01","2021-05-01","2021-06-01","2021-07-01","2021-08-01","2021-09-01",{"$f":"EDATE(AK8,1)","v":"2021-10-01"},{"$f":"EDATE(AL8,1)","v":"2021-11-01"},{"$f":"EDATE(AM8,1)","v":"2021-12-01"},null,null,null,"TOTAL",{"$f":"$E$3","v":"Y1"},{"$f":"\"Y2\"","v":"Y2"},{"$f":"\"Y3\"","v":"Y3"}]
[]
[null,"Раскачка продаж",null,null,{"$f":"TRANSPOSE('Ввод параметров'!$G$9:$G$20)","v":0.2},0.3,0.4,0.5,0.6,0.7,0.8,0.9,1,1,1,1,{"$f":"$P$10","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Выручка",{"$f":"$C$40","v":477317.64705882355},"тыс. Руб",{"$f":"$C$11*E10","v":95463.529411764714},143195.29411764705,190927.05882352943,238658.82352941178,286390.5882352941,334122.35294117645,381854.11764705885,429585.8823529412,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,null,null,null,{"$f":"SUM(AS11:AU11)","v":15465091.764705881},{"$f":"SUMIF($3:$3,AS$8,11:11)","v":4009468.2352941181},{"$f":"SUMIF($3:$3,AT$8,11:11)","v":5727811.7647058815},{"$f":"SUMIF($3:$3,AU$8,11:11)","v":5727811.7647058815}]
[]
[]
[null,"Выручка",null,"тыс. Руб",{"$f":"E11","v":95463.529411764714},{"$f":"F11","v":143195.29411764705},190927.05882352943,238658.82352941178,286390.5882352941,334122.35294117645,381854.11764705885,429585.8823529412,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,477317.64705882355,{"$f":"AL11","v":477317.64705882355},477317.64705882355,477317.64705882355,null,null,null,{"$f":"SUM(AS14:AU14)","v":15465091.764705881},{"$f":"SUMIF($3:$3,AS$8,14:14)","v":4009468.2352941181},{"$f":"SUMIF($3:$3,AT$8,14:14)","v":5727811.7647058815},{"$f":"SUMIF($3:$3,AU$8,14:14)","v":5727811.7647058815}]
[]
[null,"ОПЕРАЦИОННЫЕ ЗАТРАТЫ"]
[null,"Роялти",{"$f":"'Ввод параметров'!$C$16/100","v":0.03},"тыс. Руб",null,null,{"$f":"-G14*$C$17","v":-5727.8117647058825},-7159.7647058823532,-8591.717647058822,-10023.670588235293,-11455.623529411765,-12887.576470588236,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,-14319.529411764706,null,null,null,{"$f":"SUM(AS17:AU17)","v":-456792.988235294},{"$f":"SUMIF($3:$3,AS$8,17:17)","v":-113124.28235294114},-171834.35294117642,-171834.35294117642]
[null,"Закупка необходимых товаров",0.6,"тыс. Руб",{"$f":"-$C$18*E14","v":-57278.117647058825},-85917.176470588223,-114556.23529411765,-143195.29411764705,-171834.35294117645,-200473.41176470587,-229112.4705882353,-257751.5294117647,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,-286390.5882352941,null,null,null,-9279055.0588235259,-2405680.9411764699,-3436687.0588235282,-3436687.0588235282]
[null,"Зарплата сотрудникам",{"$f":"$C$44","v":38319.529411764706},"тыс. Руб",{"$f":"-$C$19","v":-38319.529411764706},-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,-38319.529411764706,null,null,null,-1379503.0588235294,-459834.35294117645,-459834.35294117645,-459834.35294117645]
[null,"Аренда",{"$f":"$C$45","v":19600},"тыс. Руб",{"$f":"-$C$20","v":-19600},-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,-19600,null,null,null,-705600,-235200,-235200,-235200]
[null,"ОПЕРАЦИОННЫЕ ЗАТРАТЫ",null,"тыс. Руб",{"$f":"SUM(E17:E20)","v":-115197.64705882352},{"$f":"SUM(F17:F20)","v":-143836.70588235292},-178203.57647058825,-208274.5882352941,-238345.59999999998,-268416.61176470586,-298487.62352941179,-328558.63529411762,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,-358629.6470588235,null,null,null,-11820951.105882354,-3213839.5764705883,-4303555.7647058824,-4303555.7647058824]
[null,"Аммортизация оборудования",60,"тыс. Руб",{"$f":"SUM(OFFSET(E27,0,0,1,-MIN($C22,E$2)))/$C22","v":-5000},-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,null,null,null,-180000,-60000,-60000,-60000]
[null,"Аммортизация оборудования",null,"тыс. Руб",{"$f":"SUM(E22:E22)","v":-5000},-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,-5000,{"$f":"SUM(AL22:AL22)","v":-5000},-5000,-5000,null,null,null,-180000,-60000,-60000,-60000]
[null,"Прибыль - убытки",null,"тыс. Руб",{"$f":"E14+E21+E23","v":-24734.117647058811},-5641.4117647058738,7723.4823529411806,25384.23529411768,43044.98823529412,60705.74117647059,78366.49411764706,96027.247058823588,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,113688.00000000006,null,null,null,3464140.6588235302,735628.65882352972,1364256.0000000002,1364256.0000000002]
[null,"Прибыль - убытки с учётом налогов",{"$f":"'Ввод параметров'!$C$17/100","v":0.06},"тыс. Руб",{"$f":"E24*(1-$C$25)","v":-23250.070588235281},-5302.9270588235213,7260.0734117647089,23861.181176470618,40462.28894117647,57063.396705882355,73664.504470588232,90265.612235294175,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,106866.72000000004,null,null,null,3256292.2192941192,691490.93929411797,1282400.6400000006,1282400.6400000006]
[null,"КАПИТАЛЬНЫЕ ЗАТРАТЫ"]
[null,"Закупаемое оборудование",null,"тыс. Руб",-300000,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":"SUM(AS27:AU27)","v":-300000},{"$f":"SUMIF($3:$3,AS$8,27:27)","v":-300000},0,0]
[null,"Паушальный взнос",null,"тыс. Руб",-200000,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":"SUM(AS28:AU28)","v":-200000},-200000,0,0]
[null,"КАПИТАЛЬНЫЕ ЗАТРАТЫ",null,"тыс. Руб",{"$f":"SUM(E27:E28)","v":-500000},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"SUM(AS29:AU29)","v":-500000},-500000,0,0]
[null,"Денежный поток",null,"тыс. Руб",{"$f":"E25-E23+E29","v":-518250.07058823528},-302.92705882352129,12260.073411764708,28861.181176470618,45462.28894117647,62063.396705882355,78664.504470588232,95265.612235294175,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004,111866.72000000004]
[null,"Денежный поток накопительно",null,"тыс. Руб",{"$f":"E30","v":-518250.07058823528},{"$f":"F30+E31","v":-518552.9976470588},-506292.92423529411,-477431.74305882351,-431969.45411764702,-369906.05741176469,-291241.55294117646,-195975.94070588227,-84109.220705882224,27757.499294117821,139624.21929411788,251490.93929411791,363357.65929411794,475224.37929411797,587091.099294118,698957.81929411809,810824.53929411818,922691.25929411827,1034557.9792941184,1146424.6992941184,1258291.4192941184,1370158.1392941184,1482024.8592941184,1593891.5792941183,1705758.2992941183,1817625.0192941183,1929491.7392941182,2041358.4592941182,2153225.1792941182,2265091.8992941184,2376958.6192941186,2488825.3392941188,2600692.059294119,{"$f":"AL30+AK31","v":2712558.7792941192},2824425.4992941194,2936292.2192941196,null,null,null,{"$f":"OFFSET($B31,0,(MATCH(AR$4,$2:$2,0))-1,1,1)","v":0},{"$f":"OFFSET($B31,0,(MATCH(AS$4,$2:$2,0))-1,1,1)","v":363357.65929411794},{"$f":"OFFSET($B31,0,(MATCH(AT$4,$2:$2,0))-1,1,1)","v":1705758.2992941183},{"$f":"OFFSET($B31,0,(MATCH(AU$4,$2:$2,0))-1,1,1)","v":0}]
[null,"EBITDA",null,"тыс. Руб",{"$f":"E24-E23","v":-19734.117647058811},-641.41176470587379,12723.482352941181,30384.23529411768,48044.98823529412,65705.74117647059,83366.49411764706,101027.24705882359,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,118688.00000000006,null,null,null,{"$f":"SUM(AS32:AU32)","v":3644140.6588235302},{"$f":"SUMIF($3:$3,AS$8,32:32)","v":795628.65882352972},{"$f":"SUMIF($3:$3,AT$8,32:32)","v":1424256.0000000002},{"$f":"SUMIF($3:$3,AU$8,32:32)","v":1424256.0000000002}]
[null,"NPV",{"$f":"AR33","v":0},"тыс. Руб",{"$f":"E31","v":-518250.07058823528},-518552.9976470588,-506292.92423529411,-477431.74305882351,-431969.45411764702,-369906.05741176469,-291241.55294117646,-195975.94070588227,-84109.220705882224,27757.499294117821,139624.21929411788,251490.93929411791,363357.65929411794,475224.37929411797,587091.099294118,698957.81929411809,810824.53929411818,922691.25929411827,1034557.9792941184,1146424.6992941184,1258291.4192941184,1370158.1392941184,1482024.8592941184,1593891.5792941183,1705758.2992941183,1817625.0192941183,1929491.7392941182,2041358.4592941182,2153225.1792941182,2265091.8992941184,2376958.6192941186,2488825.3392941188,2600692.059294119,{"$f":"AL31","v":2712558.7792941192},2824425.4992941194,2936292.2192941196,null,null,null,{"$f":"OFFSET($B33,0,(MATCH(AR$4,$2:$2,0))-1,1,1)","v":0},{"$f":"OFFSET($B33,0,(MATCH(AS$4,$2:$2,0))-1,1,1)","v":363357.65929411794},{"$f":"OFFSET($B33,0,(MATCH(AT$4,$2:$2,0))-1,1,1)","v":1705758.2992941183},{"$f":"OFFSET($B33,0,(MATCH(AU$4,$2:$2,0))-1,1,1)","v":0}]
[null,"Окупаемость",{"$f":"MATCH(0,$E$31:$AK$31,1)","v":9}]
[]
[]
[null,"Кол-во литров*",4.9000000000000004,"на ч/месяц"]
[null,"Потребление района",{"$f":"'Ввод параметров'!C9*3*C37*'Ввод параметров'!C8/34","v":27670.588235294123},"л/месяц"]
[null,"Средний чек",{"$f":"(('Ввод параметров'!C18+'Ввод параметров'!C19)/2)*'Ввод параметров'!C14/30+200*'Ввод параметров'!C15/50","v":327.5},"рублей"]
[null,"Выручка",{"$f":"((('Ввод параметров'!C18+'Ввод параметров'!C19)/2)*('Ввод параметров'!C14/30)*C38+200*C38)*'Ввод параметров'!C20/100","v":477317.64705882355},"рублей"]
[null,"Рентабельность",{"$f":"100-C43/C40*100","v":40},"%"]
[null,"Роялти",{"$f":"C40*'Ввод параметров'!C16/100","v":14319.529411764706},"рублей"]
[null,"Товарный остаток",{"$f":"C40*0.6","v":286390.5882352941},"рублей"]
[null,"ФОТ",{"$f":"30*'Ввод параметров'!C12+C40*'Ввод параметров'!C13/100","v":38319.529411764706},"рублей"]
[null,"Аренда",{"$f":"'Ввод параметров'!C10*'Ввод параметров'!C11","v":19600},"рублей"]
[null,"Налоги",{"$f":"C40*'Ввод параметров'!C17/100","v":28639.058823529413},"рублей"]
[null,"Чистая прибыль (мес)",{"$f":"C40-C42-C46-C43-C44-C45-C40*'Ввод параметров'!G37/100","v":90048.94117647066},"рублей"]