Atividade Individual - Métodos quantitativos aplicados ao corporate finance - Planilha de Cálculo

Prévia do material em texto

Faturamento
	índice de crescimento	ano	faturamento	previsão	intervalo de confiança
		Ano - 20 	R$ 1,000,000.00
	0.99960	Ano - 19 	R$ 999,600.00
	1.05060	Ano - 18 	R$ 1,050,179.76
	1.04040	Ano - 17 	R$ 1,092,607.02
	0.99960	Ano - 16 	R$ 1,092,169.98
	1.06080	Ano - 15 	R$ 1,158,573.91
	1.04040	Ano - 14 	R$ 1,205,380.30
	1.05060	Ano - 13 	R$ 1,266,372.54
	1.04040	Ano - 12 	R$ 1,317,533.99
	1.07100	Ano - 11 	R$ 1,411,078.91
	1.04040	Ano - 10 	R$ 1,468,086.50
	1.03020	Ano - 9 	R$ 1,512,422.71
	1.06080	Ano - 8 	R$ 1,604,378.01
	1.02000	Ano - 7 	R$ 1,636,465.57
	0.98940	Ano - 6 	R$ 1,619,119.03
	0.99960	Ano - 5 	R$ 1,618,471.39
	1.05060	Ano - 4 	R$ 1,700,366.04
	0.96900	Ano - 3 	R$ 1,647,654.69
	0.99960	Ano - 2 	R$ 1,646,995.63
	1.04040	Ano - 1 	R$ 1,713,534.25
	1.06688	Ano + 0		R$ 1,828,136.06	R$ 113,524.86
	1.02322	Ano + 1		R$ 1,870,589.32	R$ 114,436.72
	1.02270	Ano + 2		R$ 1,913,042.58	R$ 115,355.62
	1.02219	Ano + 3		R$ 1,955,495.84	R$ 116,281.49
	1.02171	Ano + 4		R$ 1,997,949.10	R$ 117,214.30
Faturamento realizado e previsto
faturamento	1000000	999600	1050179.76	1092607.02	1092169.98	1158573.9099999999	1205380.3	1266372.54	1317533.9900000002	1411078.9100000001	1468086.5000000002	1512422.7100000002	1604378.0100000002	1636465.5700000003	1619119.0300000003	1618471.3900000001	1700366.0400000003	1647654.6900000002	1646995.6300000001	1713534.2500000002	previsão	113524.86259894352	114436.72171702568	115355.61772037855	116281.49461899893	117214.29693797306	113524.86259894352	114436.72171702568	115355.61772037855	116281.49461899893	117214.29693797306	-20	-19	-18	-17	-16	-15	-14	-13	-12	-11	-10	-9	-8	-7	-6	-5	-4	-3	-2	-1	0	1	2	3	4	1828136.0620774089	1870589.3	214333735	1913042.5807893383	1955495.8401453029	1997949.0995012675	
Faturamento X kWh
	Ano	Faturamento	Consumo de energia (ano)	Consumo de energia médio (mês)
	Ano - 20 	R$ 1,000,000.00	19,800 KWh/Ano	1,650 KWh/Mês
	Ano - 19 	R$ 999,600.00	19,792 KWh/Ano	1,649 KWh/Mês
	Ano - 18 	R$ 1,050,179.76	20,794 KWh/Ano	1,733 KWh/Mês
	Ano - 17 	R$ 1,092,607.02	21,634 KWh/Ano	1,803 KWh/Mês
	Ano - 16 	R$ 1,092,169.98	21,843 KWh/Ano	1,820 KWh/Mês
	Ano - 15 	R$ 1,158,573.91	22,708 KWh/Ano	1,892 KWh/Mês
	Ano - 14 	R$ 1,205,380.30	23,625 KWh/Ano	1,969 KWh/Mês
	Ano - 13 	R$ 1,266,372.54	25,581 KWh/Ano	2,132 KWh/Mês
	Ano - 12 	R$ 1,317,533.99	26,878 KWh/Ano	2,240 KWh/Mês
	Ano - 11 	R$ 1,411,078.91	28,222 KWh/Ano	2,352 KWh/Mês
	Ano - 10 	R$ 1,468,086.50	29,068 KWh/Ano	2,422 KWh/Mês
	Ano - 9 	R$ 1,512,422.71	30,853 KWh/Ano	2,571 KWh/Mês
	Ano - 8 	R$ 1,604,378.01	32,408 KWh/Ano	2,701 KWh/Mês
	Ano - 7 	R$ 1,636,465.57	33,057 KWh/Ano	2,755 KWh/Mês
	Ano - 6 	R$ 1,619,119.03	32,059 KWh/Ano	2,672 KWh/Mês
	Ano - 5 	R$ 1,618,471.39	32,046 KWh/Ano	2,671 KWh/Mês
	Ano - 4 	R$ 1,700,366.04	34,347 KWh/Ano	2,862 KWh/Mês
	Ano - 3 	R$ 1,647,654.69	32,953 KWh/Ano	2,746 KWh/Mês
	Ano - 2 	R$ 1,646,995.63	33,599 KWh/Ano	2,800 KWh/Mês
	Ano - 1 	R$ 1,713,534.25	34,271 KWh/Ano	2,856 KWh/Mês
