Анализ чувствительности (руб.)
К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14
|
|
|
|
|
|
|
|
|
|
|
№ |
Параметры |
-40% |
-30% |
-20% |
-10% |
0% |
10% |
20% |
30% |
40% |
|
|
|
|
|
|
|
|
|
|
|
|
DPB |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,0,2,0){54} |
~PE_Get( 29,0,2,1){60} |
~PE_Get( 29,0,2,2){63} |
~PE_Get( 29,0,2,3){69} |
~PE_Get( 29,0,2,4){74} |
~PE_Get( 29,0,2,5){80} |
~PE_Get( 30,0,2,6){86} |
~PE_Get( 30,0,2,7){96} |
~PE_Get( 30,0,2,8){103} |
2 |
Объем сбыта |
~PE_Get( 29,0,3,0){105} |
~PE_Get( 29,0,3,1){105} |
~PE_Get( 29,0,3,2){105} |
~PE_Get( 29,0,3,3){87} |
~PE_Get( 29,0,3,4){74} |
~PE_Get( 29,0,3,5){63} |
~PE_Get( 30,0,3,6){60} |
~PE_Get( 30,0,3,7){54} |
~PE_Get( 30,0,3,8){50} |
3 |
Цена сбыта |
~PE_Get( 29,0,4,0){105} |
~PE_Get( 29,0,4,1){105} |
~PE_Get( 29,0,4,2){105} |
~PE_Get( 29,0,4,3){99} |
~PE_Get( 29,0,4,4){74} |
~PE_Get( 29,0,4,5){62} |
~PE_Get( 30,0,4,6){55} |
~PE_Get( 30,0,4,7){50} |
~PE_Get( 30,0,4,8){48} |
4 |
Прямые издержки |
~PE_Get( 29,0,7,0){61} |
~PE_Get( 29,0,7,1){63} |
~PE_Get( 29,0,7,2){67} |
~PE_Get( 29,0,7,3){71} |
~PE_Get( 29,0,7,4){74} |
~PE_Get( 29,0,7,5){80} |
~PE_Get( 30,0,7,6){86} |
~PE_Get( 30,0,7,7){105} |
~PE_Get( 30,0,7,8){105} |
5 |
Общие издержки |
~PE_Get( 29,0,9,0){63} |
~PE_Get( 29,0,9,1){65} |
~PE_Get( 29,0,9,2){69} |
~PE_Get( 29,0,9,3){73} |
~PE_Get( 29,0,9,4){74} |
~PE_Get( 29,0,9,5){75} |
~PE_Get( 30,0,9,6){83} |
~PE_Get( 30,0,9,7){86} |
~PE_Get( 30,0,9,8){94} |
|
PI |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,1,2,0){2,05} |
~PE_Get( 29,1,2,1){1,83} |
~PE_Get( 29,1,2,2){1,64} |
~PE_Get( 29,1,2,3){1,49} |
~PE_Get( 29,1,2,4){1,36} |
~PE_Get( 29,1,2,5){1,25} |
~PE_Get( 30,1,2,6){1,16} |
~PE_Get( 30,1,2,7){1,08} |
~PE_Get( 30,1,2,8){1,01} |
2 |
Объем сбыта |
~PE_Get( 29,1,3,0){0,53} |
~PE_Get( 29,1,3,1){0,72} |
~PE_Get( 29,1,3,2){0,92} |
~PE_Get( 29,1,3,3){1,14} |
~PE_Get( 29,1,3,4){1,36} |
~PE_Get( 29,1,3,5){1,59} |
~PE_Get( 30,1,3,6){1,83} |
~PE_Get( 30,1,3,7){2,07} |
~PE_Get( 30,1,3,8){2,31} |
3 |
Цена сбыта |
~PE_Get( 29,1,4,0){0,20} |
~PE_Get( 29,1,4,1){0,43} |
~PE_Get( 29,1,4,2){0,70} |
~PE_Get( 29,1,4,3){1,02} |
~PE_Get( 29,1,4,4){1,36} |
~PE_Get( 29,1,4,5){1,72} |
~PE_Get( 30,1,4,6){2,09} |
~PE_Get( 30,1,4,7){2,46} |
~PE_Get( 30,1,4,8){2,82} |
4 |
Прямые издержки |
~PE_Get( 29,1,7,0){1,86} |
~PE_Get( 29,1,7,1){1,73} |
~PE_Get( 29,1,7,2){1,61} |
~PE_Get( 29,1,7,3){1,48} |
~PE_Get( 29,1,7,4){1,36} |
~PE_Get( 29,1,7,5){1,24} |
~PE_Get( 30,1,7,6){1,12} |
~PE_Get( 30,1,7,7){1,00} |
~PE_Get( 30,1,7,8){0,89} |
5 |
Общие издержки |
~PE_Get( 29,1,9,0){1,67} |
~PE_Get( 29,1,9,1){1,59} |
~PE_Get( 29,1,9,2){1,51} |
~PE_Get( 29,1,9,3){1,43} |
~PE_Get( 29,1,9,4){1,36} |
~PE_Get( 29,1,9,5){1,29} |
~PE_Get( 30,1,9,6){1,22} |
~PE_Get( 30,1,9,7){1,15} |
~PE_Get( 30,1,9,8){1,09} |
|
NPV |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,2,2,0){61 333 457,67} |
~PE_Get( 29,2,2,1){53 810 141,88} |
~PE_Get( 29,2,2,2){46 286 826,10} |
~PE_Get( 29,2,2,3){38 763 153,72} |
~PE_Get( 29,2,2,4){31 238 614,07} |
~PE_Get( 29,2,2,5){23 714 074,43} |
~PE_Get( 30,2,2,6){16 189 534,78} |
~PE_Get( 30,2,2,7){8 664 995,13} |
~PE_Get( 30,2,2,8){1 140 455,48} |
2 |
Объем сбыта |
~PE_Get( 29,2,3,0){-45 699 912,31} |
~PE_Get( 29,2,3,1){-26 399 818,65} |
~PE_Get( 29,2,3,2){-7 174 165,36} |
~PE_Get( 29,2,3,3){12 032 650,35} |
~PE_Get( 29,2,3,4){31 238 614,07} |
~PE_Get( 29,2,3,5){50 443 690,69} |
~PE_Get( 30,2,3,6){69 647 186,85} |
~PE_Get( 30,2,3,7){88 850 683,00} |
~PE_Get( 30,2,3,8){108 054 179,16} |
3 |
Цена сбыта |
~PE_Get( 29,2,4,0){-88 227 015,15} |
~PE_Get( 29,2,4,1){-58 078 353,70} |
~PE_Get( 29,2,4,2){-28 115 873,49} |
~PE_Get( 29,2,4,3){1 599 488,60} |
~PE_Get( 29,2,4,4){31 238 614,07} |
~PE_Get( 29,2,4,5){60 866 975,34} |
~PE_Get( 30,2,4,6){90 493 756,14} |
~PE_Get( 30,2,4,7){120 120 536,94} |
~PE_Get( 30,2,4,8){149 723 779,25} |
4 |
Прямые издержки |
~PE_Get( 29,2,7,0){72 933 333,13} |
~PE_Get( 29,2,7,1){62 510 048,48} |
~PE_Get( 29,2,7,2){52 086 763,83} |
~PE_Get( 29,2,7,3){41 663 479,18} |
~PE_Get( 29,2,7,4){31 238 614,07} |
~PE_Get( 29,2,7,5){20 807 857,59} |
~PE_Get( 30,2,7,6){10 371 460,19} |
~PE_Get( 30,2,7,7){-89 345,25} |
~PE_Get( 30,2,7,8){-10 576 827,93} |
5 |
Общие издержки |
~PE_Get( 29,2,9,0){54 248 147,49} |
~PE_Get( 29,2,9,1){48 496 159,26} |
~PE_Get( 29,2,9,2){42 743 996,83} |
~PE_Get( 29,2,9,3){36 991 305,45} |
~PE_Get( 29,2,9,4){31 238 614,07} |
~PE_Get( 29,2,9,5){25 485 922,70} |
~PE_Get( 30,2,9,6){19 733 231,32} |
~PE_Get( 30,2,9,7){13 980 539,95} |
~PE_Get( 30,2,9,8){8 227 848,57} |
|
IRR |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,3,2,0){37,05} |
~PE_Get( 29,3,2,1){31,87} |
~PE_Get( 29,3,2,2){27,56} |
~PE_Get( 29,3,2,3){23,89} |
~PE_Get( 29,3,2,4){20,72} |
~PE_Get( 29,3,2,5){17,94} |
~PE_Get( 30,3,2,6){15,48} |
~PE_Get( 30,3,2,7){13,28} |
~PE_Get( 30,3,2,8){11,29} |
2 |
Объем сбыта |
~PE_Get( 29,3,3,0){0,00} |
~PE_Get( 29,3,3,1){1,64} |
~PE_Get( 29,3,3,2){8,59} |
~PE_Get( 29,3,3,3){14,88} |
~PE_Get( 29,3,3,4){20,72} |
~PE_Get( 29,3,3,5){26,24} |
~PE_Get( 30,3,3,6){31,51} |
~PE_Get( 30,3,3,7){36,60} |
~PE_Get( 30,3,3,8){41,53} |
3 |
Цена сбыта |
~PE_Get( 29,3,4,0){0,00} |
~PE_Get( 29,3,4,1){0,00} |
~PE_Get( 29,3,4,2){0,47} |
~PE_Get( 29,3,4,3){11,54} |
~PE_Get( 29,3,4,4){20,72} |
~PE_Get( 29,3,4,5){28,93} |
~PE_Get( 30,3,4,6){36,56} |
~PE_Get( 30,3,4,7){43,81} |
~PE_Get( 30,3,4,8){50,80} |
4 |
Прямые издержки |
~PE_Get( 29,3,7,0){31,56} |
~PE_Get( 29,3,7,1){29,00} |
~PE_Get( 29,3,7,2){26,35} |
~PE_Get( 29,3,7,3){23,60} |
~PE_Get( 29,3,7,4){20,72} |
~PE_Get( 29,3,7,5){17,69} |
~PE_Get( 30,3,7,6){14,47} |
~PE_Get( 30,3,7,7){10,97} |
~PE_Get( 30,3,7,8){7,12} |
5 |
Общие издержки |
~PE_Get( 29,3,9,0){27,65} |
~PE_Get( 29,3,9,1){25,92} |
~PE_Get( 29,3,9,2){24,20} |
~PE_Get( 29,3,9,3){22,46} |
~PE_Get( 29,3,9,4){20,72} |
~PE_Get( 29,3,9,5){18,97} |
~PE_Get( 30,3,9,6){17,21} |
~PE_Get( 30,3,9,7){15,43} |
~PE_Get( 30,3,9,8){13,63} |
|
|
|
|
|
|
|
|
|
|
|
№ |
Параметры |
-40% |
-30% |
-20% |
-10% |
0% |
10% |
20% |
30% |
40% |
|
|
|
|
|
|
|
|
|
|
|
|
DPB |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,0,2,0){54} |
~PE_Get( 29,0,2,1){60} |
~PE_Get( 29,0,2,2){63} |
~PE_Get( 29,0,2,3){69} |
~PE_Get( 29,0,2,4){74} |
~PE_Get( 29,0,2,5){80} |
~PE_Get( 30,0,2,6){86} |
~PE_Get( 30,0,2,7){96} |
~PE_Get( 30,0,2,8){103} |
2 |
Объем сбыта |
~PE_Get( 29,0,3,0){105} |
~PE_Get( 29,0,3,1){105} |
~PE_Get( 29,0,3,2){105} |
~PE_Get( 29,0,3,3){87} |
~PE_Get( 29,0,3,4){74} |
~PE_Get( 29,0,3,5){63} |
~PE_Get( 30,0,3,6){60} |
~PE_Get( 30,0,3,7){54} |
~PE_Get( 30,0,3,8){50} |
3 |
Цена сбыта |
~PE_Get( 29,0,4,0){105} |
~PE_Get( 29,0,4,1){105} |
~PE_Get( 29,0,4,2){105} |
~PE_Get( 29,0,4,3){99} |
~PE_Get( 29,0,4,4){74} |
~PE_Get( 29,0,4,5){62} |
~PE_Get( 30,0,4,6){55} |
~PE_Get( 30,0,4,7){50} |
~PE_Get( 30,0,4,8){48} |
4 |
Прямые издержки |
~PE_Get( 29,0,7,0){61} |
~PE_Get( 29,0,7,1){63} |
~PE_Get( 29,0,7,2){67} |
~PE_Get( 29,0,7,3){71} |
~PE_Get( 29,0,7,4){74} |
~PE_Get( 29,0,7,5){80} |
~PE_Get( 30,0,7,6){86} |
~PE_Get( 30,0,7,7){105} |
~PE_Get( 30,0,7,8){105} |
5 |
Общие издержки |
~PE_Get( 29,0,9,0){63} |
~PE_Get( 29,0,9,1){65} |
~PE_Get( 29,0,9,2){69} |
~PE_Get( 29,0,9,3){73} |
~PE_Get( 29,0,9,4){74} |
~PE_Get( 29,0,9,5){75} |
~PE_Get( 30,0,9,6){83} |
~PE_Get( 30,0,9,7){86} |
~PE_Get( 30,0,9,8){94} |
|
PI |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,1,2,0){2,05} |
~PE_Get( 29,1,2,1){1,83} |
~PE_Get( 29,1,2,2){1,64} |
~PE_Get( 29,1,2,3){1,49} |
~PE_Get( 29,1,2,4){1,36} |
~PE_Get( 29,1,2,5){1,25} |
~PE_Get( 30,1,2,6){1,16} |
~PE_Get( 30,1,2,7){1,08} |
~PE_Get( 30,1,2,8){1,01} |
2 |
Объем сбыта |
~PE_Get( 29,1,3,0){0,53} |
~PE_Get( 29,1,3,1){0,72} |
~PE_Get( 29,1,3,2){0,92} |
~PE_Get( 29,1,3,3){1,14} |
~PE_Get( 29,1,3,4){1,36} |
~PE_Get( 29,1,3,5){1,59} |
~PE_Get( 30,1,3,6){1,83} |
~PE_Get( 30,1,3,7){2,07} |
~PE_Get( 30,1,3,8){2,31} |
3 |
Цена сбыта |
~PE_Get( 29,1,4,0){0,20} |
~PE_Get( 29,1,4,1){0,43} |
~PE_Get( 29,1,4,2){0,70} |
~PE_Get( 29,1,4,3){1,02} |
~PE_Get( 29,1,4,4){1,36} |
~PE_Get( 29,1,4,5){1,72} |
~PE_Get( 30,1,4,6){2,09} |
~PE_Get( 30,1,4,7){2,46} |
~PE_Get( 30,1,4,8){2,82} |
4 |
Прямые издержки |
~PE_Get( 29,1,7,0){1,86} |
~PE_Get( 29,1,7,1){1,73} |
~PE_Get( 29,1,7,2){1,61} |
~PE_Get( 29,1,7,3){1,48} |
~PE_Get( 29,1,7,4){1,36} |
~PE_Get( 29,1,7,5){1,24} |
~PE_Get( 30,1,7,6){1,12} |
~PE_Get( 30,1,7,7){1,00} |
~PE_Get( 30,1,7,8){0,89} |
5 |
Общие издержки |
~PE_Get( 29,1,9,0){1,67} |
~PE_Get( 29,1,9,1){1,59} |
~PE_Get( 29,1,9,2){1,51} |
~PE_Get( 29,1,9,3){1,43} |
~PE_Get( 29,1,9,4){1,36} |
~PE_Get( 29,1,9,5){1,29} |
~PE_Get( 30,1,9,6){1,22} |
~PE_Get( 30,1,9,7){1,15} |
~PE_Get( 30,1,9,8){1,09} |
|
NPV |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,2,2,0){61 333 457,67} |
~PE_Get( 29,2,2,1){53 810 141,88} |
~PE_Get( 29,2,2,2){46 286 826,10} |
~PE_Get( 29,2,2,3){38 763 153,72} |
~PE_Get( 29,2,2,4){31 238 614,07} |
~PE_Get( 29,2,2,5){23 714 074,43} |
~PE_Get( 30,2,2,6){16 189 534,78} |
~PE_Get( 30,2,2,7){8 664 995,13} |
~PE_Get( 30,2,2,8){1 140 455,48} |
2 |
Объем сбыта |
~PE_Get( 29,2,3,0){-45 699 912,31} |
~PE_Get( 29,2,3,1){-26 399 818,65} |
~PE_Get( 29,2,3,2){-7 174 165,36} |
~PE_Get( 29,2,3,3){12 032 650,35} |
~PE_Get( 29,2,3,4){31 238 614,07} |
~PE_Get( 29,2,3,5){50 443 690,69} |
~PE_Get( 30,2,3,6){69 647 186,85} |
~PE_Get( 30,2,3,7){88 850 683,00} |
~PE_Get( 30,2,3,8){108 054 179,16} |
3 |
Цена сбыта |
~PE_Get( 29,2,4,0){-88 227 015,15} |
~PE_Get( 29,2,4,1){-58 078 353,70} |
~PE_Get( 29,2,4,2){-28 115 873,49} |
~PE_Get( 29,2,4,3){1 599 488,60} |
~PE_Get( 29,2,4,4){31 238 614,07} |
~PE_Get( 29,2,4,5){60 866 975,34} |
~PE_Get( 30,2,4,6){90 493 756,14} |
~PE_Get( 30,2,4,7){120 120 536,94} |
~PE_Get( 30,2,4,8){149 723 779,25} |
4 |
Прямые издержки |
~PE_Get( 29,2,7,0){72 933 333,13} |
~PE_Get( 29,2,7,1){62 510 048,48} |
~PE_Get( 29,2,7,2){52 086 763,83} |
~PE_Get( 29,2,7,3){41 663 479,18} |
~PE_Get( 29,2,7,4){31 238 614,07} |
~PE_Get( 29,2,7,5){20 807 857,59} |
~PE_Get( 30,2,7,6){10 371 460,19} |
~PE_Get( 30,2,7,7){-89 345,25} |
~PE_Get( 30,2,7,8){-10 576 827,93} |
5 |
Общие издержки |
~PE_Get( 29,2,9,0){54 248 147,49} |
~PE_Get( 29,2,9,1){48 496 159,26} |
~PE_Get( 29,2,9,2){42 743 996,83} |
~PE_Get( 29,2,9,3){36 991 305,45} |
~PE_Get( 29,2,9,4){31 238 614,07} |
~PE_Get( 29,2,9,5){25 485 922,70} |
~PE_Get( 30,2,9,6){19 733 231,32} |
~PE_Get( 30,2,9,7){13 980 539,95} |
~PE_Get( 30,2,9,8){8 227 848,57} |
|
IRR |
|
|
|
|
|
|
|
|
|
1 |
Объем инвестиций |
~PE_Get( 29,3,2,0){37,05} |
~PE_Get( 29,3,2,1){31,87} |
~PE_Get( 29,3,2,2){27,56} |
~PE_Get( 29,3,2,3){23,89} |
~PE_Get( 29,3,2,4){20,72} |
~PE_Get( 29,3,2,5){17,94} |
~PE_Get( 30,3,2,6){15,48} |
~PE_Get( 30,3,2,7){13,28} |
~PE_Get( 30,3,2,8){11,29} |
2 |
Объем сбыта |
~PE_Get( 29,3,3,0){0,00} |
~PE_Get( 29,3,3,1){1,64} |
~PE_Get( 29,3,3,2){8,59} |
~PE_Get( 29,3,3,3){14,88} |
~PE_Get( 29,3,3,4){20,72} |
~PE_Get( 29,3,3,5){26,24} |
~PE_Get( 30,3,3,6){31,51} |
~PE_Get( 30,3,3,7){36,60} |
~PE_Get( 30,3,3,8){41,53} |
3 |
Цена сбыта |
~PE_Get( 29,3,4,0){0,00} |
~PE_Get( 29,3,4,1){0,00} |
~PE_Get( 29,3,4,2){0,47} |
~PE_Get( 29,3,4,3){11,54} |
~PE_Get( 29,3,4,4){20,72} |
~PE_Get( 29,3,4,5){28,93} |
~PE_Get( 30,3,4,6){36,56} |
~PE_Get( 30,3,4,7){43,81} |
~PE_Get( 30,3,4,8){50,80} |
4 |
Прямые издержки |
~PE_Get( 29,3,7,0){31,56} |
~PE_Get( 29,3,7,1){29,00} |
~PE_Get( 29,3,7,2){26,35} |
~PE_Get( 29,3,7,3){23,60} |
~PE_Get( 29,3,7,4){20,72} |
~PE_Get( 29,3,7,5){17,69} |
~PE_Get( 30,3,7,6){14,47} |
~PE_Get( 30,3,7,7){10,97} |
~PE_Get( 30,3,7,8){7,12} |
5 |
Общие издержки |
~PE_Get( 29,3,9,0){27,65} |
~PE_Get( 29,3,9,1){25,92} |
~PE_Get( 29,3,9,2){24,20} |
~PE_Get( 29,3,9,3){22,46} |
~PE_Get( 29,3,9,4){20,72} |
~PE_Get( 29,3,9,5){18,97} |
~PE_Get( 30,3,9,6){17,21} |
~PE_Get( 30,3,9,7){15,43} |
~PE_Get( 30,3,9,8){13,63} |