Buscar

10 Fluxo de Caixa

Excel

•

FAFIRE

0
Dislike0
0
Dislike0
Comment0
User badge image

Solange Alves

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

EXERCÍCIO
	EXERCÍCIO
	8	OS PAGAMENTOS E RECEBIMENTOS SÃO ALIMENTADOS NO EXTRATO GERENCIAL
	8	MONTAR FLUXO DE CAIXA DIÁRIO / MENSAL
	8	CÉLULA "D2" - DIÁRIO => ESCOLHA O MÊS => ALIMENTAR OS DEMAIS DIAS AUTOMATICAMENTE + DIA DA SEMANA
	8	AS INFORMAÇÕES SERÃO ALIMENTADAS DE ACORDO COM A "CONTA" E "DIA"
	8	AGRUPAR POR ENTRADA / SAÍDA
DIÁRIO
	FLUXO DE CAIXA
	SALDO INICIAL
	SALÁRIO	0.0
	13 SAL / FÉRIAS	0.0
	JUROS	0.0
	OUTROS	0.0
	ENTRADAS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	VISA	0.0
	ALUGUEL APTO	0.0
	CONDOMÍNIO APTO	0.0
	DIARISTA	0.0
	SKY	0.0
	GVT - INTERNET	0.0
	TIM	0.0
	CELPE	0.0
	ABA	0.0
	GINÁSTICA	0.0
	BALLET	0.0
	ESCOLA	0.0
	MATERIAL ESCOLAR	0.0
	TRANSPORTE	0.0
	TARIFA	0.0
	IPTU	0.0
	IPVA	0.0
	SEGURO	0.0
	IMOBILIZADO	0.0
	SAÍDAS	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	MOVIMENTO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	APLICAÇÃO	0.0
	RETIRADA	0.0
	MOV INVESTIMENTO	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	SALDO FINAL	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0
	1-Dec-12
	1-Jan-13
	1-Feb-13
	1-Mar-13
	1-Apr-13
	1-May-13
	1-Jun-13
	1-Jul-13
	1-Aug-13
	1-Sep-13
	1-Oct-13
	1-Nov-13
	1-Dec-13
	1-Jan-14
	1-Feb-14
	1-Mar-14
	1-Apr-14
	1-May-14
	1-Jun-14
	1-Jul-14
	1-Aug-14
	1-Sep-14
	1-Oct-14
	1-Nov-14
	1-Dec-14
	1-Jan-15
	1-Feb-15
	1-Mar-15
	1-Apr-15
	1-May-15
	1-Jun-15
	1-Jul-15
	1-Aug-15
	1-Sep-15
	1-Oct-15
	1-Nov-15
	1-Dec-15
	1-Jan-16
	1-Feb-16
	1-Mar-16
	1-Apr-16
	1-May-16
	1-Jun-16
	1-Jul-16
	1-Aug-16
	1-Sep-16
	1-Oct-16
	1-Nov-16
	1-Dec-16
	1-Jan-17
	1-Feb-17
	1-Mar-17
	1-Apr-17
	1-May-17
	1-Jun-17
	1-Jul-17
	1-Aug-17
	1-Sep-17
	1-Oct-17
	1-Nov-17
	1-Dec-17
	1-Jan-18
	1-Feb-18
	1-Mar-18
	1-Apr-18
	1-May-18
	1-Jun-18
	1-Jul-18
	1-Aug-18
	1-Sep-18
	1-Oct-18
	1-Nov-18
	1-Dec-18
	1-Jan-19
	1-Feb-19
	1-Mar-19
	1-Apr-19
	1-May-19
	1-Jun-19
	1-Jul-19
	1-Aug-19
	1-Sep-19
	1-Oct-19
	1-Nov-19
	1-Dec-19
	1-Jan-20
	1-Feb-20
	1-Mar-20
	1-Apr-20
	1-May-20
	1-Jun-20
	1-Jul-20
	1-Aug-20
	1-Sep-20
	1-Oct-20
	1-Nov-20
	1-Dec-20
	1-Jan-21
	1-Feb-21
	1-Mar-21
	1-Apr-21
	1-May-21
	1-Jun-21
	1-Jul-21
	1-Aug-21
	1-Sep-21
	1-Oct-21
	1-Nov-21
	1-Dec-21
	1-Jan-22
	1-Feb-22
	1-Mar-22
	1-Apr-22
	1-May-22
	1-Jun-22
	1-Jul-22
	1-Aug-22
	1-Sep-22
	1-Oct-22
	1-Nov-22
	1-Dec-22
	1-Jan-23
	1-Feb-23
	1-Mar-23
	1-Apr-23
