Page 24 - Libro clau
P. 24

Fecha de Pago   Anualidad             Interes        Amortizacion                  Saldo
 1  20/03/2018 $             3,434.48 $     1,425.00 $            2,009.48 $            92,990.52

 DATOS:  2  20/04/2018 $             3,434.48 $     1,394.86 $            2,039.62 $            90,950.90

 C=  95000  3  20/05/2018 $             3,434.48 $     1,364.26 $            2,070.21 $            88,880.69
 i=  18% capitalizable  4  20/06/2018 $             3,434.48 $     1,333.21 $            2,101.27 $            86,779.42
 Mensualmente  5  20/07/2018 $             3,434.48 $     1,301.69 $            2,132.79 $            84,646.64

 T=  3 Años  6  20/08/2018 $             3,434.48 $     1,269.70 $            2,164.78 $            82,481.86
 n=  36  7  20/09/2018 $             3,434.48 $     1,237.23 $            2,197.25 $            80,284.61

 i=  0.015  8  20/10/2018 $             3,434.48 $     1,204.27 $            2,230.21 $            78,054.40
 A=  ?  9  20/11/2018 $             3,434.48 $     1,170.82 $            2,263.66 $            75,790.74

 10  20/12/2018 $             3,434.48 $     1,136.86 $            2,297.62 $            73,493.12
 11  20/01/2019 $             3,434.48 $     1,102.40 $            2,332.08 $            71,161.04

 A=  95000*0.015/1-(1+0.015)^-36  12  20/02/2019 $             3,434.48 $     1,067.42 $            2,367.06 $            68,793.98
 A=  1425  0.414910265  13  20/03/2019 $             3,434.48 $     1,031.91 $            2,402.57 $            66,391.41

 A=  3434.477576  14  20/04/2019 $             3,434.48 $        995.87 $            2,438.61 $            63,952.80
 15  20/05/2019 $             3,434.48 $        959.29 $            2,475.19 $            61,477.62

 16  20/06/2019 $             3,434.48 $        922.16 $            2,512.31 $            58,965.30
 17  20/07/2019 $             3,434.48 $        884.48 $            2,550.00 $            56,415.31

 18  20/08/2019 $             3,434.48 $        846.23 $            2,588.25 $            53,827.06
 19  20/09/2019 $             3,434.48 $        807.41 $            2,627.07 $            51,199.99

 20  20/10/2019 $             3,434.48 $        768.00 $            2,666.48 $            48,533.51
 21  20/11/2019 $             3,434.48 $        728.00 $            2,706.47 $            45,827.03

 22  20/12/2019 $             3,434.48 $        687.41 $            2,747.07 $            43,079.96
 23  20/01/2020 $             3,434.48 $        646.20 $            2,788.28 $            40,291.68

 24  20/02/2020 $             3,434.48 $        604.38 $            2,830.10 $            37,461.58
 25  20/03/2020 $             3,434.48 $        561.92 $            2,872.55 $            34,589.03

 26  20/04/2020 $             3,434.48 $        518.84 $            2,915.64 $            31,673.39
 27  20/05/2020 $             3,434.48 $        475.10 $            2,959.38 $            28,714.01

 28  20/06/2020 $             3,434.48 $        430.71 $            3,003.77 $            25,710.24
 29  20/07/2020 $             3,434.48 $        385.65 $            3,048.82 $            22,661.42

 30  20/08/2020 $             3,434.48 $        339.92 $            3,094.56 $            19,566.86
 31  20/09/2020 $             3,434.48 $        293.50 $            3,140.97 $            16,425.89

 32  20/10/2020 $             3,434.48 $        246.39 $            3,188.09 $            13,237.80
 33  20/11/2020 $             3,434.48 $        198.57 $            3,235.91 $            10,001.89
   19   20   21   22   23   24   25   26   27   28   29