1 - Correl
		Utilizar (X)		Utilizar (Y)
	Ano	Faturamento	Consumo de energia (ano)	Consumo de energia médio (mês)
	Ano - 20 	R$ 1,000,000.00	19,800 KWh/Ano	1,650 KWh/Mês		Coeficiente de Correlação	0.99821002727944
	Ano - 19 	R$ 999,600.00	19,792 KWh/Ano	1,649 KWh/Mês		Coeficiente de Determinação	0.996423258561221
	Ano - 18 	R$ 1,050,179.76	20,794 KWh/Ano	1,733 KWh/Mês
	Ano - 17 	R$ 1,092,607.02	21,634 KWh/Ano	1,803 KWh/Mês
	Ano - 16 	R$ 1,092,169.98	21,843 KWh/Ano	1,820 KWh/Mês
	Ano - 15 	R$ 1,158,573.91	22,708 KWh/Ano	1,892 KWh/Mês
	Ano - 14 	R$ 1,205,380.30	23,625 KWh/Ano	1,969 KWh/Mês
	Ano - 13 	R$ 1,266,372.54	25,581 KWh/Ano	2,132 KWh/Mês
	Ano - 12 	R$ 1,317,533.99	26,878 KWh/Ano	2,240 KWh/Mês
	Ano - 11 	R$ 1,411,078.91	28,222 KWh/Ano	2,352 KWh/Mês
	Ano - 10 	R$ 1,468,086.50	29,068 KWh/Ano	2,422 KWh/Mês
	Ano - 9 	R$ 1,512,422.71	30,853 KWh/Ano	2,571 KWh/Mês
	Ano - 8 	R$ 1,604,378.01	32,408 KWh/Ano	2,701 KWh/Mês
	Ano - 7 	R$ 1,636,465.57	33,057 KWh/Ano	2,755 KWh/Mês
	Ano - 6 	R$ 1,619,119.03	32,059 KWh/Ano	2,672 KWh/Mês
	Ano - 5 	R$ 1,618,471.39	32,046 KWh/Ano	2,671 KWh/Mês
	Ano - 4 	R$ 1,700,366.04	34,347 KWh/Ano	2,862 KWh/Mês
	Ano - 3 	R$ 1,647,654.69	32,953 KWh/Ano	2,746 KWh/Mês
	Ano - 2 	R$ 1,646,995.63	33,599 KWh/Ano	2,800 KWh/Mês
	Ano - 1 	R$ 1,713,534.25	34,271 KWh/Ano	2,856 KWh/Mês
