| Строка | 3кв. 2011г. | 4кв. 2011г. | 1кв. 2012г. | 2кв. 2012г. | 3кв. 2012г. | 4кв. 2012г. |
| Поступления от продаж | ~PE_Get( 22,0,6){30,072,693} | ~PE_Get( 22,0,7){28,440,997} | ~PE_Get( 22,0,8){27,002,463} | ~PE_Get( 22,0,9){79,152,389} | ~PE_Get( 22,0,10){74,857,708} | ~PE_Get( 22,0,11){70,796,049} |
| Затраты на материалы и комплектующие | ~PE_Get( 22,1,6){16,250,968} | ~PE_Get( 22,1,7){15,369,217} | ~PE_Get( 22,1,8){14,544,634} | ~PE_Get( 22,1,9){44,652,340} | ~PE_Get( 22,1,10){41,972,106} | ~PE_Get( 22,1,11){39,694,767} |
| Суммарные прямые издержки | ~PE_Get( 22,3,6){16,250,968} | ~PE_Get( 22,3,7){15,369,217} | ~PE_Get( 22,3,8){14,544,634} | ~PE_Get( 22,3,9){44,652,340} | ~PE_Get( 22,3,10){41,972,106} | ~PE_Get( 22,3,11){39,694,767} |
| Общие издержки | ~PE_Get( 22,4,6){1,124,747} | ~PE_Get( 22,4,7){578,895} | ~PE_Get( 22,4,8){556,072} | ~PE_Get( 22,4,9){5,399,291} | ~PE_Get( 22,4,10){5,106,334} | ~PE_Get( 22,4,11){4,829,273} |
| Затраты на персонал | ~PE_Get( 22,5,6){2,715,048} | ~PE_Get( 22,5,7){2,567,734} | ~PE_Get( 22,5,8){2,428,413} | ~PE_Get( 22,5,9){5,083,225} | ~PE_Get( 22,5,10){4,807,417} | ~PE_Get( 22,5,11){4,546,574} |
| Суммарные постоянные издержки | ~PE_Get( 22,6,6){3,839,795} | ~PE_Get( 22,6,7){3,146,629} | ~PE_Get( 22,6,8){2,984,484} | ~PE_Get( 22,6,9){10,482,516} | ~PE_Get( 22,6,10){9,913,751} | ~PE_Get( 22,6,11){9,375,847} |
| Другие поступления | ~PE_Get( 22,9,6){4,890,092} | ~PE_Get( 22,9,7){} | ~PE_Get( 22,9,8){4,293,251} | ~PE_Get( 22,9,9){} | ~PE_Get( 22,9,10){} | ~PE_Get( 22,9,11){} |
| Другие выплаты | ~PE_Get( 22,10,6){} | ~PE_Get( 22,10,7){} | ~PE_Get( 22,10,8){} | ~PE_Get( 22,10,9){} | ~PE_Get( 22,10,10){} | ~PE_Get( 22,10,11){} |
| Налоги | ~PE_Get( 22,11,6){4,846,835} | ~PE_Get( 22,11,7){2,797,008} | ~PE_Get( 22,11,8){3,018,741} | ~PE_Get( 22,11,9){6,758,067} | ~PE_Get( 22,11,10){9,052,830} | ~PE_Get( 22,11,11){8,565,055} |
| Кэш-фло от операционной деятельности | ~PE_Get( 22,12,6){10,025,187} | ~PE_Get( 22,12,7){7,128,143} | ~PE_Get( 22,12,8){10,747,854} | ~PE_Get( 22,12,9){17,259,467} | ~PE_Get( 22,12,10){13,919,021} | ~PE_Get( 22,12,11){13,160,380} |
| Затраты на приобретение активов | ~PE_Get( 22,13,6){35,254,102} | ~PE_Get( 22,13,7){9,018,056} | ~PE_Get( 22,13,8){} | ~PE_Get( 22,13,9){} | ~PE_Get( 22,13,10){} | ~PE_Get( 22,13,11){} |
| Другие издержки подготовительного периода | ~PE_Get( 22,14,6){1,650,510} | ~PE_Get( 22,14,7){2,363,476} | ~PE_Get( 22,14,8){3,495,504} | ~PE_Get( 22,14,9){} | ~PE_Get( 22,14,10){} | ~PE_Get( 22,14,11){} |
| Кэш-фло от инвестиционной деятельности | ~PE_Get( 22,19,6){-36,904,612} | ~PE_Get( 22,19,7){-11,381,532} | ~PE_Get( 22,19,8){-3,495,504} | ~PE_Get( 22,19,9){} | ~PE_Get( 22,19,10){} | ~PE_Get( 22,19,11){} |
| Займы | ~PE_Get( 22,21,6){36,675,694} | ~PE_Get( 22,21,7){12,564,180} | ~PE_Get( 22,21,8){} | ~PE_Get( 22,21,9){} | ~PE_Get( 22,21,10){} | ~PE_Get( 22,21,11){} |
| Выплаты в погашение займов | ~PE_Get( 22,22,6){} | ~PE_Get( 22,22,7){} | ~PE_Get( 22,22,8){} | ~PE_Get( 22,22,9){591,993} | ~PE_Get( 22,22,10){847,714} | ~PE_Get( 22,22,11){3,417,918} |
| Выплаты процентов по займам | ~PE_Get( 22,23,6){2,843,778} | ~PE_Get( 22,23,7){3,792,744} | ~PE_Get( 22,23,8){3,586,955} | ~PE_Get( 22,23,9){3,380,530} | ~PE_Get( 22,23,10){3,163,199} | ~PE_Get( 22,23,11){2,899,364} |
| Кэш-фло от финансовой деятельности | ~PE_Get( 22,26,6){33,831,916} | ~PE_Get( 22,26,7){8,771,436} | ~PE_Get( 22,26,8){-3,586,955} | ~PE_Get( 22,26,9){-3,972,522} | ~PE_Get( 22,26,10){-4,010,913} | ~PE_Get( 22,26,11){-6,317,282} |
| Баланс наличности на начало периода | ~PE_Get( 22,27,6){18,570,967} | ~PE_Get( 22,27,7){25,395,369} | ~PE_Get( 22,27,8){29,830,178} | ~PE_Get( 22,27,9){33,428,043} | ~PE_Get( 22,27,10){46,470,196} | ~PE_Get( 22,27,11){56,195,762} |
| Баланс наличности на конец периода | ~PE_Get( 22,28,6){25,869,769} | ~PE_Get( 22,28,7){30,387,816} | ~PE_Get( 22,28,8){34,053,210} | ~PE_Get( 22,28,9){47,340,155} | ~PE_Get( 22,28,10){57,248,263} | ~PE_Get( 22,28,11){64,091,361} |
Дисконтированный Отчет о движении денежных средств (руб.)
| Строка | 2013 год | 2014 год | 2015 год | 2016 год |
| Поступления от продаж | ~PE_Get( 23,0,12){247,203,794} | ~PE_Get( 23,0,13){197,763,035} | ~PE_Get( 23,0,14){158,210,428} | ~PE_Get( 23,0,15){126,568,343} |
| Затраты на материалы и комплектующие | ~PE_Get( 23,1,12){138,577,017} | ~PE_Get( 23,1,13){110,861,243} | ~PE_Get( 23,1,14){88,688,995} | ~PE_Get( 23,1,15){70,951,196} |
| Суммарные прямые издержки | ~PE_Get( 23,3,12){138,577,017} | ~PE_Get( 23,3,13){110,861,243} | ~PE_Get( 23,3,14){88,688,995} | ~PE_Get( 23,3,15){70,951,196} |
| Общие издержки | ~PE_Get( 23,4,12){16,835,162} | ~PE_Get( 23,4,13){13,468,130} | ~PE_Get( 23,4,14){10,774,504} | ~PE_Get( 23,4,15){8,619,603} |
| Затраты на персонал | ~PE_Get( 23,5,12){15,849,658} | ~PE_Get( 23,5,13){12,679,726} | ~PE_Get( 23,5,14){10,143,781} | ~PE_Get( 23,5,15){8,115,025} |
| Суммарные постоянные издержки | ~PE_Get( 23,6,12){32,684,820} | ~PE_Get( 23,6,13){26,147,856} | ~PE_Get( 23,6,14){20,918,285} | ~PE_Get( 23,6,15){16,734,628} |
| Другие поступления | ~PE_Get( 23,9,12){} | ~PE_Get( 23,9,13){} | ~PE_Get( 23,9,14){} | ~PE_Get( 23,9,15){} |
| Другие выплаты | ~PE_Get( 23,10,12){} | ~PE_Get( 23,10,13){} | ~PE_Get( 23,10,14){} | ~PE_Get( 23,10,15){} |
| Налоги | ~PE_Get( 23,11,12){30,247,004} | ~PE_Get( 23,11,13){25,081,845} | ~PE_Get( 23,11,14){20,733,727} | ~PE_Get( 23,11,15){16,811,039} |
| Кэш-фло от операционной деятельности | ~PE_Get( 23,12,12){45,694,954} | ~PE_Get( 23,12,13){35,672,091} | ~PE_Get( 23,12,14){27,869,422} | ~PE_Get( 23,12,15){22,071,480} |
| Затраты на приобретение активов | ~PE_Get( 23,13,12){} | ~PE_Get( 23,13,13){} | ~PE_Get( 23,13,14){} | ~PE_Get( 23,13,15){} |
| Другие издержки подготовительного периода | ~PE_Get( 23,14,12){} | ~PE_Get( 23,14,13){} | ~PE_Get( 23,14,14){} | ~PE_Get( 23,14,15){} |
| Кэш-фло от инвестиционной деятельности | ~PE_Get( 23,19,12){} | ~PE_Get( 23,19,13){} | ~PE_Get( 23,19,14){} | ~PE_Get( 23,19,15){} |
| Займы | ~PE_Get( 23,21,12){} | ~PE_Get( 23,21,13){} | ~PE_Get( 23,21,14){} | ~PE_Get( 23,21,15){} |
| Выплаты в погашение займов | ~PE_Get( 23,22,12){19,454,441} | ~PE_Get( 23,22,13){15,769,088} | ~PE_Get( 23,22,14){12,615,270} | ~PE_Get( 23,22,15){1,712,821} |
| Выплаты процентов по займам | ~PE_Get( 23,23,12){8,299,697} | ~PE_Get( 23,23,13){4,116,703} | ~PE_Get( 23,23,14){1,274,919} | ~PE_Get( 23,23,15){10,638} |
| Кэш-фло от финансовой деятельности | ~PE_Get( 23,26,12){-27,754,138} | ~PE_Get( 23,26,13){-19,885,791} | ~PE_Get( 23,26,14){-13,890,190} | ~PE_Get( 23,26,15){-1,723,459} |
| Баланс наличности на начало периода | ~PE_Get( 23,27,12){62,912,786} | ~PE_Get( 23,27,13){80,523,070} | ~PE_Get( 23,27,14){96,018,531} | ~PE_Get( 23,27,15){109,740,218} |
| Баланс наличности на конец периода | ~PE_Get( 23,28,12){82,032,176} | ~PE_Get( 23,28,13){97,818,476} | ~PE_Get( 23,28,14){111,797,709} | ~PE_Get( 23,28,15){132,145,730} |
Прогнозный Бухгалтерский баланс (руб.)
| Строка | 9/2010 | 10/2010 | 11/2010 | 12/2010 | 1кв. 2011г. | 2кв. 2011г. |
| Денежные средства | ~PE_Get( 24,0,0){7,138,382} | ~PE_Get( 24,0,1){9,026,209} | ~PE_Get( 24,0,2){11,005,904} | ~PE_Get( 24,0,3){13,128,758} | ~PE_Get( 24,0,4){14,350,617} | ~PE_Get( 24,0,5){20,009,333} |
| Счета к получению | ~PE_Get( 24,1,0){585,000} | ~PE_Get( 24,1,1){390,000} | ~PE_Get( 24,1,2){195,000} | ~PE_Get( 24,1,3){} | ~PE_Get( 24,1,4){} | ~PE_Get( 24,1,5){} |
| Сырье, материалы и комплектующие | ~PE_Get( 24,2,0){3,190,630} | ~PE_Get( 24,2,1){3,232,581} | ~PE_Get( 24,2,2){3,232,581} | ~PE_Get( 24,2,3){3,232,581} | ~PE_Get( 24,2,4){3,232,581} | ~PE_Get( 24,2,5){3,232,581} |
| Незавершенное производство | ~PE_Get( 24,3,0){} | ~PE_Get( 24,3,1){} | ~PE_Get( 24,3,2){} | ~PE_Get( 24,3,3){} | ~PE_Get( 24,3,4){} | ~PE_Get( 24,3,5){} |
| Краткосрочные предоплаченные расходы | ~PE_Get( 24,6,0){49,000} | ~PE_Get( 24,6,1){31,000} | ~PE_Get( 24,6,2){13,000} | ~PE_Get( 24,6,3){6,667} | ~PE_Get( 24,6,4){} | ~PE_Get( 24,6,5){} |
| Суммарные текущие активы | ~PE_Get( 24,7,0){10,963,011} | ~PE_Get( 24,7,1){12,679,790} | ~PE_Get( 24,7,2){14,446,485} | ~PE_Get( 24,7,3){16,368,005} | ~PE_Get( 24,7,4){17,583,198} | ~PE_Get( 24,7,5){23,241,913} |
| Основные средства | ~PE_Get( 24,8,0){64,907,640} | ~PE_Get( 24,8,1){64,907,640} | ~PE_Get( 24,8,2){64,907,640} | ~PE_Get( 24,8,3){64,907,640} | ~PE_Get( 24,8,4){64,907,640} | ~PE_Get( 24,8,5){64,907,640} |
| Накопленная амортизация | ~PE_Get( 24,9,0){12,694,748} | ~PE_Get( 24,9,1){13,344,368} | ~PE_Get( 24,9,2){13,993,988} | ~PE_Get( 24,9,3){14,643,608} | ~PE_Get( 24,9,4){16,592,467} | ~PE_Get( 24,9,5){18,541,327} |
| Остаточная стоимость основных средств: | ~PE_Get( 24,10,0){52,212,892} | ~PE_Get( 24,10,1){51,563,272} | ~PE_Get( 24,10,2){50,913,652} | ~PE_Get( 24,10,3){50,264,032} | ~PE_Get( 24,10,4){48,315,173} | ~PE_Get( 24,10,5){46,366,313} |
| Здания и сооружения | ~PE_Get( 24,12,0){27,819,857} | ~PE_Get( 24,12,1){27,756,773} | ~PE_Get( 24,12,2){27,693,690} | ~PE_Get( 24,12,3){27,630,606} | ~PE_Get( 24,12,4){27,441,355} | ~PE_Get( 24,12,5){27,252,105} |
| Оборудование | ~PE_Get( 24,13,0){24,108,402} | ~PE_Get( 24,13,1){23,547,741} | ~PE_Get( 24,13,2){22,987,081} | ~PE_Get( 24,13,3){22,426,420} | ~PE_Get( 24,13,4){20,744,439} | ~PE_Get( 24,13,5){19,062,457} |
| Другие активы | ~PE_Get( 24,15,0){284,633} | ~PE_Get( 24,15,1){258,757} | ~PE_Get( 24,15,2){232,882} | ~PE_Get( 24,15,3){207,006} | ~PE_Get( 24,15,4){129,379} | ~PE_Get( 24,15,5){51,751} |
| Инвестиции в основные фонды | ~PE_Get( 24,16,0){} | ~PE_Get( 24,16,1){} | ~PE_Get( 24,16,2){} | ~PE_Get( 24,16,3){} | ~PE_Get( 24,16,4){31,188,499} | ~PE_Get( 24,16,5){87,446,719} |
| СУММАРНЫЙ АКТИВ | ~PE_Get( 24,19,0){63,175,903} | ~PE_Get( 24,19,1){64,243,062} | ~PE_Get( 24,19,2){65,360,137} | ~PE_Get( 24,19,3){66,632,037} | ~PE_Get( 24,19,4){97,086,869} | ~PE_Get( 24,19,5){157,054,946} |
| Отсроченные налоговые платежи | ~PE_Get( 24,20,0){1,698,733} | ~PE_Get( 24,20,1){1,342,746} | ~PE_Get( 24,20,2){1,301,830} | ~PE_Get( 24,20,3){1,362,904} | ~PE_Get( 24,20,4){3,023,468} | ~PE_Get( 24,20,5){1,456,631} |
| Краткосрочные займы | ~PE_Get( 24,21,0){} | ~PE_Get( 24,21,1){} | ~PE_Get( 24,21,2){} | ~PE_Get( 24,21,3){} | ~PE_Get( 24,21,4){} | ~PE_Get( 24,21,5){433,333} |
| Счета к оплате | ~PE_Get( 24,22,0){96,750} | ~PE_Get( 24,22,1){64,500} | ~PE_Get( 24,22,2){32,250} | ~PE_Get( 24,22,3){} | ~PE_Get( 24,22,4){} | ~PE_Get( 24,22,5){} |
| Суммарные краткосрочные обязательства | ~PE_Get( 24,24,0){1,795,483} | ~PE_Get( 24,24,1){1,407,246} | ~PE_Get( 24,24,2){1,334,080} | ~PE_Get( 24,24,3){1,362,904} | ~PE_Get( 24,24,4){3,023,468} | ~PE_Get( 24,24,5){1,889,964} |
| Долгосрочные займы | ~PE_Get( 24,25,0){} | ~PE_Get( 24,25,1){} | ~PE_Get( 24,25,2){} | ~PE_Get( 24,25,3){} | ~PE_Get( 24,25,4){19,500,000} | ~PE_Get( 24,25,5){61,566,667} |
| Резервные фонды | ~PE_Get( 24,29,0){50,000} | ~PE_Get( 24,29,1){50,000} | ~PE_Get( 24,29,2){50,000} | ~PE_Get( 24,29,3){50,000} | ~PE_Get( 24,29,4){50,000} | ~PE_Get( 24,29,5){50,000} |
| Добавочный капитал | ~PE_Get( 24,30,0){59,478,496} | ~PE_Get( 24,30,1){59,478,496} | ~PE_Get( 24,30,2){59,478,496} | ~PE_Get( 24,30,3){59,478,496} | ~PE_Get( 24,30,4){59,478,496} | ~PE_Get( 24,30,5){59,478,496} |
| Нераспределенная прибыль | ~PE_Get( 24,31,0){1,851,924} | ~PE_Get( 24,31,1){3,307,320} | ~PE_Get( 24,31,2){4,497,561} | ~PE_Get( 24,31,3){5,740,638} | ~PE_Get( 24,31,4){15,034,906} | ~PE_Get( 24,31,5){34,069,819} |
| Суммарный собственный капитал | ~PE_Get( 24,32,0){61,380,420} | ~PE_Get( 24,32,1){62,835,816} | ~PE_Get( 24,32,2){64,026,057} | ~PE_Get( 24,32,3){65,269,134} | ~PE_Get( 24,32,4){74,563,402} | ~PE_Get( 24,32,5){93,598,315} |
| СУММАРНЫЙ ПАССИВ | ~PE_Get( 24,33,0){63,175,903} | ~PE_Get( 24,33,1){64,243,062} | ~PE_Get( 24,33,2){65,360,137} | ~PE_Get( 24,33,3){66,632,037} | ~PE_Get( 24,33,4){97,086,869} | ~PE_Get( 24,33,5){157,054,946} |
Прогнозный Бухгалтерский баланс (руб.)