flujo de caja ejercicio unca diego

2
Catedra: Ingenieria Financiera Prof.: Dr. Cayo Caceres Tema: Flujo de Caja Alumno: Diego Joel Gonzalez Berutti FLUJO DE CAJA PROYECTADO CAPACIDAD INSTALADA = PRODUCTO LACTEO CANT/DIA C/AÑO LECHE (Litros) 150 45,000 YOGURT (Litros) 5,000 1,500,000 QUESOS (Kilos) 2,700 810,000 CAPACIDAD INSTALADA UTILIZADA 50% 65% 70% 70% 70% 75% 75% 80% 90% 90% HORIZONTE DEL PROYECTO AÑO 0 AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5 AÑO 6 AÑO 7 AÑO 8 AÑO 9 TOTAL DE INGRESOS ### ### ### ### ### ### ### ### ### ### LECHE (Litros) 22,500 29,250 31,500 31,500 31,500 33,750 33,750 36,000 40,500 40,500 PRECIO (por litro) 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 TOTAL GUARANIES (1) 56,250,000 73,125,000 78,750,000 78,750,000 78,750,000 84,375,000 84,375,000 90,000,000 101,250,000 101,250,000 YOGURT (Litros) 750,000 975,000 1,050,000 1,050,000 1,050,000 1,125,000 1,125,000 1,200,000 1,350,000 1,350,000 PRECIO (por litro) 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 TOTAL GUARANIES (2) ### ### ### ### ### ### ### ### ### ### QUESOS (Kilos) 405,000 526,500 567,000 567,000 567,000 607,500 607,500 648,000 729,000 729,000 PRECIO (por kilo) 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 7,000 TOTAL GUARANIES (3) ### ### ### ### ### ### ### ### ### ### TOTAL DE EGRESOS ### ### ### ### ### ### ### ### ### ### COSTO DE PRODUCC. Y ADMINIST. ### ### ### ### ### ### ### ### ### ### Insumos ### ### ### ### ### ### ### ### ### ### Mano de Obra ### ### ### ### ### ### ### ### ### ### Combustibles y Lubricantes 50,000,000 50,000,000 50,000,000 60,000,000 50,000,000 60,000,000 50,000,000 60,000,000 60,000,000 50,000,000 Seguros 20,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 15,000,000 Servicios Públicos 250,000,000 260,000,000 270,000,000 300,000,000 270,000,000 300,000,000 270,000,000 300,000,000 300,000,000 270,000,000 Sistemas Informaticos 50,000,000 10,000,000 5,000,000 30,000,000 5,000,000 30,000,000 5,000,000 30,000,000 30,000,000 5,000,000 Mantenimiento y Reparaciones 10,000,000 10,000,000 15,000,000 5,000,000 15,000,000 5,000,000 15,000,000 5,000,000 5,000,000 15,000,000 Imagen y Difusión 30,000,000 40,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 TERRENO 750,000,000 - - - - - - - - - MAQUINARIAS ### 500,000,000 - - - - - - - - OBRAS CIVILES ### - - - - - - - - - INSTALACION Y MONTAJE 70,000,000 - - - - - - - - - GASTOS DE INVERSION 50,000,000 - - - - - - - - - DEPRESIACION 247,000,000 50,000,000 - - - - - - - - IMPREVISTOS 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 100,000,000 UTILIDADES ANTES DE IMPUESTOS -3,571,187,500 ### ### ### ### ### ### ### ### ### IMPUESTOS -357,118,750 100,835,625 206,753,750 201,253,750 206,753,750 254,171,875 259,671,875 307,090,000 412,926,250 418,426,250 UTILIDAD DESPUES DE IMPUESTOS -3,214,068,750 907,520,625 ### ### ### ### ### ### ### ### F L U J O N E T O D E C A J A CAPACIDAD INSTALADA UTILIZADA 50% 65% 70% 70% 70% 75% 75% 80% 90% 90% HORIZONTE DEL PROYECTO AÑO 0 AÑO 1 AÑO 2 AÑO 3 AÑO 2 AÑO 3 AÑO 2 AÑO 3 AÑO 3 AÑO 2 TOTAL DE INGRESOS ### ### ### ### ### ### ### ### ### ### TOTAL DE EGRESOS ### ### ### ### ### ### ### ### ### ### UTILIDAD NETA -3,571,187,500 ### ### ### ### ### ### ### ### ###

Upload: joelberutti

Post on 17-Sep-2015

12 views

Category:

Documents


0 download

DESCRIPTION

Flujo de Caja - Ingeniería Financiera

TRANSCRIPT

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"