2 - Equação da Reta
		Variavel X	Variavel Y 
	Ano	Faturamento	Consumo de energia médio (mês)	(X x Y)	X²
	Ano - 20 	R$ 1,000,000.00	1,650 KWh/Mês	R$ 1,650,000,000.00	R$ 1,000,000,000,000.00				∑(X × Y) =	66,443,081,421.20		∑(X × Y) =	66,443,081,421.20
	Ano - 19 	R$ 999,600.00	1,649 KWh/Mês	R$ 1,648,340,400.00	R$ 999,200,160,000.00				n =	20		n =	20
	Ano - 18 	R$ 1,050,179.76	1,733 KWh/Mês	R$ 1,819,961,524.08	R$ 1,102,877,528,313.66				 =	3,213,057,009.22		 =	3,213,057,009.22
	Ano - 17 	R$ 1,092,607.02	1,803 KWh/Mês	R$ 1,969,970,457.06	R$ 1,193,790,100,153.28				∑(X2) =	39,805,226,879,515.17		∑(X2) =	39,805,226,879,515.17
	Ano - 16 	R$ 1,092,169.98	1,820 KWh/Mês	R$ 1,987,749,363.60	R$ 1,192,835,265,213.20				 =	1,926,681,446,375.39		 =	1,926,681,446,375.39
	Ano - 15 	R$ 1,158,573.91	1,892 KWh/Mês	R$ 2,192,021,837.72	R$ 1,342,293,504,932.69				 =	2,314.80		 =	2,314.80
	Ano - 14 	R$ 1,205,380.30	1,969 KWh/Mês	R$ 2,373,393,810.70	R$ 1,452,941,667,628.09				 =	1,388,049.51		 =	1,388,049.51
	Ano - 13 	R$ 1,266,372.54	2,132 KWh/Mês	R$ 2,699,906,255.28	R$ 1,603,699,410,066.05
	Ano - 12 	R$ 1,317,533.99	2,240 KWh/Mês	R$ 2,951,276,137.60	R$ 1,735,895,814,805.32
	Ano - 11 	R$ 1,411,078.91	2,352 KWh/Mês	R$ 3,318,857,596.32	R$ 1,991,143,690,246.79
	Ano - 10 	R$ 1,468,086.50	2,422 KWh/Mês	R$ 3,555,705,503.00	R$ 2,155,277,971,482.25				Equação da Reta
	Ano - 9 	R$ 1,512,422.71	2,571 KWh/Mês	R$ 3,888,438,787.41	R$ 2,287,422,453,723.74				b	2,181,941,236.80	0.001715905
	Ano - 8 	R$ 1,604,378.01	2,701 KWh/Mês	R$ 4,333,425,005.01	R$ 2,574,028,798,971.56					1271597952007.38
	Ano - 7 	R$ 1,636,465.57	2,755 KWh/Mês	R$ 4,508,462,645.35	R$ 2,678,019,561,795.43
	Ano - 6 	R$ 1,619,119.03	2,672 KWh/Mês	R$ 4,326,286,048.16	R$ 2,621,546,433,308.14				a	- 66.96
	Ano - 5 	R$ 1,618,471.39	2,671 KWh/Mês	R$ 4,322,937,082.69	R$ 2,619,449,640,248.53
	Ano - 4 	R$ 1,700,366.04	2,862 KWh/Mês	R$ 4,866,447,606.48	R$ 2,891,244,669,985.28
	Ano - 3 	R$ 1,647,654.69	2,746 KWh/Mês	R$ 4,524,459,778.74	R$ 2,714,765,977,479.00
	Ano - 2 	R$ 1,646,995.63	2,800 KWh/Mês	R$ 4,611,587,764.00	R$ 2,712,594,605,239.10
	Ano - 1 	R$ 1,713,534.25	2,856 KWh/Mês	R$ 4,893,853,818.00	R$ 2,936,199,625,923.06
	Média	R$ 1,388,049.51	2,315 KWh/Mês	R$ 3,322,154,071.06
