• Author / Uploaded
• det

Citation preview

BALANCE GENERAL al 31 de diciembre del 2012 AÑO012-Año Inicial 2013

2014

2015

81,218.00

132,164.00

130,828.34

371,323.45

22,528.00

82,376.00

66,742.34

320,779.45

3,027.00

702.00

30,534.24

257,981.45

3,027.00 19,501.00

702.00 42,969.00

5,288.00

6,266.00

-

38,705.00

32,035.00

56,532.00

AGUA

-

25,041.00

30,337.00

35,646.00

GUARANA

-

13,664.00

1,698.00

20,886.00

ACTIVO ACTIVO CORRIENTE Disponibilidades Caja TESORERIA INVENTARIOS CUENTAS POR COBRAR

ACTIVO FIJO

58,690.00 58,690.00 58,690.00

49,788.00 58,690.00 58,690.00

64,086.00 81,890.00 81,890.00

50,544.00 81,890.00 81,890.00

PASTEURIZADOR

17,400.00

17,400.00

17,400.00

17,400.00

LLENADORA

39,898.00

39,898.00

39,898.00

39,898.00

TAPADORA

1,392.00

1,392.00

1,392.00

1,392.00

23,200.00

23,200.00

8,902.00

17,804.00

31,346.00

ACTIVO BRUTO

MAQUINAS

VEHICULO

DEPRECIACION ACUMULADA

-

PASIVO Y PATRIMONIO

81,218.00

132,164.00

130,828.34

371,323.45

PASIVO

81,218.00

76,460.59

97,423.00

84,010.00

PASIVO CIRCULANTE

10,000.00

18,298.59 -

35,622.00 35,622.00

42,252.00 42,252.00

CUENTAS POR PAGAR LINEA DE CREDITO

PASIVO NO CIRCULANTE BANCO PATRIMONIO

10,000.00

18,298.59

71,218.00

58,162.00

61,801.00

41,758.00

71,218.00

-

58,162.00 55,703.41 7,785.17 47,918.24 -

61,801.00 33,405.34 7,785.17 (21,183.17) 47,918.24

41,758.00 287,313.45 19,365.67 241,212.71 26,735.07

-

(0.00401)

0.00099

(0.00151)

166,513.00 7,249.00

195,649.00 89,163.00

-

CAPITAL SOCIAL

-

RESERVAS RESULTADO DE LA GESTION RESULTADO ACUMULADO

-

CANTIDADES AGUA GUARANA

-

137,445.00 58,333.00

Precio AGUA GUARANA INGRESOS Ventas Agua Ventas Guarana COSTO DE VENTAS

3.5 4.5 743,556.00 481,057.50 262,498.50 412,203.00 296,097.00

AGUA - Costos de Fabricacion materia prima mano de obra gastos indirectos JUGO DE GUARANA - Costos de Fabricacion materia prima gastos indirectos mano de obra UTILIDAD BRUTA GASTOS OPERATIVOS Gastos de distribucion Agua gastos de distribucion Guarana depreciación costo mantenimiento servicios

287,545.00 1,105.00 7,447.00

348,357.00 10,984.00 7,402.00

409,311.00 10,864.00 7,321.00

116,106.00

146,779.00

179,426.00

113,514.00 2,257.00

141,061.00 2,302.00

173,507.00 2,383.00

335.00 331,353.00 119,386.30 58,048.00 17,597.00

3,416.00 101,894.00 119,557.00 67,321.00 20,934.00

3,536.00 479,083.00 137,407.00 76,547.00 24,918.00

8,902.00

8,902.00

13,542.00

3,200.00 1,200.00

3,200.00 1,200.00 6,000.00 12,000.00 -

3,200.00 1,200.00 6,000.00 12,000.00 -

211,966.70 (17,663.00) 5,341.35 4,362.15 206,625.35 - 22,025.15 51,656.34 154,969.01 - 22,025.15

341,676.00 4,635.08 337,040.93 78,753.94 258,286.98

1 55,703.41 154,969.01 99,265.60 -

3 287,313.45 292,807.22 5,493.77

transporte gastos administracion

4,800.00 25,639.30

It EBIT Intereses EBT IUE UTILIDAD NETA

AJUSTE DIVIDENDOS

0

UTILIDAD ACUMULADA COMPLETITA REAL

-

UTILIDAD ACUMULADA COMPLETITA TEORICA DIVIDENDOS

FLUJO DE CAJA UTILIDAD NETA + DEPRECIACIONES - C ACTIVOS + C PASIVOS + C PATRIMONIO - DIVIDENDOS

0

615,416.00 1,086,005.00 582,795.50 684,771.50 32,620.50 401,233.50 513,522.00 606,922.00 366,743.00 427,496.00

1 154,969.01 8,902.00 - 62,173.00 4,757.41 - 99,265.60

2 34,520.24 33,678.26 841.98

2 3 22,025.15 258,286.98 8,902.00 13,542.00 21,151.00 - 25,475.00 20,962.41 - 13,413.00 841.98 5,493.77

