TRABALHO PRICE

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

Plan1
	FLUXO DE CAIXA
	DATA	DESCRIÇÃO	DÉBITO	CRÉDITO	SALDO INICIAL
	1-Oct	0	R$ 0.00	R$ 0.00	R$ 2,500.00
	2-Oct	ALUGUEL	-R$ 750.00	R$ 1,750.00
	3-Oct	FARMACIA	-R$ 150.00	R$ 1,600.00
	4-Oct	SUPERMERCADO	-R$ 850.00	R$ 750.00
	5-Oct	ROUPAS	R$ 500.00	R$ 1,250.00
	15-Oct	ANIVERSARIO	-R$ 50.00	R$ 1,200.00
	20-Oct	PIZZA	-R$ 50.00	R$ 1,150.00
	28-Oct	AGUA,LUZ	-R$ 250.00	R$ 900.00
	30-Oct	MERCADORIAS	-R$ 150.00	R$ 750.00
	30-Oct	ENTRADA	R$ 450.00	R$ 1,200.00
	31-Oct	TELEFONE	-R$ 150.00	R$ 1,050.00
	31-Oct	INTERTNET	-R$ 90.00	R$ 960.00
	TOTAL	-R$ 2,490.00
Plan2
	FLUXO DE CAIXA
	VC SOLUÇÕES EMPRESARIAIS
	DATA	DESCRIÇÃO	DÉBITO	CRÉDITO	SALDO INICIAL
	1-Oct	0	R$ 0.00	R$ 0.00	R$ 1,800.00
	2-Oct	ALUGUEL	-R$ 100.00	R$ 1,700.00
	3-Oct	FARMACIA	-R$ 150.00	R$ 1,550.00
	4-Oct	SUPERMERCADO	-R$ 300.00	R$ 1,250.00
	5-Oct	FRETES	R$ 400.00	R$ 1,650.00
	6-Oct	ANIVERSARIO	-R$ 50.00	R$ 1,600.00
	7-Oct	PIZZA	-R$ 50.00	R$ 1,550.00
	8-Oct	AGUA,LUZ	-R$ 300.00	R$ 1,250.00
	9-Oct	MERCADORIAS	-R$ 350.00	R$ 900.00
	10-Oct	ENTRADA	R$ 450.00	R$ 1,350.00
	11-Oct	HOTEL	-R$ 150.00	R$ 1,200.00
	12-Oct	COMBUSTIVEL	-R$ 190.00	R$ 1,010.00
	13-Oct	OFICINA	-R$ 340.00	R$ 670.00
	30-Oct	TELEFONE	-R$ 150.00	R$ 520.00
	31-Oct	INTERTNET	-R$ 80.00	R$ 440.00
	TOTAL	-R$ 2,210.00
Plan3
	VALOR DO EMPRESTIMO	R$ 50,000.00	TABELA SAC
	TAXA	12.00%
	Nº DE PARCELAS	5
	PREST.	JURO	AMORTIZAÇÃO	PARCELA	SALDO DEV.
	0	R$ 0.00	R$ 0.00	R$ 0.00	R$ 50,000.00
	1	R$ 6,000.00	R$ 10,000.00	R$ 16,000.00	R$ 40,000.00	EXP:SELECIONA O B6 ATE O E6 E COLACA-OS PARA BAIXO.(PARA SABER QUE ESTA CERTO O SALDO DEVEDOR DEVE FECHAR EM ZERO) 
	2	R$ 4,800.00	R$ 10,000.00	R$ 14,800.00	R$ 30,000.00
	3	R$ 3,600.00	R$ 10,000.00	R$ 13,600.00	R$ 20,000.00
	4	R$ 2,400.00	R$ 10,000.00	R$ 12,400.00	R$ 10,000.00
	5	R$ 1,200.00	R$ 10,000.00	R$ 11,200.00	R$ 0.00
	TOTAL	R$ 18,000.00
