0% encontró este documento útil (0 votos)
31 vistas20 páginas

Excel B-10

Cargado por

julio
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
31 vistas20 páginas

Excel B-10

Cargado por

julio
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLSX, PDF, TXT o lee en línea desde Scribd

ABARROTER

ESTADOS DE SITUACION FINAN

ACTIVOS

HISTORICOS SUBCUENTAS

EFECTIVOS Y EQUIVALENTES $ 7,327,358.67


CXC A CLIENTES Y DEUDORES DIVERSOS $ 20,516,205.48
INVENTARIOS $ 440,000.00
TERRENO Y CONSTRUCCIONES $ 2,882,500.00
MOI 5,450,000.00
DEPRECIACION ACUMULADA 2,567,500.00
COSTOS ESPECIFICOS O VALOR MERCADO
MOBILIARIO Y MAQUINARIA Y EQUIPO $ 630,833.33
MOI 3,400,000.00
DEPRECIACION ACUMULADA 2,769,166.67
COSTOS ESPECIFICOS O VALOR MERCADO
EQUIPO DE COMPUTO $ 408,375.00
MOI 840,000.00
DEPRECIACION ACUMULADA 431,625.00
COSTOS ESPECIFICOS O VALOR MERCADO
EQUIPO DE TRANSPORTE $ 253,719.19
MOI 473,598.00
DEPRECIACION ACUMULADA 219,878.81
COSTOS ESPECIFICOS O VALOR MERCADO

TOTAL DE ACTIVOS $ 32,458,991.67


ABARROTERA HUMANITAS SA DE CV
ESTADOS DE SITUACION FINANCIERA AL 31 DE DICIEMBRE 2023 (CIFRAS HISTORICAS)

ACTUALIZADOS SUBCUENTAS

$ 7,327,358.67
$ 20,516,205.48
$ 930,000.00
$ 17,520,000.00
- 9,714,855.78
- 4,535,744.67
- 12,340,888.89
$ 1,335,000.00
5,029,189.62
4,119,831.63
425,642.01
$ 1,090,000.00
925,046.79
478,315.56
643,268.77
$ 520,957.80
529,367.17
248,088.31
239,678.94

$ 49,239,521.95 16,780,530.28
ANITAS SA DE CV
E DICIEMBRE 2023 (CIFRAS HISTORICAS)

PASIVO

HISTORICOS ACTUALIZADOS

PROVEEDORES 3,528,327.00 3,528,327.00


ACREEDORES 4,482,360.53 4,482,360.53

TOTAL DE PASIVO A CORTO Y LARGO PLAZO $ 8,010,687.53 $ 8,010,687.53

CAPITAL CONTABLE

CAPITAL SOCIAL 7,000,000.00 12,628,445.13


RESULTADOS DE EJERCICIOS ENTERIORES 16,393,535.69 22,468,664.82
RESULTADO DEL EJERCICIO 1,054,768.44 1,079,549.94
REPOMO PATRIMONIAL 9,087,304.09
RETANM 14,139,478.61

TOTAL DE CAPITAL CONTABLE $ 24,448,304.13 $ 41,228,834.41

TOTAL PASIVO + CAPITAL CONTABLE $ 32,458,991.66 $ 49,239,521.94

0.01 0.01
13,381,360.73
ABARROTERA HUMANITAS SA DE CV
INTEGRACION DE ACTIVO FIJO Y B-10

12/31/2023
FECHAS CONCEPTO MOI TASA DE DEPREC

1 1/2/2010 TERRENO Y CONSTRUCCION $ 1,500,000.00 0%


2 12/27/2010 TERRENO Y CONSTRUCCION $ 3,950,000.00 5%

TERRENO Y CONSTRUCCION 5,450,000.00

1 1/25/2015 MOBILIARIO Y MAQUINARIA Y EQUIPO 2,350,000.00 10%


2 7/27/2017 MOBILIARIO Y MAQUINARIA Y EQUIPO 1,050,000.00 10%

MOBILIARIO Y MAQUINARIA Y EQUIPO 3,400,000.00

1 11/27/2021 EQUIPOS DE COMPUTO 425,000.00 30%


2 8/1/2022 EQUIPOS DE COMPUTO 415,000.00 30%

EQUIPOS DE COMPUTO 840,000.00

1 8/26/2021 EQUIPOS DE TRANSPORTES 227,547.00 25%


2 7/27/2022 EQUIPOS DE TRANSPORTES 246,051.00 25%

EQUIPOS DE TRANSPORTES 473,598.00

1 1/1/2010 APORTACION CAPITAL 5,000,000.00


2 7/1/2011 APORTACION CAPITAL 2,000,000.00

