|
|
|
|
|
|
|
|
|
|
Строка
| 1.2008
| 2.2008
| 3.2008
| 4.2008
| 5.2008
| 6.2008
| 7.2008
| 8.2008
| 9.2008
|
|
|
|
|
|
|
|
|
|
|
Валовый объем продаж
| ~PE_Get( 18,0,9){}
| ~PE_Get( 18,0,10){}
| ~PE_Get( 18,0,11){}
| ~PE_Get( 19,0,12){6 300 000,00}
| ~PE_Get( 19,0,13){6 399 000,00}
| ~PE_Get( 19,0,14){5 850 000,00}
| ~PE_Get( 19,0,15){}
| ~PE_Get( 19,0,16){}
| ~PE_Get( 19,0,17){}
|
Потери
| ~PE_Get( 18,1,9){}
| ~PE_Get( 18,1,10){}
| ~PE_Get( 18,1,11){}
| ~PE_Get( 19,1,12){}
| ~PE_Get( 19,1,13){}
| ~PE_Get( 19,1,14){}
| ~PE_Get( 19,1,15){}
| ~PE_Get( 19,1,16){}
| ~PE_Get( 19,1,17){}
|
Налоги с продаж
| ~PE_Get( 18,2,9){}
| ~PE_Get( 18,2,10){}
| ~PE_Get( 18,2,11){}
| ~PE_Get( 19,2,12){}
| ~PE_Get( 19,2,13){}
| ~PE_Get( 19,2,14){}
| ~PE_Get( 19,2,15){}
| ~PE_Get( 19,2,16){}
| ~PE_Get( 19,2,17){}
|
Чистый объем продаж
| ~PE_Get( 18,3,9){}
| ~PE_Get( 18,3,10){}
| ~PE_Get( 18,3,11){}
| ~PE_Get( 19,3,12){6 300 000,00}
| ~PE_Get( 19,3,13){6 399 000,00}
| ~PE_Get( 19,3,14){5 850 000,00}
| ~PE_Get( 19,3,15){}
| ~PE_Get( 19,3,16){}
| ~PE_Get( 19,3,17){}
|
Материалы и комплектующие
| ~PE_Get( 18,4,9){}
| ~PE_Get( 18,4,10){}
| ~PE_Get( 18,4,11){}
| ~PE_Get( 19,4,12){651 000,00}
| ~PE_Get( 19,4,13){659 080,52}
| ~PE_Get( 19,4,14){614 179,17}
| ~PE_Get( 19,4,15){}
| ~PE_Get( 19,4,16){}
| ~PE_Get( 19,4,17){}
|
Сдельная зарплата
| ~PE_Get( 18,5,9){}
| ~PE_Get( 18,5,10){}
| ~PE_Get( 18,5,11){}
| ~PE_Get( 19,5,12){}
| ~PE_Get( 19,5,13){}
| ~PE_Get( 19,5,14){}
| ~PE_Get( 19,5,15){}
| ~PE_Get( 19,5,16){}
| ~PE_Get( 19,5,17){}
|
Суммарные прямые издержки
| ~PE_Get( 18,6,9){}
| ~PE_Get( 18,6,10){}
| ~PE_Get( 18,6,11){}
| ~PE_Get( 19,6,12){651 000,00}
| ~PE_Get( 19,6,13){659 080,52}
| ~PE_Get( 19,6,14){614 179,17}
| ~PE_Get( 19,6,15){}
| ~PE_Get( 19,6,16){}
| ~PE_Get( 19,6,17){}
|
Валовая прибыль
| ~PE_Get( 18,7,9){}
| ~PE_Get( 18,7,10){}
| ~PE_Get( 18,7,11){}
| ~PE_Get( 19,7,12){5 649 000,00}
| ~PE_Get( 19,7,13){5 739 919,48}
| ~PE_Get( 19,7,14){5 235 820,83}
| ~PE_Get( 19,7,15){}
| ~PE_Get( 19,7,16){}
| ~PE_Get( 19,7,17){}
|
Налог на имущество
| ~PE_Get( 18,8,9){20 000,00}
| ~PE_Get( 18,8,10){20 000,00}
| ~PE_Get( 18,8,11){20 000,00}
| ~PE_Get( 19,8,12){20 000,00}
| ~PE_Get( 19,8,13){20 000,00}
| ~PE_Get( 19,8,14){20 000,00}
| ~PE_Get( 19,8,15){20 000,00}
| ~PE_Get( 19,8,16){20 000,00}
| ~PE_Get( 19,8,17){20 000,00}
|
Административные издержки
| ~PE_Get( 18,9,9){40 000,00}
| ~PE_Get( 18,9,10){}
| ~PE_Get( 18,9,11){}
| ~PE_Get( 19,9,12){40 000,00}
| ~PE_Get( 19,9,13){}
| ~PE_Get( 19,9,14){}
| ~PE_Get( 19,9,15){40 490,89}
| ~PE_Get( 19,9,16){}
| ~PE_Get( 19,9,17){}
|
Производственные издержки
| ~PE_Get( 18,10,9){30 445,00}
| ~PE_Get( 18,10,10){80 445,00}
| ~PE_Get( 18,10,11){16 445,00}
| ~PE_Get( 19,10,12){1 500 445,00}
| ~PE_Get( 19,10,13){1 001 667,24}
| ~PE_Get( 19,10,14){700 445,00}
| ~PE_Get( 19,10,15){700 445,00}
| ~PE_Get( 19,10,16){700 445,00}
| ~PE_Get( 19,10,17){1 600 520,00}
|
Маркетинговые издержки
| ~PE_Get( 18,11,9){}
| ~PE_Get( 18,11,10){}
| ~PE_Get( 18,11,11){}
| ~PE_Get( 19,11,12){252 000,00}
| ~PE_Get( 19,11,13){255 960,00}
| ~PE_Get( 19,11,14){234 000,00}
| ~PE_Get( 19,11,15){}
| ~PE_Get( 19,11,16){}
| ~PE_Get( 19,11,17){}
|
Зарплата административного персонала
| ~PE_Get( 18,12,9){42 332,00}
| ~PE_Get( 18,12,10){42 332,00}
| ~PE_Get( 18,12,11){42 332,00}
| ~PE_Get( 19,12,12){42 332,00}
| ~PE_Get( 19,12,13){42 827,92}
| ~PE_Get( 19,12,14){43 329,64}
| ~PE_Get( 19,12,15){43 837,24}
| ~PE_Get( 19,12,16){44 350,79}
| ~PE_Get( 19,12,17){44 870,36}
|
Зарплата производственного персонала
| ~PE_Get( 18,13,9){105 545,93}
| ~PE_Get( 18,13,10){105 545,93}
| ~PE_Get( 18,13,11){114 509,17}
| ~PE_Get( 19,13,12){132 778,77}
| ~PE_Get( 19,13,13){134 334,27}
| ~PE_Get( 19,13,14){135 907,98}
| ~PE_Get( 19,13,15){137 500,13}
| ~PE_Get( 19,13,16){139 110,93}
| ~PE_Get( 19,13,17){140 740,61}
|
Зарплата маркетингового персонала
| ~PE_Get( 18,14,9){}
| ~PE_Get( 18,14,10){}
| ~PE_Get( 18,14,11){}
| ~PE_Get( 19,14,12){}
| ~PE_Get( 19,14,13){}
| ~PE_Get( 19,14,14){}
| ~PE_Get( 19,14,15){}
| ~PE_Get( 19,14,16){}
| ~PE_Get( 19,14,17){}
|
Суммарные постоянные издержки
| ~PE_Get( 18,15,9){218 322,93}
| ~PE_Get( 18,15,10){228 322,93}
| ~PE_Get( 18,15,11){173 286,17}
| ~PE_Get( 19,15,12){1 967 555,77}
| ~PE_Get( 19,15,13){1 434 789,42}
| ~PE_Get( 19,15,14){1 113 682,62}
| ~PE_Get( 19,15,15){922 273,27}
| ~PE_Get( 19,15,16){883 906,73}
| ~PE_Get( 19,15,17){1 786 130,97}
|
Амортизация
| ~PE_Get( 18,16,9){135 972,22}
| ~PE_Get( 18,16,10){135 972,22}
| ~PE_Get( 18,16,11){137 638,89}
| ~PE_Get( 19,16,12){209 194,44}
| ~PE_Get( 19,16,13){209 194,44}
| ~PE_Get( 19,16,14){209 194,44}
| ~PE_Get( 19,16,15){213 569,44}
| ~PE_Get( 19,16,16){213 569,44}
| ~PE_Get( 19,16,17){213 569,44}
|
Проценты по кредитам
| ~PE_Get( 18,17,9){350 368,42}
| ~PE_Get( 18,17,10){350 368,42}
| ~PE_Get( 18,17,11){350 368,42}
| ~PE_Get( 19,17,12){350 368,42}
| ~PE_Get( 19,17,13){350 368,42}
| ~PE_Get( 19,17,14){350 368,42}
| ~PE_Get( 19,17,15){350 368,42}
| ~PE_Get( 19,17,16){350 368,42}
| ~PE_Get( 19,17,17){350 368,42}
|
Суммарные непроизводственные издержки
| ~PE_Get( 18,18,9){486 340,64}
| ~PE_Get( 18,18,10){486 340,64}
| ~PE_Get( 18,18,11){488 007,31}
| ~PE_Get( 19,18,12){559 562,87}
| ~PE_Get( 19,18,13){559 562,87}
| ~PE_Get( 19,18,14){559 562,87}
| ~PE_Get( 19,18,15){563 937,87}
| ~PE_Get( 19,18,16){563 937,87}
| ~PE_Get( 19,18,17){563 937,87}
|
Другие доходы
| ~PE_Get( 18,19,9){}
| ~PE_Get( 18,19,10){}
| ~PE_Get( 18,19,11){}
| ~PE_Get( 19,19,12){}
| ~PE_Get( 19,19,13){}
| ~PE_Get( 19,19,14){}
| ~PE_Get( 19,19,15){}
| ~PE_Get( 19,19,16){}
| ~PE_Get( 19,19,17){}
|
Другие издержки
| ~PE_Get( 18,20,9){}
| ~PE_Get( 18,20,10){}
| ~PE_Get( 18,20,11){}
| ~PE_Get( 19,20,12){254 098,36}
| ~PE_Get( 19,20,13){245 901,64}
| ~PE_Get( 19,20,14){}
| ~PE_Get( 19,20,15){}
| ~PE_Get( 19,20,16){}
| ~PE_Get( 19,20,17){}
|
Убытки предыдущих периодов
| ~PE_Get( 18,21,9){11 971 292,82}
| ~PE_Get( 18,21,10){}
| ~PE_Get( 18,21,11){}
| ~PE_Get( 19,21,12){}
| ~PE_Get( 19,21,13){}
| ~PE_Get( 19,21,14){}
| ~PE_Get( 19,21,15){}
| ~PE_Get( 19,21,16){}
| ~PE_Get( 19,21,17){}
|
Прибыль до выплаты налога
| ~PE_Get( 18,22,9){-724 663,57}
| ~PE_Get( 18,22,10){-734 663,57}
| ~PE_Get( 18,22,11){-681 293,48}
| ~PE_Get( 19,22,12){2 847 783,00}
| ~PE_Get( 19,22,13){3 479 665,55}
| ~PE_Get( 19,22,14){3 542 575,34}
| ~PE_Get( 19,22,15){-1 506 211,13}
| ~PE_Get( 19,22,16){-1 467 844,59}
| ~PE_Get( 19,22,17){-2 370 068,83}
|
Суммарные издержки, отнесенные на прибыль
| ~PE_Get( 18,23,9){47 550,00}
| ~PE_Get( 18,23,10){47 550,00}
| ~PE_Get( 18,23,11){47 550,00}
| ~PE_Get( 19,23,12){47 550,00}
| ~PE_Get( 19,23,13){47 550,00}
| ~PE_Get( 19,23,14){47 550,00}
| ~PE_Get( 19,23,15){47 550,00}
| ~PE_Get( 19,23,16){47 550,00}
| ~PE_Get( 19,23,17){47 550,00}
|
Прибыль от курсовой разницы
| ~PE_Get( 18,24,9){}
| ~PE_Get( 18,24,10){}
| ~PE_Get( 18,24,11){}
| ~PE_Get( 19,24,12){}
| ~PE_Get( 19,24,13){}
| ~PE_Get( 19,24,14){}
| ~PE_Get( 19,24,15){}
| ~PE_Get( 19,24,16){}
| ~PE_Get( 19,24,17){}
|
Налогооблагаемая прибыль
| ~PE_Get( 18,25,9){}
| ~PE_Get( 18,25,10){}
| ~PE_Get( 18,25,11){}
| ~PE_Get( 19,25,12){897 362,37}
| ~PE_Get( 19,25,13){3 527 215,55}
| ~PE_Get( 19,25,14){3 590 125,34}
| ~PE_Get( 19,25,15){}
| ~PE_Get( 19,25,16){}
| ~PE_Get( 19,25,17){}
|
Налог на прибыль
| ~PE_Get( 18,26,9){}
| ~PE_Get( 18,26,10){}
| ~PE_Get( 18,26,11){}
| ~PE_Get( 19,26,12){53 841,74}
| ~PE_Get( 19,26,13){211 632,93}
| ~PE_Get( 19,26,14){215 407,52}
| ~PE_Get( 19,26,15){}
| ~PE_Get( 19,26,16){}
| ~PE_Get( 19,26,17){}
|
Чистая прибыль
| ~PE_Get( 18,27,9){-724 663,57}
| ~PE_Get( 18,27,10){-734 663,57}
| ~PE_Get( 18,27,11){-681 293,48}
| ~PE_Get( 19,27,12){2 793 941,26}
| ~PE_Get( 19,27,13){3 268 032,62}
| ~PE_Get( 19,27,14){3 327 167,82}
| ~PE_Get( 19,27,15){-1 506 211,13}
| ~PE_Get( 19,27,16){-1 467 844,59}
| ~PE_Get( 19,27,17){-2 370 068,83}
|