FLUJO DE CAJA

-

DISPONIBILIDADES INICIALES DISPONIBILIDADES FINALES CONTROL

0

FLUJO DE CAJA OPERATIVO UTILIDAD NETA + GASTOS FINANCIEROS + DEPRECIACIONES Y AMORTIZACIONES

INVENTARIOS AGUA GUARANA CUENTAS POR PAGAR FLUJO DE CAJA DE INVERSION

ACTIVO BRUTO FLUJO DE CAJA DE FINANCIAMIENTO

GASTOS FINANCIEROS

-

LINEA DE CREDITO

BANCO CAPITAL SOCIAL

DIVIDENDOS FLUJO DE CAJA DISPONIBILIDADES INICIALES DISPONIBILIDADES FINALES CONTROL

-

2,325.00 3,027.00 702.00 0.00

29,832.24 702.00 30,534.24 -

227,447.21 30,534.24 257,981.45 -

1 2 3 107,039.36 71,212.00 257,619.06 160,310.36 (17,663.00) 262,922.06 8,902.00 8,902.00 13,542.00 (23,468.00) 37,681.00 (978.00) (25,041.00) (5,296.00) (5,309.00) (13,664.00) 11,966.00 (19,188.00) 35,622.00 6,630.00 - - 23,200.00 - - 23,200.00 109,364.36 - 18,179.76 - 30,171.85 5,341.35 4,362.15 4,635.08 8,298.59 - 18,298.59 (13,056.00) 3,639.00 (20,043.00) 99,265.60 841.98 5,493.77 2,325.00 29,832.24 227,447.21 3,027.00 702.00 30,534.24 702.00 30,534.24 257,981.45 (0.00) -

2016

2017 CAMBIOS

909,007.54

226,030.04

872,005.54

202,570.04

767,922.54

3,032.04

74,462.00

120,486.00

29,621.00

79,052.00

4,095.00

47,708.00

25,526.00

31,344.00

37,002.00 81,890.00 81,890.00

23,460.00 81,890.00 81,890.00

17,400.00

17,400.00

39,898.00

39,898.00

1,392.00

1,392.00

23,200.00

23,200.00

44,888.00

58,430.00

62,173.00 - 21,151.00

25,475.00

41,285.00

95,455.00

23,468.00 - 37,681.00

978.00

68,196.00

46,024.00

5,309.00 - 31,551.00 19,188.00 4,640.00

43,613.00 5,818.00

25,041.00 5,296.00 13,664.00 - 11,966.00 -

-

909,007.54 70,987.00 49,273.00 49,273.00

21,714.00 838,020.54 51,901.03 618,171.73 167,947.78

-

-

-

-

-

-

-

226,030.04 - -

21,714.00

23,200.00

4,757.41

20,962.41 - 13,413.00 - 13,023.00 - 70,987.00

35,622.00 8,298.59 - 18,298.59

6,630.00 -

7,021.00 - 49,273.00 -

- - 13,056.00 226,030.04 71,301.50 368,609.03 (213,880.49)

0.00099

0.00099

224,763.00 108,969.00

261,857.00 133,807.00

3,639.00 - 20,043.00 - 20,044.00 - 21,714.00 -

1,277,031.00 1,518,631.00 786,670.50 916,499.50 490,360.50 602,131.50 283,175.00 832,307.00 64,926.00 565,480.00 47,022.00 10,696.00 7,208.00

547,822.00 10,549.00 7,109.00

218,249.00

266,827.00

212,049.00 2,496.00

260,381.00 2,595.00

3,704.00 993,856.00 124,618.00 85,708.00 2,968.00

3,851.00 686,324.00 168,978.00 97,463.00 35,573.00

13,542.00

13,542.00

3,200.00 1,200.00 6,000.00 12,000.00 -

3,200.00 1,200.00 6,000.00 12,000.00 -

869,238.00 3,131.85 866,106.15 216,526.54 649,579.61

517,346.00 1,628.55 515,717.45 128,929.36 386,788.09

4 5 838,020.54 226,030.04 936,893.06 1,224,808.63 98,872.53 998,778.59

4 5 649,579.61 386,788.09 13,542.00 13,542.00 - 41,285.00 - 95,455.00 - 13,023.00 - 70,987.00 - 98,872.53 - 998,778.59

509,941.09 - 764,890.50 257,981.45 767,922.54 767,922.54 3,032.04 4 5 631,989.46 257,230.64 652,711.46 388,416.64 13,542.00 13,542.00 (68,196.00) (46,024.00) 31,551.00 (43,613.00) (4,640.00) (5,818.00) 7,021.00 (49,273.00) - 122,048.38 -1,022,121.14 3,131.85 1,628.55 (20,044.00) (21,714.00) - 98,872.53 - 998,778.59 509,941.09 - 764,890.50 257,981.45 767,922.54 767,922.54 3,032.03 0.00