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 ###