Grupo Nutresa Actual
Grupo Nutresa Actual
Grupo Nutresa Actual
(Colombia)
Fuente:
Horizontal
Balance General 2018 Vertical 2018 2019 - 2018 2019
Vertical 2019 Horizontal 2020 Vertical 2020 Horizontal 2021 Vertical 2021 Horizontal
2020 - 2019 2021 - 2020 2022 - 2021
100% 11.74% 11,127,542 100% 14.48% 12,738,271 100% 33.75%
-56% 16.17% -6,465,128 -58% 17.72% -7,610,883 -60% 41.90%
44% 6.12% 4,662,413 42% 9.97% 5,127,387 40% 21.66%
-35% 5.64% -3,655,267 -33% 11.05% -4,059,228 -32% 18.40%
0% -52.45% 12,442 0% 198.50% 37,138 0% 100.36%
0% -52.45% 12,442 0% 198.50% 37,138 0% 100.36%
10% 6.25% 1,019,588 9% 8.41% 1,105,297 9% 36.30%
14% 7.15% 1,443,576 13% 6.15% 1,532,391 12% 28.64%
-3% -6.71% -263,328 -2% -20.77% -208,625 -2% 75.04%
0% 7.75% 24,022 0% 39.30% 33,464 0% 78.97%
-3% -6.43% -282,878 -3% -14.78% -241,076 -2% 83.85%
0% 97.15% -4,472 0% -77.36% -1,013 0% -1892.10%
1% 2.25% 59,073 1% 53.78% 90,845 1% 31.85%
7% 10.91% 815,333 7% 21.12% 987,517 8% 27.70%
-2% 12.53% -230,936 -2% 13.91% -263,056 -2% 35.83%
5% 10.29% 584,397 5% 23.97% 724,461 6% 24.75%
0% -96.64% -553.37 0% 5539.42% -31,207 0% -99.89%
5% 13.71% 583,844 5% 18.74% 693,254 5% 30.37%
5% 13.64% 575,441 5% 17.63% 676,879 5% 30.45%
0% 19.14% 8,403 0% 94.88% 16,375 0% 26.96%
2020 2021
583,844 693,254
583,844 693,254
583,844 693,254
497,947 933,564
933,564 862,706
17,037,823 100%
-10,799,595 -63% Liquidez
6,238,228 37% Razon corriente
-4,806,136 -28% Prueba acida
74,408 0% Capital de trabajo
74,408 0%
1,506,500 9%
1,971,244 12% Endeudamiento
-365,180 -2% nivel de endeudamiento
59,891 0% endeudamiento/ventas
-443,218 -3% edeudamiento finaciero
18,147 0% cobertura de intereses(veces)
119,782 1%
1,261,102 7%
-357,301 -2% Eficiencia
903,801 5% rotacion de cartera
-34.49 0% indicadores de cartera en dias
903,767 5% rotacion de inventario veces
882,976 5% rotacion de inventario dias
20,791 0% rotacion de proveedores
rotacion de proveedores en dias
rotacion de activo total
2022 Vertical 2022
2022
903,767
903,767
903,767
862,706
1,060,247
Anual, Consolid.
2022-01-01
2022-12-31
COP Miles
Auditado
Superfinanciera – NIIF
INDICADORES GRUPO NUTRESA
KD Costo financiero
Saldo pasivo con costo
KD $ 241,076.10
$ 3,341,489.44 7.21%
KD 7.21% * (1-35%)
KDT 4.69%
KD Costo financiero
Saldo pasivo con costo
KD $ 443,217.81
$ 4,371,128.88 10.14%
KD 10.14% * (1-35%)
KDT 6.59%
ESTADO D
Horizontal 2022 Vertical 2022 2023
2022 - 2021
33.75% 17,037,823 100.00% SECTOR 19,501,028
41.90% -10,799,595 -63.39% - 12,006,215
21.66% 6,238,228 36.61% UB ub 7,494,813
18.40% -4,806,136 -28.21% - 5,857,624
100.36% 74,408 0.44% 71,010
100.36% 74,408 0.44% 71,010
36.30% 1,506,500 8.84% UO. EBIT - 5,715,603
28.64% 1,971,244 11.57% RESTA 642,937
75.04% -365,180 -2.14% - 327,191
78.97% 59,891 0.35% 59,890
83.85% -443,218 -2.60% - 387,081
31.85% 119,782 0.70% IMPUESTO 138,087
27.70% 1,261,102 7.40% UN - 5,130,546
35.83% -357,301 -2.10% - 1,795,691
24.75% 903,801 5.30% - 3,334,855
-99.89% -34.49 0.00% - 3,334,855
30.37% 903,767 5.30%
30.45% 882,976 5.18%
26.96% 20,791 0.12%
-28.33% 0.00%
-10.14% 0.00% -8.60%
464,744 2.73%
BALANCE GENE
Horizontal 2022 Vertical año 2023
2022 - 2021 2022
22.42% 20,757,388 100.00%
12.91% 13,957,399 67.24%
9.79% 4,036,758 19.45%
12.02% 4,257,677 20.51%
12.20% 2,744,103 13.22%
11.69% 1,513,574 7.29%
-41.60% 11,379 0.05%
7.21% 47,527 0.23%
7.21% 47,527 0.23%
16.37% 3,787,598 18.25%
-3.61% 8,425 0.04%
16.42% 3,779,173 18.21%
13.52% 887,513 4.28%
13.52% 887,513 4.28%
18.56% 928,947 4.48%
47.99% 6,799,989 32.76%
72.40% 3,004,244 14.47%
35.16% 259,373 1.25%
34.29% 1,856,746 8.94%
34.29% 1,856,746 8.94%
22.90% 1,060,247 5.11%
49.29% 619,202 2.98%
0.00% 177.24 0.00%
22.42% 20,757,388
19.49% 10,804,696 100.00%
19.52% 10,716,380 99.18%
0.00% 2,301 0.02%
0.00% 546,832 5.06%
3.95% 4,310,253 39.89%
38.41% 4,974,019 46.04%
30.45% 882,976 8.17%
15.94% 88,316 0.82%
25.75% 9,952,691 100.00% ESTADO DE LA SITUACIÓ
16.22% 6,143,976 61.73% 2023
19.59% 3,782,499 38.00% OFLP 3,895,974
0.00 0.00%
4.63% 1,251,290 12.57%
8.68% 223,614 2.25%
22.82% 886,573 8.91%
44.93% 3,808,715 38.27%
229.47% 588,630 5.91% OFCP 606,289
27.26% 2,237,380 22.48%
27.26% 2,237,380 22.48%
23.20% 305,482 3.07%
54.21% 328,231 3.30% #REF!
51.42% 348,993 3.51% -
-10.14% -8.60%
2022
903,767
903,767
903,767
862,706
1,060,247
Anual, Consolid.
2022-01-01
2022-12-31
COP Miles
Auditado
2024 2025 2026 2027
3.40% 3.20% 3.00% 3.40%
8.9% 3.7% 3.4% 3.1%
-
- -
GRUPO NUTRESA
Periodo de cobro a deudores comerciales - Días (cxc / ventas) *360 38.55 39.08 39.23
Rotació n de inventario - Días (inventario / costo ventas) * 360 76.84 82.42 100.15
Periodo de pago a acreedores comerciales - Días (proveedores/costo ventas) *360 71.47 83.16 74.58
Ciclo Operacional - Días rot cartera + rot inventarios 115.40 121.50 139.38
Ciclo de conversió n del Efectivo - Días RC + R Invent. - R. Proveedores 43.93 38.34 64.80
1.00 0.00 0.59 0.41
DIAS DE DEUDORES COMERCIALES PROYECTADOS PROM PONDERADO 0.00 23.05 16.09
0.00 23.15
0.00
2026 2027
7,335,449 7,819,985
2,567,407 2,736,995
825,151 879,655
5,593,193 5,962,645
108,500 - 101,560
- -
5,701,692 5,861,085
2026 2027
2,724,057 2,903,193
3,359,629 3,528,801
3,312,006 3,558,755
2,771,680 2,873,240
- 108,500 101,560
2027
5,067,336
682,383
29.94%
13.47%
4.03%
4,384,953
22.81%
86.53%
19.74%
23.77%
PROMEDIO MÓVIL SIMPLE
n=
ME =
MAE =
Pronóstico Error
Periodo e(ABS)
Demanda At
Ft e t = At - Ft
2004 152,428
2005 311,858
PROMEDIO M
2006 297,927 232,143 65,784 65,784
2007 252,873 304,893 - 52,020 52,020 18,000,000
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Demanda At Pronóstico Ft
PROMEDIO MÓVIL PONDERADO
n= 3
ME = 1,252,706
MAE = 1,269,882
Pronóstico Error
Periodo e(ABS)
Demanda At
Ft e t = At - Ft
2004 152,428 t w
2005 311,858 1 0%
2006 297,927 2 59%
2007 252,873 306,143 - 53,270 53,270 3 41%
2008 300,169 279,443 20,726 20,726 Suma 1.00
2009 248,254 272,277 - 24,023 24,023
2010 289,904 278,871 11,033 11,033
2011 276,979 265,341 11,638 11,638 PROMEDIO MOVIL PONDE
2012 5,305,782 284,601 5,021,181 5,021,181 18000000
2013 5,898,466 2,340,078 3,558,388 3,558,388 16000000
2014 6,461,752 5,548,934 912,818 912,818 14000000
2015 7,945,417 6,129,558 1,815,860 1,815,860 12000000
10000000
2016 8,676,640 7,070,435 1,606,205 1,606,205
8000000
2017 8,695,604 8,245,406 450,197 450,197
6000000
2018 9,016,066 8,684,420 331,647 331,647 4000000
2019 9,958,851 8,827,076 1,131,776 1,131,776 2000000
2020 11,127,542 9,402,850 1,724,692 1,724,692 0
1 2 3 4 5 6 7 8 9 10 11 12 1
2021 12,738,271 10,438,314 2,299,957 2,299,957
2022 17,037,823 11,788,353 5,249,469 5,249,469 Demanda At Pronóstico
1,405,708 antes de solver
% ANTES DE SOLVER
10%
60%
30%
1.00
6 7 8 9 10 11 12 13 14 15 16 17 18 19
emanda At Pronóstico Ft
SUAVIZACIÓN EXPONENCIAL SIMPLE
α= 1
ME = 938,077
MAE = 951,836
Pronóstico Error
Periodo e(ABS)
Demanda At
Ft e t = At - Ft
2004 152,428 152,428
2005 311,858 152,428 159,430 159,430
SUAVIZACIÓN EXPONENCIAL SIM
2006 297,927 311,858 - 13,931 13,931
2007 252,873 297,927 - 45,054 45,054 18,000,000
8 9 0 1 2 3 4 5 6 7 8 9 0 1 2
00 200 201 201 201 201 201 201 201 201 201 201 202 202 202
Demanda At Pronóstico Ft
Grupo Nutresa S.A. (Colombia)
Fuente:
Costo de Patrimonio
Bl 1.11 1.11
Ke 15.87% 15.90%
2022 2021
Deudores Comerciales 1,856,746 1,382,671
Inventarios 3,004,244 1,742,562
Acreedores Comericales 2,237,380 1,758,083
KTNO 2,623,609 1,367,149
Variación del capital de trabajo 1,256,460 78,947
2022 2021
Propiedad Planta y equipo $ 4,036,758 $ 3,676,931
Depreciación $ 605,514 $ 551,540
Propiedad Planta y equipo Bruto $ 4,642,272 $ 4,228,471
Variación de la PPyE $ 413,801 $ 279,134
2022 2021
Utilidad Operacional 1,506,500 1,105,297
Impuesto de renta 497,145 364,748
UODI (UTILIDAD OPERACIONAL DESPUES DE IMP 1,009,355 740,549
(+)Depreciaciones 605,514 551,540
(+)Amortizaciones
Flujo Operativo 1,614,869 1,292,089
(+/-) Variación del Capital de Trabajo - 1,256,460 - 78,947
(+/-) Variación Propiedad, planta e equipo - 413,801 - 279,134
(=) Flujo de caja libre - 55,392 934,007
VP=(VF/1+i)^n
2022 2021
WACC 14.07% 13.33%
Flujo de caja libre a valor presente -$ 28,677.68 $ 566,112.20
Suma FCL a VP -$ 1,371,188
ACC
2020 2019 2018
2,303,910 2,219,325 1,799,881
8,257,142 8,684,863 8,334,730
10,561,052 10,904,189 10,134,611
21.82% 20.35% 17.76%
78.18% 79.65% 82.24%
AJA LIBRE
Tipo de Estado Financiero Anual, Consolid. Anual, Consolid. Anual, Consolid. Anual, Consolid.
Fecha inicial del periodo de reporte 2022-01-01 2021-01-01 2020-01-01 2019-01-01
Fecha final del período 2022-12-31 2021-12-31 2020-12-31 2019-12-31
Unidades originales como se reportó COP Miles COP Miles COP Miles COP Miles
Auditado Auditado Auditado Auditado Auditado
Fuente uperfinanciera – NIIF uperfinanciera – NIIF uperfinanciera – NIIF uperfinanciera – NIIF
Anual, Consolid.
2018-01-01
2018-12-31
COP Miles
Auditado
uperfinanciera – NIIF