flujo de caja ejercicio unca diego

Hoja1FLUJO DE CAJA PROYECTADO CAPACIDAD INSTALADA = PRODUCTO LACTEOCANT/DIAC/AOLECHE (Litros)15045,000YOGURT (Litros)5,0001,500,000QUESOS (Kilos)2,700810,000

CAPACIDAD INSTALADA UTILIZADA50%65%70%70%70%75%75%80%90%90%90%HORIZONTE DEL PROYECTOAO 0AO 1AO 2AO 3AO 4AO 5AO 6AO 7AO 8AO 9AO 10TOTAL DE INGRESOS8,141,250,00010,583,625,00011,397,750,00011,397,750,00011,397,750,00012,211,875,00012,211,875,00013,026,000,00014,654,250,00014,654,250,00014,654,250,000LECHE (Litros)22,50029,25031,50031,50031,50033,75033,75036,00040,50040,50040,500PRECIO (por litro)2,5002,5002,5002,5002,5002,5002,5002,5002,5002,5002,500TOTAL GUARANIES (1)56,250,00073,125,00078,750,00078,750,00078,750,00084,375,00084,375,00090,000,000101,250,000101,250,000101,250,000YOGURT (Litros)750,000975,0001,050,0001,050,0001,050,0001,125,0001,125,0001,200,0001,350,0001,350,0001,350,000PRECIO (por litro)7,0007,0007,0007,0007,0007,0007,0007,0007,0007,0007,000TOTAL GUARANIES (2)5,250,000,0006,825,000,0007,350,000,0007,350,000,0007,350,000,0007,875,000,0007,875,000,0008,400,000,0009,450,000,0009,450,000,0009,450,000,000QUESOS (Kilos)405,000526,500567,000567,000567,000607,500607,500648,000729,000729,000729,000PRECIO (por kilo)7,0007,0007,0007,0007,0007,0007,0007,0007,0007,0007,000TOTAL GUARANIES (3)2,835,000,0003,685,500,0003,969,000,0003,969,000,0003,969,000,0004,252,500,0004,252,500,0004,536,000,0005,103,000,0005,103,000,0005,103,000,000TOTAL DE EGRESOS11,712,437,5009,575,268,7509,330,212,5009,385,212,5009,330,212,5009,670,156,2509,615,156,2509,955,100,00010,524,987,50010,469,987,50010,524,987,500COSTO DE PRODUCC. Y ADMINIST.8,095,437,5008,925,268,7509,230,212,5009,285,212,5009,230,212,5009,570,156,2509,515,156,2509,855,100,00010,424,987,50010,369,987,50010,424,987,500Insumos2,849,437,5003,704,268,7503,989,212,5003,989,212,5003,989,212,5004,274,156,2504,274,156,2504,559,100,0005,128,987,5005,128,987,5005,128,987,500Mano de Obra4,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,0004,836,000,000Combustibles y Lubricantes50,000,00050,000,00050,000,00060,000,00050,000,00060,000,00050,000,00060,000,00060,000,00050,000,00060,000,000Seguros20,000,00015,000,00015,000,00015,000,00015,000,00015,000,00015,000,00015,000,00015,000,00015,000,00015,000,000Servicios Pblicos250,000,000260,000,000270,000,000300,000,000270,000,000300,000,000270,000,000300,000,000300,000,000270,000,000300,000,000Sistemas Informaticos50,000,00010,000,0005,000,00030,000,0005,000,00030,000,0005,000,00030,000,00030,000,0005,000,00030,000,000Mantenimiento y Reparaciones10,000,00010,000,00015,000,0005,000,00015,000,0005,000,00015,000,0005,000,0005,000,00015,000,0005,000,000Imagen y Difusin30,000,00040,000,00050,000,00050,000,00050,000,00050,000,00050,000,00050,000,00050,000,00050,000,00050,000,000TERRENO750,000,0000.00.00.00.00.00.00.00.00.00.0MAQUINARIAS1,000,000,000500,000,0000.00.00.00.00.00.00.00.00.0OBRAS CIVILES1,400,000,0000.00.00.00.00.00.00.00.00.0INSTALACION Y MONTAJE70,000,0000.00.00.00.00.00.00.00.00.00.0GASTOS DE INVERSION50,000,0000.00.00.00.00.00.00.00.00.00.0DEPRESIACION247,000,00050,000,0000.00.00.00.00.00.00.00.00.0IMPREVISTOS100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000100,000,000UTILIDADES ANTES DE IMPUESTOS-3,571,187,5001,008,356,2502,067,537,5002,012,537,5002,067,537,5002,541,718,7502,596,718,7503,070,900,0004,129,262,5004,184,262,5004,129,262,500IMPUESTOS-357,118,750100,835,625206,753,750201,253,750206,753,750254,171,875259,671,875307,090,000412,926,250418,426,250412,926,250UTILIDAD DESPUES DE IMPUESTOS-3,214,068,750907,520,6251,860,783,7501,811,283,7501,860,783,7502,287,546,8752,337,046,8752,763,810,0003,716,336,2503,765,836,2503,716,336,250

F L U J O N E T O D E C A J ACAPACIDAD INSTALADA UTILIZADA50%65%70%70%70%75%75%80%90%90%90%HORIZONTE DEL PROYECTOAO 0AO 1AO 2AO 3AO 2AO 3AO 2AO 3AO 3AO 2AO 3TOTAL DE INGRESOS8,141,250,00010,583,625,00011,397,750,00011,397,750,00011,397,750,00012,211,875,00012,211,875,00013,026,000,00014,654,250,00014,654,250,00014,654,250,000TOTAL DE EGRESOS11,712,437,5009,575,268,7509,330,212,5009,385,212,5009,330,212,5009,670,156,2509,615,156,2509,955,100,00010,524,987,50010,469,987,50010,524,987,500UTILIDAD NETA-3,571,187,5001,008,356,2502,067,537,5002,012,537,5002,067,537,5002,541,718,7502,596,718,7503,070,900,0004,129,262,5004,184,262,5004,129,262,500

&"-,Negrita Cursiva"Catedra: Ingenieria FinancieraProf.: Dr. Cayo CaceresTema: Flujo de CajaAlumno: Diego Joel Gonzalez Berutti&"-,Normal"