Page 21 - libro Alan Piña

HSBC Problema base
Datos
c $ 463,200.00 $27,020.00
t 5 años 0.8174735729
i 0.05833333333
n 30
A $ 33,053.06

Tabla de amortizacion
n. pago fecha de pago anualidad interes amortizacion saldo
1 4/23/2018 $ 33,053.06 $ 27,020.00 $ 6,033.06 $ 457,166.94
2 6/23/2018 $ 33,053.06 $ 26,668.07 $ 6,384.98 $ 450,781.96
3 8/23/2018 $ 33,053.06 $ 26,295.61 $ 6,757.44 $ 444,024.52
4 10/23/2018 $ 33,053.06 $ 25,901.43 $ 7,151.63 $ 436,872.89
5 12/23/2018 $ 33,053.06 $ 25,484.25 $ 7,568.80 $ 429,304.09
6 2/23/2019 $ 33,053.06 $ 25,042.74 $ 8,010.32 $ 421,293.77
7 4/23/2019 $ 33,053.06 $ 24,575.47 $ 8,477.59 $ 412,816.18
8 6/23/2019 $ 33,053.06 $ 24,080.94 $ 8,972.11 $ 403,844.07
9 8/23/2019 $ 33,053.06 $ 23,557.57 $ 9,495.49 $ 394,348.58
10 10/23/2019 $ 33,053.06 $ 23,003.67 $10,049.39 $ 384,299.20
11 12/23/2019 $ 33,053.06 $ 22,417.45 $10,635.60 $ 373,663.59
12 2/23/2020 $ 33,053.06 $ 21,797.04 $11,256.01 $ 362,407.58
13 4/23/2020 $ 33,053.06 $ 21,140.44 $11,912.61 $ 350,494.97
14 6/23/2020 $ 33,053.06 $ 20,445.54 $12,607.52 $ 337,887.45
15 8/23/2020 $ 33,053.06 $ 19,710.10 $13,342.96 $ 324,544.49
16 10/23/2020 $ 33,053.06 $ 18,931.76 $14,121.29 $ 310,423.20
17 12/23/2020 $ 33,053.06 $ 18,108.02 $14,945.04 $ 295,478.16
18 2/23/2021 $ 33,053.06 $ 17,236.23 $15,816.83 $ 279,661.33
19 4/23/2021 $ 33,053.06 $ 16,313.58 $16,739.48 $ 262,921.85
20 6/23/2021 $ 33,053.06 $15,337.11 $17,715.95 $ 245,205.91
21 8/23/2021 $ 33,053.06 $ 14,303.68 $18,749.38 $ 226,456.53
22 10/23/2021 $ 33,053.06 $ 13,209.96 $19,843.09 $ 206,613.44