FACULTAD DE ADMINISTRACIÓN
ESCUELA PROFESIONAL DE ADMINISTRACIÓN PRIVADA
ESPECIALIDAD DE MARKETING
TAREA 1
EJERCICIOS BAJO EL METODO FRANCES
PRESENTADO POR:
Mesias Chinchay, Pamela
DOCENTE:
Carpio Hinojosa, Rafael Gino
ASIGNATURA:
Mercados de Capitales y Productos
Lima, Perú
2022
ADA
EJERCICIO N°1
Hace 01 año la empresa FG tomo una deuda por 20 millones soles a la TEA de 5.75% a ser pagada en cuotas
quincenales durante 02 años. Calcular el saldo de la deuda Hoy y realizar el cronograma de pagos.
Cuota 440,908.89
Tasa Quincenal 0.2332%
n 48
VA = Deuda = S/20,000,000 Total Cuotas 21,163,626.65
VA = Deuda = S/20,000,000 Intereses S/1,163,626.65
Esquema de Amortizacion (Cronograma de Pagos)
Nro. Cuota Cuota Intereses Amortizacion Saldo
0 20,000,000
1 440,908.89 46,644.00 394,264.89 19,605,735.11
2 440,908.89 45,724.50 395,184.39 19,210,550.72 0.2332%
3 440,908.89 44,802.85 396,106.04 18,814,444.68
4 440,908.89 43,879.05 397,029.84 18,417,414.84
5 440,908.89 42,953.10 397,955.79 18,019,459.04
6 440,908.89 42,024.98 398,883.91 17,620,575.14
7 440,908.89 41,094.71 399,814.18 17,220,760.95
8 440,908.89 40,162.26 400,746.63 16,820,014.33
9 440,908.89 39,227.64 401,681.25 16,418,333.07
10 440,908.89 38,290.84 402,618.05 16,015,715.02
11 440,908.89 37,351.85 403,557.04 15,612,157.98
12 440,908.89 36,410.68 404,498.21 15,207,659.77
13 440,908.89 35,467.30 405,441.58 14,802,218.19
14 440,908.89 34,521.73 406,387.16 14,395,831.03
15 440,908.89 33,573.96 407,334.93 13,988,496.10
16 440,908.89 32,623.97 408,284.92 13,580,211.18
17 440,908.89 31,671.77 409,237.12 13,170,974.06
18 440,908.89 30,717.35 410,191.54 12,760,782.52
19 440,908.89 29,760.70 411,148.19 12,349,634.33
20 440,908.89 28,801.82 412,107.07 11,937,527.26
21 440,908.89 27,840.70 413,068.19 11,524,459.07
22 440,908.89 26,877.34 414,031.54 11,110,427.53
23 440,908.89 25,911.74 414,997.15 10,695,430.38
24 440,908.89 24,943.88 415,965.01 10,279,465.37
25 440,908.89 23,973.77 416,935.12 9,862,530.25
26 440,908.89 23,001.39 417,907.50 9,444,622.76
27 440,908.89 22,026.75 418,882.14 9,025,740.62
28 440,908.89 21,049.83 419,859.06 8,605,881.56
29 440,908.89 20,070.64 420,838.25 8,185,043.31
30 440,908.89 19,089.16 421,819.73 7,763,223.58
31 440,908.89 18,105.39 422,803.50 7,340,420.08
32 440,908.89 17,119.33 423,789.56 6,916,630.52
33 440,908.89 16,130.97 424,777.92 6,491,852.60
34 440,908.89 15,140.30 425,768.59 6,066,084.01
35 440,908.89 14,147.32 426,761.57 5,639,322.44
36 440,908.89 13,152.03 427,756.86 5,211,565.58
37 440,908.89 12,154.41 428,754.48 4,782,811.10
38 440,908.89 11,154.47 429,754.42 4,353,056.69
39 440,908.89 10,152.20 430,756.69 3,922,300.00
40 440,908.89 9,147.59 431,761.30 3,490,538.70
41 440,908.89 8,140.63 432,768.25 3,057,770.44
42 440,908.89 7,131.33 433,777.56 2,623,992.89
43 440,908.89 6,119.68 434,789.21 2,189,203.67
44 440,908.89 5,105.66 435,803.23 1,753,400.45
45 440,908.89 4,089.28 436,819.61 1,316,580.84
46 440,908.89 3,070.53 437,838.36 878,742.48
47 440,908.89 2,049.40 438,859.49 439,882.99 0.2332%
48 440,908.89 1,025.90 439,882.99 0.00
21,163,626.65 1,163,626.65 20,000,000
EJERCICIO N°2
Hace 06 meses la empresa LM tomó una deuda por la qu
ser pagada en cuotas
5,789 c/u durante 02 años y medio a la TEA de 7.96%. Calcu
grama de pagos.
realizar el cronogram
Cuota 5,789
Tasa Bimestral 1.2847%
n 15
VA = Deuda = 78,524.40 (formula)
VA = Deuda = S/78,524.40 (funcion Excel)
Esquema de Amortizacion (Cronograma de P
Nro. Cuota Cuota Intereses
0
1 5,789 1,008.80
2 5,789 947.39
3 5,789 885.19
4 5,789 822.19
5 5,789 758.38
6 5,789 693.75
7 5,789 628.29
8 5,789 561.99
9 5,789 494.84
10 5,789 426.83
11 5,789 357.94
12 5,789 288.17
13 5,789 217.50
14 5,789 145.92
15 5,789 73.43
86,835 8,310.60
mó una deuda por la que se comprometio a pagar cuotas bimestrales de
a la TEA de 7.96%. Calcular el saldo de la deuda 01 año despues de Hoy y
realizar el cronograma de pagos.
Total Cuotas 86,835
uncion Excel) Intereses 8,310.60
acion (Cronograma de Pagos)
Amortizacion Saldo
78,524.40
4,780.20 73,744.19
4,841.61 68,902.58 1.2847%
4,903.81 63,998.76
4,966.81 59,031.95
5,030.62 54,001.33
5,095.25 48,906.08
5,160.71 43,745.37
5,227.01 38,518.37
5,294.16 33,224.21
5,362.17 27,862.04
5,431.06 22,430.98
5,500.83 16,930.15
5,571.50 11,358.65
5,643.08 5,715.57 1.2847%
5,715.57 0.00
78,524.40
