Copia de Excel

7/26/2019 Copia de Excel

1/19

Hugo Borraez Heredia INGEMI S.A.S BALANCE GENERAL (millones $)

ANALISIS VERTICAL % ANALISIS HO

ACTIVO 31-Dec-14 31-Dec-15 214 215 V! A"#$&'$ ACTIVO CORRIENTE

Disponible 1,300,346 2,405,622 959! 2445! (1,105,2"#nersiones %emporales & 40,000 000! 041! (40,00'as 'obrar 3,550,633 1,"95,046 261"! 1*24! 1,"55,5*#nenarios 42","59 453,210 315! 461! (25,45

+anes - +niipos 169,314 351,495 125! 35"! (1*2,1*Deposios .nregados 1*5,945 156,*93 13"! 159! 29,05/ros Deudores 365,055 313,"** 269! 319! 51,26/ros +ios 'es & 000! 000! &TOTAL ACT CORRIENTE 5()))(52 5(51*(54 4422! 5606! 4*2,99ACTIVO NO CORRIENTE

%errenos 1,012,531 "46! 1029! &.diiios 960,134 253,0"4 "0*! 25"! "0",06auinaria 2,55*,43* 2,091,664 1**6! 2126! 466,"".uipo de %ranspore 453,929 21","49 335! 221! 236,1*

uebles - .nseres, .uipo de 'om 2,31",961 1,654,194 1"09! 16*1! 663,"6/ros + ios Bruos 1"3,24* 1*9,034 12*! 192! (15,"*Depreiaion (2,61",566) (2,199,"04) &1930! &2235! (41",*6TOTAL ACT NO CORRIENTE 4(+5+(*,5 3(21+(542 35*2! 32"1! 1,640,13OTROS ACTIVOS NO CTES

#nangibles 139,094 41,*0" 103! 042! 9",2*alorizaiones 1,"44,510 000 12*6! 000! 1,"44,51+ios Dieridos *24,034 1,063,**2 60"! 10*1! (239,*4/ros + 7o 'orrienes 241 & 000! 000! 24TOTL OTROS ACT NO CTES 2(,,(+,) 1(15(*+) 1996! 1124! 1,602,19

ACTIVO TOTAL 13(5*5(** )(+4(2+5 10000! 10000! 3,"25,32

PASIVO PASIVO CORRIENTE

8roeedores de bienes - seri 15,642 3,529 012! 004! 12,11+reedores 3",924 35,503 02*! 036! 2,42+anes - +niipos eibidos 1,*"2,04" 1,435,*90 13*0! 1459! 436,15#mpuesos 8or 8agar 96,92* "9,063 0"1! 0*0! 1",*6/bligaiones :aborales 1,3"9,5*0 1,495,42* 101"! 1520! (115,*4/ros 8asios 'orrienes 135,655 13",529 100! 140! (1,*"TOTAL PASIVO CORRIENTE 3(53,(,,* 3(1+*()42 260*! 3239! 350,*3PASIVO NO CORRIENTE8roision 8ara 'oningenias 19",202 26,000 145! 026! 1"1,208asios :aborales & 000! 000! &/ros 8asios 7o 'orrienes & 000! 000! &TOTAL PASIVOS NO CTES 1),(22 2*( 145! 026! 1"1,20

PASIVO TOTAL 3(,34(),+ 3(212()42 2"53! 3265! 522,03PATRIMONIO

'apial isal 6,622,933 3,*45,444 4**2! 390*! 2,""",4*esera :egal 000! 000! &/ras as ;an eenidas & 000! 000! &.eos de


2/19

Hugo Borraez HerediaTOTAL PATRIMONIO )(+3(*2+ *(*2,(343 "24"! 6"35! 3,203,2*

PASIVO PATRIMONIO 13(5*5(** )(+4(2+5 10000! 10000! 3,"25,32

- -

INGEMI S.A.S.


3/19

Hugo Borraez Heredia.7D##.7%/


4/19

Hugo Borraez Heredia

ONTAL

V! Re7'$

&4595!&10000!

9"*0!&562!

&51*3!1*52!1634!D#0A

*"6!

000!2"939!2232!

10*46!

4013!&*35!1900!5096!

232"1!D#0A

&2254!D#0A

14490!

3"*6!

34324!6*2!

303*!2260!&""5!&136!1101!

65*4"!D#0AD#0A

65*4"!

1625!

"223!D#0A000!000!

D#0A

D#0A&4"35!


5/19

Hugo Borraez Heredia4*33!

3"*6!

IZONTALV! Re7'$

1634!

15""!

1"52!

2"2"!

002!

&535!

36"!&"*"1!

&1639!

D#0A

&4"35!

D#0A

&4"35!


6/19

Hugo Borraez Heredia


7/19

INGEMI S.A.SESTADO DE CAMBIOS EN EL CAPITAL NETO DE TRABAO

ACTIVO 31-0c-14 31-0c-15 AUMENTO DISMINUCION ACTIVO CORRIENTED#8$9"e 1,300,346 2,405,622 & 1,105,2"6I9e!#$9e# Te:8$!7e# & 40,000 & 40,000C'7# ; C$"!7! 3,550,633 1,"95,046 1,"55,5*" &I9e9'7!$# 42","59 453,210 & 25,451A79ce# < A9'c8$# 169,314 351,495 & 1*2,1*1

De8$#'$# E9'!e=70$# 1*5,945 156,*93 29,052 &O'!$# De&0$!e# 365,055 313,"** 51,26" &O'!$# Ac'$# C'e# & & & &TOTAL ACT CORRIENTE 5,999,052 5,516,054 1,*35,906 1,352,90*

PASIVO PASIVO CORRIENTEP!$ee0$!e# 0e "e9e# < #e!c. 15,642 3,529 & 12,113Ac!ee0$!e# 3",924 35,503 & 2,421A79ce# < A9'c8$# Rec"0$# 1,*"2,04" 1,435,*90 & 436,15"I:8&e#'$# P$! P7=7! 96,92* "9,063 & 1",*65O"=7c$9e# L7"$!7e# 1,3"9,5*0 1,495,42* 115,*4* &O'!$# P7#$# C$!!e9'e# 135,655 13",529 1,*"4 &

TOTAL PASIVO CORRIENTE 3,53",""6 3,1*6,942 11","22 46*,556

CAPITAL NETO DE TRABAO 2,461,2"6 2,329,112 1,953,62* 1,*21,464CAMBIOS CAPITAL NETO & 132,164SUMAS IGUALES 1,953,62* 1,953,62*

ESTADO DE CAMBIOS EN LA SITUACION FINANCIERAFUENTES 5(+5(3,2 USOS 5(+5(3,2

GRCION INTERNA RECURS 2,120,*95=%#:#D+D 7.%+ 1,463,1*5D.8.'#+'#/7 41",*62 &

+/%#?+'#/7 239,*4*8/#


8/19

INGEMI S.A.S2014 2015

INDICADORES DE LIUIDEZ

+?/7 '/#.7%. 1"0 1"38=.B+ +'#D+ 15" 159'+8#%+: 7.%/ D. %+B+@/ 2,461,2"6 2,329,112'#':/ '/7.


9/19

'#+

Copia de Excel

Documents

Transcript of Copia de Excel