INDICADORES FINANCEIROS

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

Planilha1
	LPA	L.L/Nº AÇÕES	192.211125
	PAYOUT	DIVID./LPA	0.0633678202	6.3367820151
	DIVIDEND YIELD	DIVID./PREÇ.AÇÃO	0.5985257985	59.8525798526
	ÍNDICE P/L	PREÇO DE AÇÃO/LPA	0.1058731642
	Orçamento de Produção 
	 	Dias	1° TRIMESTRE	2° TRIMESTRE 	3°TRIMESTRE
	Previsão de Vendas (Und)	4500	5250	5700
	(+) Estoque Inicial 	2250	2625	2850
	(-) Estoque Final	45	6750	7875	8550
	Total Prev. Necessária	0	2250	2625
	Previsão de Produção 	6750	10125	11175
	FLUXO DE CAIXA
	ITENS	JAN	FEV	MAR	ABR	MAI	JUN	JUL	AGO	SET	OUT	NOV	DEZ	TOTAL
	SALDO INICIAL 	0.0	* 44,978.49	-300,621.51	-25,621.51	-641,329.42	-320,496.09	* 337.24	-680,754.18	-332,420.85	* 15,912.48	-680,754.18	-332,420.85	-3,253,190.38
	Recebimento de vendas	* 275,000.00	* 550,000.00	* 825,000.00	* 320,833.33	* 641,666.66	* 962,499.99	* 348,333.33	* 696,666.66	* 1,044,999.99	* 348,333.33	* 696,666.66	* 1,044,999.99	* 7,754,999.94
	Integralização de Capital	* 480,000.00
	TOTAL ENTRADAS	* 755,000.00	* 550,000.00	* 825,000.00	* 320,833.33	* 641,666.66	* 962,499.99	* 348,333.33	* 696,666.66	* 1,044,999.99	* 348,333.33	* 696,666.66	* 1,044,999.99	* 8,234,999.94
	Fornecedores = CPV	* 420,000.00	* 420,000.00	* 420,000.00	* 490,000.00	* 490,000.00	* 490,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 5,922,000.00
	Água/luz/telefone	0.0	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 141,900.00
	Pro-labore	0.0	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 176,000.00
	Salários + encargos	0.0	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 1,444,850.00
	Gastos com transporte	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 261,600.00
	Despesas com marketing	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 108,000.00
	IRPJ	* 28,693.13	* 943.13	* 943.13	* 6,066.56	* 6,066.56	* 6,066.56	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 103,622.85
	CSLL	* 17,215.88	* 565.88	* 565.88	* 3,639.94	* 3,639.94	* 3,639.94	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 62,173.74
	Comissão de Vendas	0.0	* 24,750.00	* 24,750.00	* 28,875.00	* 28,875.00	* 28,875.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 324,225.00
	ICMS	* 99,000.00	* 99,000.00	* 99,000.00	* 115,500.00	* 115,500.00	* 115,500.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 1,395,900.00
	PIS	* 13,612.50	* 13,612.50	* 13,612.50	* 15,881.25	* 15,881.25	* 15,881.25	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 191,936.25
	CONFINS	* 62,700.00	* 62,700.00	* 62,700.00	* 73,150.00	* 73,150.00	* 73,150.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 884,070.00
	Aquisição de Maquinas e Equip.	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 38,000.00	* 456,000.00
	TOTAL SAÍDAS	* 710,021.51	* 850,621.51	* 850,621.51	* 962,162.75	* 962,162.75	* 962,162.75	* 1,029,087.51	* 1,029,087.51	* 1,029,087.51	* 1,029,087.51	* 1,029,087.51	* 1,029,087.51	* 11,472,277.84
	FLUXO DE CAIXA LIVRE	-435,021.51	-300,621.51	-25,621.51	-641,329.42	-320,496.09	* 337.24	-680,754.18	-332,420.85	* 15,912.48	-680,754.18	-332,420.85	* 15,912.48	-3,717,277.90
	SALDO FINAL	* 44,978.49	-300,621.51	-25,621.51	-641,329.42	-320,496.09	* 337.24	-680,754.18	-332,420.85	* 15,912.48	-680,754.18	-332,420.85	* 15,912.48	-3,237,277.90
	FORNECEDORES	Valor	1.00	2.00	3.00	4.00	5.00	6.00	7.00	8.00	9.00	10.00	11.00	12.00
	1	* 420,000.00	* 210,000.00	* 210,000.00
	2	* 420,000.00	* 210,000.00	* 210,000.00
	3	* 420,000.00	* 210,000.00	* 210,000.00
	4	* 490,000.00	* 245,000.00	* 245,000.00
	5	* 490,000.00	* 245,000.00	* 245,000.00
	6	* 490,000.00	* 245,000.00	* 245,000.00
	7	* 532,000.00	* 266,000.00	* 266,000.00
	8	* 532,000.00	* 266,000.00	* 266,000.00
	9	* 532,000.00	* 266,000.00	* 266,000.00
	10	* 532,000.00	* 266,000.00	* 266,000.00
	11	* 532,000.00	* 266,000.00	* 266,000.00
	12	* 532,000.00	* 266,000.00
	total	* 5,922,000.00	* 210,000.00	* 420,000.00	* 420,000.00	* 455,000.00	* 490,000.00	* 490,000.00	* 511,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00
	Orçamento de Vendas
	1° TRIMESTRE	2° TRIMESTRE	3° TRIMESTRE
	Previsão de Vendas (Und)	4500	5250	5700
	Preço Unitário - R$	* 550.00	* 550.00	* 550.00
	Total de Vendas- R$ (Receita Bruta)	* 2,475,000.00	* 2,887,500.00	* 3,135,000.00
	ICMS 12%	* 297,000.00	* 346,500.00	* 376,200.00
	PIS 1,65%	* 40,837.50	* 47,643.75	* 51,727.50
	COFINS 7,6%	* 188,100.00	* 219,450.00	* 238,260.00
	Total de Impostos 21,25%	* 525,937.50	* 613,593.75	* 666,187.50
	Receita Líquida	* 1,949,062.50	* 2,273,906.25	* 2,468,812.50
	Contas a receber	Valor	1.00	2.00	3.00	4.00	5.00	6.00	7.00	8.00	9.00	10.00	11.00	12.00
	1	825,000.00	275,000.00	275,000.00	275,000.00
	2	825,000.00	275,000.00	275,000.00	320,833.33
	3	825,000.00	275,000.00	320,833.33	320,833.33
	4	962,500.00	320,833.33	320,833.33	320,833.33
	5	962,500.00	320,833.33	320,833.33	348,333.33
	6	962,500.00	320,833.33	348,333.33	348,333.33
	7	1,045,000.00	348,333.33	348,333.33	348,333.33
	8	1,045,000.00	348,333.33	348,333.33	348,333.33
	9	1,045,000.00	348,333.33	348,333.33	348,333.33
	10	1,045,000.00	348,333.33	348,333.33	348,333.33
	11	1,045,000.00	348,333.33	348,333.33
	12	1,045,000.00	348,333.33
	Total	11,632,500.00	275,000.00	550,000.00	825,000.00	962,500	962,500	962,500	1,045,000	1,045,000	1,044,999.99	1,044,999.99	1,044,999.99	1,044,999.99
	DRE
	JAN	FEV	MAR	ABR	MAI	JUN	JUL	AGO	SET	OUT	NOV	DEZ	TOTAL
	Quantidade de venda	* 1,500.00	* 1,500.00	* 1,500.00	* 1,750.00	* 1,750.00	* 1,750.00	* 1,900.00	* 1,900.00	* 1,900.00	* 1,900.00	* 1,900.00	* 1,900.00	* 21,150.00
	Preço de venda	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 550.00	* 6,600.00
	RECEITA BRUTA DE VENDAS	* 825,000.00	* 825,000.00	* 825,000.00	* 962,500.00	* 962,500.00	* 962,500.00	* 1,045,000.00	* 1,045,000.00	* 1,045,000.00	* 1,045,000.00	* 1,045,000.00	* 1,045,000.00	* 11,632,500.00
	(-) ICMS	* 99,000.00	* 99,000.00	* 99,000.00	* 115,500.00	* 115,500.00	* 115,500.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 125,400.00	* 1,395,900.00
	(-) PIS	* 13,612.50	* 13,612.50	* 13,612.50	* 15,881.25	* 15,881.25	* 15,881.25	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 17,242.50	* 191,936.25
	(-) CONFINS	* 62,700.00	* 62,700.00	* 62,700.00	* 73,150.00	* 73,150.00	* 73,150.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 79,420.00	* 884,070.00
	Soma dos Impostos	* 175,312.50	* 175,312.50	* 175,312.50	* 204,531.25	* 204,531.25	* 204,531.25	* 222,062.50	* 222,062.50	* 222,062.50	* 222,062.50	* 222,062.50	* 222,062.50	* 2,471,906.25
	RECEITA LÍQUIDA	* 649,687.50	* 649,687.50	* 649,687.50	* 757,968.75	* 757,968.75	* 757,968.75	* 822,937.50	* 822,937.50	* 822,937.50	* 822,937.50	* 822,937.50	* 822,937.50	* 9,160,593.75
	(-) CPV	* 420,000.00	* 420,000.00	* 420,000.00	* 490,000.00	* 490,000.00	* 490,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 532,000.00	* 5,922,000.00
	(=) LUCRO BRUTO	* 229,687.50	* 229,687.50	* 229,687.50	* 267,968.75	* 267,968.75	* 267,968.75	* 290,937.50	* 290,937.50	* 290,937.50	* 290,937.50	* 290,937.50	* 290,937.50	* 3,238,593.75
	CUSTOS FIXOS	* 223,400.00	* 223,400.00	* 223,400.00	* 227,525.00	* 227,525.00	* 227,525.00	* 230,000.00	* 230,000.00	* 230,000.00	* 230,000.00	* 230,000.00	* 230,000.00
