caso 1

Upload: jesus-fuentes

Post on 06-Mar-2016

216 views

Category:

Documents


0 download

DESCRIPTION

caso sobre flujo de caja VAN

TRANSCRIPT

  • Aos 0 1 2Ventas 12000000 12000000Cost. Vestas 5700000 5700000U. Bruta 6300000 6300000Publicidad 1000000 1000000Mant. 100000 125000Dep. 1750000 1750000U. Op. 3450000 3425000G.F. 490000 379638.2UAI 2960000 3045362Imp 0 876877UN 2960000 2168485Cap. Trab. 475000Cash Flow -10500000 4235000 3918485Cash Flow Econ. -10500000 4553500 4165250P.P S/. -1,576,597 S/. -1,686,959Cash. Flow Fin. -3500000 S/. 2,658,403 S/. 2,231,527Van Econ. S/. 3,034,136.45Tir Econ. 23% 0.29Van Fin. S/. 3,850,121.64Tir Fin. 56%Ko 0.1

  • VR Monto3 4 5 TEA

    12000000 12000000 N5700000 5700000 Cuota6300000 63000001000000 1000000 Cuadro Prestamo

    160000 190000 Monto1750000 1750000 70000003390000 3360000 S/. 5,423,403.18261551.1 135197.9 S/. 3,736,444.593128449 3224802 S/. 1,931,398.891094957 1128681 S/. 0.002033492 2096121

    4750003783492 3846121 475000 P.3953500 3934000 475000 Q

    S/. -1,805,046 S/. -1,931,399 CVS/. 1,978,446 S/. 1,914,722 S/. 475,000

    Pub.Imp

  • 70000000.07

    4S/. -2,066,596.82

    Interes P.P. Cuota490000 S/. -1,576,596.82 S/. -2,066,596.82

    379638.22283304 S/. -1,686,958.59 S/. -2,066,596.82261551.1212644 S/. -1,805,045.70 S/. -2,066,596.82

    135197.92258594 S/. -1,931,398.89 S/. -2,066,596.82

    120100000

    57

    3500000-1225000 Ao 1

    -189000 Ao2

  • Aos 0 1 2 3Ventas 10200000 10200000 10200000Cost. Vestas 7800000 7800000 7800000U. Bruta 2400000 2400000 2400000Publicidad 750000 750000 750000Mant. 100000 130000 145000Dep. 650000 650000 650000U. Op. 900000 870000 855000G.F. 0 0.0 0.0UAI 900000 870000 855000Imp 0 59500 299250UN 900000 810500 555750Cap. Trab. 650000Cash Flow -4200000 900000 1460500 1205750Cash Flow Eco -4200000 900000 1460500 1205750P.P S/. 0 S/. 0 S/. 0Cash. Flow Fin -4200000 S/. 900,000 S/. 1,460,500 S/. 1,205,750Van Econ. S/. -48,412.61Tir Econ. 9.53% -0.01Van Fin. S/. -48,412.61Tir Fin. 10%Ko 0.1

  • VR Monto 04 5 TEA 0.07

    10200000 N 47800000 Cuota S/. 0.002400000

    750000 Cuadro Prestamo160000 Monto Interes650000 0 0840000 S/. 0.00 0

    0.0 S/. 0.00 0840000 S/. 0.00 0294000 S/. 0.00546000

    6500001196000 650000 P. 1701196000 650000 Q 60000

    S/. 0 CV 130S/. 1,196,000 S/. 650,000

    Pub. 1600000Imp -560000

    -245000

  • P.P. CuotaS/. 0.00 S/. 0.00S/. 0.00 S/. 0.00S/. 0.00 S/. 0.00S/. 0.00 S/. 0.00

    Ao 1Ao2

  • Aos 1 2Ventas 12600000 12600000Cost. Vestas 6300000 6300000U. Bruta 6300000 6300000Publicidad 700000 700000Mant. 100000 100000G Adm 110000 110000Dep. 920000 920000U. Op. 4470000 4470000G.F. 175000 135585.079583229UAI 4295000 4334414.92041677Imp 688500 1300324.47612503UN 3606500 3034090.44429174Cap. Trab.Cash Flow 4526500 3954090.44429174Cash Flow Econ. 4649000 4076590.44429174P.PCash. Flow Fin. 4351500 3818505.36470851Van Econ. S/. 7,506,534.66Tir Econ.Van Fin. S/. 10,743,921.01Tir Fin.Ko 0.1

    maq 4000000vehiculos 600000

    920000

  • 3 412600000 126000006300000 63000006300000 6300000700000 700000100000 100000110000 110000920000 920000

    4470000 447000093411.1147372838 48284.97235212254376588.88526272 4421715.027647881312976.66557882 1326514.508294363063612.2196839 3095200.51935351

    3983612.2196839 4015200.519353514106112.2196839 4137700.51935351

    3890201.10494662 3966915.54700139

    rentabilidad 1.2510891103

    inv 6000000inv fin 2000000

  • precio 180cv 90q 70000pubicidad 700000mant 100000g adm 110000

    M I PP cuota 0.091755722500000 738070.292 0.31079601

    1936929.71 175000 563070.292 738070.292 0.295228121334444.5 135585.08 602485.212 738070.292 738070.292

    689785.319 93411.1147 644659.177 738070.2920 48284.9724 689785.319 738070.292

    6000001288500

    688500

  • 1 2ventas 9600000 9600000CV 4800000 4800000UB 4800000 4800000Publicidad 600000 600000mantenimiento 100000 100000Depreciacion 1250000 1250000UO 2850000 2850000G Financiero 240000 186739UAI 2610000 2663261Impuestos 213500 932141.35UN 2396500 1731119.65

    cash flow 3646500 2981119.65cash flow econom 3802500 3102500cash flow financiero 3406500 2794380.65VAN ECONOM S/. 2,466,266.02VAN FINANCIERO S/. 6,685,451.95

    Rentabilidad 35%

  • 3 49600000 96000004800000 48000004800000 4800000600000 600000100000 100000

    1250000 12500002850000 2850000129217 67094

    2720783 2782906952274.05 974017.1

    1768508.95 1808888.9

    3018508.95 3058888.93102500 3102500

    2889291.95 2991794.9

    Hoja1Hoja2Hoja3Hoja4