Gasco analisis financiero
Enviado por nibHormazabal • 22 de Septiembre de 2022 • Ensayo • 697 Palabras (3 Páginas) • 34 Visitas
Evaluación 3
Integrantes:
Teresa Alvarado Muñoz
Adrián Matilla Chacón
Paulina Palacios Gallardo
Alejandra Vergara Arriaza
1) Tablas de amortización:
Valor Nomi | UF | 1,500,000 | |||||||
Tasa carátula Anual | 2.9700% | ||||||||
Tasa carátula Semestral | 1.4741% | Cuota | 48,158.36 | ||||||
Fecha inicio Devengo Intere | 1 agosto 2018 | TIR | 1.4741% | ||||||
Fecha Vencimiento | 1 de agosto de 2039 | ||||||||
Cupón | Cuota Intereses | Cuota Amortización | Fecha de Vencimiento | Interés | Amortización | Valor Cuota | Saldo insoluto | TIR | |
0 | 0 | 0 | 01/08/2018 | 1,500,000 | -1,500,000 | ||||
1 | 1 | 0 | 01/02/2019 | 22,112 | 26,046.34 | 48,158.36 | 1,473,954 | 48,158.36 | |
2 | 2 | 0 | 01/08/2019 | 21,728 | 26,430.30 | 48,158.36 | 1,447,523 | 48,158.36 | |
3 | 3 | 0 | 01/02/2020 | 21,338 | 26,819.92 | 48,158.36 | 1,420,703 | 48,158.36 | |
4 | 4 | 0 | 01/08/2020 | 20,943 | 27,215.28 | 48,158.36 | 1,393,488 | 48,158.36 | |
5 | 5 | 0 | 01/02/2021 | 20,542 | 27,616.47 | 48,158.36 | 1,365,872 | 48,158.36 | |
6 | 6 | 0 | 01/08/2021 | 20,135 | 28,023.57 | 48,158.36 | 1,337,848 | 48,158.36 | |
7 | 7 | 0 | 01/02/2022 | 19,722 | 28,436.68 | 48,158.36 | 1,309,411 | 48,158.36 | |
8 | 8 | 0 | 01/08/2022 | 19,302 | 28,855.87 | 48,158.36 | 1,280,556 | 48,158.36 | |
9 | 9 | 0 | 01/02/2023 | 18,877 | 29,281.25 | 48,158.36 | 1,251,274 | 48,158.36 | |
10 | 10 | 0 | 01/08/2023 | 18,445 | 29,712.89 | 48,158.36 | 1,221,561 | 48,158.36 | |
11 | 11 | 0 | 01/02/2024 | 18,007 | 30,150.90 | 48,158.36 | 1,191,411 | 48,158.36 | |
12 | 12 | 0 | 01/08/2024 | 17,563 | 30,595.37 | 48,158.36 | 1,160,815 | 48,158.36 | |
13 | 13 | 0 | 01/02/2025 | 17,112 | 31,046.38 | 48,158.36 | 1,129,769 | 48,158.36 | |
14 | 14 | 0 | 01/08/2025 | 16,654 | 31,504.05 | 48,158.36 | 1,098,265 | 48,158.36 | |
15 | 15 | 0 | 01/02/2026 | 16,190 | 31,968.46 | 48,158.36 | 1,066,296 | 48,158.36 | |
16 | 16 | 0 | 01/08/2026 | 15,719 | 32,439.72 | 48,158.36 | 1,033,857 | 48,158.36 | |
17 | 17 | 0 | 01/02/2027 | 15,240 | 32,917.92 | 48,158.36 | 1,000,939 | 48,158.36 | |
18 | 18 | 0 | 01/08/2027 | 14,755 | 33,403.18 | 48,158.36 | 967,535 | 48,158.36 | |
19 | 19 | 0 | 01/02/2028 | 14,263 | 33,895.59 | 48,158.36 | 933,640 | 48,158.36 | |
20 | 20 | 0 | 01/08/2028 | 13,763 | 34,395.25 | 48,158.36 | 899,245 | 48,158.36 | |
21 | 21 | 1 | 01/02/2029 | 13,256 | 34,902.28 | 48,158.36 | 864,342 | 48,158.36 | |
22 | 22 | 2 | 01/08/2029 | 12,742 | 35,416.79 | 48,158.36 | 828,926 | 48,158.36 | |
23 | 23 | 3 | 01/02/2030 | 12,219 | 35,938.88 | 48,158.36 | 792,987 | 48,158.36 | |
24 | 24 | 4 | 01/08/2030 | 11,690 | 36,468.67 | 48,158.36 | 756,518 | 48,158.36 | |
25 | 25 | 5 | 01/02/2031 | 11,152 | 37,006.27 | 48,158.36 | 719,512 | 48,158.36 | |
26 | 26 | 6 | 01/08/2031 | 10,607 | 37,551.79 | 48,158.36 | 681,960 | 48,158.36 | |
27 | 27 | 7 | 01/02/2032 | 10,053 | 38,105.35 | 48,158.36 | 643,855 | 48,158.36 | |
28 | 28 | 8 | 01/08/2032 | 9,491 | 38,667.08 | 48,158.36 | 605,187 | 48,158.36 | |
29 | 29 | 9 | 01/02/2033 | 8,921 | 39,237.08 | 48,158.36 | 565,950 | 48,158.36 | |
30 | 30 | 10 | 01/08/2033 | 8,343 | 39,815.49 | 48,158.36 | 526,135 | 48,158.36 | |
31 | 31 | 11 | 01/02/2034 | 7,756 | 40,402.42 | 48,158.36 | 485,732 | 48,158.36 | |
32 | 32 | 12 | 01/08/2034 | 7,160 | 40,998.01 | 48,158.36 | 444,734 | 48,158.36 | |
33 | 33 | 13 | 01/02/2035 | 6,556 | 41,602.38 | 48,158.36 | 403,132 | 48,158.36 | |
34 | 34 | 14 | 01/08/2035 | 5,943 | 42,215.65 | 48,158.36 | 360,916 | 48,158.36 | |
35 | 35 | 15 | 01/02/2036 | 5,320 | 42,837.97 | 48,158.36 | 318,078 | 48,158.36 | |
36 | 36 | 16 | 01/08/2036 | 4,689 | 43,469.46 | 48,158.36 | 274,609 | 48,158.36 | |
37 | 37 | 17 | 01/02/2037 | 4,048 | 44,110.25 | 48,158.36 | 230,499 | 48,158.36 | |
38 | 38 | 18 | 01/08/2037 | 3,398 | 44,760.50 | 48,158.36 | 185,738 | 48,158.36 | |
39 | 39 | 19 | 01/02/2038 | 2,738 | 45,420.33 | 48,158.36 | 140,318 | 48,158.36 | |
40 | 40 | 20 | 01/08/2038 | 2,068 | 46,089.89 | 48,158.36 | 94,228 | 48,158.36 | |
41 | 41 | 21 | 01/02/2039 | 1,389 | 46,769.31 | 48,158.36 | 47,459 | 48,158.36 | |
42 | 42 | 22 | 01/08/2039 | 700 | 47,458.76 | 48,158.36 | 0 | 48,158.36 |
...