Ejercicio Excel
Ejercicio Excel
Ejercicio Excel
2,327,424,118 1,336,573,029
2,327,424,118 1,336,573,029
2,327,424,118 1,336,573,029
1,160,637,927 507,730,532
623,882,016 574,291,020
42,933,165 56,165
- 2,421,283
- 6,000
499,971,010 147,623,741
- 104,444,289
4,860,212 89,254,914
- 93,418,326
- 90,544,483
- 60,053,746
- 30,490,737
- 2,873,843
- 2,873,843
- 24,211,499
- 19,211,499
- 19,211,499
- 5,000,000
- 4,310,345
- 689,655
- 43,395,058
- 42,068,832
- 42,068,832
- 1,326,226
- 1,326,226
4,860,212 - (71,769,969)
- - (37,381,240)
- - (37,381,240)
4,352,125 - (11,502,716)
4,352,125 - (11,502,716)
508,087 - (22,886,013)
508,087 - (22,886,013)
- -
- -
14,026,765 -
14,026,765 -
14,026,765 -
14,026,765 -
175,774,918 - (169,679,510)
175,774,918 - (169,679,510)
175,774,918 - (169,679,510)
7,703,421 - (239,711)
- - (9,152,169)
- -
- - (6,757,787)
21,071,497 - (6,529,843)
147,000,000 - (147,000,000)
1,223,867,582 - (335,775,904)
1,223,867,582 - (335,775,904)
1,223,867,582 - (335,775,904)
1,223,867,582 - (335,775,904)
741,837,987 - (282,675,099)
95,680,224 - (38,527,392)
95,680,224 - (38,527,392)
95,680,224 - (38,527,392)
385,388,940 - (142,314,148)
- -
- -
19,985,063 - (414,000)
19,985,063 - (414,000)
150,347,257 - (131,832,906)
147,347,257 - (131,832,906)
3,000,000 -
20,136,424 -
20,136,424 -
3,960,000 - (3,960,000)
3,960,000 - (3,960,000)
6,488,083 - (1,252,211)
6,488,083 - (1,252,211)
48,117,453 - (762,000)
48,117,453 - (762,000)
136,354,660 - (4,093,031)
75,514,838 - (1,999,998)
46,175,208 - (1,648,440)
14,664,614 - (444,593)
92,064,864 - (82,312,363)
92,064,864 - (82,312,363)
29,764,864 - (52,312,363)
62,300,000 - (30,000,000)
17,417,657 - (6,329,212)
183,295 -
183,295 -
222,280 -
222,280 -
8,093,587 - (3,874,024)
911,001 -
40,000 -
2,046,928 -
5,095,658 - (3,874,024)
677,116 - (53,218)
677,116 - (53,218)
8,241,379 - (2,401,970)
8,241,379 - (2,401,970)
1,328,162 - (60,492)
1,328,162 - (60,492)
328,865 -
517,104 - (36,492)
398,304 - (24,000)
83,889 -
4,416,332 - (1,360)
4,416,332 - (1,360)
- 4,372,000
4,233,872 - (4,190,900)
182,460 - (182,460)
11,258,000 -
11,258,000 -
11,258,000 -
62,669,659 - (6,081,632)
19,521,263 - (1,908,340)
19,521,263 - (1,908,340)
25,254,440 - (2,455,936)
5,597,519 -
19,656,921 - (2,455,936)
17,893,956 - (1,717,356)
17,572,656 - (1,717,356)
192,800 -
128,500 -
71,614,149 - (7,048,500)
71,294,149 - (7,048,500)
70,695,099 - (7,018,500)
599,050 - (30,000)
320,000 -
320,000 -
284,101,269 - (18,231,707)
1,757,000 - (1,757,000)
1,757,000 - (1,757,000)
1,757,000 - (1,757,000)
263,847,938 - (5,252,707)
263,847,938 - (200,233,666)
263,373,196 - (199,758,924)
474,742 - (474,742)
- 173,498,273 -
- 145,731,196 -
- 5,591,077 -
- 22,176,000 -
- 21,482,686 -
- 21,482,686 -
9,364,000 - (2,091,000)
9,364,000 - (2,091,000)
9,364,000 - (2,091,000)
9,132,331 - (9,131,000)
9,132,331 - (9,131,000)
9,132,331 - (9,131,000)
490,886,724 - (17,618,307)
473,268,417 - -
473,268,417 - -
473,268,417 - -
10,328,199 - (10,328,199)
10,328,199 - (10,328,199)
10,328,199 - (10,328,199)
1,190,973 - (1,190,973)
1,190,973 - (1,190,973)
1,190,973 - (1,190,973)
6,099,135 - (6,099,135)
6,099,135 - (6,099,135)
6,099,135 - (6,099,135)
176,019,942 -
101,776,942 -
37,746,220 -
37,746,220 -
4,513,310 -
4,513,310 -
21,768,818 -
21,768,818 -
37,748,594 -
37,748,594 -
74,243,000 -
74,243,000 -
74,243,000 -
1,157,873,854 - (439,223,695)
1,141,744,599 - (438,071,803)
1,141,744,599 - (438,071,803)
1,141,744,599 - (438,071,803)
16,129,255 - (1,151,892)
16,129,255 - (1,151,892)
8,762,092 - (578,170)
125,170 -
7,241,993 - (573,722)
- - (100,000,000)
- - (100,000,000)
- - (100,000,000)
- - (100,000,000)
- - (30,538,092)
- - (30,538,092)
- - (30,538,092)
- - (30,538,092)
- -
- -
- -
- -
- -
- -
- -
- -
- -
- -
- - (142,982,270)
- - (142,982,270)
- - (142,982,270)
- - (142,982,270)
3,441,447 - (330,053,422)
3,441,447 - (330,053,422)
3,441,447 - (330,053,422)
3,441,447 - (330,053,422)
2,517,374,324 - (2,482,430,095)
2,517,374,324 - (2,517,374,324)
2,517,374,324 - (2,517,374,324)
1,640,374,140 - (1,640,374,140)
877,000,184 - (877,000,184)
- 34,944,229
- 34,944,229
- 34,944,229
24,680,149 (24,675,260)
5,403,080 (5,403,080)
17,336 (17,336)
17,336 (17,336)
112,788 (112,788)
112,788 (112,788)
5,272,956 (5,272,956)
5,272,956 (5,272,956)
170,000 (170,000)
170,000 (170,000)
170,000 (170,000)
2,303,239 (2,303,239)
2,303,239 (2,303,239)
2,303,239 (2,303,239)
2,391,255 (2,391,255)
805,246 (805,246)
805,246 (805,246)
1,586,009 (1,586,009)
1,586,009 (1,586,009)
14,412,575 (14,407,686)
39,065 (39,065)
39,065 (39,065)
5,708,293 (5,708,293)
5,708,293 (5,708,293)
16,029 (16,029)
16,029 (16,029)
8,649,187 (8,644,298)
8,649,187 (8,644,298)
1,141,464 1,173,110,695
1,071,464 676,298,222
- 401,296,832
- 401,296,832
- 2,420,249
- 2,420,249
- 32,337,285
- 32,337,285
- 308,000
- 308,000
- 24,494,400
- 24,494,400
137,372 37,608,848
137,372 37,608,848
668,808 3,844,502
668,808 3,844,502
137,372 37,611,222
137,372 37,611,222
122,042 18,609,209
122,042 18,609,209
- 11,803,274
- 11,803,274
- 7,260,137
- 6,541,625
- 469,288
- 249,224
- 300,000
- 300,000
- 276,000
- 276,000
- 25,254,440
- 25,254,440
4,961 1,845,897
4,961 1,845,897
909 53,021,027
909 53,021,027
- 17,572,656
- 17,572,656
- 192,800
- 192,800
- 128,500
- 128,500
- 112,944
- 112,944
- 19,266,600
- 9,000,000
- 9,000,000
- 10,266,600
- 10,266,600
- 21,609,444
- 19,683,944
- 18,918,303
- 321,220
- 444,421
- 1,925,500
- 1,925,500
- 21,546,000
- 21,546,000
- 21,546,000
- 7,274,965
- 140,108
- 140,108
- 1,260,256
- 1,260,256
- 5,874,601
- 2,641,804
- 3,232,797
- 293,427,627
- 239,641,035
- 138,503,548
- 96,121,407
- 5,016,080
- 3,224,420
- 3,224,420
- 2,459,940
- 2,459,940
- 9,375,560
- 9,375,560
- 14,038,574
- 1,982,612
- 10,810,503
- 1,245,459
- 482,500
- 482,500
- 12,938,309
- 5,436,073
- 7,502,236
- 91,391
- 91,391
- 11,175,898
- 3,664,532
- 7,511,366
- 625,100
- 625,100
- 595,000
- 30,100
- 1,430,529
- 295,000
- 295,000
- 819,520
- 819,520
- 116,000
- 116,000
- 200,009
- 200,009
- 105,000
- 105,000
- 105,000
- 25,771,327
- 12,091,531
- 11,065,788
- 1,025,743
- 1,720,950
- 1,720,950
- 8,038,000
- 7,749,000
- 289,000
- 95,700
- 95,700
- 3,825,146
- 677,500
- 3,147,646
- 4,352,125
- 4,352,125
- 4,352,125
- 14,026,765
- 14,026,765
- 14,026,765
70,000 87,376,992
- 40,718
- 25,720
- 14,998
- 376,500
- 93,000
- 283,500
- 877,940
- 877,940
- 3,250,785
- 3,246,735
- 4,050
- 4,993,343
- 4,993,343
- 14,289,147
- 14,289,147
- 19,094,886
- 14,183,477
- 4,911,409
- 15,800
- 15,800
70,000 44,437,873
70,000 36,059,947
- 8,377,926
- 7,553,886
- 7,553,886
- 7,524,086
- 7,524,086
- 9,800
- 9,800
- 20,000
- 20,000
4,906 63,127,872
4,424 28,697,064
- 11,599,548
- 894,291
- 103,881
- 2,285,072
- 722,236
- 1,383,397
- 5,249,774
- 960,897
- 279,961
- 279,961
4,424 13,512,500
- 1,870,107
4,424 6,842,393
- 4,800,000
- 21,307
- 21,307
- 3,283,748
- 3,283,748
- 12,695,915
- 12,695,915
- 10,994,196
- 1,503,619
- 169,480
- 28,620
482 21,734,893
- 275,000
- 275,000
482 21,459,893
- 21,419,376
482 40,517
- 74,243,000
- 74,243,000
- 74,243,000
- 74,243,000
612,900 1,085,577,571
612,900 1,085,577,571
612,900 1,085,577,571
612,900 1,085,577,571
2,967,139 (2,967,139)
2,967,139 (2,967,139)
2,967,139 (2,967,139)
2,967,139 (2,967,139)
GRUPO DESCRIPCION PARCIAL SUBTOTAL TOTAL
11 DISPONIBLE 119,671,319.67
1105 CAJA 2,000,000.00
1110 BANCOS 71,850,720.01
1120 CUENTAS DE AHORRO 45,820,599.66
12 INVERSIONES 1,904,400.00
1295 OTRAS INVERSIONES 1,904,400.00
13 DEUDORES 326,289,868.00
1305 CLIENTES 291,961,868.00
1330 ANTICIPOS Y AVANCES 6,390,000.00
1355 ANTICIPO DE IMPUESTOS Y CONTRIB. O 27,888,000.00
1365 CUENTAS POR COBRAR A TRABAJADORES 50,000.00
1380 DEUDORES VARIOS
1399 PROVISION
14 INVENTARIOS 1,305,699,250.99
1435 MERCANCIAS NO FABRICADAS POR LA EMP 1,305,699,250.99
17 DIFERIDOS 9,665,495.00
1710 CARGOS DIFERIDOS 9,665,495.00
5,713,200.00
5,713,200.00
400,596,093.00
291,434,720.00
79,571,357.00
24,589,398.00
2,945,000.00
2,055,618.00
1,336,573,029.44
1,336,573,029.44
1,883,982,562.02 1883982562
0.02
89,254,914.00
93,418,326.00
24,211,499.00
43,395,058.00
- 71,769,969.00
89,254,914.00
1,973,237,476.02
#DIV/0!
#DIV/0!
base valor porcentaje alcance valor material
41 Ingresos ordinarios 2,482,430,095 10.00%
1 Total activos 1,973,237,476 1.00% 10.00% 1,973,000
Utilidad bruta 10.00%
Utilidad neta 10.00%
Patrimonio 10.00%
SMLV 616,000
Materialidad en SMLV 3.20
Edad Valor Porcentaje Vlr provisión Total
Cartera COMPOSICION DE LA CAR
Individual Edad
General Hasta 90 días
De 121 a 180 De 91 a 120
DE 181 a 360 De 121 a 180
Más de 360 DE 181 a 360
Combinado Más de 360
De 121 a 180 Provisión
DE 181 a 360
Más de 360
Valor a provisionar
COMPOSICION DE LA CARTERA
Participación Valor
Naturaleza
Códigos DESCRIPCION DE LA CUENTA
Dédito Crédito
Grupo cuenta bajo NIIF Ajustes Saldo NIIF
Grupo Clasificación Dédito Crédito Dédito
Saldo NIIF
Crédito
Naturaleza
CODIGO DESCRIPCION DE LA CUENTA
Dédito Crédito
Soporte normativo
SUMAS IGUALES
Soporte normativo
ESTADO DE SITUACION FINANCIERA DE APERTURA 01-01-2015 (CIFRAS EN MILES)