|
|
|
|
|
|
|
|
|
|
Строка
| 4.2007
| 5.2007
| 6.2007
| 7.2007
| 8.2007
| 9.2007
| 10.2007
| 11.2007
| 12.2007
|
|
|
|
|
|
|
|
|
|
|
Валовый объем продаж
| ~PE_Get( 17,0,0){}
| ~PE_Get( 17,0,1){}
| ~PE_Get( 17,0,2){}
| ~PE_Get( 17,0,3){}
| ~PE_Get( 17,0,4){}
| ~PE_Get( 17,0,5){}
| ~PE_Get( 18,0,6){}
| ~PE_Get( 18,0,7){3 150 000,00}
| ~PE_Get( 18,0,8){1 000 000,00}
|
Потери
| ~PE_Get( 17,1,0){}
| ~PE_Get( 17,1,1){}
| ~PE_Get( 17,1,2){}
| ~PE_Get( 17,1,3){}
| ~PE_Get( 17,1,4){}
| ~PE_Get( 17,1,5){}
| ~PE_Get( 18,1,6){}
| ~PE_Get( 18,1,7){}
| ~PE_Get( 18,1,8){}
|
Налоги с продаж
| ~PE_Get( 17,2,0){}
| ~PE_Get( 17,2,1){}
| ~PE_Get( 17,2,2){}
| ~PE_Get( 17,2,3){}
| ~PE_Get( 17,2,4){}
| ~PE_Get( 17,2,5){}
| ~PE_Get( 18,2,6){}
| ~PE_Get( 18,2,7){}
| ~PE_Get( 18,2,8){}
|
Чистый объем продаж
| ~PE_Get( 17,3,0){}
| ~PE_Get( 17,3,1){}
| ~PE_Get( 17,3,2){}
| ~PE_Get( 17,3,3){}
| ~PE_Get( 17,3,4){}
| ~PE_Get( 17,3,5){}
| ~PE_Get( 18,3,6){}
| ~PE_Get( 18,3,7){3 150 000,00}
| ~PE_Get( 18,3,8){1 000 000,00}
|
Материалы и комплектующие
| ~PE_Get( 17,4,0){}
| ~PE_Get( 17,4,1){}
| ~PE_Get( 17,4,2){}
| ~PE_Get( 17,4,3){}
| ~PE_Get( 17,4,4){}
| ~PE_Get( 17,4,5){}
| ~PE_Get( 18,4,6){}
| ~PE_Get( 18,4,7){2 083 500,00}
| ~PE_Get( 18,4,8){313 800,00}
|
Сдельная зарплата
| ~PE_Get( 17,5,0){}
| ~PE_Get( 17,5,1){}
| ~PE_Get( 17,5,2){}
| ~PE_Get( 17,5,3){}
| ~PE_Get( 17,5,4){}
| ~PE_Get( 17,5,5){}
| ~PE_Get( 18,5,6){}
| ~PE_Get( 18,5,7){}
| ~PE_Get( 18,5,8){}
|
Суммарные прямые издержки
| ~PE_Get( 17,6,0){}
| ~PE_Get( 17,6,1){}
| ~PE_Get( 17,6,2){}
| ~PE_Get( 17,6,3){}
| ~PE_Get( 17,6,4){}
| ~PE_Get( 17,6,5){}
| ~PE_Get( 18,6,6){}
| ~PE_Get( 18,6,7){2 083 500,00}
| ~PE_Get( 18,6,8){313 800,00}
|
Валовая прибыль
| ~PE_Get( 17,7,0){}
| ~PE_Get( 17,7,1){}
| ~PE_Get( 17,7,2){}
| ~PE_Get( 17,7,3){}
| ~PE_Get( 17,7,4){}
| ~PE_Get( 17,7,5){}
| ~PE_Get( 18,7,6){}
| ~PE_Get( 18,7,7){1 066 500,00}
| ~PE_Get( 18,7,8){686 200,00}
|
Налог на имущество
| ~PE_Get( 17,8,0){10 000,00}
| ~PE_Get( 17,8,1){10 000,00}
| ~PE_Get( 17,8,2){10 000,00}
| ~PE_Get( 17,8,3){10 000,00}
| ~PE_Get( 17,8,4){10 000,00}
| ~PE_Get( 17,8,5){10 000,00}
| ~PE_Get( 18,8,6){10 000,00}
| ~PE_Get( 18,8,7){10 000,00}
| ~PE_Get( 18,8,8){10 000,00}
|
Административные издержки
| ~PE_Get( 17,9,0){40 000,00}
| ~PE_Get( 17,9,1){}
| ~PE_Get( 17,9,2){}
| ~PE_Get( 17,9,3){40 000,00}
| ~PE_Get( 17,9,4){}
| ~PE_Get( 17,9,5){}
| ~PE_Get( 18,9,6){40 000,00}
| ~PE_Get( 18,9,7){}
| ~PE_Get( 18,9,8){}
|
Производственные издержки
| ~PE_Get( 17,10,0){}
| ~PE_Get( 17,10,1){1 100 000,00}
| ~PE_Get( 17,10,2){500 300,00}
| ~PE_Get( 17,10,3){500 300,00}
| ~PE_Get( 17,10,4){500 410,00}
| ~PE_Get( 17,10,5){1 200 410,00}
| ~PE_Get( 18,10,6){100 410,00}
| ~PE_Get( 18,10,7){116 410,00}
| ~PE_Get( 18,10,8){78 410,00}
|
Маркетинговые издержки
| ~PE_Get( 17,11,0){}
| ~PE_Get( 17,11,1){}
| ~PE_Get( 17,11,2){}
| ~PE_Get( 17,11,3){}
| ~PE_Get( 17,11,4){}
| ~PE_Get( 17,11,5){}
| ~PE_Get( 18,11,6){}
| ~PE_Get( 18,11,7){126 000,00}
| ~PE_Get( 18,11,8){40 000,00}
|
Зарплата административного персонала
| ~PE_Get( 17,12,0){24 508,00}
| ~PE_Get( 17,12,1){33 420,00}
| ~PE_Get( 17,12,2){42 332,00}
| ~PE_Get( 17,12,3){42 332,00}
| ~PE_Get( 17,12,4){42 332,00}
| ~PE_Get( 17,12,5){42 332,00}
| ~PE_Get( 18,12,6){42 332,00}
| ~PE_Get( 18,12,7){42 332,00}
| ~PE_Get( 18,12,8){42 332,00}
|
Зарплата производственного персонала
| ~PE_Get( 17,13,0){}
| ~PE_Get( 17,13,1){23 839,60}
| ~PE_Get( 17,13,2){50 678,09}
| ~PE_Get( 17,13,3){91 012,69}
| ~PE_Get( 17,13,4){91 012,69}
| ~PE_Get( 17,13,5){105 545,93}
| ~PE_Get( 18,13,6){105 545,93}
| ~PE_Get( 18,13,7){105 545,93}
| ~PE_Get( 18,13,8){105 545,93}
|
Зарплата маркетингового персонала
| ~PE_Get( 17,14,0){}
| ~PE_Get( 17,14,1){}
| ~PE_Get( 17,14,2){}
| ~PE_Get( 17,14,3){}
| ~PE_Get( 17,14,4){}
| ~PE_Get( 17,14,5){}
| ~PE_Get( 18,14,6){}
| ~PE_Get( 18,14,7){}
| ~PE_Get( 18,14,8){}
|
Суммарные постоянные издержки
| ~PE_Get( 17,15,0){64 508,00}
| ~PE_Get( 17,15,1){1 157 259,60}
| ~PE_Get( 17,15,2){593 310,09}
| ~PE_Get( 17,15,3){673 644,69}
| ~PE_Get( 17,15,4){633 754,69}
| ~PE_Get( 17,15,5){1 348 287,93}
| ~PE_Get( 18,15,6){288 287,93}
| ~PE_Get( 18,15,7){390 287,93}
| ~PE_Get( 18,15,8){266 287,93}
|
Амортизация
| ~PE_Get( 17,16,0){}
| ~PE_Get( 17,16,1){}
| ~PE_Get( 17,16,2){501 000,00}
| ~PE_Get( 17,16,3){20 166,67}
| ~PE_Get( 17,16,4){31 416,67}
| ~PE_Get( 17,16,5){70 861,11}
| ~PE_Get( 18,16,6){108 250,00}
| ~PE_Get( 18,16,7){131 861,11}
| ~PE_Get( 18,16,8){131 861,11}
|
Проценты по кредитам
| ~PE_Get( 17,17,0){}
| ~PE_Get( 17,17,1){105 368,42}
| ~PE_Get( 17,17,2){175 368,42}
| ~PE_Get( 17,17,3){245 368,42}
| ~PE_Get( 17,17,4){315 368,42}
| ~PE_Get( 17,17,5){350 368,42}
| ~PE_Get( 18,17,6){350 368,42}
| ~PE_Get( 18,17,7){350 368,42}
| ~PE_Get( 18,17,8){350 368,42}
|
Суммарные непроизводственные издержки
| ~PE_Get( 17,18,0){}
| ~PE_Get( 17,18,1){105 368,42}
| ~PE_Get( 17,18,2){676 368,42}
| ~PE_Get( 17,18,3){265 535,09}
| ~PE_Get( 17,18,4){346 785,09}
| ~PE_Get( 17,18,5){421 229,53}
| ~PE_Get( 18,18,6){458 618,42}
| ~PE_Get( 18,18,7){482 229,53}
| ~PE_Get( 18,18,8){482 229,53}
|
Другие доходы
| ~PE_Get( 17,19,0){}
| ~PE_Get( 17,19,1){}
| ~PE_Get( 17,19,2){}
| ~PE_Get( 17,19,3){}
| ~PE_Get( 17,19,4){}
| ~PE_Get( 17,19,5){}
| ~PE_Get( 18,19,6){}
| ~PE_Get( 18,19,7){}
| ~PE_Get( 18,19,8){}
|
Другие издержки
| ~PE_Get( 17,20,0){2 241 111,11}
| ~PE_Get( 17,20,1){38 888,89}
| ~PE_Get( 17,20,2){911 764,71}
| ~PE_Get( 17,20,3){895 673,31}
| ~PE_Get( 17,20,4){307 438,02}
| ~PE_Get( 17,20,5){307 438,02}
| ~PE_Get( 18,20,6){277 685,95}
| ~PE_Get( 18,20,7){}
| ~PE_Get( 18,20,8){}
|
Убытки предыдущих периодов
| ~PE_Get( 17,21,0){}
| ~PE_Get( 17,21,1){}
| ~PE_Get( 17,21,2){}
| ~PE_Get( 17,21,3){}
| ~PE_Get( 17,21,4){}
| ~PE_Get( 17,21,5){}
| ~PE_Get( 18,21,6){}
| ~PE_Get( 18,21,7){}
| ~PE_Get( 18,21,8){}
|
Прибыль до выплаты налога
| ~PE_Get( 17,22,0){-2 315 619,11}
| ~PE_Get( 17,22,1){-1 311 516,91}
| ~PE_Get( 17,22,2){-2 191 443,21}
| ~PE_Get( 17,22,3){-1 844 853,08}
| ~PE_Get( 17,22,4){-1 297 977,79}
| ~PE_Get( 17,22,5){-2 086 955,48}
| ~PE_Get( 18,22,6){-1 034 592,30}
| ~PE_Get( 18,22,7){183 982,54}
| ~PE_Get( 18,22,8){-72 317,46}
|
Суммарные издержки, отнесенные на прибыль
| ~PE_Get( 17,23,0){}
| ~PE_Get( 17,23,1){14 300,00}
| ~PE_Get( 17,23,2){23 800,00}
| ~PE_Get( 17,23,3){33 300,00}
| ~PE_Get( 17,23,4){42 800,00}
| ~PE_Get( 17,23,5){47 550,00}
| ~PE_Get( 18,23,6){47 550,00}
| ~PE_Get( 18,23,7){47 550,00}
| ~PE_Get( 18,23,8){47 550,00}
|
Прибыль от курсовой разницы
| ~PE_Get( 17,24,0){}
| ~PE_Get( 17,24,1){}
| ~PE_Get( 17,24,2){}
| ~PE_Get( 17,24,3){}
| ~PE_Get( 17,24,4){}
| ~PE_Get( 17,24,5){}
| ~PE_Get( 18,24,6){}
| ~PE_Get( 18,24,7){}
| ~PE_Get( 18,24,8){}
|
Налогооблагаемая прибыль
| ~PE_Get( 17,25,0){}
| ~PE_Get( 17,25,1){}
| ~PE_Get( 17,25,2){}
| ~PE_Get( 17,25,3){}
| ~PE_Get( 17,25,4){}
| ~PE_Get( 17,25,5){}
| ~PE_Get( 18,25,6){}
| ~PE_Get( 18,25,7){}
| ~PE_Get( 18,25,8){}
|
Налог на прибыль
| ~PE_Get( 17,26,0){}
| ~PE_Get( 17,26,1){}
| ~PE_Get( 17,26,2){}
| ~PE_Get( 17,26,3){}
| ~PE_Get( 17,26,4){}
| ~PE_Get( 17,26,5){}
| ~PE_Get( 18,26,6){}
| ~PE_Get( 18,26,7){}
| ~PE_Get( 18,26,8){}
|
Чистая прибыль
| ~PE_Get( 17,27,0){-2 315 619,11}
| ~PE_Get( 17,27,1){-1 311 516,91}
| ~PE_Get( 17,27,2){-2 191 443,21}
| ~PE_Get( 17,27,3){-1 844 853,08}
| ~PE_Get( 17,27,4){-1 297 977,79}
| ~PE_Get( 17,27,5){-2 086 955,48}
| ~PE_Get( 18,27,6){-1 034 592,30}
| ~PE_Get( 18,27,7){183 982,54}
| ~PE_Get( 18,27,8){-72 317,46}
|
