financeira - analise financeira emp simples

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

JAN
	ANÁLISE FINANCEIRA
	RECEITAS	%INF	Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	TOTAL	% S/REC
	VENDAS		$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$5,000.00	$60,000.00	83.33%
	SERVIÇOS		$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$1,000.00	$12,000.00	16.67%
	TOTAL RECEITAS BRUTAS		$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$6,000.00	$72,000.00	100.00%
	( - ) IMPOSTOS FEDERAIS	3%	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$180.00	$2,160.00	3.00%
	(-) - ISS	5%	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$50.00	$600.00	0.83%
	(-) - ICMS	17%	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$850.00	$10,200.00	14.17%
	CMV (DIGITE PERC. CUSTO MERC.	70.00%	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$3,500.00	$42,000.00	58.33%
	DEPRECIAÇÃO MAQUINAS	1%	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$60.00	$720.00	1.00%
	CUSTO SERVIÇOS (PEÇAS, MATERIAIS)	5%	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$3,600.00	5.00%
	TOTAL RECEITAS LÍQUIDAS		$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$12,720.00	17.67%
	
	DESPESA PESSOAL		Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	TOTAL	% S/REC
	SALÁRIOS		$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$100.00	$1,200.00	1.67%				3234-3444
	VALE TRANSPORTES		$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$120.00	0.17%
	PLANO SAUDE		$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$120.00	0.17%
	INDENIZAÇÕES TRABALHISTAS		$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$120.00	0.17%
	PREVISÕES.13o/FÉRIAS		$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$19.44	$233.33	0.32%
	FGTS		$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$10.15	$121.83	0.17%
	GRATIFICAÇÕES		$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$300.00	$3,600.00	5.00%
	TOTAL DESPESA PESSOAL OPERACIONAL		$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$5,515.17	8%
	
	DESPESA ADMINISTRATIVAS		Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	TOTAL	% S/REC
	121 - AGUA		$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$1.00	$12.00	0.02%
	122 - ENERGIA		$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$2.00	$24.00	0.03%
	123 - ALUGUEL		$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$3.00	$36.00	0.05%
	124 - COMBUSTIVEIS (80%) 20/80		$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$4.00	$48.00
	125 - CORREIOS E FRETES AVULSOS		$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$5.00	$60.00	0.08%
	126 - CURSOS E TREINAMENTOS		$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$6.00	$72.00	0.10%
	127 - DESP. CARTORIO E JUDICIAIS		$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$7.00	$84.00	0.12%
	128 - FARDAMENTOS E EQUIP.PROT		$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$8.00	$96.00	0.13%
	129 - JORNAIS E REVISTAS		$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$9.00	$108.00	0.15%
	130 - MANUTENÇÃO VEÍCULOS		$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$120.00	0.17%
	132 - MAT. CONSUMO E ESCRITORIO		$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$132.00	0.18%
	134 - PROPAGANDA E PUBLICIDADE		$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$12.00	$144.00	0.20%
	135 - SEGUROS		$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$13.00	$156.00	0.22%
	137 - TELEFONE FIXO E COMUNICAÇÃO		$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$14.00	$168.00	0.23%
	137- TELEFONE CELULAR		$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$15.00	$180.00	0.25%
	139 - VIAGENS E EST. ADMINIST.		$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$16.00	$192.00	0.27%
	140 - SERVIÇOS TERC. - PES. FISICA		$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$17.00	$204.00	0.28%
	141 - SERVIÇOS TERC. - PES. JURIDICA		$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$18.00	$216.00	0.30%
	143 - OBRA E REFORMAS		$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$19.00	$228.00	0.32%
	146-DESP. CONFRATERNIZ. E EVENTOS		$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$20.00	$240.00	0.33%
	147-COPA E MATERIAL DE LIMPEZA		$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$252.00	0.35%
	999-OUTRAS DESP. ADMINISTRAT.		$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$22.00	$264.00	0.37%
	TOTAL DESPESA ADMISTRATIVA		$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$3,036.00	4.22%
	
	DESPESA FINANCEIRA		Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	TOTAL	%
	150-DESP.BANCÁRIA		$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$10.00	$120.00	0.17%
	151-CPMF		$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$11.00	$132.00	0.18%
	TOTAL DA DESPESA FINANCEIRA		$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$252.00	0.35%
	
	
	RESUMO GERAL DESPESAS	RATEIO	Jan-05	Feb-05	Mar-05	Apr-05	May-05	Jun-05	Jul-05	Aug-05	Sep-05	Oct-05	Nov-05	Dec-05	TOTAL	%
	RECEITA LÍQUIDA		$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$1,060.00	$12,720.00	17.67%
	DESPESA PESSOAL		$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$459.60	$5,515.17	7.66%
	DESPESAS ADMINISTRATIVAS		$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$253.00	$3,036.00	4.22%
	DESPESAS FINANCEIRAS		$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$21.00	$252.00	0.35%
	LUCRO LÍQUIDO		$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$326.40	$3,916.83	5.44%
	LUCRO LÍQUIDO ACUMULADO		$326.40	$652.81	$979.21	$1,305.61	$1,632.01	$1,958.42	$2,284.82	$2,611.22	$2,937.63	$3,264.03	$3,590.43	$3,916.83		0.00%
	INVESTIMENTOS