Planilha de Gastos Pessoais O Economista (2)

Matemática Financeira

•

UNIGUAÇU

1

0

1

0

Larissa Altmann

27/07/2017

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

Sugestões
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
		INSTRUÇÕES E SUGESTÕES DE UTILIZAÇÃO
	
		01
						Modifique alguma categoria, caso não se aplique a você.
						Por exemplo, ao invés de PRESTAÇÃO de sua casa ou apartamento
						você poderá trocar por ALUGUEL.
	
	
	
		02
						Acrescente alguma categoria se tiver necessidade.
						Por exemplo, se você aluga uma linha telefônica, insira uma
						linha com o item ALUGUEL DE TELEFONE. Sempre que inserir
						linhas novas, faça-o antes da categoria Outros.
	
	
		03
						Exclua alguma categoria, caso não tenha relevância.
						Por exemplo, se você não possui TV A CABO, marque a linha
						toda na planilha e a exclua. As fórmulas serão reajustadas.
	
	
	
		04
						Use ou modifique a categoria Outros para relacionar itens
						temporários, como prestações ou financiamento de bens
						adquiridos ao longo dos meses.
Orçamento
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
		PLANILHA PARA ORÇAMENTO DOMÉSTICO													2017
	
	
			Março	Abril	Maio	Junho	Julho	Agosto	Setembro	Outubro	Novembro	Dezembro	Janeiro	Fevereiro	TOTAL
	
	
		SALÁRIO	0.0	0.0											* 11,957.80
		salario anual		0.0	* 1,246.00	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 1,190.20	* 11,957.80
				0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
				0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		FACULDADE	0.0	0.0	0.0	0.0	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 1,704.40
		Adm por amor	0.0	0.0	0.0	0.0	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 213.05	* 1,704.40
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		LOJAS	0.0	0.0	0.0	0.0	* 270.00	* 100.00	0.0	0.0	0.0	0.0	0.0	0.0	* 370.00
		Abrazzo		0.0	0.0	0.0	* 100.00	* 100.00	0.0	0.0	0.0	0.0	0.0	0.0	* 200.00
		Abrazzo (mãe)		0.0	0.0	0.0	* 100.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 100.00
		Via Brasil		0.0	0.0	0.0	* 70.00		0.0	0.0	0.0	0.0	0.0	0.0	* 70.00
		Abrazzo	0.0	0.0	0.0	0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		PGTO AUTO ESCOLA	0.0	0.0	0.0	0.0	* 358.00	* 358.00	* 358.00	* 358.00	* 358.00	0.0	0.0	0.0	* 1,790.00
		Auto escola	0.0	0.0	0.0		* 358.00	* 358.00	* 358.00	* 358.00	* 358.00	0.0	0.0	0.0	* 1,790.00
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		COMPRA DO CARRO	0.0	0.0	0.0	0.0	* 400.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 400.00
		Depósito em banco	0.0	0.0	0.0	0.0	* 400.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 400.00
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		DESPESAS PESSOAIS	0.0	0.0		0.0	* 78.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 78.00
		Comidas faculdade	0.0	0.0		0.0	* 40.85	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 40.85
		Comidas escritorio		0.0		0.0	* 14.20	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 14.20
		Açai	0.0	0.0		0.0	* 12.00	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 12.00
		Xerox	0.0	0.0		0.0	* 10.95	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 10.95
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0		0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
			0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	
		TOTAIS	Janeiro	Fevereiro	Março	Abril	Maio	Junho	Julho	Agosto	Setembro	Outubro	Novembro	Dezembro	TOTAL
		Rendimentos	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	* 11,957.80
		Gastos	0.0	0.0	0.0	0.0	* 1,319.05	* 671.05	* 571.05	* 571.05	* 571.05	* 213.05	* 213.05	* 213.05	* 4,342.40
		Saldo do Mês	0.0	0.0	0.0	0.0	* (1,319.05)	* (671.05)	* (571.05)	* (571.05)	* (571.05)	* (213.05)	* (213.05)	* (213.05)	* 7,615.40
		Saldo Acumulado	0.0	0.0	0.0	0.0	* (1,319.05)	* (1,990.10)	* (2,561.15)	* (3,132.20)	* (3,703.25)	* (3,916.30)	* (4,129.35)	* (4,342.40)	* 3,273.00
	
	
		RESUMO PARA O GRÁFICO
	
		SALÁRIO	* 11,957.80
		FACULDADE	* 1,704.40
		LOJAS	* 370.00
		PGTO AUTO ESCOLA	* 1,790.00
		COMPRA DO CARRO	* 400.00
		DESPESAS PESSOAIS	* 78.00
		0	0.0
		0	0.0
		0	0.0
	
		NÃO APAGUE ESTA ÁREA
Anual
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
		RENDIMENTOS E DESPESAS AO LONGO DO ANO																2017