MENSAL
	FLUXO DE CAIXA	December-13
	SALDO INICIAL
	SALÁRIO
	13 SAL / FÉRIAS
	JUROS
	OUTROS
	ENTRADAS	0.0	0.0	0.0	0.0
	VISA
	ALUGUEL APTO
	CONDOMÍNIO APTO
	DIARISTA
	SKY
	GVT - INTERNET
	TIM
	CELPE
	ABA
	GINÁSTICA
	BALLET
	ESCOLA
	MATERIAL ESCOLAR
	TRANSPORTE
	TARIFA
	IPTU
	IPVA
	SEGURO
	IMOBILIZADO
	SAÍDAS	0.0	0.0	0.0	0.0
	MOVIMENTO	0.0	0.0	0.0	0.0
	APLICAÇÃO
	RETIRADA
	MOV INVESTIMENTO	0.0	0.0	0.0	0.0
	SALDO FINAL	0.0	0.0	0.0	0.0
	1-Dec-12
	1-Jan-13
	1-Feb-13
	1-Mar-13
	1-Apr-13
	1-May-13
	1-Jun-13
	1-Jul-13
	1-Aug-13
	1-Sep-13
	1-Oct-13
	1-Nov-13
	1-Dec-13
	1-Jan-14
	1-Feb-14
	1-Mar-14
	1-Apr-14
	1-May-14
	1-Jun-14
	1-Jul-14
	1-Aug-14
	1-Sep-14
	1-Oct-14
	1-Nov-14
	1-Dec-14
	1-Jan-15
	1-Feb-15
	1-Mar-15
	1-Apr-15
	1-May-15
	1-Jun-15
	1-Jul-15
	1-Aug-15
	1-Sep-15
	1-Oct-15
	1-Nov-15
	1-Dec-15
	1-Jan-16
	1-Feb-16
	1-Mar-16
	1-Apr-16
	1-May-16
	1-Jun-16
	1-Jul-16
	1-Aug-16
	1-Sep-16
	1-Oct-16
	1-Nov-16
	1-Dec-16
	1-Jan-17
	1-Feb-17
	1-Mar-17
	1-Apr-17
	1-May-17
	1-Jun-17
	1-Jul-17
	1-Aug-17
	1-Sep-17
	1-Oct-17
	1-Nov-17
	1-Dec-17
	1-Jan-18
	1-Feb-18
	1-Mar-18
	1-Apr-18
	1-May-18
	1-Jun-18
	1-Jul-18
	1-Aug-18
	1-Sep-18
	1-Oct-18
	1-Nov-18
	1-Dec-18
	1-Jan-19
	1-Feb-19
	1-Mar-19
	1-Apr-19
	1-May-19
	1-Jun-19
	1-Jul-19
	1-Aug-19
	1-Sep-19
	1-Oct-19
	1-Nov-19
	1-Dec-19
	1-Jan-20
	1-Feb-20
	1-Mar-20
	1-Apr-20
	1-May-20
	1-Jun-20
	1-Jul-20
	1-Aug-20
	1-Sep-20
	1-Oct-20
	1-Nov-20
	1-Dec-20
	1-Jan-21
	1-Feb-21
	1-Mar-21
	1-Apr-21
	1-May-21
	1-Jun-21
	1-Jul-21
	1-Aug-21
	1-Sep-21
	1-Oct-21
	1-Nov-21
	1-Dec-21
	1-Jan-22
	1-Feb-22
	1-Mar-22
	1-Apr-22
	1-May-22
	1-Jun-22
	1-Jul-22
	1-Aug-22
	1-Sep-22
	1-Oct-22
	1-Nov-22
	1-Dec-22
	1-Jan-23
	1-Feb-23
	1-Mar-23
	1-Apr-23