APORTACION CAPITAL 7,000,000.00

18.00 100%
5.40 30.00%
AS SA DE CV
B-10

% DE DEPRE DEPRECIAION INPC


ACUMULADO HISTORICA ADQUISICION

0% - 72.5520
65% 2,567,500.00 74.9310

2,567,500.00 2,882,500.00

89.17% 2,095,416.67 87.1101


64.17% 673,750.00 95.3227

2,769,166.67 630,833.33

62.50% 265,625.00 116.8840


40.00% 166,000.00 123.8030

431,625.00 408,375.00

58.33% 132,735.75 113.8990


35.42% 87,143.06 122.9480

219,878.81 253,719.19

72.5520
75.5161
INPC MAS
ACTUAL FACTOR MOI (ACTIVO) DEPRECIACION REPOMO
12/31/2023 ACTUALIZACION ACTUALIZADO ACTUALIZADO

132.3730 0.8245 1,236,787.05 - $ 2,736,787.05


132.3730 0.7666 3,028,068.73 1,968,244.67 $ 2,442,324.05

4,264,855.78 1,968,244.67 5,179,111.11

132.3730 0.5196 1,221,073.16 1,088,790.23 $ 386,866.26


132.3730 0.3887 408,116.46 261,874.73 $ 522,491.73

1,629,189.62 1,350,664.96 909,357.99

132.3730 0.1325 56,319.30 35,199.56 $ 180,494.74


132.3730 0.0692 28,727.49 11,491.00 $ 266,236.50

85,046.79 46,690.56 446,731.23

132.3730 0.1622 36,907.29 21,529.25 $ 110,189.29


132.3730 0.0767 18,861.88 6,680.25 $ 171,089.57

55,769.17 28,209.50 281,278.86

APORT ACT
132.3730 0.8245 4,122,623.51 - $ 9,122,623.51
132.3730 0.7529 1,505,821.62 - $ 3,505,821.62

5,628,445.13 - 12,628,445.13
COSTOS ESPECIFICOS ACUMULADOS
MOI POR PERITO RETANM INTEGRADO POR KG
VALUADOR AGUACATE 10000
LIMON 10000
5,500,000.00 2,763,212.95
12,020,000.00 9,577,675.95
VALOR DE REPOSICION
17,520,000.00 12,340,888.89 AGUACATE 10000
LIMON 10000
730,000.00 343,133.74
605,000.00 82,508.27

1,335,000.00 425,642.01

467,500.00 287,005.26
622,500.00 356,263.50

1,090,000.00 643,268.77

250,301.70 140,112.41
270,656.10 99,566.53

520,957.80 239,678.94
PRECIO
$32 $320,000.00
$12 $120,000.00
$440,000.00

$61.50 $615,000.00
$31.50 $315,000.00
$930,000.00 $490,000.00
12/31/2023 AÑOS 6/1/2010 6/1/2011 6/1/2012
RESULTADOS EJERCICIOS ANTERIORES 602,012.00 671,664.79 749,376.40

INPC ACTUAL 132.3730 132.3730 132.3730


INPC DE JUNIO 72.7712 75.1555 78.4137
FACTOR DE ACTUALIZACION 1.8190 1.7613 1.6881

RESULTADO DE EJ. ANT.ACTUAL 1,095,078.17 1,183,017.53 1,265,049.91

12/31/2023

ESTADO DE RESULTADO 2023


1/1/2023 2/1/2023 3/1/2023
INGRESOS 1,088,555.00 1,104,883.33 1,121,456.57
COSTOS Y GASTOS 1,007,675.36 1,022,790.49 1,038,132.35

UTILIDAD 80,879.64 82,092.84 83,324.22

INPC DICIEMBRE 132.3730 132.3730 132.3730


INPC CORRESPONDIENTE 127.3360 128.0460 128.3890

FACTOR DE ACTUALIZACION 1.0396 1.0338 1.0310

ACTUALIZACION INGRESOS 1,131,615 1,142,220 1,156,256


ACTUALIZACION GASTOS 1,047,536 1,057,353 1,070,346
6/1/2013 6/1/2014 6/1/2015 6/1/2016 6/1/2017 6/1/2018 6/1/2019
836,079.25 932,813.62 1,040,740.16 1,161,153.80 1,295,499.29 1,445,388.56 1,612,620.02

132.3730 132.3730 132.3730 132.3730 132.3730 132.3730 132.3730


81.6192 84.6821 87.1131 89.3240 94.9636 99.3765 103.2990
1.6218 1.5632 1.5196 1.4819 1.3939 1.3320 1.2815

