Calculos ADC

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

Plan1
	Índices	Liquidez corrente:
	Liquidez corrente
	2011	2011	1.48
	2012	1.48
	AT	R$ 6,772.69	R$ 1.48	2013	1.64
	PC	R$ 4,565.57	2014	1.54
	2012
	AT	R$ 7,276.99	R$ 1.48
	PC	R$ 4,905.70
	2013
	AT	R$ 8,991.57	R$ 1.64
	PC	R$ 5,480.31
	2014
	AT	R$ 10,093.03	R$ 1.54
	PC	R$ 6,547.47
	Liquidez seca:
	Liquidez seca
	2011	2011	1.1599999999999999
	2012	1.1000000000000001
	AT-EST	R$ 5,315.39	R$ 1.16	2013	1.19
	PC	R$ 4,565.56	2014	1.1000000000000001
	2012
	AT-EST	R$ 5,392.76	R$ 1.10
	PC	R$ 4,905.70
	2013
	AT - EST	R$ 6,518.30	R$ 1.19
	PC	R$ 5,480.31
	2014
	AT- EST	R$ 7,195.96	R$ 1.10
	PC	R$ 6,547.47
	Liquidez Geral:
	Liquidez Geral
	2011	2011	0.84
	2012	0.78
	AC+ARLP	R$ 6,851.23	R$ 0.84	2013	0.77
	PC+NC	R$ 8,128.81	2014	0.81
	2012
	AC+ARLP	R$ 7,681.54	R$ 0.78
	PC+NC	R$ 9,797.91
	2013
	AC+ARLP	R$ 9,586.36	R$ 0.77
	PC+NC	R$ 12,426.00
	2014
	AC+ARLP	R$ 10,997.01	R$ 0.81
	PC+NC	R$ 13,596.50
	Liquidez Imediata:
	Liquidez Imediata
	2011	0.52
	2011	2012	0.63
	2013	0.75
	DISP	R$ 2,385.26	R$ 0.52	2014	0.7
	PC	R$ 4,565.57
	2012
	DISP	R$ 3,108.31	R$ 0.63
	PC	R$ 4,905.70
	2013
	DISP	R$ 4,088.44	R$ 0.75
	PC	R$ 5,480.31
	2014
	DISP	R$ 4,570.21	R$ 0.70
	PC	R$ 6,547.47
	Endividamento	Endividamento quantidade
	Quantidade	2011	0.86
	2012	0.88
	2011	2013	0.88
	2014	0.81
	PC+ELP	R$ 8,128.82	R$ 0.86
	PC+NC+PL	R$ 9,458.03
	2012
	PC+ELP	R$ 9,797.91	R$ 0.88
	PC+NC+PL	R$ 11,080.29
	2013
	PC+ELP	R$ 12,426.00	R$ 0.88
	PC+NC+PL	R$ 14,138.35
	2014
	PC+ELP	R$ 13,596.50	R$ 0.81
	PC+NC+PL	R$ 16,858.03
	Qualidade
	2011	Endividamento qualidade
	2011	0.52
	PC	R$ 4,565.57	R$ 0.52	2012	0.48
	PC+PELP	R$ 8,767.54	2013	0.42
	2014	0.43
	2012
	PC	R$ 4,905.70	R$ 0.48
	PC+PELP	R$ 10,272.13
	2013
	PC	R$ 5,480.31	R$ 0.42
	PC+PELP	R$ 12,963.24
	2014
	PC	R$ 6,547.47	R$ 0.43
	PC+PELP	R$ 15,179.12
	Grau de Endividamento
	2011
	PC+PELP	R$ 8,767.54	R$ 12.70	Grau de Endividamento
	PL	R$ 690.49	2011	12.7
	2012	12.71
	2013	11.03
	2014	9.04
	2012
	PC+PELP	R$ 10,272.13	R$ 12.71
	PL	R$ 808.16
	2013
	PC+PELP	R$ 12,963.24	R$ 11.03
	PL	R$ 1,175.11
	2014
	PC+PELP	R$ 15,179.12	R$ 9.04
	PL	R$ 1,678.91
	TRI	Rentabilidade
	Payback do investimento
	2011
	100%
	LL	R$ 340.44	4%	TRI
	AT	R$ 9,458.03
	payback 25	Rentabilidade TRI
	2011	0.04
	2012	2012	0.04
	2013	0.03
	LL	R$ 410.19	4%	2014	0.03
	AT	R$ 11,080.29
	payback 25
	2013
	LL	R$ 462.89	3%
	AT	R$ 14,138.35
	payback 33
	2014
	LL	R$ 427.83	3%
	AT	R$ 16,858.03
	payback 33
	TRPL
	Payback dos Proprietários 
	2011
	100%
	LL	R$ 340.44	49%	TRPL
	PL	R$ 690.49
	Rentabilidade TRPL
	payback 2	2011	0.49
	2012	0.51
	2012	2013	0.39
	2014	0.25
	LL	R$ 410.19	51%
	PL	R$ 808.16
	payback 2
	2013
	LL	R$ 462.89	39%
	PL	R$ 1,175.11
	payback 3
	2014
	LL	R$ 427.83	25%
	PL	R$ 1,678.91
	payback 4
	Margem líquida
	2011	Rentabilidade Margem líquida
	2011	0.03
	LL	R$ 340.44	3.41%	2012	0.03
	VL	R$ 9,978.41	2013	0.03
	2014	0.02
	2012
	LL	R$ 410.19	3.62%
	VL	R$ 11,334.06
	2013
	LL	R$ 462.89	3.45%
	VL	R$ 13,401.17
	2014
	LL	R$ 427.83	2.65%
	VL	R$ 16,145.67
	Giro do ativo
	2011
	Giro do ativo
	VL	R$ 9,978.41	R$ 1.06	2011	1.06
	AT	R$ 9,458.03	2012	1.02
	2013	0.95
	2014	0.96
	2012
	VL	R$ 11,334.06	R$ 1.02
	AT	R$ 11,080.29
	2013
	R$ 0.95
	VL	R$ 13,401.17
	AT	R$ 14,138.35
	2014
	VL	R$ 16,145.67	R$ 0.96
	AT	R$ 16,858.03
	Rotação
	Giro dos estoques (GE)	Giro dos estoques 
	2011	4.81
	2011	2012	4.21
	2013	3.77
	CMV	R$ 7,000.75	R$ 4.81	2014	3.9
	SD MÉ EST	R$ 1,456.90
	2012
	CMV	R$ 7,939.68	R$ 4.21
	SD MÉ EST	R$ 1,884.23
	2013
	CMV	R$ 9,326.42	R$ 3.77
	SD MÉ EST	R$ 2,473.27
	2014
	CMV	R$ 11,308.81	R$ 3.90
	SD MÉ EST	R$ 2,897.07
	Giro das contas a receber
	2011	Giro das contas a receber
	2011	0.39
	RB	R$ 1,128.87	R$ 0.39	2012	0.55
	CR	R$ 2,905.51	2013	0.61
	2014	0.65
	2012
	RB	R$ 1,243.79	R$ 0.55
	CR	R$ 2,264.45
	2013
	RB	R$ 1,450.91	R$ 0.61
	CR	R$ 2,394.58
	2014
	RB	R$ 1,681.18	R$ 0.65
	CR	R$ 2,585.72
	PMRE
	2011	PMRE
	2011	37.46
	EST/2*360	R$ 2,622.42	R$ 37.46	2012	42.72
	CMV	R$ 7,000.75	2013	46.22
	2014	46.11
	Giro = 9,61
	2012
	EST/2*360	R$ 3,391.61	R$ 42.72
	CMV	R$ 7,939.38
	Giro = 8,43
	2013
	EST/2*360	R$ 4,310.24	R$ 46.22
	CMV	R$ 9,326.42
	2014
	EST/2*360	R$ 5,214.73	R$ 46.11
	CMV	R$ 11,308.81
	PMRV
	2011
	DR/2*360	R$ 5,229.92	R$ 46.33
	vendas lq	R$ 1,128.87
	2012
	DR/2*360	R$ 4,076.01	R$ 32.77
	vendas lq	R$ 1,243.79
	2013
	DR/2*360	R$ 4,310.24	R$ 29.71
	vendas lq	R$ 1,450.91
	2014
	DR/2*360	R$ 4,654.30	R$ 27.68
	vendas lq	R$ 1,681.18
	2011
	AT	R$ 9,458.03	R$ 3.18
	RB	R$ 2,977.66
	2012
	AT	R$ 11,080.29	R$ 3.26
	RB	R$ 3,394.38
	2013
	AT	R$ 14,138.35	R$ 3.47
	RB	R$ 4,074.75
	2014
	AT	R$ 16,858.03	R$ 3.49
	BR	R$ 4,836.86
	imobilização do pl 
	2011
	IMOB	R$ 934.34	R$ 1.35	Imobilização do PL
	PL	R$ 690.49	2011	1.35
	2012	1.65
	2013	1.52
	2012	2014	1.38
	IMOB	R$ 1,334.44	R$ 1.65
	PL	R$ 808.16
	2013
	IMOB	R$ 1,785.35	R$ 1.52
	PL	R$ 1,175.11
	2014
	IMOB	R$ 2,317.67	R$ 1.38
	PL	R$ 1,678.91
	IMOB DOS RECURSOS A LP E DO PL
	2011
	Imobilização dos recursos A LP E do PL
	IMOB	R$ 934.59	R$ 0.22	2011	0.22
	ELP+PL	R$ 4,253.74	2012	0.23
	2013	0.22
	2014	0.27
	2012
	IMOB	R$ 1,334.44	R$ 0.23
	ELP+PL	R$ 5,700.37
	2013
	IMOB	R$ 1,785.35	R$ 0.22
	ELP+PL	R$ 8,120.80
	2014
	IMOB	R$ 2,317.67	R$ 0.27
	ELP+PL	R$ 8,727.94
Plan2
Plan3