tir-van

3
Período Flujo de Fondos TIR 15.10% 0 -100 VAN $ 22.89 1 20 2 20 3 20 4 20 5 20 6 20 7 20 8 20 9 20 10 20

Upload: yaneth-cristina-morales-blas

Post on 26-Sep-2015

213 views

Category:

Documents


0 download

DESCRIPTION

ya

TRANSCRIPT

Hoja1PerodoFlujo de FondosTIR15.10%0-100VAN$ 22.891202203204205206207208209201020

Hoja2Tasa12%12%12%Proy AProy BProy CInversion-100,000.00-200,000.00-180,000.00110,000.0030,000.0050,000.00220,000.0030,000.0050,000.00320,000.0030,000.0050,000.00420,000.0030,000.0020,000.00520,000.0030,000.0020,000.00620,000.0030,000.0020,000.00720,000.0030,000.0020,000.00820,000.0030,000.0020,000.00920,000.0030,000.0020,000.001020,000.0030,000.0020,000.001120,000.0030,000.0015,000.001220,000.0030,000.0015,000.001320,000.0030,000.0015,000.001420,000.0030,000.0015,000.001520,000.0030,000.0015,000.001620,000.0025,000.0015,000.001720,000.0025,000.0015,000.001820,000.0025,000.0015,000.001920,000.0025,000.0015,000.002020,000.0025,000.0015,000.00TIR17.73%13.67%16.07%VAN$140,460.30$220,790.41$212,347.7140,460.301057980

Hoja3Inversion($8,000.00)Periodo 1$2,500.00Periodo 2$3,000.00Periodo 3$5,000.00TIR13.1773%10.3300%VAN$0.00$8,453.43$453.43