practica 4 metodos 2

2
Capacidad 2,500 6,000 9,500 Inversión 120,000 231,387 326,602 Año Producción Ingresos Costo fijo C. variable Flujo anual 1 1,400 119,000 47895 62582.8 8,522 2 2,500 212,500 47895 111755 52,850 3 2,500 212,500 47895 111755 52,850 4 2,500 212,500 47895 111755 52,850 5 2,500 212,500 47895 111755 52,850 Flujo 99,922 Año Producción Ingresos Costo fijo C. variable Flujo anual 1 1,400 119,000 72,000 50,400 -3,400 2 2,500 212,500 72,000 90,000 50,500 3 5,500 467,500 72,000 198,000 197,500 4 6,000 510,000 72,000 216,000 222,000 5 6,000 510,000 72,000 216,000 222,000 Flujo 457,213 Año Producción Ingresos Costo fijo C. variable Flujo anual 1 1,400 119,000 87,400 51,520 -19,920 2 2,500 212,500 87,400 92,000 33,100 3 5,500 467,500 87,400 202,400 177,700 4 7,500 637,500 87,400 276,000 274,100 5 9,500 807,500 87,400 349,600 370,500 Flujo 508,878

Upload: alexander-ale-vilcape

Post on 17-Dec-2015

220 views

Category:

Documents


1 download

DESCRIPTION

IM2 UNSA

TRANSCRIPT

Hoja1Planta TamaoCosto unitarioCosto fijoCosto variableA2,50063.8619.15844.702Capacidad 2,5006,0009,500B6,000481236Inversin120,000231,387326,602C9,500469.236.8AoProduccinIngresosCosto fijoC. variableFlujo anual11,400119,0004789562582.88,522110477.8Ao1234522,500212,5004789511175552,850159650OpcionAABCC32,500212,5004789511175552,85015965042,500212,5004789511175552,85015965052,500212,5004789511175552,850159650Ao123450OpcionAAAAAFlujo99,9220C.T110477.81596501596501596501596500AoProduccinIngresosCosto fijoC. variableFlujo anualERROR:#VALUE!11,400119,00072,00050,400-3,40012240022,500212,50072,00090,00050,50016200035,500467,50072,000198,000197,50027000046,000510,00072,000216,000222,00028800056,000510,00072,000216,000222,0002880000Flujo457,21300AoProduccinIngresosCosto fijoC. variableFlujo anualERROR:#VALUE!11,400119,00087,40051,520-19,92013892022,500212,50087,40092,00033,10017940035,500467,50087,400202,400177,70028980047,500637,50087,400276,000274,10036340059,500807,50087,400349,600370,500437000Flujo508,878