Payback
Anos A B C D E
0 -26.000 -500.000 -170.000 -950.000 -80.000
1 4.000 100.000 20.000 230.000 0
2 4.000 120.000 19.000 230.000 0
3 4.000 140.000 18.000 230.000 0
4 4.000 160.000 17.000 230.000 19.000
5 4.000 180.000 16.000 230.000 30.000
6 4.000 200.000 15.000 230.000 0
7 4.000 14.000 230.000 50.000
8 4.000 13.000 230.000 60.000
9 4.000 12.000 230.000 70.000
10 4.000 11.000 230.000
VPL
A B C D E -26.000 -500.000 -170.000 -950.000 -80.000 35.087.719 877.192.983,0 175.438.597,0 2.017.543.860,0 0,0 30.778.701,0 923.361.034,0 146.198.830,0 1.769.775.315,0 0,0 26.998.861,0 944.960.123,0 121.494.873,0 1.552.434.487,0 0,0 23.683.211,0 947.328.444,0 100.653.647,0 1.361.784.638,0 112.495.253,0 20.774.747,0 934.863.596,0 83.098.986,0 1.194.547.928,0 155.810.599,0 18.223.462,0 911.173.095,0 68.337.982,0 1.047.849.060,0 0,0 15.985.493,0 55.949.225,0 919.165.842,0 199.818.661,0 14.022.362,0 45.572.677,0 806.285.826,0 210.335.433,0 12.300.318,0 36.900.953,0 215.255.560,0 10.789.752,0 29.671.819,0
VPL 208.644.626 5.538.879.275,0 863.317.589,0 10.669.386.956,0 893.715.506,0
VPL (Valor presente líquido)
A= 26000 - 208.644.626: 75135.5374
B= 500-553 - 5.538.879.275: - 53887.9275
C= 170000 - 863.317.589: 83668.2411
D= 95000 - 10.669.386.956: - 971938.6960
E= 80000 - 893.715.506: - 9371.5506
Taxa de retorno
Empresa A TIR = 8.7114
Ano Ano
0 -26000 CHS GCFO 0 -26000
1 4000 GC+J 1 73.589.338
2 4000 GC+J 2 104.487.053
3 4000 GC+J 3 132.908.833
4 4000 GC+J 4 159.053.083
5 4000 GC+J 5 183.102.308
6 4000 GC+J 6 205.524.391
7 4000 GC+J 7 225.573.758
8 4000 GC+J 8 244.292.465
9 4000 GC+J 9 261.511.180
10 4000 GC+J TIR 10 277.350.103 f IRR 87114 projeto não é viável
Empresa B TIR = 17.4062
Ano Ano
0 -500000 CHS GCFO 0 -500000
1 100.000 GC+J 1 34.921.495
2 120.000 GC+J