HERRAMIENTAS FINANCIERAS

UNIVERSIDAD CATOLICA DE COLOMBIA

ESPECIALIZACION ADMINISTRACION FINANCIERA

MODULO: HERRAMIENTAS FINANCIERAS II

PROFESOR: HERNAN BOJACA M.

MARGEE GARCIA G.

YANSY GONZALEZ F.

HUMBERTO RODRIGUEZ S.

BOGOTA, AGOSTO 17 DE 2009

EJERCICIO N. 1

Un concesionario de vehiculos ofrece diferentes planes de pago para su ultimo vehiculo importado que tiene un precio de $80.000.000.

PLAN A: Cuota inicial del 20% y saldo a 5 años en cuotas mensuales iguales a una tasa de interés del 26,5% NM

PLAN B: Cuota inicial 25% y saldo a 4 años, en cuotas bimestrales iguales a una tasa de interés del 24,5% E.A

PLAN C: Cuota inicial del 20% y saldo a 3 años en cuotas trimestrales iguales a una tasa de interés del 23,75% N.T

Cual de los 3 planes de financiación le conviene al comprador de un vehículo

VP PLAZO TASA VP PLAZO TASA VP PLAZO TASA

64.000.000 5 26,50% NM 60.000.000 4 24,50% E.A 64.000.000 3 23,75% N.T

NP TASA P.M PAGO PAGO TOTAL INTERES NP TASA P.BM PAGO PAGO TOTAL INTERES NP TASA P.T PAGO PAGO TOTAL INTERES

60 2,21% $ 1.935.180,10 $ 116.110.806,27 52.110.806 24 3,72% $ 3.823.122,84 $ 91.754.948,25 31.754.948 12 5,94% $ 7.607.594,96 $ 91.291.139,55 27.291.140

PLAN A TABLA DE AMORTIZACION PLAN B TABLA DE AMORTIZACION PLAN C TABLA DE AMORTIZACION

CON CUOTAS IGUALES CON CUOTAS IGUALES CON CUOTAS IGUALES

N. CUOTAS SALDO CAPITAL INTERESES VR. CUOTA ABONO A CAPITAL N. CUOTAS SALDO CAPITAL INTERESES VR. CUOTA ABONO A CAPITAL N. CUOTAS SALDO CAPITAL INTERESES VR. CUOTA ABONO A CAPITAL

0 64.000.000 0 60.000.000 0 64.000.000

1 63.478.153,23 1.413.333 $ 1.935.180,10 521.846,77 1 58.408.741,09 2.231.864 $ 3.823.122,84 1.591.258,91 1 60.192.405,04 3.800.000 $ 7.607.594,96 3.807.594,96

2 62.944.782,34 1.401.809 $ 1.935.180,10 533.370,89 2 56.758.290,97 2.172.673 $ 3.823.122,84 1.650.450,13 2 56.158.734,12 3.573.924 $ 7.607.594,96 4.033.670,91

3 62.399.632,85 1.390.031 $ 1.935.180,10 545.149,49 3 55.046.447,84 2.111.280 $ 3.823.122,84 1.711.843,13 3 51.885.564,00 3.334.425 $ 7.607.594,96 4.273.170,12

4 61.842.444,63 1.377.992 $ 1.935.180,10 557.188,21 4 53.270.928,02 2.047.603 $ 3.823.122,84 1.775.519,81 4 47.358.674,40 3.080.705 $ 7.607.594,96 4.526.889,60

5 61.272.951,85 1.365.687 $ 1.935.180,10 569.492,79 5 51.429.362,90 1.981.558 $ 3.823.122,84 1.841.565,12 5 42.563.000,73 2.811.921 $ 7.607.594,96 4.795.673,67

6 60.690.882,76 1.353.111 $ 1.935.180,10 582.069,08 6 49.519.295,73 1.913.056 $ 3.823.122,84 1.910.067,17 6 37.482.583,93 2.527.178 $ 7.607.594,96 5.080.416,79

7 60.095.959,65 1.340.257 $ 1.935.180,10 594.923,11 7 47.538.178,39 1.842.006 $ 3.823.122,84 1.981.117,34 7 32.100.517,39 2.225.528 $ 7.607.594,96 5.382.066,54

8 59.487.898,66 1.327.119 $ 1.935.180,10 608.061,00 8 45.483.367,98 1.768.312 $ 3.823.122,84 2.054.810,41 8 26.398.890,65 1.905.968 $ 7.607.594,96 5.701.626,74

9 58.866.409,65 1.313.691 $ 1.935.180,10 621.489,01 9 43.352.123,29 1.691.878 $ 3.823.122,84 2.131.244,70 9 20.358.729,82 1.567.434 $ 7.607.594,96 6.040.160,83

10 58.231.196,09 1.299.967 $ 1.935.180,10 635.213,56 10 41.141.601,12 1.612.601 $ 3.823.122,84 2.210.522,17 10 13.959.934,44 1.208.800 $ 7.607.594,96 6.398.795,38

11 57.581.954,90 1.285.939 $ 1.935.180,10 649.241,19 11 38.848.852,54 1.530.374 $ 3.823.122,84 2.292.748,58 11 7.181.210,58 828.871 $ 7.607.594,96 6.778.723,86

12 56.918.376,30 1.271.602 $ 1.935.180,10 663.578,60 12 36.470.818,91 1.445.089 $ 3.823.122,84 2.378.033,63 12 (0,00) 426.384 $ 7.607.594,96 7.181.210,58