Plan4
	VALOR DO EMPRESTIMO	R$ 150,000.00	TABELA PRICE
	TAXA	5.00%	0
	Nº DE PARCELAS	36
	PREST.	JURO	AMORTIZAÇÃO	PARCELA	SALDO DEV.
	0	R$ 0.00	R$ 0.00	R$ 0.00	R$ 150,000.00
	1	R$ 7,500.00	R$ 1,565.17	R$ 9,065.17	R$ 148,434.83
	2	R$ 7,421.74	R$ 1,643.43	R$ 9,065.17	R$ 146,791.40
	3	R$ 7,339.57	R$ 1,725.60	R$ 9,065.17	R$ 145,065.81
	4	R$ 7,253.29	R$ 1,811.88	R$ 9,065.17	R$ 143,253.93
	5	R$ 7,162.70	R$ 1,902.47	R$ 9,065.17	R$ 141,351.46
	6	R$ 7,067.57	R$ 1,997.60	R$ 9,065.17	R$ 139,353.86
	7	R$ 6,967.69	R$ 2,097.48	R$ 9,065.17	R$ 137,256.38
	8	R$ 6,862.82	R$ 2,202.35	R$ 9,065.17	R$ 135,054.03
	9	R$ 6,752.70	R$ 2,312.47	R$ 9,065.17	R$ 132,741.57
	10	R$ 6,637.08	R$ 2,428.09	R$ 9,065.17	R$ 130,313.48
	11	R$ 6,515.67	R$ 2,549.49	R$ 9,065.17	R$ 127,763.98
	12	R$ 6,388.20	R$ 2,676.97	R$ 9,065.17	R$ 125,087.01
	13	R$ 6,254.35	R$ 2,810.82	R$ 9,065.17	R$ 122,276.20
	14	R$ 6,113.81	R$ 2,951.36	R$ 9,065.17	R$ 119,324.84
	15	R$ 5,966.24	R$ 3,098.93	R$ 9,065.17	R$ 116,225.91
	16	R$ 5,811.30	R$ 3,253.87	R$ 9,065.17	R$ 112,972.04
	17	R$ 5,648.60	R$ 3,416.57	R$ 9,065.17	R$ 109,555.47
	18	R$ 5,477.77	R$ 3,587.40	R$ 9,065.17	R$ 105,968.08
	19	R$ 5,298.40	R$ 3,766.76	R$ 9,065.17	R$ 102,201.31
	20	R$ 5,110.07	R$ 3,955.10	R$ 9,065.17	R$ 98,246.21
	21	R$ 4,912.31	R$ 4,152.86	R$ 9,065.17	R$ 94,093.35
	22	R$ 4,704.67	R$ 4,360.50	R$ 9,065.17	R$ 89,732.85
	23	R$ 4,486.64	R$ 4,578.53	R$ 9,065.17	R$ 85,154.32
	24	R$ 4,257.72	R$ 4,807.45	R$ 9,065.17	R$ 80,346.87
	25	R$ 4,017.34	R$ 5,047.83	R$ 9,065.17	R$ 75,299.05
	26	R$ 3,764.95	R$ 5,300.22	R$ 9,065.17	R$ 69,998.83
	27	R$ 3,499.94	R$ 5,565.23	R$ 9,065.17	R$ 64,433.60
	28	R$ 3,221.68	R$ 5,843.49	R$ 9,065.17	R$ 58,590.11
	29	R$ 2,929.51	R$ 6,135.66	R$ 9,065.17	R$ 52,454.45
	30	R$ 2,622.72	R$ 6,442.45	R$ 9,065.17	R$ 46,012.00
	31	R$ 2,300.60	R$ 6,764.57	R$ 9,065.17	R$ 39,247.44
	32	R$ 1,962.37	R$ 7,102.80	R$ 9,065.17	R$ 32,144.64
	33	R$ 1,607.23	R$ 7,457.94	R$ 9,065.17	R$ 24,686.70
	34	R$ 1,234.34	R$ 7,830.83	R$ 9,065.17	R$ 16,855.87
	35	R$ 842.79	R$ 8,222.38	R$ 9,065.17	R$ 8,633.49
	36	R$ 431.67	R$ 8,633.49	R$ 9,065.17	R$ 0.00
	total	R$ 176,346.07	R$ 150,000.00	R$ 326,346.07