0% ont trouvé ce document utile (0 vote)
16 vues4 pages

Trabajo Final

Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
0% ont trouvé ce document utile (0 vote)
16 vues4 pages

Trabajo Final

Copyright
© © All Rights Reserved
Nous prenons très au sérieux les droits relatifs au contenu. Si vous pensez qu’il s’agit de votre contenu, signalez une atteinte au droit d’auteur ici.
Formats disponibles
Téléchargez aux formats XLSX, PDF, TXT ou lisez en ligne sur Scribd
Vous êtes sur la page 1/ 4

Préstamo S/ 30,100.

00
Plazo 24
Tasa de interés 19.00%
TCEA 20.5% 1.566133705%
SEG. DESG 0.055%
F DESMB. 4/22/2021

DIAS FECHA Nro AMORTIZACIÓN INTERES


28 5/20/2021 1 S/ 1,088.82 S/ 410.01
31 6/20/2021 2 S/ 1,059.96 S/ 437.84
30 7/20/2021 3 S/ 1,091.80 S/ 408.14
31 8/20/2021 4 S/ 1,093.65 S/ 405.36
31 9/20/2021 5 S/ 1,110.78 S/ 388.86
30 10/20/2021 6 S/ 1,140.27 S/ 360.00
31 11/20/2021 7 S/ 1,146.03 S/ 354.89
30 12/20/2021 8 S/ 1,175.36 S/ 326.62
31 1/20/2022 9 S/ 1,182.39 S/ 319.85
31 2/20/2022 10 S/ 1,200.90 S/ 302.01
28 3/20/2022 11 S/ 1,248.40 S/ 256.22
31 4/20/2022 12 S/ 1,239.26 S/ 265.04
30 5/20/2022 13 S/ 1,266.97 S/ 238.33
31 6/20/2022 14 S/ 1,278.51 S/ 227.22
30 7/20/2022 15 S/ 1,305.54 S/ 201.17
31 8/20/2022 16 S/ 1,318.98 S/ 188.22
31 9/20/2022 17 S/ 1,339.63 S/ 168.31
30 10/20/2022 18 S/ 1,365.60 S/ 143.28
31 11/20/2022 19 S/ 1,382.00 S/ 127.48
30 12/20/2022 20 S/ 1,407.23 S/ 103.16
31 1/20/2023 21 S/ 1,425.68 S/ 85.39
31 2/20/2023 22 S/ 1,448.00 S/ 63.87
28 3/20/2023 23 S/ 1,474.93 S/ 37.93
31 4/20/2023 24 S/ 1,493.78 S/ 19.76
S/ 30,284.47 S/ 5,838.97
DIAS TASA
28 1.36%
29 1.41%
30 1.46%
31 1.51%

SEG. DESG CUOTA TOTAL SALDO CAPITAL


S/ 15.45 S/ 1,514.28 S/ 30,100.00
S/ 16.49 S/ 1,514.28 S/ 29,011.18
S/ 14.35 S/ 1,514.28 S/ 27,951.22
S/ 15.27 S/ 1,514.28 S/ 26,859.42
S/ 14.64 S/ 1,514.28 S/ 25,765.77
S/ 14.01 S/ 1,514.28 S/ 24,654.99
S/ 13.36 S/ 1,514.28 S/ 23,514.72
S/ 12.30 S/ 1,514.28 S/ 22,368.69
S/ 12.04 S/ 1,514.28 S/ 21,193.33
S/ 11.37 S/ 1,514.28 S/ 20,010.95
S/ 9.66 S/ 1,514.28 S/ 18,810.04
S/ 9.98 S/ 1,514.28 S/ 17,561.64
S/ 8.98 S/ 1,514.28 S/ 16,322.38
S/ 8.56 S/ 1,514.28 S/ 15,055.41
S/ 7.58 S/ 1,514.28 S/ 13,776.90
S/ 7.09 S/ 1,514.28 S/ 12,471.36
S/ 6.34 S/ 1,514.28 S/ 11,152.38
S/ 5.40 S/ 1,514.28 S/ 9,812.75
S/ 4.80 S/ 1,514.28 S/ 8,447.15
S/ 3.89 S/ 1,514.28 S/ 7,065.15
S/ 3.22 S/ 1,514.28 S/ 5,657.92
S/ 2.41 S/ 1,514.28 S/ 4,232.24
S/ 1.43 S/ 1,514.28 S/ 2,784.24
S/ 0.74 S/ 1,514.28 S/ 1,309.31
S/ 219.35 S/ 36,342.79
Préstamo 30100 F. DESEMB
Plazo 24 4/22/2021
Tasa de interés 19.00% F VENCIM
TCEA 20.50% 5/20/2021
Tasa desgrmn 0.055% CUOTA 1507.90