13 56.240.143,67 1.256.947 $ 1.935.180,10 678.232,63 13 34.004.327,83 1.356.632 $ 3.823.122,84 2.466.491,08 $ 27.291.139,55 $ 91.291.139,55 $ 64.000.000,00

14 55.546.933,41 1.241.970 $ 1.935.180,10 693.210,27 14 31.446.088,87 1.264.884 $ 3.823.122,84 2.558.238,96

15 54.838.414,75 1.226.661 $ 1.935.180,10 708.518,66 15 28.792.689,22 1.169.723 $ 3.823.122,84 2.653.399,65

16 54.114.249,64 1.211.015 $ 1.935.180,10 724.165,11 16 26.040.589,12 1.071.023 $ 3.823.122,84 2.752.100,10

17 53.374.092,54 1.195.023 $ 1.935.180,10 740.157,09 17 23.186.117,14 968.651 $ 3.823.122,84 2.854.471,98

18 52.617.590,32 1.178.678 $ 1.935.180,10 756.502,23 18 20.225.465,28 862.471 $ 3.823.122,84 2.960.651,87

19 51.844.382,00 1.161.972 $ 1.935.180,10 773.208,32 19 17.154.683,88 752.341 $ 3.823.122,84 3.070.781,40

20 51.054.098,66 1.144.897 $ 1.935.180,10 790.283,34 20 13.969.676,37 638.115 $ 3.823.122,84 3.185.007,51

21 50.246.363,24 1.127.445 $ 1.935.180,10 807.735,43 21 10.666.193,81 519.640 $ 3.823.122,84 3.303.482,56

22 49.420.790,32 1.109.607 $ 1.935.180,10 825.572,92 22 7.239.829,19 396.758 $ 3.823.122,84 3.426.364,62

23 48.576.986,00 1.091.376 $ 1.935.180,10 843.804,32 23 3.686.011,57 269.305 $ 3.823.122,84 3.553.817,62

24 47.714.547,67 1.072.742 $ 1.935.180,10 862.438,33 24 0,00 137.111 $ 3.823.122,84 3.686.011,57

25 46.833.063,83 1.053.696 $ 1.935.180,10 881.483,84 31.754.948 91.754.948 60.000.000

26 45.932.113,88 1.034.230 $ 1.935.180,10 900.949,95

27 45.011.267,96 1.014.334 $ 1.935.180,10 920.845,92

28 44.070.086,69 993.999 $ 1.935.180,10 941.181,27

29 43.108.121,00 973.214 $ 1.935.180,10 961.965,69

30 42.124.911,90 951.971 $ 1.935.180,10 983.209,10

31 41.119.990,27 930.258 $ 1.935.180,10 1.004.921,63

32 40.092.876,61 908.066 $ 1.935.180,10 1.027.113,65

33 39.043.080,87 885.384 $ 1.935.180,10 1.049.795,75

34 37.970.102,13 862.201 $ 1.935.180,10 1.072.978,74

35 36.873.428,45 838.506 $ 1.935.180,10 1.096.673,68

36 35.752.536,56 814.288 $ 1.935.180,10 1.120.891,89

37 34.606.891,64 789.535 $ 1.935.180,10 1.145.644,92

38 33.435.947,05 764.236 $ 1.935.180,10 1.170.944,58

39 32.239.144,11 738.377 $ 1.935.180,10 1.196.802,94

40 31.015.911,78 711.948 $ 1.935.180,10 1.223.232,34

41 29.765.666,39 684.935 $ 1.935.180,10 1.250.245,39

42 28.487.811,42 657.325 $ 1.935.180,10 1.277.854,97

43 27.181.737,15 629.106 $ 1.935.180,10 1.306.074,27

44 25.846.820,41 600.263 $ 1.935.180,10 1.334.916,74

45 24.482.424,25 570.784 $ 1.935.180,10 1.364.396,15

46 23.087.897,68 540.654 $ 1.935.180,10 1.394.526,57

47 21.662.575,32 509.858 $ 1.935.180,10 1.425.322,36

48 20.205.777,09 478.382 $ 1.935.180,10 1.456.798,23

49 18.716.807,89 446.211 $ 1.935.180,10 1.488.969,19

50 17.194.957,30 413.330 $ 1.935.180,10 1.521.850,60

51 15.639.499,16 379.722 $ 1.935.180,10 1.555.458,13

52 14.049.691,33 345.372 $ 1.935.180,10 1.589.807,83

53 12.424.775,25 310.264 $ 1.935.180,10 1.624.916,09

54 10.763.975,59 274.380 $ 1.935.180,10 1.660.799,65

55 9.066.499,95 237.704 $ 1.935.180,10 1.697.475,64

56 7.331.538,39 200.219 $ 1.935.180,10 1.734.961,56

57 5.558.263,09 161.905 $ 1.935.180,10 1.773.275,30

58 3.745.827,96 122.745 $ 1.935.180,10 1.812.435,13

59 1.893.368,22 82.720 $ 1.935.180,10 1.852.459,74

60 (0,00) 41.812 $ 1.935.180,10 1.893.368,22

$ 52.110.806,27 $ 116.110.806,27 $ 64.000.000,00

CUOTA INICIAL 16.000.000,00 CUOTA INICIAL 20.000.000 CUOTA INICIAL 16.000.000

TOTAL CUOTAS $ 116.110.806,27 TOTAL CUOTAS 91.754.948 TOTAL CUOTAS $ 91.291.140

PAGO TOTAL 132.110.806,27 PAGO

...