* 2,732,775.00
	Água/luz/telefone	* 12,900.000	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 12,900.00	* 154,800.000
	Pro-labore	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 16,000.00	* 192,000.00
	Salários + encargos	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 131,350.00	* 1,576,200.00
	Gastos com transporte	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 21,800.00	* 261,600.00
	Despesas com marketing	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 9,000.00	* 108,000.00
	Depreciação	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 7,600.00	* 91,200.00
	Comissão	* 24,750.00	* 24,750.00	* 24,750.00	* 28,875.00	* 28,875.00	* 28,875.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 31,350.00	* 348,975.00
	LAIR	* 6,287.50	* 6,287.50	* 6,287.50	* 40,443.75	* 40,443.75	* 40,443.75	* 60,937.50	* 60,937.50	* 60,937.50	* 60,937.50	* 60,937.50	* 60,937.50	* 505,818.75
	IR	* 943.13	* 943.13	* 943.13	* 6,066.56	* 6,066.56	* 6,066.56	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 9,140.63	* 75,872.82
	CSLL	* 565.88	* 565.88	* 565.88	* 3,639.94	* 3,639.94	* 3,639.94	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 5,484.38	* 45,523.69
	RESULTADO LÍQUIDO DO EXERCÍCIO	* 4,778.50	* 4,778.50	* 4,778.50	* 30,737.25	* 30,737.25	* 30,737.25	* 46,312.50	* 46,312.50	* 46,312.50	* 46,312.50	* 46,312.50	* 46,312.49	* 384,422.24