Anual
	0	0	0
	0	0	0
	0	0	0
	0	0	0
	0	1319.05	-1319.05
	0	671.05	-671.05
	0	571.05	-571.05
	0	571.05	-571.05
	0	571.05	-571.05
	0	213.05	-213.05
	0	213.05	-213.05
	0	213.05	-213.05
Rendimentos
Gastos
Saldo do Mês
Para Onde
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
		PARA ONDE VAI MEU DINHEIRO?																2017
Para Onde
	1704.4
	370
	1790
	400
	78
	0
	0
	0
O gráfico mostra a porcentagem gasta com cada categoria de despesa no ano todo, baseado na última coluna de totais.
Gráficos
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
		GRÁFICOS																2017
Gráficos
	11957.8
	0
	0
	0
	0
	0
	0
	0
SALÁRIO
Calendário
	1704.4
	0
	0
	0
	0
	0
	0
	0
	0
	0
	0
FACULDADE
	200
	100
	70
	0
	0
LOJAS
	1790
	0
	0
	0
	0
Transporte
	400
	0
	0
	0
	0
	0
	0
	0
DEPOSITOS
	40.85
	14.2
	12
	10.95
	0
	0
	0
	0
	0
	0
	0
Despesas Pessoais
	0
	0
	0
	0
	0
	0
	0
	0
	0
Lazer
	0
	0
	0
Cartões de Crédito
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
	
		SUGESTÕES ORÇAMENTO ANUAL PARA ONDE GRÁFICOS DEPENDENTES CALENDÁRIO
	
	
		DIGITE AQUI O ANO DESEJADO:								2017
	
														Digite aqui o ano desejado è		2017
		2017
		JANEIRO								FEVEREIRO								MARÇO
		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S
		1	2	3	4	5	6	7		0	0	0	1	2	3	4		0	0	0	1	2	3	4
		8	9	10	11	12	13	14		5	6	7	8	9	10	11		5	6	7	8	9	10	11
		15	16	17	18	19	20	21		12	13	14	15	16	17	18		12	13	14	15	16	17	18
		22	23	24	25	26	27	28		19	20	21	22	23	24	25		19	20	21	22	23	24	25
		29	30	31	0	0	0	0		26	27	28	0	0	0	0		26	27	28	29	30	31	0
		0	0															0	0
	
		ABRIL								MAIO								JUNHO
		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S
		0	0	0	0	0	0	1		0	1	2	3	4	5	6		0	0	0	0	1	2	3
		2	3	4	5	6	7	8		7	8	9	10	11	12	13		4	5	6	7	8	9	10
		9	10	11	12	13	14	15		14	15	16	17	18	19	20		11	12	13	14	15	16	17
		16	17	18	19	20	21	22		21	22	23	24	25	26	27		18	19	20	21	22	23	24
		23	24	25	26	27	28	29		28	29	30	31	0	0	0		25	26	27	28	29	30	0
		30	0							0	0							0	0
	
		JULHO								AGOSTO								SETEMBRO
		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S
		0	0	0	0	0	0	1		0	0	1	2	3	4	5		0	0	0	0	0	1	2
		2	3	4	5	6	7	8		6	7	8	9	10	11	12		3	4	5	6	7	8	9
		9	10	11	12	13	14	15		13	14	15	16	17	18	19		10	11	12	13	14	15	16
		16	17	18	19	20	21	22		20	21	22	23	24	25	26		17	18	19	20	21	22	23
		23	24	25	26	27	28	29		27	28	29	30	31	0	0		24	25	26	27	28	29	30
		30	31							0	0							0	0
	
		OUTUBRO								NOVEMBRO								DEZEMBRO
		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S		D	S	T	Q	Q	S	S
		1	2	3	4	5	6	7		0	0	0	1	2	3	4		0	0	0	0	0	1	2
		8	9	10	11	12	13	14		5	6	7	8	9	10	11		3	4	5	6	7	8	9
		15	16	17	18	19	20	21		12	13	14	15	16	17	18		10	11	12	13	14	15	16
		22	23	24	25	26	27	28		19	20	21	22	23	24	25		17	18	19	20	21	22	23
		29	30	31	0	0	0	0		26	27	28	29	30	0	0		24	25	26	27	28	29	30
		0	0							0	0							31	0
	
	
	
	
	
																										CALENDAR TABLES AND FORMULAS
																										DO NOT ERASE OR DELETE
																										1	31	0	JANUARY			42736.0	1
																										2	28	1	FEBRUARY			42767.0	4
																										3	31	2	MARCH			42795.0	4
																										4	30	3	APRIL			42826.0	0
																										5	31	4	MAY			42856.0	2
																										6	30	5	JUNE			42887.0	5
																										7	31	6	JULY			42917.0	0
																										8	31	7	AUGUST			42948.0	3
																										9	30	8	SEPTEMBER			42979.0	6
																										10	31	9	OCTOBER			43009.0	1
																										11	30	10	NOVEMBER			43040.0	4
																										12	31	11	DECEMBER			43070.0	6
	
																										DOW TABLE	1.0	2.0	3.0	4.0	5.0	6.0	0.0
																										YEAR CALC	117.0