Regressão Linear
Consumo de energia médio (mês	)	
1000000	999600	1050179.76	1092607.02	1092169.98	1158573.9099999999	1205380.3	1266372.54	1317533.9900000002	1411078.9100000001	1468086.5000000002	15124	22.7100000002	1604378.0100000002	1636465.570000000	3	1619119.0300000003	1618471.3900000001	1700366.0400000003	1647654.6900000002	1646995.6300000001	1713534.2500000002	1650	1649	1733	1803	1820	1892	1969	2132	2240	2352	2422	2571	2701	2755	2672	2671	2862	2746	2800	2856	
3 - prox 5 anos
		Variavel X	Variavel Y 
	Ano	Faturamento	Consumo de energia médio (mês)			Equação	0,001716x - 66,96
	Ano - 20 	R$ 1,000,000.00	1,650 KWh/Mês
	Ano - 19 	R$ 999,600.00	1,649 KWh/Mês
	Ano - 18 	R$ 1,050,179.76	1,733 KWh/Mês
	Ano - 17 	R$ 1,092,607.02	1,803 KWh/Mês
	Ano - 16 	R$ 1,092,169.98	1,820 KWh/Mês
	Ano - 15 	R$ 1,158,573.91	1,892 KWh/Mês
	Ano - 14 	R$ 1,205,380.30	1,969 KWh/Mês
	Ano - 13 	R$ 1,266,372.54	2,132 KWh/Mês
	Ano - 12 	R$ 1,317,533.99	2,240KWh/Mês
	Ano - 11 	R$ 1,411,078.91	2,352 KWh/Mês
	Ano - 10 	R$ 1,468,086.50	2,422 KWh/Mês
	Ano - 9 	R$ 1,512,422.71	2,571 KWh/Mês
	Ano - 8 	R$ 1,604,378.01	2,701 KWh/Mês
	Ano - 7 	R$ 1,636,465.57	2,755 KWh/Mês
	Ano - 6 	R$ 1,619,119.03	2,672 KWh/Mês
	Ano - 5 	R$ 1,618,471.39	2,671 KWh/Mês
	Ano - 4 	R$ 1,700,366.04	2,862 KWh/Mês
	Ano - 3 	R$ 1,647,654.69	2,746 KWh/Mês
	Ano - 2 	R$ 1,646,995.63	2,800 KWh/Mês
	Ano - 1 	R$ 1,713,534.25	2,856 KWh/Mês
	Ano + 0	R$ 1,828,136.06	3,070 KWh/Mês
	Ano + 1	R$ 1,870,589.32	3,143 KWh/Mês
	Ano + 2	R$ 1,913,042.58	3,216 KWh/Mês
	Ano + 3	R$ 1,955,495.84	3,289 KWh/Mês
	Ano + 4	R$ 1,997,949.10	3,362 KWh/Mês
4 - Fluxo caixa 
	Premissas	Projeto	R$ 90,600.00
		entrada (30%)	R$ 27,180.00
		Valor a pagar	R$ 63,420.00
		n projeto	36
		i (a.m)	1.19%
		Economia Mês (kWh/mês)	3,000
		Tarifa	0.86
		TMA	1.48%
	Período	Entrada: 30% * Total dos Investimentos	Prestação: PMT = PV{i (1 + i)n/ [(1 + i) n - 1]}	Economia de Energia a.m.: Kwh/mês * Valor da Tarifa = R$....	Valor Residual do Equipamento: Io * % equivalente ao VR	Gabarito (4)
