Page 30 - Libro clau
P. 30
Datos: Fecha de pago Anualidad Intereses Amortizacion Saldo
C= 463200 1 26/04/2018 $ 33,053.06 $ 27,020.00 $ 6,033.06 $ 457,166.94
i= 35% Capitalizable 2 26/06/2018 $ 33,053.06 $ 26,668.07 $ 6,384.98 $ 450,781.96
T= 5 Años 3 26/08/2018 $ 33,053.06 $ 26,295.61 $ 6,757.44 $ 444,024.52
n= 30 Bimestral 4 26/10/2018 $ 33,053.06 $ 25,901.43 $ 7,151.63 $ 436,872.89
i= 0.058333333 5 26/12/2018 $ 33,053.06 $ 25,484.25 $ 7,568.80 $ 429,304.09
A= 6 26/02/2019 $ 33,053.06 $ 25,042.74 $ 8,010.32 $ 421,293.77
7 26/04/2019 $ 33,053.06 $ 24,575.47 $ 8,477.59 $ 412,816.18
A= 463200*0.0583/ 1-(1+0.0583)^-30 8 26/06/2019 $ 33,053.06 $ 24,080.94 $ 8,972.11 $ 403,844.07
A= 27020 0.817473573 9 26/08/2019 $ 33,053.06 $ 23,557.57 $ 9,495.49 $ 394,348.58
A= 33053.0562656 10 26/10/2019 $ 33,053.06 $ 23,003.67 $ 10,049.39 $ 384,299.20
11 26/12/2019 $ 33,053.06 $ 22,417.45 $ 10,635.60 $ 373,663.59
12 26/02/2020 $ 33,053.06 $ 21,797.04 $ 11,256.01 $ 362,407.58
13 26/04/2020 $ 33,053.06 $ 21,140.44 $ 11,912.61 $ 350,494.97
14 26/06/2020 $ 33,053.06 $ 20,445.54 $ 12,607.52 $ 337,887.45
15 26/08/2020 $ 33,053.06 $ 19,710.10 $ 13,342.96 $ 324,544.49
16 26/10/2020 $ 33,053.06 $ 18,931.76 $ 14,121.29 $ 310,423.20
17 26/12/2020 $ 33,053.06 $ 18,108.02 $ 14,945.04 $ 295,478.16
18 26/02/2021 $ 33,053.06 $ 17,236.23 $ 15,816.83 $ 279,661.33
19 26/04/2021 $ 33,053.06 $ 16,313.58 $ 16,739.48 $ 262,921.85
20 26/06/2021 $ 33,053.06 $ 15,337.11 $ 17,715.95 $ 245,205.91
21 26/08/2021 $ 33,053.06 $ 14,303.68 $ 18,749.38 $ 226,456.53
22 26/10/2021 $ 33,053.06 $ 13,209.96 $ 19,843.09 $ 206,613.44
23 26/12/2021 $ 33,053.06 $ 12,052.45 $ 21,000.61 $ 185,612.83
24 26/02/2022 $ 33,053.06 $ 10,827.42 $ 22,225.64 $ 163,387.19
25 26/04/2022 $ 33,053.06 $ 9,530.92 $ 23,522.14 $ 139,865.05
26 26/06/2022 $ 33,053.06 $ 8,158.79 $ 24,894.26 $ 114,970.79
27 26/08/2022 $ 33,053.06 $ 6,706.63 $ 26,346.43 $ 88,624.36
28 26/10/2022 $ 33,053.06 $ 5,169.75 $ 27,883.30 $ 60,741.06
29 26/12/2022 $ 33,053.06 $ 3,543.23 $ 29,509.83 $ 31,231.23
30 26/02/2023 $ 33,053.06 $ 1,821.82 $ 31,231.23 $0.00
$ 528,391.69
HSBC es la mejor opcion
