Page 70 - libro Alan Piña
P. 70
Problema base
Datos
C $ 95,000.00
i 0.015
t 3 años
n 36
A 3434.477576 anualidad
tabla de amortizacion
Saldo inicial $ 95,000.00
N. Pago fecha de pago anualidad intereses amortizacion saldo
1 21/03/2018 3434.477576 $ 1,425.00 $ 2,009.48 $ 92,990.52
2 21/04/2018 3434.477576 $ 1,394.86 $ 2,039.62 $ 90,950.90
3 21/05/2018 3434.477576 $ 1,364.26 $ 2,070.21 $ 88,880.69
4 21/06/2018 3434.477576 $ 1,333.21 $ 2,101.27 $ 86,779.42
5 21/07/2018 3434.477576 $ 1,301.69 $ 2,132.79 $ 84,646.64
6 21/08/2018 3434.477576 $ 1,269.70 $ 2,164.78 $ 82,481.86
7 21/09/2018 3434.477576 $ 1,237.23 $ 2,197.25 $ 80,284.61
8 21/10/2018 3434.477576 $ 1,204.27 $ 2,230.21 $ 78,054.40
9 21/11/2018 3434.477576 $ 1,170.82 $ 2,263.66 $ 75,790.74
10 21/12/2018 3434.477576 $ 1,136.86 $ 2,297.62 $ 73,493.12
11 21/01/2019 3434.477576 $ 1,102.40 $ 2,332.08 $ 71,161.04
12 21/02/2019 3434.477576 $ 1,067.42 $ 2,367.06 $ 68,793.98
13 21/03/2019 3434.477576 $ 1,031.91 $ 2,402.57 $ 66,391.41
14 21/04/2019 3434.477576 $ 995.87 $ 2,438.61 $ 63,952.80
15 21/05/2019 3434.477576 $ 959.29 $ 2,475.19 $ 61,477.62
16 21/06/2019 3434.477576 $ 922.16 $ 2,512.31 $ 58,965.30
17 21/07/2019 3434.477576 $ 884.48 $ 2,550.00 $ 56,415.31
18 21/08/2019 3434.477576 $ 846.23 $ 2,588.25 $ 53,827.06
19 21/09/2019 3434.477576 $ 807.41 $ 2,627.07 $ 51,199.99
20 21/10/2019 3434.477576 $ 768.00 $ 2,666.48 $ 48,533.51
21 21/11/2019 3434.477576 $ 728.00 $ 2,706.47 $ 45,827.03
22 21/12/2019 3434.477576 $ 687.41 $ 2,747.07 $ 43,079.96
23 21/01/2020 3434.477576 $ 646.20 $ 2,788.28 $ 40,291.68
24 21/02/2020 3434.477576 $ 604.38 $ 2,830.10 $ 37,461.58
25 21/03/2020 3434.477576 $ 561.92 $ 2,872.55 $ 34,589.03
26 21/04/2020 3434.477576 $ 518.84 $ 2,915.64 $ 31,673.39
27 21/05/2020 3434.477576 $ 475.10 $ 2,959.38 $ 28,714.01
28 21/06/2020 3434.477576 $ 430.71 $ 3,003.77 $ 25,710.24
29 21/07/2020 3434.477576 $ 385.65 $ 3,048.82 $ 22,661.42
30 21/08/2020 3434.477576 $ 339.92 $ 3,094.56 $ 19,566.86
31 21/09/2020 3434.477576 $ 293.50 $ 3,140.97 $ 16,425.89
32 21/10/2020 3434.477576 $ 246.39 $ 3,188.09 $ 13,237.80
33 21/11/2020 3434.477576 $ 198.57 $ 3,235.91 $ 10,001.89
34 21/12/2020 3434.477576 $ 150.03 $ 3,284.45 $ 6,717.44
35 21/01/2021 3434.477576 $ 100.76 $ 3,333.72 $ 3,383.72
36 21/02/2021 3434.477576 $ 50.76 $ 3,383.72 $ 0.00
