exel de van, tir y trema

INTERES
MONTO PAGARE
20,000
50,000
40,000
50,000

7
PLAZO
4
3
1

CONTADO

inv. Inicial.

31/08/2014
INTERES
MONTO PAGARE
1,000
3,000
5,000
8,000

3
PLAZO
1
2
3

VALORPRESENTE
15,257.90
40,814.89
37,383.18
50,000.00
143,455.98
30,000
113,455.98
148,717.64

VALOR PRESENTE
970.87
2,827.79
4,575.71

8,374.37

374.37
deseb. Inicial

inv. Inicial.-8000

INTERES
MONTO PAGARE
1,000
3,000
5,000
8,000

363.47

5
PLAZO
1
2
3

VALOR PRESENTE
952.38
2,721.09
4,319.19
-7.34

deseb. Inicial

-8000

-6.99

5%

(C$ 6.99)7,992.66

interes
año
1
2
3
4
5
6
7
8
9
10
des. Inicial

13.5
flujo de caja
14,000
11,000
10,000
10,000
10,000
9,100
9,000
9,000
4,500
100,000

12,334.80
8,538.886,839.31
6,025.83
5,309.10
4,256.63
3,709.13
3,267.95
1,439.63
28,186.52
79,907.77
-79000
907.77

-4000000
1500,000
1500,000

interes
año
1
2
3
4
5

13
flujo de caja
-5,0004,500
5,500
4,500
130,000

des. Inicial

0/09/14
interes
año
1
2
3
4
5

CALCULO
27.00
flujo de caja
1500,000
1500,000
1500,000
1500,000
2000,000

1500,000
1500,000
2000,000CALCULO TIR 27.306142%
des. Inicial
VIA FORMULA

27.30980

25348.2099
81819.9749
0.30980466

interes
año
1
2
3
4
5
7
8

des. Inicial

27.31
flujo de caja
1,000
1,000
1,0001,000
5,500

-4,424.78
3,524.16
3,811.78
2,759.93
70,558.79
0.00
0.00
0.00
0.00
0.00
76,229.88
-80000
-3,770.12

1181,102.36
930,001.86
732,284.93
576,602.31
605,356.75CALCULO DEL VAN
interes
año
1
2
3
4
5

28.00
flujo de caja
1500,000
1500,000
1500,000
1500,000
2000,000

1171,875.00
915,527.34
715,255.74
558,793.54
582,076.61

0.00
0.00
0.000.00
0.00
4025,348.21
-4000000
25,348.21

0.00
0.00
0.00
0.00
0.00
3943,528.23
-4000000
-56,471.77

des. Inicial

1171875
785.51
617.02
484.68
380.72
1,644.81
0.00
0.00
0.00...