A B

Ingresos anuales 190,000.00 170,000.00

Gastos anuales 167,000.00 145,000.00
Inversion Inicial 50,000.00 70,000.00
Valor de mercado 10,000.00 8,000.00
Vida util (años) 6.00 6.00
Depreciacion 6,666.67 10,333.33

Ano Ingresos

0
1 190,000.00
2 190,000.00
3 190,000.00
4 190,000.00
5 190,000.00
6 200,000.00

Ano Ingresos

0
1 170,000.00
2 170,000.00
3 170,000.00
4 170,000.00
5 170,000.00
6 178,000.00
 t 35%
trema 10%

Proyecto A
Flujo de efectivo sin Utilidad neta antes de impuestos
Egresos Depreciacion (dk) Impuesto
impuetos (UNADI)
50,000.00 -50,000.00
167,000.00 23,000.00 6,666.67 16,333.33 5,716.67
167,000.00 23,000.00 6,666.67 16,333.33 5,716.67
167,000.00 23,000.00 6,666.67 16,333.33 5,716.67
167,000.00 23,000.00 6,666.67 16,333.33 5,716.67
167,000.00 23,000.00 6,666.67 16,333.33 5,716.67
167,000.00 33,000.00 6,666.67 26,333.33 9,216.67

Proyecto B
Flujo de efectivo sin Utilidad neta antes de impuestos
Egresos Depreciacion (dk) Impuesto
impuetos (UNADI)
70,000.00 -70,000.00
145,000.00 25,000.00 10,333.33 14,666.67 5,133.33
145,000.00 25,000.00 10,333.33 14,666.67 5,133.33
145,000.00 25,000.00 10,333.33 14,666.67 5,133.33
145,000.00 25,000.00 10,333.33 14,666.67 5,133.33
145,000.00 25,000.00 10,333.33 14,666.67 5,133.33
145,000.00 33,000.00 10,333.33 22,666.67 7,933.33
 Proyecto TIR Viabilidad del proyecto
A 27% Se Recomienda
B 19% Se Recomienda

cto A
Utilidad neta despues de Flujo de Efectivo despues de
Valor Presente
impuestos (UNDI) Impuestos (FEDI)
-50,000.00 -50,000.00
10,616.67 17,283.33 15,712.12
10,616.67 17,283.33 14,283.75
10,616.67 17,283.33 12,985.22
10,616.67 17,283.33 11,804.75
10,616.67 17,283.33 10,731.59
17,116.67 23,783.33 13,425.07
28,943

cto B
Utilidad neta despues de Flujo de Efectivo despues de
Valor Presente
impuestos (UNDI) Impuestos (FEDI)
-70,000.00 -70,000.00
9,533.33 19,866.67 18,060.61
9,533.33 19,866.67 16,418.73
9,533.33 19,866.67 14,926.12
9,533.33 19,866.67 13,569.20
 9,533.33 19,866.67 12,335.64
14,733.33 25,066.67 14,149.48
19,459.78
 Vp
28,943
19,459.78

Valor presente
acumulado
-50,000.00
-34,287.88
-20,004.13
-7,018.91
4,785.84
15,517.43
28,942.50

Valor presente
acumulado
-70,000.00
-51,939.39
-35,520.66
-20,594.54
-7,025.34
5,310.30
19,459.78
 A B
Ingresos anuales 210,000.00 190,000.00
Gastos anuales 185,000.00 16,500.00
Inversion Inicial 80,000.00 78,000.00
Valor de mercado 10,000.00 7,000.00
Vida util (años) 6.00 12.00
Depreciacion 11,666.67 5,916.67

Ano Ingresos Egresos

0 80,000.00
1 210,000.00 185,000.00
2 210,000.00 185,000.00
3 210,000.00 185,000.00
4 210,000.00 185,000.00
5 210,000.00 185,000.00
6 220,000.00 185,000.00
7 210,000.00 185,000.00
8 210,000.00 185,000.00
9 210,000.00 185,000.00
10 210,000.00 185,000.00
11 210,000.00 185,000.00
12 210,000.00 265,000.00
Ano Ingresos Egresos

0 78,000.00
1 190,000.00 16,500.00
2 190,000.00 16,500.00
3 190,000.00 16,500.00
4 190,000.00 16,500.00
5 190,000.00 16,500.00
6 190,000.00 16,500.00
7 190,000.00 16,500.00
8 190,000.00 94,500.00
9 190,000.00 16,500.00
10 190,000.00 16,500.00
11 190,000.00 16,500.00
12 190,000.00 16,500.00
 t 35%
TREMa 10%

mcm 24 años

Utilidad neta antes de

Flujo de efectivo sin impuetos Depreciacion (dk) Impuesto
impuestos (UNADI)

-80,000.00
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
35,000.00 11,666.67 23,333.33 8166.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
25,000.00 11,666.67 13,333.33 4666.66666667
-55,000.00 11,666.67 -66,666.67 -23333.3333333
 Utilidad neta antes de
Flujo de efectivo sin impuetos Depreciacion (dk) Impuesto
impuestos (UNADI)

-78,000.00
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
95,500.00 5,916.67 89,583.33 31354.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
173,500.00 5,916.67 167,583.33 58654.1666667
 Maquinaria TIR Viabilidad del proyecto Vp
A 22.432% Se Recomienda 45,645
B 147.167% Se Recomienda #REF!

Utilidad neta despues de Flujo de Efectivo despues Valor presente

Valor Presente
impuestos (UNDI) de Impuestos (FEDI) acumulado

-80,000.00 -80,000.00 -80,000.00

8,666.67 20,333.33 18484.8484848485 -61,515.15
8,666.67 20,333.33 16804.4077134986 -44,710.74
8,666.67 20,333.33 15276.7342849987 -29,434.01
8,666.67 20,333.33 13887.9402590898 -15,546.07
8,666.67 20,333.33 12625.4002355362 -2,920.67
15,166.67 26,833.33 15146.7171231097 12,226.05
8,666.67 20,333.33 10434.215070691 22,660.26
8,666.67 20,333.33 9485.65006426457 32,145.91
8,666.67 20,333.33 8623.31824024052 40,769.23
8,666.67 20,333.33 7839.38021840047 48,608.61
8,666.67 20,333.33 7126.70928945498 55,735.32
-43,333.33 -31,666.67 -10089.9758941613 45,645.35
 45,645.35

Utilidad neta despues de Flujo de Efectivo despues Valor presente

Valor Presente
impuestos (UNDI) de Impuestos (FEDI) acumulado

-78,000.00 -78,000.00 -78,000.00

108,929.17 114,845.83 104405.303030303 26,405.30
108,929.17 114,845.83 94913.91184573 121,319.21
108,929.17 114,845.83 86285.3744052091 207,604.59
108,929.17 114,845.83 78441.249459281 286,045.84
108,929.17 114,845.83 71310.2267811645 357,356.07
108,929.17 114,845.83 64827.4788919678 422,183.54
108,929.17 114,845.83 58934.0717199707 481,117.62
58,229.17 64,145.83 29924.5046597035 511,042.12
108,929.17 114,845.83 48705.84439667 559,747.97
108,929.17 114,845.83 44278.0403606091 604,026.01
108,929.17 114,845.83 40252.7639641901 644,278.77
108,929.17 114,845.83 36593.4217856273 680,872.19