Analisis_Vertical_Horizontal

Download Report

Transcript Analisis_Vertical_Horizontal

Análisis de los Estados
Financieros
Análisis vertical
Balance
Análisis vertical
Activos
2003
2004
2005
2003
2004
2005
0.6%
0.3%
0.4%
3.3%
0.7%
2.0%
23.9%
21.9%
25.0%
48.7%
44.6%
48.8%
76.5%
67.4%
76.2%
Efectivo
Títulos
CxC
Inventarios
Activo Cte
9,000
48,600
351,200
715,200
1,124,000
7,282
20,000
632,160
1,287,360
1,946,802
14,000
71,632
878,000
1,716,480
2,680,112
AFB
-Dep. Acum.
AFN
491,000
146,200
344,800
1,202,950
263,160
939,790
1,220,000
383,160
836,840
33.4%
41.7%
34.7%
10.0%
9.1%
10.9%
23.5%
32.6%
23.8%
Activo Total
1,468,800
2,886,592
3,516,952
100.0%
100.0%
100.0%
CxP
NxP
OxP
Pasivo Cte
DLP
Pasivo Total
145,600
200,000
136,000
481,600
323,432
805,032
324,000
720,000
284,960
1,328,960
1,000,000
2,328,960
359,800
300,000
380,000
1,039,800
500,000
1,539,800
10.2%
Acc. Pref.
Acc. Com.
Util. Ret.
Patrimonio
460,000
203,768
663,768
460,000
97,632
557,632
1,680,936
296,216
1,977,152
1,468,800
2,886,592
3,516,952
Pasivos
P&P
9.9%
11.2%
13.6%
24.9%
8.5%
9.3%
9.9%
10.8%
32.8%
46.0%
29.6%
22.0%
34.6%
14.2%
54.8%
80.7%
43.8%
0.0%
0.0%
0.0%
31.3%
15.9%
47.8%
13.9%
3.4%
8.4%
45.2%
19.3%
56.2%
100.0%
100.0%
100.0%
Análisis vertical
Estado de Resultados
Análisis vertical
2003
2004
2005
2003
2004
2005
Ventas netas
3,432,000
5,834,400
7,035,600
100.0%
100.0%
100.0%
Costos
2,864,000
4,980,000
5,800,000
83.4%
85.4%
82.4%
Gastos
340,000
720,000
612,960
9.9%
12.3%
8.7%
UAIIDA
228,000
134,400
622,640
6.6%
2.3%
8.8%
18,900
116,960
120,000
0.6%
2.0%
1.7%
-
-
-
0.0%
0.0%
0.0%
D&A
18,900
116,960
120,000
0.6%
2.0%
1.7%
UAII
209,100
17,440
502,640
6.1%
0.3%
7.1%
62,500
176,000
80,000
1.8%
3.0%
1.1%
Depr.
Amort.
Intereses
UAI
146,600
-
158,560
422,640
4.3%
-2.7%
6.0%
Impuestos
58,640
-
63,424
169,056
1.7%
-1.1%
2.4%
UDI ant DP
87,960
-
95,136
253,584
2.6%
-1.6%
3.6%
0.0%
0.0%
0.0%
Div. Pref.
-
UDI
87,960
Dividendos
22,000
Ad. U.R.
65,960
-
-
95,136
253,584
2.6%
-1.6%
3.6%
11,000
55,000
0.6%
0.2%
0.8%
106,136
198,584
1.9%
-1.8%
2.8%
Análisis horizontal
Balance
Análisis horizontal
Activos
2003
2004
2005 2003-2004
2004-2005
Efectivo
Títulos
CxC
Inventarios
Activo Cte
9,000
48,600
351,200
715,200
1,124,000
7,282
20,000
632,160
1,287,360
1,946,802
14,000
71,632
878,000
1,716,480
2,680,112
-19.1%
92.3%
-58.8%
258.2%
80.0%
38.9%
80.0%
33.3%
73.2%
37.7%
AFB
-Dep. Acum.
AFN
491,000
146,200
344,800
1,202,950
263,160
939,790
1,220,000
383,160
836,840
145.0%
1.4%
80.0%
45.6%
172.6%
-11.0%
Activo Total
1,468,800
2,886,592
3,516,952
96.5%
21.8%
CxP
NxP
OxP
Pasivo Cte
DLP
Pasivo Total
145,600
200,000
136,000
481,600
323,432
805,032
324,000
720,000
284,960
1,328,960
1,000,000
2,328,960
359,800
300,000
380,000
1,039,800
500,000
1,539,800
122.5%
11.0%
260.0%
-58.3%
Acc. Pref.
Acc. Com.
Util. Ret.
Patrimonio
460,000
203,768
663,768
460,000
97,632
557,632
1,680,936
296,216
1,977,152
1,468,800
2,886,592
3,516,952
Pasivos
P&P
109.5%
33.4%
175.9%
-21.8%
209.2%
-50.0%
189.3%
-33.9%
0.0%
265.4%
-52.1%
203.4%
-16.0%
254.6%
96.5%
21.8%
Análisis horizontal
Análisis vertical
Estado de Resultados
2003
Ventas netas
Costos
Gastos
UAIIDA
Depr.
Amort.
D&A
UAII
Intereses
UAI
Impuestos
UDI ant DP
Div. Pref.
UDI
Dividendos
Ad. U.R.
2004
2005 2003-2004
3,432,000
2,864,000
340,000
5,834,400
4,980,000
720,000
7,035,600
5,800,000
612,960
228,000
18,900
18,900
209,100
62,500
146,600
58,640
87,960
87,960
22,000
65,960
134,400
116,960
116,960
17,440
176,000
158,560
63,424
95,136
95,136
11,000
106,136
622,640
120,000
120,000
502,640
80,000
422,640
169,056
253,584
253,584
55,000
198,584
-
2004-2005
70.0%
20.6%
73.9%
16.5%
111.8%
-14.9%
-41.1%
363.3%
518.8%
2.6%
518.8%
2.6%
-91.7%
2782.1%
181.6%
-54.5%
-208.2%
-366.5%
-208.2%
-366.5%
-208.2%
-366.5%
-208.2%
-366.5%
-50.0%
400.0%
-260.9%
-287.1%