{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ПредвРасчет","Отчет","Inputs","Шаблон"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":66,"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":291,"n_cols":22,"rows_kept":291,"cut":false,"hidden":false,"merged":[]}
[null,"Финансовая модель проекта создания и эксплуатации школы на 1000 мест с бассейном, дополнительными функциональными помещениями в микрорайоне 20А г. Сургута на основе концессионного механизма"]
[]
[]
[1,"УПРАВЛЕНИЕ",null,null,null,"СЦЕНАРНЫЙ АНАЛИЗ ПРОЕКТА (количество лет эксплуатации)"]
[null,"Срок эксплуатации, лет",5,null,null,"Номер сценария",null,null,"Тек.сценарий",1,2,3,4,null,"ПРОВЕРКИ (балансировка модели \"ctrl + е\" на русской раскладке)"]
[null,"Капитальный грант на инвест.стадии",0.3,null,null,"Срок соглашения, лет",null,null,{"$f":"I7+3","v":8},null,{"$f":"K7+3","v":8},null,null,null,"Налог на прибыль",null,{"$f":"C135","v":true}]
[null,"Заемные средства",{"$f":"(1 - ПР_КГ_процент) * D7","v":0.48999999999999994},0.7,null,"Количество лет эксплуатации",null,null,{"$f":"C5","v":5},null,5,null,null,null,"Баланс НДС",null,{"$f":"C152","v":true}]
[null,"Собственные средства",{"$f":"(1 - ПР_КГ_процент) * D8","v":0.21},0.3,null,"Кап. грант на инвест. стадии",null,null,{"$f":"ПР_КГ_процент","v":0.3},null,0.3,null,null,null,"Расчет IRR",null,{"$f":"C190","v":true}]
[null,"Стоимость заемных средств",0.125,"* старший долг",null,null,null,null,null,null,null,null,null,null,"Точность расчетов",null,{"$f":"C221","v":true}]
[null,"Стоимость собственных средств",0.15,"* младший долг",null,"Интегральные показатели проекта"]
[]
[null,"Ставка НДС",0.18,null,null,"PV бюджета, млн.р.",null,null,{"$f":"SUM(ПР_PV_бюджета) * -1","v":-1148.0938145458572},null,-1148.0938145458572,null,null,null,"СЦЕНАРНЫЙ АНАЛИЗ ПРОЕКТА (5 лет эксплуатации, 8 лет срок КС)"]
[null,"Возмещение НДС (0 - 100% CAPEX, 1 - CAPEX без КапГранта)",0,null,null,"IRR инвестора",null,null,{"$f":"ПР_IRR_инвестора","v":0.14579233910244205},null,0.14579233910244205,null,null,null,"Номер сценария",null,null,null,null,"Тек.сценарий",1,2]
[null,"OPEX в год, млн. р.",1,null,null,"IRR проекта для бюджета",null,null,{"$f":"ПР_IRR_проекта","v":0.10505365623262763},null,0.10505365623262763,null,null,null,"Капитализация банковских процентов в млад.долг",null,null,null,null,{"$f":"IF(ПР_Сцен_капит_проц_ЗС = 1,\"да\",\"нет\")","v":"да"},"да"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Капитализация банковских процентов в baloon",null,null,null,null,{"$f":"IF(ПР_Сцен_капит_проц_baloon = 1,\"да\",\"нет\")","v":"нет"},"нет"]
[null,"Стоимость объекта с НДС, млн. р.",1274.18253,"* цены соотв.лет",null,"Номинальные показатели проекта",null,null,null,null,null,null,null,null,"Интегральные показатели проекта"]
[null,"доля здание",{"$f":"1 - ПР_CAPEX_доля_оборуд-ПР_CAPEX_доля_малоц","v":0.83699999999999997},null,null,"Расходы бюджета Югры, млн. р.",null,null,{"$f":"SUM(ПР_Расх_бюджета) * -1","v":-2023.1132008121476},null,-2023.1132008121476,null,null,null,"PV бюджета, млн.р.",null,null,null,null,{"$f":"$I$12","v":-1148.0938145458572},-1148.0938145458572]
[null,"доля обрудование",0.1,null,null,"Доходы бюджета, млн. р.",null,null,{"$f":"SUM(ПР_Расх_НП)","v":146.09231548441633},null,146.09231548441633,null,null,null,"IRR инвестора",null,null,null,null,{"$f":"$I$13","v":0.14579233910244205},0.14579233910244205]
[null,"доля малоценка",6.3E-2,null,null,"Удорожание объекта, млн. р.",null,null,{"$f":"-I17 - SUM(ПР_CAPEX) - SUM(ПР_проектир) - SUM(ПР_OPEX)","v":723.93067081214758},null,723.93067081214758,null,null,null,"IRR проекта для бюджета",null,null,null,null,{"$f":"$I$14","v":0.10505365623262763},0.10505365623262763]
[null,"Процент CAPEX в год",0.5,null,null,"Переплата бюджета, млн. р.",null,null,{"$f":"I19-I18","v":577.83835532773128},null,577.83835532773128,null,null,null,"Баланс по НДС"]
[null,null,null,null,null,"Показатели проекта при государственном контракте",null,null,null,null,null,null,null,null,"НДС возмещенный от CAPEX",null,null,null,null,{"$f":"I26","v":-195.12953847457626},-195.12953847457626]
[null,"Капит-ция банковских процентов в МД (1-да, 0-нет)",1,null,null,"Расходы бюджета Югры, млн. р.",null,null,{"$f":"SUM(ПР_Расх_Бюдж_44ФЗ) * -1","v":-1705.409197615254},null,-1705.409197615254,null,null,null,"НДС уплаченный по проекту",null,null,null,null,{"$f":"I27","v":223.51503207255368},223.51503207255368]
[null,"Капит-ция банк.процентов в baloon (1-да, 0-нет)",0,null,null,"PV бюджета, млн.р.",null,null,{"$f":"ПР_Расх_Бюдж_44ФЗ_PV","v":-1077.6306971054557},null,-1077.6306971054557,null,null,null,"Номинальные показатели проекта"]
[null,null,null,null,null,"Переплата бюджета, млн. р.",null,null,{"$f":"(SUM(ПР_CAPEX) + SUM(ПР_проектир) + I22) *-1","v":411.22666761525397},null,411.22666761525397,null,null,null,"Расходы бюджета Югры, млн. р.",null,null,null,null,{"$f":"$I$17","v":-2023.1132008121476},-2023.1132008121476]
[null,"Ставка дисконтирования",0.114,null,null,"Баланс по НДС",null,null,null,null,null,null,null,null,"Переплата бюджета, млн. р.",null,null,null,null,{"$f":"$I$20","v":577.83835532773128},577.83835532773128]
[null,"Ставка по облигациям",0.114,null,null,"НДС возмещенный от CAPEX",null,null,{"$f":"SUM(ПР_НДС_возм)","v":-195.12953847457626},null,-195.12953847457626]
[null,null,null,null,null,"НДС уплаченный по проекту",null,null,{"$f":"SUM(ПР_НДС_уплач)","v":223.51503207255368},null,223.51503207255368]
[]
[null,null,null,null,null,"Годы"]
[null,null,null,null,null,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032,"ПР_год"]
[null,"Проектирование",null,null,{"$f":"SUM(F31:U31)","v":1},1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Инвестиционная стадия",null,null,2,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_Ф_ИнвСтадия"]
[null,null,null,null,"х",0,0,0,{"$f":"$C$5","v":5},{"$f":"(I33-1)*((I33-1)>0)","v":4},3,2,1,0,0,{"$f":"(O33-1)*((O33-1)>0)","v":0},0,0,0,0,0]
[null,"Эксплуатационная стадия"," ",null,5,0,0,0,{"$f":"IF(I33 > 0,1,0)","v":1},{"$f":"IF(J33 > 0,1,0)","v":1},1,1,1,0,0,0,0,0,0,0,0,"ПР_Ф_Экспл"]
[null,"Флаг проекта",null,null,null,{"$f":"IF((F31+F32+F33+F34) >= 1,1,0)","v":1},{"$f":"IF((G31+G32+G33+G34) >= 1,1,0)","v":1},1,1,1,1,1,1,0,0,0,0,0,0,0,0,"ПР_Ф_проекта"]
[]
[{"$f":"MAX($A$1:A36) + 1","v":2},"ИНВЕСТИЦИОННАЯ СТАДИЯ"]
[null,null,null,null,null,"Годы"]
[null,null,"Значение","Ед.изм.","Сумма",{"$f":"ПР_год","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032]
[null,"Проектирование",null,"млн. р.",{"$f":"SUM(F40:U40)","v":20},20,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_проектир"]
[null,"CAPEX",null,"млн. р.",{"$f":"SUM(F41:U41)","v":1274.18253},{"$f":"F42+F43+F44","v":0},{"$f":"G42+G43+G44","v":637.09126500000002},637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_CAPEX"]
[null,"CAPEX (здание)",30,null,1066.4907776099999,0,{"$f":"ПР_CAPEX_сумма * ПР_CAPEX_доля_здание * ПР_CAPEX_процент_год * ПР_Ф_ИнвСтадия","v":533.24538880499995},533.24538880499995,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_CAPEX_здание"]
[null,"CAPEX (оборудование)",10,null,127.41825300000001,0,{"$f":"ПР_CAPEX_сумма * ПР_CAPEX_доля_оборуд * ПР_CAPEX_процент_год * ПР_Ф_ИнвСтадия","v":63.709126500000004},63.709126500000004,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_CAPEX_оборуд"]
[null,"CAPEX (малоценка)",3,null,80.273499389999998,0,{"$f":"ПР_CAPEX_сумма * ПР_CAPEX_доля_малоц * ПР_CAPEX_процент_год * ПР_Ф_ИнвСтадия","v":40.136749694999999},40.136749694999999,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_CAPEX_малоц"]
[null,"OPEX (capex)",null,"млн. р.",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Grant Project",1,null,20,{"$f":"$C$46 * F40","v":20},{"$f":"$C$46 * G40","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Grant",0.25,"млн. р.",343.94471101694916,{"$f":"F46 + F41 / (1 + ПР_Налог_НДС) * ПР_КГ_процент","v":20},{"$f":"G46 + G41 / (1 + ПР_Налог_НДС) * ПР_КГ_процент","v":161.97235550847458},161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_КапГрант"]
[null,"НДС",null,"млн. р.",194.36682661016948,0,{"$f":"(G41 - G47 * ПР_Сцен_НДС_CAPEX) - (G41 - G47 * ПР_Сцен_НДС_CAPEX)/ 1.18","v":97.183413305084741},{"$f":"(H41 - H47 * ПР_Сцен_НДС_CAPEX) - (H41 - H47 * ПР_Сцен_НДС_CAPEX)/ 1.18","v":97.183413305084741},{"$f":"(I41 - I47) - (I41 - I47)/ 1.18","v":0},0,0,0,0,0,0,0,0,0,0,0,0,"ПР_НДС_возмещ"]
[]
[null,"Потребность в финасировании",null,"млн. р.",755.87099237288135,{"$f":"F40 + F41 + F45 - F47 - F48","v":0},{"$f":"G40 + G41 + G45 - G47 - G48","v":377.93549618644067},377.93549618644067,0,0,0,0,0,{"$f":"N40 + N41 + N45 - N47 - N48","v":0},0,0,0,0,0,0,0,"ПР_потреб_финанс"]
[]
[{"$f":"MAX($A$1:A51) + 1","v":3},"ФИНАНСИРОВАНИЕ ПРОЕКТА"]
[]
[null,"Привлечение Заемных средств",null,"млн. р.",{"$f":"SUM(F54:U54)","v":529.10969466101687},{"$f":"F50 * $D$7","v":0},264.55484733050844,264.55484733050844,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_ЗС_привлеч"]
[null,"Привлечение Собственных средств",null,"млн. р.",226.76129771186439,{"$f":"F50 * $D$8","v":0},113.38064885593219,113.38064885593219,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_СС_привлеч"]
[]
[null,"Заемные средства"]
[null,"Привлечение кредита 1",null,"млн. р.",{"$f":"SUM(F58:U58)","v":264.55484733050844},0,{"$f":"$G$54","v":264.55484733050844},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Привлечение кредита 2",null,"млн. р.",264.55484733050844,0,0,{"$f":"$H$54","v":264.55484733050844},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитализация процентов в baloon",null,"млн. р.",0,0,{"$f":"$E$58 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * ПР_Сцен_капит_проц_baloon","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитализация процентов в baloon",null,"млн. р.",0,0,0,{"$f":"$E$59 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * ПР_Сцен_капит_проц_baloon","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"ВСЕГО ОД остаток 1",null,null,"х",0,{"$f":"F63+G58+G60","v":264.55484733050844},{"$f":"G63+H58+H60","v":264.55484733050844},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ВСЕГО ОД остаток 2",null,null,"х",0,{"$f":"F64+G59+G61","v":0},{"$f":"G64+H59+H61","v":264.55484733050844},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"Погашение кредита (ОД_ЗС) 1",{"$f":"$C$5","v":5},"млн. р.",{"$f":"SUM(F66:U66)","v":-264.55484733050844},{"$f":"IFERROR(PPMT($C$67,F65,$C$66,$H$63,0),0)","v":0},0,0,{"$f":"IFERROR(PPMT($C$67,I65,$C$66,$H$63,0),0)","v":-41.231941503967221},{"$f":"IFERROR(PPMT($C$67,J65,$C$66,$H$63,0),0)","v":-46.385934191963123},-52.184175965958516,-58.707197961703322,-66.04559770691624,0,0,0,0,0,0,0,0]
[null,"Погашение кредита (%)",{"$f":"ПР_ЗС_ставка","v":0.125},"млн. р.",-106.95163977089545,{"$f":"(PMT(ПР_ЗС_ставка,$C$66,$H$63,0)-F66) * ПР_Ф_Экспл","v":0},0,0,-33.069355916313555,-27.915363228317652,-22.117121454322259,-15.594099458577453,-8.2556997133645353,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"Погашение кредита (ОД_ЗС) 1",{"$f":"$C$5","v":5},"млн. р.",-264.55484733050844,{"$f":"IFERROR(PPMT($C$70,F68,$C$69,$H$64,0),0)","v":0},0,0,{"$f":"IFERROR(PPMT($C$70,I68,$C$69,$H$64,0),0)","v":-41.231941503967221},{"$f":"IFERROR(PPMT($C$70,J68,$C$69,$H$64,0),0)","v":-46.385934191963123},-52.184175965958516,-58.707197961703322,-66.04559770691624,0,0,0,0,0,0,0,0]
[null,"Погашение кредита (%)",{"$f":"ПР_ЗС_ставка","v":0.125},"млн. р.",-106.95163977089545,{"$f":"(PMT($C$70,$C$69,$H$64,0)-F69) * ПР_Ф_Экспл","v":0},0,0,-33.069355916313555,-27.915363228317652,-22.117121454322259,-15.594099458577453,-8.2556997133645353,0,0,0,0,0,0,0,0]
[]
[null,"Погашение baloon",null,"млн. р."]
[]
[null,"ВСЕГО ОД",null,"млн. р.",-529.10969466101687,{"$f":"F66+F69","v":0},{"$f":"G66+G69","v":0},{"$f":"H66+H69","v":0},{"$f":"I66+I69","v":-82.463883007934442},{"$f":"J66+J69","v":-92.771868383926247},{"$f":"K66+K69","v":-104.36835193191703},-117.41439592340664,-132.09119541383248,{"$f":"N66+N69","v":0},0,0,0,0,0,0,0,"ПР_ЗС_ОД_возврат"]
[null,"ВСЕГО %",null,"млн. р.",-213.90327954179091,{"$f":"F67+F70","v":0},{"$f":"G67 + G70 - $E$58 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * (1 - ПР_Сцен_капит_проц_ЗС)","v":0},{"$f":"H67 + H70 - $E$59 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * (1 - ПР_Сцен_капит_проц_ЗС) - $E$58 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * (1 - ПР_Сцен_капит_проц_ЗС)","v":0},{"$f":"I67+I70","v":-66.138711832627109},{"$f":"J67+J70","v":-55.830726456635304},{"$f":"K67+K70","v":-44.234242908644518},{"$f":"L67+L70","v":-31.188198917154907},-16.511399426729071,{"$f":"N67+N70","v":0},0,0,0,0,0,0,0,"ПР_ЗС_проц_возврат"]
[null,"ВСЕГО % капитализированные",null,"млн. р.",0,{"$f":"F60+F61","v":0},{"$f":"G60+G61","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_ЗС_проц_капит"]
[]
[null,"ВСЕГО аннуитет (Заемные средства)",null,"млн. р.",-743.01297420280775,{"$f":"F74+F75","v":0},0,0,-148.60259484056155,-148.60259484056155,-148.60259484056155,-148.60259484056155,-148.60259484056155,0,0,0,0,0,0,0,0]
[]
[]
[null,"Собственные средства"]
[null,"Привлечение кредита 1",null,"млн. р.",{"$f":"SUM(F82:U82)","v":113.38064885593219},{"$f":"F70","v":0},{"$f":"$G$55","v":113.38064885593219},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Привлечение кредита 2",null,"млн. р.",113.38064885593219,0,0,{"$f":"$H$55","v":113.38064885593219},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитализация процентов 1",null,"млн. р.",100.15290648940677,0,{"$f":"$E$82 * ПР_СС_ставка * ПР_Ф_ИнвСтадия + $E$58 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * ПР_Сцен_капит_проц_ЗС","v":50.076453244703387},{"$f":"$E$82 * ПР_СС_ставка * ПР_Ф_ИнвСтадия + $E$58 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * ПР_Сцен_капит_проц_ЗС","v":50.076453244703387},{"$f":"$E$82 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитализация процентов 2",null,"млн. р.",50.076453244703387,0,0,{"$f":"$E$83 * ПР_СС_ставка * ПР_Ф_ИнвСтадия + $E$59 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия * ПР_Сцен_капит_проц_ЗС","v":50.076453244703387},{"$f":"$E$59 * ПР_ЗС_ставка * ПР_Ф_ИнвСтадия","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"ВСЕГО ОД остаток 1",null,null,"х",0,{"$f":"F87+G82+G84","v":163.45710210063558},{"$f":"G87+H82+H84","v":213.53355534533898},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ВСЕГО ОД остаток 2",null,null,"х",0,{"$f":"F88+G83+G85","v":0},{"$f":"G88+H83+H85","v":163.45710210063558},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"Погашение кредита (ОД_СС) 1",{"$f":"$C$5","v":5},"млн. р.",{"$f":"SUM(F90:U90)","v":-213.53355534533901},{"$f":"IFERROR(PPMT($C$91,F89,$C$90,$H$87,0),0)","v":0},{"$f":"IFERROR(PPMT($C$91,G89,$C$90,$H$87,0),0)","v":0},0,-31.670347230118296,-36.420899314636031,-41.884034211831441,-48.166639343606157,-55.391635245147079,0,0,0,0,0,0,0,0]
[null,"Погашение кредита (%)",{"$f":"ПР_СС_ставка","v":0.15},"млн. р.",-104.96834731425668,{"$f":"(PMT(ПР_СС_ставка,$C$90,$H$87,0)-F90) * ПР_Ф_Экспл","v":0},0,0,-32.030033301800842,-27.279481217283106,-21.816346320087696,-15.53374118831298,-8.3087452867720586,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13]
[null,"Погашение кредита (ОД_СС) 2",{"$f":"$C$5","v":5},"млн. р.",-163.45710210063555,{"$f":"IFERROR(PPMT($C$94,F92,$C$93,$H$88,0),0)","v":0},{"$f":"IFERROR(PPMT($C$94,G92,$C$93,$H$88,0),0)","v":0},0,-24.243230401816209,-27.879714962088642,-32.061672206401937,-36.870923037362225,-42.401561492966565,0,0,0,0,0,0,0,0]
[null,"Погашение кредита (%)",{"$f":"ПР_СС_ставка","v":0.15},"млн. р.",-80.351876483922155,{"$f":"(PMT(ПР_СС_ставка,$C$93,$H$88,0)-F93) * ПР_Ф_Экспл","v":0},0,0,-24.518565315095334,-20.882080754822901,-16.700123510509606,-11.890872679549318,-6.3602342239449783,0,0,0,0,0,0,0,0]
[]
[null,"ВСЕГО ОД",null,"млн. р.",-376.99065744597459,{"$f":"F90+F93","v":0},{"$f":"G90+G93","v":0},0,-55.913577631934501,-64.300614276724673,-73.945706418233385,-85.037562380968382,-97.793196738113636,0,0,0,0,0,0,0,0,"ПР_СС_ОД_возврат"]
[null,"ВСЕГО %",null,"млн. р.",-185.3202237981788,{"$f":"F91+F94","v":0},{"$f":"G91+G94","v":0},0,-56.548598616896172,-48.161561972106007,-38.516469830597302,-27.424613867862298,-14.668979510717037,0,0,0,0,0,0,0,0,"ПР_СС_проц_возврат"]
[null,"ВСЕГО % капитализированные",null,"млн. р.",150.22935973411018,{"$f":"F84+F85","v":0},50.076453244703387,100.15290648940677,0,0,0,0,0,0,0,0,0,0,0,0,0,"ПР_СС_проц_капит"]
[]
[null,"ВСЕГО аннуитет (Собственные средства)",null,"млн. р.",-562.31088124415339,{"$f":"F96+F97","v":0},0,0,-112.46217624883067,-112.46217624883067,-112.46217624883069,-112.46217624883067,-112.46217624883067,0,0,0,0,0,0,0,0]
[]
[null,"Финансирование, СВОД"]
[]
[null,"ВСЕГО ОД",null,null,{"$f":"SUM(F104:U104)","v":-906.10035210699141},{"$f":"ПР_ЗС_ОД_возврат + ПР_СС_ОД_возврат","v":0},0,0,-138.37746063986896,-157.07248266065091,-178.31405835015042,-202.45195830437501,-229.88439215194612,0,0,0,0,0,0,0,0]
[null,"ВСЕГО %",null,null,-399.22350333996968,{"$f":"ПР_ЗС_проц_возврат + ПР_СС_проц_возврат","v":0},0,0,-122.68731044952328,-103.99228842874132,-82.75071273924182,-58.612812785017205,-31.180378937446108,0,0,0,0,0,0,0,0]
[null,"ВСЕГО % капитализированные",null,null,150.22935973411018,{"$f":"ПР_ЗС_проц_капит + ПР_СС_проц_капит","v":0},50.076453244703387,100.15290648940677,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[{"$f":"MAX($A$1:A107) + 1","v":4},"ОПЕРАЦИОННЫЕ ЗАТРАТЫ"]
[]
[null,"OPEX",null,null,{"$f":"SUM(F110:U110)","v":5},{"$f":"ПР_OPEX_год * ПР_Ф_Экспл","v":0},0,0,1,1,1,1,1,0,0,0,0,0,0,0,0,"ПР_OPEX"]
[]
[{"$f":"MAX($A$1:A111) + 1","v":5},"РАСЧЕТ СУБСИДИЙ ПО КАПГРАНТУ И ИНВЕСТИЦИОННОМУ ПЛАТЕЖУ"]
[]
[null,"Субсидия на возмещение затрат на создание объекта на Инвестиционной стадии",null,null,{"$f":"SUM(F114:U114)","v":343.94471101694916},{"$f":"ПР_КапГрант","v":20},161.97235550847458,161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта в части банковских процентов",null,null,213.90327954179091,{"$f":"-ПР_ЗС_проц_возврат","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0,"ПР_С_КГ_Экспл"]
[null,"Субсидия на исполнение обязательств Концедента по выплате Инвестиционного платежа по концессионному соглашению",null,null,1287.8762795681009,{"$f":"-(ПР_ЗС_ОД_возврат + ПР_СС_ОД_возврат + ПР_СС_проц_возврат) * (1 + ПР_Налог_НДС)","v":0},0,0,230.01274992298286,242.17617266665314,255.86002325328229,271.25435516324001,288.57297856194248,0,0,0,0,0,0,0,0,"ПР_С_ПК_ИП"]
[]
[{"$f":"MAX($A$1:A117) + 1","v":6},"РАСЧЕТ СУБСИДИИ ПО ОПЕРАЦИОННОМУ ПЛАТЕЖУ"]
[]
[null,"Выручка",null,null,{"$f":"SUM(F120:U120)","v":1241.7501781808539},{"$f":"F116 / (1 + ПР_Налог_НДС) + F139 / (1 + ПР_Налог_НДС)","v":0},0,0,211.60554385988908,226.58728467013805,243.49416206010252,269.26413919341877,290.79904704241403,1.5864179273272801E-7,2.0726674574591243E-7,2.6291280298047565E-7,3.2659496064734113E-7,3.9947512024546539E-7,0,0,0,"ПР_Выручка"]
[null,"Прочие доходы (корректировка по банковским процентам)",null,null,213.90327954179091,{"$f":"F115","v":0},{"$f":"G115","v":0},0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Расходы на эксплуатацию",null,null,4.2372881355932206,{"$f":"ПР_OPEX / (1 + ПР_Налог_НДС)","v":0},0,0,0.84745762711864414,0.84745762711864414,0.84745762711864414,0.84745762711864414,0.84745762711864414,0,0,0,0,0,0,0,0]
[null,"Амортизация",null,null,321.73108882499997,{"$f":"(SUM(ПР_CAPEX_здание) / ПР_CAPEX_амор_здание * F124 + SUM(ПР_CAPEX_оборуд) / ПР_CAPEX_амор_оборуд * F125 + SUM(ПР_CAPEX_малоц) / ПР_CAPEX_амор_малоц * F126) * ПР_Ф_Экспл","v":0},0,0,75.049351016999992,75.049351016999992,75.049351016999992,48.291517886999998,48.291517886999998,0,0,0,0,0,0,0,0]
[null,"Флаг амортизация здание",null,null,13,0,0,0,1,1,1,1,1,1,1,1,1,1,1,1,1]
[null,"Флаг амортизация оборудование",null,null,10,0,0,0,1,1,1,1,1,1,1,1,1,1,0,0,0]
[null,"Флаг амортизация малоценка",null,null,3,0,0,0,1,1,1,0,0,0,0,0,0,0,0,0,0]
[null,"Проценты",null,null,-399.22350333996968,{"$f":"F105","v":0},0,0,-122.68731044952328,-103.99228842874132,-82.75071273924182,-58.612812785017205,-31.180378937446108,0,0,0,0,0,0,0,0]
[]
[null,"Прибыль до НО",null,null,730.46157742208175,{"$f":"F120+F121-F122-F123+F127","v":0},{"$f":"G120+G121-G122-G123+G127","v":0},0,79.160136598874217,102.52891405391338,129.08088358538657,192.70054981143781,226.99109201757835,1.5864179273272801E-7,2.0726674574591243E-7,2.6291280298047565E-7,3.2659496064734113E-7,3.9947512024546539E-7,0,0,0]
[null,"Налог на прибыль",0.2,null,146.09231548441633,{"$f":"$C$130 * F129","v":0},{"$f":"$C$130 * G129","v":0},0,15.832027319774845,20.505782810782677,25.816176717077315,38.540109962287566,45.398218403515671,{"$f":"$C$130 * N129","v":3.17283585465456E-8},4.1453349149182489E-8,5.2582560596095129E-8,6.5318992129468233E-8,7.9895024049093086E-8,0,0,0,"ПР_Расх_НП"]
[null,"Прибыль после НО (дивиденды)",null,null,584.36926193766533,{"$f":"F129-F130","v":0},{"$f":"G129-G130","v":0},0,63.328109279099372,82.023131243130706,103.26470686830926,154.16043984915024,181.59287361406268,{"$f":"N129-N130","v":1.269134341861824E-7},1.6581339659672996E-7,2.1033024238438052E-7,2.6127596851787288E-7,3.1958009619637229E-7,0,0,0]
[]
[null,"Налог на прибыль",null,null,146.09231414009048,0,0,0,15.832026976005288,20.505782410262483,25.816176252236165,38.540109394062846,45.398217752632263,1.5864179273272801E-7,2.0726674574591243E-7,2.6291280298047565E-7,3.2659496064734113E-7,3.9947512024546539E-7,0,0,0,"ПР_Расх_НП_paste"]
[null,"Проверка (точность до 0,1 млн)",null,null,null,{"$f":"F133=F130","v":true},{"$f":"ROUND(G133,1)=ROUND(G130,1)","v":true},{"$f":"ROUND(H133,1)=ROUND(H130,1)","v":true},true,true,true,true,true,{"$f":"ROUND(N133,1)=ROUND(N130,1)","v":true},true,true,true,true,true,true,true]
[null,"Проверка по всем периодам",{"$f":"SUM(F135:U135)=COUNT(ПР_год)","v":true},null,null,{"$f":"F134 * 1","v":1},{"$f":"G134 * 1","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[{"$f":"MAX($A$1:A135) + 1","v":7},"БЮДЖЕТНЫЕ РАСХОДЫ"]
[]
[null,"Субсидия на исполнение обязательств Концедента по выплате Операционного платежа по концессионному соглашению",null,null,177.38893068530675,{"$f":"F110 + F133 * (1 + ПР_Налог_НДС)","v":0},0,0,19.68179183168624,25.19682324410973,31.463087977638672,46.477329084994153,54.56989694810607,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0,"ПР_С_ПК_ИП"]
[]
[null,"Субсидия на возмещение затрат на создание объекта на Инвестиционной стадии",null,null,343.94471101694916,{"$f":"F114","v":20},161.97235550847458,161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта в части банковских процентов",null,null,213.90327954179091,{"$f":"F115","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Субсидия на исполнение обязательств Концедента по выплате Инвестиционного платежа по концессионному соглашению",null,null,1287.8762795681009,{"$f":"F116","v":0},0,0,230.01274992298286,242.17617266665314,255.86002325328229,271.25435516324001,288.57297856194248,0,0,0,0,0,0,0,0]
[]
[null,"ВСЕГО Субсидии",null,null,2023.1132008121476,{"$f":"SUM(F139:F143)","v":20},{"$f":"SUM(G139:G143)","v":161.97235550847458},161.97235550847458,315.83325358729621,323.2037223673982,331.55735413956552,348.91988316538908,359.6542749367776,{"$f":"SUM(N139:N143)","v":1.8719731542461903E-7},2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0,"ПР_Расх_бюджета"]
[null,null,null,null,{"$f":"\"* Стоимость ШКОЛЫ = \" & (E40+E41) & \" млн. рублей (удорожание \" & ROUND((E145 - (E40+E41)),0) & \" млн. рублей)\"","v":"* Стоимость ШКОЛЫ = 1294,18253 млн. рублей (удорожание 729 млн. рублей)"}]
[{"$f":"MAX($A$1:A146) + 1","v":8},"ПРОВЕРКА НДС"]
[]
[null,"НДС из фед.бюджета",null,null,{"$f":"SUM(F149:U149)","v":195.12953847457626},{"$f":"F48 + F110 - F110 / (1 + ПР_Налог_НДС)","v":0},97.183413305084741,97.183413305084741,0.15254237288135586,0.15254237288135586,0.15254237288135586,0.15254237288135586,0.15254237288135586,0,0,0,0,0,0,0,0]
[null,"НДС в фед.бюджет",null,null,223.51503207255368,{"$f":"F143 - F143 / (1 + ПР_Налог_НДС) + F139 - F139 / (1 + ПР_Налог_НДС)","v":0},0,0,38.088997894780029,40.785711240624842,43.828949170818461,48.467545054815368,52.343828467634523,2.8555522691891022E-8,3.7308014234264223E-8,4.73243045364856E-8,5.8787092916521358E-8,7.1905521644183768E-8,0,0,0]
[]
[null,"ОБОРОТ по НДС",{"$f":"E152 > 0","v":true},null,{"$f":"SUM(F152:U152)","v":28.385493597977401},{"$f":"F150-F149","v":0},{"$f":"G150-G149","v":-97.183413305084741},-97.183413305084741,37.936455521898672,40.633168867743485,43.676406797937105,48.315002681934011,52.191286094753167,2.8555522691891022E-8,3.7308014234264223E-8,4.73243045364856E-8,5.8787092916521358E-8,7.1905521644183768E-8,0,0,0]
[]
[{"$f":"MAX($A$1:A153) + 1","v":9},"РАСЧЕТ УДОРОЖАНИЯ"]
[]
[null,"Капитальные затраты",null,null,{"$f":"SUM(F156:U156)","v":1274.18253},{"$f":"ПР_CAPEX","v":0},637.09126500000002,637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Проектирование",null,null,20,{"$f":"ПР_проектир","v":20},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ВСЕГО",null,null,1294.18253,{"$f":"F157+F156","v":20},{"$f":"G157+G156","v":637.09126500000002},637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"БЮДЖЕТНЫЕ РАСХОДЫ (концессионное соглашение)",null,null,{"$f":"SUM(F160:U160)","v":2023.1132008121476},{"$f":"F161 + F162 + F163 + F164","v":20},{"$f":"G161 + G162 + G163 + G164","v":161.97235550847458},161.97235550847458,315.83325358729621,323.2037223673982,331.55735413956552,348.91988316538908,359.65427493677765,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта на Инвестиционной стадии",null,null,{"$f":"SUM(F161:U161)","v":343.94471101694916},{"$f":"F141","v":20},161.97235550847458,161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта в части банковских процентов",null,null,{"$f":"SUM(F162:U162)","v":213.90327954179091},{"$f":"F142","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Субсидия на исполнение обязательств Концедента по выплате Инвестиционного платежа по концессионному соглашению",null,null,{"$f":"SUM(F163:U163)","v":1287.8762795681009},{"$f":"F143","v":0},0,0,230.01274992298286,242.17617266665314,255.86002325328229,271.25435516324001,288.57297856194248,0,0,0,0,0,0,0,0]
[null,"Субсидия на исполнение обязательств Концедента по выплате Операционного платежа по концессионному соглашению",null,null,{"$f":"SUM(F164:U164)","v":177.38893068530675},{"$f":"F139","v":0},0,0,19.68179183168624,25.19682324410973,31.463087977638672,46.477329084994153,54.56989694810607,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0]
[]
[null,"ВСЕГО удорожание, в том числе",null,null,{"$f":"SUM(F166:U166)","v":918.29749742231729},{"$f":"F175 + F170 + F168 + F167 - ПР_OPEX","v":0},50.076453244703387,100.15290648940677,176.45579294742726,165.13123970674729,152.24329578941507,145.46792486101407,128.76988278483154,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0,"ПР_Удорож"]
[null,"Банковские проценты",null,null,213.90327954179091,{"$f":"(ПР_ЗС_проц_возврат + ПР_ЗС_проц_капит) * -1","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Проценты по Собственным средствам",null,null,335.54958353228903,{"$f":"ПР_СС_проц_возврат * -1 + ПР_СС_проц_капит","v":0},50.076453244703387,100.15290648940677,56.548598616896172,48.161561972106007,38.516469830597302,27.424613867862298,14.668979510717037,0,0,0,0,0,0,0,0]
[]
[null,"НДС по инвестиционному платежу",null,null,196.4557036629306,{"$f":"F143-F143/(1+ПР_Налог_НДС)","v":0},0,0,35.08669066621772,36.942128033896239,39.029495072534587,41.377782991002704,44.019606899279353,0,0,0,0,0,0,0,0]
[]
[null,"Уплаченный НДС в проекте",null,null,{"$f":"SUM(F172:U172)","v":223.51503207255368},{"$f":"F170+F178","v":0},{"$f":"G170+G178","v":0},0,38.088997894780029,40.785711240624842,43.828949170818447,48.467545054815368,52.343828467634516,2.8555522691891022E-8,3.7308014234264223E-8,4.73243045364856E-8,5.8787092916521358E-8,7.1905521644183768E-8,0,0,0,"ПР_НДС_уплач"]
[null,"Возмещение НДС в проекте",null,null,-195.12953847457626,{"$f":"(ПР_НДС_возмещ + (ПР_OPEX -ПР_OPEX / (1 + ПР_Налог_НДС))) * -1","v":0},-97.183413305084741,-97.183413305084741,-0.15254237288135586,-0.15254237288135586,-0.15254237288135586,-0.15254237288135586,-0.15254237288135586,0,0,0,0,0,0,0,0,"ПР_НДС_возм"]
[]
[null,"Операционный платеж, в т.ч.",null,null,177.38893068530675,{"$f":"F139","v":0},0,0,19.68179183168624,25.19682324410973,31.463087977638672,46.477329084994153,54.56989694810607,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0]
[null,"возмещение налога на прибыль",null,null,146.09231414009048,{"$f":"F133","v":0},0,0,15.832026976005288,20.505782410262483,25.816176252236165,38.540109394062846,45.398217752632263,1.5864179273272801E-7,2.0726674574591243E-7,2.6291280298047565E-7,3.2659496064734113E-7,3.9947512024546539E-7,0,0,0]
[null,"возмещение эксплуатационных расходов",null,null,4.2372881355932206,{"$f":"ПР_OPEX / (1 + ПР_Налог_НДС)","v":0},0,0,0.84745762711864414,0.84745762711864414,0.84745762711864414,0.84745762711864414,0.84745762711864414,0,0,0,0,0,0,0,0]
[null,"НДС в Операционном платеже",null,null,27.05932840962306,{"$f":"F139 - F139 / (1 + ПР_Налог_НДС)","v":0},0,0,3.0023072285623087,3.8435832067286029,4.7994540982838636,7.0897620638126639,8.3242215683551635,2.8555522691891022E-8,3.7308014234264223E-8,4.73243045364856E-8,5.8787092916521358E-8,7.1905521644183768E-8,0,0,0]
[]
[{"$f":"MAX($A$1:A179) + 1","v":10},"ИНТЕГРАЛЬНЫЕ ПОКАЗАТЕЛИ ПРОЕКТА"]
[]
[null,"PV бюджетных расходов по КС",{"$f":"NPV(ПР_ст_диск,F182:U182)","v":1148.0938145458572},"ПР_PV_бюджета",{"$f":"SUM(F182:U182)","v":2023.113199213376},{"$f":"F160 * ПР_Ф_проекта","v":20},161.97235550847458,161.97235550847458,315.83325358729621,323.2037223673982,331.55735413956552,348.91988316538908,359.65427493677765,0,0,0,0,0,0,0,0]
[]
[null,"IRR проекта для бюджета",{"$f":"IRR(F184:U184)","v":0.10505365623262763},"ПР_IRR_проекта",{"$f":"SUM(F184:U184)","v":577.83835642817689},{"$f":"(-F158 - G158 + F160 - F176 - ПР_OPEX) * ПР_Ф_проекта","v":-637.09126500000002},{"$f":"(-H158 + G160 - G176 - ПР_OPEX) * ПР_Ф_проекта","v":-475.11890949152541},{"$f":"(H160 - H176 - ПР_OPEX) * ПР_Ф_проекта","v":161.97235550847458},299.00122661129092,301.6979399571357,304.74117788732934,309.37977377132626,313.25605718414539,0,0,0,0,0,0,0,0]
[null,"всего вложений",null,null,-1294.18253,{"$f":"-F158 * ПР_Ф_проекта","v":-20},-637.09126500000002,-637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"бюджетные доходы (налог на прибыль)",null,null,-146.09231278519906,{"$f":"-F176 * ПР_Ф_проекта","v":0},0,0,-15.832026976005288,-20.505782410262483,-25.816176252236165,-38.540109394062846,-45.398217752632263,0,0,0,0,0,0,0,0]
[null,"эксплуатация",null,null,-5,{"$f":"-ПР_OPEX * ПР_Ф_проекта","v":0},0,0,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0]
[null,"Бюджетные расходы",null,null,2023.113199213376,{"$f":"F160 * ПР_Ф_проекта","v":20},161.97235550847458,161.97235550847458,315.83325358729621,323.2037223673982,331.55735413956552,348.91988316538908,359.65427493677765,0,0,0,0,0,0,0,0]
[null,"Проверка",null,null,null,{"$f":"F185+F186+F187+F188+G185=F184","v":true},{"$f":"G185+G186+G187+G188=G184","v":true},{"$f":"H186+H187+H188=H184","v":true},{"$f":"I185+I186+I187+I188=I184","v":true},true,true,true,true,true,true,true,true,true,true,true,true]
[null,"Проверка",{"$f":"SUM(F190:U190)=COUNT(ПР_год)","v":true},null,null,{"$f":"F189 * 1","v":1},{"$f":"G189 * 1","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[]
[{"$f":"MAX($A$1:A191) + 1","v":11},"ПОТОКИ ИНВЕСТОРА"]
[]
[null,"FCFE",null,null,{"$f":"SUM(F194:U194)","v":185.3202237981788},{"$f":"(-F82 - F83 - F84 - F85 - F90 - F91 - F93 - F94) * ПР_Ф_проекта","v":0},{"$f":"(-G82 - G83 - F84 - F85 - G90 - G91 - G93 - G94) * ПР_Ф_проекта","v":-113.38064885593219},-163.45710210063558,12.309269759423906,112.46217624883067,112.46217624883067,112.46217624883067,112.46217624883067,0,0,0,0,0,0,0,0,"* (инвестор привлекает долг под капитализацию процентов в конце периода)"]
[null,"IRR инвестора",{"$f":"IRR(F194:U194)","v":0.14579233910244205}]
[]
[{"$f":"MAX($A$1:A196) + 1","v":12},"БЮДЖЕТ ДВИЖЕНИЯ ДЕНЕЖНЫХ СРЕДСТВ"]
[]
[null,"Операционный поток"]
[null,"Выручка",null,null,{"$f":"SUM(F200:U200)","v":1465.2652086546357},{"$f":"ПР_Выручка * (1 + ПР_Налог_НДС) * ПР_Ф_проекта","v":0},0,0,249.6945417546691,267.37299591076288,287.32311123092097,317.73168424823416,343.14287551004855,0,0,0,0,0,0,0,0]
[null,"Расходы на эксплуатацию",null,null,-5,{"$f":"ПР_OPEX * -1 * ПР_Ф_проекта","v":0},0,0,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0]
[null,"Проценты",null,null,-399.22350333996968,{"$f":"ПР_ЗС_проц_возврат + ПР_СС_проц_возврат * ПР_Ф_проекта","v":0},0,0,-122.68731044952328,-103.99228842874132,-82.75071273924182,-58.612812785017205,-31.180378937446108,0,0,0,0,0,0,0,0]
[null,"Возмещение банковских процентов",null,null,213.90327954179091,{"$f":"F162 * ПР_Ф_проекта","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Налог на прибыль",null,null,-146.09231548441633,{"$f":"F130 * -1","v":0},0,0,-15.832027319774845,-20.505782810782677,-25.816176717077315,-38.540109962287566,-45.398218403515671,-3.17283585465456E-8,-4.1453349149182489E-8,-5.2582560596095129E-8,-6.5318992129468233E-8,-7.9895024049093086E-8,0,0,0]
[null,"Оборот по НДС",null,null,-28.385493597977401,{"$f":"F152 * -1","v":0},97.183413305084741,97.183413305084741,-37.936455521898672,-40.633168867743485,-43.676406797937105,-48.315002681934011,-52.191286094753167,-2.8555522691891022E-8,-3.7308014234264223E-8,-4.73243045364856E-8,-5.8787092916521358E-8,-7.1905521644183768E-8,0,0,0]
[null,"Чистый денежный поток в результате операционной деятельности",null,null,1100.4671757740632,{"$f":"SUM(F200:F205)","v":0},{"$f":"SUM(G200:G205)","v":97.183413305084741},97.183413305084741,138.3774602960994,157.0724822601307,178.31405788530924,202.45195773615032,229.88439150106265,-6.0283881238436629E-8,-7.8761363383446713E-8,-9.9906865132580729E-8,-1.241060850459896E-7,-1.5180054569327687E-7,0,0,0]
[]
[null,"Инвестиционный поток"]
[null,"Проектирование",null,null,{"$f":"SUM(F209:U209)","v":-20},{"$f":"ПР_проектир * -1 * ПР_Ф_проекта","v":-20},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитальные затраты",null,null,-1274.18253,{"$f":"ПР_CAPEX * -1 * ПР_Ф_проекта","v":0},-637.09126500000002,-637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Капитальный грант",null,null,343.94471101694916,{"$f":"ПР_КапГрант * ПР_Ф_проекта","v":20},161.97235550847458,161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Чистый денежный поток в результате инвестиционной деятельности",null,null,-950.23781898305083,{"$f":"SUM(F209:F211)","v":0},{"$f":"SUM(G209:G211)","v":-475.11890949152541},-475.11890949152541,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Финансовый поток"]
[null,"Привлечение Банковских средств",null,null,{"$f":"SUM(F215:U215)","v":529.10969466101687},{"$f":"ПР_ЗС_привлеч * ПР_Ф_проекта","v":0},264.55484733050844,264.55484733050844,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Погашение Банковских средств",null,null,-529.10969466101687,{"$f":"ПР_ЗС_ОД_возврат * ПР_Ф_проекта","v":0},0,0,-82.463883007934442,-92.771868383926247,-104.36835193191703,-117.41439592340664,-132.09119541383248,0,0,0,0,0,0,0,0]
[null,"Привлечение Собственных средств",null,null,226.76129771186439,{"$f":"ПР_СС_привлеч * ПР_Ф_проекта","v":0},113.38064885593219,113.38064885593219,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Погашение Собственных средств",null,null,-376.99065744597459,{"$f":"ПР_СС_ОД_возврат * ПР_Ф_проекта","v":0},0,0,-55.913577631934501,-64.300614276724673,-73.945706418233385,-85.037562380968382,-97.793196738113636,0,0,0,0,0,0,0,0]
[null,"Чистый денежный поток в результате финансовой деятельности",null,null,-150.22935973411015,{"$f":"SUM(F215:F218)","v":0},{"$f":"SUM(G215:G218)","v":377.93549618644062},377.93549618644062,-138.37746063986896,-157.07248266065091,-178.31405835015042,-202.45195830437501,-229.88439215194612,0,0,0,0,0,0,0,0]
[]
[null,"ЧИСТЫЙ ДЕНЕЖНЫЙ ПОТОК ПРОЕКТА",{"$f":"E221<ДопОшибка","v":true},null,-2.9430978400659691E-6,{"$f":"F206+F212+F219","v":0},{"$f":"G206+G212+G219","v":0},0,-3.4376955682091648E-7,-4.0052020722214365E-7,-4.6484117888212495E-7,-5.6822469218786864E-7,-6.5088346445918432E-7,-6.0283881238436629E-8,-7.8761363383446713E-8,-9.9906865132580729E-8,-1.241060850459896E-7,-1.5180054569327687E-7,0,0,0]
[]
[{"$f":"MAX($A$1:A222) + 1","v":13},"РАСЧЕТ ДЛЯ ГОСУДАРСТВЕННОГО КОНТРАКТА"]
[null,null,null,null,null,"Годы"]
[null,null,"Значение","Ед.изм.","Сумма",{"$f":"ПР_год","v":2017},2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,2030,2031,2032]
[null,"Проектирование (государственный счет)",null,"млн. р.",{"$f":"SUM(F226:U226)","v":20},{"$f":"ПР_проектир","v":20},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"CAPEX",null,"млн. р.",{"$f":"SUM(F227:U227)","v":1274.18253},{"$f":"ПР_CAPEX","v":0},637.09126500000002,637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Эксплуатация",null,"млн. р.",5,{"$f":"ПР_OPEX","v":0},0,0,1,1,1,1,1,0,0,0,0,0,0,0,0]
[]
[null,"Финансирование за счет государственных программ",null,"млн. р.",{"$f":"SUM(F230:U230)","v":343.94471101694916},{"$f":"ПР_КапГрант","v":20},161.97235550847458,161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Потребность в финансировании",null,"млн. р.",950.23781898305083,{"$f":"F226 + F227 - F230","v":0},{"$f":"G226 + G227 - G230","v":475.11890949152541},475.11890949152541,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Привлечние долга, транш 1",null,"млн. р.",475.11890949152541,0,{"$f":"$G$232","v":475.11890949152541},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(F234 = 0, (E235 > 0) * (E235 - 1),(ПР_Срок_экспл + 2))","v":0},7,6,5,4,3,2,1,0,0,0,0,0,0,0,0]
[null,"Баланс долга на начало, транш 1",null,null,null,{"$f":"E239 + F234","v":0},{"$f":"F239 + G234","v":475.11890949152541},407.24477956416467,339.37064963680393,271.49651970944319,203.62238978208242,135.74825985472165,67.874129927360883,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13]
[null,"Погашение долга, транш 1","=(G230 > 0) * $E$229 / (ПР_Срок_экспл + 2)","млн. р.",475.1189094915253,{"$f":"(F235 > 0) * $E$234 / (ПР_Срок_экспл + 2)","v":0},67.874129927360769,67.874129927360769,67.874129927360769,67.874129927360769,67.874129927360769,67.874129927360769,67.874129927360769,0,0,0,0,0,0,0,0]
[null,"Погашение процентов, транш 1",null,"млн. р.",{"$f":"SUM(F238:U238)","v":216.65422272813566},{"$f":"F236 * ПР_Ставка_облиг","v":0},54.163555682033902,46.425904870314774,38.688254058595646,30.950603246876526,23.212952435157398,15.475301623438268,7.7376508117191412,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14]
[null,"Баланс долга на конец, транш 1",null,null,null,{"$f":"F236 - F237","v":0},{"$f":"G236 - G237","v":407.24477956416467},339.37064963680393,271.49651970944319,203.62238978208242,135.74825985472165,67.874129927360883,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13,1.1368683772161603E-13]
[null,"ИТОГО расходы по траншу 1",null,null,691.77313221966108,{"$f":"F237+F238","v":0},{"$f":"G237+G238","v":122.03768560939467},114.30003479767555,106.56238398595642,98.824733174237295,91.087082362518174,83.349431550799039,75.611780739079904,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14]
[]
[null,"Привлечние долга, транш 2",null,"млн. р.",{"$f":"SUM(F242:U242)","v":475.11890949152541},0,0,{"$f":"$H$232","v":475.11890949152541},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,{"$f":"IF(F242 = 0, (E243 > 0) * (E243 - 1),(ПР_Срок_экспл + 1))","v":0},0,6,5,4,3,2,1,0,0,0,0,0,0,0,0]
[null,"Баланс долга на начало, транш 2",null,null,null,{"$f":"E247 + F242","v":0},{"$f":"F247 + G242","v":0},475.11890949152541,395.93242457627116,316.74593966101691,237.55945474576265,158.3729698305084,79.186484915254155,0,0,0,0,0,0,0,0]
[null,"Погашение долга, транш 2",null,"млн. р.",{"$f":"SUM(F245:U245)","v":475.11890949152547},{"$f":"(F243 > 0) * $E$234 / (ПР_Срок_экспл + 1)","v":0},0,79.18648491525424,79.18648491525424,79.18648491525424,79.18648491525424,79.18648491525424,79.18648491525424,0,0,0,0,0,0,0,0]
[null,"Погашение процентов, транш 2",null,"млн. р.",189.57244488711862,{"$f":"F244 * ПР_Ставка_облиг","v":0},0,54.163555682033902,45.136296401694914,36.109037121355925,27.081777841016944,18.054518560677959,9.0272592803389742,0,0,0,0,0,0,0,0]
[null,"Баланс долга на конец, транш 1",null,null,null,{"$f":"F244 - F245","v":0},{"$f":"G244 - G245","v":0},395.93242457627116,316.74593966101691,237.55945474576265,158.3729698305084,79.186484915254155,0,0,0,0,0,0,0,0,0]
[null,"ИТОГО расходы по траншу 1",null,null,{"$f":"SUM(F248:U248)","v":664.69135437864406},{"$f":"F245 + F246","v":0},{"$f":"G245 + G246","v":0},133.35004059728814,124.32278131694915,115.29552203661017,106.26826275627118,97.241003475932203,88.213744195593222,0,0,0,0,0,0,0,0]
[]
[null,null,{"$f":"IRR(F250:U250)","v":0.12172007070003321},null,null,-465,{"$f":"-465+G240+G248","v":-342.96231439060534},{"$f":"H240+H248","v":247.65007539496369},{"$f":"I240+I248","v":230.88516530290556},214.12025521084746,197.35534511878936,180.59043502673126,163.82552493467313]
[]
[null,"ВСЕГО бюджетные расходы по 44 ФЗ, в том числе",null,"млн. р.",1705.409197615254,{"$f":"F230 + F240 + F248 + F228","v":20},{"$f":"G230 + G240 + G248 + G228","v":284.01004111786926},409.62243090343827,231.88516530290556,215.12025521084746,198.35534511878936,181.59043502673126,164.82552493467313,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,"ПР_Расх_Бюдж_44ФЗ"]
[null,"погашение долга",null,null,950.23781898305072,{"$f":"F237+F245","v":0},{"$f":"G237+G245","v":67.874129927360769},147.060614842615,147.060614842615,147.060614842615,147.060614842615,147.060614842615,147.060614842615,0,0,0,0,0,0,0,0]
[null,"погашение процентов",null,null,406.22666761525426,{"$f":"F238+F246","v":0},{"$f":"G238+G246","v":54.163555682033902},100.58946055234867,83.824550460290567,67.059640368232451,50.294730276174342,33.529820184116225,16.764910092058116,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14]
[null,"государственные программы",null,null,343.94471101694916,{"$f":"F230","v":20},{"$f":"G230","v":161.97235550847458},161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"эксплуатация",null,null,5,{"$f":"F228","v":0},{"$f":"G228","v":0},0,1,1,1,1,1,0,0,0,0,0,0,0,0]
[]
[null,"Приведенная стоимость бюджетных расходов",{"$f":"NPV(ПР_ст_диск,ПР_Расх_Бюдж_44ФЗ) * -1","v":-1077.6306971054557},"млн. р."]
[]
[null,"Расчет IRR",{"$f":"IRR(F260:U260)","v":0.17430250816070991},null,null,{"$f":"-F226-F227-F228+F252","v":0},{"$f":"-G226-G227-G228+G252","v":-353.08122388213076},-227.46883409656175,230.88516530290556,214.12025521084746,197.35534511878936,180.59043502673126,163.82552493467313,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14,1.2960299500264228E-14]
[]
[{"$f":"MAX($A$1:A261) + 1","v":14},"РАСЧЕТ КОЭФИЦИЕНТОВ ДЛЯ ГП"]
[]
[null,"Капитальные затраты",null,null,{"$f":"SUM(F264:U264)","v":1274.18253},{"$f":"ПР_CAPEX","v":0},637.09126500000002,637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Проектирование",null,null,20,{"$f":"ПР_проектир","v":20},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"ВСЕГО",null,null,1294.18253,{"$f":"F265+F264","v":20},{"$f":"G265+G264","v":637.09126500000002},637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"БЮДЖЕТНЫЕ РАСХОДЫ (концессионное соглашение)",null,null,{"$f":"SUM(F268:U268)","v":2023.1132008121476},{"$f":"F269 + F270 + F271 + F272","v":20},{"$f":"G269 + G270 + G271 + G272","v":161.97235550847458},161.97235550847458,315.83325358729621,323.2037223673982,331.55735413956552,348.91988316538908,359.65427493677765,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта на Инвестиционной стадии",null,null,{"$f":"SUM(F269:U269)","v":343.94471101694916},{"$f":"F161","v":20},{"$f":"G161","v":161.97235550847458},161.97235550847458,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Субсидия на возмещение затрат на создание объекта в части банковских процентов",null,null,{"$f":"SUM(F270:U270)","v":213.90327954179091},{"$f":"F162","v":0},0,0,66.138711832627109,55.830726456635304,44.234242908644518,31.188198917154907,16.511399426729071,0,0,0,0,0,0,0,0]
[null,"Субсидия на исполнение обязательств Концедента по выплате Инвестиционного платежа по концессионному соглашению",null,null,{"$f":"SUM(F271:U271)","v":1287.8762795681009},{"$f":"F163","v":0},0,0,230.01274992298286,242.17617266665314,255.86002325328229,271.25435516324001,288.57297856194248,0,0,0,0,0,0,0,0]
[null,"Субсидия на исполнение обязательств Концедента по выплате Операционного платежа по концессионному соглашению",null,null,{"$f":"SUM(F272:U272)","v":177.38893068530675},{"$f":"F164","v":0},0,0,19.68179183168624,25.19682324410973,31.463087977638672,46.477329084994153,54.56989694810607,1.8719731542461903E-7,2.4457475998017666E-7,3.1023710751696125E-7,3.8538205356386248E-7,4.7138064188964916E-7,0,0,0]
[]
[null,"Капитальные затраты + проектирование (в ценах соответствующих лет)",null,null,{"$f":"SUM(F274:U274)","v":1294.18253},{"$f":"F266","v":20},637.09126500000002,637.09126500000002,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"К капитальный грант",null,null,{"$f":"SUM(F275:U275)","v":0.2657621340453028},{"$f":"F269 / $E$274","v":1.5453770651656068E-2},{"$f":"G269 / $E$274","v":0.12515418169682338},0.12515418169682338,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"К банковские проценты",null,null,0.16528061118379561,{"$f":"F270 / $E$274","v":0},0,0,5.1104624192869541E-2,4.3139762098809431E-2,3.4179292242991814E-2,2.4098763655197003E-2,1.2758168993927827E-2,0,0,0,0,0,0,0,0]
[null,"К инвестиционного платежа",null,null,0.9951272326076761,{"$f":"F271 / $E$274","v":0},0,0,0.17772821421332496,0.18712675148431585,0.19770010591418066,0.20959512964777852,0.22297703134807612,0,0,0,0,0,0,0,0]
[null,"К операционного платежа",null,null,0.13706639254766231,{"$f":"F272 / $E$274","v":0},0,0,1.5207894849025847E-2,1.9469296378239419E-2,2.4311167279965271E-2,3.5912499209052179E-2,4.2165533596026879E-2,1.4464521895888907E-10,1.8898011239587405E-10,2.3971665536001419E-10,2.9778029345200826E-10,3.6423041646965296E-10,0,0,0]
[]
[null,"К распределение общее",null,null,1.563236370384437,{"$f":"F278 + F277 + F276 + F275","v":1.5453770651656068E-2},{"$f":"G278 + G277 + G276 + G275","v":0.12515418169682338},0.12515418169682338,0.24404073325522035,0.24973580996136469,0.25619056543713775,0.26960639251202767,0.27790073393803083,1.4464521895888907E-10,1.8898011239587405E-10,2.3971665536001419E-10,2.9778029345200826E-10,3.6423041646965296E-10,0,0,0]
[]
[null,"К для внесение в ГП",null,null,1.563236370384437,{"$f":"F280","v":1.5453770651656068E-2},{"$f":"G280","v":0.12515418169682338},0.12515418169682338,0.24404073325522035,0.24973580996136469,0.25619056543713775,0.26960639251202767,0.27790073393803083,1.4464521895888907E-10,1.8898011239587405E-10,2.3971665536001419E-10,2.9778029345200826E-10,3.6423041646965296E-10,0,0,0]
[]
[]
[{"$f":"MAX($A$1:A284) + 1","v":15},"РАСЧЕТ КОЭФИЦИЕНТОВ ДЛЯ ГП (СЦЕНАРИИ)"]
[]
[null,"К для внесение в ГП, срок КС - 8 лет (экспл - 5 лет), в том числе",null,null,1.563236370384437,1.5453770651656068E-2,0.12515418169682338,0.12515418169682338,0.24404073325522035,0.24973580996136469,0.25619056543713775,0.26960639251202767,0.27790073393803083,0,0,0,0,0,0,0,0]
[null,"К капитальный грант",null,null,0.2657621340453028,1.5453770651656068E-2,0.12515418169682338,0.12515418169682338,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"К банковские проценты",null,null,0.16528061118379561,0,0,0,5.1104624192869541E-2,4.3139762098809431E-2,3.4179292242991814E-2,2.4098763655197003E-2,1.2758168993927827E-2,0,0,0,0,0,0,0,0]
[null,"К инвестиционного платежа",null,null,0.9951272326076761,0,0,0,0.17772821421332496,0.18712675148431585,0.19770010591418066,0.20959512964777852,0.22297703134807612,0,0,0,0,0,0,0,0]
[null,"К операционного платежа",null,{"$f":"ROUND(SUM(E288:E291),4) = ROUND(E287,4)","v":true},0.13706639254766231,0,0,0,1.5207894849025847E-2,1.9469296378239419E-2,2.4311167279965271E-2,3.5912499209052179E-2,4.2165533596026879E-2,0,0,0,0,0,0,0,0]

{"sheet":"Отчет","index":1,"n_rows":31,"n_cols":6,"rows_kept":31,"cut":false,"hidden":false,"merged":[[0,0,0,5],[29,1,29,5],[30,1,30,5],[3,0,3,5],[10,0,10,5],[16,0,16,5],[20,0,20,5],[26,0,26,5]]}
["Предварительный расчет расходов автономного округа по концессионному соглашению по школе на 801 место с бассейном, дополнительными функциональными помещениями в микрорайоне 42 г. Сургута"]
[]
["№ п/п","Номер сценария",1,2,3,4]
["Вводные данные"]
["1.","Срок соглашения, лет (в т.ч. 1 год проектирование, 2 года строительство)",{"$f":"ПредвРасчет!J6","v":0},{"$f":"ПредвРасчет!K6","v":8},{"$f":"ПредвРасчет!L6","v":0},{"$f":"ПредвРасчет!M6","v":0}]
["2.","Количество лет эксплуатации",{"$f":"ПредвРасчет!J7","v":0},{"$f":"ПредвРасчет!K7","v":5},{"$f":"ПредвРасчет!L7","v":0},{"$f":"ПредвРасчет!M7","v":0}]
["3.","Капит.грант на инвестиционной стадии, в % от капзатрат без НДС",{"$f":"ПредвРасчет!J8","v":0},{"$f":"ПредвРасчет!K8","v":0.3},{"$f":"ПредвРасчет!L8","v":0},{"$f":"ПредвРасчет!M8","v":0}]
["4.","Сумма кап.гранта на инвестиционной стадии, млн. рублей",{"$f":"SUM(ПР_КапГрант)","v":343.94471101694916},{"$f":"SUM(ПР_КапГрант)","v":343.94471101694916},{"$f":"SUM(ПР_КапГрант)","v":343.94471101694916},{"$f":"SUM(ПР_КапГрант)","v":343.94471101694916}]
["5.","Сумма кап.затрат с НДС в ценах соотв-их лет, млн. рублей (*), в том числе",{"$f":"SUM(ПР_CAPEX) + SUM(ПР_проектир)","v":1294.18253},{"$f":"SUM(ПР_CAPEX) + SUM(ПР_проектир)","v":1294.18253},{"$f":"SUM(ПР_CAPEX) + SUM(ПР_проектир)","v":1294.18253},{"$f":"SUM(ПР_CAPEX) + SUM(ПР_проектир)","v":1294.18253}]
["6.","- стоимость проектирования, млн. рублей",{"$f":"SUM(ПР_проектир)","v":20},{"$f":"SUM(ПР_проектир)","v":20},{"$f":"SUM(ПР_проектир)","v":20},{"$f":"SUM(ПР_проектир)","v":20}]
["Номинальные показатели проекта","Номинальные показатели проекта"]
["7.","Расходы бюджета Югры, млн. рублей, в том числе",{"$f":"ПредвРасчет!J17 * -1","v":0},{"$f":"ПредвРасчет!K17 * -1","v":2023.1132008121476},{"$f":"ПредвРасчет!L17 * -1","v":0},{"$f":"ПредвРасчет!M17 * -1","v":0}]
["7.1.","- расходы на эксплуатацию объекта, млн. рублей",{"$f":"SUM(ПР_OPEX_год) * C6","v":0},{"$f":"SUM(ПР_OPEX_год) * D6","v":5},{"$f":"SUM(ПР_OPEX_год) * E6","v":0},{"$f":"SUM(ПР_OPEX_год) * F6","v":0}]
["8.","Удорожание объекта, млн. рублей (п.7 - п.7.1. - п.5)",{"$f":"C12-C9-C13","v":-1294.18253},{"$f":"D12-D9-D13","v":723.93067081214758},-1294.18253,-1294.18253]
["9.","Доходы бюджета, млн. рублей",{"$f":"ПредвРасчет!J18","v":0},{"$f":"ПредвРасчет!K18","v":146.09231548441633},{"$f":"ПредвРасчет!L18","v":0},{"$f":"ПредвРасчет!M18","v":0}]
["10.","Переплата бюджета, млн. рублей (п.8 - п.9)",{"$f":"C14-C15","v":-1294.18253},{"$f":"D14-D15","v":577.83835532773128},-1294.18253,-1294.18253]
["Интегральные показатели проекта","Интегральные показатели проекта"]
["11.","PV бюджета, млн.р.",{"$f":"ПредвРасчет!J12 * -1","v":0},{"$f":"ПредвРасчет!K12 * -1","v":1148.0938145458572},{"$f":"ПредвРасчет!L12 * -1","v":0},{"$f":"ПредвРасчет!M12 * -1","v":0}]
["12.","IRR инвестора",{"$f":"ПредвРасчет!J13","v":0},{"$f":"ПредвРасчет!K13","v":0.14579233910244205},{"$f":"ПредвРасчет!L13","v":0},{"$f":"ПредвРасчет!M13","v":0}]
["13.","IRR проекта для бюджета",{"$f":"ПредвРасчет!J14","v":0},{"$f":"ПредвРасчет!K14","v":0.10505365623262763},{"$f":"ПредвРасчет!L14","v":0},{"$f":"ПредвРасчет!M14","v":0}]
["Показатели проекта при государственном контракте (облигационный займ)","Показатели проекта при государственном контракте"]
["14.","Расходы бюджета Югры, млн. р., в том числе",{"$f":"ПредвРасчет!J22 * -1","v":0},{"$f":"ПредвРасчет!K22 * -1","v":1705.409197615254},{"$f":"ПредвРасчет!L22 * -1","v":0},{"$f":"ПредвРасчет!M22 * -1","v":0}]
["14.1.","- расходы на эксплуатацию объекта, млн. рублей",{"$f":"C13","v":0},{"$f":"D13","v":5},0,0]
["15.","Переплата бюджета, млн. рублей (п.14. - п.14.1. - п.5.)",{"$f":"C22-C9-C13","v":-1294.18253},{"$f":"D22-D9-D13","v":406.22666761525397},-1294.18253,-1294.18253]
["16.","PV бюджета, млн.рублей",{"$f":"ПредвРасчет!J23 * -1","v":0},{"$f":"ПредвРасчет!K23 * -1","v":1077.6306971054557},{"$f":"ПредвРасчет!L23 * -1","v":0},{"$f":"ПредвРасчет!M23 * -1","v":0}]
["17.","Ставка по облигационному займу",{"$f":"ПР_ст_диск","v":0.114},{"$f":"ПР_ст_диск","v":0.114},{"$f":"ПР_ст_диск","v":0.114},{"$f":"ПР_ст_диск","v":0.114}]
["Прочие вводные данные (для информации)","Прочие вводные данные (для информации)"]
["18.","Доля оборудования в капитальных затратах (10%), млн. рублей",{"$f":"C9 * ПР_CAPEX_доля_оборуд","v":129.41825300000002},{"$f":"D9 * ПР_CAPEX_доля_оборуд","v":129.41825300000002},{"$f":"E9 * ПР_CAPEX_доля_оборуд","v":129.41825300000002},{"$f":"F9 * ПР_CAPEX_доля_оборуд","v":129.41825300000002}]
["19.","Доля малоценных предметов* в кап.затратах (6,3%), млн. рублей",{"$f":"C9 * ПР_CAPEX_доля_малоц","v":81.533499390000003},{"$f":"D9 * ПР_CAPEX_доля_малоц","v":81.533499390000003},{"$f":"E9 * ПР_CAPEX_доля_малоц","v":81.533499390000003},{"$f":"F9 * ПР_CAPEX_доля_малоц","v":81.533499390000003}]
["*","капитальные затраты рассчитаны на основе методики "]
["**","малоценные предметы - мебель, инвентарь, комнатные растения, базовый ассортимент лекартсвенных препаратов, посуда, спецодежда и т.п."]

{"sheet":"Inputs","index":2,"n_rows":61,"n_cols":101,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["ШАБЛОН"]
["Начало периода",null,null,null,null,null,null,"НачПериода",null,null,null,null,null,null,null,null,"2016-01-01",{"$f":"Q3+1","v":"2016-04-01"},{"$f":"R3+1","v":"2016-07-01"},"2016-10-01","2017-01-01","2017-04-01","2017-07-01","2017-10-01","2018-01-01","2018-04-01","2018-07-01","2018-10-01","2019-01-01","2019-04-01","2019-07-01","2019-10-01","2020-01-01","2020-04-01","2020-07-01","2020-10-01","2021-01-01","2021-04-01","2021-07-01","2021-10-01","2022-01-01","2022-04-01","2022-07-01","2022-10-01","2023-01-01","2023-04-01","2023-07-01","2023-10-01","2024-01-01","2024-04-01","2024-07-01","2024-10-01","2025-01-01","2025-04-01","2025-07-01","2025-10-01","2026-01-01","2026-04-01","2026-07-01","2026-10-01","2027-01-01","2027-04-01","2027-07-01","2027-10-01","2028-01-01","2028-04-01","2028-07-01","2028-10-01","2029-01-01","2029-04-01","2029-07-01","2029-10-01","2030-01-01","2030-04-01","2030-07-01","2030-10-01","2031-01-01","2031-04-01","2031-07-01","2031-10-01","2032-01-01","2032-04-01",{"$f":"CD3+1","v":"2032-07-01"},"2032-10-01","2033-01-01","2033-04-01","2033-07-01","2033-10-01","2034-01-01","2034-04-01","2034-07-01","2034-10-01","2035-01-01","2035-04-01","2035-07-01","2035-10-01","2036-01-01","2036-04-01","2036-07-01","2036-10-01","НачПериода"]
["Окончание периода",null,null,null,null,null,null,"КонПериода",null,null,null,null,null,null,null,null,{"$f":"EOMONTH(Q2,2)","v":"2016-03-31"},{"$f":"EOMONTH(R2,2)","v":"2016-06-30"},{"$f":"EOMONTH(S2,2)","v":"2016-09-30"},"2016-12-31","2017-03-31","2017-06-30","2017-09-30","2017-12-31","2018-03-31","2018-06-30","2018-09-30","2018-12-31","2019-03-31","2019-06-30","2019-09-30","2019-12-31","2020-03-31","2020-06-30","2020-09-30","2020-12-31","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31","2028-03-31","2028-06-30","2028-09-30","2028-12-31","2029-03-31","2029-06-30","2029-09-30","2029-12-31","2030-03-31","2030-06-30","2030-09-30","2030-12-31","2031-03-31","2031-06-30","2031-09-30","2031-12-31","2032-03-31","2032-06-30",{"$f":"EOMONTH(CE2,2)","v":"2032-09-30"},"2032-12-31","2033-03-31","2033-06-30","2033-09-30","2033-12-31","2034-03-31","2034-06-30","2034-09-30","2034-12-31","2035-03-31","2035-06-30","2035-09-30","2035-12-31","2036-03-31","2036-06-30","2036-09-30","2036-12-31","КонПериода"]
["Номер квартала",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(P4=4,1,P4+1)","v":1},{"$f":"IF(Q4=4,1,Q4+1)","v":2},3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,{"$f":"IF(CC4=4,1,CC4+1)","v":2},3,4,1,2,3,4,1,2,3,4,1,2,3,4,1,2,3,4,"НомерКвартала"]
["Год",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(Q3)","v":2016},{"$f":"YEAR(R3)","v":2016},2016,2016,2017,2017,2017,2017,2018,2018,2018,2018,2019,2019,2019,2019,2020,2020,2020,2020,2021,2021,2021,2021,2022,2022,2022,2022,2023,2023,2023,2023,2024,2024,2024,2024,2025,2025,2025,2025,2026,2026,2026,2026,2027,2027,2027,2027,2028,2028,2028,2028,2029,2029,2029,2029,2030,2030,2030,2030,2031,2031,2031,2031,2032,{"$f":"YEAR(CD3)","v":2032},2032,2032,2033,2033,2033,2033,2034,2034,2034,2034,2035,2035,2035,2035,2036,2036,2036,2036,"Год"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]
[]
[]
[]
["№","п.","Наименование статьи","Ед. измерения","Сумма","PV","Значение","Имена","Источник"]
[]
[{"$f":"MAX($A$1:A17)+1","v":1},null,"Общие допущения"]
[]
[]
[]
[]
[]
[null,null,"Общие сведения"]
[null,null,"Дата создания",null,null,null,"2016-05-30"]
[null,null,"Валюта",null,null,null,"тыс. рублей"]
[null,null,"Количество месяцев в году",null,null,null,12,"Мес_год"]
[null,null,"Количество месяцев в квартале",null,null,null,3,"Мес_кв"]
[null,null,"Допустимая ошибка",null,null,null,1E-3,"ДопОшибка"]
[]
[null,null,"Временные параметры"]
[null,null,"Дата начала модели, заключение КС",null,null,null,"2017-01-01","Старт"]
[null,null,"Дата начала проектирования",null,null,null,{"$f":"Старт","v":"2017-01-01"},"НачПроектир"]
[null,null,"Срок проектирования","месяцы",null,null,null,"СрокПроектир"]
[null,null,"Дата окончания проектирования",null,null,null,{"$f":"EDATE(G33,G34)","v":"2017-01-01"},"КонПроектир"]
[null,null,"Дата начала строительства"]
[null,null,"Срок строительства","месяцы"]
[null,null,"Дата окончания строительства"]
[null,null,"Дата начала комплектации объекта"]
[null,null,"Срок комплектации объекта","месяцы"]
[null,null,"Дата окончания комплектации объекта"]
[null,null,"Дата начала экплуатации объекта"]
[null,null,"Срок эксплуатации объекта","месяцы"]
[null,null,"Дата окончания эксплуатации объекта"]
[null,null,"Длительность эксплуатации","лет"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"MAX($A$1:A60)+1","v":2},null,"Макроэкономические показатели"]

{"sheet":"Шаблон","index":3,"n_rows":25,"n_cols":101,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["ШАБЛОН"]
["Начало периода",null,null,null,null,null,null,"НачПериода",null,null,null,null,null,null,null,null,"2016-01-01",{"$f":"Q3+1","v":"2016-04-01"},{"$f":"R3+1","v":"2016-07-01"},"2016-10-01","2017-01-01","2017-04-01","2017-07-01","2017-10-01","2018-01-01","2018-04-01","2018-07-01","2018-10-01","2019-01-01","2019-04-01","2019-07-01","2019-10-01","2020-01-01","2020-04-01","2020-07-01","2020-10-01","2021-01-01","2021-04-01","2021-07-01","2021-10-01","2022-01-01","2022-04-01","2022-07-01","2022-10-01","2023-01-01","2023-04-01","2023-07-01","2023-10-01","2024-01-01","2024-04-01","2024-07-01","2024-10-01","2025-01-01","2025-04-01","2025-07-01","2025-10-01","2026-01-01","2026-04-01","2026-07-01","2026-10-01","2027-01-01","2027-04-01","2027-07-01","2027-10-01","2028-01-01","2028-04-01","2028-07-01","2028-10-01","2029-01-01","2029-04-01","2029-07-01","2029-10-01","2030-01-01","2030-04-01","2030-07-01","2030-10-01","2031-01-01","2031-04-01","2031-07-01","2031-10-01","2032-01-01","2032-04-01",{"$f":"CD3+1","v":"2032-07-01"},"2032-10-01","2033-01-01","2033-04-01","2033-07-01","2033-10-01","2034-01-01","2034-04-01","2034-07-01","2034-10-01","2035-01-01","2035-04-01","2035-07-01","2035-10-01","2036-01-01","2036-04-01","2036-07-01","2036-10-01","НачПериода"]
["Окончание периода",null,null,null,null,null,null,"КонПериода",null,null,null,null,null,null,null,null,{"$f":"EOMONTH(Q2,2)","v":"2016-03-31"},{"$f":"EOMONTH(R2,2)","v":"2016-06-30"},{"$f":"EOMONTH(S2,2)","v":"2016-09-30"},"2016-12-31","2017-03-31","2017-06-30","2017-09-30","2017-12-31","2018-03-31","2018-06-30","2018-09-30","2018-12-31","2019-03-31","2019-06-30","2019-09-30","2019-12-31","2020-03-31","2020-06-30","2020-09-30","2020-12-31","2021-03-31","2021-06-30","2021-09-30","2021-12-31","2022-03-31","2022-06-30","2022-09-30","2022-12-31","2023-03-31","2023-06-30","2023-09-30","2023-12-31","2024-03-31","2024-06-30","2024-09-30","2024-12-31","2025-03-31","2025-06-30","2025-09-30","2025-12-31","2026-03-31","2026-06-30","2026-09-30","2026-12-31","2027-03-31","2027-06-30","2027-09-30","2027-12-31","2028-03-31","2028-06-30","2028-09-30","2028-12-31","2029-03-31","2029-06-30","2029-09-30","2029-12-31","2030-03-31","2030-06-30","2030-09-30","2030-12-31","2031-03-31","2031-06-30","2031-09-30","2031-12-31","2032-03-31","2032-06-30",{"$f":"EOMONTH(CE2,2)","v":"2032-09-30"},"2032-12-31","2033-03-31","2033-06-30","2033-09-30","2033-12-31","2034-03-31","2034-06-30","2034-09-30","2034-12-31","2035-03-31","2035-06-30","2035-09-30","2035-12-31","2036-03-31","2036-06-30","2036-09-30","2036-12-31","КонПериода"]
["Номер квартала",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Номер_квартала","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$f":"Номер_квартала","v":{"$error":"#NAME?"}},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},{"$error":"#NAME?"},"НомерКвартала"]
["Год",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"YEAR(Q3)","v":2016},{"$f":"YEAR(R3)","v":2016},2016,2016,2017,2017,2017,2017,2018,2018,2018,2018,2019,2019,2019,2019,2020,2020,2020,2020,2021,2021,2021,2021,2022,2022,2022,2022,2023,2023,2023,2023,2024,2024,2024,2024,2025,2025,2025,2025,2026,2026,2026,2026,2027,2027,2027,2027,2028,2028,2028,2028,2029,2029,2029,2029,2030,2030,2030,2030,2031,2031,2031,2031,2032,{"$f":"YEAR(CD3)","v":2032},2032,2032,2033,2033,2033,2033,2034,2034,2034,2034,2035,2035,2035,2035,2036,2036,2036,2036,"Год"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4,5,6,7]
[]
[]
[]
["№","п.","Наименование статьи","Ед. измерения","Сумма","PV","Значение","Имена","Источник","Проверка"]
[]
[{"$f":"MAX($A$1:A17)+1","v":1},null,"Шаблон 1"]
[]
[]
[]
[]
[]
[]
[{"$f":"MAX($A$1:A24)+1","v":2},null,"Шаблон 2"]