Анализ чувствительности (руб.)

К оглавлению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}