evaluacion de inversiones

Post on 23-Dec-2015

218 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

DESCRIPTION

Curso de Excel Avanzado

TRANSCRIPT

EVALUACIONES DE INVERSIONESPERIODO INGRESOS EGRESOS

0 S/. 20,000.00 1 S/. 8,000.00 S/. 3,000.00 2 S/. 12,000.00 S/. 4,000.00 3 S/. 12,000.00 S/. 6,000.00 4 S/. 8,000.00 S/. 4,000.00 5 S/. 6,000.00 S/. 3,000.00

Costo de Oportunidad: 12%Factor de Riesgo: 4%Tasa de Descuento: 16%

VAN -2262.90TIR 10.56%

CONCLUSION

EVALUACIONES DE INVERSIONESFLUJO NETO

S/. -20,000.00 S/. 5,000.00 S/. 8,000.00 S/. 6,000.00 S/. 4,000.00 S/. 3,000.00

VAN>=0TIR > Tasa de Descuento

top related