EXTRATO GERENCIAL
	Apoio 2	DATA PAGAMENTO	DATA PREVISÃO	CONTA	DESCRIÇÃO	VALOR	SALDO ACUMULADO
	1-Dec-13	1-Dec-13	SALDO INICIAL	2,500.00	2,500.00
	1-Dec-13	3-Dec-13	SALÁRIO	5,000.00	7,500.00
	1-Dec-13	3-Dec-13	13 SAL / FÉRIAS	2,343.00	9,843.00
	1-Dec-13	4-Dec-13	JUROS	100.00	9,943.00
	1-Dec-13	4-Dec-13	OUTROS	2,000.00	11,943.00
	1-Dec-13	4-Dec-13	VISA	 ( 1,000.00 ) 	10,943.00
	1-Dec-13	4-Dec-13	ALUGUEL APTO	 ( 800.00 ) 	10,143.00
	1-Dec-13	5-Dec-13	CONDOMÍNIO APTO	 ( 40.00 ) 	10,103.00
	1-Dec-13	5-Dec-13	DIARISTA	 ( 568.15 ) 	9,534.85
	1-Dec-13	5-Dec-13	SKY	 ( 164.57 ) 	9,370.28
	1-Dec-13	5-Dec-13	GVT - INTERNET	 ( 120.00 ) 	9,250.28
	1-Dec-13	5-Dec-13	TIM	 ( 300.00 ) 	8,950.28
	1-Dec-13	6-Dec-13	CELPE	 ( 140.00 ) 	8,810.28
	1-Dec-13	10-Dec-13	ABA	 ( 200.00 ) 	8,610.28
	1-Dec-13	10-Dec-13	GINÁSTICA	 ( 232.00 ) 	8,378.28
	1-Dec-13	10-Dec-13	BALLET	 ( 208.67 ) 	8,169.61
	1-Dec-13	10-Dec-13	ESCOLA	 ( 60.00 ) 	8,109.61
	1-Dec-13	10-Dec-13	MATERIAL ESCOLAR	 ( 200.00 ) 	7,909.61
	1-Dec-13	10-Dec-13	TRANSPORTE	 ( 100.00 ) 	7,809.61
	1-Dec-13	13-Dec-13	TARIFA	 ( 150.00 ) 	7,659.61
	1-Dec-13	17-Dec-13	IPTU	 ( 60.00 ) 	7,599.61
	1-Dec-13	17-Dec-13	IPVA	 ( 50.00 ) 	7,549.61
	1-Dec-13	17-Dec-13	SEGURO	 ( 146.40 ) 	7,403.21
	1-Dec-13	17-Dec-13	APLICAÇÃO	 ( 3,000.00 ) 	4,403.21
	1-Dec-13	31-Dec-13	RETIRADA	4,403.21
	1-Jan-14	1-Jan-14	SALDO INICIAL	4,403.21	4,403.21
	1-Jan-14	3-Jan-14	SALÁRIO	5,000.00	9,403.21
	1-Jan-14	5-Jan-14	13 SAL / FÉRIAS	9,403.21
	1-Jan-14	7-Jan-14	JUROS	100.00	9,503.21
	1-Jan-14	9-Jan-14	OUTROS	2,000.00	11,503.21
	1-Jan-14	11-Jan-14	VISA	 ( 1,000.00 ) 	10,503.21
	1-Jan-14	13-Jan-14	ALUGUEL APTO	 ( 800.00 ) 	9,703.21
	1-Jan-14	15-Jan-14	CONDOMÍNIO APTO	 ( 40.00 ) 	9,663.21
	1-Jan-14	17-Jan-14	DIARISTA	 ( 568.15 ) 	9,095.06
	1-Jan-14	19-Jan-14	SKY	 ( 164.57 ) 	8,930.49
	1-Jan-14	21-Jan-14	GVT - INTERNET	 ( 120.00 ) 	8,810.49
	1-Jan-14	23-Jan-14	TIM	 ( 300.00 ) 	8,510.49
	1-Jan-14	25-Jan-14	CELPE	 ( 140.00 ) 	8,370.49
	1-Jan-14	14-Jan-14	ABA	 ( 200.00 ) 	8,170.49
	1-Jan-14	16-Jan-14	GINÁSTICA	 ( 232.00 ) 	7,938.49
	1-Jan-14	18-Jan-14	BALLET	 ( 208.67 ) 	7,729.82
	1-Jan-14	20-Jan-14	ESCOLA	 ( 60.00 ) 	7,669.82
	1-Jan-14	22-Jan-14	MATERIAL ESCOLAR	 ( 200.00 ) 	7,469.82
	1-Jan-14	24-Jan-14	TRANSPORTE	 ( 100.00 ) 	7,369.82
	1-Jan-14	16-Jan-14	TARIFA	 ( 150.00 ) 	7,219.82
	1-Jan-14	18-Jan-14	IPTU	 ( 60.00 ) 	7,159.82
	1-Jan-14	20-Jan-14	IPVA	 ( 50.00 ) 	7,109.82
	1-Jan-14	22-Jan-14	SEGURO	 ( 146.40 ) 	6,963.42
	1-Jan-14	24-Jan-14	APLICAÇÃO	 ( 3,000.00 ) 	3,963.42
	1-Jan-14	26-Jan-14	RETIRADA	3,963.42
	1-Feb-14	1-Feb-14	SALDO INICIAL	3,963.42	3,963.42
	1-Feb-14	3-Feb-14	SALÁRIO	5,000.00	8,963.42
	1-Feb-14	5-Feb-14	13 SAL / FÉRIAS	8,963.42
	1-Feb-14	7-Feb-14	JUROS	100.00	9,063.42
	1-Feb-14	9-Feb-14	OUTROS	2,000.00	11,063.42
	1-Feb-14	11-Feb-14	VISA	 ( 1,000.00 ) 	10,063.42
	1-Feb-14	13-Feb-14	ALUGUEL APTO	 ( 800.00 ) 	9,263.42
	1-Feb-14	15-Feb-14	CONDOMÍNIO APTO	 ( 40.00 ) 	9,223.42
	1-Feb-14	17-Feb-14	DIARISTA	 ( 568.15 ) 	8,655.27
	1-Feb-14	19-Feb-14	SKY	 ( 164.57 ) 	8,490.70
	1-Feb-14	21-Feb-14	GVT - INTERNET	 ( 120.00 ) 	8,370.70
	1-Feb-14	23-Feb-14	TIM	 ( 300.00 ) 	8,070.70
	1-Feb-14	25-Feb-14	CELPE	 ( 140.00 ) 	7,930.70
	1-Feb-14	27-Feb-14	ABA	 ( 200.00 ) 	7,730.70
