Hoja1

UNIVERSIDAD TECNICA DE ORUROFACULTAD NACIONAL DE INGENIERIA CARRERA DE INGENIERIA INDUSTRIAL

LABORATORIO N3

DOCENTE DE TEORIADOCENRTE LABORATORIOESTUDIANTETEMA: FLUJO DE CAJA

Hoja2EVALUACION PROYECTO PURODESCRIPCIONAO 0AO 1AO 2AO 3AO 4AO 5AO 6AO 7AO 8AO 9AO 10PRODUCCION20000200002000020000280002800028000280003000030000PRECIO580580580580580580580580580580INGRESO POR VENTAS11,600,00011,600,00011,600,00011,600,00016,240,00016,240,00016,240,00016,240,00017,400,00017,400,000costo de ventas174,000174,000174,000174,000243,600243,600243,600243,600261,000261,000costo de produccion variable2,700,0002,700,0002,700,0002,700,0003,780,0003,780,0003,780,0003,780,0004,050,0004,050,000Costos fijos de Administracion2,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,000otros costo fijos800,000800,000800,000800,000800,000Depreciacion2,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,000Total costos8,474,0008,474,0008,474,0008,474,0009,623,6008,823,6008,823,6008,823,6009,111,0009,111,000Utilidad bruta3,126,0003,126,0003,126,0003,126,0006,616,4007,416,4007,416,4007,416,4008,289,0008,289,000Impuestos a las utilidades312,600312,600312,600312,600661,640741,640741,640741,640828,900828,900Utilidad neta2,813,4002,813,4002,813,4002,813,4005,954,7606,674,7606,674,7606,674,7607,460,1007,460,100Depreciacion2,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,000Camiones6,000,000lineas de produccion 9,000,000Galpon8,000,000total Activos fijos23,000,000Capital de trabajo900,000total inversiones23,900,000FLUJO DE CAJA NETO-23,900,0005,113,4005,113,4005,113,4005,113,4008,254,7608,974,7608,974,7608,974,7609,760,1009,760,100Tasa de descuento12%VAN15,208,609TIR24%

Hoja2 (2)EVALUACION FINANCIERA DEL PROYECTODESCRIPCIONAO 0AO 1AO 2AO 3AO 4AO 5AO 6AO 7AO 8AO 9AO 10PRODUCCION20000200002000020000280002800028000280003000030000PRECIO580580580580580580580580580580INGRESO POR VENTAS11,600,00011,600,00011,600,00011,600,00016,240,00016,240,00016,240,00016,240,00017,400,00017,400,000costo de ventas174,000174,000174,000174,000243,600243,600243,600243,600261,000261,000costo de produccion variable2,700,0002,700,0002,700,0002,700,0003,780,0003,780,0003,780,0003,780,0004,050,0004,050,000Costos fijos de Administracion2,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,0002,500,000otros costo fijos800,000800,000800,000800,000800,000Interes bancario1,552,5001,411,7281,258,2871,091,035908,732710,020493,425257,337Depreciacion2,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,000Total costos10,026,5009,885,7289,732,2879,565,03510,532,3329,533,6209,317,0259,080,9379,111,0009,111,000Utilidad bruta1,573,5001,714,2721,867,7132,034,9655,707,6686,706,3806,922,9757,159,0638,289,0008,289,000Impuestos a las utilidades157,350171,427186,771203,496570,767670,638692,297715,906828,900828,900Utilidad neta1,416,1501,542,8451,680,9421,831,4685,136,9026,035,7426,230,6776,443,1577,460,1007,460,100Depreciacion2,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,0002,300,000Amortizacion de la deuda1,564,1331,704,9051,858,3462,025,5982,207,9012,406,6132,623,2082,859,29600Camiones6,000,000lineas de produccion 9,000,000Galpon8,000,000total Activos fijos23,000,000Capital de trabajo900,000total inversiones23,900,000Credito bancario17,250,000FLUJO DE CAJA NETO-6,650,0002,152,0172,137,9402,122,5962,105,8715,229,0005,929,1295,907,4705,883,8619,760,1009,760,100Tasa de descuento12%VAN17,506,606TIR44%CUADRO DE AMORTIZACIONESinteres9%Periodo 8aosaoDeudaInteresPagoAmortizacionSaldo017,250,00017,250,000117,250,0001,552,5003,116,6331,564,13315,685,867215,685,8671,411,7283,116,6331,704,90513,980,962313,980,9621,258,2873,116,6331,858,34612,122,616412,122,6161,091,0353,116,6332,025,59810,097,018510,097,018908,7323,116,6332,207,9017,889,11767,889,117710,0203,116,6332,406,6135,482,50475,482,504493,4253,116,6332,623,2082,859,29682,859,296257,3373,116,6332,859,29609000001000000

Hoja3