Fluxo de Caixa	Fluxo de Caixa
Acumulado	Fluxo de Caixa
Descontado	Fluxo de Caixa
Descontado
Acumulado
	Período	Entrada	Prestação: 	Economia	VR	F.C.	F.C.A.	F.C.D.	F.C.D.A.
	0	-R$ 27,180.00				-R$ 27,180.00	-R$ 27,180.00	-R$ 27,180.00	-R$ 27,180.00
	1		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 26,776.18	R$ 397.93	-R$ 26,782.07
	2		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 26,372.36	R$ 392.13	-R$ 26,389.94
	3		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 25,968.54	R$ 386.41	-R$ 26,003.53
	4		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 25,564.72	R$ 380.77	-R$ 25,622.76
	5		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 25,160.90	R$ 375.22	-R$ 25,247.54
	6		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 24,757.08	R$ 369.75	-R$ 24,877.79
	7		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 24,353.26	R$ 364.35	-R$ 24,513.44
	8		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 23,949.44	R$ 359.04	-R$ 24,154.40
	9		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 23,545.62	R$ 353.80	-R$ 23,800.59
	10		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 23,141.80	R$ 348.64	-R$ 23,451.95
	11		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 22,737.98	R$ 343.56	-R$ 23,108.39
	12		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 22,334.16	R$ 338.55	-R$ 22,769.84
	13		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 21,930.34	R$ 333.61	-R$ 22,436.23
	14		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 21,526.52	R$ 328.75	-R$ 22,107.48
	15		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 21,122.70	R$ 323.95	-R$ 21,783.53
	16		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 20,718.88	R$ 319.23	-R$ 21,464.30
	17		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 20,315.06	R$ 314.57	-R$ 21,149.73
	18		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 19,911.24	R$ 309.98	-R$ 20,839.74
	19		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 19,507.42	R$ 305.46	-R$ 20,534.28
	20		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 19,103.60	R$ 301.01	-R$ 20,233.27
	21		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 18,699.78	R$ 296.62	-R$ 19,936.65
	22		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 18,295.96	R$ 292.29	-R$ 19,644.36
	23		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 17,892.14	R$ 288.03	-R$ 19,356.33
	24		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 17,488.32	R$ 283.83	-R$ 19,072.50
	25		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 17,084.50	R$ 279.69	-R$ 18,792.81
	26		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 16,680.68	R$ 275.61	-R$ 18,517.20
	27		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 16,276.86	R$ 271.59	-R$ 18,245.61
	28		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 15,873.04	R$ 267.63	-R$ 17,977.98
	29		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 15,469.22	R$ 263.73	-R$ 17,714.25
	30		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 15,065.40	R$ 259.88	-R$ 17,454.37
	31		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 14,661.58	R$ 256.09	-R$ 17,198.28
	32		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 14,257.76	R$ 252.36	-R$ 16,945.93
	33		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 13,853.94	R$ 248.68	-R$ 16,697.25
	34		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 13,450.12	R$ 245.05	-R$ 16,452.20
	35		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 13,046.30	R$ 241.47	-R$ 16,210.73
	36		-R$ 2,176.18	R$ 2,580.00		R$ 403.82	-R$ 12,642.48	R$ 237.95	-R$ 15,972.77
	37			R$ 2,580.00		R$ 2,580.00	-R$ 10,062.48	R$ 1,498.11	-R$ 14,474.67
	38			R$ 2,580.00		R$ 2,580.00	-R$ 7,482.48	R$ 1,476.26	-R$ 12,998.41
	39			R$ 2,580.00		R$ 2,580.00	-R$ 4,902.48	R$ 1,454.73	-R$ 11,543.68
	40			R$ 2,580.00		R$ 2,580.00	-R$ 2,322.48	R$ 1,433.51	-R$ 10,110.17
	41			R$ 2,580.00		R$ 2,580.00	R$ 257.52	R$ 1,412.61	-R$ 8,697.56
	42			R$ 2,580.00		R$ 2,580.00	R$ 2,837.52	R$ 1,392.00	-R$ 7,305.56
	43			R$ 2,580.00		R$ 2,580.00	R$ 5,417.52	R$ 1,371.70	-R$ 5,933.86
	44			R$ 2,580.00		R$ 2,580.00	R$ 7,997.52	R$ 1,351.70	-R$ 4,582.16
	45			R$ 2,580.00		R$ 2,580.00	R$ 10,577.52	R$ 1,331.98	-R$ 3,250.18
	46			R$ 2,580.00		R$ 2,580.00	R$ 13,157.52	R$ 1,312.56	-R$ 1,937.62
	47			R$ 2,580.00		R$ 2,580.00	R$ 15,737.52	R$ 1,293.42	-R$ 644.20
	48			R$ 2,580.00		R$ 2,580.00	R$ 18,317.52	R$ 1,274.55	R$ 630.35
	49			R$ 2,580.00		R$ 2,580.00	R$ 20,897.52	R$ 1,255.96	R$ 1,886.31
	50			R$ 2,580.00		R$ 2,580.00	R$ 23,477.52	R$ 1,237.65	R$ 3,123.96
	51			R$ 2,580.00		R$ 2,580.00	R$ 26,057.52	R$ 1,219.60	R$ 4,343.56
	52			R$ 2,580.00		R$ 2,580.00	R$ 28,637.52	R$ 1,201.81	R$ 5,545.37
	53			R$ 2,580.00		R$ 2,580.00	R$ 31,217.52	R$ 1,184.28	R$ 6,729.65
	54			R$ 2,580.00		R$ 2,580.00	R$ 33,797.52	R$ 1,167.01	R$ 7,896.66
	55			R$ 2,580.00		R$ 2,580.00	R$ 36,377.52	R$ 1,149.99	R$ 9,046.65
	56			R$ 2,580.00		R$ 2,580.00	R$ 38,957.52	R$ 1,133.22	R$ 10,179.87
	57			R$ 2,580.00		R$ 2,580.00	R$ 41,537.52	R$ 1,116.69	R$ 11,296.57
	58			R$ 2,580.00		R$ 2,580.00	R$ 44,117.52	R$ 1,100.41	R$ 12,396.97
	59			R$ 2,580.00		R$ 2,580.00	R$ 46,697.52	R$ 1,084.36	R$ 13,481.33
	60			R$ 2,580.00	R$ 9,060.00	R$ 11,640.00	R$ 58,337.52	R$ 4,820.87	R$ 18,302.20
									VPL