1-Mar-14	1-Mar-14	GINÁSTICA	 ( 232.00 ) 	7,498.70
	1-Mar-14	3-Mar-14	BALLET	 ( 208.67 ) 	7,290.03
	1-Mar-14	5-Mar-14	ESCOLA	 ( 60.00 ) 	7,230.03
	1-Mar-14	7-Mar-14	MATERIAL ESCOLAR	 ( 200.00 ) 	7,030.03
	1-Mar-14	9-Mar-14	TRANSPORTE	 ( 100.00 ) 	6,930.03
	1-Mar-14	11-Mar-14	TARIFA	 ( 150.00 ) 	6,780.03
	1-Mar-14	13-Mar-14	IPTU	 ( 60.00 ) 	6,720.03
	1-Mar-14	15-Mar-14	IPVA	 ( 50.00 ) 	6,670.03
	1-Mar-14	17-Mar-14	SEGURO	 ( 146.40 ) 	6,523.63
	1-Mar-14	19-Mar-14	APLICAÇÃO	 ( 500.00 ) 	6,023.63
	1-Mar-14	21-Mar-14	RETIRADA	6,023.63
	1-Mar-14	1-Mar-14	SALDO INICIAL	6,023.63	6,023.63
	1-Mar-14	3-Mar-14	SALÁRIO	5,000.00	11,023.63
	1-Mar-14	5-Mar-14	13 SAL / FÉRIAS	11,023.63
	1-Mar-14	7-Mar-14	JUROS	100.00	11,123.63
	1-Mar-14	9-Mar-14	OUTROS	2,000.00	13,123.63
	1-Mar-14	11-Mar-14	VISA	 ( 1,000.00 ) 	12,123.63
	1-Mar-14	13-Mar-14	ALUGUEL APTO	 ( 800.00 ) 	11,323.63
	1-Mar-14	15-Mar-14	CONDOMÍNIO APTO	 ( 40.00 ) 	11,283.63
	1-Mar-14	17-Mar-14	DIARISTA	 ( 568.15 ) 	10,715.48
	1-Mar-14	19-Mar-14	SKY	 ( 164.57 ) 	10,550.91
	1-Mar-14	21-Mar-14	GVT - INTERNET	 ( 120.00 ) 	10,430.91
	1-Mar-14	23-Mar-14	TIM	 ( 300.00 ) 	10,130.91
	1-Mar-14	25-Mar-14	CELPE	 ( 140.00 ) 	9,990.91
	1-Mar-14	27-Mar-14	ABA	 ( 200.00 ) 	9,790.91
	1-Mar-14	29-Mar-14	GINÁSTICA	 ( 232.00 ) 	9,558.91
	1-Mar-14	31-Mar-14	BALLET	 ( 208.67 ) 	9,350.24
	1-Apr-14	2-Apr-14	ESCOLA	 ( 60.00 ) 	9,290.24
	1-Apr-14	4-Apr-14	MATERIAL ESCOLAR	 ( 200.00 ) 	9,090.24
	1-Apr-14	6-Apr-14	TRANSPORTE	 ( 100.00 ) 	8,990.24
	1-Apr-14	8-Apr-14	TARIFA	 ( 150.00 ) 	8,840.24
	1-Apr-14	10-Apr-14	IPTU	 ( 60.00 ) 	8,780.24
	1-Apr-14	12-Apr-14	IPVA	 ( 50.00 ) 	8,730.24
	1-Apr-14	14-Apr-14	SEGURO	 ( 146.40 ) 	8,583.84
	1-Apr-14	16-Apr-14	APLICAÇÃO	 ( 500.00 ) 	8,083.84
	1-Apr-14	18-Apr-14	RETIRADA	8,083.84
	1-Apr-14	1-Apr-14	SALDO INICIAL	8,083.84	8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
	1-May-13	1-May-13	SALDO INICIAL	8,083.84	8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
		8,083.84
	1-Jun-13	1-Jun-13	SALDO INICIAL	8,083.84	8,083.84

