Page 19 - libro Alan Piña

BANCOMER problema base
Datos
c $ 463,200.00 $48,636.00
i 0.105 0.8642454359
T 5 años
n 20
A $ 56,275.68

tabla de amortizacion
n. pago fecha de pago anualidad interes amortisacion saldo
1 5/23/2018 $ 56,275.68 $ 48,636.00 $ 7,639.68 $ 455,560.32
2 8/23/2018 $ 56,275.68 $ 47,833.83 $ 8,441.85 $ 447,118.47
3 11/23/2018 $ 56,275.68 $ 46,947.44 $ 9,328.24 $ 437,790.23
4 2/23/2019 $ 56,275.68 $ 45,967.97 $10,307.71 $ 427,482.53
5 5/23/2019 $ 56,275.68 $ 44,885.67 $11,390.02 $ 416,092.51
6 8/23/2019 $ 56,275.68 $ 43,689.71 $12,585.97 $ 403,506.54
7 11/23/2019 $ 56,275.68 $ 42,368.19 $13,907.49 $ 389,599.05
8 2/23/2020 $ 56,275.68 $ 40,907.90 $15,367.78 $ 374,231.27
9 5/23/2020 $ 56,275.68 $ 39,294.28 $16,981.40 $ 357,249.87
10 8/23/2020 $ 56,275.68 $37,511.24 $18,764.44 $ 338,485.43
11 11/23/2020 $ 56,275.68 $ 35,540.97 $20,734.71 $ 317,750.72
12 2/23/2021 $ 56,275.68 $ 33,363.83 $22,911.86 $ 294,838.86
13 5/23/2021 $ 56,275.68 $ 30,958.08 $25,317.60 $ 269,521.26
14 8/23/2021 $ 56,275.68 $ 28,299.73 $27,975.95 $ 241,545.32
15 11/23/2021 $ 56,275.68 $ 25,362.26 $30,913.42 $ 210,631.89
16 2/23/2022 $ 56,275.68 $22,116.35 $34,159.33 $ 176,472.56
17 5/23/2022 $ 56,275.68 $ 18,529.62 $37,746.06 $ 138,726.50
18 8/23/2022 $ 56,275.68 $ 14,566.28 $41,709.40 $ 97,017.10
19 11/23/2022 $ 56,275.68 $ 10,186.80 $46,088.88 $ 50,928.22
20 2/23/2023 $ 56,275.68 $ 5,347.46 $50,928.22 $0.00
$ 662,313.61