1,355,983.24 1,458,152.05 1,581,460.02 1,720,762.21 1,805,839.88 1,925,309.18 2,066,499.67

4/1/2023 5/1/2023 6/1/2023 7/1/2023 8/1/2023 9/1/2023 10/1/2023


1,138,278.42 1,155,352.60 1,172,682.89 1,190,273.13 1,208,127.23 1,226,249.14 1,244,642.87
1,053,704.34 1,069,509.90 1,085,552.55 1,101,835.84 1,118,363.38 1,135,138.83 1,152,165.91

84,574.08 85,842.70 87,130.34 88,437.29 89,763.85 91,110.31 92,476.96

132.3730 132.3730 132.3730 132.3730 132.3730 132.3730 132.3730


128.3630 128.0840 128.2140 128.8320 129.5450 130.1200 130.6090

1.0312 1.0335 1.0324 1.0275 1.0218 1.0173 1.0135

1,173,838 1,194,041 1,210,722 1,222,988 1,234,501 1,247,481 1,261,453


1,086,622 1,105,323 1,120,766 1,132,120 1,142,778 1,154,794 1,167,727
6/1/2020 6/1/2021 6/1/2022
1,799,200.15 2,007,367.61 2,239,620.04 16,393,535.69

132.3730 132.3730 132.3730


106.7430 113.0180 122.0440
1.2401 1.1713 1.0846

2,231,205.06 2,351,141.17 2,429,166.72 22,468,664.82

11/1/2023 12/1/2023 TOTAL


1,263,312.52 1,282,262.21 14,196,075.91
1,169,448.40 1,186,990.12 13,141,307.47
-
93,864.12 95,272.09 1,054,768.44

132.3730 132.3730
131.4450 132.3730

1.0071 1.0000
-
1,272,231 1,282,262 14,529,608.86
1,177,705 1,186,990 13,450,058.92
1,079,549.94
ACTUALIZACION DE ACTIVOS

TERRENO Y CONSTRUCCION MOBILIARIO Y MAQUINARIA Y EQUIPO


1 1,236,787.05 - 1,221,073.16
2 3,028,068.73 - 408,116.46

4,264,855.78 1,629,189.62

ACTUALIZACION DE DEPRECIACION

TERRENO Y CONSTRUCCION MOBILIARIO Y MAQUINARIA Y EQUIPO


1 - 1,088,790.23
2 1,968,244.67 261,874.73

- 1,968,244.67 - 1,350,664.96

VALOR MERCADO

TERRENO Y CONSTRUCCION MOBILIARIO Y MAQUINARIA Y EQUIPO


1 2,763,212.95 343,133.74
2 9,577,675.95 82,508.27

12,340,888.89 - 425,642.01 -

ACTUALIZACION CAPITAL SOCIAL

APORTACION CAPITAL
1 4,122,623.51
2 1,505,821.62

- 5,628,445.13
ACTUALIZACION DE EJERCICIOS ANTERIORES Y ACTUA

EJERCICIOS ANTERIORES INGRESOS


6,075,129.13 333,532.95

- 6,075,129.13 - 333,532.95
ZACION DE ACTIVOS

EQUIPOS DE COMPUTO EQUIPOS DE TRANSPORTES


56,319.30 36,907.29
28,727.49 18,861.88

85,046.79 55,769.17

ION DE DEPRECIACION

EQUIPOS DE COMPUTO EQUIPOS DE TRANSPORTES


35,199.56 21,529.25
11,491.00 6,680.25

- 46,690.56 - 28,209.50

OR MERCADO

EQUIPOS DE COMPUTO EQUIPOS DE TRANSPORTES


287,005.26 140,112.41
356,263.50 99,566.53

643,268.77 - 239,678.94 -

CION CAPITAL SOCIAL


ERCICIOS ANTERIORES Y ACTUAL

GASTOS
308,751.45

308,751.45 -
CORRECION POR REEXPRESION
1,968,244.67 4,264,855.78
1,350,664.96 1,629,189.62
46,690.56 85,046.79
28,209.50 55,769.17
5,628,445.13 308,751.45
6,075,129.13
333,532.95

15,430,916.90 6,343,612.82 REPOMO PATRIMONIAL DESFAVORABL


9,087,304.09 9,087,304.09

9,087,304.09
RETANM
12,340,888.89
425,642.01
643,268.77
239,678.94
490,000.00

14,139,478.61

REPOCION INVENTARIO
$490,000.00

490,000.00 -
O PATRIMONIAL DESFAVORABLE

