excel clase 01

8
Ejemplo 5 Ejemp VF $ - VF VA -$ 9,107,914 VA Nper 15 Nper Tasa 7% Tasa Pago 1,000,000 Pago

Upload: michaelzambrana

Post on 09-Nov-2015

212 views

Category:

Documents


0 download

DESCRIPTION

excel

TRANSCRIPT

EJEMPLOSEjemplo 5Ejemplo 6VF0.0VF$ 25,129,022VF$ 0VA-$ 9,107,914VA0.0VA0.0Nper15Nper15Nper0Tasa7%Tasa7%Tasa0%Pago1,000,000Pago-1,000,000Pago0.0

VNAPROYECTO APROYECTO BValor Actual NetotFlujo CajatFlujo CajaVNA0-20000-20001100012002800260036003800420041175550550

Tasa Dcto20%Tasa Dcto20%

VNA-147.34VNA-366.96-$ 122.79PROYECTO AtFlujo Caja7/31/13-20002/15/1410009/6/148009/7/146002/23/152008/10/1550

Tasa Dcto20%

VNA NoPer235.28

Hoja30123456789101112131415P$ 25,000Ventas$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000$ 300,000CV unit-$ 10,000CV-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000-$ 120,000Q mensual$ 12CF0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0I-$ 300,000INV-$ 300,000CF0.0FC-$ 300,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000$ 180,000Tasa de descuento20%