VENCIMIENTO PERIODO SALDO INICIAL CUOTA INTERES AMORTIZACIÓN


4/22/2021 0
5/20/2021 1 30100.00 1507.90 410.01 1082.43
6/20/2021 2 29017.57 1507.90 437.94 1053.47
7/20/2021 3 27964.10 1507.90 408.32 1084.19
8/20/2021 4 26879.91 1507.90 405.67 1086.95
9/20/2021 5 25792.96 1507.90 389.27 1103.97
10/20/2021 6 24688.99 1507.90 360.50 1133.82
11/20/2021 7 23555.18 1507.90 355.50 1139.01
12/20/2021 8 22416.17 1507.90 327.31 1168.25
1/20/2022 9 21247.91 1507.90 320.67 1175.14
2/20/2022 10 20072.77 1507.90 302.94 1193.55
3/20/2022 11 18879.22 1507.90 257.17 1241.04
4/20/2022 12 17638.18 1507.90 266.20 1231.67
5/20/2022 13 16406.51 1507.90 239.56 1259.31
6/20/2022 14 15147.20 1507.90 228.60 1270.68
7/20/2022 15 13876.52 1507.90 202.62 1297.64
8/20/2022 16 12578.87 1507.90 189.84 1310.91
9/20/2022 17 11267.97 1507.90 170.06 1331.43
10/20/2022 18 9936.53 1507.90 145.09 1357.34
11/20/2022 19 8579.19 1507.90 129.48 1373.54
12/20/2022 20 7205.65 1507.90 105.21 1398.72
1/20/2023 21 5806.93 1507.90 87.64 1416.96
2/20/2023 22 4389.98 1507.90 66.25 1439.15
3/20/2023 23 2950.83 1507.90 40.20 1466.19
4/20/2023 24 1484.65 1507.90 22.41 1484.65
36189.49 5868.46 30100.00

COMPROBACIÓN 36189.49
TCEA
20.0769%

FLUJO DE CAJA 20.08%

SEGURO SALDO CAP FINAL FLUJO DE CAJA


30100.00 30100
15.45 29017.57 -1507.90
16.49 27964.10 -1507.90
15.38 26879.91 -1507.90
15.28 25792.96 -1507.90
14.66 24688.99 -1507.90
13.58 23555.18 -1507.90
13.39 22416.17 -1507.90
12.33 21247.91 -1507.90
12.08 20072.77 -1507.90
11.41 18879.22 -1507.90
9.69 17638.18 -1507.90
10.02 16406.51 -1507.90
9.02 15147.20 -1507.90
8.61 13876.52 -1507.90
7.63 12578.87 -1507.90
7.15 11267.97 -1507.90
6.40 9936.53 -1507.90
5.47 8579.19 -1507.90
4.88 7205.65 -1507.90
3.96 5806.93 -1507.90
3.30 4389.98 -1507.90
2.49 2950.83 -1507.90
1.51 1484.65 -1507.90
0.84 0.00 -1507.90
221.02873654 -36189.489002081

Vous aimerez peut-être aussi