Analise de Investimento

Fazer download em xlsx, pdf ou txt
Fazer download em xlsx, pdf ou txt
Você está na página 1de 15

Matriz de Deciso dos Projetos

Indicadores Acquazero Flipwash


VPL X X
Payback Simples X
Payback Descontado X
TIR X
Acquazero Flipwash
VPL R$ 544,355.35 VPL
Payback Simples 2 meses e alguns dias Payback Simples
Payback Descontado 2 meses e alguns dias Payback Descontado
TIR 93.55% TIR
Flipwash
R$ 147,649.76
5 meses e alguns dias
5 meses e alguns dias
21.20%
Flipwash - Anlise de caixa
Fluxo de Caixa Fluxo de caixa
Meses Sada Entrada Nominal descontado
1 R$ 65,200.00 R$ 20,000.00 -R$ 45,200.00 -R$ 44,676.62
2 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 9,476.66
3 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 9,366.93
4 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 9,258.47
5 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 9,151.26
6 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 9,045.30
7 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,940.56
8 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,837.03
9 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,734.71
10 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,633.57
11 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,533.60
12 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,434.78
13 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,337.11
14 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,240.58
15 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,145.16
16 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 8,050.84
17 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,957.62
18 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,865.48
19 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,774.40
20 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,684.38
21 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,595.40
22 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,507.45
23 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,420.52
24 R$ 10,300.00 R$ 20,000.00 R$ 9,700.00 R$ 7,334.59

Fluxo de Caixa
R$ 9,700.00

R$ 9,700.00
R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

1 2 3 4 5 6 7 8 9 10 11 12
-R$ 45,200.00

Fluxo de Caixa
Payback Simples Payback Descontado

-R$ 45,200.00 -R$ 44,676.62 Taxa de desconto (a.m) 1.17%


-R$ 35,500.00 -R$ 35,199.95
-R$ 25,800.00 -R$ 25,833.02 VPL R$ 147,649.76
-R$ 16,100.00 -R$ 16,574.56
-R$ 6,400.00 -R$ 7,423.30 Payback Simples 5 meses e alguns dias
R$ 3,300.00 R$ 1,622.00
R$ 13,000.00 R$ 10,562.56 Payback Descontado 5 meses e alguns dias
R$ 22,700.00 R$ 19,399.59
R$ 32,400.00 R$ 28,134.30 TIR 21.20%
R$ 42,100.00 R$ 36,767.87
R$ 51,800.00 R$ 45,301.46
R$ 61,500.00 R$ 53,736.24
R$ 71,200.00 R$ 62,073.36
R$ 80,900.00 R$ 70,313.94
R$ 90,600.00 R$ 78,459.09
R$ 100,300.00 R$ 86,509.93
R$ 110,000.00 R$ 94,467.55
R$ 119,700.00 R$ 102,333.03
R$ 129,400.00 R$ 110,107.43
R$ 139,100.00 R$ 117,791.80
R$ 148,800.00 R$ 125,387.20
R$ 158,500.00 R$ 132,894.65
R$ 168,200.00 R$ 140,315.17
R$ 177,900.00 R$ 147,649.76

luxo de Caixa - Flipwash


R$ 9,700.00

R$ 9,700.00
R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

R$ 9,700.00

11 12 13 14 15 16 17 18 19 20 21 22 23 24
Fluxo de Caixa Nominal
R$ 9,700.00

23
R$ 9,700.00

24
Acquazero - Anlise de caixa
Fluxo de Caixa Fluxo de caixa
Meses Sada Entrada Nominal descontado
1 R$ 91,000.00 R$ 60,000.00 -R$ 31,000.00 -R$ 30,641.04
2 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 28,332.29
3 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 28,004.22
4 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 27,679.96
5 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 27,359.44
6 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 27,042.64
7 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 26,729.51
8 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 26,420.00
9 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 26,114.07
10 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 25,811.69
11 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 25,512.81
12 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 25,217.39
13 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 24,925.39
14 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 24,636.77
15 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 24,351.50
16 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 24,069.53
17 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 23,790.82
18 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 23,515.34
19 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 23,243.05
20 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 22,973.91
21 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 22,707.89
22 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 22,444.95
23 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 22,185.05
24 R$ 31,000.00 R$ 60,000.00 R$ 29,000.00 R$ 21,928.17

Fluxo de Caixa
R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00
R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

1 2 3 4 5 6 7 8 9 10 11 12
1 2 3 4 5 6 7 8 9 10 11 12

-R$ 31,000.00

Fluxo de Ca
Payback Simples Payback Descontado

-R$ 31,000.00 -R$ 30,641.04 Taxa de desconto (a.m) 1.17%


-R$ 2,000.00 -R$ 2,308.75
R$ 27,000.00 R$ 25,695.47 VPL R$ 544,355.35
R$ 56,000.00 R$ 53,375.43
R$ 85,000.00 R$ 80,734.87 Payback Simples 2 meses e alguns dias
R$ 114,000.00 R$ 107,777.51
R$ 143,000.00 R$ 134,507.01 Payback Descontado 2 meses e alguns dias
R$ 172,000.00 R$ 160,927.01
R$ 201,000.00 R$ 187,041.08 TIR 93.55%
R$ 230,000.00 R$ 212,852.78
R$ 259,000.00 R$ 238,365.59
R$ 288,000.00 R$ 263,582.98
R$ 317,000.00 R$ 288,508.37
R$ 346,000.00 R$ 313,145.15
R$ 375,000.00 R$ 337,496.64
R$ 404,000.00 R$ 361,566.17
R$ 433,000.00 R$ 385,356.99
R$ 462,000.00 R$ 408,872.33
R$ 491,000.00 R$ 432,115.38
R$ 520,000.00 R$ 455,089.29
R$ 549,000.00 R$ 477,797.18
R$ 578,000.00 R$ 500,242.13
R$ 607,000.00 R$ 522,427.18
R$ 636,000.00 R$ 544,355.35

Fluxo de Caixa - Acquazero


R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00
R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

R$ 29,000.00

11 12 13 14 15 16 17 18 19 20 21 22 23
11 12 13 14 15 16 17 18 19 20 21 22 23

Fluxo de Caixa Nominal


R$ 29,000.00

23
R$ 29,000.00

24
23 24

Você também pode gostar