5 - Fluxo caixa 2
	Premissas	Projeto	R$ 99,200.00	Dados dos anos 	Ano 0	3070.12
		entrada (30%)	R$ 29,760.00		Ano 1	3142.97
		Valor a pagar	R$ 69,440.00		Ano 2	3215.82
		n projeto	36		Ano 3	3288.67
		i (a.m)	1.19%		Ano 4	3361.52
		Economia Mês MAx (kWh/mês)	3,500
		Tarifa	0.86
		TMA	1.48%
	Período	Entrada: 30% * Total dos Investimentos	Prestação: PMT = PV{i (1 + i)n/ [(1 + i) n - 1]}	Economia de Energia a.m.: Kwh/mês * Valor da Tarifa = R$....	Valor Residual do Equipamento: Io * % equivalente ao VR	Gabarito (4)
Fluxo de Caixa	Fluxo de Caixa
Acumulado	Fluxo de Caixa
Descontado	Fluxo de Caixa
Descontado
Acumulado
	Período	Entrada	Prestação: 	Economia	VR	F.C.	F.C.A.	F.C.D.	F.C.D.A.
	0	-R$ 29,760.00				-R$ 29,760.00	-R$ 29,760.00	-R$ 29,760.00	-R$ 29,760.00
	1		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 29,502.44	R$ 253.80	-R$ 29,506.20
	2		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 29,244.89	R$ 250.10	-R$ 29,256.10
	3		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 28,987.33	R$ 246.45	-R$ 29,009.65
	4		-R$ 2,382.75	R$ 2,640.30		R$ 257.56-R$ 28,729.78	R$ 242.86	-R$ 28,766.80
	5		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 28,472.22	R$ 239.31	-R$ 28,527.48
	6		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 28,214.67	R$ 235.82	-R$ 28,291.66
	7		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 27,957.11	R$ 232.38	-R$ 28,059.27
	8		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 27,699.56	R$ 229.00	-R$ 27,830.28
	9		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 27,442.00	R$ 225.66	-R$ 27,604.62
	10		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 27,184.44	R$ 222.36	-R$ 27,382.26
	11		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 26,926.89	R$ 219.12	-R$ 27,163.13
	12		-R$ 2,382.75	R$ 2,640.30		R$ 257.56	-R$ 26,669.33	R$ 215.93	-R$ 26,947.21
	13		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 26,349.13	R$ 264.54	-R$ 26,682.67
	14		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 26,028.92	R$ 260.68	-R$ 26,422.00
	15		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 25,708.71	R$ 256.88	-R$ 26,165.12
	16		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 25,388.51	R$ 253.13	-R$ 25,911.99
	17		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 25,068.30	R$ 249.44	-R$ 25,662.55
	18		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 24,748.10	R$ 245.80	-R$ 25,416.75
	19		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 24,427.89	R$ 242.22	-R$ 25,174.54
	20		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 24,107.68	R$ 238.68	-R$ 24,935.85
	21		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 23,787.48	R$ 235.20	-R$ 24,700.65
	22		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 23,467.27	R$ 231.77	-R$ 24,468.88
	23		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 23,147.06	R$ 228.39	-R$ 24,240.49
	24		-R$ 2,382.75	R$ 2,702.96		R$ 320.21	-R$ 22,826.86	R$ 225.06	-R$ 24,015.43
	25		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 22,444.00	R$ 265.17	-R$ 23,750.26
	26		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 22,061.14	R$ 261.30	-R$ 23,488.96
	27		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 21,678.29	R$ 257.49	-R$ 23,231.46
	28		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 21,295.43	R$ 253.74	-R$ 22,977.73
	29		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 20,912.57	R$ 250.04	-R$ 22,727.69
	30		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 20,529.71	R$ 246.39	-R$ 22,481.30
	31		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 20,146.86	R$ 242.80	-R$ 22,238.50
	32		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 19,764.00	R$ 239.26	-R$ 21,999.25
	33		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 19,381.14	R$ 235.77	-R$ 21,763.48
	34		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 18,998.29	R$ 232.33	-R$ 21,531.15
	35		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 18,615.43	R$ 228.94	-R$ 21,302.21
	36		-R$ 2,382.75	R$ 2,765.61		R$ 382.86	-R$ 18,232.57	R$ 225.60	-R$ 21,076.61
	37			R$ 2,828.26		R$ 2,828.26	-R$ 15,404.31	R$ 1,642.26	-R$ 19,434.35
	38			R$ 2,828.26		R$ 2,828.26	-R$ 12,576.06	R$ 1,618.31	-R$ 17,816.05
	39			R$ 2,828.26		R$ 2,828.26	-R$ 9,747.80	R$ 1,594.71	-R$ 16,221.34
	40			R$ 2,828.26		R$ 2,828.26	-R$ 6,919.54	R$ 1,571.45	-R$ 14,649.89
	41			R$ 2,828.26		R$ 2,828.26	-R$ 4,091.29	R$ 1,548.53	-R$ 13,101.36
	42			R$ 2,828.26		R$ 2,828.26	-R$ 1,263.03	R$ 1,525.95	-R$ 11,575.41
	43			R$ 2,828.26		R$ 2,828.26	R$ 1,565.23	R$ 1,503.69	-R$ 10,071.72
	44			R$ 2,828.26		R$ 2,828.26	R$ 4,393.48	R$ 1,481.76	-R$ 8,589.95
	45			R$ 2,828.26		R$ 2,828.26	R$ 7,221.74	R$ 1,460.15	-R$ 7,129.80
	46			R$ 2,828.26		R$ 2,828.26	R$ 10,050.00	R$ 1,438.86	-R$ 5,690.94
	47			R$ 2,828.26		R$ 2,828.26	R$ 12,878.26	R$ 1,417.87	-R$ 4,273.07
	48			R$ 2,828.26		R$ 2,828.26	R$ 15,706.51	R$ 1,397.19	-R$ 2,875.88
	49			R$ 2,890.91		R$ 2,890.91	R$ 18,597.42	R$ 1,407.32	-R$ 1,468.56
	50			R$ 2,890.91		R$ 2,890.91	R$ 21,488.33	R$ 1,386.79	-R$ 81.77
	51			R$ 2,890.91		R$ 2,890.91	R$ 24,379.24	R$ 1,366.57	R$ 1,284.80
	52			R$ 2,890.91		R$ 2,890.91	R$ 27,270.14	R$ 1,346.64	R$ 2,631.44
	53			R$ 2,890.91		R$ 2,890.91	R$ 30,161.05	R$ 1,327.00	R$ 3,958.43
	54			R$ 2,890.91		R$ 2,890.91	R$ 33,051.96	R$ 1,307.64	R$ 5,266.08
	55			R$ 2,890.91		R$ 2,890.91	R$ 35,942.87	R$ 1,288.57	R$ 6,554.65
	56			R$ 2,890.91		R$ 2,890.91	R$ 38,833.77	R$ 1,269.78	R$ 7,824.43
	57			R$ 2,890.91		R$ 2,890.91	R$ 41,724.68	R$ 1,251.26	R$ 9,075.69
	58			R$ 2,890.91		R$ 2,890.91	R$ 44,615.59	R$ 1,233.01	R$ 10,308.70
	59			R$ 2,890.91		R$ 2,890.91	R$ 47,506.50	R$ 1,215.03	R$ 11,523.73
	60			R$ 2,890.91	R$ 9,920.00	R$ 12,810.91	R$ 60,317.41	R$ 5,305.82	R$ 16,829.55
									VPL
6 - KPI viabilidade
		Projeto Original	Projeto + 1 Placa
	VPL	R$ 18,302.20	R$ 16,829.55
	TIR	2.8157%	2.5613%
	Payback Descontado	47.505	50.0598
	Índice de Lucratividade	1.67	1.57
	Último valor negativo	R$ 644.20	0.5054335572		R$ 81.77	0.0598342555
	Primeiro Positivo	R$ 630.35			R$ 1,284.80
(𝑋# 	×	𝑌#) 
(𝑋#$) 
𝑌" 
𝑋"