Finanzas Corporativas II
Enviado por Homer Huaman flores • 13 de Diciembre de 2023 • Tareas • 726 Palabras (3 Páginas) • 21 Visitas
“Año de la unidad, la paz y el desarrollo”
UNIVERSIDAD NACIONAL “SAN LUIS GONZAGA”
FACULTAD DE ADMINISTRACIÓN
[pic 1]
Estudiantes:
ALMORA GUTIERREZ, PAMELA
HUAMAN FLORES ,HOMER
MESA PILLACA,NELI
ASIGNATURA:
Finanzas Corporativas II
DOCENTE :
Flores Avalos Santos
SECCION
IV -C
ICA-2023
TAREA 01: PRESTAMOS
1.- Una empresa industrial ha recibido un préstamo de 250 000 soles para financiar la compra de maquinaria. El período del financiamiento es de 6 años y la tasa de interés nominal anual es 24 %, siendo las cuotas bimestrales vencidas. (UTILIZAR ECUACIONES Y/O FUNCIONES FINANCIERAS PARA CADA PREGUNTA).
DATOS | conv. Bimestre | ||
P | 250000 | soles | 250000 |
Tna | 24% | anual | 0.03650232561 |
N | 6 | años | 36 |
C | 12588.52 | mes |
|
M=1
RESPUESTAS UTILIZANDO FUNCION FINANCIERA
PAGO
PAGO.PRINC.ENTRE
PAGO.INT.ENTRE
Cuota =12588.52
MESES | NPR | CUOTA | INTERES | AMORTIZACION | SALDO |
0 | 0 |
|
|
| 250000 |
1 | 1 | S/12,588.52 | S/9,125.58 | S/3,462.94 | S/246,537.06 |
2 | 2 | S/12,588.52 | S/8,999.18 | S/3,589.34 | S/242,947.72 |
3 | 3 | S/12,588.52 | S/8,868.16 | S/3,720.36 | S/239,227.36 |
4 | 4 | S/12,588.52 | S/8,732.36 | S/3,856.16 | S/235,371.20 |
5 | 5 | S/12,588.52 | S/8,591.60 | S/3,996.92 | S/231,374.28 |
6 | 6 | S/12,588.52 | S/8,445.70 | S/4,142.82 | S/227,231.46 |
7 | 7 | S/12,588.52 | S/8,294.48 | S/4,294.04 | S/222,937.42 |
8 | 8 | S/12,588.52 | S/8,137.73 | S/4,450.78 | S/218,486.64 |
9 | 9 | S/12,588.52 | S/7,975.27 | S/4,613.25 | S/213,873.39 |
10 | 10 | S/12,588.52 | S/7,806.88 | S/4,781.64 | S/209,091.75 |
11 | 11 | S/12,588.52 | S/7,632.34 | S/4,956.18 | S/204,135.56 |
12 | 12 | S/12,588.52 | S/7,451.42 | S/5,137.09 | S/198,998.47 |
13 | 13 | S/12,588.52 | S/7,263.91 | S/5,324.61 | S/193,673.86 |
14 | 14 | S/12,588.52 | S/7,069.55 | S/5,518.97 | S/188,154.89 |
15 | 15 | S/12,588.52 | S/6,868.09 | S/5,720.43 | S/182,434.46 |
16 | 16 | S/12,588.52 | S/6,659.28 | S/5,929.24 | S/176,505.23 |
17 | 17 | S/12,588.52 | S/6,442.85 | S/6,145.67 | S/170,359.56 |
18 | 18 | S/12,588.52 | S/6,218.52 | S/6,370.00 | S/163,989.56 |
19 | 19 | S/12,588.52 | S/5,986.00 | S/6,602.52 | S/157,387.05 |
20 | 20 | S/12,588.52 | S/5,744.99 | S/6,843.52 | S/150,543.52 |
21 | 21 | S/12,588.52 | S/5,495.19 | S/7,093.33 | S/143,450.19 |
22 | 22 | S/12,588.52 | S/5,236.27 | S/7,352.25 | S/136,097.94 |
23 | 23 | S/12,588.52 | S/4,967.89 | S/7,620.63 | S/128,477.31 |
24 | 24 | S/12,588.52 | S/4,689.72 | S/7,898.80 | S/120,578.52 |
25 | 25 | S/12,588.52 | S/4,401.40 | S/8,187.12 | S/112,391.40 |
26 | 26 | S/12,588.52 | S/4,102.55 | S/8,485.97 | S/103,905.43 |
27 | 27 | S/12,588.52 | S/3,792.79 | S/8,795.73 | S/95,109.70 |
28 | 28 | S/12,588.52 | S/3,471.73 | S/9,116.79 | S/85,992.91 |
29 | 29 | S/12,588.52 | S/3,138.94 | S/9,449.58 | S/76,543.33 |
30 | 30 | S/12,588.52 | S/2,794.01 | S/9,794.51 | S/66,748.82 |
31 | 31 | S/12,588.52 | S/2,436.49 | S/10,152.03 | S/56,596.79 |
32 | 32 | S/12,588.52 | S/2,065.91 | S/10,522.60 | S/46,074.19 |
33 | 33 | S/12,588.52 | S/1,681.82 | S/10,906.70 | S/35,167.49 |
34 | 34 | S/12,588.52 | S/1,283.70 | S/11,304.82 | S/23,862.66 |
35 | 35 | S/12,588.52 | S/871.04 | S/11,717.47 | S/12,145.19 |
36 | 36 | S/12,588.52 | S/443.33 | S/12,145.19 | S/0.00 |
TOTAL |
| S/453,186.63 | S/203,186.63 | S/250,000.00 |
|
...