Download - Analisis Sensibilidad
XYZ C.A.Nit 911.368.286 - 4
BALANCE GENERAL INICIALAL 31 ENERO DE 2015
ACTIVOACTIVO CORRIENTEDISPONIBLE Caja y bancos 550,000,000TOTAL DISPONIBLE 550,000,000
TOTAL ACTIVO CORRIENTE 550,000,000
PROPIEDAD, PLANTA Y EQUIPO Edificaciones 430,000,000Muebles y Enseres 88,000,000Equipo de Computación 101,000,000Maquinaria y Equipo 32,000,000
TOTAL PROPIEDAD, PLANTA Y EQUIPO 651,000,000
TOTAL ACTIVO 1,201,000,000
PASIVOPASIVO CORRIENTECostos y gastos por Pagar 6,000,000Prestamos Bancarios 95,000,000
TOTAL PASIVO 101,000,000
PATRIMONIO
Capital Suscrito y Pagado 1,000,000,000Menos Capital por Suscribir -400,000,000Reserva Protección Aportes 100,000,000TOTAL PATRIMONIO 1,100,000,000
TOTAL PASIVO Y PATRIMONIO 1,201,000,000
MARCO ANTONIO ZAMBRANO OSCAR JAVIER MAHECHA BELTRAN
Representante Legal Contador
Nit 911.368.286 - 4BALANCE GENERAL INICIAL
AL 31 ENERO DE 2015
C.C. 80188866 TP 127817-T
XYZ C.A.Nit 911.368.286 - 4
PERDIDAS Y GANANCIAS PROYECTADODEL 1 ENERO AL 31 DE DICIEMBRE DE 2015
INGRESOS 1,521,720,000
Ingresos por comisiones 1,305,720,000.00Otros ingresos por Comercio exterior 216,000,000.00
TOTAL INGRESOS 1,521,720,000
COSTOS Y GASTOS 1,177,640,800
Gastos administrativos 261,144,000.00Gastos y costos Operativos 574,516,800.00Seguros 48,501,600.00Fletes INT 32,334,400.00Impuestos y Contribuciones 143,629,200.00Gastos Legales 26,114,400.00Otros Estimados 91,400,400.00
TOTAL COSTOS Y GASTOS 1,177,640,800
UTILIDAD DEL EJERCICIO 344,079,200
MARCO ANTONIO ZAMBRANO OSCAR JAVIER MAHECHA BELTRAN
Representante Legal ContadorC.C. 80188866 TP 127817-T
Página 1
XYZ C. A. RIF J-xxxxxxxx-xFLUJO DE CAJA PROYECTADO A 12 MESES
Saldo Inicial: 550,000,000.00INGRESOSACTIVIDADES DE OPERACIÓN:Ingresos por comisiones 1,305,720,000.00Otros ingresos por Comercio exterior 216,000,000.00Total Ingresos Operativos 1,521,720,000.00ACTIVIDADES DE FINANCIAMIENTO
Préstamo Bancario 95,000,000.00
Total Ingresos 1,616,720,000.00
DISPONIBILIDAD 2,166,720,000.00 100.00%
DESEMBOLSOS
ACTIVIDADES DE OPERACIÓN:
Gastos administrativos 261,144,000.00 24.48%Gastos y costos Operativos 574,516,800.00 53.86%Seguros 48,501,600.00 4.55%Fletes INT 32,334,400.00 3.03%Impuestos y Contribuciones 143,629,200.00 13.46%Gastos Legales 26,114,400.00 2.45%Diversos 91,400,400.00 8.57%
ACTIVIDADES DE FINANCIAMIENTO:
Abono a Capital 95,000,000.00 8.91%Intereses Bancarios 12,797,940.15 1.20%
Total Desembolsos 1,285,438,740.15 25.26%
TOTAL SALDOS AL FINAL 881,281,259.85 74.74%
Página 2
PROYECTADO
FLUJO DE CAJA PROYECTADO A 12 MESES
Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul-15 Aug-15 Sep-15 Oct-15
Flujo de Efectivo Mes 1 2 3 4 5 6 7 8 9 10
AUMENTO INGRESOS - 20% - - 20% - - - - -
SALDO INICIAL 550,000,000.00 650,276,838.32 662,085,676.64 673,894,514.96 685,703,353.28 699,650,591.60 713,597,829.92 727,545,068.25 741,492,306.57 755,439,544.89
Ingresos de Efectivo
Ingresos por comisiones 81,000,000 97,200,000.00 97,200,000.00 97,200,000.00 116,640,000.00 116,640,000.00 116,640,000.00 116,640,000.00 116,640,000.00 116,640,000.00
Otros ingresos por Comercio exterior 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00 18,000,000.00
Préstamo Bancario 95,000,000.00 - - - - - - -
Total Ingresos 194,000,000.00 115,200,000.00 115,200,000.00 115,200,000.00 134,640,000.00 134,640,000.00 134,640,000.00 134,640,000.00 134,640,000.00 134,640,000.00
Pagos
Gastos administrativos 16,200,000.00 19,440,000.00 19,440,000.00 19,440,000.00 23,328,000.00 23,328,000.00 23,328,000.00 23,328,000.00 23,328,000.00 23,328,000.00
Gastos y costos Operativos 35,640,000.00 42,768,000.00 42,768,000.00 42,768,000.00 51,321,600.00 51,321,600.00 51,321,600.00 51,321,600.00 51,321,600.00 51,321,600.00
Seguros 5,820,000.00 3,456,000.00 3,456,000.00 3,456,000.00 4,039,200.00 4,039,200.00 4,039,200.00 4,039,200.00 4,039,200.00 4,039,200.00
Fletes INT 3,880,000.00 2,304,000.00 2,304,000.00 2,304,000.00 2,692,800.00 2,692,800.00 2,692,800.00 2,692,800.00 2,692,800.00 2,692,800.00
Impuestos y Contribuciones 8,910,000.00 10,692,000.00 10,692,000.00 10,692,000.00 12,830,400.00 12,830,400.00 12,830,400.00 12,830,400.00 12,830,400.00 12,830,400.00
Gastos Legales 1,620,000.00 1,944,000.00 1,944,000.00 1,944,000.00 2,332,800.00 2,332,800.00 2,332,800.00 2,332,800.00 2,332,800.00 2,332,800.00
Diversos 5,670,000.00 6,804,000.00 6,804,000.00 6,804,000.00 8,164,800.00 8,164,800.00 8,164,800.00 8,164,800.00 8,164,800.00 8,164,800.00
Total Pagos 77,740,000.00 87,408,000.00 87,408,000.00 87,408,000.00 104,709,600.00 104,709,600.00 104,709,600.00 104,709,600.00 104,709,600.00 104,709,600.00
inversiones 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00 7,000,000.00
109,260,000.00 20,792,000.00 20,792,000.00 20,792,000.00 22,930,400.00 22,930,400.00 22,930,400.00 22,930,400.00 22,930,400.00 22,930,400.00
PASIVO BANCARIO
Abono a Capital 7,083,161.68 7,224,824.91 7,369,321.41 7,516,707.84 7,667,042.00 7,820,382.84 7,976,790.49 8,136,326.30 8,299,052.83 8,465,033.89
Intereses Bancarios 1,900,000.00 1,758,336.77 1,613,840.27 1,466,453.84 1,316,119.68 1,162,778.84 1,006,371.19 846,835.38 684,108.85 518,127.79
TOTAL DEUDA 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68 8,983,161.68
Saldo Neto Mensual 100,276,838.32 11,808,838.32 11,808,838.32 11,808,838.32 13,947,238.32 13,947,238.32 13,947,238.32 13,947,238.32 13,947,238.32 13,947,238.32
Saldo Final Acumulado 650,276,838.32 662,085,676.64 673,894,514.96 685,703,353.28 699,650,591.60 713,597,829.92 727,545,068.25 741,492,306.57 755,439,544.89 769,386,783.21
XYZ C. A. RIF J-xxxxxxxx-x
Disponible Antes de Amortizacion de la deuda
FLUJO DE CAJA PROYECTADO A 12 MESES
Nov-15 Dec-15
11 12 Totales %
- -
769,386,783.21 783,334,021.53 550,000,000.00
116,640,000.00 116,640,000.00 1,305,720,000 122.41%
18,000,000.00 18,000,000.00 216,000,000 20.25%
- - 95,000,000 8.91%
134,640,000.00 134,640,000.00 1,066,720,000 100.00%
23,328,000.00 23,328,000.00 261,144,000 24.48%
51,321,600.00 51,321,600.00 574,516,800 53.86%
4,039,200.00 4,039,200.00 48,501,600 4.55%
2,692,800.00 2,692,800.00 32,334,400 3.03%
12,830,400.00 12,830,400.00 143,629,200 13.46%
2,332,800.00 2,332,800.00 26,114,400 2.45%
8,164,800.00 8,164,800.00 91,400,400 8.57%
104,709,600.00 104,709,600.00 1,177,640,800 110%
7,000,000.00 7,000,000.00 84,000,000.00
22,930,400.00 22,930,400.00 - 194,920,800.00 - 0
8,634,334.56 8,807,021.25 95,000,000 8.91%
348,827.12 176,140.43 12,797,940 1.20%
8,983,161.68 8,983,161.68 107,797,940 10.11%
13,947,238.32 13,947,238.32 797,281,260 74.74%
783,334,021.53 797,281,259.85 1,347,281,259.85
TABLA DE AMORTIZACION PARA EL CALCULO DE CUOTAS
PRESTAMO 95,000,000.00
2 MES 0.00% INICIAL11 AÑO SALDO 95,000,000.00
PLAZO 12
N° FECHA MONTO CUOTA
0 0.00%1 Mar-11 8,983,161.68 8,983,161.68 2 Apr-11 8,983,161.68 8,983,161.68
3 May-11 8,983,161.68 8,983,161.68 4 Jun-11 8,983,161.68 8,983,161.68 5 Jul-11 8,983,161.68 8,983,161.68 6 Aug-11 8,983,161.68 8,983,161.68 7 Sep-11 8,983,161.68 8,983,161.68 8 Oct-11 8,983,161.68 8,983,161.68 9 Nov-11 8,983,161.68 8,983,161.68
10 Dec-11 8,983,161.68 8,983,161.68 11 Jan-12 8,983,161.68 8,983,161.68 12 Feb-12 8,983,161.68 8,983,161.68
CUOTA REGULAR
CUOTA ESPECIAL
Nota:Tabla sujeta a modificacion por variación de la tasa.
TABLA DE AMORTIZACION PARA EL CALCULO DE CUOTAS
24.00% TASA24 MESES
28.00% TASA 2
###
###
INTERES CAPITAL SALDO
95,000,000.00 1,900,000.00 7,083,161.68 87,916,838.32 1,758,336.77 7,224,824.91 80,692,013.41
1,613,840.27 7,369,321.41 73,322,692.00 1,466,453.84 7,516,707.84 65,805,984.16 1,316,119.68 7,667,042.00 58,138,942.16 1,162,778.84 7,820,382.84 50,318,559.33 1,006,371.19 7,976,790.49 42,341,768.83 846,835.38 8,136,326.30 34,205,442.53 684,108.85 8,299,052.83 25,906,389.70 518,127.79 8,465,033.89 17,441,355.82 348,827.12 8,634,334.56 8,807,021.25 176,140.43 8,807,021.25 -
12,797,940.15 ###