Hoja1FLUJO DE CAJA

PERIODOS (AOS)012345678

Unidades Vendidas30,000.0030,000.0030,000.0039,000.0039,000.0039,000.0039,000.0039,000.00

INGRESOS1,800,000.001,800,000.001,800,000.002,340,000.002,340,000.002,340,000.002,340,000.002,340,000.00VALOR ACTIVOS60,000.00COSTOS VARIABLES-1,050,000.00-1,050,000.00-1,050,000.00-1,209,000.00-1,209,000.00-1,209,000.00-1,209,000.00-1,209,000.00COSTOS DE FAB. FIJOS-10,000.00-10,000.00-10,000.00-12,000.00-12,000.00-12,000.00-12,000.00-12,000.00COMISIONES DE VENTAS-90,000.00-90,000.00-90,000.00-117,000.00-117,000.00-117,000.00-117,000.00-117,000.00GASTOS ADM Y VENTAS-40,000.00-40,000.00-40,000.00-48,000.00-48,000.00-48,000.00-48,000.00-48,000.00DEPRECIACON-35,000.00-35,000.00-35,000.00-47,500.00-47,500.00-47,500.00-47,500.00-47,500.00AMORTIZACIN INTAGIBLES-7,500.00-7,500.00-7,500.00-7,500.00VALOR LIBROS-45,000.00UTILIDAD ANTES DE IMPUESTO567,500.00567,500.00567,500.00899,000.00861,500.00906,500.00906,500.00966,500.00IMPUESTO-170,250.00-170,250.00-170,250.00-269,700.00-258,450.00-271,950.00-271,950.00-289,950.00UTILIDAD NETA397,250.00397,250.00397,250.00629,300.00603,050.00634,550.00634,550.00676,550.00

DEPRECIACIN35,000.0035,000.0035,000.0047,500.0047,500.0047,500.0047,500.0047,500.00AMORTIZACIN INTANGIBLES7,500.007,500.007,500.007,500.00VALOR LIBROS45,000.00INVERSIN INICIAL-765,000.00INVERSIN REEMPLAZO-300,000.00INVERSIN AMPLIACIN-250,000.00724,050.00778,032.50INVERSIN CAPITAL TRABAJO-1,190,000.00-196,000.00VALOR DE DESECHO1,052,355.70FLUJO CAJA-1,955,000.00439,750.00439,750.00439,750.00238,300.00395,550.00682,050.00682,050.001,776,405.70VAN=513942.370597078TIR=21.06%DEPRECIACIN

12345678INFRAESTRUCTURA INICIAL20,000.0020,000.0020,000.0020,000.0020,000.0020,000.0020,000.0020,000.00INFRAESTRUCTURA AMPLIACIN5,000.005,000.005,000.005,000.005,000.00MAQUINARIA INICIAL a15,000.0015,000.0015,000.0015,000.0015,000.00MAQUINARIA INICIAL b15,000.0015,000.0015,000.00MAQUINARIA REEMPLAZOMAQUINARIA AMPLIACIN7,500.007,500.007,500.007,500.007,500.00DEPRECIACIN TOTAL35,000.0035,000.0035,000.0047,500.0047,500.0047,500.0047,500.0047,500.00IncrementoMaquinaria=300,000.00150,000.00Infraestructura=400,000.00100,000.00Terreno=40,000.00Gastos Puesta en marcha=30,000.00Estudios=5,000.00765,000.00Costos de fabricacin volumen:30,000.00IncrementoMano de obra=10.008.00Materiales=20.0018.00Costos Indirectos=5.005.00Total=35.0031.00

Hoja2

Hoja3