7/25/2019 Analisis de Sensibilidad 2

1/2

Cantidad 1,000 1,100 1,122 1,144 1,167 1,191

Precio 200 200 200 230 230 230

Costo variable 80 80 80 80 80 80

0 1 2 3 4 5 6

Ing.operacional 200,000 220,000 224,400 263,221 268,486 273,855

Venta activo 120,000Costo variable - 80,000 - 88,000 - 89,760 - 91,555 - 93,386 - 95,254

Costos fijos - 50,000 - 50,000 - 50,000 - 46,000 - 46,000 ###

Depreciacin - 30,000 - 30,000 - 30,000 - 30,000 - 30,000 - 30,000

Valor libro - 150,000

Utilidad 40,000 52,000 54,640 95,666 69,099 102,601

Ip!esto "1#$% - 6,800 - 8,840 - 9,289 - 16,263 - 11,747 - 17,442

Ut.neta 33,200 43,160 45,351 79,403 57,352 85,159

Depreciacin 30,000 30,000 30,000 30,000 30,000 30,000

Valor libro 150,000

Inversin fija - 300,000 - 300,000

Capital trabajo - 54,000

Valor desec&o

'l!jo - 354,000 63,200 73,160 75,351 109,403 - 62,648 115,159

V() "12$% 115,696

115,696 200 197 194 191 188 185

1000 115,696 100,588 85,480 70,372 55,264 40,156

970 96,657 82,002 67,348 52,693 38,039 23,384

940 77,618 63,417 49,216 35,014 20,813 6,612

910 58,580 44,832 31,084 17,336 3,588 -10,161

880 39,541 26,247 12,952 -343 -13,638 -26,933

850 20,503 7,661 -5,180 -18,022 -30,864 -43,705

820 1,464 -10,924 -23,312 -35,701 -48,089 -60,478

7/25/2019 Analisis de Sensibilidad 2

2/2

1,214 1,239

230 230

80 80

7 8

279,332 284,919

- 97,159 - 99,102

- 46,000 - 46,000

- 30,000 - 30,000

106,173 109,817

- 18,049 - 18,669

88,124 91,148

30,000 30,000

54,000

210,000

118,124 385,148

182

25,049

8,730

-7,590

-23,909

-40,228

-56,547

-72,866