Teste o Premium para desbloquear

Aproveite todos os benefícios por 3 dias sem pagar! 😉
Já tem cadastro?

E aí, curtiu este material?

Ajude a incentivar outros estudantes a melhorar o conteúdo

Gostou desse material? Compartilhe! 🧡

LikeFooter
DislikeFooter

Excel

5.231 Materiais compartilhados

mobile

Baixe o app para aproveitar ainda mais

Leia os materiais offline, sem usar a internet. Além de vários outros recursos!

Continue navegando

Perguntas relacionadas

Question Icon

102:59 Progresso:8/10 2 HORAS AVALIAÇÃO – ORÇAMENTO EMPRESARIAL E FLUXO DE CAIXA 10 É incorreto dizer: O orçamento empresarial traduz o planejame...

User badge image

Diego Assis

Question Icon

Uma pessoa pretende atingir no final de 10 meses um montante de R$ 101.766,89 e para isto programou 03 fluxos de caixa, conforme descrito:

User badge image

Evy

Question Icon

Para um custo de capital de 12% a.a. e com as informações disponíveis a seguir, calcule a Taxa Interna de Retorno (TIR). Investimento Inicial R$ 10...

User badge image

Estudando com Questões

Question Icon

O projeto X produz um fluxo de caixa líquido (após taxas e impostos) de $1.000,00 no final do primeiro ano, $1.200,00 no final do segundo ano e $1....

User badge image

Edison Soares

Outros materiais