-
Ene Feb Mar Abr May Jun
2024 133.55500 133.68100 134.06500 134.33600 134.08700 134.59400
2023 127.33600 128.04600 128.38900 128.36300 128.08400 128.21400
2022 118.00200 118.98100 120.15900 120.80900 121.02200 122.04400
2021 110.21000 110.90700 111.82400 112.19000 112.41900 113.01800
2020 106.44700 106.88900 106.83800 105.75500 106.16200 106.74300
2019 103.10800 103.07900 103.47600 103.53100 103.23300 103.29900
2018 98.79500 99.17137 99.49216 99.15485 98.99408 99.37646
2017 93.60388 94.14478 94.72249 94.83893 94.72549 94.96364
2016 89.38638 89.77778 89.91000 89.62528 89.22561 89.32403
2015 87.11010 87.27538 87.63072 87.40384 86.96737 87.11311
2014 84.51905 84.73316 84.96529 84.80678 84.53558 84.68207
2013 80.89278 81.29094 81.88743 81.94152 81.66882 81.61924
2012 78.34305 78.50231 78.54739 78.30098 78.05382 78.41367
2011 75.29599 75.57846 75.72345 75.71744 75.15926 75.15551
2010 72.55205 72.97167 73.48973 73.25556 72.79398 72.77118
2009 69.45615 69.60949 70.00995 70.25499 70.05036 70.17935
2008 65.35056 65.54483 66.01989 66.17013 66.09864 66.37217
2007 63.01621 63.19235 63.32911 63.29130 62.98253 63.05817
2006 60.60363 60.69636 60.77251 60.86162 60.59067 60.64300
2005 58.30916 58.50343 58.76712 58.97642 58.82825 58.77178
2004 55.77432 56.10794 56.29807 56.38303 56.24160 56.33174
2003 53.52544 53.67412 54.01293 54.10514 53.93056 53.97511
2002 50.90047 50.86775 51.12795 51.40723 51.51143 51.76259
2001 48.57548 48.54333 48.85089 49.09731 49.20997 49.32636
2000 44.93083 45.32938 45.58068 45.84002 46.01138 46.28392
1999 40.46977 41.01364 41.39468 41.77458 42.02588 42.30201
1998 34.00392 34.59924 35.00453 35.33204 35.61348 36.03442
1997 29.49889 29.99460 30.36789 30.69597 30.97612 31.25096
1996 23.32975 23.87426 24.39983 25.09345 25.55084 25.96690
1995 15.37699 16.02871 16.97362 18.32613 19.09209 19.69802
Jul Ago Sep Oct Nov Dic
136.00300 136.01300 136.08000 136.82800 137.42400
128.83200 129.54500 130.12000 130.60900 131.44500 132.37300
122.94800 123.80300 124.57100 125.27600 125.99700 126.47800
113.68200 113.89900 114.60100 115.56100 116.88400 117.30800
107.44400 107.86700 108.11400 108.77400 108.85600 109.27100
103.68700 103.67000 103.94200 104.50300 105.34600 105.93400
99.90910 100.49200 100.91700 101.44000 102.30300 103.02000
95.32274 95.79377 96.09352 96.69827 97.69517 98.27288
89.55691 89.80933 90.35774 90.90615 91.61683 92.03903
87.24082 87.42488 87.75242 88.20392 88.68547 89.04682
84.91496 85.21997 85.59634 86.06963 86.76378 87.18898
81.59219 81.82433 82.13234 82.52299 83.29227 83.77006
78.85390 79.09054 79.43912 79.84104 80.38344 80.56824
75.51611 75.63556 75.82111 76.33271 77.15833 77.79239
72.92919 73.13175 73.51511 73.96893 74.56158 74.93095
70.37052 70.53888 70.89272 71.10719 71.47605 71.77186
66.74206 67.12749 67.58493 68.04549 68.81894 69.29555
63.32600 63.58400 64.07770 64.32741 64.78122 65.04906
60.80929 61.11961 61.73661 62.00652 62.33186 62.69242
59.00180 59.07226 59.30901 59.45458 59.88249 60.25031
56.47939 56.82804 57.29792 57.69475 58.18690 58.30709
54.05334 54.21549 54.53824 54.73821 55.19254 55.42981
51.91118 52.10856 52.42198 52.65304 53.07888 53.30993
49.19820 49.48969 49.95038 50.17614 50.36515 50.43490
46.46447 46.71979 47.06107 47.38514 47.79029 48.30767
42.58158 42.82126 43.23502 43.50885 43.89578 44.33552
36.38188 36.73163 37.32738 37.86227 38.53279 39.47297
31.52321 31.80350 32.19961 32.45694 32.82004 33.27987
26.33603 26.68607 27.11275 27.45117 27.86708 28.75934
20.09959 20.43298 20.85564 21.28476 21.80961 22.52017

También podría gustarte